Re: "Garbled" postgres logs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "Garbled" postgres logs
Дата
Msg-id 12421.1175633493@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "Garbled" postgres logs  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: "Garbled" postgres logs  (tgoodair@ca.afilias.info (Tim Goodaire))
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> Note to hackers: would it make sense to use write() instead of
>> fprintf() in send_message_to_server_log to avoid any possibility
>> of stdio deciding to fragment the message?  Possibly there'd be
>> some marginal efficiency gain too.

> What about in write_syslogger_file_binary()? Since redirect_stderr is 
> set true in the case reported, wont that be what does the writing?

No, syslogger is single-threaded so it can't be at fault.  The
interleaving must be happening when the data is inserted into the pipe
that leads to syslogger.  We've got multiple backends concurrently
writing that pipe, remember.

BTW, although I'm blaming stdio here, it's conceivable that it is
issuing messages in a single write() and the kernel is failing to keep
the writes atomic, as I think is required by spec if the write is for
less than PIPEBUF bytes.  So Tim might want to compare exact kernel
versions as well as exact libc versions between the misbehaving machine
and the others.
        regards, tom lane


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

Предыдущее
От: Brad Nicholson
Дата:
Сообщение: Re: "Garbled" postgres logs
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Oracle indemnifies PostgreSQL on its patents