v6.4.2 backend crashing on certain sql stmts - Mailing list pgsql-admin
From | gjerde@icebox.org |
---|---|
Subject | v6.4.2 backend crashing on certain sql stmts |
Date | |
Msg-id | Pine.LNX.4.05.9901200327460.1855-100000@snowman.icebox.org Whole thread Raw |
Responses |
Re: [ADMIN] v6.4.2 backend crashing on certain sql stmts
|
List | pgsql-admin |
Hi, I've been running v6.4.2 for a while, and it's been running great. Recently I destroyed my database and recreated them(i wanted to change some fields). This is on Linux 2.0.35 i386. Now I get this error, but only on certain statements: pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. My tables: Database = customers +------------------+----------------------------------+----------+ | Owner | Relation | Type | +------------------+----------------------------------+----------+ | postgres | currentuser | table | | postgres | currentuser_id_seq | sequence | | postgres | currentuser_pkey | index | | postgres | memberaccess | table | | postgres | memberaccess_id_seq | sequence | | postgres | memberaccess_pkey | index | | postgres | members | table | | postgres | members_pkey | index | +------------------+----------------------------------+----------+ This is a normal query: customers=> select * from memberaccess; id|memberid|access --+--------+----------- 1| 1|parts 2| 1|mcrd [snip - normal info] Another normal query: customers=> select * from members; [snip - normal info] This is the query that breaks: SELECT memberaccess.access FROM memberaccess WHERE memberaccess.MemberID = members.ID AND members.username LIKE 'gjerde'; This last query will give the error message on top. The sql statements to create my tables are below. Thanks, Ole Gjerde System Administrator Avsupport Inc. CREATE TABLE members ( ID int4 PRIMARY KEY, username varchar(64) NOT NULL, password varchar(64) NOT NULL, companyname varchar(128), contact varchar(64), phone varchar(32), fax varchar(32), email varchar(64), contactby varchar(16), datecreated int8 NOT NULL, status varchar(32), demodaysleft int4, lastlogintime int8, concurrentusers int4, searchnum int8, rfqnum int8, loginnum int8 ); CREATE TABLE memberaccess ( ID serial PRIMARY KEY, memberid int8 NOT NULL, access varchar(32) NOT NULL );
pgsql-admin by date: