psycopg.errors.DuplicateTable: relation "revenue0_pid" already exists

cmu-db / dbgym

An end-to-end research vehicle for studying self-driving DBMSs.

MIT License

14 stars 1 forks source link

psycopg.errors.DuplicateTable: relation "revenue0_pid" already exists #23

Closed wangpatrick57 closed 6 months ago

wangpatrick57 commented 6 months ago

Details in /home/phw2/ray_results/ProtoxHPO_2024-04-04_15-19-39/TuneOpt_c13e4_00001_1_activation_fn=gelu,batch_size=16,bias_zero=False,critic_lr_scale=2.5000,embedder_path=home_phw2_dbgym_manual_2024-04-04_15-19-39 on dev4

wangpatrick57 commented 6 months ago

One possible factor is in workload.py. Unlike the original codebase which modified the .sql file directly, we modify the .sql file in code.

Screenshot 2024-04-04 at 14 27 05