Kbase P102486: SQL-92 server hangs when 2 stored procedures are run concurrently.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/24/2005 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0B
RedHat Linux Advanced Server 2.1
SYMPTOM(s):
SQL-92 server hangs when 2 stored procedures are run concurrently.
The Stored Procedure is executed concurrently on the same SQL-92 server (_sqlsrv2 process) from different SQL-92 clients.
CAUSE:
This hang is caused by a race in the Linux SMP kernel in that duplicate PIDs are assigned to different threads.
FIX:
Upgrade to Red Hat Enterprise Linux AS release 3.
- OR -
Run single-threaded SQL-92 servers (-Mi 1).