Re: pgbench logging broken by time logic changes

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: pgbench logging broken by time logic changes
Дата
Msg-id
alpine.DEB.2.22.394.2106240815480.1687456@pseudo
Ответ на
Список
Дерево обсуждения
pgbench logging broken by time logic changes Gregory Smith <gregsmithpgsql@gmail.com>
Re: pgbench logging broken by time logic changes Yugo NAGATA <nagata@sraoss.co.jp>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Yugo NAGATA <nagata@sraoss.co.jp>
Re: pgbench logging broken by time logic changes Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: pgbench logging broken by time logic changes Yugo NAGATA <nagata@sraoss.co.jp>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Hannu Krosing <hannuk@google.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Gregory Smith <gregsmithpgsql@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Andrew Dunstan <andrew@dunslane.net>
Re: pgbench logging broken by time logic changes Noah Misch <noah@leadboat.com>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Andrew Dunstan <andrew@dunslane.net>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Andrew Dunstan <andrew@dunslane.net>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Andrew Dunstan <andrew@dunslane.net>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Thomas Munro <thomas.munro@gmail.com>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Daniel Gustafsson <daniel@yesql.se>
Re: pgbench logging broken by time logic changes Daniel Gustafsson <daniel@yesql.se>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Michael Paquier <michael@paquier.xyz>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench logging broken by time logic changes Yugo NAGATA <nagata@sraoss.co.jp>
Re: pgbench logging broken by time logic changes Fabien COELHO <coelho@cri.ensmp.fr>

Bonjour Michaël,

> Using grep() with "$re" results in all the fields matching.  Using on
> the contrary "/$re/" in grep(), like list_files(), would only match
> the first one, which is correct.

Ok, good catch. Perl is kind of a strange language.

> With this issue fixed, I have bumped into what looks like a different 
> bug in the tests.  001_pgbench_log_2 uses pgbench with 2 clients, but> 
> expects only patterns in the logs where the first column value uses only 
> 0.  With two clients, those first values can be either 0 or 1 due to the 
> client ID set.

Indeed. The tests passes because the number of expected lines is quite

> It seems to me that we had better fix this issue and back-patch where
> this has been introduced so as we have exact match checks with the log
> formarts, no?  Please see the attached.

Ok, however the regex should be "^[01] ...".

Attached v11 with your fixes + the above regex fix.

-- 
Fabien.
В списке pgsql-hackers по дате отправления
От: tanghy.fnst@fujitsu.com
Дата:
От: Peter Eisentraut
Дата:
FAQ