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