Kbase 21056: Missing SQL Schema Information Can Cause SQL Server To Die
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Disconnecting client <number> of dead server <number>. (2526)
Error "-20217 possible RPC error"
Error "-20211 possible RPC error"
Errors are present on client session or within SQL trace log.
Files named sqlnnnnnn.trc appear contain the same text:
PANIC - PSR psr_env_create Exceeds max recursion PID 20920
CAUSE:
Incomplete SQL system tables, caused by a faulty run of mkschema, can cause this problem. Run the following 4GL code against the problem database to verify all forty two (42) SQL system tables exist within the metadata:
for each _file where _file-num > 2000.
display _file-name.
If fewer than forty two (42) tables (beginning with the prefix SYS) are returned, this proves there are an inadequate number of SQL system tables. Connections cannot be made until they all SYS tables are present.
FIX:
Run the mkschema utility against the database to create the complete SQL metaschema. The database must be down to complete this operation.
Example: mkschema DBname