ok,
for now I can work around this problem by don't using the connection pool
Thank
Michele
2009/7/31 Charles Foster <[email protected]>
> Hi Michele,
>
> I am intensely busy working on something else at the moment, I will
> investigate this problem further but just don't have the time right now.
> If you turn connection pooling off does the problem go away?
>
> Regards,
>
> Charles
>
> > Hi Charles,
> > Thank for the response,
> > as you suggest to me, I have repeated the test using the sedna driver;
> > below there is the code that I've used for new test.
> >
> > With this code it can load 20 resources simultaneously.
> >
> >
> > In the test with the Sedna XML:DB API I have tried to eliminate the row
> of
> > code where I close the collection
> > (in tis manner I never use a "recycled" Database Socket connection) and
> so
> > there are no problems.
> >
> > It seems that the problem occurs when I use "recycled" collection.
> >
> > Code with sedna driver
> > import ru.ispras.sedna.driver.*;
> > public class Test2 {
> > public Test2() {
> > removeAll();
> > int numThread = 20;
> > final Thread[] listThread = new Thread[numThread];
> > for (int i = 0; i < numThread; i++) {
> > final int count = i;
> > listThread[i] = new Thread(new Runnable() {
> > public void run() {
> > SednaConnection conn = getConnection();
> > try {
> > conn.begin();
> > SednaStatement st1 = conn.createStatement();
> > boolean call_res = st1.execute("LOAD
> > \"c:\\test.xml\" \"a" + count + "\"");
> > conn.commit();
> > } catch (Exception e) {
> > try {
> > conn.rollback();
> > } catch (DriverException e1) {
> > e1.printStackTrace();
> > }
> > System.out.println(e);
> > } finally {
> > try {
> > conn.close();
> > } catch (DriverException e) {
> > e.printStackTrace();
> > }
> > }
> >
> > }
> >
> > });
> >
> > }
> > long ini = System.currentTimeMillis();
> > for (int i = 0; i < numThread; i++) {
> > listThread[i].start();
> > }
> >
> > for (int i = 0; i < numThread; i++) {
> > try {
> > listThread[i].join();
> > } catch (InterruptedException e) {
> > e.printStackTrace();
> > }
> > }
> > System.out.println("fine totale:" + (System.currentTimeMillis() -
> > ini));
> > }
> >
> > private SednaConnection getConnection() {
> > SednaConnection con = null;
> > String url = "localhost";
> > String dbname = "Test";
> > String user = "SYSTEM";
> > String password = "MANAGER";
> > try {
> > con = DatabaseManager.getConnection(url, dbname, user,
> > password);
> > } catch (DriverException e) {
> > e.printStackTrace();
> > }
> > return con;
> > }
> >
> > ...
> >
> > public static void main(String[] args) {
> > Test2 t2 = new Test2();
> > }
> > }
> >
> >
> >
> >
> >
> >
> > 2009/7/28 Charles Foster <[email protected]>
> >
> >> Hi Michele,
> >>
> >> I've spoken to you about this before privately and explained to you that
> >> investigating this problem would take a long time indeed.
> >>
> >> It appears that the code creates 10 concurrent connections and "open
> >> transactions" on the database at the same time.
> >>
> >> Have you tried opening 10 connections with an according 10 concurrent
> >> OPEN-transactions on the Database with either Sedna Team MODIS Driver or
> >> even se_term? Or even getting the same thing to work with the Team MODIS
> >> Java driver?
> >>
> >> Are you aware that the following code:
> >>
> >> DatabaseManager.getCollection(String, String, String)
> >>
> >> will create you a brand new Sedna Connection / Socket?
> >>
> >> Please investigate as much as you can about this and identifying where
> >> the
> >> issue resides (Sedna XML Database or Sedna XML:DB Driver), The fact the
> >> error message is SEDNA Message: ERROR SE4703... would suggest it is at
> >> the
> >> Server end, but please first find this out.
> >>
> >> Regards,
> >>
> >> Charles
> >>
> >> > Hi,
> >> >
> >> > I've encountered a problem when I try to use a Sedna XML:DB API for
> >> Java
> >> > in
> >> > a multithreading application.
> >> >
> >> > When more than one thread try to store a different resource in the
> >> same
> >> > collection and the operation is bounded in one transaction I get the
> >> > following error:
> >> >
> >> > SEDNA Message: ERROR SE4703 The transaction is a victim of deadlock
> >> > resolution procedure.
> >> >
> >> > This is the test code for replicate the problem:
> >> >
> >> >
> >> >
> >> >
> >> > import org.xmldb.api.DatabaseManager;
> >> > import org.xmldb.api.base.Collection;
> >> > import org.xmldb.api.base.Database;
> >> > import org.xmldb.api.base.Resource;
> >> > import org.xmldb.api.base.XMLDBException;
> >> > import org.xmldb.api.modules.CollectionManagementService;
> >> > import org.xmldb.api.modules.TransactionService;
> >> > import org.xmldb.api.modules.XMLResource;
> >> >
> >> > public class Test3 {
> >> > public Test3() throws Exception {
> >> >
> >> > Database sednaDatabase;
> >> > Class<?> clazz = Class.forName("net.cfoster.sedna.DatabaseImpl");
> >> > sednaDatabase = (Database) (clazz.newInstance());
> >> > DatabaseManager.registerDatabase(sednaDatabase);
> >> >
> >> > int numThread = 10;
> >> > final Thread[] listThread = new Thread[numThread];
> >> >
> >> > for (int i = 0; i < numThread; i++) {
> >> >
> >> > final int count = i;
> >> >
> >> > listThread[i] = new Thread(new Runnable() {
> >> > public void run() {
> >> > Collection root = null;
> >> > TransactionService transactionService = null;
> >> > try {
> >> > root =
> >> > DatabaseManager.getCollection("xmldb:sedna://localhost:5050/Test",
> >> > "SYSTEM",
> >> > "MANAGER");
> >> > transactionService = (TransactionService)
> >> > root.getService("TransactionService", "1.0");
> >> > transactionService.begin();
> >> > Resource r = root.createResource("test" + count,
> >> > XMLResource.RESOURCE_TYPE);
> >> > r.setContent("<test/>");
> >> > root.storeResource(r);
> >> > transactionService.commit();
> >> > } catch (Exception e) {
> >> > e.printStackTrace();
> >> > try {
> >> > transactionService.rollback();
> >> > } catch (XMLDBException e1) {
> >> > e1.printStackTrace();
> >> > }
> >> > } finally {
> >> > try {
> >> > root.close();
> >> > } catch (Exception e) {
> >> > e.printStackTrace();
> >> > }
> >> > }
> >> >
> >> > }
> >> >
> >> > });
> >> >
> >> > }
> >> > System.out.println("init");
> >> > for (int i = 0; i < numThread; i++) {
> >> > listThread[i].start();
> >> > }
> >> >
> >> > for (int i = 0; i < numThread; i++) {
> >> > listThread[i].join();
> >> > }
> >> > System.out.println("end");
> >> > System.exit(0);
> >> > }
> >> >
> >> >
> >> >
> >> > public static void main(String[] args) {
> >> > try {
> >> > new Test3();
> >> > } catch (Exception e) {
> >> > e.printStackTrace();
> >> > }
> >> > }
> >> > }
> >> >
> >>
> ------------------------------------------------------------------------------
> >> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> >> > 30-Day
> >> > trial. Simplify your report design, integration and deployment - and
> >> focus
> >> > on
> >> > what you do best, core application coding. Discover what's new with
> >> > Crystal Reports now.
> >> >
> >>
> http://p.sf.net/sfu/bobj-july_______________________________________________
> >> > Sedna-discussion mailing list
> >> > [email protected]
> >> > https://lists.sourceforge.net/lists/listinfo/sedna-discussion
> >> >
> >>
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> >> 30-Day
> >> trial. Simplify your report design, integration and deployment - and
> >> focus
> >> on
> >> what you do best, core application coding. Discover what's new with
> >> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> >> _______________________________________________
> >> Sedna-discussion mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
> >>
> >
> ------------------------------------------------------------------------------
> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> > 30-Day
> > trial. Simplify your report design, integration and deployment - and
> focus
> > on
> > what you do best, core application coding. Discover what's new with
> > Crystal Reports now.
> >
> http://p.sf.net/sfu/bobj-july_______________________________________________
> > Sedna-discussion mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/sedna-discussion
> >
>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Sedna-discussion mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
