spyglass icon indicating copy to clipboard operation
spyglass copied to clipboard

Published 20 hours ago • verified publisher icon LorenFrankLab

Insertion error in fresh database

Open samuelbray32 opened this issue 11 months ago • 2 comments

  • When populating LinearizedPositionV1 for the first time in a database, I got an error that cannot call make within a transaction.
  • I think what happened is that the "position_linearization_merge" schema had not yet been made, and it tried to do so at this point

https://github.com/LorenFrankLab/spyglass/blob/10bf4accb177500ab3f14b313cfc473637e38119/src/spyglass/linearization/v1/main.py#L180

  • This left the database in a state whereLinearizedPositionV1 was populated for the entry, but the corresponding part table in PositionOutput was not.

Solution @CBroz1 Is there a preferred way to ensure that the LinearizedPositionOutput table is constructed before this step?

samuelbray32 avatar Mar 14 '24 19:03 samuelbray32