DFM3.8 db backup Error: Database cannot be started -- Unknown error (37)

etpdutyofficer · ‎2010-08-05

Am unable to take backups of DFM db. dfmbackuplog telling Unknown error (37). Any pointers/help in trying to resolve this problem appreciated.

[dfmserver/Linux]# dfm version
dfm 3.8 (3.8.1D2)

[dfmserver/Linux]# dfm service list
sql: started
http: started
eventd: started
monitor: started
scheduler: started
server: started
watchdog: started

[dfmserver/Linux]# dfm backup create testbu

Disabling Performance Advisor.

SQL Anywhere Backup Utility Version 10.0.1.3830

(251410 of 250092 pages, 100% complete)

Database backup completed

Enabling Performance Advisor.

Error: dbstop process returned error.

[dfmserver/Linux]#

/opt/NTAPdfm/log/dfmbackup.log

------- snip start---------------

Aug 04 16:39:59 [dfm: INFO]: dbeng9 process spawned with pid = 25860.

Aug 04 16:39:59 [dfm: INFO]: dbvalid process spawned successfully, pid = 25861.

I. 08/04 16:39:59. SQL Anywhere Personal Server Version 10.0.1.3830

I. 08/04 16:39:59.

I. 08/04 16:39:59. This software contains confidential and trade secret information of

I. 08/04 16:39:59. iAnywhere Solutions, Inc.

I. 08/04 16:39:59. Use, duplication or disclosure of the software and documentation

I. 08/04 16:39:59. by the U.S. Government is subject to restrictions set forth in a license

I. 08/04 16:39:59. agreement between the Government and iAnywhere Solutions, Inc. or

I. 08/04 16:39:59. other written agreement specifying the Government's rights to use the

I. 08/04 16:39:59. software and any applicable FAR provisions, for example, FAR 52.227-19.

I. 08/04 16:39:59.

I. 08/04 16:39:59. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA

I. 08/04 16:39:59.

I. 08/04 16:39:59. 4 logical processor(s) on 2 physical processor(s) detected.

I. 08/04 16:39:59. This server is licensed to:

I. 08/04 16:39:59. DFM User

I. 08/04 16:39:59. NetApp

I. 08/04 16:39:59. Running Linux 2.6.18-164.11.1.el5 #1 SMP Wed Jan 6 13:26:04 EST 2010 on X86_64

I. 08/04 16:39:59. Server built for X86 processor architecture

I. 08/04 16:39:59. Authenticated Server licensed for use with Authenticated Applications only

I. 08/04 16:39:59. 1048576K of memory used for caching

I. 08/04 16:39:59. Minimum cache size: 8192K, maximum cache size: 1834880K

I. 08/04 16:39:59. Using a maximum page size of 8192 bytes

I. 08/04 16:39:59. Starting database "dfmBackupDbvalidDatabase" (/mnt/dfm_backup/dfm_temp_dest_dir//monitordb.db) at Wed Aug 04 2010 16:39

I. 08/04 16:39:59. Database recovery in progress

I. 08/04 16:39:59. Last checkpoint at Wed Aug 04 2010 16:39

I. 08/04 16:39:59. Checkpoint log...

Aug 04 16:40:00 [dfm: INFO]: dbvalid process spawned successfully, pid = 25880.

Aug 04 16:40:01 [dfm: INFO]: dbvalid process spawned successfully, pid = 25898.

Aug 04 16:40:02 [dfm: INFO]: dbvalid process spawned successfully, pid = 25905.

Aug 04 16:40:03 [dfm: INFO]: dbvalid process spawned successfully, pid = 25910.

Aug 04 16:40:05 [dfm: INFO]: dbvalid process spawned successfully, pid = 25915.

Aug 04 16:40:06 [dfm: INFO]: dbvalid process spawned successfully, pid = 25920.

Aug 04 16:40:07 [dfm: INFO]: dbvalid process spawned successfully, pid = 25925.

Aug 04 16:40:08 [dfm: INFO]: dbvalid process spawned successfully, pid = 25936.

Aug 04 16:40:09 [dfm: INFO]: dbvalid process spawned successfully, pid = 25943.

Aug 04 16:40:10 [dfm: INFO]: dbvalid process spawned successfully, pid = 25948.

Aug 04 16:40:11 [dfm: INFO]: dbvalid process spawned successfully, pid = 25953.

Aug 04 16:40:12 [dfm: INFO]: dbvalid process spawned successfully, pid = 25958.

Aug 04 16:40:13 [dfm: INFO]: dbvalid process spawned successfully, pid = 25963.

Aug 04 16:40:14 [dfm: INFO]: dbvalid process spawned successfully, pid = 25968.

Aug 04 16:40:15 [dfm: INFO]: dbvalid process spawned successfully, pid = 25973.

Aug 04 16:40:16 [dfm: INFO]: dbvalid process spawned successfully, pid = 25978.

Aug 04 16:40:17 [dfm: INFO]: dbvalid process spawned successfully, pid = 25983.

Aug 04 16:40:18 [dfm: INFO]: dbvalid process spawned successfully, pid = 25988.

Aug 04 16:40:19 [dfm: INFO]: dbvalid process spawned successfully, pid = 26135.

Aug 04 16:40:20 [dfm: INFO]: dbvalid process spawned successfully, pid = 26142.

Aug 04 16:40:21 [dfm: INFO]: dbvalid process spawned successfully, pid = 26147.

Aug 04 16:40:22 [dfm: INFO]: dbvalid process spawned successfully, pid = 26152.

Aug 04 16:40:23 [dfm: INFO]: dbvalid process spawned successfully, pid = 26157.

Aug 04 16:40:24 [dfm: INFO]: dbvalid process spawned successfully, pid = 26163.

Aug 04 16:40:25 [dfm: INFO]: dbvalid process spawned successfully, pid = 26172.

Aug 04 16:40:26 [dfm: INFO]: dbvalid process spawned successfully, pid = 26261.

Aug 04 16:40:27 [dfm: INFO]: dbvalid process spawned successfully, pid = 26266.

Aug 04 16:40:28 [dfm: INFO]: dbvalid process spawned successfully, pid = 26283.

Aug 04 16:40:29 [dfm: INFO]: dbvalid process spawned successfully, pid = 26392.

E. 08/04 16:40:29. Error: Database cannot be started -- Unknown error (37)

E. 08/04 16:40:29. Database cannot be started -- Unknown error (37)

I. 08/04 16:40:29. Database server shutdown due to startup error

I. 08/04 16:40:30. Database server stopped at Wed Aug 04 2010 16:40

Aug 04 16:40:30 [dfm: INFO]: dbvalid process spawned successfully, pid = 26397.

SQL Anywhere Stop Server Utility Version 10.0.1.3830

Unable to stop database server -- Database server not found.

Aug 04 16:40:30 [dfm:ERROR]: dbstop process returned error = 1.

Aug 04 16:40:30 [dfm:ERROR]: dbstop process returned error.

Aug 04 16:40:30 [dfm:ERROR]: Database backup create failed

------- snip end---------------

rranga · ‎2010-08-05

Is the DFM or backup dir on a NFS mount point? If so, can you try to do the backup on a non-NFS directory?

etpdutyofficer · ‎2010-08-05

Yes. the DFM db backup is to NFS mounted disk. Tried backup to local disk and it works fine - thanks for the suggestion in trying this. Could be then issue with NFS disk export permissions.

hanspeter_proprentne · ‎2011-09-15

I use a nfs mount for backup and it has been working for a while. Then I get the same error: SQLAnywhere(dfmbackupdbvalidengine): Error: Database cannot be started -- Unknown error (37).

I restarted the nfslock service because the nfslock service hang up -> now it works.

vladimirzhigulin · ‎2011-08-02

So DFM database backup doesn't support NFS?

I just tried it on "dfm 4.0.2 (4.0.2)", where /storage-03/backup_dfm/ is NFS volume with 777 permissions and DFM host has root permissions on it:

==> access.log <==

10.154.82.110 - - [02/Aug/2011:13:53:40 +0200] "POST /dfm/option/set HTTP/1.1" 302 -

==> dfmbackup.log <==

Aug 02 13:53:40 [dfmserver: INFO]: [6399:0xeefffb90]: script_dir_size=0.

==> dfmcmd.log <==

Aug 02 13:53:40 [dfm: INFO]: [14405:0xf74b76c0]: Error: Could not get size of destination directory /storage-03/backup_dfm/. Please make sure this directory exists.

==> dfmserver.log <==

Aug 02 13:53:40 [dfmserver:ERROR]: [6399:0xeefffb90]: Error: Unable to confirm space available in /storage-03/backup_dfm/.

Could someont clarify that please?

Thanks,

Vladimir

adrien_manteau · ‎2011-10-21

An answer, perhaps?

Does the "DFM database backup" supports NFS?

Thanks.