cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

SQL-Error

Dirk_Mueller
Level 5

‎11-02-2006 04:19 AM

HI@ll,

sometimes one or more streams of our sql-backups fails with NB-error-code 6.
A few minutes later the same job runs again without error.

Here�s the dbclient-Log:

18:56:16.515 <16> readCommFile: ERR - timed out after 900 seconds while reading from C:\VERITAS\NetBackup\Logs\user_ops\dbext\logs\2864.0.1162402831
18:56:31.890 <16> readCommFile: ERR - timed out after 900 seconds while reading from C:\VERITAS\NetBackup\Logs\user_ops\mssql\logs\1101106184011-284-1744-000-000-prg
19:21:06.515 <16> readCommFile: ERR - timed out after 900 seconds while reading from C:\VERITAS\NetBackup\Logs\user_ops\dbext\logs\2864.0.1162402831
19:21:06.515 <32> serverResponse: ERR - could not read from comm file <>
19:21:06.515 <16> CreateNewImage: ERR - serverResponse() failed
19:21:06.515 <16> VxBSACreateObject: ERR - Could not create new image with file /uhd-zv01.MSSQL7.UHD-ZV01\HELPLINE.db.Helpline_System.~.0.001of001.20061101184031..C.
19:21:06.515 <4> getServerName: Read server name from nb_master_config: vms-zv01
19:21:06.515 <2> logconnections: BPRD CONNECT FROM 10.10.152.108.3525 TO 10.10.152.64.13720
19:21:06.921 <4> getServerName: Read server name from nb_master_config: vms-zv01
19:21:06.921 <2> logconnections: BPRD CONNECT FROM 10.10.152.108.3526 TO 10.10.152.64.13720
19:21:09.000 <32> DBthreads::dbclient: ERR - failed with error <3>. The text follows:
19:21:09.000 <1> DBthreads::dbclient: CONTINUATION: - System detected error, operation aborted.
19:21:09.000 <8> close_image: Session being terminated abnormally, cleaning up
19:21:09.000 <4> close_image: INF - backup FAILED
19:21:09.000 <4> close_image: INF ---- end of Backup ---

19:21:09.000 <4> KillAllThreads: INF - entering KillAllThreads <2>
19:21:09.000 <4> KillAllThreads: INF - Killing group #0
19:21:09.000 <4> KillAllThreads: INF - Issuing SignalAbort to MS SQL Server VDI
19:21:09.000 <4> KillAllThreads: INF - entering KillAllThreads <2>
19:21:09.000 <4> KillAllThreads: INF - Killing group #0
19:21:09.015 <4> KillAllThreads: INF - entering KillAllThreads <2>
19:21:09.015 <4> KillAllThreads: INF - Killing group #0
19:21:10.015 <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message Text
19:21:10.015 <16> CODBCaccess::LogODBCerr: DBMS MSG -
19:21:10.015 <32> Dbbackrec::PerformNBOperation: ERR - Error found executing
19:21:10.015 <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b52420>
19:21:10.015 <4> getServerName: Read server name from nb_master_config: vms-zv01
19:21:10.015 <2> logconnections: BPRD CONNECT FROM 10.10.152.108.3529 TO 10.10.152.64.13720
19:21:11.968 <32> CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->Close: 0x80770004. The text follows:
19:21:11.968 <1> CDBbackrec::FreeDeviceSet(): CONTINUATION: - An abort request is preventing anything except termination actions.
19:21:11.968 <4> Dbbackrec::Perform: INF - OPERATION #2 of batch C:\LVR\bin\backup_all.bch FAILED with status 1. Elapsed time = 2440(2440) seconds.
19:36:26.890 <16> readCommFile: ERR - timed out after 900 seconds while reading from C:\VERITAS\NetBackup\Logs\user_ops\mssql\logs\1101106184011-284-1744-000-000-prg
19:36:26.890 <32> serverResponse: ERR - could not read from comm file <>
19:36:26.890 <16> CreateNewImage: ERR - serverResponse() failed
19:36:26.890 <16> VxBSACreateObject: ERR - Could not create new image with file /uhd-zv01.MSSQL7.UHD-ZV01\HELPLINE.db.Helpline_Daten.~.0.001of001.20061101184030..C.
19:36:26.890 <32> DBthreads::dbclient: ERR - failed with error <3>. The text follows:
19:36:26.890 <1> DBthreads::dbclient: CONTINUATION: - System detected error, operation aborted.
19:36:26.890 <8> close_image: Session being terminated abnormally, cleaning up
19:36:26.890 <4> close_image: INF - backup FAILED
19:36:26.890 <4> close_image: INF ---- end of Backup ---

19:36:26.890 <4> KillAllThreads: INF - entering KillAllThreads <1>
19:36:26.890 <4> KillAllThreads: INF - Killing group #0
19:36:26.890 <4> KillAllThreads: INF - Issuing SignalAbort to MS SQL Server VDI
19:36:26.890 <4> KillAllThreads: INF - entering KillAllThreads <1>
19:36:26.890 <4> KillAllThreads: INF - Killing group #0
19:36:26.906 <4> KillAllThreads: INF - entering KillAllThreads <1>
19:36:26.906 <4> KillAllThreads: INF - Killing group #0
19:36:27.906 <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message Text
19:36:27.906 <16> CODBCaccess::LogODBCerr: DBMS MSG -
19:36:27.906 <32> Dbbackrec::PerformNBOperation: ERR - Error found executing
19:36:27.906 <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b51590>
19:36:27.921 <32> CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->Close: 0x80770004. The text follows:
19:36:27.921 <1> CDBbackrec::FreeDeviceSet(): CONTINUATION: - An abort request is preventing anything except termination actions.

Any idea for my problem???

Kind regards
Dirk
0 Kudos
2 REPLIES 2

zippy
Level 6

‎11-02-2006 06:43 AM

Dirk,

The errors look like Network or Resource errors or both. When you run a backup check the perfomance on the server, and ask your Network admin to check the switch the NIC card is plugged int ot see if there are any errors. Make sure the speed of all hardware the cat 5 cable touches is at the same speed.

JD
0 Kudos

Dennis_Strom
Level 6

‎11-02-2006 09:30 AM

good tuning forum discussion covers a lot. If you read the stuff in here you will have a fairly good understanding of the whole mess. I think it will help you out. I know it helped me. follow the links.
http://forums.symantec.com/discussions/thread.jspa?threadID=67607&tstart=0
0 Kudos