Actually, the stack trace showed the UserData object as being the
cluprit which means you need to do a join on 'website' and
'rolleruser' tables.
Try this:
delete from weblogentry where websiteid not in (select website.id
from website, rolleruser where website.userid = rolleruser.id)
Max
On Jul 27, 2005, at 8:10 PM, Matthew P. Schmidt wrote:
That's a data inconsistency problem. The following query was
harsh, but solved the problem:
delete from weblogentry where categoryid not in (select id from
weblogcategory)
I believe those are the right columns, just double check. That
should get rid of any entries that managed to become orphaned.
-Matt
Matt Raible wrote:
When I try to kick off the search indexing for my site, I get the
following stack trace in my logs. Any idea how to fix this?
INFO 2005-07-27 16:47:34,168 | WriteToIndexOperation:run | Starting
search index operation
ERROR 2005-07-27 16:47:37,067 |
HibernateWeblogManagerImpl:getWeblogEntries |
net.sf.hibernate.UnresolvableObjectException: No row with the given
identifier exists: 192197110220102822966018600075, of class:
org.roller.pojos.UserData
ERROR 2005-07-27 16:47:37,068 | RebuildUserIndexOperation:doRun |
ERROR adding doc to index
org.roller.RollerException
at
org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEnt
ries(HibernateWeblogManagerImpl.java:307)
at org.roller.business.WeblogManagerImpl.getWeblogEntries
(WeblogManagerImpl.java:297)
at
org.roller.business.search.operations.RebuildUserIndexOperation.doRun
(RebuildUserIndexOperation.java:114)
at
org.roller.business.search.operations.WriteToIndexOperation.run
(WriteToIndexOperation.java:41)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor
$Worker.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:595)
--- ROOT CAUSE ---
net.sf.hibernate.UnresolvableObjectException: No row with the given
identifier exists: 192197110220102822966018600075, of class:
org.roller.pojos.UserData
at net.sf.hibernate.UnresolvableObjectException.throwIfNull
(UnresolvableObjectException.java:38)
at net.sf.hibernate.impl.SessionImpl.internalLoad
(SessionImpl.java:1950)
at net.sf.hibernate.type.ManyToOneType.resolveIdentifier
(ManyToOneType.java:69)
at net.sf.hibernate.type.EntityType.resolveIdentifier
(EntityType.java:204)
at net.sf.hibernate.impl.SessionImpl.initializeEntity
(SessionImpl.java:2201)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:240)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
at net.sf.hibernate.loader.Loader.list(Loader.java:946)
at net.sf.hibernate.loader.CriteriaLoader.list
(CriteriaLoader.java:121)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:
3609)
at net.sf.hibernate.impl.CriteriaImpl.list
(CriteriaImpl.java:238)
at
org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEnt
ries(HibernateWeblogManagerImpl.java:302)
at org.roller.business.WeblogManagerImpl.getWeblogEntries
(WeblogManagerImpl.java:297)
at
org.roller.business.search.operations.RebuildUserIndexOperation.doRun
(RebuildUserIndexOperation.java:114)
at
org.roller.business.search.operations.WriteToIndexOperation.run
(WriteToIndexOperation.java:41)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor
$Worker.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:595)
INFO 2005-07-27 16:47:37,072 | RebuildUserIndexOperation:doRun |
Completed rebuilding index for all users in '2.904' secs
INFO 2005-07-27 16:47:37,073 | WriteToIndexOperation:run | Search
index operation complete
