Hi List,
Included is some extra logging from postgresql which specifies what kind of
error occurs:
LOCATION: pg_parse_query, postgres.c:464
DEBUG: 00000: forked new backend, pid=24603 socket=8
LOCATION: BackendStartup, postmaster.c:2235
LOG: 00000: connection received: host=192.168.100.10 port=32988
LOCATION: BackendFork, postmaster.c:2395
LOG: 00000: connection authorized: user=postgres database=clienten2
LOCATION: BackendFork, postmaster.c:2457
LOG: 00000: statement: SET DATESTYLE TO 'ISO'
LOCATION: pg_parse_query, postgres.c:464
LOG: 00000: statement: INSERT INTO "public"."velden" ("tab_naam",
"tab_naam_kort", "ingangsdatum", "vervaldatum", "mutmed", "mutdat",
"vld_validatie_type", "vld_veldnaam", "vld_type", "vld_len", "vld_dec",
"vld_leegakkoord", "vld_soortinvoer", "default_waarde", "vld_classnaam")
VALUES ('Verwacht plaatsingspercentage', 'Plpct', '2000-01-01
00:00:00', NULL, 1695, '2004-11-15 13:52:49', NULL, 'con_plaatsingspct',
'int2', 0, 0, 'f', 0, '', NULL)
LOCATION: pg_parse_query, postgres.c:464
LOG: 00000: statement: SELECT last_value FROM "public"."tabellen_tab_id_seq"
LOCATION: pg_parse_query, postgres.c:464
LOG: 00000: statement: INSERT INTO "public"."schermen" ("scr_id", "tab_id",
"scr_order_display", "scr_langkort", "vervaldatum", "mutmed", "mutdat",
"kolom", "rij", "tabelnaam", "scr_verplicht")
VALUES ('contracten', 825, NULL, 't', NULL, 1695, '2004-11-15
13:52:49', NULL, NULL, NULL, 'f')
LOCATION: pg_parse_query, postgres.c:464
LOG: 00000: statement: BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
LOCATION: pg_parse_query, postgres.c:464
LOG: 00000: statement: ALTER TABLE contracten ADD COLUMN con_plaatsingspct
int2
LOCATION: pg_parse_query, postgres.c:464
LOG: 08P01: unexpected EOF on client connection
LOCATION: SocketBackend, postgres.c:281
LOG: 08P01: unexpected EOF on client connection
LOCATION: SocketBackend, postgres.c:281
LOG: 08P01: unexpected EOF on client connection
LOCATION: SocketBackend, postgres.c:281
LOG: 08P01: unexpected EOF on client connection
LOCATION: SocketBackend, postgres.c:281
LOG: 08P01: unexpected EOF on client connection
LOCATION: SocketBackend, postgres.c:281
I hope someone can help me in debugging this problem. Because we are supposed
to go live in the coming weeks, so I am getting desperate!
As you can see, the last query it receives is the 'ALTER TABLE' query, after
that, it stops responding.
> Hi list,
>
> I am using psycopg (1.1.15) with Python 2.3.3 and Postgresql 7.4 in a
> fairly big application. In that application I am (also) manipulating the
> database. (Alter table etc.) The coding is working properly, but sometimes
> the connection to the database breaks and the application hangs. I have
> experienced this on several machines. The weird thing is that after a break
> in my application pgAdmin3 is hanging also. This would indicate a problem
> in Postgresql, but I don't know. When I look in Postgresql.log I get the
> following message:
>
> LOG: unexpected EOF on client connection
>
> but it doesn't specify a time and date, so I THINK this indicates my
> problem, but I am not sure. (I do not see any other errors in the log)
>
> Does this indicate an error in psycopg? Or is there something else going
> on? How can I find out what is happening? (client crash, server problem?)
|
