Re: IDS 9.4UC8: dbimport crashes with assert failures

June Nebab wrote: > Hello Folks, > > My dbimport fails on a test system with assert failures. Does not > always crash on the same table or unload file. The > database is 3.9GB. Import of a smaller (5.1MB) database works fine. > The online log file looks like this: > > > 10:05:02 Assert Warning: I/O error, Primary Chunk > '/u/informix/devices/ids94/prod_dbs_hdb2' -- Offline > 10:05:02 IBM Informix Dynamic Server Version 9.40.UC8 > 10:05:02 Who: Thread(14, flush_sub(1), 51285c48, 1) > File: rsbuff.c Line: 4742 > 10:05:02 Results: Chunk is now unusable > 10:05:02 Action: Repair and restore from mirror or archive > 10:05:02 stack trace for pid 18964 written to > /u/informix/9_4/tmp/af.3f6519d > 10:05:02 See Also: /u/informix/9_4/tmp/af.3f6519d > 10:05:03 I/O error, Primary Chunk > '/u/informix/devices/ids94/prod_dbs_hdb2' -- Offline > 10:05:03 Assert Failed: INFORMIX-OnLine Must ABORT > Critical media failure. > 10:05:03 IBM Informix Dynamic Server Version 9.40.UC8 > 10:05:03 Who: Thread(14, flush_sub(1), 51285c48, 1) > File: rsmirror.c Line: 1812 > 10:05:03 stack trace for pid 18964 written to > /u/informix/9_4/tmp/af.3f6519d > 10:05:03 See Also: /u/informix/9_4/tmp/af.3f6519d > 10:05:05 rsmirror.c, line 1812, thread 14, proc id 18964, > INFORMIX-OnLine Must ABORT > Critical media failure.. > 10:05:05 The Master Daemon Died > 10:05:05 PANIC: Attempting to bring system down > > The assert file looks like this: > > > > 10:05:02 mt_aio_wait(51715680) > 10:05:02 chunkio(3, 0x48eb7800, 0x5594f, 0, 0x1, 1360522504, 34) > errno 1 > AIOREQ *a > 518d2b68: 00000000 00000000 00000000 00000000 ........ ........ > 518d2b78: 00000000 00000000 c8577151 38557151 ........ .WqQ8UqQ > 518d2b88: 00000000 00000000 bd0f0000 41494f72 ........ ....AIOr > 518d2b98: 65710000 00000000 d1070000 00000000 eq...... ........ > 518d2ba8: 03000000 01090000 01000000 02000000 ........ ........ > 518d2bb8: 01000000 00000000 01000000 00577151 ........ .....WqQ > 518d2bc8: 00000000 01000000 05000000 01000000 ........ ........ > 518d2bd8: 00000000 00000000 00000000 ........ .... > 10:05:02 > 10:05:02 IBM Informix Dynamic Server Version 9.40.UC8 > Software Serial Number AAA#B000000 > > 10:05:02 Assert Warning: I/O error, Primary Chunk > '/u/informix/devices/ids94/prod_dbs_hdb2' -- Offline > 10:05:02 Who: Thread(14, flush_sub(1), 51285c48, 1) > File: rsbuff.c Line: 4742 > 10:05:02 Results: Chunk is now unusable > 10:05:02 Action: Repair and restore from mirror or archive > 10:05:02 Stack for thread: 14 flush_sub(1) > > base: 0x518ca000 > len: 36864 > pc: 0x085ff9eb > tos: 0x518d24b0 > state: running > vp: 1 > > 0x085ff9eb (oninit)afstack (0x5182cb28, 0x498c519e, 0x518d2ab8, > 0x85fef38, 0x88aae40, 0x4a14) > 0x085fef46 (oninit)afhandler(0x1, 0x518d2be4, 0x518b4a20, > 0x518b5800, 0x401, 0x1) > 0x085fe8c5 (oninit)afwarn_interface(0x518d2be4, 0x518b4a20, > 0x518b5800, 0x886bca4, 0x1286, 0x518d2be4) > 0x08428e1a (oninit)chunkio (0x51715680, 0x3, 0x48eb7800, 0x5594f, > 0x0, 0x1) > 0x084291d7 (oninit)physio (0x51715680, 0x517157c8, 0x48eb7800, > 0x5594f, 0x1, 0x1) > 0x0843b6b4 (oninit)flush_buffers(0x512c50a8, 0x518d2e78, 0x4, > 0x13, 0x512c50a8, 0x13) > 0x0843bb13 (oninit)clean_lru(0x13, 0x512c50a8, 0x518d2fc8, > 0x843bdec, 0x512c50a8, 0x0) > 0x0843bdf6 (oninit)flush_sub(0x1, 0x0, 0x0, 0x0, 0x0, 0x0) > 0x085e3490 (oninit)startup (0x0, 0x518d3670, 0x518d3058, 0x670, > 0xa31a6d39, 0x0) > 0x00000000 (*nosymtab*)0x0 > Have a look in /var/log/messages or dmesg You have a failing disk at wherever /u/informix/devices/ids94/prod_dbs_hdb2 points to