Jens,
Just my two cents ... with new mySQL releases, bug get fixed and new bugs get
(re)introduced. I'd go and read the release notes for the mySQL JDBC
driver and check (if you are using different versions, indeed) whether e.g. connection
handling or something similar has been changed (fixed).
Other than this, I can only advise you follow Bruce's suggestions below.
Regards
Werner
On Thu, 11 Mar 2004 09:13:23 -0700 (MST), Bruce Snyder wrote:
>
>This one time, at band camp, Jens Saade said:
>
>Jens,
>
>Please see my comments inline:
>
>
>JS>.... forgot to mention I use poolman for connection pooling between my
>JS>system and the mysql db.
>JS>
>JS>Jens Saade wrote:
>JS>
>JS>>
>JS>> Hi all,
>JS>>
>JS>> I am currently experiencing weird problems with castor jdo.
>JS>> I am using mysql 4.0.16 on debian linux, jdk 1.4.1_02 (1.4.2._x
>JS>> versions somehow crash with sig 11), aswell as castor 0.9.5.2 / 0.9.5
>JS>>
>JS>> While running perfectly under windoze exactly the same code throws
>JS>> exception (win: jdk 1.4.1_04, mysql Ver 12.21 Distrib 4.0.14, for
>JS>> Win95/Win98 (i32))
>JS>>
>JS>> The stacktrace: ---------------------------------
>JS>>
>JS>> org.exolab.castor.jdo.TransactionNotInProgressException: This
>JS>> transaction is not open
>JS>> at
>JS>> org.exolab.castor.jdo.engine.DatabaseImpl.rollback(DatabaseImpl.java:551)
>JS>> at
>JS>> de.fusionsoft.pce.core.engine.ItemManager.getAllItems(ItemManager.java:267)
>JS>>
>JS>> at
>JS>> de.fusionsoft.pce.core.engine.PceServiceImpl.getAllItems(PceServiceImpl.java:239)
>JS>>
>JS>> at
>JS>> de.fusionsoft.pce.core.engine._PceServiceImpl_Tie._invoke(Unknown Source)
>JS>> at
>JS>> com.sun.corba.ee.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:355)
>JS>>
>JS>> at com.sun.corba.ee.internal.iiop.ORB.process(ORB.java:255)
>JS>> at
>JS>> com.sun.corba.ee.internal.iiop.RequestProcessor.process(RequestProcessor.java:84)
>JS>>
>JS>> at
>JS>> com.sun.corba.ee.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:99)
>JS>>
>JS>> 2004-03-10 20:09:34,667 ERROR [pce.core.engine.ItemManager] : Could
>JS>> not execute statement 'selectAllItemsOql' :
>JS>> org.exolab.castor.jdo.ObjectModifiedException: Transaction aborted:
>JS>> Object of type de.fusionsoft.pce.core.items.types.News with identity 1
>JS>> has been modified by a concurrent transaction (cache entry is
>JS>> different from database row)
>JS>> at
>JS>> org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:883)
>JS>> at
>JS>> org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:1616)
>JS>> at org.exolab.castor.persist.LockEngine.store(LockEngine.java:758)
>JS>> at
>JS>>
>org.exolab.castor.persist.TransactionContext.prepare(TransactionContext.java:1540)
>JS>>
>JS>> at
>JS>> org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java:528)
>JS>> at
>JS>> de.fusionsoft.pce.core.engine.ItemManager.getAllItems(ItemManager.java:264)
>JS>>
>JS>> at
>JS>> de.fusionsoft.pce.core.engine.PceServiceImpl.getAllItems(PceServiceImpl.java:239)
>JS>>
>JS>> at
>JS>> de.fusionsoft.pce.core.engine._PceServiceImpl_Tie._invoke(Unknown Source)
>JS>> at
>JS>> com.sun.corba.ee.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:355)
>JS>>
>JS>> at com.sun.corba.ee.internal.iiop.ORB.process(ORB.java:255)
>JS>> at
>JS>> com.sun.corba.ee.internal.iiop.RequestProcessor.process(RequestProcessor.java:84)
>JS>>
>JS>> at
>JS>> com.sun.corba.ee.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:99)
>JS>>
>JS>>
>JS>>
>JS>> I am also experiencing a new error when i try to insert a new item -
>JS>> this is prolly a dependency error ...
>
>This looks like a locking issue. What type of access are you
>specifying in the mapping descriptor for the News object listed
>below in the exception?
>
>JS>> org.exolab.castor.jdo.LockNotGrantedException:
>JS>> persist.readLockTimeoutde.fusionsoft.pce.core.items.types.News/2/105
>JS>> by [EMAIL PROTECTED]
>JS>> at
>JS>> org.exolab.castor.persist.ObjectLock.acquireLoadLock(ObjectLock.java:428)
>JS>> at
>JS>> org.exolab.castor.persist.LockEngine$TypeInfo.acquire(LockEngine.java:1201)
>JS>>
>JS>> at
>JS>> org.exolab.castor.persist.LockEngine$TypeInfo.access$300(LockEngine.java:1026)
>JS>>
>JS>> at org.exolab.castor.persist.LockEngine.load(LockEngine.java:355)
>JS>> at
>JS>> org.exolab.castor.persist.TransactionContext.load(TransactionContext.java:649)
>JS>>
>JS>> at
>JS>> org.exolab.castor.persist.QueryResults.fetch(QueryResults.java:229)
>JS>> at
>JS>>
>org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImpl.java:641)
>JS>>
>JS>> at
>JS>>
>org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImpl.java:624)
>JS>>
>JS>> at
>JS>>
>de.fusionsoft.pce.core.engine.ItemManager.filterItemsByRight(ItemManager.java:304)
>JS>>
>JS>> at
>JS>> de.fusionsoft.pce.core.engine.ItemManager.getAllItems(ItemManager.java:262)
>JS>>
>JS>> at
>JS>> de.fusionsoft.pce.core.engine.PceServiceImpl.getAllItems(PceServiceImpl.java:239)
>JS>>
>JS>> at
>JS>> de.fusionsoft.pce.core.engine._PceServiceImpl_Tie._invoke(Unknown Source)
>JS>> at
>JS>> com.sun.corba.ee.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:355)
>JS>>
>JS>> at com.sun.corba.ee.internal.iiop.ORB.process(ORB.java:255)
>JS>> at
>JS>> com.sun.corba.ee.internal.iiop.RequestProcessor.process(RequestProcessor.java:84)
>JS>>
>JS>> at
>JS>> com.sun.corba.ee.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:99)
>JS>>
>JS>>
>JS>>
>JS>>
>JS>> ----------sourcecode ------
>JS>> public Item[] getAllItems(String sessionId, int reqItemTypeId,
>JS>> String reqSortby, boolean reqAscending, int reqMaxLimit) throws
>JS>> ItemException, SecurityException {
>JS>> UserRegistry userReg = UserRegistry.getInstance(jdo);
>JS>>
>JS>> long tokenId = userReg.getUserIdForSession(sessionId);
>JS>> if (tokenId == 0) {
>JS>> logger.error("tokenId could not be resolved from
>JS>> UserRegistry for sessionId " + sessionId);
>JS>> return null;
>JS>> }
>JS>>
>JS>> logger.debug("getAllItems() called: sessionId=" + sessionId + "
>JS>> reqItemTypeId=" + reqItemTypeId + " reqSortby=" + reqSortby + "
>JS>> reqAscending=" + reqAscending + " reqMaxLimit=" + reqMaxLimit);
>JS>> Item[] items = null;
>JS>> Item tmpItem = null;
>JS>> OQLQuery selectAllItemsOql = null;
>JS>> QueryResults results = null;
>JS>>
>JS>> ItemType reqItemType;
>JS>> String reqItemTypeName;
>JS>> try {
>JS>> reqItemType = itemTypes[reqItemTypeId];
>JS>> } catch (IndexOutOfBoundsException e) {
>JS>> throw new ItemException("Invalid ItemType provided: " +
>JS>> reqItemTypeId + " does not exist. " + e);
>JS>> }
>JS>>
>JS>> // only proceed if we got a valid itemType reference
>JS>> if (reqItemType != null) {
>JS>> Database db = null;
>JS>> try {
>JS>> db = jdo.getDatabase();
>JS>> db.begin();
>JS>>
>JS>> // prepare statement properties
>JS>> reqItemTypeName = reqItemType.getTypeName();
>JS>>
>JS>> if (reqSortby == null || reqSortby.equals(""))
>JS>> reqSortby = SORTFIELD_DEFAULT;
>JS>>
>JS>> String reqOrder;
>JS>> if (reqAscending)
>JS>> reqOrder = "ASC";
>JS>> else
>JS>> reqOrder = "DESC";
>JS>>
>JS>> if (reqMaxLimit == 0)
>JS>> reqMaxLimit = LIMIT_DEFAULT;
>JS>> logger.debug("Selecting
>JS>> de.fusionsoft.pce.core.items.types." + reqItemTypeName);
>JS>> selectAllItemsOql = db.getOQLQuery("SELECT p FROM
>JS>> de.fusionsoft.pce.core.items.types." + reqItemTypeName + " p ORDER BY
>JS>> " + reqSortby + " " + reqOrder + " LIMIT $1");
>JS>> selectAllItemsOql.bind(reqMaxLimit);
>JS>> results = selectAllItemsOql.execute(true);
>
>It seems as if there is a tx available when the OQL is executed
>above because there's a call above to db.begin() so I'm a bit perplexed.
>
>JS>> items = filterItemsByRight(reqItemTypeId, tokenId,
>JS>> results);
>JS>> results.close();
>JS>> db.commit();
>JS>> } catch (PersistenceException e) {
>JS>> try {
>JS>> db.rollback();
>JS>> } catch (TransactionNotInProgressException e1) {
>JS>> e1.printStackTrace();
>JS>> }
>JS>> logger.error("Could not execute statement
>JS>> 'selectAllItemsOql' :", e);
>JS>> } finally {
>JS>> try {
>JS>> if (!db.isClosed())
>JS>> db.close();
>JS>> } catch (PersistenceException e) {
>JS>> logger.error("Could not close DB connection while
>JS>> executing statement 'selectAllItemsOql' :", e);
>JS>> throw new ItemException(e.getMessage());
>JS>> }
>JS>> }
>JS>>
>JS>> } else {
>JS>> throw new ItemException("Invalid ItemType provided: " +
>JS>> reqItemTypeId + " is not applicable.");
>JS>>
>JS>> }
>JS>> return items;
>JS>> }
>JS>> ----------------
>JS>>
>JS>> Note that I do not change result objects in any way.
>JS>>
>JS>>
>JS>>
>JS>> Anyone knows what to do?
>
>
>When I'm perplexed in this way, I try to break down the problem to
>the bare minimum amount of code. I suggest you take that strategy
>and get the easiest possible thing working first. Just comment out
>everything down to the bare minimum. Then gradually uncomment code
>until you find the problem. In order to comment further on the
>problem, I would need to see the results of this type of troubleshooting.
>
>Bruce
>--
>perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
>
>The Castor Project
>http://www.castor.org/
>
>Apache Geronimo
>http://incubator.apache.org/projects/geronimo.html
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
