Re: Bug#1216 - Mailing list pgsql-bugs

Your name               : A Wu
Your email address      : sunwukong@ieee.org


System Configuration
---------------------
  Architecture (example: Intel Pentium)         : AMD Opteron 242

  Operating System (example: Linux 2.4.18)      : Linux 2.6.7-gentoo-r13 x86_64

  PostgreSQL version (example: PostgreSQL-8.0):   PostgreSQL-8.0Beta1

  Compiler used (example:  gcc 2.95.2)          : gcc-3.4.1


Please enter a FULL description of your problem:
------------------------------------------------
[Follow-up to bug report #1216] I recompiled with the additional flags:

--enable-debug --enable-depend --enable-cassert

I've also set

log_error_verbosity = verbose

Unfortunately neither the postgresql.log:

LOG:  00000: database system is ready
LOCATION:  StartupXLOG, xlog.c:4461
ERROR:  42704: group "regressgroup1" does not exist
LOCATION:  DropGroup, user.c:1769
LOG:  00000: server process (PID 3758) was terminated by signal 11
LOCATION:  LogChildExit, postmaster.c:2333
LOG:  00000: terminating any other active server processes
LOCATION:  HandleChildCrash, postmaster.c:2226
LOG:  00000: all server processes terminated; reinitializing
LOCATION:  reaper, postmaster.c:2126
LOG:  00000: database system was interrupted at 2004-08-12 11:09:01 MDT
LOCATION:  StartupXLOG, xlog.c:4002
LOG:  00000: checkpoint record is at 0/B53588
LOCATION:  StartupXLOG, xlog.c:4070
LOG:  00000: redo record is at 0/B53588; undo record is at 0/0; shutdown TRUE
LOCATION:  StartupXLOG, xlog.c:4097
LOG:  00000: next transaction ID: 591; next OID: 41804
LOCATION:  StartupXLOG, xlog.c:4100
LOG:  00000: database system was not properly shut down; automatic recovery in progress
LOCATION:  StartupXLOG, xlog.c:4156
LOG:  00000: redo starts at 0/B535D0
LOCATION:  StartupXLOG, xlog.c:4193
LOG:  00000: record with zero length at 0/B96E68
LOCATION:  ReadRecord, xlog.c:2454
LOG:  00000: redo done at 0/B96E38
LOCATION:  StartupXLOG, xlog.c:4250
FATAL:  57P03: the database system is starting up
LOCATION:  ProcessStartupPacket, postmaster.c:1556
FATAL:  57P03: the database system is starting up
LOCATION:  ProcessStartupPacket, postmaster.c:1556
FATAL:  57P03: the database system is starting up
LOCATION:  ProcessStartupPacket, postmaster.c:1556
FATAL:  57P03: the database system is starting up
LOCATION:  ProcessStartupPacket, postmaster.c:1556
FATAL:  57P03: the database system is starting up
LOCATION:  ProcessStartupPacket, postmaster.c:1556
FATAL:  57P03: the database system is starting up
LOCATION:  ProcessStartupPacket, postmaster.c:1556
FATAL:  57P03: the database system is starting up
LOCATION:  ProcessStartupPacket, postmaster.c:1556
LOG:  00000: database system is ready
LOCATION:  StartupXLOG, xlog.c:4461

nor the system log are any more help than I've already reported:

Aug 12 11:09:13 postmaster[3758]: segfault at 0000000000000020 rip 0000002a9594d565 rsp 0000007fbfffd9e8 error 4

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
see bug report #1216