Yoshinori posted in dm-daq-support that hkdb was loading some frames in the wrong order:

After looking into it, it seems as though this is caused by a single frame that has an abnormally long duration:

frame.__dict__
>> {'_sa_instance_state': <sqlalchemy.orm.state.InstanceState object at 0x7f914c0d6c80>,
 'agent': 'acu',
 'byte_offset': 577164031,
 'end_time': 1737422107.8764656,
 'feed': 'acu_error',
 'file': <sotodlib.io.hkdb.HkFile object at 0x7f90d2b4eec0>,
 'file_id': 47326,
 'id': 20629910,
 'start_time': 1737108927.5658438}

This long frame makes it so this query can potentially insert files out of order, since the query is order by Frame start time.

This bug can be fixed by sorting the file paths and making sure we're loading them in the proper order.