On 8/18/05, Matt Raible <[EMAIL PROTECTED]> wrote: > Looks like it worked!
Ugh, it took me a few weeks to figure it out - but I believe there might be some issues with Categories. Running the script to delete "orphans" deleted all the posts that I with an "Open Source" category. For those that follow my blog, you might remember some posts about the OSCON conference I attended. For that conference (and entries), I created an "Open Source" category. I just realized today that any entry with this category is gone: http://raibledesigns.com/page/rd/archives/20050831 It was in the first week of August. Ugh - time to start looking through the backups. Matt > > INFO 2005-08-18 13:44:38,625 | RebuildUserIndexOperation:doRun | > Completed rebuilding index for all users in '170.517' secs > INFO 2005-08-18 13:44:38,647 | WriteToIndexOperation:run | Search > index operation complete > > Now I have a new issue. If I do a search on my "rd" blog, I get a > stack trace - but it works fine on my "rn" blog. Any ideas? > > http://raibledesigns.com/search/rd?q=julie > > http://raibledesigns.com/search/rn?q=julie > > The error is: > > ERROR 2005-08-18 13:47:25,103 | BasePageServlet:handleRequest | > EXCEPTION: in RollerServlet > org.apache.velocity.exception.MethodInvocationException: Invocation of > method 'format' in class java.text.SimpleDateFormat threw exception > class java.lang.IllegalArgumentException : Cannot format given Object > as a Date > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:246) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55) > > > > > On 8/18/05, Matt Raible <[EMAIL PROTECTED]> wrote: > > 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 > > > >>>>>>> > > > >>>>>> > > > >>>>> > > > >>>>> > > > >>>> > > > >>> > > > >>> > > > >> > > > > > > > > > > > > >
