Re: Cluster::restart dumping logs when stop fails

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Cluster::restart dumping logs when stop fails
Дата
Msg-id 20240407004913.bzalra7ycxptdeej@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Cluster::restart dumping logs when stop fails  (Daniel Gustafsson <daniel@yesql.se>)
Ответы Re: Cluster::restart dumping logs when stop fails  (Daniel Gustafsson <daniel@yesql.se>)
Re: Cluster::restart dumping logs when stop fails  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Hi,

On 2024-04-07 00:19:35 +0200, Daniel Gustafsson wrote:
> > On 6 Apr 2024, at 23:44, Andres Freund <andres@anarazel.de> wrote:
> 
> > It might be useful to print a few lines, but the whole log files can be
> > several megabytes worth of output.
> 
> The non-context aware fix would be to just print the last 1024 (or something)
> bytes from the logfile:

That'd be better, yes. I'd mainly log the path to the logfile though, that's
probably at least as helpful for actually investigating the issue?

> diff --git a/src/test/perl/PostgreSQL/Test/Cluster.pm b/src/test/perl/PostgreSQL/Test/Cluster.pm
> index 54e1008ae5..53d4751ffc 100644
> --- a/src/test/perl/PostgreSQL/Test/Cluster.pm
> +++ b/src/test/perl/PostgreSQL/Test/Cluster.pm
> @@ -951,8 +951,8 @@ sub start
>  
>      if ($ret != 0)
>      {
> -        print "# pg_ctl start failed; logfile:\n";
> -        print PostgreSQL::Test::Utils::slurp_file($self->logfile);
> +        print "# pg_ctl start failed; logfile excerpt:\n";
> +        print substr PostgreSQL::Test::Utils::slurp_file($self->logfile), -1024;
>  
>          # pg_ctl could have timed out, so check to see if there's a pid file;
>          # otherwise our END block will fail to shut down the new postmaster.

That's probably unnecessary optimization, but it seems a tad silly to read an
entire, potentially sizable, file to just use the last 1k. Not sure if the way
slurp_file() uses seek supports negative ofsets, the docs read to me like that
may only be supported with SEEK_END.

Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Matthias van de Meent
Дата:
Сообщение: Re: Add bump memory context type and use it for tuplesorts
Следующее
От: Tom Lane
Дата:
Сообщение: Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs