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 <[EMAIL PROTECTED]> wrote:


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

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


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

Matt

On 7/30/05, Dave Johnson <[EMAIL PROTECTED]> wrote:
Have you tried running ConsistencyCheck? It will list the
inconsistencies and if you run it with -purge" it will attempt to
automatically clean them up.

Here's the script I use to run it:

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

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


- Dave




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

Max,

This results in:

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

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

Matt

On 7/27/05, Rudman Max <[EMAIL PROTECTED]> wrote:
Actually, the stack trace showed the UserData object as being the
cluprit which means you need to do a join on 'website' and
'rolleruser' tables.

Try this:

delete from weblogentry where websiteid not in (select website.id
from website, rolleruser where website.userid = rolleruser.id)
Max


On Jul 27, 2005, at 8:10 PM, Matthew P. Schmidt wrote:

That's a data inconsistency problem.  The following query was
harsh, but solved the problem:

delete from weblogentry where categoryid not in (select id from
weblogcategory)

I believe those are the right columns, just double check.  That
should get rid of any entries that managed to become orphaned.

-Matt

Matt Raible wrote:


When I try to kick off the search indexing for my site, I get the
following stack trace in my logs. Any idea how to fix this?

INFO  2005-07-27 16:47:34,168 | WriteToIndexOperation:run | Starting
search index operation
ERROR 2005-07-27 16:47:37,067 |
HibernateWeblogManagerImpl:getWeblogEntries |
net.sf.hibernate.UnresolvableObjectException: No row with the given
identifier exists: 192197110220102822966018600075, of class:
org.roller.pojos.UserData
ERROR 2005-07-27 16:47:37,068 | RebuildUserIndexOperation:doRun |
ERROR adding doc to index
org.roller.RollerException
     at
org.roller.business.hibernate.HibernateWeblogManagerImpl.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


Reply via email to