Re: psql causing a error

Lists: pgsql-admin
From: "Arnold, Sandra" <ArnoldS(at)osti(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: psql causing a error
Date: 2011-03-04 21:17:33
Message-ID: 54E5385D47A89542BC678F5426799F3904EED3A788@OSTIEX01.osti.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

All of a sudden the psql for 9.0 is giving me the error below. The dump is just a partial dump. Is this a known issue? It was working for about 4 days after I installed the software until around lunch time today. I did the install using the current one-click installer provided by EnterpriseDB.

*** glibc detected *** /app/PostgreSQL/9.0/bin/psql: free(): invalid next size (fast): 0x0000000015b46b20 ***
======= Backtrace: =========
/lib64/libc.so.6[0x358167230f]
/lib64/libc.so.6(cfree+0x4b)[0x358167276b]
/app/PostgreSQL/9.0/bin/psql[0x4139b4]
/app/PostgreSQL/9.0/bin/psql[0x414e44]
/app/PostgreSQL/9.0/bin/psql[0x415a68]
/app/PostgreSQL/9.0/bin/psql[0x408d82]
/app/PostgreSQL/9.0/bin/psql[0x40d9d6]
/app/PostgreSQL/9.0/bin/psql[0x40fa7e]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x358161d994]
/app/PostgreSQL/9.0/bin/psql[0x403a69]
======= Memory map: ========
00400000-00456000 r-xp 00000000 fd:01 691534 /app/PostgreSQL/9.0/bin/psql
00655000-00656000 rw-p 00055000 fd:01 691534 /app/PostgreSQL/9.0/bin/psql
00656000-00657000 rw-p 00656000 00:00 0
15b2e000-15b4f000 rw-p 15b2e000 00:00 0 [heap]
3485e00000-3485e03000 r-xp 00000000 fd:01 693115 /app/PostgreSQL/9.0/lib/libtermcap.so.2
3485e03000-3486002000 ---p 00003000 fd:01 693115 /app/PostgreSQL/9.0/lib/libtermcap.so.2
3486002000-3486003000 rw-p 00002000 fd:01 693115 /app/PostgreSQL/9.0/lib/libtermcap.so.2
354e400000-354e402000 r-xp 00000000 fd:00 229449 /lib64/libcom_err.so.2.1
354e402000-354e601000 ---p 00002000 fd:00 229449 /lib64/libcom_err.so.2.1
354e601000-354e602000 rw-p 00001000 fd:00 229449 /lib64/libcom_err.so.2.1
3581200000-358121c000 r-xp 00000000 fd:00 229379 /lib64/ld-2.5.so
358141b000-358141c000 r--p 0001b000 fd:00 229379 /lib64/ld-2.5.so
358141c000-358141d000 rw-p 0001c000 fd:00 229379 /lib64/ld-2.5.so
3581600000-358174e000 r-xp 00000000 fd:00 229386 /lib64/libc-2.5.so

Thanks,

Sandra Arnold
Senior Database Administrator
Contractor to DOE/OSTI
NCI, Inc.
Oak Ridge, TN
(865) 576-0054 (work)
(865) 567-7553 (cell)
arnolds(at)osti(dot)gov

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: "Arnold, Sandra" <ArnoldS(at)osti(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: psql causing a error
Date: 2011-03-05 10:57:28
Message-ID: AANLkTi=sUOVA=kc5jg3qas-EAGO9G4dbMkuV6KanJC=C@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

On Sat, Mar 5, 2011 at 2:47 AM, Arnold, Sandra <ArnoldS(at)osti(dot)gov> wrote:

> All of a sudden the psql for 9.0 is giving me the error below. The dump
> is just a partial dump. Is this a known issue? It was working for about 4
> days after I installed the software until around lunch time today. I did
> the install using the current one-click installer provided by EnterpriseDB.
>
>
> *** glibc detected *** /app/PostgreSQL/9.0/bin/psql: free(): invalid next
> size (fast): 0x0000000015b46b20 ***
> ======= Backtrace: =========
> /lib64/libc.so.6[0x358167230f]
> /lib64/libc.so.6(cfree+0x4b)[0x358167276b]
> /app/PostgreSQL/9.0/bin/psql[0x4139b4]
> /app/PostgreSQL/9.0/bin/psql[0x414e44]
> /app/PostgreSQL/9.0/bin/psql[0x415a68]
> /app/PostgreSQL/9.0/bin/psql[0x408d82]
> /app/PostgreSQL/9.0/bin/psql[0x40d9d6]
> /app/PostgreSQL/9.0/bin/psql[0x40fa7e]
> /lib64/libc.so.6(__libc_start_main+0xf4)[0x358161d994]
> /app/PostgreSQL/9.0/bin/psql[0x403a69]
> ======= Memory map: ========
> 00400000-00456000 r-xp 00000000 fd:01 691534
> /app/PostgreSQL/9.0/bin/psql
> 00655000-00656000 rw-p 00055000 fd:01 691534
> /app/PostgreSQL/9.0/bin/psql
> 00656000-00657000 rw-p 00656000 00:00 0
> 15b2e000-15b4f000 rw-p 15b2e000 00:00 0
> [heap]
> 3485e00000-3485e03000 r-xp 00000000 fd:01 693115
> /app/PostgreSQL/9.0/lib/libtermcap.so.2
> 3485e03000-3486002000 ---p 00003000 fd:01 693115
> /app/PostgreSQL/9.0/lib/libtermcap.so.2
> 3486002000-3486003000 rw-p 00002000 fd:01 693115
> /app/PostgreSQL/9.0/lib/libtermcap.so.2
> 354e400000-354e402000 r-xp 00000000 fd:00 229449
> /lib64/libcom_err.so.2.1
> 354e402000-354e601000 ---p 00002000 fd:00 229449
> /lib64/libcom_err.so.2.1
> 354e601000-354e602000 rw-p 00001000 fd:00 229449
> /lib64/libcom_err.so.2.1
> 3581200000-358121c000 r-xp 00000000 fd:00 229379
> /lib64/ld-2.5.so
> 358141b000-358141c000 r--p 0001b000 fd:00 229379
> /lib64/ld-2.5.so
> 358141c000-358141d000 rw-p 0001c000 fd:00 229379
> /lib64/ld-2.5.so
> 3581600000-358174e000 r-xp 00000000 fd:00 229386
> /lib64/libc-2.5.so
>
>
>

Please follow below steps to resolve this issue:

*Step 1:* Install Libedit module from Yum Repository.

[root(at)239435-db9 ~]# yum install libedit.x86_64

[root(at)239435-db9 ~]# rpm -q libedit.x86_64

libedit-2.11-2.20080712cvs.el5

*Step 2:* Identify the location of installed libedit binary location.

[root(at)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(at)239435-db9 ~]# pwd

/root

*Step 3*: Take the backup of bundled libedit binary

[root(at)239435-db9 ~]# cd /opt/PostgreSQL/9.0/lib/

[root(at)239435-db9 lib]# ls -l libedit*

-rwxr-xr-- 1 root daemon 192738 Dec 14 04:46 libedit.so

[root(at)239435-db9 lib]# mv libedit.so libedit.so.bk

*Step 4:* Soft link the newly installed libedit binary to PostgreSQL
installed location

[root(at)239435-db9 lib]# ln -s
/usr/lib64/libedit.so.0 /opt/PostgreSQL/9.0/lib/libedit.so

*Step 5:* Connect to the Database using PSQL binary.

--Raghu Ram

> Thanks,
>
> *Sandra Arnold*
> *Senior Database Administrator*
> *Contractor to DOE/OSTI*
> *NCI, Inc.*
> *Oak Ridge, TN*
> *(865) 576-0054 (work)*
> *(865) 567-7553 (cell)*
> *arnolds(at)osti(dot)gov*
>
>

From: "Arnold, Sandra" <ArnoldS(at)osti(dot)gov>
To: 'raghu ram' <raghuchennuru(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: psql causing a error
Date: 2011-03-07 17:00:48
Message-ID: 54E5385D47A89542BC678F5426799F3904EED3A792@OSTIEX01.osti.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

libedit.x86_64 does not show up in the yum library that we have access to. Can you point us to a location that we can get this without having to pull down the entire source?

Thanks,

Sandra Arnold
Senior Database Administrator
Contractor to DOE/OSTI
NCI, Inc

________________________________
From: raghu ram [mailto:raghuchennuru(at)gmail(dot)com]
Sent: Saturday, March 05, 2011 5:57 AM
To: Arnold, Sandra
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] psql causing a error

On Sat, Mar 5, 2011 at 2:47 AM, Arnold, Sandra <ArnoldS(at)osti(dot)gov<mailto:ArnoldS(at)osti(dot)gov>> wrote:
All of a sudden the psql for 9.0 is giving me the error below. The dump is just a partial dump. Is this a known issue? It was working for about 4 days after I installed the software until around lunch time today. I did the install using the current one-click installer provided by EnterpriseDB.

*** glibc detected *** /app/PostgreSQL/9.0/bin/psql: free(): invalid next size (fast): 0x0000000015b46b20 ***
======= Backtrace: =========
/lib64/libc.so.6[0x358167230f]
/lib64/libc.so.6(cfree+0x4b)[0x358167276b]
/app/PostgreSQL/9.0/bin/psql[0x4139b4]
/app/PostgreSQL/9.0/bin/psql[0x414e44]
/app/PostgreSQL/9.0/bin/psql[0x415a68]
/app/PostgreSQL/9.0/bin/psql[0x408d82]
/app/PostgreSQL/9.0/bin/psql[0x40d9d6]
/app/PostgreSQL/9.0/bin/psql[0x40fa7e]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x358161d994]
/app/PostgreSQL/9.0/bin/psql[0x403a69]
======= Memory map: ========
00400000-00456000 r-xp 00000000 fd:01 691534 /app/PostgreSQL/9.0/bin/psql
00655000-00656000 rw-p 00055000 fd:01 691534 /app/PostgreSQL/9.0/bin/psql
00656000-00657000 rw-p 00656000 00:00 0
15b2e000-15b4f000 rw-p 15b2e000 00:00 0 [heap]
3485e00000-3485e03000 r-xp 00000000 fd:01 693115 /app/PostgreSQL/9.0/lib/libtermcap.so.2
3485e03000-3486002000 ---p 00003000 fd:01 693115 /app/PostgreSQL/9.0/lib/libtermcap.so.2
3486002000-3486003000 rw-p 00002000 fd:01 693115 /app/PostgreSQL/9.0/lib/libtermcap.so.2
354e400000-354e402000 r-xp 00000000 fd:00 229449 /lib64/libcom_err.so.2.1
354e402000-354e601000 ---p 00002000 fd:00 229449 /lib64/libcom_err.so.2.1
354e601000-354e602000 rw-p 00001000 fd:00 229449 /lib64/libcom_err.so.2.1
3581200000-358121c000 r-xp 00000000 fd:00 229379 /lib64/ld-2.5.so<http://ld-2.5.so>
358141b000-358141c000 r--p 0001b000 fd:00 229379 /lib64/ld-2.5.so<http://ld-2.5.so>
358141c000-358141d000 rw-p 0001c000 fd:00 229379 /lib64/ld-2.5.so<http://ld-2.5.so>
3581600000-358174e000 r-xp 00000000 fd:00 229386 /lib64/libc-2.5.so<http://libc-2.5.so>

Please follow below steps to resolve this issue:

Step 1: Install Libedit module from Yum Repository.

[root(at)239435-db9 ~]# yum install libedit.x86_64

[root(at)239435-db9 ~]# rpm -q libedit.x86_64

libedit-2.11-2.20080712cvs.el5

Step 2: Identify the location of installed libedit binary location.

[root(at)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(at)239435-db9 ~]# pwd

/root

Step 3: Take the backup of bundled libedit binary

[root(at)239435-db9 ~]# cd /opt/PostgreSQL/9.0/lib/

[root(at)239435-db9 lib]# ls -l libedit*

-rwxr-xr-- 1 root daemon 192738 Dec 14 04:46 libedit.so

[root(at)239435-db9 lib]# mv libedit.so libedit.so.bk

Step 4: Soft link the newly installed libedit binary to PostgreSQL installed location

[root(at)239435-db9 lib]# ln -s /usr/lib64/libedit.so.0 /opt/PostgreSQL/9.0/lib/libedit.so

Step 5: Connect to the Database using PSQL binary.

--Raghu Ram

Thanks,

Sandra Arnold
Senior Database Administrator
Contractor to DOE/OSTI
NCI, Inc.
Oak Ridge, TN
(865) 576-0054 (work)
(865) 567-7553 (cell)
arnolds(at)osti(dot)gov<mailto:arnolds(at)osti(dot)gov>

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: "Arnold, Sandra" <ArnoldS(at)osti(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: psql causing a error
Date: 2011-03-07 18:06:56
Message-ID: AANLkTin2wBgXWLT07u_PUHHvamJpB-Vok-XnOcpKjGe6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

On Mon, Mar 7, 2011 at 10:30 PM, Arnold, Sandra <ArnoldS(at)osti(dot)gov> wrote:

> libedit.x86_64 does not show up in the yum library that we have access
> to. Can you point us to a location that we can get this without having to
> pull down the entire source?
>
>

Please try to download libedit binary using below link::

http://pkgs.org/download/centos-5-rhel-5/rpmforge-x86_64/libedit-20090923-3.0_1.el5.rf.x86_64.rpm.html

--Raghu Ram

> Thanks,
>
> *Sandra Arnold
> Senior Database Administrator*
> *Contractor to DOE/OSTI*
> *NCI, Inc*
>
>
> ------------------------------
> *From:* raghu ram [mailto:raghuchennuru(at)gmail(dot)com]
> *Sent:* Saturday, March 05, 2011 5:57 AM
> *To:* Arnold, Sandra
> *Cc:* pgsql-admin(at)postgresql(dot)org
> *Subject:* Re: [ADMIN] psql causing a error
>
>
>
> On Sat, Mar 5, 2011 at 2:47 AM, Arnold, Sandra <ArnoldS(at)osti(dot)gov> wrote:
>
>> All of a sudden the psql for 9.0 is giving me the error below. The dump
>> is just a partial dump. Is this a known issue? It was working for about 4
>> days after I installed the software until around lunch time today. I did
>> the install using the current one-click installer provided by EnterpriseDB.
>>
>>
>> *** glibc detected *** /app/PostgreSQL/9.0/bin/psql: free(): invalid next
>> size (fast): 0x0000000015b46b20 ***
>> ======= Backtrace: =========
>> /lib64/libc.so.6[0x358167230f]
>> /lib64/libc.so.6(cfree+0x4b)[0x358167276b]
>> /app/PostgreSQL/9.0/bin/psql[0x4139b4]
>> /app/PostgreSQL/9.0/bin/psql[0x414e44]
>> /app/PostgreSQL/9.0/bin/psql[0x415a68]
>> /app/PostgreSQL/9.0/bin/psql[0x408d82]
>> /app/PostgreSQL/9.0/bin/psql[0x40d9d6]
>> /app/PostgreSQL/9.0/bin/psql[0x40fa7e]
>> /lib64/libc.so.6(__libc_start_main+0xf4)[0x358161d994]
>> /app/PostgreSQL/9.0/bin/psql[0x403a69]
>> ======= Memory map: ========
>> 00400000-00456000 r-xp 00000000 fd:01 691534
>> /app/PostgreSQL/9.0/bin/psql
>> 00655000-00656000 rw-p 00055000 fd:01 691534
>> /app/PostgreSQL/9.0/bin/psql
>> 00656000-00657000 rw-p 00656000 00:00 0
>> 15b2e000-15b4f000 rw-p 15b2e000 00:00 0
>> [heap]
>> 3485e00000-3485e03000 r-xp 00000000 fd:01 693115
>> /app/PostgreSQL/9.0/lib/libtermcap.so.2
>> 3485e03000-3486002000 ---p 00003000 fd:01 693115
>> /app/PostgreSQL/9.0/lib/libtermcap.so.2
>> 3486002000-3486003000 rw-p 00002000 fd:01 693115
>> /app/PostgreSQL/9.0/lib/libtermcap.so.2
>> 354e400000-354e402000 r-xp 00000000 fd:00 229449
>> /lib64/libcom_err.so.2.1
>> 354e402000-354e601000 ---p 00002000 fd:00 229449
>> /lib64/libcom_err.so.2.1
>> 354e601000-354e602000 rw-p 00001000 fd:00 229449
>> /lib64/libcom_err.so.2.1
>> 3581200000-358121c000 r-xp 00000000 fd:00 229379
>> /lib64/ld-2.5.so
>> 358141b000-358141c000 r--p 0001b000 fd:00 229379
>> /lib64/ld-2.5.so
>> 358141c000-358141d000 rw-p 0001c000 fd:00 229379
>> /lib64/ld-2.5.so
>> 3581600000-358174e000 r-xp 00000000 fd:00 229386
>> /lib64/libc-2.5.so
>>
>>
>>
>
> Please follow below steps to resolve this issue:
>
> *Step 1:* Install Libedit module from Yum Repository.
>
>
> [root(at)239435-db9 ~]# yum install libedit.x86_64
>
>
>
>
> [root(at)239435-db9 ~]# rpm -q libedit.x86_64
>
> libedit-2.11-2.20080712cvs.el5
>
>
> *Step 2:* Identify the location of installed libedit binary location.
>
>
> [root(at)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(at)239435-db9 ~]# pwd
>
> /root
>
>
> *Step 3*: Take the backup of bundled libedit binary
>
>
> [root(at)239435-db9 ~]# cd /opt/PostgreSQL/9.0/lib/
>
>
>
> [root(at)239435-db9 lib]# ls -l libedit*
>
> -rwxr-xr-- 1 root daemon 192738 Dec 14 04:46 libedit.so
>
>
> [root(at)239435-db9 lib]# mv libedit.so libedit.so.bk
>
>
> *Step 4:* Soft link the newly installed libedit binary to PostgreSQL
> installed location
>
>
> [root(at)239435-db9 lib]# ln -s
> /usr/lib64/libedit.so.0 /opt/PostgreSQL/9.0/lib/libedit.so
>
>
> *Step 5:* Connect to the Database using PSQL binary.
>
>
> --Raghu Ram
>
>
>
>
>> Thanks,
>>
>> *Sandra Arnold*
>> *Senior Database Administrator*
>> *Contractor to DOE/OSTI*
>> *NCI, Inc.*
>> *Oak Ridge, TN*
>> *(865) 576-0054 (work)*
>> *(865) 567-7553 (cell)*
>> *arnolds(at)osti(dot)gov*
>>
>>
>
>

From: Bill Teluk <bill(dot)teluk(at)team(dot)telstra(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql causing a error
Date: 2011-03-22 03:56:27
Message-ID: 1300766187565-4248901.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hi Raghu and thanks!,
This fix helped me too.
My installation is an OpenSCG PostgreSQL 9.0.3 build with PostGIS 1.5.2
installed; and as per Sandra - the installation worked fine for several days
then failed - I got mine going again the first time by multiple restarts and
some port config changes, but the second time I looked further and found
this post. Each time I had a failure on mine, it was triggered by loading
an SQL script via "psql -f" generated by the shp2pgsql utility that ships
with PostGIS v1.5.2 - the script looked fine to me though (and deleting the
tables generated by it failed to restore operation.) Also, pgAdmin
(v1.12.2) seemed to work OK where psql wouldn't.
Regards, Bill.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/psql-causing-a-error-tp3410159p4248901.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.