Informix - Problem description
Problem IT27617 | Status: Closed |
DEFRAGMENT TASK FAILS WITH ISAM ERROR 21538 WHEN DEFRAGMENTER CLEANER THREAD DOES NOT RUN AT STARTUP | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The sysadmin task to defragment a table or partition will wait for a period of time before failing with ISAM error 21538 if the defragmenter cleaner thread is not run when IDS is started. One way for this to occur is when an external restore is used with no logical recovery. An example of running the task and error received: $ echo 'execute function task("defragment", "stores_demo:customer")' | dbaccess sysadmin - (expression) Failed to defrag the partition 1049057 - ISAM error 21538 The following stack may be observed for the thread during execution of the task: Stack for thread: 58 sqlexec base: 0x00000000461db000 len: 69632 pc: 0x000000000143e8b7 tos: 0x00000000461e7ec0 state: sleeping vp: 1 (oninit) yield_processor_svp (oninit) mt_yield (oninit) rs_defrag_partition (oninit) admin_reorg_extents (oninit) do_job_c (oninit) task_c (oninit) udrlm_clang_execute_internal (oninit) udrlm_clang_execute (oninit) udrlm_exec_routine (oninit) udr_execute (oninit) exroutine (oninit) geval (oninit) evalcols (oninit) ip_curnext (oninit) ip_fetch (oninit) getrow (oninit) fetchrow (oninit) exfetch (oninit) sql_nfetch (oninit) sq_nfetch (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup One workaround is to restart the instance whereupon these messages of the following form should appear in the online log: 16:59:38 Defragmenter cleaner thread now running 16:59:38 Defragmenter cleaner thread cleaned:0 partitions | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Defragment task fails with ISAM error 21538 when * * defragmenter cleaner thread does not run at startup. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.12.2018 03.10.2019 03.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |