You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Matt Raible <mr...@gmail.com> on 2005/08/03 01:53:23 UTC
Re: Fixing Search
What's the syntax for rollerdb.properties? Here's what I get when
trying to run the script below.
[raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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.getWeblogEn
> >>>> t
> >>>> ries(HibernateWeblogManagerImpl.java:307)
> >>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
> >>>> (WeblogManagerImpl.java:297)
> >>>> at
> >>>> org.roller.business.search.operations.RebuildUserIndexOperation.doRu
> >>>> 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.doQueryAndInitializeNonLazyCollection
> >>>> 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.getWeblogEn
> >>>> t
> >>>> ries(HibernateWeblogManagerImpl.java:302)
> >>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
> >>>> (WeblogManagerImpl.java:297)
> >>>> at
> >>>> org.roller.business.search.operations.RebuildUserIndexOperation.doRu
> >>>> 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
> >>>>
> >>>
> >>
> >>
> >
>
>
Re: Fixing Search
Posted by Lance Lavandowska <la...@gmail.com>.
On 8/18/05, Matt Raible <mr...@gmail.com> wrote:
> The strange thing is it works fine when I eliminate my username:
>
> http://raibledesigns.com/search?q=julie
>
> I'm guessing it might be a theme problem - I'll try tweaking some date
> formatting stuff that I have.
That one bad entry isn't showing up on your first search results page,
more than likely. Try stepping thru the results to see if you can
trip the error again.
Lance
Re: Fixing Search
Posted by Lance Lavandowska <la...@gmail.com>.
Oh, I see what you're saying! Yes, must be something n your theme.
On 8/18/05, Matt Raible <mr...@gmail.com> wrote:
> The strange thing is it works fine when I eliminate my username:
>
> http://raibledesigns.com/search?q=julie
>
> I'm guessing it might be a theme problem - I'll try tweaking some date
> formatting stuff that I have.
>
> Matt
Re: Fixing Search
Posted by Matt Raible <mr...@gmail.com>.
The strange thing is it works fine when I eliminate my username:
http://raibledesigns.com/search?q=julie
I'm guessing it might be a theme problem - I'll try tweaking some date
formatting stuff that I have.
Matt
On 8/18/05, Lance Lavandowska <la...@gmail.com> wrote:
> Ugh, the useless Velocity exception stacktrace. My best guess is that
> something has a null timestamp value. You might want to alter your
> velocimacros to elimate date formatting (just print it raw) and see
> what that reveals.
>
> Lance
>
> On 8/18/05, Matt Raible <mr...@gmail.com> wrote:
>
> > 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)
>
Re: Fixing Search
Posted by Lance Lavandowska <la...@gmail.com>.
Ugh, the useless Velocity exception stacktrace. My best guess is that
something has a null timestamp value. You might want to alter your
velocimacros to elimate date formatting (just print it raw) and see
what that reveals.
Lance
On 8/18/05, Matt Raible <mr...@gmail.com> wrote:
> 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)
Re: Sub categories
Posted by "Matthew P. Schmidt" <ma...@javalobby.org>.
I have to agree with a change that would let the listing of entries in a
category be recursive to its subcategories. We've thought about making
this change at JRoller so that more categories could be included in the
frontpage listings.
Matthew P. Schmidt
Vice President of Technology
Javalobby.org
Email: matt@javalobby.org
Phone: 919.678.0300
Matt Raible wrote:
>On 9/9/05, paksegu <pa...@yahoo.com> wrote:
>
>
>>Hello Roller World,
>>Do we have a sub category feature in Roller 2.0?
>>Thanks -Ransford
>>
>>
>
>Yes, there is one, but it doesn't work like you'd think. If you
>filter on a parent-category (via web or RSS means), the sub categories
>entries don't get included. For example:
>
>http://raibledesigns.com/page/rd/archives/20050630?catname=Java
>
>http://raibledesigns.com/page/rd/archives/20050630?catname=Java/JavaOne
>
>IMO, the 1st link should contain all the links from the 2nd as well.
>
>
Re: Sub categories
Posted by Dave Johnson <da...@rollerweblogger.org>.
On Sep 9, 2005, at 3:05 PM, Matt Raible wrote:
> On 9/9/05, paksegu <pa...@yahoo.com> wrote:
>>
>> Hello Roller World,
>> Do we have a sub category feature in Roller 2.0?
>> Thanks -Ransford
>
> Yes, there is one, but it doesn't work like you'd think. If you
> filter on a parent-category (via web or RSS means), the sub categories
> entries don't get included. For example:
>
> http://raibledesigns.com/page/rd/archives/20050630?catname=Java
>
> http://raibledesigns.com/page/rd/archives/20050630?catname=Java/JavaOne
>
> IMO, the 1st link should contain all the links from the 2nd as well.
Yes, I agree too and we had that working at one point -- before the
switch to the Hibernate Query API and dynamic building of queries.
- Dave
Re: Sub categories
Posted by Matt Raible <mr...@gmail.com>.
On 9/9/05, paksegu <pa...@yahoo.com> wrote:
>
> Hello Roller World,
> Do we have a sub category feature in Roller 2.0?
> Thanks -Ransford
Yes, there is one, but it doesn't work like you'd think. If you
filter on a parent-category (via web or RSS means), the sub categories
entries don't get included. For example:
http://raibledesigns.com/page/rd/archives/20050630?catname=Java
http://raibledesigns.com/page/rd/archives/20050630?catname=Java/JavaOne
IMO, the 1st link should contain all the links from the 2nd as well.
Sub categories
Posted by paksegu <pa...@yahoo.com>.
Hello Roller World,
Do we have a sub category feature in Roller 2.0?
Thanks -Ransford
Matt Raible <mr...@gmail.com> wrote:
On 8/18/05, Matt Raible 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 wrote:
> > On 8/18/05, Dave Johnson wrote:
> > > There is a snippet about ConsistencyCheck at the end of the 1.0 upgrade
> > > guide:
> > >
> >
> > 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 wrote:
> > > >> What's the syntax for rollerdb.properties? Here's what I get when
> > > >> trying to run the script below.
> > > >>
> > > >> [raible@kgb01 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.(FileInputStream.java:106)
> > > >> at java.io.FileInputStream.(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 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 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
> > > >>>>>>>
> > > >>>>>>
> > > >>>>>
> > > >>>>>
> > > >>>>
> > > >>>
> > > >>>
> > > >>
> > > >
> > >
> > >
> >
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: Fixing Search
Posted by Dave Johnson <da...@rollerweblogger.org>.
On Sep 9, 2005, at 2:22 PM, Matt Raible wrote:
> 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.
Any idea why those posts were considered to be orphans?
- Dave
Re: Fixing Search
Posted by Matt Raible <mr...@gmail.com>.
I found the 4 missing posts in a MySQL Dump I did right before I ran
the scripts. However, they're missing the pubtime and update time
(both have NULL). Any idea why these aren't included in a dump?
Thanks,
Matt
On 9/9/05, Matt Raible <mr...@gmail.com> wrote:
> On 8/18/05, Matt Raible <mr...@gmail.com> 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 <mr...@gmail.com> wrote:
> > > On 8/18/05, Dave Johnson <da...@rollerweblogger.org> 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 <mr...@gmail.com> wrote:
> > > > >> What's the syntax for rollerdb.properties? Here's what I get when
> > > > >> trying to run the script below.
> > > > >>
> > > > >> [raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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
> > > > >>>>>>>
> > > > >>>>>>
> > > > >>>>>
> > > > >>>>>
> > > > >>>>
> > > > >>>
> > > > >>>
> > > > >>
> > > > >
> > > >
> > > >
> > >
> >
>
Re: Fixing Search
Posted by Matt Raible <mr...@gmail.com>.
On 8/18/05, Matt Raible <mr...@gmail.com> 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 <mr...@gmail.com> wrote:
> > On 8/18/05, Dave Johnson <da...@rollerweblogger.org> 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 <mr...@gmail.com> wrote:
> > > >> What's the syntax for rollerdb.properties? Here's what I get when
> > > >> trying to run the script below.
> > > >>
> > > >> [raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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
> > > >>>>>>>
> > > >>>>>>
> > > >>>>>
> > > >>>>>
> > > >>>>
> > > >>>
> > > >>>
> > > >>
> > > >
> > >
> > >
> >
>
Re: Fixing Search
Posted by Matt Raible <mr...@gmail.com>.
Looks like it worked!
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 <mr...@gmail.com> wrote:
> On 8/18/05, Dave Johnson <da...@rollerweblogger.org> 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 <mr...@gmail.com> wrote:
> > >> What's the syntax for rollerdb.properties? Here's what I get when
> > >> trying to run the script below.
> > >>
> > >> [raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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
> > >>>>>>>
> > >>>>>>
> > >>>>>
> > >>>>>
> > >>>>
> > >>>
> > >>>
> > >>
> > >
> >
> >
>
Re: Fixing Search
Posted by Matt Raible <mr...@gmail.com>.
On 8/18/05, Dave Johnson <da...@rollerweblogger.org> 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 <mr...@gmail.com> wrote:
> >> What's the syntax for rollerdb.properties? Here's what I get when
> >> trying to run the script below.
> >>
> >> [raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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
> >>>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>
> >>>
> >>>
> >>
> >
>
>
Re: Fixing Search
Posted by Dave Johnson <da...@rollerweblogger.org>.
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 <mr...@gmail.com> wrote:
>> What's the syntax for rollerdb.properties? Here's what I get when
>> trying to run the script below.
>>
>> [raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
Re: Fixing Search
Posted by Matthew Schmidt <ma...@javalobby.org>.
They are primarily from way back when. A few versions ago there were
issues with the integrity, but it should be cleared up now.
-Matt
Allen Gilliland wrote:
>I don't have any suggestions, but I will say that if this is really happening then we need to figure out why and fix it. Data integrity issues are really ugly and should not be happening :(
>
>-- Allen
>
>
>On Thu, 2005-08-18 at 11:29, Matthew Schmidt wrote:
>
>
>>Your best bet is to just run some queries on the DB with stuff like
>>websiteid not in (select id from website) to find entries with no
>>website or or not in (select id from weblog_category) for entries with
>>no categories. That has worked for us in the past.
>>
>>-Matt
>>
>>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 <mr...@gmail.com> wrote:
>>>
>>>
>>>
>>>
>>>>What's the syntax for rollerdb.properties? Here's what I get when
>>>>trying to run the script below.
>>>>
>>>>[raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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.getWeblogEn
>>>>>>>>>t
>>>>>>>>>ries(HibernateWeblogManagerImpl.java:307)
>>>>>>>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
>>>>>>>>>(WeblogManagerImpl.java:297)
>>>>>>>>> at
>>>>>>>>>org.roller.business.search.operations.RebuildUserIndexOperation.doRu
>>>>>>>>>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.doQueryAndInitializeNonLazyCollection
>>>>>>>>>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.getWeblogEn
>>>>>>>>>t
>>>>>>>>>ries(HibernateWeblogManagerImpl.java:302)
>>>>>>>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
>>>>>>>>>(WeblogManagerImpl.java:297)
>>>>>>>>> at
>>>>>>>>>org.roller.business.search.operations.RebuildUserIndexOperation.doRu
>>>>>>>>>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
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>
>
>
Re: Fixing Search
Posted by Allen Gilliland <Al...@Sun.COM>.
I don't have any suggestions, but I will say that if this is really happening then we need to figure out why and fix it. Data integrity issues are really ugly and should not be happening :(
-- Allen
On Thu, 2005-08-18 at 11:29, Matthew Schmidt wrote:
> Your best bet is to just run some queries on the DB with stuff like
> websiteid not in (select id from website) to find entries with no
> website or or not in (select id from weblog_category) for entries with
> no categories. That has worked for us in the past.
>
> -Matt
>
> 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 <mr...@gmail.com> wrote:
> >
> >
> >>What's the syntax for rollerdb.properties? Here's what I get when
> >>trying to run the script below.
> >>
> >>[raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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.getWeblogEn
> >>>>>>>t
> >>>>>>>ries(HibernateWeblogManagerImpl.java:307)
> >>>>>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
> >>>>>>>(WeblogManagerImpl.java:297)
> >>>>>>> at
> >>>>>>>org.roller.business.search.operations.RebuildUserIndexOperation.doRu
> >>>>>>>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.doQueryAndInitializeNonLazyCollection
> >>>>>>>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.getWeblogEn
> >>>>>>>t
> >>>>>>>ries(HibernateWeblogManagerImpl.java:302)
> >>>>>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
> >>>>>>>(WeblogManagerImpl.java:297)
> >>>>>>> at
> >>>>>>>org.roller.business.search.operations.RebuildUserIndexOperation.doRu
> >>>>>>>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
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>
> >>>>>
> >>>
> >>>
Re: Fixing Search
Posted by Matthew Schmidt <ma...@javalobby.org>.
Your best bet is to just run some queries on the DB with stuff like
websiteid not in (select id from website) to find entries with no
website or or not in (select id from weblog_category) for entries with
no categories. That has worked for us in the past.
-Matt
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 <mr...@gmail.com> wrote:
>
>
>>What's the syntax for rollerdb.properties? Here's what I get when
>>trying to run the script below.
>>
>>[raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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.getWeblogEn
>>>>>>>t
>>>>>>>ries(HibernateWeblogManagerImpl.java:307)
>>>>>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
>>>>>>>(WeblogManagerImpl.java:297)
>>>>>>> at
>>>>>>>org.roller.business.search.operations.RebuildUserIndexOperation.doRu
>>>>>>>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.doQueryAndInitializeNonLazyCollection
>>>>>>>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.getWeblogEn
>>>>>>>t
>>>>>>>ries(HibernateWeblogManagerImpl.java:302)
>>>>>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
>>>>>>>(WeblogManagerImpl.java:297)
>>>>>>> at
>>>>>>>org.roller.business.search.operations.RebuildUserIndexOperation.doRu
>>>>>>>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
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>
Re: Fixing Search
Posted by Matt Raible <mr...@gmail.com>.
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 <mr...@gmail.com> wrote:
> What's the syntax for rollerdb.properties? Here's what I get when
> trying to run the script below.
>
> [raible@kgb01 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 <da...@rollerweblogger.org> 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 <mr...@steelbrick.com> 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.getWeblogEn
> > >>>> t
> > >>>> ries(HibernateWeblogManagerImpl.java:307)
> > >>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
> > >>>> (WeblogManagerImpl.java:297)
> > >>>> at
> > >>>> org.roller.business.search.operations.RebuildUserIndexOperation.doRu
> > >>>> 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.doQueryAndInitializeNonLazyCollection
> > >>>> 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.getWeblogEn
> > >>>> t
> > >>>> ries(HibernateWeblogManagerImpl.java:302)
> > >>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
> > >>>> (WeblogManagerImpl.java:297)
> > >>>> at
> > >>>> org.roller.business.search.operations.RebuildUserIndexOperation.doRu
> > >>>> 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
> > >>>>
> > >>>
> > >>
> > >>
> > >
> >
> >
>