Forum Discussion

Level 4

14 years ago

Duplication fails with database system error (220)

Hi there.

I'm running Netbackup 7.1 on a RHEL 5 and I'm having the error "database system error (220)" when the duplication process runs.

Here's the full log:

16/Jun/2011 15:19:43 - begin Duplicate
16/Jun/2011 15:19:43 - requesting resource backupserver-hcart3-robot-tld-0
16/Jun/2011 15:19:43 - requesting resource backupserver-hcart3-robot-tld-0
16/Jun/2011 15:19:43 - granted resource FC0281
16/Jun/2011 15:19:43 - granted resource HP.ULTRIUM3-SCSI.001
16/Jun/2011 15:19:43 - granted resource backupserver-hcart3-robot-tld-0
16/Jun/2011 15:19:43 - granted resource FC0330
16/Jun/2011 15:19:43 - granted resource HP.ULTRIUM3-SCSI.000
16/Jun/2011 15:19:43 - granted resource backupserver-hcart3-robot-tld-0
16/Jun/2011 15:20:54 - Info bpdbm (pid=20149) cataloguing file number 10000 path /System State/Active Directory/CN=Configuration/CN=DisplaySpecifiers/CN=40B/CN=msExchOmaConnector-Display/classDisplayName
16/Jun/2011 15:21:29 - Info bpdbm (pid=20149) cataloguing file number 20000 path /System State/Active Directory/CN=Configuration/CN=DisplaySpecifiers/CN=413/CN=serviceAdministrationPoint-Display/
16/Jun/2011 15:22:21 - Info bpdbm (pid=20149) cataloguing file number 30000 path /System State/Active Directory/CN=Configuration/CN=DisplaySpecifiers/CN=816/CN=msExchIMGlobalSettingsContainer-Display/
16/Jun/2011 15:23:00 - Info bpdbm (pid=20149) cataloguing file number 40000 path /System State/Active Directory/CN=Configuration/CN=Services/CN=Microsoft Exchange/CN=Universidade de Lisboa/CN=Addressing/CN=Display-Templates/CN=40F/displayName
16/Jun/2011 15:24:10 - Info bpdbm (pid=20149) cataloguing file number 50000 path /System State/Active Directory/CN=Configuration/CN=Services/CN=Microsoft Exchange/CN=Universidade de Lisboa/CN=ELC Folders Container/CN=Deleted Items/msExchELCFolderType
16/Jun/2011 15:25:15 - Info bpdbm (pid=20149) cataloguing file number 60000 path /System State/Active Directory/CN=Configuration/CN=Sites/CN=Subnets/CN=194.117.13.0\24/description
16/Jun/2011 15:25:40 - Info bpdbm (pid=20149) cataloguing file number 70000 path /System State/Active Directory/DC=alunos/OU=DBA/OU=LIC/CN=Ana Maria Domingues Vieites/extensionAttribute1
16/Jun/2011 15:26:06 - Info bpdbm (pid=20149) cataloguing file number 80000 path /System State/Active Directory/DC=alunos/OU=DBA/OU=Licenciatura/CN=Ana Sofia Briosa e Scheltinga/givenName
16/Jun/2011 15:26:10 - Info bpdbm (pid=20149) cataloguing file number 90000 path /System State/Active Directory/DC=alunos/OU=DBA/OU=Licenciatura/CN=Diana Mileu Miranda Antunes/mailNickname
16/Jun/2011 15:26:16 - Info bpdbm (pid=20149) cataloguing file number 100000 path /System State/Active Directory/DC=alunos/OU=DBA/OU=Licenciatura/CN=Joana Santos Pinheiro AnastÃ¡cio/cn
16/Jun/2011 15:28:05 - Info bpdbm (pid=20149) cataloguing file number 200000 path /System State/Active Directory/DC=alunos/OU=DEGGE/OU=Licenciatura/CN=Jorge Miguel Nogueira Ponte/showInAddressBook
16/Jun/2011 15:29:35 - Info bpdbm (pid=20149) cataloguing file number 300000 path /System State/Active Directory/DC=alunos/OU=DG/OU=Licenciatura/CN=Joana Sofia Ferreira SimÃµes/msExchMailboxGuid
16/Jun/2011 15:31:59 - Info bpdbm (pid=20149) cataloguing file number 400000 path /System State/Active Directory/DC=alunos/OU=DI/OU=Licenciatura/CN=Tiago Alexandre da Costa Rodrigues/homeDrive
16/Jun/2011 15:33:49 - Info bpdbm (pid=20149) cataloguing file number 500000 path /System State/Active Directory/DC=alunos/OU=Externos/OU=Erasmus/CN=Giulia Bacchini/proxyAddresses
16/Jun/2011 15:41:54 - Error bpduplicate (pid=20142) db_IMAGE() failed: database system error (220)
16/Jun/2011 15:41:54 - Error bpduplicate (pid=20142) Status = no images were successfully processed.
16/Jun/2011 15:41:54 - Error bpduplicate (pid=20142) Duplicate of backupid alunos-dc01.hostname_1308108619 failed, database system error (220).
16/Jun/2011 15:41:54 - Error bpduplicate (pid=20142) Status = no images were successfully processed.
16/Jun/2011 15:41:54 - end Duplicate; elapsed time 0:22:11
no images were successfully processed (191)

Can anyone give me a help here?

Thanks.

Regards,
Ricardo Vilhena

Mark_Solutions
13 years ago
This does sound similar to the error as in other versions.

What happens is that bpdbm does not get an update within its hard codes timeout (not one that you can increase)

The only real fix that has been found is to use engineering binaries that increase the timeouts for bpdbm and bpcd.

Odd that this looks to be a tape to tape duplication as you would usually expect GRT to come from disk - or am i reading your log wrong?

I have also found in some cases that reducing the fragment size on images (particularly when de-dupe of any sort is involved) helps (5000MB works well) but in case it is just a tuning matter make sure you are using appropriate SIZE and NUMBER DATA BUFFERS for tape and DISK

Using a GRT Proxy Host (Windows server only) can also help as it can be faster by removing the load from the Exchange Server

Hope this helps

Marianne
Level 6
14 years ago
http://www.symantec.com/docs/HOWTO50980

NetBackup status code: 220

Message: database system error

Explanation: The bpdbm process (UNIX and Linux), or the NetBackup Database Manager service (Windows) did not create a directory path for its configuration catalogs. This error is due to a system call failure, which is usually due to a permission problem or an out of space condition.

Recommended Action: Create a debug log directory for bpdbm. Increase the logging level for the diagnostic and debug logs for nbemm.

Retry the operation and check the resulting logs for information.
Pritesh_Pisal
Level 5
14 years ago
faceing the same issue.............
vilhena
Level 4
14 years ago
I've looked for the logs, and I saw some system call errors, I guess, but there's no way to decypher these logs :/
Marianne
Level 6
14 years ago
Please post bpdbm and /var/log/messages as attachments.
Pritesh_Pisal
Level 5
14 years ago
Hi Please find the bpdm logs,also find the below error details

06/21/2011 09:09:10 - begin Duplicate
06/21/2011 09:09:10 - requesting resource xxx-hcart-robot-tld-0
06/21/2011 09:09:10 - awaiting resourcexxx -hcart-robot-tld-0. Waiting for resources.
          Reason: Media is in use, Media server:xxxx,
          Robot Type(Number): TLD(0), Media ID: N/A, Drive Name: N/A,
          Volume Pool: DailyDedicated, Storage Unit: -hcart-robot-tld-0, Drive Scan Host: N/A,
          Disk Pool: N/A, Disk Volume: N/A
06/21/2011 10:34:04 - granted resource 0045L4
06/21/2011 10:34:04 - granted resource IBM.ULT3580-HH4.001
06/21/2011 10:34:04 - granted resource xxx-hcart-robot-tld-0
06/21/2011 10:44:48 - Info bpdbm (pid=17192) cataloguing file number 10000 path /Microsoft Information Store/Top of Information Store/Sent Items/RE: 1+ year of exp in software testing <000000002e85e67800bf9544af015352ae66a5aa07003d5445983859b84b92669c0d883ea6fb0000004ee47400003d5445983859b84b92669c0d883ea6fb000006d3b7220000>
06/21/2011 10:45:15 - Error bpduplicate (pid=9619) db_IMAGE() failed: database system error (220)
06/21/2011 10:45:15 - Error bpduplicate (pid=9619) Status = no images were successfully processed.
06/21/2011 10:45:15 - Error bpduplicate (pid=9619) Duplicate of backupid xxxxx.com_1308580320 failed, database system error (220).
06/21/2011 10:45:15 - Error bpduplicate (pid=9619) Status = no images were successfully processed.
06/21/2011 10:45:15 - end Duplicate; elapsed time 1:36:05
no images were successfully processed (191)
bpdbm.txt29 KB
Marianne
Level 6
14 years ago
We need a bpdbm log that matches the period that you posted above.

According to your post, the duplication job started at 09:09 and failed at 10:45.

The log starts at 14:51 and ends at 15:05.
watsons
Level 6
14 years ago
Not sure how relevant it is to this technote http://www.symantec.com/docs/TECH143796, but the error looks similar (191 & database system error 220). But the technote is for 7.0.1, might want to check with support if the same applies to 7.1.

Is yours backup a normal filesystem backup (ALL_LCOAL_DRIVES), or Active-Directory GRT?
vilhena
Level 4
14 years ago
I saw that too Watsons, but in that case there is a network read failed error that does not happen here.

As soon as I can I'll send the log files.

Thanks.

Regards,

Vilhena
Pritesh_Pisal
Level 5
14 years ago
Sorry to update you late...

case has been logged with Symantec,they have asked for the fresh admin , bpbrm , bpbrmds , bpdbm , bptm & bpdm logs...even I havent recieved those logs as they are uploading through remote location to symantec ftp.

lets see what they says...will surly update the result!
Raid1
13 years ago

hi Pritesh

am facing the same issue ? did u solve it and how was it solved ? thanks for you help.

Regards,