ERRORDATA_STACK_SIZE exceeded - Mailing list pgsql-general

From Stefan Sassenberg
Subject ERRORDATA_STACK_SIZE exceeded
Date
Msg-id 4534BA80.6000606@gmx.de
Whole thread Raw
Responses Re: ERRORDATA_STACK_SIZE exceeded  (Markus Schiltknecht <markus@bluegap.ch>)
Re: ERRORDATA_STACK_SIZE exceeded  (Shane Ambler <pgsql@007Marketing.com>)
Re: ERRORDATA_STACK_SIZE exceeded  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello,

I've got a failing sql-Script that I execute with the psql command. The
Script contains:

----------------------------8<-----------------------------
SET CLIENT_ENCODING = 'LATIN1';

(Some other statements)

CREATE TABLE "public"."init_camera_type" (
   "id_camera_type" SMALLINT NOT NULL,
   "name" VARCHAR(75) NOT NULL,
   "is_video_camera" BOOLEAN DEFAULT false NOT NULL,
   "description" VARCHAR(75),
   PRIMARY KEY("id_camera_type")
) WITH OIDS;
----------------------------8<-----------------------------

where it bails out. The console output is:
----------------------------8<-----------------------------
PANIK:  ERRORDATA_STACK_SIZE exceeded
server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
----------------------------8<-----------------------------

The postgresql.log writes:
----------------------------8<-----------------------------
2006-10-17 13:04:03 CEST FEHLER:  22021: ungültige Byte-Sequenz für
Kodierung »UTF8«: 0xbb
2006-10-17 13:04:03 CEST ORT:  report_invalid_encoding, wchar.c:1328
2006-10-17 13:04:03 CEST ANWEISUNG:  CREATE TABLE
"public"."init_camera_type" (
           "id_camera_type" SMALLINT NOT NULL,
           "name" VARCHAR(75) NOT NULL,
           "is_video_camera" BOOLEAN DEFAULT false NOT NULL,
           "description" VARCHAR(75),
           PRIMARY KEY("id_camera_type")
         ) WITH OIDS;
2006-10-17 13:04:03 CEST FEHLER:  22021: ungültige Byte-Sequenz für
Kodierung »UTF8«: 0xfc6c74696765
2006-10-17 13:04:03 CEST ORT:  report_invalid_encoding, wchar.c:1328
2006-10-17 13:04:03 CEST ANWEISUNG:  CREATE TABLE
"public"."init_camera_type" (
           "id_camera_type" SMALLINT NOT NULL,
           "name" VARCHAR(75) NOT NULL,
           "is_video_camera" BOOLEAN DEFAULT false NOT NULL,
           "description" VARCHAR(75),
           PRIMARY KEY("id_camera_type")
         ) WITH OIDS;
2006-10-17 13:04:03 CEST FEHLER:  22021: ungültige Byte-Sequenz für
Kodierung »UTF8«: 0xfc6c74696765
2006-10-17 13:04:03 CEST ORT:  report_invalid_encoding, wchar.c:1328
2006-10-17 13:04:03 CEST ANWEISUNG:  CREATE TABLE
"public"."init_camera_type" (
           "id_camera_type" SMALLINT NOT NULL,
           "name" VARCHAR(75) NOT NULL,
           "is_video_camera" BOOLEAN DEFAULT false NOT NULL,
           "description" VARCHAR(75),
           PRIMARY KEY("id_camera_type")
         ) WITH OIDS;
2006-10-17 13:04:03 CEST FEHLER:  22021: ungültige Byte-Sequenz für
Kodierung »UTF8«: 0xfc6c74696765
2006-10-17 13:04:03 CEST ORT:  report_invalid_encoding, wchar.c:1328
2006-10-17 13:04:03 CEST ANWEISUNG:  CREATE TABLE
"public"."init_camera_type" (
           "id_camera_type" SMALLINT NOT NULL,
           "name" VARCHAR(75) NOT NULL,
           "is_video_camera" BOOLEAN DEFAULT false NOT NULL,
           "description" VARCHAR(75),
           PRIMARY KEY("id_camera_type")
         ) WITH OIDS;
2006-10-17 13:04:03 CEST PANIK:  XX000: ERRORDATA_STACK_SIZE exceeded
2006-10-17 13:04:03 CEST ORT:  errstart, elog.c:274
2006-10-17 13:04:03 CEST ANWEISUNG:  CREATE TABLE
"public"."init_camera_type" (
           "id_camera_type" SMALLINT NOT NULL,
           "name" VARCHAR(75) NOT NULL,
           "is_video_camera" BOOLEAN DEFAULT false NOT NULL,
           "description" VARCHAR(75),
           PRIMARY KEY("id_camera_type")
         ) WITH OIDS;
2006-10-17 13:04:03 CEST DEBUG:  00000: reaping dead processes
2006-10-17 13:04:03 CEST ORT:  reaper, postmaster.c:2021
2006-10-17 13:04:03 CEST DEBUG:  00000: Serverprozess (PID 32435) wurde
von Signal 6 beendet
2006-10-17 13:04:03 CEST ORT:  LogChildExit, postmaster.c:2428
----------------------------8<-----------------------------

I don't think there are invalid byte sequences in my script. In fact
there is no occurrence of 0xbb anywhere in the script.

The database that script is applied to is UTF8 encoded.
The postgresql version is 8.1.4.
My system is Linux pc01 2.6.17-gentoo-r8 #2 SMP Mon Oct 16 11:23:12 CEST
2006 i686 Intel(R) Pentium(R) 4 CPU 2.60GHz GNU/Linux

Is there someone who can explain what's going on here?

Regards

Stefan

pgsql-general by date:

Previous
From: "Obe, Regina"
Date:
Subject: Re: [NOVICE] How to split a table?
Next
From: Markus Schiltknecht
Date:
Subject: Re: ERRORDATA_STACK_SIZE exceeded