I can't figure out how this happened  

I have table where the primary key is a sequence.  I was getting a lot of 
errors on insertions, and noticed the current value was around 65k, but the max 
id in the database was around 160k.  everything works now that i've restarted 
it, but I can't find any record of a restart sequence accidentally being put in.

the only thing I can think of, is the sequence went up several hundred billion 
and restarted from 0 when a drive crashed. but that seems incredibly unlikely 
given the last known actual max id.

does anyone have an idea what could cause this?  pg 9.6.6 on ubuntu


Reply via email to