v6.4.2 backend crashing on certain sql stmts
От | gjerde@icebox.org |
---|---|
Тема | v6.4.2 backend crashing on certain sql stmts |
Дата | |
Msg-id | Pine.LNX.4.05.9901200327460.1855-100000@snowman.icebox.org обсуждение исходный текст |
Ответы |
Re: [ADMIN] v6.4.2 backend crashing on certain sql stmts
(Herouth Maoz <herouth@oumail.openu.ac.il>)
|
Список | 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 по дате отправления:
Следующее
От: Herouth MaozДата:
Сообщение: Re: [ADMIN] v6.4.2 backend crashing on certain sql stmts