Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA27850; Wed, 2 Jun 93 00:48:23 -0700 Date: Wed, 2 Jun 93 00:48:23 -0700 From: "David J. Hughes" Subject: Help!!! Backend core dump To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu To: postgres@postgres.Berkeley.EDU Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I am currently seeing the Postgres 4.1 backend dumping core as a result of the most simple query in my entire application :- retrieve (M_USER_INFO.xdisplay) The last things I see from the backend are :- Error: Unexpected response from the backend, exiting... Error: Unexpected identfier in dump_data: I I have also seen Error: Unexpected identfier in dump_data: P with the same result (ie. a core dump) This happens on the same query but not every time. Sometimes, this piece of code may be executed properly from anywhere between 3 and 5 times. Othertimes it'll dump on the first execution. I have included a stack trace below. Any help on this, or even just an idea of what the errors may imply, would be greatly appreciated. [ on a side note, my code fires off hundreds of queries without problems. I can't see why this is causing problems ] Environment :- Postgres 4.1 via libpq Sparc SunOS 4.1.1 ___ David J. Hughes bambi@Bond.edu.au / \ / / / / __/ __ __ ____/ / / __ Senior Network Programmer / \ / \ / \ / / / / / \ / Comms Development & Operation \____/ \__// / \__/ \___/ / / / Qld. 4229 AUSTRALIA (+61 75 951450) _exit() at 0xf75c3670 ExcRaise() at 0x63548 dump_data() at 0x63f74 process_portal() at 0x5e574 PQexec() at 0x5f3ac MdbCreateValueList(rel = 0x71511 "M_USER_INFO", field = 0x7151d "xdisplay", condition = (nil), sort = 0), line 165 in "db/db_int.c" reportIt(class = 1, event = 5, message = 0x8df38 "IP Service ftp on fiddich went down at 17:27:10 06/02/93 "), line 465 in "alert.c" processEvent(sd = 5), line 971 in "reporter.c" main(argc = 1, argv = 0xf7fffe3c), line 1092 in "reporter.c"