Errors occurred while cleaning dbspace
Dennis Melnikov saw an assert warning on 11.70.FC5XE startup, errors cleaning dbspace dbs01 (cannot drop temp partnum 0x901833, iserrno 113) and asked whether it matters. Andreas Legner said cleanup is retried at the next initialization. Dennis had not restarted. Andreas concluded an internal activity probably allocated the temp partition during cleaning and it was cleaned up afterwards.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,
IDS put a warning in message log when starting:
18:13:19 Assert Warning: Errors occurred while cleaning dbspace 'dbs01informix '
18:13:19 IBM Informix Dynamic Server Version 11.70.FC5XE
18:13:19 Who: Session(1, informix@elids5, 0, 700001f18a7c028)
Thread(10, main_loop(), 700001f18a3a028, 1)
File: rspartn.c Line: 12320
18:13:19 Results: Unused temp tables and/or deferred indexes may remain
18:13:19 Action: Cleanup will be reattempted during next initialization
18:13:19 stack trace for pid 6947492 written to /tmp/af.3f23e0f
18:13:19 See Also: /tmp/af.3f23e0f
18:13:19 Errors occurred while cleaning dbspace 'dbs01informix '
/tmp/af.3f23e0f:
18:13:19 Cannot drop temp partnum 0x901833, iserrno 113
18:13:19
18:13:19 IBM Informix Dynamic Server Version 11.70.FC5XE Software Serial Number AAA#B000000
18:13:19 Assert Warning: Errors occurred while cleaning dbspace 'dbs01 informix '
18:13:19 Who: Session(1, informix@elids5, 0, 700001f18a7c028)
Thread(10, main_loop(), 700001f18a3a028, 1)
File: rspartn.c Line: 12320
18:13:19 Results: Unused temp tables and/or deferred indexes may remain
18:13:19 Action: Cleanup will be reattempted during next initialization
18:13:19 Raw hex dump of stack located in /tmp/af.3f23e0f.rawstk
18:13:19 Stack for thread: 10 main_loop()base: 0x0700001f1c2a8000
len: 69632
pc: 0x0000000100096cec
tos: 0x0700001f1c2b71d0
state: running
vp: 1
0x0000000100096a98 (oninit)afstack
0x000000010009603c (oninit)afhandler
0x00000001000963ec (oninit)afwarn_interface
0x000000010038dbcc (oninit)clean_pp
0x000000010038ee00 (oninit)clean_dbspaces
0x0000000100008f8c (oninit)main_loop
0x0000000101489440 (oninit)startup
18:13:19 See Also: /tmp/af.3f23e0f
---------------------------------Begin System Alarm Program Output
---------------------------------
Assertion Failure Type: Warning
Host Name: elids5
Database Server Name: elids5
Time of failure: Tue Dec 5 18:13:19 2023
AF file: /tmp/af.3f23e0f
Shared memory file: None
System Blocking: OFF
-------------------------------
End System Alarm Program Output
-------------------------------
18:13:19 sh /opt/informix/11.70fc5xe/etc/evidence.sh 1 0 /tmp/af.3f23e0f 1 0x700001f18a3a028 10 0x700001f1c29d560 1025 0 0 0 0
18:13:19
------------------ End of assertion failure 0 -----------------Can it result in something bad?
------------------------------
Sincerely,
Dennis
------------------------------
If
SELECT * FROM sysmaster:sysptnhdr WHERE partnum = '0x901833'::INTreturns 0 rows, can I be sure that the possible problem has gone?
------------------------------
Sincerely,
Dennis
------------------------------
So this has occurred, as promised - did you restart once again? Cleanup will be reattempted during next initialization ------------------------------ Andreas Legner ------------------------------
No. ------------------------------ Sincerely, Dennis ------------------------------
Then it seems to have been a case of some internal activity having allocated a temp partition early on, before/during temp partition cleaning (hence iserrno 113 ), and the partition got cleaned up automatically once that activity completed. ------------------------------ Andreas Legner ------------------------------