[rt-users] missing information - corrupt DB?

[Paul Dixon]

I've been using rt 1.0 successfully for many months, but recently I've had
some information go missing.

To give an example, I created a request on 17th Mar with serial number 199.
The web interface shows the request correctly, but with a blank transaction
history. The directory /usr/local/rt/transactions/2000/Mar/17 contains a
file named 199.868 which contains what I would have expected to see, but the
web interface isn't showing it.

I'm not too familiar with the database structure of RT, but a look at the
transactions table appeared to show some sort of corruption...


mysql> select id, serial_num, actor from transactions where serial_num>190;
+------------+------------+------------------------------------------+
| id         | serial_num | actor                                    |
+------------+------------+------------------------------------------+
|        839 |        191 | paul at elphin.com                          |
|        840 |        192 | paul at elphin.com                          |
|        849 |        191 | paul                                     |
|        850 |        192 | paul                                     |
| 1248343907 | 1968398946 | NULL                                     |
|  878930738 | 1664045365 | NULL                                     |
|  172254532 | 1445671501 | NULL                                     |
| 1868644921 | 1399087626 | YBDrK2Vui95aOAOEsHuZvVCdmPSJBXbDX8xTi52q |
|        869 |        200 | gerrit.mesker at achmea.nl                  |
|        870 |        201 | paul at elphin.com                          |
+------------+------------+------------------------------------------+

That looks pretty nasty to me ;-) Hopefully someone else might be able to
throw some light on it! Can I recover the situation?

Thanks,

paul at elphin.com