Re: [ADMIN] Can't connect to my postgresql

Daniel Rubio <drubior(at)tinet(dot)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