Advertisement
Guest User

postgresql 9.4.4 serialization failure due to FK

a guest
Jun 18th, 2015
460
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. postgresql 9.4.4 serialization failure due to FK
  2.  
  3. Files:
  4. setup.sql - http://pastebin.com/24dgELYa
  5. run.sh - http://pastebin.com/3BsQtc3S
  6.  
  7. Test steps:
  8.  
  9. createdb test
  10. psql test -f setup.sql
  11. ./run.sh
  12.  
  13. Output - eventually one or more:
  14.  
  15. ERROR: could not serialize access due to read/write dependencies among transactions
  16. DETAIL: Reason code: Canceled on commit attempt with conflict in from prepared pivot.
  17. HINT: The transaction might succeed if retried.
  18. ERROR: could not serialize access due to read/write dependencies among transactions
  19. DETAIL: Reason code: Canceled on commit attempt with conflict in from prepared pivot.
  20. HINT: The transaction might succeed if retried.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement