[rt-users] Upgrade 3.6 -> 3.8; database corruption?

[Kevin Murphy]

Hi Ruslan,

I don't know if you saw the end of my previous message in this thread, 
so here it is again (rt-validator 3.8.2rc1 output).   There are many 
CachedGroupMembers problems.  Should I attempt to allow rt-validator to 
fix them (if it can?)  See also the seemingly unrelated SQL error.

As mentioned previously, my RT database works fine with RT 3.6.X but 
produces the weird rights errors with 3.8.X.  This database has been in 
use since 2003.  There have been many RT and PostgreSQL upgrades since 
then, but there has never been a database problem, to my knowledge.

I ran the rt-validator from 3.8.2rc1 on my 3.6.7 database, and this is 
what I got:

*Name "RT::DatabaseType" used only once: possible typo at 
sbin/rt-validator line 133.

Record #15423 in CachedGroupMembers references not existent record in
CachedGroupMembers
    ImmediateParentId => '6585' => GroupId
    MemberId => '6329' => MemberId
    Via => '15420' => id*

[... and 109 more like the previous ...]
  
*Principal #22 is member of #6585 when #6585 is member of #6166,
but there is no cached GM record that 22 is member of #6166.
*
[... and 219 more like the previous ...]

*[Wed Dec 17 15:59:28 2008] [warning]: DBD::Pg::st execute failed:
ERROR:  syntax error at or near "WHERE"
LINE 4: WHERE
        ^ at sbin/rt-validator line 1060. (sbin/rt-validator:1060)
[Wed Dec 17 15:59:28 2008] [crit]: couldn't execute SELECT m.id, g.id,
g.Instance
FROM
    Groups g JOIN Attachments m
WHERE
    g.Domain = ?
    AND g.Type = ?
    AND g.id = m.Creator

    Error: ERROR:  syntax error at or near "WHERE"
LINE 4: WHERE
        ^ at sbin/rt-validator line 1060.
(/usr/local/src/rt-3.8.2rc1/sbin/../lib/RT.pm:377)
couldn't execute SELECT m.id, g.id, g.Instance
FROM
    Groups g JOIN Attachments m
WHERE
    g.Domain = ?
    AND g.Type = ?
    AND g.id = m.Creator

    Error: ERROR:  syntax error at or near "WHERE"
LINE 4: WHERE
        ^ at sbin/rt-validator line 1060.*



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081218/93f1e1c2/attachment.htm>