|
Problem IT09446
|
Status: Closed |
A PREPARED STATEMENT EXECUTED MANY TIMES IN THE SAME SESSION ON UPDATABLE SECONDARY MAY CAUSE SQSCB->NEXTID OVERFLOW ON PRIMARY. |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
You are running a client application via Updatable secondary
server. The application is heavily using prepared statements.
Eventually the application hangs and the following messages
reported in the message log file of the Primary server:
Encountered problem processing update on secondary : Cannot
call mksdb
Encountered problem processing update on secondary : Cannot
call proxyWriteMksdb
sprollback sqerrno -208 sqiserrno 0
The application works fine if connected directly to the Primary
instance. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of updatable secondary servers using prepared *
* statements. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 when available. *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10.xC7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.06.2015
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC7
|
| Problem solved according to the fixlist(s) of the following version(s) |
