>>The Invalid Seek offset message appeared on different lines of code. Once I removed order, it stopped.
>
>try to
>
>REINDEX
>
>post some "lines of code" where the Invalid happen.
>
>If the error persists, test to perform the code with "SET EXCLUSIVE ON"
Yes, it persists. The error happens in various places, mostly on insert commands. I'll try with SET EXCLUSIVE ON in my tests, but I'm not 100% sure we can use this solution in general.
If it's not broken, fix it until it is.
My Blog