View Revisions: Issue #6716
| Summary | 0006716: Deadlocks on Sybase due to default table locking scheme being overly restrictive | ||
|---|---|---|---|
| Revision | 2025-02-05 14:24 by pbelov | ||
| Additional Information | Originally reported by Benjamin S. (and independently by Phillip M.) https://sourceforge.net/p/symmetricds/discussion/739236/thread/c6964e72ea/?limit=25 https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20021_1251/html/locking/X12029.htm -- Identify table locking scheme: SELECT TableName = CONVERT(VARCHAR(30), so.name), LockingScheme = CONVERT(VARCHAR(30), lockscheme(so.id)) ,case (sysstat2 & 57344) when 32768 then 1 else 0 end as bit_evaluation , crdate FROM symmetricroot.dbo.sysobjects so WHERE so.type IN ('S', 'U') and so.name like 'sym_%' order by so.name; |
||
| Revision | 2025-02-05 02:24 by pbelov | ||
| Additional Information | Originally reported by Benjamin S. (and independently by Phillip M.) https://sourceforge.net/p/symmetricds/discussion/739236/thread/c6964e72ea/?limit=25 https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20021_1251/html/locking/X12029.htm |
||