Multiple jboss instance - database lock

[dwarakanathan]

Hi,
I have a multiple instance JBoss. I face this Database lock issue. Actually i dont need any database for my 2nd instance. How do i remove it ?

WARN [ServiceController] Problem starting service jboss:service=Hypersonic,database=localDB
java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@114fd341[file =/....//.../data/hypersonic/localDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception: checkHeartbeat(): lock file [/u/hcdev101/apps/hca/jboss/server/logviewer/data/hypersonic/localDB.lck] is presumably locked by another process.

Thanks !!m

[dimitris]

You can't run 2 instances that look in the same files. You must need to have as many server configs as concurrent instances.

[dwarakanathan]

yes i do have 2 instances.. but still, the same error ;(

[peterj]

What Dimitris is saying is that you cannot run the 'default' or 'all' configuration (or in your case, the 'logviewer' configuration) twice to get your two instances; that will not work because the files will conflict.

As an example, when I run two instances, I do the following:

1) I copy the 'server/default' (or 'server/all') directory twice, once as 'server/server1' and 'server/server2'

2) I then run the instances as:

run -c server1
run -c server2

Since I have two different configuration directories, there are no file conflicts.