Just had a rather disturbing event happen on platypus.. [EMAIL PROTECTED]:07]~/buildfarm/HEAD/pgsql.39276/src/interfaces/ecpg/test/results:271>ll preproc-variable.* -rw-r--r-- 1 buildfarm decibel 6328 May 26 23:42 preproc-variable.c -rw-r--r-- 1 buildfarm decibel 76460670919 May 27 02:18 preproc-variable.stderr -rw-r--r-- 1 buildfarm decibel 14668726272 May 27 03:07 preproc-variable.stdout
The processes that were running (I'd already killed 39276 without thinking...):
[EMAIL
PROTECTED]:11]~/buildfarm/HEAD/pgsql.39276/src/interfaces/ecpg/test/results:282>ps
auxww
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
buildfarm 65843 94.5 0.1 20848 3056 ?? RN 11:42PM 204:15.00
preproc/variable
buildfarm 61647 0.0 0.0 5776 1012 ?? IN 11:42PM 0:00.01 gmake -j4
NO_LOCALE=1 check
buildfarm 61654 0.0 0.0 5784 1032 ?? IN 11:42PM 0:00.01 gmake -C test
check
buildfarm 61876 0.0 0.0 5224 1624 ?? IN 11:42PM 0:00.09 sh
./pg_regress --dbname=regress1 --temp-install --top-builddir=../../../..
--temp-port=55678 --multibyte=SQL_ASCII --load-language=plpgsql --no-locale
buildfarm 65430 0.0 0.1 54168 4656 ?? IN 11:42PM 0:00.21 [postgres]
buildfarm 65846 0.0 0.1 54232 3720 ?? SNs 11:42PM 0:01.55 postmaster:
writer process (postgres)
buildfarm 65847 0.0 0.1 17884 3244 ?? SNs 11:42PM 0:00.11 postmaster:
stats collector process (postgres)
buildfarm 65848 0.0 0.1 54452 3508 ?? INs 11:42PM 0:00.05 postmaster:
autovacuum launcher process (postgres)
buildfarm 69673 0.0 0.1 30584 3676 ?? S 3:03AM 0:00.07 sshd: [EMAIL
PROTECTED] (sshd)
buildfarm 69674 0.0 0.1 9452 3284 p3 Ss 3:03AM 0:00.07 -tcsh (tcsh)
buildfarm 69886 0.0 0.0 4740 1040 p3 R+ 3:11AM 0:00.00 ps auxww
preproc-variable.stdout contains the following line, over and over:
?, born 140737488349640, age = -5704, married (null), children = 4196007
Here's the interesting bits from .stderr:
[EMAIL
PROTECTED]:10]~/buildfarm/HEAD/pgsql.39276/src/interfaces/ecpg/test/results:277>head
-n 100 preproc-variable.stderr
[NO_PID]: ECPGdebug: set to 1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGconnect: opening database regress1 on <DEFAULT> port <DEFAULT>
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 46: QUERY: set datestyle to iso on connection
regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 46 Ok: SET
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 49: QUERY: create table family ( name char ( 8 )
, born integer , age smallint , married date , children integer )
on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 49 Ok: CREATE TABLE
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 52: QUERY: insert into family ( name , married ,
children ) values ( 'Mum' , '19870714' , 3 ) on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: terminating connection because of crash of another server
process[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlcode 0
[NO_PID]: sqlca: code: 0, state: 57P02
[NO_PID]: ECPGexecute line 52: error: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
[NO_PID]: sqlca: code: 0, state: 57P02
[NO_PID]: raising sqlstate YE000 (sqlcode: -400) in line 52, ''server closed
the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
' in line 5'.
[NO_PID]: sqlca: code: -400, state: YE000
sql error 'server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
' in line 5
[NO_PID]: ECPGexecute line 53: QUERY: insert into family ( name , born ,
married , children ) values ( 'Dad' , '19610721' , '19870714' , 3 ) on
connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 53: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlstate YE000 (sqlcode: -400) in line 53, ''no connection to
the server
' in line 53.'.
[NO_PID]: sqlca: code: -400, state: YE000
sql error 'no connection to the server
' in line 53.
[NO_PID]: ECPGexecute line 54: QUERY: insert into family ( name , age )
values ( 'Child 1' , 16 ) on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 54: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlstate YE000 (sqlcode: -400) in line 54, ''no connection to
the server
' in line 54.'.
[NO_PID]: sqlca: code: -400, state: YE000
sql error 'no connection to the server
' in line 54.
[NO_PID]: ECPGexecute line 55: QUERY: insert into family ( name , age )
values ( 'Child 2' , 14 ) on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 55: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlstate YE000 (sqlcode: -400) in line 55, ''no connection to
the server
' in line 55.'.
[NO_PID]: sqlca: code: -400, state: YE000
sql error 'no connection to the server
' in line 55.
[NO_PID]: ECPGexecute line 56: QUERY: insert into family ( name , age )
values ( 'Child 3' , 9 ) on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 56: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlstate YE000 (sqlcode: -400) in line 56, ''no connection to
the server
' in line 56.'.
[NO_PID]: sqlca: code: -400, state: YE000
sql error 'no connection to the server
' in line 56.
[NO_PID]: ECPGtrans line 59 action = commit connection = regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlcode -401 in line 59, 'Error in transaction processing in
line 59.'.
[NO_PID]: sqlca: code: -401, state: 08007
sql error Error in transaction processing in line 59.
[NO_PID]: ECPGexecute line 62: QUERY: declare cur cursor for select name ,
born , age , married , children from family on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 62: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlstate YE000 (sqlcode: -400) in line 62, ''no connection to
the server
' in line 62.'.
[NO_PID]: sqlca: code: -400, state: YE000
sql error 'no connection to the server
' in line 62.
[NO_PID]: ECPGexecute line 71: QUERY: fetch cur on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 71: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlstate YE000 (sqlcode: -400) in line 71, ''no connection to
the server
' in line 71.'.
[NO_PID]: sqlca: code: -400, state: YE000
sql error 'no connection to the server
' in line 71.
[NO_PID]: ECPGexecute line 71: QUERY: fetch cur on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGexecute line 71: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: raising sqlstate YE000 (sqlcode: -400) in line 71, ''no connection to
the server
' in line 71.'.
[NO_PID]: sqlca: code: -400, state: YE000
sql error 'no connection to the server
' in line 71.
[NO_PID]: ECPGexecute line 71: QUERY: fetch cur on connection regress1
[NO_PID]: sqlca: code: 0, state: 00000
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgplCh1YFL3XX.pgp
Description: PGP signature
