Regress test case Error on PG14.19 #175
Description
Hi, I found some errors for load_check test case.
- There have ERRORS for regress testing case load_check when using bulkload V3.1.22 on PG14.19.
- Result for regress test case is:
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test init ... ok 3819 ms
test load_bin ... ok 3440 ms
test load_csv ... ok 1643 ms
test load_remote ... ok 568 ms
test load_function ... ok 4516 ms
test load_encoding ... ok 1147 ms
test load_check ... FAILED (test process exited with exit code 2) 290 ms
test load_filter ... FAILED (test process exited with exit code 2) 42 ms
test load_parallel ... FAILED (test process exited with exit code 2) 46 ms
test write_bin ... FAILED (test process exited with exit code 2) 25 ms
=======================
4 of 10 tests failed.
- The detail error is.
Core backtrace :
Core was generated by `postgres: postgres contrib_regression [local]'.
Program terminated with signal 6, Aborted.
#0 0x00007f98cf56f387 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install glibc-2.17-326.el7_9.3.x86_64 nspr-4.35.0-1.el7_9.x86_64 nss-3.90.0-2.el7_9.x86_64 nss-softokn-freebl-3.90.0-6.el7_9.x86_64 nss-util-3.90.0-1.el7_9.x86_64
(gdb) bt
#0 0x00007f98cf56f387 in raise () from /lib64/libc.so.6
#1 0x00007f98cf570a78 in abort () from /lib64/libc.so.6
#2 0x0000000000b253bf in ExceptionalCondition (
conditionName=0xbbc378 "!XLogRecPtrIsInvalid(so->currPos.lsn)",
errorType=0xbbbb2a "FailedAssertion", fileName=0xbbbd10 "nbtutils.c", lineNumber=1775)
at assert.c:69
#3 0x000000000054b563 in _bt_killitems (scan=0x2c309d0) at nbtutils.c:1775
#4 0x0000000000540c82 in _bt_steppage (scan=0x2c309d0, dir=ForwardScanDirection)
at nbtsearch.c:1901
#5 0x000000000053fe9d in _bt_next (scan=0x2c309d0, dir=ForwardScanDirection)
at nbtsearch.c:1497
#6 0x000000000053b264 in btgettuple (scan=0x2c309d0, dir=ForwardScanDirection)
at nbtree.c:268
#7 0x0000000000528799 in index_getnext_tid (scan=0x2c309d0, direction=ForwardScanDirection)
at indexam.c:575
#8 0x0000000000528941 in index_getnext_slot (scan=0x2c309d0,
direction=ForwardScanDirection, slot=0x2c301d0) at indexam.c:667
#9 0x000000000077646e in IndexNext (node=0x2c2fec8) at nodeIndexscan.c:133
#10 0x000000000074c6c5 in ExecScanFetch (node=0x2c2fec8, accessMtd=0x77628c ,
recheckMtd=0x7769ed ) at execScan.c:132
#11 0x000000000074c73a in ExecScan (node=0x2c2fec8, accessMtd=0x77628c ,
recheckMtd=0x7769ed ) at execScan.c:181
#12 0x0000000000776ef2 in ExecIndexScan (pstate=0x2c2fec8) at nodeIndexscan.c:537
#13 0x000000000073d394 in ExecProcNode (node=0x2c2fec8)
at ../../../src/include/executor/executor.h:261
#14 0x000000000073fbc2 in ExecutePlan (queryDesc=0x2c2b190, operation=CMD_SELECT,
sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x2c22940)
at execMain.c:1554
#15 0x000000000073d97c in standard_ExecutorRun (queryDesc=0x2c2b190,
direction=ForwardScanDirection, count=0, execute_once=false) at execMain.c:359
---Type to continue, or q to quit---
#16 0x000000000073d81f in ExecutorRun (queryDesc=0x2c2b190, direction=ForwardScanDirection,
count=0, execute_once=false) at execMain.c:308
#17 0x000000000098f572 in PortalRunSelect (portal=0x2bc2a70, forward=true, count=0,
dest=0x2c22940) at pquery.c:919
#18 0x000000000098f231 in PortalRun (portal=0x2bc2a70, count=9223372036854775807,
isTopLevel=true, run_once=true, dest=0x2c22940, altdest=0x2c22940, qc=0x7ffd697a06f0)
at pquery.c:763
#19 0x0000000000988bba in exec_simple_query (
query_string=0x2b5b0b0 "SELECT * FROM target ORDER BY id;") at postgres.c:1182
#20 0x000000000098d46c in PostgresMain (argc=1, argv=0x7ffd697a0980,
dbname=0x2b86928 "contrib_regression", username=0x2b57c58 "postgres") at postgres.c:4571
#21 0x00000000008c79bf in BackendRun (port=0x2b7e6d0) at postmaster.c:4541
#22 0x00000000008c7331 in BackendStartup (port=0x2b7e6d0) at postmaster.c:4263
#23 0x00000000008c35fb in ServerLoop () at postmaster.c:1750
#24 0x00000000008c2ed2 in PostmasterMain (argc=3, argv=0x2b55bd0) at postmaster.c:1422
#25 0x00000000007c2b1a in main (argc=3, argv=0x2b55bd0) at main.c:211
(gdb)
王鹏/兰柯
瀚高基础软件股份有限公司
wangpeng@highgo.com
lanke@highgo.com