Re: Sql process and hanging ARServer

2006-09-17 Thread Piotr Polewczak 
the blocking process is :
sp_cursorclose;1


the directly blocked querys :
SELECT COUNT(*) FROM (SELECT distinct userName, password, authString FROM
servgrp_userlic WHERE groupId = -1) as d1

SELECT MAX(timestamp) FROM user_cache

SELECT
userName,password,authString,fixedLicChange,shortGroup,longGroup,shortCompGroup,longCompGroup
FROM user_cache WHERE entryId = '1000'

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Sql process and hanging ARServer

2006-09-15 Thread Piotr Polewczak 
Hi,

i've got problem with hanging arserver, problem appears when one sql process
(connection from arserver) starts to lock other processes.

Command in blocking process is : sp_cursorclose;1 
Resources locked by process are : ARSystem.dbo.servgrp_userlic,
ARSystem.dbo.user_cache, ARSystem.dbo.T10 (User)

after several minutes almost all arserver processes are locked by first
process and arserver hangs, in logs there is info :
Dispatch : Timeout during data retrieval due to busy server -- retry the
operation (server)  ARERR #8211; 93

Problem appears in the high load of the system and when all licences are taken.

Enviroment :
2 x ARS 6.3 patch 18 (server group)
MSSQL2000
Windows 2003

Thanks for any help,
Peter

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Sql process and hanging ARServer

2006-09-15 Thread Axton 

Post the sql statemenst for the first two threads that enter the deadlock.

Read up:
http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm
http://support.microsoft.com/?kbid=832524

Axton Grams

On 9/15/06, Piotr Polewczak [EMAIL PROTECTED] wrote:

Hi,

i've got problem with hanging arserver, problem appears when one sql process
(connection from arserver) starts to lock other processes.

Command in blocking process is : sp_cursorclose;1
Resources locked by process are : ARSystem.dbo.servgrp_userlic,
ARSystem.dbo.user_cache, ARSystem.dbo.T10 (User)

after several minutes almost all arserver processes are locked by first
process and arserver hangs, in logs there is info :
Dispatch : Timeout during data retrieval due to busy server -- retry the
operation (server)  ARERR #8211; 93

Problem appears in the high load of the system and when all licences are taken.

Enviroment :
2 x ARS 6.3 patch 18 (server group)
MSSQL2000
Windows 2003

Thanks for any help,
Peter

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org