Issue #888: InternalException

 

[2012-08-11 14:39:54 #127 server]
[ObjectDB 2.4.2] Unexpected exception (Error 990)
  Generated by Java HotSpot(TM) Client VM 1.6.0_25 (on Linux 2.6.32.12).
Please report this error on http://www.objectdb.com/database/issue/new
com.objectdb.o.InternalException: null
com.objectdb.o.InternalException
        at com.objectdb.o.BYR.s(BYR.java:113)
        at com.objectdb.o.BYR.A(BYR.java:206)
        at com.objectdb.o.REG.E(REG.java:379)
        at com.objectdb.o.EXR$d.c(EXR.java:131)
        at com.objectdb.o.VAR.ax(VAR.java:846)
        at com.objectdb.o.VAR.aw(VAR.java:789)
        at com.objectdb.o.BCN.o(BCN.java:305)
        at com.objectdb.o.BCN.UV(BCN.java:264)
        at com.objectdb.o.PBI.C(PBI.java:146)
        at com.objectdb.o.PBI.q(PBI.java:115)
        at com.objectdb.o.OBI.Vj(OBI.java:243)
        at com.objectdb.o.BQI.Vs(BQI.java:150)
        at com.objectdb.o.TQI.Vs(TQI.java:67)
        at com.objectdb.o.TQI.Vs(TQI.java:67)
        at com.objectdb.o.TQI.Vs(TQI.java:67)
        at com.objectdb.o.MQI.Vs(MQI.java:143)
        at com.objectdb.o.PRG.ai(PRG.java:776)
        at com.objectdb.o.PRG.ag(PRG.java:705)
        at com.objectdb.o.PRG.af(PRG.java:553)
        at com.objectdb.o.QRM.U5(QRM.java:262)
        at com.objectdb.o.MST.U5(MST.java:953)
        at com.objectdb.o.WRA.U5(WRA.java:290)
        at com.objectdb.o.WSM.U5(WSM.java:113)
        at com.objectdb.o.WRA.U5(WRA.java:290)
        at com.objectdb.o.WSN.U5(WSN.java:425)
        at com.objectdb.o.STC.r(STC.java:447)
        at com.objectdb.o.SHN.aj(SHN.java:489)
        at com.objectdb.o.SHN.K(SHN.java:156)
        at com.objectdb.o.HND.run(HND.java:133)
        at java.lang.Thread.run(Thread.java:662)

Thank you for this report.

The stack trace indicates an unexpected state during query execution but the exact reason is unknown. You should check your database with the Doctor to verify that the database file is fine.

If you could post a sample database with the query that causes this exception it may help.

I stopped the DB and ran the Doctor over it and it found no errors, however, when I started the DB back up the problem was gone....weird.

If it helps this is the query that was causing it:

TypedQuery<Object[]> q1 = em.createQuery(
        "SELECT e,g FROM Event e, Guest g WHERE e.calendarId = :calendarId"
            + " AND e.activeStartDate <= :endDate" + " AND e.activeEndDate > :startDate"
            + " AND :userId IN e.guests AND g.eventId = e.id AND g.userId = :userId",
        Object[].class);

This query still worked fine though, also other simple Guest retrieval queries worked fine as well:

TypedQuery<Event> q1 = em.createQuery("SELECT e FROM Event e WHERE e.calendarId = :calendarId"
        + " AND e.activeStartDate <= :endDate" + " AND e.activeEndDate > :startDate"
        + " AND :userId IN e.guests", Event.class);

Maybe it was a cache problem and restarting the database cleared the cache.

Have you changed the persistent model recently (e.g. added / removed a persistent field)? Currently schema changed require restarting the database.

Ah, that may be it. I did add a new field to the entity. Weird how I could grab the same entities through other queries though, I guess it's related to what fields in the entity are triggered in the query? Thanks.

Different queries behave differently but it is unclear what is the exact cause.

Anyway, the database must be restarted after a schema change, so this issue will be closed now.