Post
Topic
Board Meta
Re: Database Error
by
snipie
on 18/09/2015, 15:31:39 UTC
I had something weird happening just now. I was trying to make a post but it kept showing 502 error at first, I kept retrying and after several attempts, it went through but then I saw a duplicate post appear just after the original post and when I tried deleting the next one it wouldn't delete, I edited the post and then tried deleting it but again it didn't delete.

I tried to  remove original one which was at 2:30, duplicate was at 2.42 but after I tried deleting the original it went down and the 2.42 one came before that. Which is something I haven't ever seen happening before.

After several attempts I was able to remove the duplicate one but something is defo wrong.
Happened to me worse than that, i was writing a new topic during the incident, got 3 duplicated posts! Which I didn't find a way to delete it, and the original one didn't appear lol.
Was afraid that they will think i am spamming the forum when I found it, first reflex looking to my message nothing new, then when I read this euuh finally i am not alone.

It was probably Theymos who was fixing a bug involving invalid UTF characters such required that the database tables be locked which probably caused all of the weird bugs today

- I revised all of the database's collation rules to settings which should work as intended. This required locking tables for extended periods of time, which is what caused the other weirdness over the last few hours.
Thanks for the explication, hope that this will not happens again