Hi again,
Forgot to mention:
- I don't use transactions explicitly although I suppose each
operation goes inside its own transaction by default.
- I use concurrent threads with separate XML DB connections but
there still might be some mess with static resources.
Best regards,
Ivan Lagunov
From: Ivan Lagunov [mailto:[email protected]]
Sent: Tuesday, October 30, 2012 5:10 PM
To: [email protected]; 'Charles Foster'
Subject: Errors while bulk upload process
Hi Charles,
I'm facing strange problems with a bulk upload operation using Sedna XML:DB
API implementation. It happens periodically on Production environment but I
cannot reproduce it locally or on Test env. Thus, I need a hint from you
what the root cause may be according to the symptoms/stacktraces.
The algorithm is the following:
1. Creating a connection to XML DB
rootCollection = DatabaseManager.getCollection(dbUrl, dbUsername,
dbPassword);
2. Getting a specific collection using
rootCollection.getChildCollection("collection").getChildCollection("subColle
ction")
3. Uploading xml content to the collection using
XMLResource resource = (XMLResource) collection.createResource(xmlName,
XMLResource.RESOURCE_TYPE);
resource.setContent(xmlContents);
collection.storeResource(resource);
4. Repeat steps 2-3 many times (hundreds)
5. Close a connection to XML DB
rootCollection.close();
The steps 2 and 3 fail with exceptions unexpectedly/randomly for a huge
number of files. If one file upload fails, the next upload may go fine, I'm
just printing the stack trace.
I'm getting four types of exceptions:
On step 2:
java.lang.NullPointerException
at net.cfoster.sedna.xmldb.o.a(Unknown Source)
at net.cfoster.sedna.xmldb.g.c(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.c.b(Unknown Source)
at net.cfoster.sedna.xmldb.c.getChildCollection(Unknown Source)
org.xmldb.api.base.XMLDBException: SEDNA Message: ERROR SE4610
There is no transaction to commit.
at net.cfoster.sedna.xmldb.g.c(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.c.b(Unknown Source)
at net.cfoster.sedna.xmldb.c.getChildCollection(Unknown Source)
org.xmldb.api.base.XMLDBException: SEDNA Message: ERROR SE4612
Commit current transaction before beginning a new one.
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.g.a(Unknown Source)
at net.cfoster.sedna.xmldb.c.b(Unknown Source)
at net.cfoster.sedna.xmldb.c.getChildCollection(Unknown Source)
on step 3:
java.lang.NullPointerException
at net.cfoster.sedna.xmldb.o.a(Unknown Source)
at net.cfoster.sedna.xmldb.m.hasMoreResources(Unknown Source)
at net.cfoster.sedna.xmldb.m.getSize(Unknown Source)
at net.cfoster.sedna.xmldb.c.a(Unknown Source)
at net.cfoster.sedna.xmldb.c.removeResource(Unknown Source)
at net.cfoster.sedna.xmldb.c.storeResource(Unknown Source)
BTW, these problems started since I upgraded to the latest Version 1.2.5
26/Oct/12. Could you look into this? Any hint?
Best regards,
Ivan Lagunov
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
