cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Transaction Logs issues

pamorim
Level 3

Hi community,

I hereby request your assistance, I have:

Master Server:

Host - srv-netbckp-201

SO - Windows Server 2008 R2

Version - Symantec Netbackup 7.5.0.6

 

Media Server:

Host - srv-netbckp-101

SO -  RedHat Entreprise Linux Server Release 6.3

Version - Symantec Netbackup 7.5.0.6

 

Host - srv-netbckp-202

SO - Windows Server 2008 R2

Version - Symantec Netbackup 7.5.0.6

 

Backup on cliente:

Host - CX1ONIR3PRD1

SO - Windows Server 2003

Version - Symantec Netbackup 7.5.0.6

 

and I have the following issue, backups on SQL transactions logs in this client holds at 400000kb and still active.

 

Bdclient logs:

15:35:17.732 [6376.5180] <16> CDBbackrec::ClientStatus: ERR - Internal error. See the dbclient log for more information.

15:35:17.747 [6376.5180] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:17.747 [6376.5180] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2286 TO 172.25.12.11.1556 fd = 944

15:35:17.778 [6376.5180] <32> CDBbackrec::ClientStatus: ERR - Failed to get the client status because no BSA transaction is active.

15:35:17.778 [6376.5180] <16> CDBbackrec::ProcessVxBSAerror: ERR - Error in DBthreads::dbclient: 6.

15:35:17.778 [6376.5180] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:17.778 [6376.5180] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2287 TO 172.25.12.11.1556 fd = 944

15:35:17.825 [6376.5180] <1> CDBbackrec::ProcessVxBSAerror:     CONTINUATION: - The system cannot find the file specified.

15:35:17.841 [6376.5180] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:17.841 [6376.5180] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2288 TO 172.25.12.11.1556 fd = 936

15:35:17.872 [6376.5180] <16> DBthreads::dbclient: ERR - Error in VxBSAEndData: 6.

15:35:17.872 [6376.5180] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:17.872 [6376.5180] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2290 TO 172.25.12.11.1556 fd = 936

15:35:17.903 [6376.5180] <1> DBthreads::dbclient:     CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid.

15:35:17.903 [6376.5180] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:17.903 [6376.5180] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2291 TO 172.25.12.11.1556 fd = 944

15:35:20.732 [6376.8416] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x01a84ef0>

15:35:20.732 [6376.8416] <4> getServerName: Read server name from nb_master_config: srv-netbckp-201.backup.intranet.onitelecom.pt

15:35:20.732 [6376.8416] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:20.732 [6376.8416] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2298 TO 172.25.12.11.1556 fd = 684

15:35:20.825 [6376.8416] <16> CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->Close: 0x80770004.

15:35:20.841 [6376.8416] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:20.841 [6376.8416] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2299 TO 172.25.12.11.1556 fd = 824

15:35:20.888 [6376.8416] <1> CDBbackrec::FreeDeviceSet():     CONTINUATION: - An abort request is preventing anything except termination actions.

15:35:20.888 [6376.8416] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:20.888 [6376.8416] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2302 TO 172.25.12.11.1556 fd = 872

15:35:20.935 [6376.8416] <4> Dbbackrec::Perform: INF - OPERATION #1 of batch E:\Program Files\Veritas\NetBackup\DbExt\MsSql\Sql_TransLogs.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 76704(76704) seconds.

15:35:20.935 [6376.8416] <2> vnet_pbxConnect: pbxConnectEx Succeeded

15:35:20.935 [6376.8416] <2> logconnections: BPRD CONNECT FROM 172.25.12.113.2303 TO 172.25.12.11.1556 fd = 880

15:35:22.966 [6376.6360] <4> CDBbackmain::dbbackup: INF - Results of executing <E:\Program Files\Veritas\NetBackup\DbExt\MsSql\Sql_TransLogs.bch>:

<0> operations succeeded. <1> operations failed.

 

My first question is, what is the meaning of this message "Failed to get the client status because no BSA transaction is active"?

 

Thanks in Advance.
Best regards to all
 
(Updated the versions of Symantec Netbackup to 7.5.0.6 instead of 7.5.0.4)
11 REPLIES 11

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

If you copy & paste the following in Google:

"Failed to get the client status because no BSA transaction is active"

You will see that a Symantec TechNote is found.

http://www.symantec.com/docs/TECH200716

According to the TN:

 The permanent fix is in versions 7.5.0.5, 7.5.0.6, and 7.6

pamorim
Level 3

Realy sorry, I made a mistake with the versions when creating this topic, it's all updated to 7.5.0.6.

Before this errors, it was already set 9600 seconds on Client read Timeout.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

My reply above now really looks silly with your opening post edited to show 7.5.0.6 instead of the original 7.5.0.4......

pamorim
Level 3

Sorry Marianne, you are right, I should not edit the versions of my original post.

This will not happen again.

pamorim
Level 3

I am getting this errors on SQL:

2013-12-03 15:35:17.73 Backup      Error: 18210, Severity: 16, State: 1.
2013-12-03 15:35:17.73 Backup      BackupIoRequest::ReportIoError: write failure on backup device 'VNBU0-6376-8416-1386008217'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2013-12-03 15:35:17.73 Backup      Error: 18210, Severity: 16, State: 1.
2013-12-03 15:35:17.73 Backup      BackupIoRequest::ReportIoError: write failure on backup device 'VNBU0-6376-8416-1386008217'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2013-12-03 15:35:17.75 Backup      Error: 3041, Severity: 16, State: 1.
2013-12-03 15:35:17.75 Backup      BACKUP failed to complete the command BACKUP LOG P03. Check the backup application log for detailed messages.
2013-12-03 15:35:19.38 spid104     Error: 18210, Severity: 16, State: 1.
2013-12-03 15:35:19.38 spid104     BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'VNBU0-6376-8416-1386008217'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
 
I see that the problem comes from SQL, am I wrong?
Best regards

rookie11
Moderator
Moderator
   VIP   

on client CX1ONIR3PRD1

database ABC resides at a certain location on D:\. transaction log size is 400000kb. please check free space on D:\

 

pamorim
Level 3

The drive D:\ have 21,2GB free space.

rookie11
Moderator
Moderator
   VIP   

please share ur transaction log backup script. dbclient error log. plz check errors in eventvwr.

make sure u hav atleast 10-12 % disk space free on D: drive

V4
Level 6
Partner Accredited

verify logs in SQL studio events

pls post dbclient log

jayeshv
Not applicable

Hi,

Even m facing the same issue.

Master Server/Media Server : 7.6.0.1

Client: 7.6.0.1

08:20:01.567 [8536.4796] <32> CDBbackrec::ClientStatus: ERR - Failed to get the client status because no BSA transaction is active.
08:20:01.567 [8536.4796] <16> CDBbackrec::ProcessVxBSAerror: ERR - Error in DBthreads::dbclient: 6.
08:20:01.570 [8536.7352] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x004db540>

any help!!

rookie11
Moderator
Moderator
   VIP   

You havnt posted transaction log backup script