Thread: Unexpected exit of Postgres terminal
Dear all, Today I need to use crosstab function but Postgresql says that there is no function crosstab, so i try to install it by : bin/psql -Upostgres test -f '/opt/PostgresPlus/9.0SS/share/postgresql/contrib/tablefunc.sql' & it creates the functions. But know when I issue any query in Postgres , don't know why this appears. test=# select * from ct; id | rowid | attribute | value ----+-------+-----------+------- 1 | test1 | att1 | val1 2 | test1 | att2 | val2 3 | test1 | att3 | val3 4 | test1 | att4 | val4 5 | test2 | att1 | val5 6 | test2 | att2 | val6 7 | test2 | att3 | val7 8 | test2 | att4 | val8 (8 rows) *** glibc detected *** bin/psql: free(): invalid next size (fast): 0x000000000b684f40 *** ======= Backtrace: ========= /lib64/libc.so.6[0x34e9a722ef] /lib64/libc.so.6(cfree+0x4b)[0x34e9a7273b] bin/psql[0x4139b4] bin/psql[0x414e44] bin/psql[0x415a68] bin/psql[0x408d82] bin/psql[0x40d9d6] bin/psql[0x40fa7e] /lib64/libc.so.6(__libc_start_main+0xf4)[0x34e9a1d994] bin/psql[0x403a69] ======= Memory map: ======== 00400000-00456000 r-xp 00000000 08:01 18267785 /opt/PostgresPlus/9.0SS/bin/psql 00655000-00656000 rw-p 00055000 08:01 18267785 /opt/PostgresPlus/9.0SS/bin/psql 00656000-00657000 rw-p 00656000 00:00 0 0b66d000-0b68e000 rw-p 0b66d000 00:00 0 [heap] 3485e00000-3485e03000 r-xp 00000000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2 3485e03000-3486002000 ---p 00003000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2 3486002000-3486003000 rw-p 00002000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2 34e8a00000-34e8a1c000 r-xp 00000000 08:01 13291123 /lib64/ld-2.5.so 34e8c1b000-34e8c1c000 r--p 0001b000 08:01 13291123 /lib64/ld-2.5.so 34e8c1c000-34e8c1d000 rw-p 0001c000 08:01 13291123 /lib64/ld-2.5.so 34e9a00000-34e9b4d000 r-xp 00000000 08:01 13291124 /lib64/libc-2.5.so 34e9b4d000-34e9d4d000 ---p 0014d000 08:01 13291124 /lib64/libc-2.5.so 34e9d4d000-34e9d51000 r--p 0014d000 08:01 13291124 /lib64/libc-2.5.so 34e9d51000-34e9d52000 rw-p 00151000 08:01 13291124 /lib64/libc-2.5.so 34e9d52000-34e9d57000 rw-p 34e9d52000 00:00 0 34e9e00000-34e9e82000 r-xp 00000000 08:01 13291125 /lib64/libm-2.5.so 34e9e82000-34ea081000 ---p 00082000 08:01 13291125 /lib64/libm-2.5.so 34ea081000-34ea082000 r--p 00081000 08:01 13291125 /lib64/libm-2.5.so 34ea082000-34ea083000 rw-p 00082000 08:01 13291125 /lib64/libm-2.5.so 34ea200000-34ea202000 r-xp 00000000 08:01 13291130 /lib64/libdl-2.5.so 34ea202000-34ea402000 ---p 00002000 08:01 13291130 /lib64/libdl-2.5.so 34ea402000-34ea403000 r--p 00002000 08:01 13291130 /lib64/libdl-2.5.so 34ea403000-34ea404000 rw-p 00003000 08:01 13291130 /lib64/libdl-2.5.so 34ea600000-34ea616000 r-xp 00000000 08:01 13291126 /lib64/libpthread-2.5.so 34ea616000-34ea815000 ---p 00016000 08:01 13291126 /lib64/libpthread-2.5.so 34ea815000-34ea816000 r--p 00015000 08:01 13291126 /lib64/libpthread-2.5.so 34ea816000-34ea817000 rw-p 00016000 08:01 13291126 /lib64/libpthread-2.5.so 34ea817000-34ea81b000 rw-p 34ea817000 00:00 0 34eae00000-34eae14000 r-xp 00000000 08:01 20286121 /usr/lib64/libz.so.1.2.3 34eae14000-34eb013000 ---p 00014000 08:01 20286121 /usr/lib64/libz.so.1.2.3 34eb013000-34eb014000 rw-p 00013000 08:01 20286121 /usr/lib64/libz.so.1.2.3 34f2400000-34f2419000 r-xp 00000000 08:01 13291152 /lib64/libaudit.so.0.0.0 34f2419000-34f2618000 ---p 00019000 08:01 13291152 /lib64/libaudit.so.0.0.0 34f2618000-34f261a000 rw-p 00018000 08:01 13291152 /lib64/libaudit.so.0.0.0 34f3400000-34f3402000 r-xp 00000000 08:01 13291142 /lib64/libcom_err.so.2.1 34f3402000-34f3601000 ---p 00002000 08:01 13291142 /lib64/libcom_err.so.2.1 34f3601000-34f3602000 rw-p 00001000 08:01 13291142 /lib64/libcom_err.so.2.1 34f3c00000-34f3c11000 r-xp 00000000 08:01 13291139 /lib64/libresolv-2.5.so 34f3c11000-34f3e11000 ---p 00011000 08:01 13291139 /lib64/libresolv-2.5.so 34f3e11000-34f3e12000 r--p 00011000 08:01 13291139 /lib64/libresolv-2.5.so 34f3e12000-34f3e13000 rw-p 00012000 08:01 13291139 /lib64/libresolv-2.5.so 34f3e13000-34f3e15000 rw-p 34f3e13000 00:00 0 34f4000000-34f4002000 r-xp 00000000 08:01 13291138 /lib64/libkeyutils-1.2.so 34f4002000-34f4201000 ---p 00002000 08:01 13291138 /lib64/libkeyutils-1.2.so 34f4201000-34f4202000 rw-p 00001000 08:01 13291138 /lib64/libkeyutils-1.2.so 34f5c00000-34f5c0b000 r-xp 00000000 08:01 13291153 /lib64/libpam.so.0.81.5 34f5c0b000-34f5e0a000 ---p 0000b000 08:01 13291153 /lib64/libpam.so.0.81.5 34f5e0a000-34f5e0b000 rw-p 0000a000 08:01 13291153 /lib64/libpam.so.0.81.5 34fac00000-34fac0d000 r-xp 00000000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1 34fac0d000-34fae0d000 ---p 0000d000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1 34fae0d000-34fae0e000 rw-p 0000d000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1 383ea00000-383eb2d000 r-xp 00000000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6 383eb2d000-383ed2c000 ---p 0012d000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6 383ed2c000-383ed4d000 rw-p 0012c000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6 383ed4d000-383ed51000 rw-p 383ed4d000 00:00 0 383ee00000-383ee46000 r-xp 00000000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6 383ee46000-383f046000 ---p 00046000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6 383f046000-383f04c000 rw-p 00046000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6 3ec2200000-3ec2208000 r-xp 00000000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1 3ec2208000-3ec2407000 ---p 00008000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1 3ec2407000-3ec2408000 rw-p 00007000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1 3ec2600000-3ec262c000 r-xp 00000000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2 3ec262c000-3ec282c000 ---p 0002c000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2 3ec282c000-3ec282e000 rw-p 0002c000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2 3ec2a00000-3ec2a24000 r-xp 00000000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1 3ec2a24000-3ec2c23000 ---p 00024000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1 3ec2c23000-3ec2c25000 rw-p 00023000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1 3ec2e00000-3ec2e91000 r-xp 00000000 08:01 20289076 /usr/lib64/libkrb5.so.3.3 3ec2e91000-3ec3091000 ---p 00091000 08:01 20289076 /usr/lib64/libkrb5.so.3.3 3ec3091000-3ec3095000 rw-p 00091000 08:01 20289076 /usr/lib64/libkrb5.so.3.3 3ec3200000-3ec323b000 r-xp 00000000 08:01 13290831 /lib64/libsepol.so.1 3ec323b000-3ec343b000 ---p 0003b000 08:01 13290831 /lib64/libsepol.so.1 3ec343b000-3ec343c000 rw-p 0003b000 08:01 13290831 /lib64/libsepol.so.1 3ec343c000-3ec3446000 rw-p 3ec343c000 00:00 0 3ec3600000-3ec3615000 r-xp 00000000 08:01 13290833 /lib64/libselinux.so.1 3ec3615000-3ec3815000 ---p 00015000 08:01 13290833 /lib64/libselinux.so.1 3ec3815000-3ec3817000 rw-p 00015000 08:01 13290833 /lib64/libselinux.so.1 3ec3817000-3ec3818000 rw-p 3ec3817000 00:00 0 3ec3a00000-3ec3a09000 r-xp 00000000 08:01 13290835 /lib64/libcrypt-2.5.so 3ec3a09000-3ec3c08000 ---p 00009000 08:01 13290835 /lib64/libcrypt-2.5.so 3ec3c08000-3ec3c09000 r--p 00008000 08:01 13290835 /lib64/libcrypt-2.5.so 3ec3c09000-3ec3c0a000 rw-p 00009000 08:01 13290835 /lib64/libcrypt-2.5.so 3ec3c0a000-3ec3c38000 rw-p 3ec3c0a000 00:00 0 2ae529470000-2ae529472000 rw-p 2ae529470000 00:00 0 2ae529472000-2ae529495000 r-xp 00000000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5 2ae529495000-2ae529694000 ---p 00023000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5 2ae529694000-2ae529697000 rw-p 00022000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5 2ae529697000-2ae5296cd000 r-xp 00000000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1 2ae5296cd000-2ae5298cc000 ---p 00036000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1 2ae5298cc000-2ae5298ce000 rw-p 00035000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1 2ae5298ce000-2ae529a02000 r-xp 00000000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2 2ae529a02000-2ae529c01000 ---p 00134000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2 2ae529c01000-2ae529c0b000 rw-p 00133000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2 2ae529c0b000-2ae529c0c000 rw-p 2ae529c0b000 00:00 0 2ae529c2e000-2ae529c30000 rw-p 2ae529c2e000 00:00 0 2ae529c30000-2ae529c58000 r-xp 00000000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so 2ae529c58000-2ae529e57000 ---p 00028000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so 2ae529e57000-2ae529e5a000 rw-p 00027000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so 2ae529e5a000-2ae529e62000 rw-p 2ae529e5a000 00:00 0 2ae529e62000-2ae52d43b000 r--p 00000000 08:01 20267104 /usr/lib/locale/locale-archive 2ae52d43b000-2ae52d43c000 rw-p 2ae52d43b000 00:00 0 2ae52d45d000-2ae52d467000 r-xp 00000000 08:01 13290841 /lib64/libnss_files-2.5.so 2ae52d467000-2ae52d666000 ---p 0000a000 08:01 13290841 /lib64/libnss_files-2.5.so 2ae52d666000-2ae52d667000 r--p 00009000 08:01 13290841 /lib64/libnss_files-2.5.so 2ae52d667000-2ae52d668000 rw-p 0000a000 08:01 13290841 /lib64/libnss_files-2.5.so 7fff8aeee000-7fff8af03000 rw-p 7ffffffea000 00:00 0 [stack] ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso] Aborted [root@ws-test 9.0SS]# Any comments on this & how to resolve it. Thanks
Hi Adarsh,
This isssue has fixed in PPSS latest version. However here is workaround for it.
Step 1: Install Libedit module from Yum Repository.
[root@239435-db9 ~]# yum install libedit.x86_64
[root@239435-db9 ~]# rpm -q libedit.x86_64
libedit-2.11-2.20080712cvs.el5
Step 2: Identify the location of installed libedit binary location.
[root@239435-db9 ~]# rpm -q libedit.x86_64 --filesbypkg
libedit /usr/lib64/libedit.so.0
libedit /usr/lib64/libedit.so.0.0.27
libedit /usr/share/doc/libedit-2.11
libedit /usr/share/doc/libedit-2.11/COPYING
libedit /usr/share/doc/libedit-2.11/ChangeLog
libedit /usr/share/doc/libedit-2.11/THANKS
[root@239435-db9 ~]# pwd
/root
Step 3: Take the backup of bundled libedit binary
[root@239435-db9 ~]# cd /opt/PostgreSQL/9.0/lib/
[root@239435-db9 lib]# ls -l libedit*
-rwxr-xr-- 1 root daemon 192738 Dec 14 04:46 libedit.so
[root@239435-db9 lib]# mv libedit.so libedit.so.bk
Step 4: Soft link the newly installed libedit binary to PostgreSQL installed location
[root@239435-db9 lib]# ln -s /usr/lib64/libedit.so.0 /opt/PostgreSQL/9.0/lib/libedit.so
Now try connecting to Server with psql...
On Thu, May 19, 2011 at 4:39 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
Dear all,
Today I need to use crosstab function but Postgresql says that there is no function crosstab, so i try to install it by :
bin/psql -Upostgres test -f '/opt/PostgresPlus/9.0SS/share/postgresql/contrib/tablefunc.sql'
& it creates the functions.
But know when I issue any query in Postgres , don't know why this appears.
test=# select * from ct;
id | rowid | attribute | value
----+-------+-----------+-------
1 | test1 | att1 | val1
2 | test1 | att2 | val2
3 | test1 | att3 | val3
4 | test1 | att4 | val4
5 | test2 | att1 | val5
6 | test2 | att2 | val6
7 | test2 | att3 | val7
8 | test2 | att4 | val8
(8 rows)
*** glibc detected *** bin/psql: free(): invalid next size (fast): 0x000000000b684f40 ***
======= Backtrace: =========
/lib64/libc.so.6[0x34e9a722ef]
/lib64/libc.so.6(cfree+0x4b)[0x34e9a7273b]
bin/psql[0x4139b4]
bin/psql[0x414e44]
bin/psql[0x415a68]
bin/psql[0x408d82]
bin/psql[0x40d9d6]
bin/psql[0x40fa7e]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x34e9a1d994]
bin/psql[0x403a69]
======= Memory map: ========
00400000-00456000 r-xp 00000000 08:01 18267785 /opt/PostgresPlus/9.0SS/bin/psql
00655000-00656000 rw-p 00055000 08:01 18267785 /opt/PostgresPlus/9.0SS/bin/psql
00656000-00657000 rw-p 00656000 00:00 0
0b66d000-0b68e000 rw-p 0b66d000 00:00 0 [heap]
3485e00000-3485e03000 r-xp 00000000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2
3485e03000-3486002000 ---p 00003000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2
3486002000-3486003000 rw-p 00002000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2
34e8a00000-34e8a1c000 r-xp 00000000 08:01 13291123 /lib64/ld-2.5.so
34e8c1b000-34e8c1c000 r--p 0001b000 08:01 13291123 /lib64/ld-2.5.so
34e8c1c000-34e8c1d000 rw-p 0001c000 08:01 13291123 /lib64/ld-2.5.so
34e9a00000-34e9b4d000 r-xp 00000000 08:01 13291124 /lib64/libc-2.5.so
34e9b4d000-34e9d4d000 ---p 0014d000 08:01 13291124 /lib64/libc-2.5.so
34e9d4d000-34e9d51000 r--p 0014d000 08:01 13291124 /lib64/libc-2.5.so
34e9d51000-34e9d52000 rw-p 00151000 08:01 13291124 /lib64/libc-2.5.so
34e9d52000-34e9d57000 rw-p 34e9d52000 00:00 0
34e9e00000-34e9e82000 r-xp 00000000 08:01 13291125 /lib64/libm-2.5.so
34e9e82000-34ea081000 ---p 00082000 08:01 13291125 /lib64/libm-2.5.so
34ea081000-34ea082000 r--p 00081000 08:01 13291125 /lib64/libm-2.5.so
34ea082000-34ea083000 rw-p 00082000 08:01 13291125 /lib64/libm-2.5.so
34ea200000-34ea202000 r-xp 00000000 08:01 13291130 /lib64/libdl-2.5.so
34ea202000-34ea402000 ---p 00002000 08:01 13291130 /lib64/libdl-2.5.so
34ea402000-34ea403000 r--p 00002000 08:01 13291130 /lib64/libdl-2.5.so
34ea403000-34ea404000 rw-p 00003000 08:01 13291130 /lib64/libdl-2.5.so
34ea600000-34ea616000 r-xp 00000000 08:01 13291126 /lib64/libpthread-2.5.so
34ea616000-34ea815000 ---p 00016000 08:01 13291126 /lib64/libpthread-2.5.so
34ea815000-34ea816000 r--p 00015000 08:01 13291126 /lib64/libpthread-2.5.so
34ea816000-34ea817000 rw-p 00016000 08:01 13291126 /lib64/libpthread-2.5.so
34ea817000-34ea81b000 rw-p 34ea817000 00:00 0
34eae00000-34eae14000 r-xp 00000000 08:01 20286121 /usr/lib64/libz.so.1.2.3
34eae14000-34eb013000 ---p 00014000 08:01 20286121 /usr/lib64/libz.so.1.2.3
34eb013000-34eb014000 rw-p 00013000 08:01 20286121 /usr/lib64/libz.so.1.2.3
34f2400000-34f2419000 r-xp 00000000 08:01 13291152 /lib64/libaudit.so.0.0.0
34f2419000-34f2618000 ---p 00019000 08:01 13291152 /lib64/libaudit.so.0.0.0
34f2618000-34f261a000 rw-p 00018000 08:01 13291152 /lib64/libaudit.so.0.0.0
34f3400000-34f3402000 r-xp 00000000 08:01 13291142 /lib64/libcom_err.so.2.1
34f3402000-34f3601000 ---p 00002000 08:01 13291142 /lib64/libcom_err.so.2.1
34f3601000-34f3602000 rw-p 00001000 08:01 13291142 /lib64/libcom_err.so.2.1
34f3c00000-34f3c11000 r-xp 00000000 08:01 13291139 /lib64/libresolv-2.5.so
34f3c11000-34f3e11000 ---p 00011000 08:01 13291139 /lib64/libresolv-2.5.so
34f3e11000-34f3e12000 r--p 00011000 08:01 13291139 /lib64/libresolv-2.5.so
34f3e12000-34f3e13000 rw-p 00012000 08:01 13291139 /lib64/libresolv-2.5.so
34f3e13000-34f3e15000 rw-p 34f3e13000 00:00 0
34f4000000-34f4002000 r-xp 00000000 08:01 13291138 /lib64/libkeyutils-1.2.so
34f4002000-34f4201000 ---p 00002000 08:01 13291138 /lib64/libkeyutils-1.2.so
34f4201000-34f4202000 rw-p 00001000 08:01 13291138 /lib64/libkeyutils-1.2.so
34f5c00000-34f5c0b000 r-xp 00000000 08:01 13291153 /lib64/libpam.so.0.81.5
34f5c0b000-34f5e0a000 ---p 0000b000 08:01 13291153 /lib64/libpam.so.0.81.5
34f5e0a000-34f5e0b000 rw-p 0000a000 08:01 13291153 /lib64/libpam.so.0.81.5
34fac00000-34fac0d000 r-xp 00000000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1
34fac0d000-34fae0d000 ---p 0000d000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1
34fae0d000-34fae0e000 rw-p 0000d000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1
383ea00000-383eb2d000 r-xp 00000000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6
383eb2d000-383ed2c000 ---p 0012d000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6
383ed2c000-383ed4d000 rw-p 0012c000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6
383ed4d000-383ed51000 rw-p 383ed4d000 00:00 0
383ee00000-383ee46000 r-xp 00000000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6
383ee46000-383f046000 ---p 00046000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6
383f046000-383f04c000 rw-p 00046000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6
3ec2200000-3ec2208000 r-xp 00000000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1
3ec2208000-3ec2407000 ---p 00008000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1
3ec2407000-3ec2408000 rw-p 00007000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1
3ec2600000-3ec262c000 r-xp 00000000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2
3ec262c000-3ec282c000 ---p 0002c000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2
3ec282c000-3ec282e000 rw-p 0002c000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2
3ec2a00000-3ec2a24000 r-xp 00000000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1
3ec2a24000-3ec2c23000 ---p 00024000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1
3ec2c23000-3ec2c25000 rw-p 00023000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1
3ec2e00000-3ec2e91000 r-xp 00000000 08:01 20289076 /usr/lib64/libkrb5.so.3.3
3ec2e91000-3ec3091000 ---p 00091000 08:01 20289076 /usr/lib64/libkrb5.so.3.3
3ec3091000-3ec3095000 rw-p 00091000 08:01 20289076 /usr/lib64/libkrb5.so.3.3
3ec3200000-3ec323b000 r-xp 00000000 08:01 13290831 /lib64/libsepol.so.1
3ec323b000-3ec343b000 ---p 0003b000 08:01 13290831 /lib64/libsepol.so.1
3ec343b000-3ec343c000 rw-p 0003b000 08:01 13290831 /lib64/libsepol.so.1
3ec343c000-3ec3446000 rw-p 3ec343c000 00:00 0
3ec3600000-3ec3615000 r-xp 00000000 08:01 13290833 /lib64/libselinux.so.1
3ec3615000-3ec3815000 ---p 00015000 08:01 13290833 /lib64/libselinux.so.1
3ec3815000-3ec3817000 rw-p 00015000 08:01 13290833 /lib64/libselinux.so.1
3ec3817000-3ec3818000 rw-p 3ec3817000 00:00 0
3ec3a00000-3ec3a09000 r-xp 00000000 08:01 13290835 /lib64/libcrypt-2.5.so
3ec3a09000-3ec3c08000 ---p 00009000 08:01 13290835 /lib64/libcrypt-2.5.so
3ec3c08000-3ec3c09000 r--p 00008000 08:01 13290835 /lib64/libcrypt-2.5.so
3ec3c09000-3ec3c0a000 rw-p 00009000 08:01 13290835 /lib64/libcrypt-2.5.so
3ec3c0a000-3ec3c38000 rw-p 3ec3c0a000 00:00 0
2ae529470000-2ae529472000 rw-p 2ae529470000 00:00 0
2ae529472000-2ae529495000 r-xp 00000000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5
2ae529495000-2ae529694000 ---p 00023000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5
2ae529694000-2ae529697000 rw-p 00022000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5
2ae529697000-2ae5296cd000 r-xp 00000000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1
2ae5296cd000-2ae5298cc000 ---p 00036000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1
2ae5298cc000-2ae5298ce000 rw-p 00035000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1
2ae5298ce000-2ae529a02000 r-xp 00000000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2
2ae529a02000-2ae529c01000 ---p 00134000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2
2ae529c01000-2ae529c0b000 rw-p 00133000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2
2ae529c0b000-2ae529c0c000 rw-p 2ae529c0b000 00:00 0
2ae529c2e000-2ae529c30000 rw-p 2ae529c2e000 00:00 0
2ae529c30000-2ae529c58000 r-xp 00000000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so
2ae529c58000-2ae529e57000 ---p 00028000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so
2ae529e57000-2ae529e5a000 rw-p 00027000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so
2ae529e5a000-2ae529e62000 rw-p 2ae529e5a000 00:00 0
2ae529e62000-2ae52d43b000 r--p 00000000 08:01 20267104 /usr/lib/locale/locale-archive
2ae52d43b000-2ae52d43c000 rw-p 2ae52d43b000 00:00 0
2ae52d45d000-2ae52d467000 r-xp 00000000 08:01 13290841 /lib64/libnss_files-2.5.so
2ae52d467000-2ae52d666000 ---p 0000a000 08:01 13290841 /lib64/libnss_files-2.5.so
2ae52d666000-2ae52d667000 r--p 00009000 08:01 13290841 /lib64/libnss_files-2.5.so
2ae52d667000-2ae52d668000 rw-p 0000a000 08:01 13290841 /lib64/libnss_files-2.5.so
7fff8aeee000-7fff8af03000 rw-p 7ffffffea000 00:00 0 [stack]
ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso]
Aborted
[root@ws-test 9.0SS]#
Any comments on this & how to resolve it.
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Small change replace all PG path with PPSS paths...
On Thu, May 19, 2011 at 4:46 PM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
Hi Adarsh,This isssue has fixed in PPSS latest version. However here is workaround for it.Step 1: Install Libedit module from Yum Repository.[root@239435-db9 ~]# yum install libedit.x86_64[root@239435-db9 ~]# rpm -q libedit.x86_64libedit-2.11-2.20080712cvs.el5Step 2: Identify the location of installed libedit binary location.[root@239435-db9 ~]# rpm -q libedit.x86_64 --filesbypkglibedit /usr/lib64/libedit.so.0libedit /usr/lib64/libedit.so.0.0.27libedit /usr/share/doc/libedit-2.11libedit /usr/share/doc/libedit-2.11/COPYINGlibedit /usr/share/doc/libedit-2.11/ChangeLoglibedit /usr/share/doc/libedit-2.11/THANKS[root@239435-db9 ~]# pwd/rootStep 3: Take the backup of bundled libedit binary[root@239435-db9 ~]# cd /opt/PostgreSQL/9.0/lib/[root@239435-db9 lib]# ls -l libedit*-rwxr-xr-- 1 root daemon 192738 Dec 14 04:46 libedit.so[root@239435-db9 lib]# mv libedit.so libedit.so.bkStep 4: Soft link the newly installed libedit binary to PostgreSQL installed location[root@239435-db9 lib]# ln -s /usr/lib64/libedit.so.0 /opt/PostgreSQL/9.0/lib/libedit.soNow try connecting to Server with psql...On Thu, May 19, 2011 at 4:39 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:Dear all,
Today I need to use crosstab function but Postgresql says that there is no function crosstab, so i try to install it by :
bin/psql -Upostgres test -f '/opt/PostgresPlus/9.0SS/share/postgresql/contrib/tablefunc.sql'
& it creates the functions.
But know when I issue any query in Postgres , don't know why this appears.
test=# select * from ct;
id | rowid | attribute | value
----+-------+-----------+-------
1 | test1 | att1 | val1
2 | test1 | att2 | val2
3 | test1 | att3 | val3
4 | test1 | att4 | val4
5 | test2 | att1 | val5
6 | test2 | att2 | val6
7 | test2 | att3 | val7
8 | test2 | att4 | val8
(8 rows)
*** glibc detected *** bin/psql: free(): invalid next size (fast): 0x000000000b684f40 ***
======= Backtrace: =========
/lib64/libc.so.6[0x34e9a722ef]
/lib64/libc.so.6(cfree+0x4b)[0x34e9a7273b]
bin/psql[0x4139b4]
bin/psql[0x414e44]
bin/psql[0x415a68]
bin/psql[0x408d82]
bin/psql[0x40d9d6]
bin/psql[0x40fa7e]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x34e9a1d994]
bin/psql[0x403a69]
======= Memory map: ========
00400000-00456000 r-xp 00000000 08:01 18267785 /opt/PostgresPlus/9.0SS/bin/psql
00655000-00656000 rw-p 00055000 08:01 18267785 /opt/PostgresPlus/9.0SS/bin/psql
00656000-00657000 rw-p 00656000 00:00 0
0b66d000-0b68e000 rw-p 0b66d000 00:00 0 [heap]
3485e00000-3485e03000 r-xp 00000000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2
3485e03000-3486002000 ---p 00003000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2
3486002000-3486003000 rw-p 00002000 08:01 18269363 /opt/PostgresPlus/9.0SS/lib/libtermcap.so.2
34e8a00000-34e8a1c000 r-xp 00000000 08:01 13291123 /lib64/ld-2.5.so
34e8c1b000-34e8c1c000 r--p 0001b000 08:01 13291123 /lib64/ld-2.5.so
34e8c1c000-34e8c1d000 rw-p 0001c000 08:01 13291123 /lib64/ld-2.5.so
34e9a00000-34e9b4d000 r-xp 00000000 08:01 13291124 /lib64/libc-2.5.so
34e9b4d000-34e9d4d000 ---p 0014d000 08:01 13291124 /lib64/libc-2.5.so
34e9d4d000-34e9d51000 r--p 0014d000 08:01 13291124 /lib64/libc-2.5.so
34e9d51000-34e9d52000 rw-p 00151000 08:01 13291124 /lib64/libc-2.5.so
34e9d52000-34e9d57000 rw-p 34e9d52000 00:00 0
34e9e00000-34e9e82000 r-xp 00000000 08:01 13291125 /lib64/libm-2.5.so
34e9e82000-34ea081000 ---p 00082000 08:01 13291125 /lib64/libm-2.5.so
34ea081000-34ea082000 r--p 00081000 08:01 13291125 /lib64/libm-2.5.so
34ea082000-34ea083000 rw-p 00082000 08:01 13291125 /lib64/libm-2.5.so
34ea200000-34ea202000 r-xp 00000000 08:01 13291130 /lib64/libdl-2.5.so
34ea202000-34ea402000 ---p 00002000 08:01 13291130 /lib64/libdl-2.5.so
34ea402000-34ea403000 r--p 00002000 08:01 13291130 /lib64/libdl-2.5.so
34ea403000-34ea404000 rw-p 00003000 08:01 13291130 /lib64/libdl-2.5.so
34ea600000-34ea616000 r-xp 00000000 08:01 13291126 /lib64/libpthread-2.5.so
34ea616000-34ea815000 ---p 00016000 08:01 13291126 /lib64/libpthread-2.5.so
34ea815000-34ea816000 r--p 00015000 08:01 13291126 /lib64/libpthread-2.5.so
34ea816000-34ea817000 rw-p 00016000 08:01 13291126 /lib64/libpthread-2.5.so
34ea817000-34ea81b000 rw-p 34ea817000 00:00 0
34eae00000-34eae14000 r-xp 00000000 08:01 20286121 /usr/lib64/libz.so.1.2.3
34eae14000-34eb013000 ---p 00014000 08:01 20286121 /usr/lib64/libz.so.1.2.3
34eb013000-34eb014000 rw-p 00013000 08:01 20286121 /usr/lib64/libz.so.1.2.3
34f2400000-34f2419000 r-xp 00000000 08:01 13291152 /lib64/libaudit.so.0.0.0
34f2419000-34f2618000 ---p 00019000 08:01 13291152 /lib64/libaudit.so.0.0.0
34f2618000-34f261a000 rw-p 00018000 08:01 13291152 /lib64/libaudit.so.0.0.0
34f3400000-34f3402000 r-xp 00000000 08:01 13291142 /lib64/libcom_err.so.2.1
34f3402000-34f3601000 ---p 00002000 08:01 13291142 /lib64/libcom_err.so.2.1
34f3601000-34f3602000 rw-p 00001000 08:01 13291142 /lib64/libcom_err.so.2.1
34f3c00000-34f3c11000 r-xp 00000000 08:01 13291139 /lib64/libresolv-2.5.so
34f3c11000-34f3e11000 ---p 00011000 08:01 13291139 /lib64/libresolv-2.5.so
34f3e11000-34f3e12000 r--p 00011000 08:01 13291139 /lib64/libresolv-2.5.so
34f3e12000-34f3e13000 rw-p 00012000 08:01 13291139 /lib64/libresolv-2.5.so
34f3e13000-34f3e15000 rw-p 34f3e13000 00:00 0
34f4000000-34f4002000 r-xp 00000000 08:01 13291138 /lib64/libkeyutils-1.2.so
34f4002000-34f4201000 ---p 00002000 08:01 13291138 /lib64/libkeyutils-1.2.so
34f4201000-34f4202000 rw-p 00001000 08:01 13291138 /lib64/libkeyutils-1.2.so
34f5c00000-34f5c0b000 r-xp 00000000 08:01 13291153 /lib64/libpam.so.0.81.5
34f5c0b000-34f5e0a000 ---p 0000b000 08:01 13291153 /lib64/libpam.so.0.81.5
34f5e0a000-34f5e0b000 rw-p 0000a000 08:01 13291153 /lib64/libpam.so.0.81.5
34fac00000-34fac0d000 r-xp 00000000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1
34fac0d000-34fae0d000 ---p 0000d000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1
34fae0d000-34fae0e000 rw-p 0000d000 08:01 13291147 /lib64/libgcc_s-4.1.2-20080825.so.1
383ea00000-383eb2d000 r-xp 00000000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6
383eb2d000-383ed2c000 ---p 0012d000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6
383ed2c000-383ed4d000 rw-p 0012c000 08:01 18269341 /opt/PostgresPlus/9.0SS/lib/libcrypto.so.6
383ed4d000-383ed51000 rw-p 383ed4d000 00:00 0
383ee00000-383ee46000 r-xp 00000000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6
383ee46000-383f046000 ---p 00046000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6
383f046000-383f04c000 rw-p 00046000 08:01 18269362 /opt/PostgresPlus/9.0SS/lib/libssl.so.6
3ec2200000-3ec2208000 r-xp 00000000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1
3ec2208000-3ec2407000 ---p 00008000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1
3ec2407000-3ec2408000 rw-p 00007000 08:01 20288482 /usr/lib64/libkrb5support.so.0.1
3ec2600000-3ec262c000 r-xp 00000000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2
3ec262c000-3ec282c000 ---p 0002c000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2
3ec282c000-3ec282e000 rw-p 0002c000 08:01 20289077 /usr/lib64/libgssapi_krb5.so.2.2
3ec2a00000-3ec2a24000 r-xp 00000000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1
3ec2a24000-3ec2c23000 ---p 00024000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1
3ec2c23000-3ec2c25000 rw-p 00023000 08:01 20289075 /usr/lib64/libk5crypto.so.3.1
3ec2e00000-3ec2e91000 r-xp 00000000 08:01 20289076 /usr/lib64/libkrb5.so.3.3
3ec2e91000-3ec3091000 ---p 00091000 08:01 20289076 /usr/lib64/libkrb5.so.3.3
3ec3091000-3ec3095000 rw-p 00091000 08:01 20289076 /usr/lib64/libkrb5.so.3.3
3ec3200000-3ec323b000 r-xp 00000000 08:01 13290831 /lib64/libsepol.so.1
3ec323b000-3ec343b000 ---p 0003b000 08:01 13290831 /lib64/libsepol.so.1
3ec343b000-3ec343c000 rw-p 0003b000 08:01 13290831 /lib64/libsepol.so.1
3ec343c000-3ec3446000 rw-p 3ec343c000 00:00 0
3ec3600000-3ec3615000 r-xp 00000000 08:01 13290833 /lib64/libselinux.so.1
3ec3615000-3ec3815000 ---p 00015000 08:01 13290833 /lib64/libselinux.so.1
3ec3815000-3ec3817000 rw-p 00015000 08:01 13290833 /lib64/libselinux.so.1
3ec3817000-3ec3818000 rw-p 3ec3817000 00:00 0
3ec3a00000-3ec3a09000 r-xp 00000000 08:01 13290835 /lib64/libcrypt-2.5.so
3ec3a09000-3ec3c08000 ---p 00009000 08:01 13290835 /lib64/libcrypt-2.5.so
3ec3c08000-3ec3c09000 r--p 00008000 08:01 13290835 /lib64/libcrypt-2.5.so
3ec3c09000-3ec3c0a000 rw-p 00009000 08:01 13290835 /lib64/libcrypt-2.5.so
3ec3c0a000-3ec3c38000 rw-p 3ec3c0a000 00:00 0
2ae529470000-2ae529472000 rw-p 2ae529470000 00:00 0
2ae529472000-2ae529495000 r-xp 00000000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5
2ae529495000-2ae529694000 ---p 00023000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5
2ae529694000-2ae529697000 rw-p 00022000 08:01 18269360 /opt/PostgresPlus/9.0SS/lib/libpq.so.5
2ae529697000-2ae5296cd000 r-xp 00000000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1
2ae5296cd000-2ae5298cc000 ---p 00036000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1
2ae5298cc000-2ae5298ce000 rw-p 00035000 08:01 18269367 /opt/PostgresPlus/9.0SS/lib/libxslt.so.1
2ae5298ce000-2ae529a02000 r-xp 00000000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2
2ae529a02000-2ae529c01000 ---p 00134000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2
2ae529c01000-2ae529c0b000 rw-p 00133000 08:01 18269366 /opt/PostgresPlus/9.0SS/lib/libxml2.so.2
2ae529c0b000-2ae529c0c000 rw-p 2ae529c0b000 00:00 0
2ae529c2e000-2ae529c30000 rw-p 2ae529c2e000 00:00 0
2ae529c30000-2ae529c58000 r-xp 00000000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so
2ae529c58000-2ae529e57000 ---p 00028000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so
2ae529e57000-2ae529e5a000 rw-p 00027000 08:01 18269350 /opt/PostgresPlus/9.0SS/lib/libedit.so
2ae529e5a000-2ae529e62000 rw-p 2ae529e5a000 00:00 0
2ae529e62000-2ae52d43b000 r--p 00000000 08:01 20267104 /usr/lib/locale/locale-archive
2ae52d43b000-2ae52d43c000 rw-p 2ae52d43b000 00:00 0
2ae52d45d000-2ae52d467000 r-xp 00000000 08:01 13290841 /lib64/libnss_files-2.5.so
2ae52d467000-2ae52d666000 ---p 0000a000 08:01 13290841 /lib64/libnss_files-2.5.so
2ae52d666000-2ae52d667000 r--p 00009000 08:01 13290841 /lib64/libnss_files-2.5.so
2ae52d667000-2ae52d668000 rw-p 0000a000 08:01 13290841 /lib64/libnss_files-2.5.so
7fff8aeee000-7fff8af03000 rw-p 7ffffffea000 00:00 0 [stack]
ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso]
Aborted
[root@ws-test 9.0SS]#
Any comments on this & how to resolve it.
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general