"""Barrier experiment: probe DB fencing during PUT -> metadata commit window.""" from client import Client, check, run from track2 import sql from concurrent.futures import ThreadPoolExecutor import time def main(): c=Client(timeout=30); a,b,e,chat=c.bootstrap() before=sql('select count(*) from attachments;') sql("create function proof_delay() returns trigger language plpgsql as $$ begin perform pg_sleep(6); return NEW; end; $$; create trigger proof_delay before insert on attachments for each row execute function proof_delay();") try: with ThreadPoolExecutor(max_workers=1) as pool: task=pool.submit(c.attachment,a,chat) for _ in range(30): if sql("select count(*) from pg_stat_activity where wait_event='PgSleep';")!='0': break time.sleep(.2) check(sql('select count(*) from attachments;')==before,'metadata visible before commit') check(sql('select pg_try_advisory_xact_lock(741204);')=='f','reconciler could enter active upload') att,data=task.result() check(sql('select pg_try_advisory_xact_lock(741204);')=='t','lock leaked after commit') received=c.call('GET','/api/v1/attachments/'+att['id']+'/content',actor=b)['bytes'] check(received==data,'bytes lost in commit window') print('PASS PUT/COMMIT barrier: uncommitted metadata invisible; exclusive reconcile lock denied during upload; released after commit; other member downloads identical bytes') finally: sql('drop trigger proof_delay on attachments; drop function proof_delay();') if __name__ == '__main__': run(main)