The following bug has been logged online:

Bug reference:      4680
Logged by:          Denis Afonin
Email address:      v...@itkm.ru
PostgreSQL version: 8.3.6
Operating system:   Linux Debian Lenny
Description:        Server crashed if using wrong (mismatch) conversion
functions
Details: 

I do:

=cut=
postg...@sunset:~$ createdb test -E KOI8
postg...@sunset:~$ psql test
Welcome to psql 8.3.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

test=# SHOW server_version;
 server_version 
----------------
 8.3.6
(1 row)

test=# CREATE DEFAULT CONVERSION test1 FOR 'LATIN1' TO 'KOI8' FROM
ascii_to_mic;
CREATE CONVERSION
test=# CREATE DEFAULT CONVERSION test2 FOR 'KOI8' TO 'LATIN1' FROM
mic_to_ascii;
CREATE CONVERSION
test=# set client_encoding to 'LATIN1';
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
Соединение с сервером было потеряно.
Попытка переустановить: Безуспешно.
!> \q
=end cut=


In Logs:
=cut=
2009-02-27 10:29:40 UTC LOG:  database system was shut down at 2009-02-27
10:29:38 UTC
2009-02-27 10:29:40 UTC LOG:  autovacuum launcher started
2009-02-27 10:29:40 UTC LOG:  database system is ready to accept
connections
2009-02-27 10:29:50 UTC ERROR:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC STATEMENT:  set client_encoding to 'LATIN1';
2009-02-27 10:29:50 UTC ERROR:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC STATEMENT:  set client_encoding to 'LATIN1';
2009-02-27 10:29:50 UTC ERROR:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC ERROR:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC ERROR:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  ERRORDATA_STACK_SIZE exceeded
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  ERRORDATA_STACK_SIZE exceeded
<<<<many-many-many-of-above-lines-skipped>>>>>
2009-02-27 10:29:50 UTC PANIC:  ERRORDATA_STACK_SIZE exceeded
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  ERRORDATA_STACK_SIZE exceeded
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC PANIC:  expected source encoding "MULE_INTERNAL",
but got "KOI8"
2009-02-27 10:29:50 UTC LOG:  server process (PID 4958) was terminated by
signal 11: Segmentation fault
2009-02-27 10:29:50 UTC LOG:  terminating any other active server processes
2009-02-27 10:29:50 UTC LOG:  all server processes terminated;
reinitializing
2009-02-27 10:29:50 UTC LOG:  database system was interrupted; last known up
at 2009-02-27 10:29:40 UTC
2009-02-27 10:29:50 UTC LOG:  database system was not properly shut down;
automatic recovery in progress
=end cut=

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to