Informix - Problem description
Problem IT32162 | Status: Closed |
AN ONSTAT -G SES OR ONSTAT -G SQL CAN LOOP PRINTING MANY "(" CHARACTERS RESULTING IN A LARGE ASSERTION FILE BEING CREATED | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The instance that was running at the time was reporting some memory corruption problems which resulted in an AF to be generated. While producing the "onstat -g ses 0" section of the AF, the report ended up in a loop and printed many indented "(" characters resulting a very large file to be created which might fill the file system. You will see something like the following towards the end of the session report ... sqscb info scb sqscb optofc pdqpriority optcompind directives 70000006864a098 70000004d16d028 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 8546 DBNAME DR Wait 0 0 4.10 Off Stored procedure stack : context proc-counter opcode name ---------------------------------------------------------------- -- 0x070000003f290058 0x7000000924cac38+0x0050 CURSOR DBNAME:sp_name Current SQL statement (134) in procedure DBNAME:sp_name proc-counter 0x7000000924cac38 opcode CURSOR ( ( ( ( And now all you see are many indented ( characters being printed and this also means that the other parts of the assert file are not reported. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.03.2020 14.12.2020 14.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |