Re: Turbine stack trace

Thank's for your reply.

I launch the request on our database, there is a NULL entry :

mysql> select b.USER_ID from SCARAB_ISSUE_ATTRIBUTE_VALUE b, SCARAB_ATTRIBUTE a
where ATTRIBUTE_TYPE_ID = 8 and a.ATTRIBUTE_ID = b.ATTRIBUTE_ID group by
USER_ID;
+---------+
| USER_ID |
+---------+
|    NULL |
|       1 |
|     100 |
|     120 |
|     121 |
...
|     340 |
|     341 |
+---------+
81 rows in set (0.06 sec)

Seems to be a AssignedTo item :
+--------------+----------------+-------------------+--------------+--------------------+-------------+--------+------------+---------------------+---------+---------+
| ATTRIBUTE_ID | ATTRIBUTE_NAME | ATTRIBUTE_TYPE_ID | PERMISSION   |
REQUIRED_OPTION_ID | DESCRIPTION | ACTION | CREATED_BY | CREATED_DATE
      | DELETED | USER_ID |
+--------------+----------------+-------------------+--------------+--------------------+-------------+--------+------------+---------------------+---------+---------+
|            2 | AssignedTo     |                 8 | Issue | Edit |
            NULL | AssignedTo  | to     |       NULL | 2002-01-01
00:30:00 |       0 |    NULL |
|            2 | AssignedTo     |                 8 | Issue | Edit |
            NULL | AssignedTo  | to     |       NULL | 2002-01-01
00:30:00 |       0 |       1 |
|            2 | AssignedTo     |                 8 | Issue | Edit |
            NULL | AssignedTo  | to     |       NULL | 2002-01-01
00:30:00 |       0 |     100 |
|

Can I update with a valid user id ?

BTW, the count of null and not null user_id gives the following.

mysql> select count(*) from SCARAB_ISSUE_ATTRIBUTE_VALUE where not
isnull(USER_ID) limit 0,10;
D) limit 0,10;
+----------+
| count(*) |
+----------+
|     3185 |
+----------+
1 row in set (0.02 sec)

mysql> select count(*) from SCARAB_ISSUE_ATTRIBUTE_VALUE where
isnull(USER_ID) limit 0,10;
limit 0,10;
+----------+
| count(*) |
+----------+
|    47313 |
+----------+


On Mon, May 5, 2008 at 7:09 PM, Mick Semb Wever <[email protected]> wrote:
>
>
> > Since this, scarab is not working very well. I often repair the mysql
> > tables.
>
> I think you problems are a little bigger if you have to repair your
> tables multiple times. Time for a new disk maybe?

We tried, but we have a lot of static to copy ... this can not be
exported/imported.

>
>
> > On several issues, I have the following stack :
> >
> > Caused by: org.apache.torque.NoRowsException: Failed to select a row. at
> > org.tigris.scarab.om.BaseScarabUserImplPeer.retrieveScarabUserImplByPK
> (BaseScarabUserImplPeer.java:173)
>
> My first guess is that one of the tables is has a USER_ID value that
> doesn't exist in TURBINE_USER.
>
> For example:
> do all the USER_ID printed from
>
> select b.USER_ID from SCARAB_ISSUE_ATTRIBUTE_VALUE b, SCARAB_ATTRIBUTE a
> where ATTRIBUTE_TYPE_ID = 8 and a.ATTRIBUTE_ID = b.ATTRIBUTE_ID group by
> USER_ID;
>
> exist in TURBINE_USER ?
>
> ~mck
>
> --
> "Be kind. For everyone you meet is fighting a hard battle." Plato
> | www.semb.wever.org | www.sesat.no | www.sesam.no |
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>



-- 
Christophe Delarue
mailto:[email protected]
06 12 95 49 56