[rt-users] missing information - corrupt DB?

[Rich West]

Since you know the file is there, you might want to check the permissions on the
file.  I had this happen ages ago with older versions of RT where the permissions
on the files weren't being set properly.  This is usually due to improper
permissions on the installation binaries.

If it is corrected when you fix the permissions (or if you do a chmod a+r
/usr/local/rt/transactions/2000/Mar/17/199.868), then you might want to go back to
your source tree, and run 'make fixperms' (I think that's the right make option).

-Rich


Jesse wrote:

> 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.
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users