Files

28 lines
1.6 KiB
Python

"""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)