|
Problem IT19870
|
Status: Closed |
JDBC CLIENT THAT RETRIEVES AUTO GENERATED KEYS FOR INSERT INTO ... SELECT FROM ... STATEMENT LEAKS OPENTABLE MEMORY AND OPEN TAB
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
If a JDBC client executes an INSERT INTO ... SELECT FROM ...
statement that inserts more than 32K records and it utilizes a
Statement.RETURN_GENERATED_KEY n an executeUpdate method and it
also utilizes the stmt.getGeneratedKeys() method,
it an exceed a sessions's open table limite of 32K and the
insert will fail with a -242/-104 error:
-242 Could not open database table table-name.
-104 ISAM error: too many files open.
If you trap for the -242 on the server (onmode -I -242) you will
see close approximately 32K open table entries
in "onstat -g opn" output for the asserting thread and a large
opentable mem usage in "onstat -g ses " output for
the asserting session# and a stack from the trap like:
(oninit) afstack
(oninit) afhandler
(oninit) affail_interface
(oninit) check_traperror
(oninit) sqerr
(oninit) sqerr1
(oninit) sqnameerr
(oninit) process_autokey
(oninit) addone
(oninit) insert_next
(oninit) doinsert
(oninit) excommand
(oninit) sq_execute
(oninit) sqmain
(oninit) spawn_thread
(oninit) th_init_initgls
(oninit) startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Informix users with JDBC auto generated key *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC9 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.03.2017
10.07.2017
10.07.2017 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
