LMS 3.2 - Backup hangs with validating ANI-DB

Unanswered Question
Mar 29th, 2010

Hello all,

on our Solaris Systems running LMS 3.2 backup struggles with backing up ANI-DB (even after doing Restore of orig db).

As the problem arises on more than one LMS 3.2 system with same patch-level my question

to you -> is this a known problem?

Thanks for any feedback

Lothar

-------------------------------------------------------------------

Here's the point when backup results in freeze

(dbbackup.log)


[Mon Mar 29 11:32:01 2010] Archiving the contents of the following directories into /enbw/backup/files/cw_db_backup_nfs/4/campus/filebackup.tar
[Mon Mar 29 11:32:01 2010] /opt/CSCOpx/campus/etc/cwsi/DeviceDiscovery.properties
/opt/CSCOpx/campus/etc/cwsi/ANIServer.properties
/opt/CSCOpx/campus/etc/cwsi/ut.properties
/opt/CSCOpx/campus/etc/cwsi/discoverysnmp.conf
/opt/CSCOpx/campus/etc/cwsi/datacollectionsnmp.conf
/opt/CSCOpx/campus/etc/cwsi/WlseUhic.properties
/opt/CSCOpx/campus/etc/cwsi/UTSnmpv3EngineParam.txt
/opt/CSCOpx/campus/etc/cwsi/UTDiscoverOnTrunk.properties
/opt/CSCOpx/campus/etc/cwsi/users
/opt/CSCOpx/campus/etc/cwsi/archives
/opt/CSCOpx/campus/etc/users
/opt/CSCOpx/campus/etc/cwsi/ReportArchives
/opt/CSCOpx/campus/etc/cwsi/CMReportArchives
/opt/CSCOpx/campus/etc/cwsi/portsData.xml
/opt/CSCOpx/campus/etc/cwsi/RouterData.xml
/opt/CSCOpx/campus/etc/cwsi/vlanData.xml
/opt/CSCOpx/campus/etc/cwsi/CMHP.properties
/opt/CSCOpx/campus/etc/cwsi/MACDetection.properties
/opt/CSCOpx/campus/etc/cwsi/OUI.properties
/opt/CSCOpx/campus/etc/cwsi/PortModuleConfig.properties
/opt/CSCOpx/htdocs/campus/maps
/opt/CSCOpx/campus/lib/classpath/com/cisco/nm/cm/ut/uhic/utlite/properties/utliteuhic.properties
/opt/CSCOpx/campus/lib/classpath/com/cisco/nm/cm/ut/utm/properties/utm.properties
/opt/CSCOpx/campus/lib/classpath/com/cisco/nm/cm/ut/uhic/mac/properties/macuhic.properties
/opt/CSCOpx/campus/etc/cwsi/vnmData.xml
/opt/CSCOpx/vnm/conf/VNMServer.properties
/opt/CSCOpx/vnm/conf/VNMClient.properties
/opt/CSCOpx/vnm/conf/velocity.properties
/opt/CSCOpx/vnm/conf/VRFCollectorSnmp.conf
/opt/CSCOpx/vnm/reports/VNMReportArchives/archives
/opt/CSCOpx/vnm/reports/VNMReportArchives/jobs

/opt/CSCOpx/bin/tar: Removing leading `/' from absolute path names in the archive
mkdir /enbw/backup/files/cw_db_backup_nfs/4/campus/database/
[Mon Mar 29 11:32:11 2010] Backing up database aniDb:SQL Anywhere Command File Hiding Utility Version 10.0.1.3830
SQL Anywhere Backup Utility Version 10.0.1.3830
(3348 of 3345 pages, 100% complete)
Database backup completed
SQL Anywhere Command File Hiding Utility Version 10.0.1.3830

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 2 (1 ratings)
Loading.
Joe Clarke Mon, 03/29/2010 - 22:25

At this phase, the backup is trying to verify the database.  When that hangs, it typically means the database is corrut in some way.  It could also point to a very large ANI database, and this phase is just taking a long time.  It also looks like you're trying to backup to an NFS mount.  Can you try a backup to a local file system, and see if the verification completes?

--

Please support CSC Helps Haiti

https://supportforums.cisco.com/docs/DOC-8895

https://supportforums.cisco.com

lo.mueller Mon, 03/29/2010 - 23:34

Hi Joe,

thanks for your feedback.

Do you have any experiences with doing backups with Sybase over NFS-Shares (NFS-Share will be mounted with automounter)?

Are there recommended/best practise settings/NFS-Options?

Doing backup directly to NFS-Share would be first choice for our backup-mgmt (centralized NAS).

Best Regards

Lothar

Joe Clarke Tue, 03/30/2010 - 09:35

We recommend customers do a backup locally, then move the backup directory to a network-attached file system.  For example, you could wrap the backup.pl script to run the backup, then copy the resulting directory if the backup runs completely.  This approach is safer because if the copy operation fails, you still have a good local copy.

--

Please support CSC Helps Haiti

https://supportforums.cisco.com/docs/DOC-8895

https://supportforums.cisco.com

Actions

This Discussion