Re: Fixing Search

Thu, 18 Aug 2005 12:20:17 -0700

There is a snippet about ConsistencyCheck at the end of the 1.0 upgrade guide: 
<http://www.rollerweblogger.org/wiki/Wiki.jsp?page=UpgradeGuide_1_0>

- Dave


On Aug 18, 2005, at 1:58 PM, Matt Raible wrote:


Anyone know how to fix this?  I get daily complaints from blog readers
that they can't search my site.

Thanks,

Matt

On 8/2/05, Matt Raible <[EMAIL PROTECTED]> wrote:

What's the syntax for rollerdb.properties?  Here's what I get when
trying to run the script below.

[EMAIL PROTECTED] bin]$ ./checkDatabase.sh
Exception in thread "main" java.io.FileNotFoundException:
rollerdb.properties (No such file or directory)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:106)
        at java.io.FileInputStream.<init>(FileInputStream.java:66)
at org.roller.business.utils.ConsistencyCheck.main(ConsistencyCheck.java: 35) 


Is there an example of this file in Roller's source tree.

Matt

On 7/30/05, Dave Johnson <[EMAIL PROTECTED]> wrote:

Have you tried running ConsistencyCheck? It will list the
inconsistencies and if you run it with -purge" it will attempt to
automatically clean them up.

Here's the script I use to run it:

#!/bin/sh
if [ "$JAVA_HOME" = "" ] ; then
echo You must set JAVA_HOME to point to your Java JDK install 
directory
         exit 1
fi
_JDBCJAR=${CATALINA_HOME}/common/lib/mysql-connector-java-3.0.15-ga-
bin.jar
_CP=../lib/rollerbeans.jar
_CP=${_CP}:../lib/commons-logging.jar
_CP=${_CP}:${_JDBCJAR}

${JAVA_HOME}/bin/java -classpath ${_CP}
org.roller.business.utils.ConsistencyCheck $1 $2 $3 $4


- Dave




On Jul 28, 2005, at 11:41 PM, Matt Raible wrote:


Max,

This results in:

mysql> delete from weblogentry where websiteid not in (select
website.id
-> from website, rolleruser where website.userid = rolleruser.id); ERROR 1064 (00000): You have an error in your SQL syntax near 'select 
website.id
from website, rolleruser where website.userid = rolleruser.id' at line 
1

I'm using MySQL 3.23.56-Max-log, and I'm guessing the problem is the
subselect doesnt' work in that version.

Matt

On 7/27/05, Rudman Max <[EMAIL PROTECTED]> wrote:

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.getWeblo gEn 
t
ries(HibernateWeblogManagerImpl.java:307)
       at org.roller.business.WeblogManagerImpl.getWeblogEntries
(WeblogManagerImpl.java:297)
       at
org.roller.business.search.operations.RebuildUserIndexOperation.d oRu 
n
(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.doQueryAndInitializeNonLazyCollect ion 
s
(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.getWeblo gEn 
t
ries(HibernateWeblogManagerImpl.java:302)
       at org.roller.business.WeblogManagerImpl.getWeblogEntries
(WeblogManagerImpl.java:297)
       at
org.roller.business.search.operations.RebuildUserIndexOperation.d oRu 
n
(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

Reply via email to