-
Notifications
You must be signed in to change notification settings - Fork 1.2k
Open
Labels
area/ysqlYugabyte SQL (YSQL)Yugabyte SQL (YSQL)kind/bugThis issue is a bugThis issue is a bugkind/failing-testTests and testing infraTests and testing infrapriority/mediumMedium priority issueMedium priority issueqa_automationBugs identified via itest-system, LST, Stress automation or causing automation failuresBugs identified via itest-system, LST, Stress automation or causing automation failures
Description
Jira Link: DB-852
Description
SQLsmith found this failing debug postgres assert. Can be reproduced:
CREATE TABLE mvtest_boxes (id serial primary key, b box);
select
ref_0.id as c0,
ref_1.rolsuper as c1,
(select pg_catalog.max(write_lag) from pg_catalog.pg_stat_replication)
as c2
from
public.mvtest_boxes as ref_0
right join pg_catalog.pg_authid as ref_1
on (ref_0.id = ref_1.rolconnlimit )
where ref_0.id is not NULL
limit 104;
postgres logs:
TRAP: FailedAssertion("!(IsSearchNull(ybScan->key[i].sk_flags))", File: "../../../../../../../src/postgres/src/backend/access/yb_access/yb_scan.c", Line: 838)
2022-01-26 23:20:40.805 CET [63131] LOG: server process (PID 90921) was terminated by signal 6: Abort trap
2022-01-26 23:20:40.805 CET [63131] DETAIL: Failed process was running: select
ref_0.id as c0,
ref_1.rolsuper as c1,
(select pg_catalog.max(write_lag) from pg_catalog.pg_stat_replication)
as c2
from
public.mvtest_boxes as ref_0
right join pg_catalog.pg_authid as ref_1
on (ref_0.id = ref_1.rolconnlimit )
where ref_0.id is not NULL
limit 104;
2022-01-26 23:20:40.805 CET [63131] LOG: terminating any other active server processes
2022-01-26 23:20:40.809 CET [63131] LOG: all server processes terminated; reinitializing
2022-01-26 23:20:40.813 CET [90975] LOG: database system was interrupted; last known up at 2022-01-26 23:18:51 CET
2022-01-26 23:20:40.814 CET [90976] FATAL: the database system is in recovery mode
2022-01-26 23:20:40.816 CET [90975] LOG: database system was not properly shut down; automatic recovery in progress
2022-01-26 23:20:40.816 CET [90975] LOG: invalid record length at 0/9F000F08: wanted 24, got 0
2022-01-26 23:20:40.816 CET [90975] LOG: redo is not required
2022-01-26 23:20:40.821 CET [63131] LOG: database system is ready to accept connections
Metadata
Metadata
Assignees
Labels
area/ysqlYugabyte SQL (YSQL)Yugabyte SQL (YSQL)kind/bugThis issue is a bugThis issue is a bugkind/failing-testTests and testing infraTests and testing infrapriority/mediumMedium priority issueMedium priority issueqa_automationBugs identified via itest-system, LST, Stress automation or causing automation failuresBugs identified via itest-system, LST, Stress automation or causing automation failures