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 | firstname.lastname@example.org |
| 840 | 192 | email@example.com |
| 849 | 191 | paul |
| 850 | 192 | paul |
| 1248343907 | 1968398946 | NULL |
| 878930738 | 1664045365 | NULL |
| 172254532 | 1445671501 | NULL |
| 1868644921 | 1399087626 | YBDrK2Vui95aOAOEsHuZvVCdmPSJBXbDX8xTi52q |
| 869 | 200 | firstname.lastname@example.org |
| 870 | 201 | email@example.com |
That looks pretty nasty to me Hopefully someone else might be able to
throw some light on it! Can I recover the situation?