APAR status
Closed as program error.
Error description
When the problem happens you typically see an assert warning followed by an assert failed: 04/21/2022 12:19:12 Assert Warning: I/O write chunk 1, pagenum 43300, pagecnt 64 04/21/2022 12:19:12 IBM Informix Dynamic Server Version 14.10.FC8 04/21/2022 12:19:12 Who: Session(321, informix@hostname, 9525, 0x45fceda8) Thread(339, sqlexec, 59ac8c28, 1) File: rsbuff.c Line: 6001 04/21/2022 12:19:12 Action: Please notify IBM Informix Technical Support. 04/21/2022 12:19:12 stack trace for pid 17563 written to INFORMIXDIR/tmp/af.53b920f 04/21/2022 12:19:12 See Also: INFORMIXDIR/tmp/af.53b920f 04/21/2022 12:19:12 I/O write chunk 1, pagenum 43300, pagecnt 64 04/21/2022 12:19:13 Assert Failed: Dynamic Server must abort 04/21/2022 12:19:13 IBM Informix Dynamic Server Version 14.10.FC8 04/21/2022 12:19:13 Who: Session(321, informix@hostname, 9525, 0x45fceda8) Thread(339, sqlexec, 59ac8c28, 1) File: rslog.c Line: 3552 04/21/2022 12:19:13 Results: Dynamic Server must abort An example of a stack at the assert warn. This shows a create database was being execute, however, the stack can be produced from anything that is logged. 12:19:12 Stack for thread: 339 sqlexec 0x00000000014cfead (oninit) afstack 0x00000000014cd869 (oninit) afhandler 0x00000000014ca642 (oninit) afwarn_interface 0x0000000000e7aa21 (oninit) physio 0x0000000000ead560 (oninit) logwrite 0x0000000000ffd88a (oninit) log_put 0x0000000000ff6b7c (oninit) logm_write 0x0000000000eb102f (oninit) logvimage_new 0x00000000010494d1 (oninit) wrt_home 0x0000000001048a4c (oninit) wrtrecord 0x0000000001048593 (oninit) rswrite 0x00000000015a79b1 (oninit) fmwrite 0x0000000000a7eaf6 (oninit) adddata 0x0000000000a7e3b7 (oninit) creatproc 0x000000000071ee75 (oninit) aud_creatproc 0x00000000006069d2 (oninit) excommand 0x0000000000a5f99a (oninit) exstmt_int 0x0000000000a602e8 (oninit) scread 0x0000000000a561ab (oninit) dbcreate 0x000000000071a9de (oninit) aud_dbcreate 0x00000000007c196e (oninit) sqcreatedb 0x0000000000606542 (oninit) excommand 0x0000000000aaf15c (oninit) sq_execute_workhorse 0x0000000000aaf995 (oninit) sq_execute 0x0000000000b93e2e (oninit) sqmain 0x0000000001603a79 (oninit) spawn_thread 0x00000000014bcfb3 (oninit) th_init_initgls 0x00000000015054cf (oninit) startup Then the stack at the assert fail 12:19:13 Stack for thread: 339 sqlexec 0x00000000014cfead (oninit) afstack 0x00000000014cd869 (oninit) afhandler 0x00000000014ca6e2 (oninit) afcrash_interface 0x0000000000eb2c64 (oninit) logerr 0x0000000000ffc8a6 (oninit) log_put 0x0000000000ff6b7c (oninit) logm_write 0x0000000000eb102f (oninit) logvimage_new 0x00000000010494d1 (oninit) wrt_home 0x0000000001048a4c (oninit) wrtrecord 0x0000000001048593 (oninit) rswrite 0x00000000015a79b1 (oninit) fmwrite 0x0000000000a7eaf6 (oninit) adddata 0x0000000000a7e3b7 (oninit) creatproc 0x000000000071ee75 (oninit) aud_creatproc 0x00000000006069d2 (oninit) excommand 0x0000000000a5f99a (oninit) exstmt_int 0x0000000000a602e8 (oninit) scread 0x0000000000a561ab (oninit) dbcreate 0x000000000071a9de (oninit) aud_dbcreate 0x00000000007c196e (oninit) sqcreatedb 0x0000000000606542 (oninit) excommand 0x0000000000aaf15c (oninit) sq_execute_workhorse 0x0000000000aaf995 (oninit) sq_execute 0x0000000000b93e2e (oninit) sqmain 0x0000000001603a79 (oninit) spawn_thread 0x00000000014bcfb3 (oninit) th_init_initgls 0x00000000015054cf (oninit) startup Below is an example of the customer failure which occurred during physical logging as is believed to be a result of the same underlying issue 22:15:00 Assert Warning: I/O write chunk 350, pagenum 13788650, pagecnt 65 --> errno = 22 22:15:00 Who: Session(18341513, username, -1, 1c47f3018) Thread(1419340837, sqlexec, 22e8b0848, 28) File: rsbuff.c Line: 6004 22:15:00 Action: Please notify IBM Informix Technical Support. 22:15:01 IBM Informix Dynamic Server Version 14.10.FC4W1 22:15:01 Assert Failed: Dynamic Server must abort 22:15:01 Who: Session(18341513, username, -1, 1c47f3018) Thread(1419340837, sqlexec, 22e8b0848, 40) File: rsbuff.c Line: 4814 22:15:01 Action: Reinitialize shared memory 22:15:01 SHM Globals and Master Pool/Master Block Adresses: 0x101409964 oninit :: mt_system + 0x114 0x101431328 oninit :: afhandler + 0x1128 0x1014301d0 oninit :: afcrash_interface + 0xa0 0x100c6ac30 oninit :: bfphysflush + 0x620 0x100c6a03c oninit :: bfphyslogx + 0xc4c 0x100bf227c oninit :: dodrecord + 0x61c 0x100bea350 oninit :: logundo + 0x1b20 0x100e285e4 oninit :: rlogm_undo + 0x1d4 0x100be7b6c oninit :: rollback + 0x114c 0x100be5efc oninit :: rsrollback + 0x33c s 0x10066304c oninit :: sqisrollback + 0x7c 0x1006197cc oninit :: sqrollback + 0xa7c 0x100572dec oninit :: aud_sqrollback + 0xc 0x10092fd10 oninit :: sql_rollback + 0x2a0 0x10092fa44 oninit :: sq_rollback + 0x84 0x1009fbe68 oninit :: sqmain + 0xa48 0x101532220 oninit :: listen_verify + 0x650 0x101531860 oninit :: spawn_thread + 0x18a0 0x1013f0fe8 oninit :: th_init_initgls + 0x168 0x10141e4e4 oninit :: startup + 0x1c4
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC9. * ****************************************************************
Problem conclusion
Fixed in Informix Server 14.10.xC9.
Temporary fix
Comments
APAR Information
APAR number
IT40736
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-04-25
Closed date
2022-09-29
Last modified date
2024-09-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 September 2024