postmaster dies on EOF?

From: "Denis A(dot) Doroshenko" <d(dot)doroshenko(at)omnitel(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postmaster dies on EOF?
Date: 2000-10-18 08:18:57
Message-ID: 20001018101857.F24830@comrade.omnitel.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

i really don't know if this is already known issue, unfortunatelly i
was unable to find any relevant information on the web. The problem is
very simple, and doesn not seem to be too important, i really amn't sure
whether i should report it with the tool...

one day i decided to switch password authetntication in pg_hba.conf
for local tcp/unix connection as well, ran psql and saw 'Password:' for
the first time :-) But, when i pressed ^D in answer it showed many
lines with 'Password:' at the begining and then postmaster died. I
wondered much being unable to find postmaster amongst the list of
processes... it looked like:

cyxob [12] $ psql -h localhost template1
Password:^D
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
psql: pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.

Later, when i ran it with no -S and with -s 10 flag and looked at its
output, it seemed to permorm read/write op on fdescriptor, and file
descriptor number were increasing up to 63 (well, my ulimit on number
of open files seems to be 64). it looked like:

FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
binding ShmemCreate(key=52e2c1, size=1104896)
DEBUG: Data Base System is starting up at Wed Oct 18 10:13:10 2000
DEBUG: Data Base System was interrupted being in production at Wed Oct 18 10:11:45 2000
DEBUG: Data Base System is in production state at Wed Oct 18 10:13:10 2000
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 6
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 6
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 6
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 7
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 7
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 7
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 8
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 8
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 8
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 9
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 9
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 9
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 10
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 10
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 10
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 11
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 11
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 11
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 12
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 12
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 12
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 13
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 13
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 13
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 14
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 14
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 14
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 15
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 15
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 15
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 16
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 16
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 16
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 17
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 17
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 17
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 18
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 18
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 18
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 19
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 19
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 19
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 20
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 20
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 20
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 21
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 21
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 21
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 22
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 22
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 22
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 23
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 23
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 23
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 24
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 24
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 24
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 25
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 25
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 25
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 26
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 26
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 26
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 27
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 27
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 27
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 28
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 28
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 28
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 29
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 29
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 29
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 30
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 30
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 30
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 31
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 31
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 31
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 32
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 32
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 32
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 33
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 33
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 33
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 34
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 34
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 34
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 35
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 35
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 35
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 36
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 36
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 36
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 37
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 37
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 37
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 38
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 38
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 38
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 39
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 39
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 39
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 40
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 40
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 40
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 41
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 41
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 41
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 42
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 42
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 42
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 43
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 43
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 43
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 44
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 44
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 44
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 45
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 45
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 45
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 46
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 46
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 46
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 47
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 47
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 47
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 48
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 48
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 48
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 49
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 49
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 49
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 50
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 50
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 50
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 51
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 51
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 51
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 52
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 52
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 52
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 53
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 53
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 53
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 54
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 54
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 54
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 55
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 55
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 55
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 56
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 56
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 56
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 57
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 57
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 57
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 58
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 58
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 58
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 59
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 59
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 59
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 60
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 60
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 60
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 61
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 61
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 61
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 62
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 62
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 62
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 63
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 63
FATAL 1: ReleaseLruFile: No open files available to be closed
proc_exit(0)
shmem_exit(0)
exit(0)

i'm running:

pgsql [30] $ psql -c 'select version();' template1
version
---------------------------------------------------------------------
PostgreSQL 7.0.2 on i386-unknown-openbsd2.6, compiled by gcc 2.95.1
(1 row)
pgsql [31] $

configuration options were:

./configure \
--with-tcl \
--prefix=/usr/local/pgsql \
--with-template=openbsd \
--with-includes=/usr/local/include \
--with-libraries=/usr/local/lib \
--with-tkconfig=/usr/local/lib/tk8.0

Thanks!

--
Denis A. Doroshenko -- VAS/IN group engineer
[Address: Omnitel Ltd., T.Sevcenkos 25, Vilnius 2600, Lithuania]
[Phone: +370 98 63207] [E-mail: mailto:d(dot)doroshenko(at)omnitel(dot)net]

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Karel Zak 2000-10-18 08:21:32 Re: Bugs in to_char function
Previous Message Ronald Kuczek 2000-10-18 06:34:25 AW: UPPER and LOWER dosen't work correctly on special caracters (umlauts)