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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
