Problem with invalid byte sequence and log_min_error_statement

From: Janning Vygen <vygen(at)kicktipp(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with invalid byte sequence and log_min_error_statement
Date: 2009-04-15 15:31:45
Message-ID: 200904151731.45893.vygen@kicktipp.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-04-15 15:33:01 Re: Performance of full outer join in 8.3
Previous Message Albe Laurenz 2009-04-15 15:15:43 Re: need information