Well here is what I have got! My server runs into a deadlock when I try to create objectnodes in the domain.xml - now I need to create the history uri's in the domain.xml to avoid errors when version-control is applied to a resource.
However it only runs into a deadlock when I add more the one objectnode to the JDBC store. So it I just add one at a time then it works fine. I guess it has something to do with when data is committed during the loading of domain.xml. /jacob ----- Original Message ----- From: "BaTien Duong" <[EMAIL PROTECTED]> To: "Slide Developers Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, May 27, 2004 3:57 PM Subject: Re: deadlock with multible JDBC stores > Martin Holz wrote: > > >"Jacob Lund" <[EMAIL PROTECTED]> writes: > > > > > > > > > >>Have any of you successfully configured multiple JDBC stores in domain.xml? > >> > >>Have a look at the attached domain.xml file. I have defined multiple stores > >>using TxFileStore and JDBCStore (both MySQL and SQLSever). > >> > >>However it runs into a deadlock when the domain.xml definition tries to create > >>the objectnodes for the history and files uri's. > >> > >> > > > >IIRC this was reported before for MySQL > >See http://thread.gmane.org/gmane.comp.jakarta.slide.user/3865 > >Not sure if was ever solved. It works for me with Postgres. > > > > > > > Hello Martin: > > Do you mind to share your Domain.xml that work with Postgres. I was not > able to resolve this issue yet. Here is what I have tried: > > <scope match="/" store='tx" /> (Tx FileDescriptorsStore) > > <scope match="/files/pmo" store="pmo" /> (PMO database in MySql instance) > <scope match="/history/pmo" store="pmo" /> > <scope match="/workspace/pmo" store="pmo" /> > <scope match="/workingresource/pmo" store="pmo" /> > > This works fine. But when i introduce store testCom that connects to a > separate database TESTCOM in the same MySql instance, i get a deadlock. > The idea is to isolate each project in separate database. When the > project is finished, all we need is a backup of the database and takes > it out of the service. > > <scope match="/files/testCom" store="testCom" /> (TESTCOM database in > the same MySql instance) > <scope match="/history/testCom" store="testCom" /> > <scope match="/workspace/testCom" store="testCom" /> > <scope match="/workingresource/testCom" store="testCom" /> > > I have tried with both MySql 4.0.18 and 4.1.1. At this current status, i > have not tried with different MySql instances or different RDBMS. > > Thanks. > > BaTien > DBGROUPS > > >Martin > > > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > >. > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
