ecpg test runs out of disk space

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ecpg test runs out of disk space
Date: 2007-05-27 08:18:36
Message-ID: 20070527081836.GG92628@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Just had a rather disturbing event happen on platypus..

buildfarm(at)fritz(dot)1[3: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...):
buildfarm(at)fritz(dot)1[3: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: buildfarm(at)ttyp3 (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:
buildfarm(at)fritz(dot)1[3: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 decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2007-05-27 11:24:09 Re: buildfarm failures after pgstat patch
Previous Message Tom Lane 2007-05-27 05:45:45 Re: buildfarm failures after pgstat patch