sql error 15138: response

Showing posts with label response. Show all posts

Tuesday, March 27, 2012

error 17883

Hi, ALL
We are getting error 17883
Backup for DB "GBK" was not creating.
19:22 first error.
~ 07:00 users begin to work. Server does not response.
~ 07:13 administrator log in to console.
07:31 server restart. there are no error in error log.
Errorlog:
2006-04-06 19:20:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6750:1, last LSN:
1131478:6786:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:21:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:21:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:22:03.13 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6786:1, last LSN:
1131478:6814:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:22:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:22:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:24:03.21 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6814:1, last LSN:
1131478:6850:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:26:03.12 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6850:1, last LSN:
1131478:6867:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:28:03.20 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6867:1, last LSN:
1131478:6919:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:30:02.70 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:30:04.65 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6919:1, last LSN:
1131478:6962:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:31:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:31:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:32:03.18 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6962:1, last LSN:
1131478:7027:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:34:03.23 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7027:1, last LSN:
1131478:7070:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:36:03.31 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7070:1, last LSN:
1131478:7096:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:37:08.94 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:37:08.94 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:38:03.28 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7096:1, last LSN:
1131478:7127:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:40:02.13 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:40:03.22 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7127:1, last LSN:
1131478:7175:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:42:03.19 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7175:1, last LSN:
1131478:7220:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:44:03.22 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7220:1, last LSN:
1131478:7247:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:44:08.94 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:44:08.94 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:46:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7247:1, last LSN:
1131478:7264:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:48:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7264:1, last LSN:
1131478:7286:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:50:02.13 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:50:03.28 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7286:1, last LSN:
1131478:7293:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:52:03.21 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7293:1, last LSN:
1131478:7305:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:54:03.18 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7305:1, last LSN:
1131478:7307:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:56:03.11 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7307:1, last LSN:
1131478:7309:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:58:03.10 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7309:1, last LSN:
1131478:7319:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 22:30:02.74 spid55 Attempting to cycle errorlog.
2006-04-06 22:30:02.83 spid55 Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2006-04-06 22:30:02.83 spid55 Copyright (C) 1988-2002 Microsoft
Corporation.
2006-04-06 22:30:02.83 spid55 All rights reserved.
2006-04-06 22:30:02.83 spid55 Server Process ID is 636.
2006-04-06 22:30:02.83 spid55 Logging SQL Server messages in file
'd:\mssql2000\MSSQL\log\ERRORLOG'.
2006-04-06 22:30:02.83 spid55 Errorlog has been reinitialized. See
previous log for older entries.
2006-04-06 22:30:05.14 spid55 DBCC CHECKDB (master) executed by
domain\user found 0 errors and repaired 0 errors.
2006-04-06 22:30:06.81 backup Database backed up: Database: master,
creation date(time): 2006/03/24(20:39:08), pages dumped: 1963, first LSN:
312:455:1, last LSN: 312:457:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'master_full'}).
2006-04-06 22:30:08.88 spid54 DBCC CHECKDB (msdb) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-06 22:30:12.94 backup Database backed up: Database: msdb,
creation date(time): 2000/08/06(01:40:56), pages dumped: 4811, first LSN:
18066:979:1, last LSN: 18066:982:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'msdb_full'}).
2006-04-06 22:30:13.89 spid54 DBCC CHECKDB (sqladmin) executed by
domain\user found 0 errors and repaired 0 errors.
2006-04-06 22:30:14.99 backup Database backed up: Database: sqladmin,
creation date(time): 2003/04/21(14:44:13), pages dumped: 258, first LSN:
27404:239:1, last LSN: 27404:241:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'sqladmin_full'}).
2006-04-06 22:30:17.50 spid55 DBCC CHECKDB (GSM) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-06 22:30:31.42 backup Database log truncated: Database: GSM.
2006-04-06 22:30:33.74 backup Database backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), pages dumped: 3750, first LSN: 46638:361:1,
last LSN: 46638:363:1, number of dump devices: 1, device information:
(FILE=1, TYPE=DISK: {'GSM_full'}).
2006-04-06 22:44:07.73 spid56 DBCC CHECKDB (gbk) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-07 00:18:47.12 backup Database log truncated: Database: gbk.
2006-04-07 07:14:53.14 server Error: 17883, Severity: 1, State: 0
2006-04-07 07:14:53.14 server The Scheduler 2 appears to be hung. SPID 0,
ECID 0, UMS Context 0x07A86300.
2006-04-07 07:14:56.42 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:361:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:20:03.00 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:30:03.30 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:31:17.07 backup BACKUP failed to complete the command PRINT
'creating full backup GBK'
backup database [gbk] to [gbk_full] with stats=100, init, skip
2006-04-07 07:31:27.73 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
...
Server restart
Hello
In essence all this 17883 message tells us is that no context switches were
made on the scheduler. The two things that I can think of are a) a hung
scheduler, or b) a thread that is not properly yielding to the scheduler.
I would suggest opening up a case with PSS since this need memory dump to
find clues to troubleshoot the issue.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, please make sure you have latest service pack installed on the
server.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: error 17883
>thread-index: AcZaGCgcfWSWeH5/QoCXiTp9pSJ7YQ==
>X-WBNR-Posting-Host: 212.12.3.11
>From: =?Utf-8?B?dmFkaW1t?= <white@.community.nospam>
>Subject: error 17883
>Date: Fri, 7 Apr 2006 00:52:02 -0700
>Lines: 186
>Message-ID: <1961654E-C620-4AFA-BD4A-A731BCA877CE@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427204
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi, ALL
>We are getting error 17883
>Backup for DB "GBK" was not creating.
> 19:22 first error.
>~ 07:00 users begin to work. Server does not response.
>~ 07:13 administrator log in to console.
> 07:31 server restart. there are no error in error log.
>Errorlog:
>2006-04-06 19:20:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6750:1, last LSN:
>1131478:6786:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:21:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:21:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:22:03.13 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6786:1, last LSN:
>1131478:6814:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:22:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:22:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:24:03.21 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6814:1, last LSN:
>1131478:6850:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:26:03.12 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6850:1, last LSN:
>1131478:6867:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:28:03.20 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6867:1, last LSN:
>1131478:6919:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:30:02.70 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:30:04.65 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6919:1, last LSN:
>1131478:6962:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:31:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:31:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:32:03.18 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6962:1, last LSN:
>1131478:7027:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:34:03.23 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7027:1, last LSN:
>1131478:7070:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:36:03.31 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7070:1, last LSN:
>1131478:7096:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:37:08.94 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:37:08.94 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:38:03.28 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7096:1, last LSN:
>1131478:7127:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:40:02.13 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:40:03.22 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7127:1, last LSN:
>1131478:7175:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:42:03.19 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7175:1, last LSN:
>1131478:7220:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:44:03.22 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7220:1, last LSN:
>1131478:7247:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:44:08.94 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:44:08.94 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:46:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7247:1, last LSN:
>1131478:7264:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:48:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7264:1, last LSN:
>1131478:7286:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:50:02.13 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:50:03.28 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7286:1, last LSN:
>1131478:7293:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:52:03.21 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7293:1, last LSN:
>1131478:7305:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:54:03.18 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7305:1, last LSN:
>1131478:7307:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:56:03.11 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7307:1, last LSN:
>1131478:7309:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:58:03.10 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7309:1, last LSN:
>1131478:7319:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 22:30:02.74 spid55 Attempting to cycle errorlog.
>2006-04-06 22:30:02.83 spid55 Microsoft SQL Server 2000 - 8.00.760
>(Intel X86)
>Dec 17 2002 14:22:05
>Copyright (c) 1988-2003 Microsoft Corporation
>Enterprise Edition on Windows NT 5.2 (Build 3790: )
>2006-04-06 22:30:02.83 spid55 Copyright (C) 1988-2002 Microsoft
>Corporation.
>2006-04-06 22:30:02.83 spid55 All rights reserved.
>2006-04-06 22:30:02.83 spid55 Server Process ID is 636.
>2006-04-06 22:30:02.83 spid55 Logging SQL Server messages in file
>'d:\mssql2000\MSSQL\log\ERRORLOG'.
>2006-04-06 22:30:02.83 spid55 Errorlog has been reinitialized. See
>previous log for older entries.
>2006-04-06 22:30:05.14 spid55 DBCC CHECKDB (master) executed by
>domain\user found 0 errors and repaired 0 errors.
>2006-04-06 22:30:06.81 backup Database backed up: Database: master,
>creation date(time): 2006/03/24(20:39:08), pages dumped: 1963, first LSN:
>312:455:1, last LSN: 312:457:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'master_full'}).
>2006-04-06 22:30:08.88 spid54 DBCC CHECKDB (msdb) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-06 22:30:12.94 backup Database backed up: Database: msdb,
>creation date(time): 2000/08/06(01:40:56), pages dumped: 4811, first LSN:
>18066:979:1, last LSN: 18066:982:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'msdb_full'}).
>2006-04-06 22:30:13.89 spid54 DBCC CHECKDB (sqladmin) executed by
>domain\user found 0 errors and repaired 0 errors.
>2006-04-06 22:30:14.99 backup Database backed up: Database: sqladmin,
>creation date(time): 2003/04/21(14:44:13), pages dumped: 258, first LSN:
>27404:239:1, last LSN: 27404:241:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'sqladmin_full'}).
>2006-04-06 22:30:17.50 spid55 DBCC CHECKDB (GSM) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-06 22:30:31.42 backup Database log truncated: Database: GSM.
>2006-04-06 22:30:33.74 backup Database backed up: Database: GSM,
creation
>date(time): 2004/06/05(00:34:40), pages dumped: 3750, first LSN:
46638:361:1,
>last LSN: 46638:363:1, number of dump devices: 1, device information:
>(FILE=1, TYPE=DISK: {'GSM_full'}).
>2006-04-06 22:44:07.73 spid56 DBCC CHECKDB (gbk) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-07 00:18:47.12 backup Database log truncated: Database: gbk.
>2006-04-07 07:14:53.14 server Error: 17883, Severity: 1, State: 0
>2006-04-07 07:14:53.14 server The Scheduler 2 appears to be hung. SPID
0,
>ECID 0, UMS Context 0x07A86300.
>2006-04-07 07:14:56.42 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:361:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:20:03.00 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:30:03.30 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:31:17.07 backup BACKUP failed to complete the command
PRINT
>'creating full backup GBK'
>backup database [gbk] to [gbk_full] with stats=100, init, skip
>2006-04-07 07:31:27.73 spid3 SQL Server is terminating due to 'stop'
>request from Service Control Manager.
>...
>Server restart
>
sql

error 17883

Hi, ALL
We are getting error 17883
Backup for DB "GBK" was not creating.
19:22 first error.
~ 07:00 users begin to work. Server does not response.
~ 07:13 administrator log in to console.
07:31 server restart. there are no error in error log.
Errorlog:
2006-04-06 19:20:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6750:1, last LSN:
1131478:6786:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:21:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:21:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:22:03.13 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6786:1, last LSN:
1131478:6814:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:22:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:22:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:24:03.21 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6814:1, last LSN:
1131478:6850:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:26:03.12 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6850:1, last LSN:
1131478:6867:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:28:03.20 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6867:1, last LSN:
1131478:6919:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:30:02.70 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:30:04.65 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6919:1, last LSN:
1131478:6962:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:31:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:31:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:32:03.18 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6962:1, last LSN:
1131478:7027:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:34:03.23 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7027:1, last LSN:
1131478:7070:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:36:03.31 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7070:1, last LSN:
1131478:7096:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:37:08.94 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:37:08.94 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:38:03.28 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7096:1, last LSN:
1131478:7127:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:40:02.13 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:40:03.22 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7127:1, last LSN:
1131478:7175:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:42:03.19 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7175:1, last LSN:
1131478:7220:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:44:03.22 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7220:1, last LSN:
1131478:7247:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:44:08.94 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:44:08.94 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:46:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7247:1, last LSN:
1131478:7264:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:48:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7264:1, last LSN:
1131478:7286:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:50:02.13 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:50:03.28 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7286:1, last LSN:
1131478:7293:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:52:03.21 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7293:1, last LSN:
1131478:7305:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:54:03.18 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7305:1, last LSN:
1131478:7307:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:56:03.11 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7307:1, last LSN:
1131478:7309:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:58:03.10 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7309:1, last LSN:
1131478:7319:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 22:30:02.74 spid55 Attempting to cycle errorlog.
2006-04-06 22:30:02.83 spid55 Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2006-04-06 22:30:02.83 spid55 Copyright (C) 1988-2002 Microsoft
Corporation.
2006-04-06 22:30:02.83 spid55 All rights reserved.
2006-04-06 22:30:02.83 spid55 Server Process ID is 636.
2006-04-06 22:30:02.83 spid55 Logging SQL Server messages in file
'd:\mssql2000\MSSQL\log\ERRORLOG'.
2006-04-06 22:30:02.83 spid55 Errorlog has been reinitialized. See
previous log for older entries.
2006-04-06 22:30:05.14 spid55 DBCC CHECKDB (master) executed by
domain\user found 0 errors and repaired 0 errors.
2006-04-06 22:30:06.81 backup Database backed up: Database: master,
creation date(time): 2006/03/24(20:39:08), pages dumped: 1963, first LSN:
312:455:1, last LSN: 312:457:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'master_full'}).
2006-04-06 22:30:08.88 spid54 DBCC CHECKDB (msdb) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-06 22:30:12.94 backup Database backed up: Database: msdb,
creation date(time): 2000/08/06(01:40:56), pages dumped: 4811, first LSN:
18066:979:1, last LSN: 18066:982:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'msdb_full'}).
2006-04-06 22:30:13.89 spid54 DBCC CHECKDB (sqladmin) executed by
domain\user found 0 errors and repaired 0 errors.
2006-04-06 22:30:14.99 backup Database backed up: Database: sqladmin,
creation date(time): 2003/04/21(14:44:13), pages dumped: 258, first LSN:
27404:239:1, last LSN: 27404:241:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'sqladmin_full'}).
2006-04-06 22:30:17.50 spid55 DBCC CHECKDB (GSM) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-06 22:30:31.42 backup Database log truncated: Database: GSM.
2006-04-06 22:30:33.74 backup Database backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), pages dumped: 3750, first LSN: 46638:361:1
,
last LSN: 46638:363:1, number of dump devices: 1, device information:
(FILE=1, TYPE=DISK: {'GSM_full'}).
2006-04-06 22:44:07.73 spid56 DBCC CHECKDB (gbk) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-07 00:18:47.12 backup Database log truncated: Database: gbk.
2006-04-07 07:14:53.14 server Error: 17883, Severity: 1, State: 0
2006-04-07 07:14:53.14 server The Scheduler 2 appears to be hung. SPID 0,
ECID 0, UMS Context 0x07A86300.
2006-04-07 07:14:56.42 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:361:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:20:03.00 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:30:03.30 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:31:17.07 backup BACKUP failed to complete the command PRINT
'creating full backup GBK'
backup database [gbk] to [gbk_full] with stats=100, init, skip
2006-04-07 07:31:27.73 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
...
Server restartHello
In essence all this 17883 message tells us is that no context switches were
made on the scheduler. The two things that I can think of are a) a hung
scheduler, or b) a thread that is not properly yielding to the scheduler.
I would suggest opening up a case with PSS since this need memory dump to
find clues to troubleshoot the issue.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, please make sure you have latest service pack installed on the
server.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: error 17883
>thread-index: AcZaGCgcfWSWeH5/QoCXiTp9pSJ7YQ==
>X-WBNR-Posting-Host: 212.12.3.11
>From: examnotes <white@.community.nospam>
>Subject: error 17883
>Date: Fri, 7 Apr 2006 00:52:02 -0700
>Lines: 186
>Message-ID: <1961654E-C620-4AFA-BD4A-A731BCA877CE@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427204
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi, ALL
>We are getting error 17883
>Backup for DB "GBK" was not creating.
> 19:22 first error.
>~ 07:00 users begin to work. Server does not response.
>~ 07:13 administrator log in to console.
> 07:31 server restart. there are no error in error log.
>Errorlog:
>2006-04-06 19:20:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6750:1, last LSN:
>1131478:6786:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:21:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:21:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:22:03.13 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6786:1, last LSN:
>1131478:6814:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:22:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:22:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:24:03.21 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6814:1, last LSN:
>1131478:6850:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:26:03.12 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6850:1, last LSN:
>1131478:6867:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:28:03.20 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6867:1, last LSN:
>1131478:6919:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:30:02.70 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:30:04.65 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6919:1, last LSN:
>1131478:6962:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:31:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:31:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:32:03.18 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6962:1, last LSN:
>1131478:7027:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:34:03.23 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7027:1, last LSN:
>1131478:7070:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:36:03.31 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7070:1, last LSN:
>1131478:7096:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:37:08.94 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:37:08.94 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:38:03.28 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7096:1, last LSN:
>1131478:7127:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:40:02.13 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:40:03.22 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7127:1, last LSN:
>1131478:7175:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:42:03.19 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7175:1, last LSN:
>1131478:7220:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:44:03.22 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7220:1, last LSN:
>1131478:7247:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:44:08.94 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:44:08.94 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:46:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7247:1, last LSN:
>1131478:7264:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:48:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7264:1, last LSN:
>1131478:7286:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:50:02.13 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:50:03.28 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7286:1, last LSN:
>1131478:7293:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:52:03.21 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7293:1, last LSN:
>1131478:7305:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:54:03.18 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7305:1, last LSN:
>1131478:7307:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:56:03.11 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7307:1, last LSN:
>1131478:7309:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:58:03.10 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7309:1, last LSN:
>1131478:7319:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 22:30:02.74 spid55 Attempting to cycle errorlog.
>2006-04-06 22:30:02.83 spid55 Microsoft SQL Server 2000 - 8.00.760
>(Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
>2006-04-06 22:30:02.83 spid55 Copyright (C) 1988-2002 Microsoft
>Corporation.
>2006-04-06 22:30:02.83 spid55 All rights reserved.
>2006-04-06 22:30:02.83 spid55 Server Process ID is 636.
>2006-04-06 22:30:02.83 spid55 Logging SQL Server messages in file
>'d:\mssql2000\MSSQL\log\ERRORLOG'.
>2006-04-06 22:30:02.83 spid55 Errorlog has been reinitialized. See
>previous log for older entries.
>2006-04-06 22:30:05.14 spid55 DBCC CHECKDB (master) executed by
>domain\user found 0 errors and repaired 0 errors.
>2006-04-06 22:30:06.81 backup Database backed up: Database: master,
>creation date(time): 2006/03/24(20:39:08), pages dumped: 1963, first LSN:
>312:455:1, last LSN: 312:457:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'master_full'}).
>2006-04-06 22:30:08.88 spid54 DBCC CHECKDB (msdb) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-06 22:30:12.94 backup Database backed up: Database: msdb,
>creation date(time): 2000/08/06(01:40:56), pages dumped: 4811, first LSN:
>18066:979:1, last LSN: 18066:982:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'msdb_full'}).
>2006-04-06 22:30:13.89 spid54 DBCC CHECKDB (sqladmin) executed by
>domain\user found 0 errors and repaired 0 errors.
>2006-04-06 22:30:14.99 backup Database backed up: Database: sqladmin,
>creation date(time): 2003/04/21(14:44:13), pages dumped: 258, first LSN:
>27404:239:1, last LSN: 27404:241:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'sqladmin_full'}).
>2006-04-06 22:30:17.50 spid55 DBCC CHECKDB (GSM) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-06 22:30:31.42 backup Database log truncated: Database: GSM.
>2006-04-06 22:30:33.74 backup Database backed up: Database: GSM,
creation
>date(time): 2004/06/05(00:34:40), pages dumped: 3750, first LSN:
46638:361:1,
>last LSN: 46638:363:1, number of dump devices: 1, device information:
>(FILE=1, TYPE=DISK: {'GSM_full'}).
>2006-04-06 22:44:07.73 spid56 DBCC CHECKDB (gbk) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-07 00:18:47.12 backup Database log truncated: Database: gbk.
>2006-04-07 07:14:53.14 server Error: 17883, Severity: 1, State: 0
>2006-04-07 07:14:53.14 server The Scheduler 2 appears to be hung. SPID
0,
>ECID 0, UMS Context 0x07A86300.
>2006-04-07 07:14:56.42 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:361:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:20:03.00 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:30:03.30 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:31:17.07 backup BACKUP failed to complete the command
PRINT
>'creating full backup GBK'
>backup database [gbk] to [gbk_full] with stats=100, init, skip
>2006-04-07 07:31:27.73 spid3 SQL Server is terminating due to 'stop'
>request from Service Control Manager.
>...
>Server restart
>

Monday, March 26, 2012

error 17883

Hi, ALL
We are getting error 17883
Backup for DB "GBK" was not creating.
19:22 first error.
~ 07:00 users begin to work. Server does not response.
~ 07:13 administrator log in to console.
07:31 server restart. there are no error in error log.
Errorlog:
2006-04-06 19:20:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6750:1, last LSN:
1131478:6786:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:21:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:21:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:22:03.13 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6786:1, last LSN:
1131478:6814:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:22:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:22:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:24:03.21 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6814:1, last LSN:
1131478:6850:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:26:03.12 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6850:1, last LSN:
1131478:6867:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:28:03.20 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6867:1, last LSN:
1131478:6919:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:30:02.70 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:30:04.65 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6919:1, last LSN:
1131478:6962:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:31:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:31:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:32:03.18 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6962:1, last LSN:
1131478:7027:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:34:03.23 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7027:1, last LSN:
1131478:7070:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:36:03.31 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7070:1, last LSN:
1131478:7096:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:37:08.94 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:37:08.94 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:38:03.28 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7096:1, last LSN:
1131478:7127:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:40:02.13 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:40:03.22 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7127:1, last LSN:
1131478:7175:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:42:03.19 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7175:1, last LSN:
1131478:7220:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:44:03.22 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7220:1, last LSN:
1131478:7247:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:44:08.94 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:44:08.94 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:46:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7247:1, last LSN:
1131478:7264:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:48:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7264:1, last LSN:
1131478:7286:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:50:02.13 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:50:03.28 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7286:1, last LSN:
1131478:7293:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:52:03.21 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7293:1, last LSN:
1131478:7305:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:54:03.18 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7305:1, last LSN:
1131478:7307:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:56:03.11 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7307:1, last LSN:
1131478:7309:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:58:03.10 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7309:1, last LSN:
1131478:7319:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 22:30:02.74 spid55 Attempting to cycle errorlog.
2006-04-06 22:30:02.83 spid55 Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2006-04-06 22:30:02.83 spid55 Copyright (C) 1988-2002 Microsoft
Corporation.
2006-04-06 22:30:02.83 spid55 All rights reserved.
2006-04-06 22:30:02.83 spid55 Server Process ID is 636.
2006-04-06 22:30:02.83 spid55 Logging SQL Server messages in file
'd:\mssql2000\MSSQL\log\ERRORLOG'.
2006-04-06 22:30:02.83 spid55 Errorlog has been reinitialized. See
previous log for older entries.
2006-04-06 22:30:05.14 spid55 DBCC CHECKDB (master) executed by
domain\user found 0 errors and repaired 0 errors.
2006-04-06 22:30:06.81 backup Database backed up: Database: master,
creation date(time): 2006/03/24(20:39:08), pages dumped: 1963, first LSN:
312:455:1, last LSN: 312:457:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'master_full'}).
2006-04-06 22:30:08.88 spid54 DBCC CHECKDB (msdb) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-06 22:30:12.94 backup Database backed up: Database: msdb,
creation date(time): 2000/08/06(01:40:56), pages dumped: 4811, first LSN:
18066:979:1, last LSN: 18066:982:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'msdb_full'}).
2006-04-06 22:30:13.89 spid54 DBCC CHECKDB (sqladmin) executed by
domain\user found 0 errors and repaired 0 errors.
2006-04-06 22:30:14.99 backup Database backed up: Database: sqladmin,
creation date(time): 2003/04/21(14:44:13), pages dumped: 258, first LSN:
27404:239:1, last LSN: 27404:241:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'sqladmin_full'}).
2006-04-06 22:30:17.50 spid55 DBCC CHECKDB (GSM) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-06 22:30:31.42 backup Database log truncated: Database: GSM.
2006-04-06 22:30:33.74 backup Database backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), pages dumped: 3750, first LSN: 46638:361:1,
last LSN: 46638:363:1, number of dump devices: 1, device information:
(FILE=1, TYPE=DISK: {'GSM_full'}).
2006-04-06 22:44:07.73 spid56 DBCC CHECKDB (gbk) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-07 00:18:47.12 backup Database log truncated: Database: gbk.
2006-04-07 07:14:53.14 server Error: 17883, Severity: 1, State: 0
2006-04-07 07:14:53.14 server The Scheduler 2 appears to be hung. SPID 0,
ECID 0, UMS Context 0x07A86300.
2006-04-07 07:14:56.42 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:361:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:20:03.00 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:30:03.30 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:31:17.07 backup BACKUP failed to complete the command PRINT
'creating full backup GBK'
backup database [gbk] to [gbk_full] with stats=100, init, skip
2006-04-07 07:31:27.73 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
...
Server restartHello
In essence all this 17883 message tells us is that no context switches were
made on the scheduler. The two things that I can think of are a) a hung
scheduler, or b) a thread that is not properly yielding to the scheduler.
I would suggest opening up a case with PSS since this need memory dump to
find clues to troubleshoot the issue.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, please make sure you have latest service pack installed on the
server.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: error 17883
>thread-index: AcZaGCgcfWSWeH5/QoCXiTp9pSJ7YQ==>X-WBNR-Posting-Host: 212.12.3.11
>From: =?Utf-8?B?dmFkaW1t?= <white@.community.nospam>
>Subject: error 17883
>Date: Fri, 7 Apr 2006 00:52:02 -0700
>Lines: 186
>Message-ID: <1961654E-C620-4AFA-BD4A-A731BCA877CE@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427204
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi, ALL
>We are getting error 17883
>Backup for DB "GBK" was not creating.
> 19:22 first error.
>~ 07:00 users begin to work. Server does not response.
>~ 07:13 administrator log in to console.
> 07:31 server restart. there are no error in error log.
>Errorlog:
>2006-04-06 19:20:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6750:1, last LSN:
>1131478:6786:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:21:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:21:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:22:03.13 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6786:1, last LSN:
>1131478:6814:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:22:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:22:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:24:03.21 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6814:1, last LSN:
>1131478:6850:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:26:03.12 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6850:1, last LSN:
>1131478:6867:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:28:03.20 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6867:1, last LSN:
>1131478:6919:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:30:02.70 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:30:04.65 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6919:1, last LSN:
>1131478:6962:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:31:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:31:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:32:03.18 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6962:1, last LSN:
>1131478:7027:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:34:03.23 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7027:1, last LSN:
>1131478:7070:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:36:03.31 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7070:1, last LSN:
>1131478:7096:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:37:08.94 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:37:08.94 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:38:03.28 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7096:1, last LSN:
>1131478:7127:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:40:02.13 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:40:03.22 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7127:1, last LSN:
>1131478:7175:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:42:03.19 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7175:1, last LSN:
>1131478:7220:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:44:03.22 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7220:1, last LSN:
>1131478:7247:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:44:08.94 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:44:08.94 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:46:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7247:1, last LSN:
>1131478:7264:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:48:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7264:1, last LSN:
>1131478:7286:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:50:02.13 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:50:03.28 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7286:1, last LSN:
>1131478:7293:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:52:03.21 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7293:1, last LSN:
>1131478:7305:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:54:03.18 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7305:1, last LSN:
>1131478:7307:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:56:03.11 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7307:1, last LSN:
>1131478:7309:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:58:03.10 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7309:1, last LSN:
>1131478:7319:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 22:30:02.74 spid55 Attempting to cycle errorlog.
>2006-04-06 22:30:02.83 spid55 Microsoft SQL Server 2000 - 8.00.760
>(Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
>2006-04-06 22:30:02.83 spid55 Copyright (C) 1988-2002 Microsoft
>Corporation.
>2006-04-06 22:30:02.83 spid55 All rights reserved.
>2006-04-06 22:30:02.83 spid55 Server Process ID is 636.
>2006-04-06 22:30:02.83 spid55 Logging SQL Server messages in file
>'d:\mssql2000\MSSQL\log\ERRORLOG'.
>2006-04-06 22:30:02.83 spid55 Errorlog has been reinitialized. See
>previous log for older entries.
>2006-04-06 22:30:05.14 spid55 DBCC CHECKDB (master) executed by
>domain\user found 0 errors and repaired 0 errors.
>2006-04-06 22:30:06.81 backup Database backed up: Database: master,
>creation date(time): 2006/03/24(20:39:08), pages dumped: 1963, first LSN:
>312:455:1, last LSN: 312:457:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'master_full'}).
>2006-04-06 22:30:08.88 spid54 DBCC CHECKDB (msdb) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-06 22:30:12.94 backup Database backed up: Database: msdb,
>creation date(time): 2000/08/06(01:40:56), pages dumped: 4811, first LSN:
>18066:979:1, last LSN: 18066:982:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'msdb_full'}).
>2006-04-06 22:30:13.89 spid54 DBCC CHECKDB (sqladmin) executed by
>domain\user found 0 errors and repaired 0 errors.
>2006-04-06 22:30:14.99 backup Database backed up: Database: sqladmin,
>creation date(time): 2003/04/21(14:44:13), pages dumped: 258, first LSN:
>27404:239:1, last LSN: 27404:241:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'sqladmin_full'}).
>2006-04-06 22:30:17.50 spid55 DBCC CHECKDB (GSM) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-06 22:30:31.42 backup Database log truncated: Database: GSM.
>2006-04-06 22:30:33.74 backup Database backed up: Database: GSM,
creation
>date(time): 2004/06/05(00:34:40), pages dumped: 3750, first LSN:
46638:361:1,
>last LSN: 46638:363:1, number of dump devices: 1, device information:
>(FILE=1, TYPE=DISK: {'GSM_full'}).
>2006-04-06 22:44:07.73 spid56 DBCC CHECKDB (gbk) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-07 00:18:47.12 backup Database log truncated: Database: gbk.
>2006-04-07 07:14:53.14 server Error: 17883, Severity: 1, State: 0
>2006-04-07 07:14:53.14 server The Scheduler 2 appears to be hung. SPID
0,
>ECID 0, UMS Context 0x07A86300.
>2006-04-07 07:14:56.42 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:361:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:20:03.00 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:30:03.30 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:31:17.07 backup BACKUP failed to complete the command
PRINT
>'creating full backup GBK'
>backup database [gbk] to [gbk_full] with stats=100, init, skip
>2006-04-07 07:31:27.73 spid3 SQL Server is terminating due to 'stop'
>request from Service Control Manager.
>...
>Server restart
>

Friday, February 24, 2012

Error "Incorrect syntax near (." when doing Update() from code, VB

Hi all

My error is as follows:

Incorrect syntax near '('.
Line 27: acceptOrDeclineFriendship.UpdateParameters.Add("Response", answer)
Line 28: acceptOrDeclineFriendship.UpdateParameters.Add("FriendID", friend_id)
Line 29: acceptOrDeclineFriendship.Update()
Line 30:
Line 31: End Sub

Bear with me... I have a page where i use a repeater control to list users who have requested to be friends with the currently online user. The 'getFriendRequests' query looks like this:

SelectCommand="SELECT * FROM Friends, UserDetails WHERE (Friends.UserID = UserDetails.UserID) AND (FriendID = @.UserID) AND (ApprovedByFriend = 'False') ORDER BY Friends.Requested DESC"
This works.

Within each repeater template, there are 2 buttons, 'Accept' or 'Decline', like this:

 <asp:Repeater ID="Repeater1" runat="server" DataSourceID="getFriendRequests"> <ItemTemplate> (other stuff like avatar and username etc) <asp:Button ID="accept" runat="server" Text="Accept" commandName="Accept" commandArgument='<%#Eval("UserID")%>' onCommand="Accept_Decline_Friends"/> <asp:Button ID="decline" runat="server" Text="Decline" commandName="Decline" commandArgument='<%#Eval("UserID")%>' onCommand="Accept_Decline_Friends"/> </ItemTemplate> </asp:Repeater>

The code-behind (VB) which deals with this is as follows:

Protected Sub Accept_Decline_Friends(ByVal senderAs Object,ByVal eAs CommandEventArgs)'retrieve id of requestee and the answer accept/declineDim friend_idAs String = e.CommandArgument.ToStringDim answerAs String = e.CommandName.ToString'add the parameters acceptOrDeclineFriendship.UpdateParameters.Add("Response", answer) acceptOrDeclineFriendship.UpdateParameters.Add("FriendID", friend_id) acceptOrDeclineFriendship.Update()End Sub

Since the buttons are being created dynamically, this is how i track 1. the response from the currently logged in user 'Accept/Decline' and 2. who they are responding to (by their uniqueid)

This relates to a sqlDataSource on my .aspx page like this:

<!-- update query when user has accepted the friendship --> <asp:SqlDataSource ID="acceptOrDeclineFriendship" runat="server" ConnectionString="<%$ xxx%>" UpdateCommand="UPDATE Friends SET (ApprovedByFriend = @.Response) WHERE (FriendID = @.UserID) AND (UserID = @.FriendID)"> <UpdateParameters> <asp:ControlParameter Name="UserID" ControlID="userIdValue" /> </UpdateParameters> </asp:SqlDataSource>

Which is meant to update my 'Friends' table to show that 'ApprovedByFriend' (the logged in user) is either 'Accept' or 'Decline', and record who's request was responded to.

I hope this is clear, just trying to suppy all of the information! The error appears to be saying that I have an issue with my code-behind, where i am telling the sqlDataSource above to UPDATE. What I can say is that for each button in the repeater, the 2 variables 'friend_id' and 'answer' are picking up the correct values.

Can anyone see any obvious problems here? Any help is very much appreciated as i am well and truley stuck!

Hi all

after all that I figured out it was a simple syntax issue.

UpdateCommand="UPDATE Friends SET ApprovedByFriend = @.Response WHERE (FriendID = @.UserID) AND (UserID = @.FriendID)">

I had some brackets around the SET condition Embarrassed

Friday, February 17, 2012

Error

I am getting the following error:
Client found response content type of 'text/html; charset=Windows-1252',
but expected 'text/xml'. The request failed with the error message: --
<html> <head> <title>Server cannot access application directory
'D:\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\'. The
directory does not exist or is not accessible because of security
settings.</title> <style> body {font-family:"Verdana";font-
weight:normal;font-size: .7em;color:black;} p {font-
family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b
{font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em} .marker {font-
weight: bold; color: black;text-decoration: none;} .version {color:
gray;} .error {margin-bottom: 10px;} .expandable { text-
decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style> </head> <body bgcolor="white"> <span><H1>Server
Error in '/ReportServer' Application.<hr width=100% size=1
color=silver></H1> <h2> <i>Server cannot access application
directory 'D:\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\'.
The directory does not exist or is not accessible because of security
settings.</i> </h2></span> <font face="Arial, Helvetica, Geneva,
SunSans-Regular, sans-serif "> <b> Description: </b>An unhandled
exception occurred during the execution of the current web request. Please
review the stack trace for more information about the error and where it
originated in the code. <br><br> <b> Exception
Details: </b>System.Web.HttpException: Server cannot access application
directory 'D:\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\'.
The directory does not exist or is not accessible because of security
settings.<br><br> <b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc"> <tr>
<td> <code> An unhandled exception was generated
during the execution of the current web request. Information regarding the
origin and location of the exception can be identified using the exception
stack trace below.</code> </td> </tr>
</table> <br> <b>Stack Trace:</b> <br><br>
<table width=100% bgcolor="#ffffcc"> <tr>
<td> <code><pre> [HttpException (0x80004005): Server
cannot access application directory 'D:\Microsoft SQL Server\MSSQL\
Reporting Services\ReportServer\'. The directory does not exist or is not
accessible because of security settings.]
System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263
[HttpException (0x80004005): ASP.NET Initialization Error]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +983
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +128
</pre></code> </td> </tr>
</table> <br> <hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework
Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 </font>
</body> </html>  --.
Any ideas'
--
Message posted via http://www.sqlmonster.comHi,
The answer is shown by the error it self:
'Server cannot access application directory
'D:\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\'. The
directory does not exist or is not accessible because of security
settings.'
Just check your IIS settings for the Virtual Directory 'ReportServer'
Jan Pieter Posthuma
"Pamela Mitter via SQLMonster.com" wrote:
> I am getting the following error:
> Client found response content type of 'text/html; charset=Windows-1252',
> but expected 'text/xml'. The request failed with the error message: --
> <html> <head> <title>Server cannot access application directory
> 'D:\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\'. The
> directory does not exist or is not accessible because of security
> settings.</title> <style> body {font-family:"Verdana";font-
> weight:normal;font-size: .7em;color:black;} p {font-
> family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b
> {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
> H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
> H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
> pre {font-family:"Lucida Console";font-size: .9em} .marker {font-
> weight: bold; color: black;text-decoration: none;} .version {color:
> gray;} .error {margin-bottom: 10px;} .expandable { text-
> decoration:underline; font-weight:bold; color:navy; cursor:hand; }
> </style> </head> <body bgcolor="white"> <span><H1>Server
> Error in '/ReportServer' Application.<hr width=100% size=1
> color=silver></H1> <h2> <i>Server cannot access application
> directory 'D:\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\'.
> The directory does not exist or is not accessible because of security
> settings.</i> </h2></span> <font face="Arial, Helvetica, Geneva,
> SunSans-Regular, sans-serif "> <b> Description: </b>An unhandled
> exception occurred during the execution of the current web request. Please
> review the stack trace for more information about the error and where it
> originated in the code. <br><br> <b> Exception
> Details: </b>System.Web.HttpException: Server cannot access application
> directory 'D:\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\'.
> The directory does not exist or is not accessible because of security
> settings.<br><br> <b>Source Error:</b> <br><br>
> <table width=100% bgcolor="#ffffcc"> <tr>
> <td> <code> An unhandled exception was generated
> during the execution of the current web request. Information regarding the
> origin and location of the exception can be identified using the exception
> stack trace below.</code> </td> </tr>
> </table> <br> <b>Stack Trace:</b> <br><br>
> <table width=100% bgcolor="#ffffcc"> <tr>
> <td> <code><pre> [HttpException (0x80004005): Server
> cannot access application directory 'D:\Microsoft SQL Server\MSSQL\
> Reporting Services\ReportServer\'. The directory does not exist or is not
> accessible because of security settings.]
> System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263
> [HttpException (0x80004005): ASP.NET Initialization Error]
> System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +983
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +128
> </pre></code> </td> </tr>
> </table> <br> <hr width=100% size=1 color=silver>
> <b>Version Information:</b> Microsoft .NET Framework
> Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 </font>
> </body> </html>  --.
> Any ideas'
> --
> Message posted via http://www.sqlmonster.com
>

Tuesday, March 27, 2012

error 17883

error 17883

Monday, March 26, 2012

error 17883

Friday, February 24, 2012

Error "Incorrect syntax near (." when doing Update() from code, VB

Friday, February 17, 2012

Error

sql error 15138

Blog Archive

About Me