[rt-users] missing information - corrupt DB?

Jesse jesse at pallas.eruditorum.org
Tue Mar 21 13:12:29 EST 2000


Yipe. That's not good. I'd suggest you "mysqldump rt" and see if you
see the corruption there.  What rev of mysql are you running?


	jesse

On Tue, Mar 21, 2000 at 04:18:31PM -0000, Paul Dixon wrote:
> 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
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent -- jrvincent at wesleyan.edu -- jesse at fsck.com 
pgp keyprint:  50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
--------------------------------------------------------------
Linux is like a Vorlon.  It is incredibly powerful, gives terse,
cryptic answers and has a lot of things going on in the background.





More information about the rt-users mailing list