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

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Michael MeskesDate: 2007-05-27 11:24:09
Subject: Re: buildfarm failures after pgstat patch
Previous:From: Tom LaneDate: 2007-05-27 05:45:45
Subject: Re: buildfarm failures after pgstat patch

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