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
USERPID %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 Ss3: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: 0
[NO_PID]: ECPGconnect: opening database regress1 on port
[NO_PID]: sqlca: code: 0, state: 0
[NO_PID]: ECPGexecute line 46: QUERY: set datestyle to iso on connection
regress1
[NO_PID]: sqlca: code: 0, state: 0
[NO_PID]: ECPGexecute line 46 Ok: SET
[NO_PID]: sqlca: code: 0, state: 0
[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: 0
[NO_PID]: ECPGexecute line 49 Ok: CREATE TABLE
[NO_PID]: sqlca: code: 0, state: 0
[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: 0
[NO_PID]: terminating connection because of crash of another server
process[NO_PID]: sqlca: code: 0, state: 0
[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: 0
[NO_PID]: ECPGexecute line 53: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 0
[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: 0
[NO_PID]: ECPGexecute line 54: error: no connection to the server
[NO_PID]: sqlca: code: 0, state: 0
[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: c
