Skip to content

YSQL: SELECT query agains system catalog tables raises error: "Illegal state: Transaction for catalog table write operation 'pg_largeobject_metadata' not found" #10087

@mtakahar

Description

@mtakahar

Jira Link: DB-4794
This query is generated by SQLsmith. May be a duplicate of #9645 but it's not clear to me if that's the case. The query contains a TABLESAMPLE clause that has not been supported by Yugabyte DB yet (#4288) but hits the illegal state error without it, too.

select
   cast(nullif(
       pg_catalog.bit_and(
         cast(cast(null as int2) as int2)) over (partition by ref_0.hasindexes order by ref_0.tableowner,ref_0.schemaname),
     case when EXISTS (
         select
             ref_0.tablename as c0,
             sample_0.fdwacl as c1,
             sample_0.fdwacl as c2
           from
             pg_catalog.pg_foreign_data_wrapper as sample_0 tablesample system (9.1)
           where cast(null as tinterval) #< cast(null as reltime)
           limit 85) then cast(coalesce(pg_catalog.int2mod(
           cast(cast(null as int2) as int2),
           cast((select indnatts from pg_catalog.pg_index limit 1 offset 2)
              as int2)),

           pg_catalog.min(
             cast(cast(null as int2) as int2)) over (partition by ref_0.hastriggers,ref_0.tablename order by ref_0.tablespace)) as int2) else cast(coalesce(pg_catalog.int2mod(
           cast(cast(null as int2) as int2),
           cast((select indnatts from pg_catalog.pg_index limit 1 offset 2)
              as int2)),

           pg_catalog.min(
             cast(cast(null as int2) as int2)) over (partition by ref_0.hastriggers,ref_0.tablename order by ref_0.tablespace)) as int2) end
       ) as int2) as c0,
   ref_0.rowsecurity as c1,
   ref_0.schemaname as c2,
   cast(nullif(ref_0.tableowner,
     pg_catalog.current_user()) as name) as c3
 from
   pg_catalog.pg_tables as ref_0
 where pg_catalog.pg_my_temp_schema() <> pg_catalog.oidlarger(
     cast(pg_catalog.lo_create(
       cast(pg_catalog.pg_my_temp_schema() as oid)) as oid),
     cast(pg_catalog.pg_my_temp_schema() as oid))
 limit 128;

ERROR: Illegal state: Transaction for catalog table write operation 'pg_largeobject_metadata' not found

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    Status

    No status

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions