On 8/18/05, Dave Johnson <[EMAIL PROTECTED]> wrote: > 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>
Thanks Dave - looks like I have quite a few orphans. http://raibledesigns.com/consistencycheck.log I've backed up my database, and I'm about to run this with -purge. If my site is offline in the near future, you'll know why. ;-) Matt > > - 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 > >>>>>>> > >>>>>> > >>>>> > >>>>> > >>>> > >>> > >>> > >> > > > >