Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work

Поиск
Список
Период
Сортировка
Искать
От
Nathan Bossart
Тема
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work
Дата
Msg-id
20220823180744.GD1207981@nathanxps13
Ответ на
Список
Дерево обсуждения
Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Julien Rouhaud <rjuju123@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Thomas Munro <thomas.munro@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier <michael@paquier.xyz>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier <michael@paquier.xyz>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier <michael@paquier.xyz>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier <michael@paquier.xyz>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart <nathandbossart@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Andres Freund <andres@anarazel.de>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Tom Lane <tgl@sss.pgh.pa.us>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work "Bossart, Nathan" <bossartn@amazon.com>
On Wed, Aug 17, 2022 at 12:39:26PM +0530, Bharath Rupireddy wrote:
> +	/*
> +	 * We're only handling directories here, skip if it's not ours. Also, skip
> +	 * if the caller has already performed this check.
> +	 */
> +	if (!slot_dir_checked &&
> +		lstat(path, &statbuf) == 0 && !S_ISDIR(statbuf.st_mode))
>  		return;

There was previous discussion about removing this stanza from
ReorderBufferCleanupSeralizedTXNs() completely [0].  If that is still
possible, I think I would choose that over having callers specify whether
to do the directory check.

> +		/* we're only handling directories here, skip if it's not one */
> +		sprintf(path, "pg_replslot/%s", logical_de->d_name);
> +		if (get_dirent_type(path, logical_de, false, LOG) != PGFILETYPE_DIR)
> +			continue;

IIUC an error in get_dirent_type() could cause slots to be skipped here,
which is a behavior change.

[0] https://postgr.es/m/20220329224832.GA560657%40nathanxps13

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Alvaro Herrera
Дата:
FAQ