May 10, 2012 at 7:11 am
Hi al
I have been trying to a script using LITESPEED procs however I am getting an error when running the following:
DateTime: 2012-05-10 12:36:09
Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_slssqlmaint N'-MAINTDEL -DELFOLDER "\\BKPMEDIA5\DBTEST\DBTEST$TFS\master\FULL" -DELEXTENSION "bak" -DELUNIT "11522" -DELUNITTYPE "minutes" -DELUSEAGE' IF @ReturnCode <> 0 RAISERROR('Error deleting LiteSpeed backup files.', 16, 1)
HResult 0x2746, Level 16, State 1
TCP Provider: An existing connection was forcibly closed by the remote host.
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Communication link failure.
The backup itself runs ok, so it looks like it might be something related to the xp_slssqlmaint extended proc. Does anyone have any ideas how I can troubleshoot this?
Thanks
May 10, 2012 at 9:05 am
what is your Litespeed version you are using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 11, 2012 at 2:42 am
Hi Perry - the version is 5.0.2.1030 however this is working on other servers with the same version of LITESPEED
May 11, 2012 at 8:15 am
my first temptation would be to re run the instance configuration and re create all the procedures, if you're still having issues after that maybe check with Quest support
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2012 at 2:50 pm
Fair enough I will give that a whirl, thanks.
May 18, 2012 at 6:30 am
Hi - Ok I have re-installed LITESPEED and the whole instance still crashes.
The command I am running is:
DECLARE @ReturnCode int
EXECUTE @ReturnCode = [master].dbo.xp_slssqlmaint N'-MAINTDEL -DELFOLDER "\\BKPMEDIA5\DBTEST\DBTEST$TFS\master\FULL" -DELEXTENSION "bak" -DELUNIT "11521" -DELUNITTYPE "minutes" -DELUSEAGE'
IF @ReturnCode <> 0 RAISERROR('Error deleting LiteSpeed backup files.', 16, 1)
Just before the crash I can see in the event log the following:
Using 'xpSLS.dll' version '0005.00.02' to execute extended stored procedure 'xp_slssqlmaint'.
Then I get this:
Faulting application sqlservr.exe, version 2009.100.1600.1, time stamp 0x4bb6b40b, faulting module ntdll.dll, version 6.0.6002.18005, time stamp 0x49e0421d, exception code 0xc0000374, fault offset 0x00000000000aef37, process id 0x6e4, application start time 0x01cd34f060b7022f.
Its like SQL is unable to execute the xp command although it is running other xp commands e.g.
DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_backup_database @database = N'master', @filename = N'\\BKPMEDIA5\DBTEST\DBTEST$TFS\master\FULL\LS_DBTEST$TFS_master_FULL_20120518_114832.bak', @with = 'CHECKSUM', @compressionlevel = 5 IF @ReturnCode <> 0 RAISERROR('Error performing LiteSpeed backup.', 16, 1)
Anyone seen this behaviour before?
May 18, 2012 at 6:40 am
We've had simliar(ish) issues in the past with Litespeed "Losing connection" to the database engine, in that case I think we had to re-start the SQL Service to fix this issue.
Sorry if it's a little vague, it was about 18 months ago.
May 18, 2012 at 6:41 am
Well the box has been rebooted several times and still does not fix the problem.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply