BUG #6263: \l causes core dump with large database

From: "Robert Messer" <bob(dot)messer(at)l-3com(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6263: \l causes core dump with large database
Date: 2011-10-20 16:22:46
Message-ID: 201110201622.p9KGMkpk001661@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6263
Logged by: Robert Messer
Email address: bob(dot)messer(at)l-3com(dot)com
PostgreSQL version: 9.1.1 64-bit
Operating system: Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Description: \l causes core dump with large database
Details:

psql.bin (9.1.1)
Type "help" for help.

postgres=# \l
*** glibc detected *** /opt/PostgreSQL/9.1/bin/psql.bin: realloc(): invalid
next size: 0x0000000019510a20 ***
======= Backtrace: =========
/lib64/libc.so.6[0x3cb76746b4]
/lib64/libc.so.6(realloc+0x102)[0x3cb76751a2]
/opt/PostgreSQL/9.1/bin/../lib/libpq.so.5(enlargePQExpBuffer+0x66)[0x2b15bba
6b196]
/opt/PostgreSQL/9.1/bin/../lib/libpq.so.5(appendPQExpBuffer+0xdb)[0x2b15bba6
b39b]
/opt/PostgreSQL/9.1/bin/psql.bin[0x4197a5]
/opt/PostgreSQL/9.1/bin/psql.bin[0x406276]
/opt/PostgreSQL/9.1/bin/psql.bin[0x40e4e8]
/opt/PostgreSQL/9.1/bin/psql.bin[0x4104b4]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x3cb761d994]
/opt/PostgreSQL/9.1/bin/psql.bin[0x403a69]
======= Memory map: ========
00400000-0045b000 r-xp 00000000 08:07 1042796
/opt/PostgreSQL/9.1/bin/psql.bin
0065b000-0065c000 rw-p 0005b000 08:07 1042796
/opt/PostgreSQL/9.1/bin/psql.bin
0065c000-0065d000 rw-p 0065c000 00:00 0
194f4000-19515000 rw-p 194f4000 00:00 0
[heap]
3497e00000-3497e0d000 r-xp 00000000 08:07 1044446
/opt/PostgreSQL/9.1/lib/liblber-2.3.so.0
3497e0d000-349800d000 ---p 0000d000 08:07 1044446
/opt/PostgreSQL/9.1/lib/liblber-2.3.so.0
349800d000-349800e000 rw-p 0000d000 08:07 1044446
/opt/PostgreSQL/9.1/lib/liblber-2.3.so.0
3498200000-349824e000 r-xp 00000000 08:07 1044449
/opt/PostgreSQL/9.1/lib/libncurses.so.5.5
349824e000-349844e000 ---p 0004e000 08:07 1044449
/opt/PostgreSQL/9.1/lib/libncurses.so.5.5
349844e000-349845c000 rw-p 0004e000 08:07 1044449
/opt/PostgreSQL/9.1/lib/libncurses.so.5.5
349845c000-349845d000 rw-p 349845c000 00:00 0
3843400000-3843418000 r-xp 00000000 08:07 1044460
/opt/PostgreSQL/9.1/lib/libsasl2.so.2
3843418000-3843618000 ---p 00018000 08:07 1044460
/opt/PostgreSQL/9.1/lib/libsasl2.so.2
3843618000-3843619000 rw-p 00018000 08:07 1044460
/opt/PostgreSQL/9.1/lib/libsasl2.so.2
3cb7200000-3cb721c000 r-xp 00000000 08:07 1238205
/lib64/ld-2.5.so
3cb741b000-3cb741c000 r--p 0001b000 08:07 1238205
/lib64/ld-2.5.so
3cb741c000-3cb741d000 rw-p 0001c000 08:07 1238205
/lib64/ld-2.5.so
3cb7600000-3cb774d000 r-xp 00000000 08:07 1238206
/lib64/libc-2.5.so
3cb774d000-3cb794d000 ---p 0014d000 08:07 1238206
/lib64/libc-2.5.so
3cb794d000-3cb7951000 r--p 0014d000 08:07 1238206
/lib64/libc-2.5.so
3cb7951000-3cb7952000 rw-p 00151000 08:07 1238206
/lib64/libc-2.5.so
3cb7952000-3cb7957000 rw-p 3cb7952000 00:00 0
3cb7a00000-3cb7a82000 r-xp 00000000 08:07 1237941
/lib64/libm-2.5.so
3cb7a82000-3cb7c81000 ---p 00082000 08:07 1237941
/lib64/libm-2.5.so
3cb7c81000-3cb7c82000 r--p 00081000 08:07 1237941
/lib64/libm-2.5.so
3cb7c82000-3cb7c83000 rw-p 00082000 08:07 1237941
/lib64/libm-2.5.so
3cb7e00000-3cb7e02000 r-xp 00000000 08:07 1238083
/lib64/libdl-2.5.so
3cb7e02000-3cb8002000 ---p 00002000 08:07 1238083
/lib64/libdl-2.5.so
3cb8002000-3cb8003000 r--p 00002000 08:07 1238083
/lib64/libdl-2.5.so
3cb8003000-3cb8004000 rw-p 00003000 08:07 1238083
/lib64/libdl-2.5.so
3cb8200000-3cb8216000 r-xp 00000000 08:07 1238208
/lib64/libpthread-2.5.so
3cb8216000-3cb8415000 ---p 00016000 08:07 1238208
/lib64/libpthread-2.5.so
3cb8415000-3cb8416000 r--p 00015000 08:07 1238208
/lib64/libpthread-2.5.so
3cb8416000-3cb8417000 rw-p 00016000 08:07 1238208
/lib64/libpthread-2.5.so
3cb8417000-3cb841b000 rw-p 3cb8417000 00:00 0
3cb8600000-3cb8614000 r-xp 00000000 08:03 3147029
/usr/lib64/libz.so.1.2.3
3cb8614000-3cb8813000 ---p 00014000 08:03 3147029
/usr/lib64/libz.so.1.2.3
3cb8813000-3cb8814000 rw-p 00013000 08:03 3147029
/usr/lib64/libz.so.1.2.3
3cbba00000-3cbba19000 r-xp 00000000 08:07 1237957
/lib64/libaudit.so.0.0.0
3cbba19000-3cbbc18000 ---p 00019000 08:07 1237957
/lib64/libaudit.so.0.0.0
3cbbc18000-3cbbc1a000 rw-p 00018000 08:07 1237957
/lib64/libaudit.so.0.0.0
3cbce00000-3cbce0b000 r-xp 00000000 08:07 1238227
/lib64/libpam.so.0.81.5
3cbce0b000-3cbd00a000 ---p 0000b000 08:07 1238227
/lib64/libpam.so.0.81.5
3cbd00a000-3cbd00b000 rw-p 0000a000 08:07 1238227
/lib64/libpam.so.0.81.5
3cbd200000-3cbd215000 r-xp 00000000 08:07 1238217
/lib64/libselinux.so.1
3cbd215000-3cbd415000 ---p 00015000 08:07 1238217
/lib64/libselinux.so.1
3cbd415000-3cbd417000 rw-p 00015000 08:07 1238217
/lib64/libselinux.so.1
3cbd417000-3cbd418000 rw-p 3cbd417000 00:00 0
3cbd600000-3cbd63b000 r-xp 00000000 08:07 1238216
/lib64/libsepol.so.1
3cbd63b000-3cbd83b000 ---p 0003b000 08:07 1238216
/lib64/libsepol.so.1
3cbd83b000-3cbd83c000 rw-p 0003b000 08:07 1238216
/lib64/libsepol.so.1
3cbd83c000-3cbd846000 rw-p 3cbd83c000 00:00 0
3cbfa00000-3cbfa11000 r-xp 00000000 08:07 1238215
/lib64/libresolv-2.5.so
3cbfa11000-3cbfc11000 ---p 00011000 08:07 1238215
/lib64/libresolv-2.5.so
3cbfc11000-3cbfc12000 r--p 00011000 08:07 1238215
/lib64/libresolv-2.5.so
3cbfc12000-3cbfc13000 rw-p 00012000 08:07 1238215
/lib64/libresolv-2.5.so
3cbfc13000-3cbfc15000 rw-p 3cbfc13000 00:00 0
3cc0200000-3cc0202000 r-xp 00000000 08:07 1238218
/lib64/libcom_err.so.2.1
3cc0202000-3cc0401000 ---p 00002000 08:07 1238218
/lib64/libcom_err.so.2.1
3cc0401000-3cc0402000 rw-p 00001000 08:07 1238218
/lib64/libcom_err.so.2.1
3cc0a00000-3cc0a91000 r-xp 00000000 08:03 3147961
/usr/lib64/libkrb5.so.3.3
3cc0a91000-3cc0c91000 ---p 00091000 08:03 3147961
/usr/lib64/libkrb5.so.3.3
3cc0c91000-3cc0c95000 rw-p 00091000 08:03 3147961
/usr/lib64/libkrb5.so.3.3
3cc1200000-3cc1202000 r-xp 00000000 08:07 1238214
/lib64/libkeyutils-1.2.so
3cc1202000-3cc1401000 ---p 00002000 08:07 1238214
/lib64/libkeyutils-1.2.so
3cc1401000-3cc1402000 rw-p 00001000 08:07 1238214
/lib64/libkeyutils-1.2.so
3cc1600000-3cc1624000 r-xp 00000000 08:03 3147960
/usr/lib64/libk5crypto.so.3.1
3cc1624000-3cc1823000 ---p 00024000 08:03 3147960
/usr/lib64/libk5crypto.so.3.1
3cc1823000-3cc1825000 rw-p 00023000 08:03 3147960
/usr/lib64/libk5crypto.so.3.1
3cc1e00000-3cc1e2c000 r-xp 00000000 08:03 3147962
/usr/lib64/libgssapi_krb5.so.2.2
3cc1e2c000-3cc202c000 ---p 0002c000 08:03 3147962
/usr/lib64/libgssapi_krb5.so.2.2
3cc202c000-3cc202e000 rw-p 0002c000 08:03 3147962
/usr/lib64/libgssapi_krb5.so.2.2
3cc3e00000-3cc3e08000 r-xp 00000000 08:03 3147102
/usr/lib64/libkrb5support.so.0.1
3cc3e08000-3cc4007000 ---p 00008000 08:03 3147102
/usr/lib64/libkrb5support.so.0.1
3cc4007000-3cc4008000 rw-p 00007000 08:03 3147102
/usr/lib64/libkrb5support.so.0.1
3cca400000-3cca409000 r-xp 00000000 08:07 1237958
/lib64/libcrypt-2.5.so
3cca409000-3cca608000 ---p 00009000 08:07 1237958
/lib64/libcrypt-2.5.so
3cca608000-3cca609000 r--p 00008000 08:07 1237958
/lib64/libcrypt-2.5.so
3cca609000-3cca60a000 rw-p 00009000 08:07 1237958
/lib64/libcrypt-2.5.so
3cca60a000-3cca638000 rw-p 3cca60a000 00:00 0
3f74800000-3f7492d000 r-xp 00000000 08:07 1044435
/opt/PostgreSQL/9.1/lib/libcrypto.so.6
3f7492d000-3f74b2c000 ---p 0012d000 08:07 1044435
/opt/PostgreSQL/9.1/lib/libcrypto.so.6
3f74b2c000-3f74b4d000 rw-p 0012c000 08:07 1044435
/opt/PostgreSQL/9.1/lib/libcrypto.so.6
3f74b4d000-3f74b51000 rw-p 3f74b4d000 00:00 0
3f74c00000-3f74c46000 r-xp 00000000 08:07 1044461
/opt/PostgreSQL/9.1/lib/libssl.so.6
3f74c46000-3f74e46000 ---p 00046000 08:07 1044461
/opt/PostgreSQL/9.1/lib/libssl.so.6
3f74e46000-3f74e4c000 rw-p 00046000 08:07 1044461
/opt/PostgreSQL/9.1/lib/libssl.so.6
3f76400000-3f7643d000 r-xp 00000000 08:07 1044448
/opt/PostgreSQL/9.1/lib/libldap_r-2.3.so.0
3f7643d000-3f7663c000 ---p 0003d000 08:07 1044448
/opt/PostgreSQL/9.1/lib/libldap_r-2.3.so.0
3f7663c000-3f7663f000 rw-p 0003c000 08:07 1044448
/opt/PostgreSQL/9.1/lib/libldap_r-2.3.so.0
3f7663f000-3f76649000 rw-p 3f7663f000 00:00 0
2b15bba50000-2b15bba52000 rw-p 2b15bba50000 00:00 0
2b15bba52000-2b15bba78000 r-xp 00000000 08:07 1044458
/opt/PostgreSQL/9.1/lib/libpq.so.5
2b15bba78000-2b15bbc77000 ---p 00026000 08:07 1044458
/opt/PostgreSQL/9.1/lib/libpq.so.5
2b15bbc77000-2b15bbc7a000 rw-p 00025000 08:07 1044458
/opt/PostgreSQL/9.1/lib/libpq.so.5
2b15bbc7a000-2b15bbcb2000 r-xp 00000000 08:07 1044465
/opt/PostgreSQL/9.1/lib/libxslt.so.1
2b15bbcb2000-2b15bbeb1000 ---p 00038000 08:07 1044465
/opt/PostgreSQL/9.1/lib/libxslt.so.1
2b15bbeb1000-2b15bbeb3000 rw-p 00037000 08:07 1044465
/opt/PostgreSQL/9.1/lib/libxslt.so.1
2b15bbeb3000-2b15bbfeb000 r-xp 00000000 08:07 1044464
/opt/PostgreSQL/9.1/lib/libxml2.so.2
2b15bbfeb000-2b15bc1ea000 ---p 00138000 08:07 1044464
/opt/PostgreSQL/9.1/lib/libxml2.so.2
2b15bc1ea000-2b15bc1f4000 rw-p 00137000 08:07 1044464
/opt/PostgreSQL/9.1/lib/libxml2.so.2
2b15bc1f4000-2b15bc1f5000 rw-p 2b15bc1f4000 00:00 0
2b15bc20d000-2b15bc20f000 rw-p 2b15bc20d000 00:00 0
2b15bc20f000-2b15bc237000 r-xp 00000000 08:07 1044444
/opt/PostgreSQL/9.1/lib/libedit.so
2b15bc237000-2b15bc436000 ---p 00028000 08:07 1044444
/opt/PostgreSQL/9.1/lib/libedit.so
2b15bc436000-2b15bc439000 rw-p 00027000 08:07 1044444
/opt/PostgreSQL/9.1/lib/libedit.so
2b15bc439000-2b15bc442000 rw-p 2b15bc439000 00:00 0
2b15bc442000-2b15bfa17000 r--p 00000000 08:03 9799853
/usr/lib/locale/locale-archive
2b15bfa17000-2b15bfa18000 rw-p 2b15bfa17000 00:00 0
2b15bfa2f000-2b15bfa39000 r-xp 00000000 08:07 1237915
/lib64/libnss_files-2.5.so
2b15bfa39000-2b15bfc38000 ---p 0000a000 08:07 1237915
/lib64/libnss_files-2.5.so
2b15bfc38000-2b15bfc39000 r--p 00009000 08:07 1237915
/lib64/libnss_files-2.5.so
2b15bfc39000-2b15bfc3a000 rw-p 0000a000 08:07 1237915
/lib64/libnss_files-2.5.so
2b15bfc52000-2b15bfc5f000 r-xp 00000000 08:07 1238093
/lib64/libgcc_s-4.1.2-20080825.so.1
2b15bfc5f000-2b15bfe5f000 ---p 0000d000 08:07 1238093
/lib64/libgcc_s-4.1.2-20080825.so.1
2b15bfe5f000-2b15bfe60000 rw-p 0000d000 08:07 1238093
/lib64/libgcc_s-4.1.2-20080825.so.1
2b15c0000000-2b15c0021000 rw-p 2b15c0000000 00:00 0
2b15c0021000-2b15c4000000 ---p 2b15c0021000 00:00 0
7fff3581b000-7fff35830000 rw-p 7ffffffea000 00:00 0
[stack]
ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0
[vdso]
/opt/PostgreSQL/9.1/bin/psql: line 30: 14485 Aborted
LD_LIBRARY_PATH=$PG_BIN_PATH/../lib:$LD_LIBRARY_PATH "$PG_BIN_PATH/psql.bin"
"$@"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2011-10-20 17:04:28 Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Previous Message Valentine Gogichashvili 2011-10-20 16:19:31 Re: Can't use WITH in a PERFORM query in PL/pgSQL?