Currently running Netbackup 3.4.1 on an NT4 master\media server with the
latest NB_341_3 patch.
On a regular basis we have been seeing a Status code 54 on SQL Server
Class jobs. We have about twenty-five SQL Servers in this class, with at
least ten databases per server and there will always be one database that
errors with a Status Code 54, all of the other databases back-up ok.
These are full backups and the error never occurs on the same database or
the same sever.
We have changed all tape media to new ones with no success.
Below is a list of the errors from the dbclient and dbbackup logs.
lnspbck01 is our Master\media server. RRLN08 is a SQL Server client.
dbclient
08:16:05 [277.266] <2> bind_on_port_addr: bound to port 4663
08:16:05 [277.266] <2> bprd_connect: no authentication required
08:16:05 [277.266] <4> serverResponse: initial client_read_timeout = <3600>
08:16:15 [277.266] <4> serverResponse: INF - Server buffer size = 65536
08:16:15 [277.266] <4> serverResponse: INF - comm file read timeout set to
3600
08:16:15 [277.266] <2> bind_on_port_addr: bound to port 0
08:16:15 [277.266] <4> serverResponse: INF - DATA sockfd: 1340
08:16:15 [277.266] <2> bind_on_port_addr: bound to port 0
08:16:18 [277.266] <2> bind_on_port_addr: bound to port 0
08:16:21 [277.266] <2> bind_on_port_addr: bound to port 0
08:18:50 [277.266] <16> connectSock: ERR - connect() to server failed,
Connection refused.
08:18:50 [277.266] <16> serverResponse: ERR - cannot connect on NAME socket
lnspbck01.4901
08:18:50 [277.266] <16> dbc_open: ERR - serverResponse() failed
08:18:50 [277.266] <4> closeApi: INF - EXIT STATUS 6: the backup failed to
back up the requested files
dbbackup
08:16:05 [277,254] <4> InitPipeInfo: INF - Using backup image
'rrln08.MSSQL7.RRLN08.db.RMS_SYSTEMDATA.~.0.001of001.20020525081605..C'.
08:16:05 [277,254] <4> Dbbackrec::Perform: INF - backup database
"RMS_SYSTEMDATA" to VIRTUAL_DEVICE='VNBU0-277-254' with blocksize = 512,
maxtransfersize = 65536, buffercount = 1
08:16:05 [277,254] <4> Dbbackrec::Perform: INF - #Stripes: 1, #Bufs per
stripe 1, To: NetBackup on lnspbck01
08:16:05 [277,254] <4> DBConnect: INF - Logging into SQL Server with DSN
<VeritasBackup>, SQL userid <sa>.
08:18:50 [277,72] <4> KillAllThreads: INF - Issuing SignalAbort to MS SQL
Server VDI
08:18:50 [277,266] <32> DBthreads::dbclient: ERR - Error returned when
opening dbclient, pipe #0
08:18:51 [277,254] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC error.
ODBC return code <-1>, SQL State <37000>, Message Text <[Microsoft][ODBC
SQL Server Driver][SQL Server]Write on 'VNBU0-277-254' failed, status =
995. See the SQL Server error log for more details.>
08:18:51 [277,254] <32> Dbbackrec::Perform: ERR - Error found executing
<backup database "RMS_SYSTEMDATA" to VIRTUAL_DEVICE='VNBU0-277-254' with
blocksize = 512, maxtransfersize = 65536, buffercount = 1>
08:18:51 [277,254] <32> CDBbackrec::FreeDeviceSet(): ERR - Error in
VDS->Close: 0x80770004. The text follows:
08:18:51 [277,254] CONTINUATION: - An abort request is preventing
anything except termination actions.
08:18:51 [277,254] <4> Dbbackrec::Perform: INF - OPERATION #93 of batch C:
\Program Files\VERITAS\batch\UP_to_End.bch FAILED with STATUS 1 (0 is
normal). Elapsed time = 166(166) seconds.
Any help would be appreciated.
Thanks.
Chan Bhangra
|
