Orbeon Forms community mailing list

Embedded eXist Database locked while Tomcat running - how can I access?

Classic

List

Threaded

7 messages Options

Michael_C

Embedded eXist Database locked while Tomcat running - how can I access?

Hi all,
I have an application which saves form data to the embedded eXist database. The data is stored correctly, but I can't access the database from an external application while Tomcat is running. It seems that Orbeon locks the database and prevents any other app from getting access.
I have tried installing eXist separately , and using the Client shell to connect to the DB embedded in Orbeon, but I get the following error:

File lock last access timestamp: Jun 22, 2010 C:\tools\Apache\Tomcat_6.0\webapps\orbeon\WEB-INF\exist-data\dbx_dir.lck
Waiting a short time for the lock to be released... C:\tools\Apache\Tomcat_6.0\webapps\orbeon\WEB-INF\exist-data\dbx_dir.lck

The lock is never released while Tomcat is running, so I have to stop Tomcat to access my data. This would not be an issue except I now need that data to be available to other applications...

Is this a fundamental limitation, or is there a way of setting the embedded eXist database to allow simultaneous accesses?

/Michael

Louis Ratzesberger-2

Re: Embedded eXist Database locked while Tomcat running - how can I access?

Hi Michael,

Are you able to access the REST interface? When you put in the URL, e.g.:

http://my.domain:8080/orbeon/exist/rest/db

assuming your context is /orbeon.... You should see the list of
collections, perhaps only one:

<exist:result>
<exist:collection name="/db"
created="2009-06-18T17:29:48.204-07:00" owner="admin" group="dba"
permissions="rwurwurwu">
<exist:collection name="orbeon"
created="2009-06-18T19:37:51.701-07:00" owner="guest" group="guest"
permissions="rwur-ur-u"/>
</exist:collection>
</exist:result>

The lock files are always present when the database is running to
insure no other process (besides eXist - it isn't Orbeon doing this)
attempts to access the database file and corrupt it.

It is unclear to me what data is in the database files that you need
to access which is NOT available through one of the API's, like REST,
when the database is running.

Regards,
hank

Quoting Michael_C <[hidden email]>:

>
> Hi all,
> I have an application which saves form data to the embedded eXist database.
> The data is stored correctly, but I can't access the database from an
> external application while Tomcat is running. It seems that Orbeon locks the
> database and prevents any other app from getting access.
> I have tried installing eXist separately , and using the Client shell to
> connect to the DB embedded in Orbeon, but I get the following error:
>
> File lock last access timestamp: Jun 22, 2010
> C:\tools\Apache\Tomcat_6.0\webapps\orbeon\WEB-INF\exist-data\dbx_dir.lck
> Waiting a short time for the lock to be released...
> C:\tools\Apache\Tomcat_6.0\webapps\orbeon\WEB-INF\exist-data\dbx_dir.lck
>
> The lock is never released while Tomcat is running, so I have to stop Tomcat
> to access my data. This would not be an issue except I now need that data to
> be available to other applications...
>
> Is this a fundamental limitation, or is there a way of setting the embedded
> eXist database to allow simultaneous accesses?
>
> /Michael
>
>
> --
> View this message in context:
> http://orbeon-forms-ops-users.24843.n4.nabble.com/Embedded-eXist-Database-locked-while-Tomcat-running-how-can-I-access-tp2264105p2264105.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>

--
Hank Ratzesberger
[hidden email]

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Alistair Miles-2

Re: Embedded eXist Database locked while Tomcat running - how can I access?

In reply to this post by Michael_C

FWIW, I've had no problem accessing exist data via the rest interface
(as Hank suggests) or via custom xqueries.

Hth,

Alistair

On Tue, Jun 22, 2010 at 06:24:55AM -0700, Michael_C wrote:

>
> Hi all,
> I have an application which saves form data to the embedded eXist database.
> The data is stored correctly, but I can't access the database from an
> external application while Tomcat is running. It seems that Orbeon locks the
> database and prevents any other app from getting access.
> I have tried installing eXist separately , and using the Client shell to
> connect to the DB embedded in Orbeon, but I get the following error:
>
> File lock last access timestamp: Jun 22, 2010
> C:\tools\Apache\Tomcat_6.0\webapps\orbeon\WEB-INF\exist-data\dbx_dir.lck
> Waiting a short time for the lock to be released...
> C:\tools\Apache\Tomcat_6.0\webapps\orbeon\WEB-INF\exist-data\dbx_dir.lck
>
> The lock is never released while Tomcat is running, so I have to stop Tomcat
> to access my data. This would not be an issue except I now need that data to
> be available to other applications...
>
> Is this a fundamental limitation, or is there a way of setting the embedded
> eXist database to allow simultaneous accesses?
>
> /Michael
>
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Embedded-eXist-Database-locked-while-Tomcat-running-how-can-I-access-tp2264105p2264105.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.

>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws

--
Alistair Miles
Head of Epidemiological Informatics
Centre for Genomics and Global Health <http://cggh.org>
The Wellcome Trust Centre for Human Genetics
Roosevelt Drive
Oxford
OX3 7BN
United Kingdom
Web: http://purl.org/net/aliman
Email: [hidden email]
Tel: +44 (0)1865 287669

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Michael_C

Re: Embedded eXist Database locked while Tomcat running - how can I access?

In reply to this post by Louis Ratzesberger-2

Hi,
Yes, I can see the collections as you describe, thanks, so that's a start!
I had assumed that the eXist client shell accessed the database through the REST API, and that I would not be able to access the API successfully unless the client could do so. Was this assumption incorrect?

Alessandro Vernet

Re: Re: Embedded eXist Database locked while Tomcat running - how can I access?

Administrator

Michael,

You can connect to the embedded eXist with the eXist client while
Tomcat is running. Just make sure that you choose "remote" when
connecting, and then use the following URL for eXist:
xmldb:exist://localhost:8080/orbeon/exist/xmlrpc (replacing the host /
port / context as appropriate). You can even connect with the eXist
client you run directly from the eXist site by clicking on the orange
"launch" logo at the bottom left of http://exist.sourceforge.net/.

Alex

On Tue, Jun 22, 2010 at 11:00 AM, Michael_C <[hidden email]> wrote:

>
> Hi,
> Yes, I can see the collections as you describe, thanks, so that's a start!
> I had assumed that the eXist client shell accessed the database through the
> REST API, and that I would not be able to access the API successfully unless
> the client could do so. Was this assumption incorrect?
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Embedded-eXist-Database-locked-while-Tomcat-running-how-can-I-access-tp2264105p2264530.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>

--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
My Twitter: http://twitter.com/avernet

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

petergruenbeck

Re: Re: Embedded eXist Database locked while Tomcat running - how can I access?

I'm also getting the locked exist-db file while I'm fiddling with Orbeon
Websphere 8 deployment configuration changes (just messing with JNDI for a
SQLserver). I've stopped all Orbeon applications but the lock remains until
I stop/start all of Websphere. It does not always occur so it may be related
to what I'm doing between restarts.

Is it possible Orbeon is not shutting down cleanly and leaving a transaction
open somewhere? Say for example it thinks I have an unsaved edit on a form.

--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].

Alessandro Vernet

Re: Re: Embedded eXist Database locked while Tomcat running - how can I access?

Administrator

Hi Peter,

eXist-db is deployed as a servlet, and it should remove its lock file when
the servlet is "undeployed" (I would imagine it uses a
`ServletContextListener` and runs its shut down procedure when
`contextDestroyed()` is called). I don't think there is anything purely
specific to Orbeon Forms there.

Now I'm not sure what WebSphere does when you're doing some configuration
changes. It maybe just "kills" the web app, without shutting it down
properly, for speed, since this would typically only be done during
development.

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet