cardano-db-sync icon indicating copy to clipboard operation
cardano-db-sync copied to clipboard

Insert in Bulk

Open kderme opened this issue 1 year ago • 1 comments

Description

This is an experimental impmenetation of https://github.com/orgs/IntersectMBO/projects/8/views/3?pane=issue&itemId=48804685. The purpose is to benchmark it and evaluate its complexity and correctness.

Checklist

  • [ ] Commit sequence broadly makes sense
  • [ ] Commits have useful messages
  • [ ] New tests are added if needed and existing tests are updated
  • [ ] Any changes are noted in the changelog
  • [ ] Code is formatted with fourmolu on version 0.10.1.0 (which can be run with scripts/fourmolize.sh)
  • [ ] Self-reviewed the diff

Migrations

  • [ ] The pr causes a breaking change of type a,b or c
  • [ ] If there is a breaking change, the pr includes a database migration and/or a fix process for old values, so that upgrade is possible
  • [ ] Resyncing and running the migrations provided will result in the same database semantically

If there is a breaking change, especially a big one, please add a justification here. Please elaborate more what the migration achieves, what it cannot achieve or why a migration is not possible.

kderme avatar Jan 04 '24 10:01 kderme

I had a strange error

DbInsertException "Many MaTxOut" (SqlError {sqlState = "XX000", sqlExecStatus = FatalError, sqlErrorMsg = "unrecognized node type: -1543503872", sqlErrorDetail = "", sqlErrorHint = ""})

though it may be a red herring as I didn't sync from a clean state.

kderme avatar Jan 04 '24 16:01 kderme