Error - Caused by Java SQL SQLException Database Is Locked

Version 2 by David Young
on Jan 27, 2011 11:56.

<< Changes from 1 to 2

compared with

Current by Nata Ramanenka
on Feb 20, 2012 01:22.

Key

This line was removed.

This word was removed. This word was added.

This line was added.

Changes (1)

View Page History

h1. Error - Caused by: java.sql.SQLException: Database Is Locked

{kb-symptom}
User gets this error with CDP 3 Disk Safe stored on NFS:

...

{code}
2011-01-19 16:31:00,880 ERROR - TASK(zimbra backup): Error replicating device / (0714caf7-ec47-4ba1-83fa-ffabaaee9030)
com.r1soft.backup.server.disksafe.blockstore.Rib: Failed to load block store
at com.r1soft.backup.server.disksafe.blockstore.Rf.loadDB(Rf.java:558)
at com.r1soft.backup.server.disksafe.blockstore.Rg.openR1DBNativeBlockStore(Rg.java:31)
at com.r1soft.backup.server.disksafe.blockstore.Rd.open(Rd.java:75)
at com.r1soft.backup.server.disksafe.blockstore.Ri.getBlockStore(Ri.java:65)
at com.r1soft.backup.server.disksafe.metadata.entity.RecoveryPoint.startAddMember(RecoveryPoint.java:646)
at com.r1soft.backup.server.task.DataProtectionPolicyTask.Ra(DataProtectionPolicyTask.java:1470)
at com.r1soft.backup.server.task.DataProtectionPolicyTask.Ra(DataProtectionPolicyTask.java:1361)
at com.r1soft.backup.server.task.DataProtectionPolicyTask.Rc(DataProtectionPolicyTask.java:943)
at com.r1soft.backup.server.task.DataProtectionPolicyTask.run(DataProtectionPolicyTask.java:398)
at com.r1soft.backup.server.task.scheduler.TaskRunner.run(TaskRunner.java:155)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: database is locked
at com.r1soft.r1db.DB.throwex(DB.java:289)
at com.r1soft.r1db.NativeDB.prepare(Native Method)
at com.r1soft.r1db.DB.prepare(DB.java:115)
at com.r1soft.r1db.Stmt.execute(Stmt.java:82)
at com.r1soft.backup.server.disksafe.blockstore.Rf.configPragmas(Rf.java:441)
at com.r1soft.backup.server.disksafe.blockstore.Rf.loadDB(Rf.java:529)
...
{code}
{color:black}Setup is a CDP 3.8.2 on CentOS backing up to a NetApp SAN over NFS3.{color}
{kb-cause}
CDP 3.0 uses file locks on the block store to protect the block store from another instance of CDP accidentally trying to open it. 
{kb-resolution}
Resolution is starting {color:blue}nfslock{color} on the Linux NFS client where CDP Server is running.

To start {color:blue}nfslock{color}, run the following command:
{code}
/etc/init.d/nfslock start
{code}
See the "Linux NFS configuration services" article in [http://www.dba-oracle.com/oracle_tips_linux_nfs.htm] for more information.
{kb-related-articles}