Skip site navigation (1) Skip section navigation (2)

WG: [GENERAL] reproducible database crash with simple sql command on postgres 8.3.1

From: <Christian(dot)Strobl(at)dlr(dot)de>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: WG: [GENERAL] reproducible database crash with simple sql command on postgres 8.3.1
Date: 2008-05-17 20:05:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-general
regards christian

Please forward this info to pgsql-bugs.  I don't have a Windows machine
so I can't look into it myself.

                        regards, tom lane


Von: Strobl, Christian
Gesendet: Fr 16.05.2008 17:42
An: Tom Lane
Betreff: AW: [GENERAL] reproducible database crash with simple sql command on postgres 8.3.1 

hi tom,
please excuse my delayed answer, but i wasn't in the office and i undertook some additional testing
1) postgres=# show lc_messages;
 English_United States
(1 Zeile)

formerly it was German_Germany. but also if i change to English_United States with 
set lc_messages = 'English_United States'
there is no change in the language of the messages, also after a complete deinstallation-installation-process with english as default the language in the shell (dosbox and powershell) is still german. for me this seems very strange.
2) postgres=# show lc_ctype;
 English_United States.1252
(1 Zeile)
3) postgres=# show server_encoding;
(1 Zeile)
4a) postgres=# show client_encoding;
(1 Zeile)
now to the really strange behaviour: with win 1252 (or latin 1) i can use german special characters for example in insert-statements (i changed  in the shell also the codepage to windows 1252 with chcp 1252)
create table test (name varchar);
insert into test (name) values ('äöü');
select * from test;

(3 Zeilen)
as far as good. but if i make some mistake with psql for example 
i get the follwing message
postgres=# x;
Server beendete die Verbindung unerwartet
        Das heißt wahrscheinlich, daß der Server abnormal beendete
        bevor oder während die Anweisung bearbeitet wurde.
Die Verbindung zum Server wurde verloren.  Versuche Reset: Fehlgeschlagen.
the worst is that also the is now down and has to be restarted
4b) postgres=# show client_encoding;
(1 Zeile)
now its not possible to insert german special characters with sql-statements
the follwing statement 
insert into test (name) values ('äöü');
gives the follwing error message
postgres=# insert into test (name) values ('äöü');
FEHLER:  ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe4f6fc
TIP:  Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server
erwartet, welche durch »client_encoding« bestimmt wird.
but wrong statements are correctly processed  by psql
postgres=# x;
FEHLER:  Syntaxfehler bei »x«
ZEILE 1: x;
thats the things i collected with this problem
thanks and greetings from munich
p.s. i don't know if you can see the german special characters at your email client. these are the letters for ae, oe and ue
p.p.s. without a exact explanation my impression is that the wole thing is working better with pgadmin III but also not without some problems
p.p.p.s if you are interested i can also send you some log-files but for example the install log file is quite large (> 4MB)


Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Gesendet: Fr 09.05.2008 16:18
An: Strobl, Christian
Cc: pgsql-general(at)postgresql(dot)org
Betreff: Re: [GENERAL] reproducible database crash with simple sql command on postgres 8.3.1 

<Christian(dot)Strobl(at)dlr(dot)de> writes:

> the rest of the message is unfortunately in german then i have to
> restart the postgres-service manually this error is very easy
> reproducible at my environment

What this typically means is that you've got an encoding/locale
configuration problem.  The thing is trying to report some error
or other, and it discovers that the error text is badly encoded
according to the current database encoding, and it tries to
report that, only *that* error text is badly encoded too, so
it tries to report that, getting another error, etc, until the
error recovery stack overflows.

The hope of getting rid of this scenario is one reason why we locked
down encoding/locale combinations in 8.3, so I'm disappointed that
you're still able to make it happen.  You didn't say what settings
you are using though.  Could we see

        show lc_messages;
        show lc_ctype;
        show server_encoding;
        show client_encoding;

                        regards, tom lane

In response to

pgsql-bugs by date

Next:From: bishopDate: 2008-05-17 22:24:22
Subject: BUG #4180: PANIC while PQExec on Client with differen locale from database
Previous:From: Jaime CasanovaDate: 2008-05-17 18:52:22
Subject: Re: [DOCS] wal_sync_method

pgsql-general by date

Next:From: Ioannis TambourasDate: 2008-05-17 23:07:21
Subject: Re: pg_standby stuck on a wal file size <16MB
Previous:From: Gurjeet SinghDate: 2008-05-17 19:07:07
Subject: Re: pg_standby stuck on a wal file size <16MB

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group