Thread: BUG #6263: \l causes core dump with large database
The following bug has been logged online: Bug reference: 6263 Logged by: Robert Messer Email address: bob.messer@l-3com.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" "$@"
"Robert Messer" <bob.messer@l-3com.com> writes:
> postgres=# \l
> *** glibc detected *** /opt/PostgreSQL/9.1/bin/psql.bin: realloc(): invalid
> next size: 0x0000000019510a20 ***
Well, this is interesting, but you're going to need to provide enough
information to let someone else duplicate it. "large database" means
little, and it certainly doesn't explain why you're seeing it when
nobody else has reported any such thing.
regards, tom lane
bob.messer@l-3com.com writes:
> 2) If I replace the libedit.so with the version in this rpm: libedit-2.11-2.20080712cvs.el5.x86_64.rpm, the
commandworks.
> 3) if I edit the psql script to use the libreadline.so that is installed on the system (it's looking in the wrong
place),the command works.
In that case you're dealing with a libedit bug. libedit has a lot of
known problems, especially if you're trying to use an old version as
it sounds like you might be. There's not a lot we can do about that.
regards, tom lane
bob.messer@l-3com.com writes:
> I am talking about the one that is installed in the PostgreSQL/lib folder, not the one from the operating system.
Well, you need to be complaining to whoever provided that build of
Postgres, which is not the upstream project ... and it is definitely
not me personally, so replying only to me isn't going to get you
anywhere. Please keep the list cc'd when replying.
regards, tom lane
On Oct 20, 2011, at 11:20 PM, Tom Lane wrote: > bob.messer@l-3com.com writes: >> 2) If I replace the libedit.so with the version in this rpm: libedit-2.= 11-2.20080712cvs.el5.x86_64.rpm, the command works. >=20 >> 3) if I edit the psql script to use the libreadline.so that is installe= d on the system (it's looking in the wrong place), the command works. >=20 > In that case you're dealing with a libedit bug. libedit has a lot of > known problems, especially if you're trying to use an old version as > it sounds like you might be. There's not a lot we can do about that. We have tried upgrading the libedit on our buildfarms and thus the One-Clic= k installers will now distribute newer version of libedit. Hopefully this w= ill eliminate this error. >=20 > regards, tom lane >=20 > --=20 > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.