The following bug has been logged online:
Bug reference: 3640
Logged by: Antonio Mari
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux xxxxxxxxx 2.6.17-gentoo-r7 #1 SMP Tue Aug 29
15:01:36 CEST 2006 i686 Intel(R) Xeon(TM) CPU 3.00GHz GenuineIntel GNU/Linux
Description: PANIC: ERRORDATA_STACK_SIZE exceeded
Details:
Hi,
First I'm going to put my configuration
[EMAIL PROTECTED]::~# pg_config
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/libpq-8.2.4/postgresql
INCLUDEDIR = /usr/include/postgresql/libpq-4
PKGINCLUDEDIR = /usr/include/postgresql/libpq-4
INCLUDEDIR-SERVER = /usr/include/postgresql/libpq-4/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/man
SHAREDIR = /usr/share/postgresql
SYSCONFDIR = /etc/postgresql
PGXS = /usr/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr' '--includedir=/usr/include/postgresql/libpq-4'
'--sysconfdir=/etc/postgresql' '--mandir=/usr/share/man'
'--host=i686-pc-linux-gnu' '--with-docdir=/usr/share/doc/libpq-8.2.4'
'--libdir=/usr/lib' '--enable-depend' '--without-krb5' '--enable-nls'
'--with-pam' '--without-perl' '--disable-integer-datetimes'
'--without-python' '--with-readline' '--with-openssl' '--without-tcl'
'--disable-thread-safety' '--with-zlib' 'CFLAGS=-O2 -march=i686 -pipe'
'CPPFLAGS=' 'host_alias=i686-pc-linux-gnu'
CC = i686-pc-linux-gnu-gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -march=i686 -pipe -Wall -Wmissing-prototypes -Wpointer-arith
-Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-rpath,'/usr/lib'
LDFLAGS_SL =
LIBS = -lpgport -lpam -lssl -lcrypto -lz -lreadline -lcrypt -ldl -lm
VERSION = PostgreSQL 8.2.4
The control data infomation are:
[EMAIL PROTECTED]::~# LC_ALL=C pg_controldata /home/pg/data/
pg_control version number: 822
Catalog version number: 200611241
Database system identifier: 5024274278997028863
Database cluster state: in production
pg_control last modified: Fri Sep 28 14:23:57 2007
Current log file ID: 9
Next log file segment: 241
Latest checkpoint location: 9/F009E610
Prior checkpoint location: 9/F0079740
Latest checkpoint's REDO location: 9/F009E610
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's TimeLineID: 1
Latest checkpoint's NextXID: 0/163813137
Latest checkpoint's NextOID: 75565308
Latest checkpoint's NextMultiXactId: 4
Latest checkpoint's NextMultiOffset: 7
Time of latest checkpoint: Fri Sep 28 14:23:57 2007
Minimum recovery ending location: 0/0
Maximum data alignment: 4
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Date/time type storage: floating-point numbers
Maximum length of locale name: 128
LC_COLLATE: [EMAIL PROTECTED]
LC_CTYPE: [EMAIL PROTECTED]
As you see the initdb was initialized with [EMAIL PROTECTED] locale (LATIN9).
When connecting via psql to a database encoded in UTF8 and client_encoding
is LATIN9 (or LATIN1) and try a wrong query I've the PANIC error.
PANIC: ERRORDATA_STACK_SIZE exceeded
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
La conexión al servidor se ha perdido. Intentando reiniciar: falló.
The sequence is:
[EMAIL PROTECTED]::~$ createdb -E UTF8 testutf
CREATE DATABASE
[EMAIL PROTECTED]::~$ psql testutf
testutf=# SELECT kk;
ERROR: no existe la columna «kk»
LINE 1: SELECT kk;
testutf=# SET client_encoding TO LATIN9;
testutf=# SELECT kk;
PANIC: ERRORDATA_STACK_SIZE exceeded
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
I've tried in 2 differents installations.
P.D. Sorry for my poor english.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
