Ticket #35 (closed defect: fixed)

Opened 10 years ago

Last modified 10 years ago

database out of shared memory

Reported by: jesus Assigned to: jesus
Priority: major Milestone: Ploy
Component: stratcond Severity:
Keywords: Cc:

Description

If you load a whole batch of data, commit and then crash or fail to checkpoint back to the noitd. Next time around you will have a whole batch of data that is going to trigger primary key violations. This can be 100k rows of data easily and will cause new savepoints for each row. This get allocated new txnids in postgres which requires a lock and we run out of locks.

We want to limit this to a smaller batch size.

Change History

06/24/08 17:25:14 changed by jesus

  • status changed from new to closed.
  • resolution set to fixed.

(In [299]) fixes #35