limitXmin=snapshot->xmin;

PopActiveSnapshot();

UnregisterSnapshot(snapshot);

InvalidateCatalogSnapshot();

Parsed test spec with 2 sessions

starting permutation: s2l s1i s2i

step s2l: SELECT pg_advisory_lock(281457);

pg_advisory_lock

step s1i:

CREATE INDEX CONCURRENTLY mcic_one_pkey ON mcic_one (id)

WHERE lck_shr(281457);

<waiting ...>

step s2i:

CREATE INDEX CONCURRENTLY mcic_two_pkey ON mcic_two (id)

WHERE unlck();

step s1i: <... completed>

s1

test: skip-locked-3

test: skip-locked-4

test: drop-index-concurrently-1

test: multiple-cic

test: alter-table-1

test: alter-table-2

test: alter-table-3

{

CREATETABLEmcic_one (

);

CREATETABLEmcic_two (

);

CREATEFUNCTIONlck_shr(bigint)RETURNSboolIMMUTABLELANGUAGEplpgsqlAS $$

BEGINPERFORMpg_advisory_lock_shared($1);RETURNtrue;END;

$$;

CREATEFUNCTIONunlck()RETURNSboolIMMUTABLELANGUAGEplpgsqlAS $$

BEGINPERFORMpg_advisory_unlock_all();RETURNtrue;END;

$$;

}

{

DROPTABLEmcic_one,mcic_two;

DROPFUNCTIONlck_shr(bigint);

DROPFUNCTIONunlck();

}

step"s1i"{

CREATEINDEXCONCURRENTLYmcic_one_pkeyONmcic_one (id)

WHERElck_shr(281457);

}

teardown{SELECTpg_advisory_unlock_all()AS"s1"; }

step"s2l" {SELECTpg_advisory_lock(281457); }

step"s2i"{

CREATEINDEXCONCURRENTLYmcic_two_pkeyONmcic_two (id)

WHEREunlck();

}