Odd report for creation date

RT Users
1

Should I be worried about this?

mysql> select Created from Queues;
| Created |
*’)-+.-(- 11:94:88 |
’)-+.-(- 11:94:88 |
| M063-70-65 87:95:52 |
| ?**.-)-0. 58:15:04 |
| ?690-32-20 84:65:92 |
5 rows in set (0.01 sec)

Huh? I’m really confused. The column type is reported as "datetime"
but, well, I’m not aware of the above being any sort of valid datetime
format. I’ve not looked for other issues in the db, thought I’d check
if this was normal (or a known issue).

2

Should I be worried about this?

Yes. That looks like pretty severe database corruption.

mysql> select Created from Queues;
±--------------------+
| Created |
±--------------------+
*')-+.-(- 11:94:88 |
')-+.-(- 11:94:88 |
| M063-70-65 87:95:52 |
| ?**.-)-0. 58:15:04 |
| ?690-32-20 84:65:92 |
±--------------------+
5 rows in set (0.01 sec)

Huh? I’m really confused. The column type is reported as “datetime”
but, well, I’m not aware of the above being any sort of valid datetime
format. I’ve not looked for other issues in the db, thought I’d check
if this was normal (or a known issue).

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

Should I be worried about this?

Yes. That looks like pretty severe database corruption.

Um, well, crap!

Can anyone offer any hints where this error might have come from? We’ve
seen no other database problems, have had no strange behavior in RT or
other things that rely on the database (although that’s not much right
now, admittedly). No system crashes, panics, or other things that I’d
normally expect to potentially cause such corruption. Has anyone else
seen anything similar to this?

Should I just patch the data and watch for it happening again?

4

Um, well, crap!

Can anyone offer any hints where this error might have come from? We’ve
seen no other database problems, have had no strange behavior in RT or
other things that rely on the database (although that’s not much right
now, admittedly). No system crashes, panics, or other things that I’d
normally expect to potentially cause such corruption. Has anyone else
seen anything similar to this?

It could be a bug in Mysql. I’d recommend running their recovery tools,
and making sure that:

  1. you’re current on mysql
  2. you keep frequent backups of the database
  3. you keep mysql’s transaction logs since your last database backup

Should I just patch the data and watch for it happening again?

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.