Re: psql crash on 9.6.16

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(dot)Kreienkamp(at)la-z-boy(dot)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(dot)klaver(at)aklaver(dot)com