Problem with invalid byte sequence and log_min_error_statement

Поиск
Список
Период
Сортировка
От Janning Vygen
Тема Problem with invalid byte sequence and log_min_error_statement
Дата
Msg-id 200904151731.45893.vygen@kicktipp.de
обсуждение исходный текст
Ответы Re: Problem with invalid byte sequence and log_min_error_statement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

i run the greatest database ever, postgresql-8.3, on debian etch

I am investigating some error messages in my log file:

Apr 15 08:04:34 postgres[20686]: [4-1] 2009-04-15 08:04:34 CEST ERROR:
invalid byte sequence for encoding "UTF8": 0x81
Apr 15 08:04:34 postgres[20686]: [4-2] 2009-04-15 08:04:34 CEST HINT:  This
error can also happen if the byte sequence does not match the encoding
expected by the
Apr 15 08:04:34 postgres[20686]: [4-3]  server, which is controlled by
"client_encoding".

I want to know which statement produces this error. I have

show log_min_error_statement ;
 error

show log_error_verbosity;
 default

so i think the error statement should be logged. Why is the error statement
not logged? Or do i need to set  log_error_verbosity to verbose to see the
statement producing the error?

I always see 0x81 and 0xe46973 as invalid byte sequence. Can someone give me a
hint what characters in which encoding those bytes might be?

kind regards
Janning





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

Предыдущее
От: sub_woofer
Дата:
Сообщение: Trigger error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance of full outer join in 8.3