pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't connect to my postgresql
5+ messages / 2 participants
[nested] [flat]
* Can't connect to my postgresql
@ 2003-03-25 14:03 Daniel Rubio <drubior@tinet.org>
2003-03-25 14:42 ` Re: Can't connect to my postgresql Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Daniel Rubio @ 2003-03-25 14:03 UTC (permalink / raw)
To: pgsql-admin
I've recently installed postgres in a new computer running solaris 8,
and I can't connect to it running psql. When I try it the response is:
bash-2.03$ ./psql
Password:
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
And on the log file i see:
LOG: connection received: host=[local]
LOG: connection received: host=[local]
LOG: server process (pid 6308) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing shared memory and
semaphores
LOG: database system was interrupted at 2003-03-25 14:58:41 GMT
LOG: checkpoint record is at 0/7EBB30
LOG: redo record is at 0/7EBB30; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16886
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: ReadRecord: record with zero length at 0/7EBB70
LOG: redo is not required
LOG: database system is ready
I configured using
./configure --prefix=/apps/pgsql-7.3.2 --without-readline
--with-openssl=/usr/local/ssl --with-pam
Some idea??
--
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio@oasi.org
********************************************************
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't connect to my postgresql
2003-03-25 14:03 Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
@ 2003-03-25 14:42 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-03-26 07:49 ` Re: Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2003-03-25 14:42 UTC (permalink / raw)
To: Daniel Rubio <drubior@tinet.org>; +Cc: pgsql-admin
Daniel Rubio <drubior@tinet.org> writes:
> I've recently installed postgres in a new computer running solaris 8,
> and I can't connect to it running psql. When I try it the response is:
> bash-2.03$ ./psql
> Password:
> psql: server closed the connection unexpectedly
Can you provide a debugger stack trace? This should be leaving a core
dump file in the database subdirectory ($PGDATA/base/something/core).
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't connect to my postgresql
2003-03-25 14:03 Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
2003-03-25 14:42 ` Re: Can't connect to my postgresql Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-03-26 07:49 ` Daniel Rubio <drubior@tinet.org>
2003-03-26 13:02 ` Re: Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
2003-03-31 21:43 ` Re: [ADMIN] Can't connect to my postgresql Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 5+ messages in thread
From: Daniel Rubio @ 2003-03-26 07:49 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Yes, there's a core in the data directory, here is the stack trace:
bash-2.03# pstack /apps/pgsql-7.3.2/data/core
core '/apps/pgsql-7.3.2/data/core' of 6308:
/apps/pgsql-7.3.2/bin/postmaster -D /apps/pgsql-7.3.2/da
00123e24 user_group_bsearch_cmp (33d689, 0, ffffffff, 0, 0, 0) + 10
fef36048 bsearch (8, fffffffc, 0, 4, 0, 123e14) + 4c
00123ecc get_user_line (33d689, a, 1, 2, 0, 8000) + 30
00122ccc md5_crypt_verify (33d558, 33d689, 32a188, 318249, 2b4198,
2d0ea3) + 2c
00122c70 recv_and_check_password_packet (33d558, 3, 0, ffffffff,
fffffff8, ffbeffc1) + f0
001223f4 ClientAuthentication (33d558, 33d648, 2b4198, fefbc004,
221d4, 172908) + 1b8
00172c34 DoBackend (33d558, 1, 0, ffffffff, 22658, 1724e4) + 3f4
001724f0 BackendStartup (33d558, 5, ffbef7e8, 1, 221d4, 1707ec) + b0
001708e8 ServerLoop (2e3cac, 1896, fefbf54c, fefc2938, fefbc004,
fefc2938) + 370
0017015c PostmasterMain (3, 323910, 74657200, 65720000, 74657200, 0) + ca4
00129b0c main (3, ffbefd6c, ffbefd7c, 317e30, 0, 0) + 2d0
00032d84 _start (0, 0, 0, 0, 0, 0) + 5c
I hope it may help ... i don't understand almost nothing!
Tom Lane wrote:
> Daniel Rubio <drubior@tinet.org> writes:
>
>>I've recently installed postgres in a new computer running solaris 8,
>>and I can't connect to it running psql. When I try it the response is:
>>bash-2.03$ ./psql
>>Password:
>>psql: server closed the connection unexpectedly
>
>
> Can you provide a debugger stack trace? This should be leaving a core
> dump file in the database subdirectory ($PGDATA/base/something/core).
>
> regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio@oasi.org
********************************************************
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Can't connect to my postgresql
2003-03-25 14:03 Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
2003-03-25 14:42 ` Re: Can't connect to my postgresql Tom Lane <tgl@sss.pgh.pa.us>
2003-03-26 07:49 ` Re: Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
@ 2003-03-26 13:02 ` Daniel Rubio <drubior@tinet.org>
1 sibling, 0 replies; 5+ messages in thread
From: Daniel Rubio @ 2003-03-26 13:02 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
This only happen when in my pg_hba.conf file I put password on the
method validation for local, instead the default trust.
I suppose is due to openssl :(
I'll have to rebuild the application whitout support for it ( i compiled
without it in other machine and all is fine )
Could be the pam support instead?
Daniel Rubio wrote:
> Yes, there's a core in the data directory, here is the stack trace:
>
> bash-2.03# pstack /apps/pgsql-7.3.2/data/core
> core '/apps/pgsql-7.3.2/data/core' of 6308:
> /apps/pgsql-7.3.2/bin/postmaster -D /apps/pgsql-7.3.2/da
> 00123e24 user_group_bsearch_cmp (33d689, 0, ffffffff, 0, 0, 0) + 10
> fef36048 bsearch (8, fffffffc, 0, 4, 0, 123e14) + 4c
> 00123ecc get_user_line (33d689, a, 1, 2, 0, 8000) + 30
> 00122ccc md5_crypt_verify (33d558, 33d689, 32a188, 318249, 2b4198,
> 2d0ea3) + 2c
> 00122c70 recv_and_check_password_packet (33d558, 3, 0, ffffffff,
> fffffff8, ffbeffc1) + f0
> 001223f4 ClientAuthentication (33d558, 33d648, 2b4198, fefbc004, 221d4,
> 172908) + 1b8
> 00172c34 DoBackend (33d558, 1, 0, ffffffff, 22658, 1724e4) + 3f4
> 001724f0 BackendStartup (33d558, 5, ffbef7e8, 1, 221d4, 1707ec) + b0
> 001708e8 ServerLoop (2e3cac, 1896, fefbf54c, fefc2938, fefbc004,
> fefc2938) + 370
> 0017015c PostmasterMain (3, 323910, 74657200, 65720000, 74657200, 0) + ca4
> 00129b0c main (3, ffbefd6c, ffbefd7c, 317e30, 0, 0) + 2d0
> 00032d84 _start (0, 0, 0, 0, 0, 0) + 5c
>
> I hope it may help ... i don't understand almost nothing!
>
> Tom Lane wrote:
>
>> Daniel Rubio <drubior@tinet.org> writes:
>>
>>> I've recently installed postgres in a new computer running solaris 8,
>>> and I can't connect to it running psql. When I try it the response is:
>>> bash-2.03$ ./psql
>>> Password:
>>> psql: server closed the connection unexpectedly
>>
>>
>>
>> Can you provide a debugger stack trace? This should be leaving a core
>> dump file in the database subdirectory ($PGDATA/base/something/core).
>>
>> regards, tom lane
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>>
>
>
--
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio@oasi.org
********************************************************
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [ADMIN] Can't connect to my postgresql
2003-03-25 14:03 Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
2003-03-25 14:42 ` Re: Can't connect to my postgresql Tom Lane <tgl@sss.pgh.pa.us>
2003-03-26 07:49 ` Re: Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
@ 2003-03-31 21:43 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2003-03-31 21:43 UTC (permalink / raw)
To: Daniel Rubio <drubior@tinet.org>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-bugs@postgreSQL.org
Daniel Rubio <drubior@tinet.org> writes:
> Yes, there's a core in the data directory, here is the stack trace:
> bash-2.03# pstack /apps/pgsql-7.3.2/data/core
> core '/apps/pgsql-7.3.2/data/core' of 6308:
> /apps/pgsql-7.3.2/bin/postmaster -D /apps/pgsql-7.3.2/da
> 00123e24 user_group_bsearch_cmp (33d689, 0, ffffffff, 0, 0, 0) + 10
> fef36048 bsearch (8, fffffffc, 0, 4, 0, 123e14) + 4c
> 00123ecc get_user_line (33d689, a, 1, 2, 0, 8000) + 30
> 00122ccc md5_crypt_verify (33d558, 33d689, 32a188, 318249, 2b4198,
> 2d0ea3) + 2c
After staring at the code for awhile, the only scenario I can construct
goes like this:
1. You had a $PGDATA/global/pg_pwd file when you started the postmaster.
2. For some reason, the file disappeared or became unreadable.
3. At the next SIGHUP, load_user() would delete user_lines and then
exit, leaving user_sorted pointing at pfree'd memory.
4. The above crash is then exactly what one would expect.
load_user and load_group are clearly buggy in that they don't take care
to keep the data structures in sync after an open failure --- but I'm
having a hard time concocting a reason why pg_pwd would disappear like
that. Ideas anyone?
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-03-31 21:43 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-25 14:03 Can't connect to my postgresql Daniel Rubio <drubior@tinet.org>
2003-03-25 14:42 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-03-26 07:49 ` Daniel Rubio <drubior@tinet.org>
2003-03-26 13:02 ` Daniel Rubio <drubior@tinet.org>
2003-03-31 21:43 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox