Re: BUG #15653: pg_detoast_datum_packed problem

Hi,

GDB BACKTRACE
-------------
GNU gdb (GDB) 8.2.1
Copyright (C) 2018 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later
<http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-pc-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
    <http://www.gnu.org/software/gdb/documentation/>.

For help, type "help".
Type "apropos word" to search for commands related to "word"...
vk qt5printers
vk wx5printers
vk libpython
sys.version_info(major=3, minor=7, micro=2, releaselevel='final', serial=0)
Reading symbols from
/mnt/sdd1/home/src/postgresql-devel/20190222/bin/postgres...done.
[New LWP 4815]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/usr/lib/libthread_db.so.1".
Core was generated by `postgres: vlada ispp-pionir-test ::1(33336)
SELECT                            '.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x00007f8888d24f10 in __memcpy_ssse3 () from /usr/lib/libc.so.6
(gdb) bt
#0  0x00007f8888d24f10 in __memcpy_ssse3 () from /usr/lib/libc.so.6
#1  0x00007f8889e615ce in pg_bvarchar (fcinfo=0x560c6689fa40) at
vkBytea.c:137
#2  0x0000560c6503478c in ExecInterpExpr (state=0x560c6689f488,
econtext=0x560c6689e910, isnull=0x7ffe0538847f)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/execExprInterp.c:649
#3  0x0000560c6503672b in ExecInterpExprStillValid
(state=0x560c6689f488, econtext=0x560c6689e910, isNull=0x7ffe0538847f)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/execExprInterp.c:1769
#4  0x0000560c6504ccad in ExecEvalExprSwitchContext
(state=0x560c6689f488, econtext=0x560c6689e910, isNull=0x7ffe0538847f)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/include/executor/executor.h:308
#5  0x0000560c6504cddd in ExecQual (state=0x560c6689f488,
econtext=0x560c6689e910)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/include/executor/executor.h:377
#6  0x0000560c6504d0d2 in ExecScan (node=0x560c6689e7f8,
accessMtd=0x560c65080e57 <SeqNext>, recheckMtd=0x560c65080f20 <SeqRecheck>)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/execScan.c:190
#7  0x0000560c65080f6e in ExecSeqScan (pstate=0x560c6689e7f8)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/nodeSeqscan.c:129
#8  0x0000560c6504ad76 in ExecProcNodeFirst (node=0x560c6689e7f8)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/execProcnode.c:445
#9  0x0000560c65082510 in ExecProcNode (node=0x560c6689e7f8)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/include/executor/executor.h:241
#10 0x0000560c65082656 in ExecSort (pstate=0x560c6689e5e0)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/nodeSort.c:107
#11 0x0000560c6504ad76 in ExecProcNodeFirst (node=0x560c6689e5e0)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/execProcnode.c:445
#12 0x0000560c6503f1f9 in ExecProcNode (node=0x560c6689e5e0)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/include/executor/executor.h:241
#13 0x0000560c65041be1 in ExecutePlan (estate=0x560c6689e388,
planstate=0x560c6689e5e0, use_parallel_mode=false, operation=CMD_SELECT,
sendTuples=true,
    numberTuples=0, direction=ForwardScanDirection,
dest=0x560c668ef3c8, execute_once=true)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/execMain.c:1644
#14 0x0000560c6503f871 in standard_ExecutorRun
(queryDesc=0x560c6693aab8, direction=ForwardScanDirection, count=0,
execute_once=true)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/execMain.c:362
#15 0x0000560c6503f695 in ExecutorRun (queryDesc=0x560c6693aab8,
direction=ForwardScanDirection, count=0, execute_once=true)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/executor/execMain.c:306
#16 0x0000560c65256540 in PortalRunSelect (portal=0x560c66824048,
forward=true, count=0, dest=0x560c668ef3c8)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/tcop/pquery.c:929
--Type <RET> for more, q to quit, c to continue without paging--
#17 0x0000560c6525615f in PortalRun (portal=0x560c66824048,
count=9223372036854775807, isTopLevel=true, run_once=true,
dest=0x560c668ef3c8,
    altdest=0x560c668ef3c8, completionTag=0x7ffe05388950 "") at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/tcop/pquery.c:770
#18 0x0000560c6524f797 in exec_simple_query (
    query_string=0x560c667b5528 "RELEASE _EXEC_SVP_0x4f3870;SAVEPOINT
_EXEC_SVP_0x4f3870;select *,OID from ispp_wmpl where
(bvarchar(key))>=(bvarchar('W '::varchar)) and
(bvarchar(key))<=(bvarchar('W", '~' <repeats 11 times>, "'::varchar)) 
order by key")
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/tcop/postgres.c:1215
#19 0x0000560c652541a6 in PostgresMain (argc=1, argv=0x560c667ae488,
dbname=0x560c667e1e68 "ispp-pionir-test", username=0x560c667e4020 "vlada")
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/tcop/postgres.c:4256
#20 0x0000560c651a4be9 in BackendRun (port=0x560c667db6f0)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/postmaster/postmaster.c:4382
#21 0x0000560c651a42d1 in BackendStartup (port=0x560c667db6f0)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/postmaster/postmaster.c:4073
#22 0x0000560c651a020d in ServerLoop () at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/postmaster/postmaster.c:1703
#23 0x0000560c6519f999 in PostmasterMain (argc=3, argv=0x560c667ac3c0)
    at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/postmaster/postmaster.c:1376
#24 0x0000560c650b941c in main (argc=3, argv=0x560c667ac3c0) at
/mnt/sdd1/home/src/postgresql-devel/postgresql-git/postgresql/src/backend/main/main.c:228
(gdb)

Vladimir Koković, DP senior(69)
Belgrade, Mar. 1 2019

On 25.2.19. 17:37, gmail Vladimir Koković wrote:
> The complete primer and source in tar.gz
>
> On 23.2.19. 21:43, PG Bug reporting form wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference:      15653
>> Logged by:          Vladimir Kokovic
>> Email address:      vladimir(dot)kokovic(at)gmail(dot)com
>> PostgreSQL version: Unsupported/Unknown
>> Operating system:   linux manjaro
>> Description:
>>
>> This bug I have to report only for sentimental reasons because vkBytea
>> system exists since the version of PostgreSQL 7.4!
>> vkBytea system serves to restore all elemental PostgreSQL types in bytea
>> form.
>> It survived all versions in the meantime so that current GIT HEAD would
>> report SIGSEGV to the pg_bvarchar method.
>> My impression is that the problem is in the method
>> pg_detoast_datum_packed
>> but i do not understand the reason why.  select * return all rows OK.
>>
>> The complete primer and source in tar.gz will be sent later.
>>
>
>