This can trigger in VCSA where database sitting in SQL Server. As the error message indicates, the sequence of 0 is outside of the bound of the sequence. Resetting should fix this issue.
setval: value -1786008095 is out of bounds for sequence "vpx_event_seq" (1..9223372036854775807)
VCDB=# SELECT setval('vpx_event_seq', 0)
VCDB-# ;
ERROR: setval: value 0 is out of bounds for sequence "vpx_event_seq" (1..9223372036854775807)
VCDB=# SELECT setval('vpx_event_seq', 1000);
setval
--------
1000
(1 row)
No comments:
Post a Comment