On Dec 28, 2007, at 9:33 AM, marcelo Cortez wrote:
Folks i received the follow message from backend ,it's this a bug? best regards and happy new year MDC pd: any clue are welcomed. *** glibc detected *** postgres: postgres richelet 201.235.11.133(2504) SELECT: double free or corruption (!prev): 0x0845d7e8 *** ======= Backtrace: ========= /lib/libc.so.6[0xb7e0e930] /lib/libc.so.6(__libc_free+0x89)[0xb7e0ff99] postgres: postgres richelet 201.235.11.133(2504) SELECT[0x82b1c0b] postgres: postgres richelet 201.235.11.133(2504) SELECT(MemoryContextDelete+0x42)[0x82b2152] postgres: postgres richelet 201.235.11.133(2504) SELECT(MemoryContextDeleteChildren+0x28)[0x82b2198] postgres: postgres richelet 201.235.11.133(2504) SELECT(MemoryContextDelete+0x12)[0x82b2122] postgres: postgres richelet 201.235.11.133(2504) SELECT(MemoryContextDeleteChildren+0x28)[0x82b2198] postgres: postgres richelet 201.235.11.133(2504) SELECT(AtAbort_Portals+0x6f)[0x82b281f] postgres: postgres richelet 201.235.11.133(2504) SELECT[0x80adef3] postgres: postgres richelet 201.235.11.133(2504) SELECT(AbortCurrentTransaction+0x25)[0x80ae115] postgres: postgres richelet 201.235.11.133(2504) SELECT(PostgresMain+0x25c6)[0x81f7226] postgres: postgres richelet 201.235.11.133(2504) SELECT[0x81ca226] postgres: postgres richelet 201.235.11.133(2504) SELECT(PostmasterMain+0x81d)[0x81caf0d] postgres: postgres richelet 201.235.11.133(2504) SELECT(main+0x1c7)[0x8182e67] /lib/libc.so.6(__libc_start_main+0xd8)[0xb7dc0838] postgres: postgres richelet 201.235.11.133(2504) SELECT[0x807fa81] ======= Memory map: ======== 08048000-0836a000 r-xp 00000000 03:03 715320 /usr/local/pgsql/bin/postgres 0836a000-08373000 rw-p 00321000 03:03 715320 /usr/local/pgsql/bin/postgres 08373000-0846d000 rw-p 08373000 00:00 0 [heap] b5f00000-b5f21000 rw-p b5f00000 00:00 0 b5f21000-b6000000 ---p b5f21000 00:00 0 b60c4000-b60ce000 r-xp 00000000 03:03 744303 /usr/lib/gcc/i686-pc-linux-gnu/4.1.2/libgcc_s.so.1 b60ce000-b60cf000 rw-p 00009000 03:03 744303 /usr/lib/gcc/i686-pc-linux-gnu/4.1.2/libgcc_s.so.1 b60d7000-b60d9000 r-xp 00000000 03:03 708661 /usr/lib/gconv/ISO8859-1.so b60d9000-b60db000 rw-p 00001000 03:03 708661 /usr/lib/gconv/ISO8859-1.so b60db000-b60e3000 r-xp 00000000 03:03 527740 /usr/local/pgsql/lib/fuzzystrmatch.so b60e3000-b60e4000 rw-p 00007000 03:03 527740 /usr/local/pgsql/lib/fuzzystrmatch.so b60e4000-b6146000 rw-p b60e4000 00:00 0 b6146000-b6154000 r-xp 00000000 03:03 709308 /lib/libresolv-2.5.so b6154000-b6156000 rw-p 0000d000 03:03 709308 /lib/libresolv-2.5.so b6156000-b6158000 rw-p b6156000 00:00 0 b6158000-b615c000 r-xp 00000000 03:03 709745 /lib/libnss_dns-2.5.so b615c000-b615e000 rw-p 00003000 03:03 709745 /lib/libnss_dns-2.5.so b615e000-b6166000 r-xp 00000000 03:03 708470 /lib/libnss_files-2.5.so b6166000-b6168000 rw-p 00007000 03:03 708470 /lib/libnss_files-2.5.so b6169000-b6170000 r--s 00000000 03:03 6427 /usr/lib/gconv/gconv-modules.cache b6170000-b61a3000 r--p 00000000 03:03 8975 /usr/lib/locale/es_AR/LC_CTYPE b61a3000-b61a8000 r--p 00000000 03:03 16329 /usr/lib/locale/es_AR/LC_COLLATE b61a8000-b7daa000 rw-s 00000000 00:08 114456 /SYSV0052e2c1 (deleted) b7daa000-b7dab000 rw-p b7daa000 00:00 0 b7dab000-b7ecd000 r-xp 00000000 03:03 709248 /lib/libc-2.5.so b7ecd000-b7ece000 r--p 00122000 03:03 709248 /lib/libc-2.5.so b7ece000-b7ed0000 rw-p 00123000 03:03 709248 /lib/libc-2.5.so b7ed0000-b7ed3000 rw-p b7ed0000 00:00 0 b7ed3000-b7ef6000 r-xp 00000000 03:03 709734 /lib/libm-2.5.so b7ef6000-b7ef8000 rw-p 00022000 03:03 709734 /lib/libm-2.5.so b7ef8000-b7efa000 r-xp 00000000 03:03 709751 /lib/libdl-2.5.so b7efa000-b7efc000 rw-p 00001000 03:03 709751 /lib/libdl-2.5.so b7efc000-b7f01000 r-xp 00000000 03:03 709885 /lib/libcrypt-2.5.so b7f01000-b7f03000 rw-p 00004000 03:03 709885 /lib/libcrypt-2.5.so b7f03000-b7f2b000 rw-p b7f03000 00:00 0 b7f2d000-b7f2e000 r-xp 00000000 03:03 715438 /usr/local/pgsql/lib/utf8_and_iso8859_1.so b7f2e000-b7f2f000 rw-p 00000000 03:03 715438 /usr/local/pgsql/lib/utf8_and_iso8859_1.so b7f2f000-b7f30000 r--p 00000000 03:03 206641 /usr/lib/locale/es_AR/LC_TIME b7f30000-b7f31000 r--p 00000000 03:03 16760 /usr/lib/locale/es_AR/LC_NUMERIC b7f31000-b7f32000 r--p 00000000 03:03 206642 /usr/lib/locale/es_AR/LC_MONETARY b7f32000-b7f33000 r--p 00000000 03:03 16336 /usr/lib/locale/es_AR/LC_MESSAGES/SYS_LC_MESSAGES b7f33000-b7f4d000 r-xp 00000000 03:03 709923 /lib/ld-2.5.so b7f4d000-b7f4e000 r--p 00019000 03:03 709923 /lib/ld-2.5.so b7f4e000-b7f4f000 rw-p 0001a000 03:03 709923 /lib/ld-2.5.so bfdc4000-bfdda000 rw-p bfdc4000 00:00 0 [stack] ffffe000-fffff000 r-xp 00000000 00:00 0 [vdso] LOG: server process (PID 15558) was terminated by signal 6: Aborted LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2007-12-28 09:20:37 ART LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/20AC262C LOG: redo is not required LOG: autovacuum launcher started LOG: database system is ready to accept connections
Well, if Postgres had killed the proc itself it would have written out a nicely formatted Postgres-style memory context report along with an ERROR message along the lines of OUT OF MEMORY and the request size and Postgres would not have bounced. Since the postmaster dropped into recovery mode when the proc received the SIGABRT and died, that means that the signal came from somewhere else, OOM killer?
Erik Jones Software Developer | Emma® erik@xxxxxxxxxx 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
