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 |
