forked from mtusi2026/mtusi2026lab4
28 lines
1.6 KiB
Python
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)
|