From: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Log: Untranslatable character: no DETAIL |
Date: | 2012-05-18 15:14:23 |
Message-ID: | CANPAkgsGrD9L4Suz24qdDz1twVeueE14VZBN9SdcqdifAQX4mQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
When logging long queries we get a DETAIL record with the query parameters,
like this:
2012-05-17 08:33:33 CDT [15053]: [1-1] user(at)database x.x.x.x(35559)LOG:
00000: duration: 587.476 ms execute dbdpg_p15947_158: select
a_bunch_of_stuff from table_b where id = $1 and ........
2012-05-17 08:33:33 CDT [15053]: [2-1] user(at)database x.x.x.x(35559)DETAIL:
parameters: $1 = '302241'
2012-05-17 08:33:33 CDT [15053]: [3-1]
user(at)databasex(dot)x(dot)x(dot)x(35559)LOCATION: exec_execute_message,
postgres.c:2023
but the untranslatable character error is not showing a DETAIL record:
2012-05-17 09:11:42 CDT [27225]: [1-1] user(at)database2 x.x.x.x(34225)ERROR:
22P05: character 0xe28093 of encoding "UTF8" has no equivalent in "LATIN1"
2012-05-17 09:11:42 CDT [27225]: [2-1]
user(at)database2x(dot)x(dot)x(dot)x(34225)LOCATION: report_untranslatable_char,
wchar.c:1643
2012-05-17 09:11:42 CDT [27225]: [3-1]
user(at)database2x(dot)x(dot)x(dot)x(34225)STATEMENT: select * from table_a where id
= $1
The query parameters would be helpful in tracking down the record that has
the bad data. Are there separate parameter settings for these, or are we
possibly missing something else? We have log_min_error_statement =
warning. This is 9.1.3 These are two separate databases running on the
same server (postgresql instance).
__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com
<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2012-05-18 15:41:04 | Re: How to check for server availability? [v9.3.1, Linux] |
Previous Message | Steve Crawford | 2012-05-18 15:07:36 | Re: How to write a script to analyze and vacuum all the tables in the system catalog?Thanks. |