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