Обсуждение: psql crash on 9.6.16

Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | ( 734-384-6403 | |  ) 7349151444  | * Scot.Kreienkamp@la-z-boy.com
www.la-z-boy.com  | facebook.com/lazboy  | twitter.com/lazboy | youtube.com/lazboy

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by e-mail or by telephone at the above number. Thank you.

On 3/16/20 7:48 AM, Scot Kreienkamp wrote:
> I was using psql to connect to the local database for a simple update 
> this morning and it crashed.  Here’s what was printed out after the 
> crash.  I was not able to re-create it.

I don't have an answer, just some questions:

1) OS and version of same?

2) Where you using the 9.6 version of psql?

3) What was the connection string that you supplied to psql?

> 
> rms =# update userlogin set firstname='namechanged', 
> lastname='namechanged' where userloginid='1598113';
> 
> UPDATE 1
> 
> rms =# select * from userlogin where userloginid='1598113';
> 
> *** Error in `psql': free(): invalid pointer: 0x0000000001bc64e0 ***
> 
> ======= Backtrace: =========
> 
> /lib64/libc.so.6(+0x816b9)[0x7fa5e4b106b9]
> 
> /lib64/libreadline.so.6(rl_do_undo+0x1bd)[0x7fa5e5188abd]
> 
> /lib64/libreadline.so.6(rl_revert_line+0x15)[0x7fa5e5188c65]
> 
> /lib64/libreadline.so.6(readline_internal_teardown+0x66)[0x7fa5e5174286]
> 
> /lib64/libreadline.so.6(readline+0x82)[0x7fa5e51750e2]
> 
> psql[0x40f9e5]
> 
> psql[0x410412]
> 
> psql[0x405ac1]
> 
> /lib64/libc.so.6(__libc_start_main+0xf5)[0x7fa5e4ab1545]
> 
> psql[0x405c2a]
> 
> ======= Memory map: ========
> 
> 00400000-00480000 r-xp 00000000 fd:00 134383438                          
> /usr/pgsql-9.6/bin/psql
> 
> 0067f000-00680000 r--p 0007f000 fd:00 134383438                          
> /usr/pgsql-9.6/bin/psql
> 
> 00680000-00681000 rw-p 00080000 fd:00 134383438                          
> /usr/pgsql-9.6/bin/psql
> 
> 00681000-00682000 rw-p 00000000 00:00 0
> 
> 01b97000-01bd9000 rw-p 00000000 00:00 0                                  
> [heap]
> 
> 7fa5d4000000-7fa5d4021000 rw-p 00000000 00:00 0
> 
> 7fa5d4021000-7fa5d8000000 ---p 00000000 00:00 0
> 
> 7fa5da0f0000-7fa5da105000 r-xp 00000000 fd:00 67546789                   
> /usr/lib64/libgcc_s-4.8.5-20150702.so.1
> 
> 7fa5da105000-7fa5da304000 ---p 00015000 fd:00 67546789                   
> /usr/lib64/libgcc_s-4.8.5-20150702.so.1
> 
> 7fa5da304000-7fa5da305000 r--p 00014000 fd:00 67546789                   
> /usr/lib64/libgcc_s-4.8.5-20150702.so.1
> 
> 7fa5da305000-7fa5da306000 rw-p 00015000 fd:00 67546789                   
> /usr/lib64/libgcc_s-4.8.5-20150702.so.1
> 
> 7fa5da306000-7fa5da312000 r-xp 00000000 fd:00 67259454                   
> /usr/lib64/libnss_files-2.17.so
> 
> 7fa5da312000-7fa5da511000 ---p 0000c000 fd:00 67259454                   
> /usr/lib64/libnss_files-2.17.so
> 
> 7fa5da511000-7fa5da512000 r--p 0000b000 fd:00 67259454                   
> /usr/lib64/libnss_files-2.17.so
> 
> 7fa5da512000-7fa5da513000 rw-p 0000c000 fd:00 67259454                   
> /usr/lib64/libnss_files-2.17.so
> 
> 7fa5da513000-7fa5da519000 rw-p 00000000 00:00 0
> 
> 7fa5da519000-7fa5e0a43000 r--p 00000000 fd:00 201551822                  
> /usr/lib/locale/locale-archive
> 
> 7fa5e0a43000-7fa5e0a45000 r-xp 00000000 fd:00 67252476                   
> /usr/lib64/libfreebl3.so
> 
> 7fa5e0a45000-7fa5e0c44000 ---p 00002000 fd:00 67252476                   
> /usr/lib64/libfreebl3.so
> 
> 7fa5e0c44000-7fa5e0c45000 r--p 00001000 fd:00 67252476                   
> /usr/lib64/libfreebl3.so
> 
> 7fa5e0c45000-7fa5e0c46000 rw-p 00002000 fd:00 67252476                   
> /usr/lib64/libfreebl3.so
> 
> 7fa5e0c46000-7fa5e0ca6000 r-xp 00000000 fd:00 67252693                   
> /usr/lib64/libpcre.so.1.2.0
> 
> 7fa5e0ca6000-7fa5e0ea6000 ---p 00060000 fd:00 67252693                   
> /usr/lib64/libpcre.so.1.2.0
> 
> 7fa5e0ea6000-7fa5e0ea7000 r--p 00060000 fd:00 67252693                
>     /usr/lib64/libpcre.so.1.2.0
> 
> 7fa5e0ea7000-7fa5e0ea8000 rw-p 00061000 fd:00 67252693                   
> /usr/lib64/libpcre.so.1.2.0
> 
> 7fa5e0ea8000-7fa5e0eaf000 r-xp 00000000 fd:00 69021578                   
> /usr/lib64/librt-2.17.so
> 
> 7fa5e0eaf000-7fa5e10ae000 ---p 00007000 fd:00 69021578                   
> /usr/lib64/librt-2.17.so
> 
> 7fa5e10ae000-7fa5e10af000 r--p 00006000 fd:00 69021578                   
> /usr/lib64/librt-2.17.so
> 
> 7fa5e10af000-7fa5e10b0000 rw-p 00007000 fd:00 69021578                   
> /usr/lib64/librt-2.17.so
> 
> 7fa5e10b0000-7fa5e10b8000 r-xp 00000000 fd:00 67242996                   
> /usr/lib64/libcrypt-2.17.so
> 
> 7fa5e10b8000-7fa5e12b7000 ---p 00008000 fd:00 67242996                   
> /usr/lib64/libcrypt-2.17.so
> 
> 7fa5e12b7000-7fa5e12b8000 r--p 00007000 fd:00 67242996                   
> /usr/lib64/libcrypt-2.17.so
> 
> 7fa5e12b8000-7fa5e12b9000 rw-p 00008000 fd:00 67242996                   
> /usr/lib64/libcrypt-2.17.so
> 
> 7fa5e12b9000-7fa5e12e7000 rw-p 00000000 00:00 0
> 
> 7fa5e12e7000-7fa5e130b000 r-xp 00000000 fd:00 67252633                   
> /usr/lib64/libselinux.so.1
> 
> 7fa5e130b000-7fa5e150a000 ---p 00024000 fd:00 67252633                   
> /usr/lib64/libselinux.so.1
> 
> 7fa5e150a000-7fa5e150b000 r--p 00023000 fd:00 67252633                   
> /usr/lib64/libselinux.so.1
> 
> 7fa5e150b000-7fa5e150c000 rw-p 00024000 fd:00 67252633                   
> /usr/lib64/libselinux.so.1
> 
> 7fa5e150c000-7fa5e150e000 rw-p 00000000 00:00 0
> 
> 7fa5e150e000-7fa5e1548000 r-xp 00000000 fd:00 67243008                   
> /usr/lib64/libnspr4.so
> 
> 7fa5e1548000-7fa5e1747000 ---p 0003a000 fd:00 67243008                   
> /usr/lib64/libnspr4.so
> 
> 7fa5e1747000-7fa5e1748000 r--p 00039000 fd:00 67243008                   
> /usr/lib64/libnspr4.so
> 
> 7fa5e1748000-7fa5e174a000 rw-p 0003a000 fd:00 67243008                   
> /usr/lib64/libnspr4.so
> 
> 7fa5e174a000-7fa5e174c000 rw-p 00000000 00:00 0
> 
> 7fa5e174c000-7fa5e1750000 r-xp 00000000 fd:00 69021712                   
> /usr/lib64/libplc4.so
> 
> 7fa5e1750000-7fa5e194f000 ---p 00004000 fd:00 69021712                   
> /usr/lib64/libplc4.so
> 
> 7fa5e194f000-7fa5e1950000 r--p 00003000 fd:00 69021712                   
> /usr/lib64/libplc4.so
> 
> 7fa5e1950000-7fa5e1951000 rw-p 00004000 fd:00 69021712            
>         /usr/lib64/libplc4.so
> 
> 7fa5e1951000-7fa5e1954000 r-xp 00000000 fd:00 69021714                   
> /usr/lib64/libplds4.so
> 
> 7fa5e1954000-7fa5e1b53000 ---p 00003000 fd:00 69021714                   
> /usr/lib64/libplds4.so
> 
> 7fa5e1b53000-7fa5e1b54000 r--p 00002000 fd:00 69021714                   
> /usr/lib64/libplds4.so
> 
> 7fa5e1b54000-7fa5e1b55000 rw-p 00003000 fd:00 69021714                   
> /usr/lib64/libplds4.so
> 
> 7fa5e1b55000-7fa5e1b7e000 r-xp 00000000 fd:00 67246665                   
> /usr/lib64/libnssutil3.so
> 
> 7fa5e1b7e000-7fa5e1d7d000 ---p 00029000 fd:00 67246665                   
> /usr/lib64/libnssutil3.so
> 
> 7fa5e1d7d000-7fa5e1d84000 r--p 00028000 fd:00 67246665                   
> /usr/lib64/libnssutil3.so
> 
> 7fa5e1d84000-7fa5e1d85000 rw-p 0002f000 fd:00 67246665    
>                 /usr/lib64/libnssutil3.so
> 
> 7fa5e1d85000-7fa5e1eab000 r-xp 00000000 fd:00 67252506                   
> /usr/lib64/libnss3.so
> 
> 7fa5e1eab000-7fa5e20ab000 ---p 00126000 fd:00 67252506                   
> /usr/lib64/libnss3.so
> 
> 7fa5e20ab000-7fa5e20b0000 r--p 00126000 fd:00 67252506                   
> /usr/lib64/libnss3.so
> 
> 7fa5e20b0000-7fa5e20b2000 rw-p 0012b000 fd:00 67252506                   
> /usr/lib64/libnss3.so
> 
> 7fa5e20b2000-7fa5e20b4000 rw-p 00000000 00:00 0
> 
> 7fa5e20b4000-7fa5e20d9000 r-xp 00000000 fd:00 67252510                   
> /usr/lib64/libsmime3.so
> 
> 7fa5e20d9000-7fa5e22d8000 ---p 00025000 fd:00 67252510                   
> /usr/lib64/libsmime3.soAborted
> 
> *Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate*
> One La-Z-Boy Drive | Monroe, Michigan 48162 |( 734-384-6403 | | ) 
> 7349151444 | * Scot.Kreienkamp@la-z-boy.com
> www.la-z-boy.com <http://www.la-z-boy.com> | facebook.com/lazboy 
> <http://facebook.com/lazboy>  | twitter.com/lazboy 
> <http://twitter.com/lazboy>| youtube.com/lazboy <http://youtube.com/lazboy>
> 
> This message is intended only for the individual or entity to which it
> is addressed. It may contain privileged, confidential information which 
> is exempt from disclosure under applicable laws. If you are not the 
> intended recipient, you are strictly prohibited from disseminating or 
> distributing this information (other than to the intended recipient) or 
> copying this information. If you have received this communication in 
> error, please notify us immediately by e-mail or by telephone at the 
> above number. Thank you.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com> writes:
> I was using psql to connect to the local database for a simple update this morning and it crashed.  Here's what was
printedout after the crash.  I was not able to re-create it. 

Hm, the backtrace says the problem is somewhere inside libreadline,
which means it has nothing to do with any SQL-level concepts, but
rather with editing your input text.  Did you do anything unusual
while typing that line of input --- say, recall it from history,
or edit it in a way that you don't usually do, or even mistype
some control character you don't usually type?

Sadly, the visible evidence here doesn't tell us much of anything
about what provoked the crash :-(

FWIW, there's a pretty good chance that this isn't psql's fault
per se, but a libreadline bug.  You might check to see if you can
get a newer readline version installed.

            regards, tom lane

I don't have an answer, just some questions:
No problem, wasn't looking for an answer, just trying to help by reporting it.


1) OS and version of same?
RHEL7.7

2) Where you using the 9.6 version of psql?
Yes, 9.6.16 client and server, installed via RPM from the official repo packages.

3) What was the connection string that you supplied to psql?
No connection string, so connected via socket.  Psql -d rms.



Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | Office: 734-384-6403 | Fax:  | Mobile: 7349151444 | E-mail:
Scot.Kreienkamp@la-z-boy.com

?
?

This message is intended only for the individual or entity to which it is addressed. It may contain privileged,
confidentialinformation which is exempt from disclosure under applicable laws. If you are not the intended recipient,
youare strictly prohibited from disseminating or distributing this information (other than to the intended recipient)
orcopying this information. If you have received this communication in error, please notify us immediately by e-mail or
bytelephone at the above number. Thank you.  

Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive | Monroe, Michigan 48162 | Office: 734-384-6403 | Fax:  | Mobile: 7349151444 | E-mail:
Scot.Kreienkamp@la-z-boy.com

?
?
-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Monday, March 16, 2020 11:40 AM
To: Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: psql crash on 9.6.16

ATTENTION:   This email was sent to La-Z-Boy from an external source.     Be vigilant when opening attachments or
clickinglinks. 

Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com> writes:
> I was using psql to connect to the local database for a simple update this morning and it crashed.  Here's what was
printedout after the crash.  I was not able to re-create it. 

Hm, the backtrace says the problem is somewhere inside libreadline,
which means it has nothing to do with any SQL-level concepts, but
rather with editing your input text.  Did you do anything unusual
while typing that line of input --- say, recall it from history,
or edit it in a way that you don't usually do, or even mistype
some control character you don't usually type?

Sadly, the visible evidence here doesn't tell us much of anything
about what provoked the crash :-(

FWIW, there's a pretty good chance that this isn't psql's fault
per se, but a libreadline bug.  You might check to see if you can
get a newer readline version installed.

            regards, tom lane

[Scot Kreienkamp]
Nothing unusual that I can think of.  I typed it in by hand, the update succeeded, and I was able to recall it and run
itagain from history with no crash.   

This message is intended only for the individual or entity to which it is addressed. It may contain privileged,
confidentialinformation which is exempt from disclosure under applicable laws. If you are not the intended recipient,
youare strictly prohibited from disseminating or distributing this information (other than to the intended recipient)
orcopying this information. If you have received this communication in error, please notify us immediately by e-mail or
bytelephone at the above number. Thank you.  

On 3/16/20 12:32 PM, Scot Kreienkamp wrote:

> 
> Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com> writes:
>> I was using psql to connect to the local database for a simple update this morning and it crashed.  Here's what was
printedout after the crash.  I was not able to re-create it.
 
> 
> Hm, the backtrace says the problem is somewhere inside libreadline,
> which means it has nothing to do with any SQL-level concepts, but
> rather with editing your input text.  Did you do anything unusual
> while typing that line of input --- say, recall it from history,
> or edit it in a way that you don't usually do, or even mistype
> some control character you don't usually type?
> 
> Sadly, the visible evidence here doesn't tell us much of anything
> about what provoked the crash :-(
> 
> FWIW, there's a pretty good chance that this isn't psql's fault
> per se, but a libreadline bug.  You might check to see if you can
> get a newer readline version installed.
> 
>             regards, tom lane
> 
> [Scot Kreienkamp]
> Nothing unusual that I can think of.  I typed it in by hand, the update succeeded, and I was able to recall it and
runit again from history with no crash.
 
> 

How did you get to the SELECT statement that ultimately crashed the session?


-- 
Adrian Klaver
adrian.klaver@aklaver.com