Kbase P159469: SQL-92 servers crash periodically with error 48 while running a specific query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/1/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 servers crash periodically with error 48 while running a specific query.
SQLSRV2 6: SYSTEM ERROR: Bus error. (48)
Disconnecting client 288 of dead server 6. (2526)
Disconnecting dead server 6. (2525)
In some instances the database will crash.
SYSTEM ERROR: Releasing multiplexed latch. latchId: 26880 (5029)
User 289 died holding 1 shared memory locks. (2522)
Begin ABNORMAL shutdown code 2 (2249)
FACT(s) (Environment):
HP-UX 11.x
Progress 9.1D
9.1D09
OpenEdge Category: SQL
CAUSE:
The data requested in the specific query is larger than the set SQL-WIDTH.
FIX:
Run dbtool dbname and select option #2: SQL Width Scan w/Fix Option