Skip site navigation (1) Skip section navigation (2)

inner query bug

From: Andrew Holm-Hansen <andrew(at)einer(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: inner query bug
Date: 2003-11-21 22:39:50
Message-ID: 1069454390.17793.2.camel@gecko.paycheckadv.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I was advised to send an e-mail after a discussion with neilc on
#postgresql.

The failure occurs randomly, never on the first time (at least that I've
seen) and usually only after doing a bunch of other stuff first (big
joins, views, etc). In one case, the backend terminated and restarted,
this has only happened once.

P4 w/1024 GB ram.  RH9
uname -a
Linux gecko.paycheckadv.com 2.6.0-0.test9.1.90 #1 Tue Nov 18 09:34:47
EST 2003 i686 i686 i386 GNU/Linux
                                                                                                                                            
psql output follows:

SC2test7=# select * from txstatus,tx txx where txstatus.txid = txx.txid
AND txstatus.statuschangetime = (select max(txstatus.statuschangetime)
from txstatus where txstatus.txid = txx.txid); FATAL:  terminating
connection due to administrator command
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
SC2test7=# \d txstatus
no connection to the server
The connection to the server was lost. Attempting reset: Succeeded.
SC2test7=# \d txstatus
                                            Table "public.txstatus"
      Column      |           Type          
|                            Modifiers
------------------+--------------------------+------------------------------------------------------------------
 txstatusid       | integer                  | not null default
nextval('public.txstatus_txstatusid_seq'::text)
 statusid         | integer                  | not null
 txid             | integer                  | not null
 statuschangetime | timestamp with time zone | not null
 employeeid       | integer                  | not null
Indexes: pk_txstatus_txstatusid primary key btree (txstatusid),
         idx_txstatus_statuschangetime btree (statuschangetime)
Foreign Key constraints: fk_txstatus_statusid FOREIGN KEY (statusid)
REFERENCES status(statusid),
                         fk_txstatus_txid FOREIGN KEY (txid) REFERENCES
tx(txid),
                         fk_txstatus_employeeid FOREIGN KEY (employeeid)
REFERENCES employee(employeeid)
                                                                                                                                            
SC2test7=# \d tx
                                          Table "public.tx"
      Column       |           Type           |                     
Modifiers
-------------------+--------------------------+------------------------------------------------------
 txid              | integer                  | not null default
nextval('public.tx_txid_seq'::text)
 txtypeid          | integer                  | not null
 statusid          | integer                  | not null
 amount            | numeric(6,2)             | not null
 servicecharge     | numeric(6,2)             | not null
 customeraccountid | integer                  |
 checksid          | integer                  |
 rent              | numeric(6,2)             |
 scheduledpayments | integer                  |
 txtimestamp       | timestamp with time zone | not null
Indexes: pk_tx_txid primary key btree (txid),
         idx_tx_statusid btree (statusid),
         idx_tx_txtypeid btree (txtypeid)
Foreign Key constraints: fk_tx_txtypeid FOREIGN KEY (txtypeid)
REFERENCES txtype(txtypeid),
                         fk_tx_statusid FOREIGN KEY (statusid)
REFERENCES status(statusid),
                         fk_tx_customeraccountid FOREIGN KEY
(customeraccountid) REFERENCES customeraccount(customeraccountid),
                         fk_tx_checksid FOREIGN KEY (checksid)
REFERENCES checks(checksid)
                                                                                                                                                                                                      
select * from txstatus,tx txx where txstatus.txid = txx.txid AND
txstatus.statuschangetime = (select max(txstatus.statuschangetime) from
txstatus where txstatus.txid = txx.txid);
ERROR:  variable not found in subplan target list


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2003-11-21 22:56:20
Subject: Re: PERFORM bug with FOUND?
Previous:From: David FetterDate: 2003-11-21 22:02:34
Subject: PERFORM bug with FOUND?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group