Running clients 11.04 against a 10.2b08 DB.
We have been seeing this error in the database log:
SRV 56: (15093) SYSTEM ERROR: This server has too many open cursors so the cursor creation attempt by user 11920 at line 798 in /vobs_rkt/src/glue/nsadb.c, msgcode 50, ROWID 0, table 18, index 48.
With the clients crashing, and receiving this error:
[15/12/09@15:41:56.552-0500] P-040195 T-4069881632 1 4GL -- ** Disconnected by the server, code 48. (706)
We use very few dynamic queries, so am unsure on best how to debug this?
Thanks.
You might try lowering the number of clients per server (-Ma). No idea what value you are using so this is a complete a shot in the dark.
Also, doesn't have to be dynamic queries. Static queries also need to use index cursors.
Thank you Gus. Any ideas on why we only started seeing this error after a V11.04 upgrade, where we'd never seen it before once in years of running the application under V10?