[rt-users] missing information - corrupt DB?

[Jesse]

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.