Skip to content

[YSQL][SQLsmith] TRAP: FailedAssertion("!(IsSearchNull(ybScan->key[i].sk_flags))", File: "../../../../../../../src/postgres/src/backend/access/yb_access/yb_scan.c", Line: 838) #11253

@def-

Description

@def-

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)kind/bugThis issue is a bugkind/failing-testTests and testing infrapriority/mediumMedium priority issueqa_automationBugs identified via itest-system, LST, Stress automation or causing automation failures

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions