Return
-
Title
Error: "Msg 49999, Level 16, State 1, Line 0: ConfigureThreads returned non zero" -
Description
Litespeed backup (Full or T-Log) hangs when CPU throttle parameter is used with the following error logs
Msg 49999, Level 16, State 1, Line 0: ConfigureThreads returned non zero
dbo.sysdbmaintenanceplan_historysequence_id plan_id plan_name database_name server_name activity succeeded end_time duration start_time error_number message
1535834 4C2E5515-FCE0-4856-97FB-AE13E84320E7 Processed 1 pages for database 'Database_DB', file 'Database_DB_log' on file 1. BACKUP LOG successfully processed 1 pages in 0.024 seconds (0.021 MB/sec). Backup added as file number: 1 Native Size: 0.00 MB Backup Size: 0.10 MB CPU Seconds: 0.13 Msg 49999, Level 16, State 1, Line 0: ConfigureThreads returned non zero. -
Cause
The problem is that the throttling code was relying on throttled threads to terminate before throttling thread was shut down.
When the throttling terminates (or is forcibly terminated) it never iterates through its array of handled "worker" threads and resumes any threads that may be currently suspended. Thus, any threads suspended will hang indefinitely until forcibly killed.
 -
Resolution
Log a case and request for a patch or upgrade to Litespeed for SQL Server 6.0.
-
Defect ID
CR74331