Re: Turbine stack trace

Mick Semb Wever <[email protected]>
Newsgroups gmane.comp.java.scarab.user
Message-ID <[email protected]>
> 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?

> 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 |
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.