IDS 9.4UC8: dbimport crashes with assert failures

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-OnLineMust 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 SerialNumber 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 Redhat Enterprise Linux - AS v 4 2.6.9-67.ELsmp IDS 9.4UC8 320GB SATA subsystem. DISCLAIMER This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments thereto is privileged and/or confidential and is intended ONLY for the use of the individual(s) and/or entity(s) named above. If you are not the intended recipient, you are strictly prohibited from disclosing, printing, copying, using or disseminating this transmission and/or any such attachments and any information contained in this transmission and/or in any such attachments. ANY unauthorized interception of this transmission and/or any such attachments is a violation of federal criminal law. If you have received this transmission in error, please notify the sender immediately and delete the transmission and all such attachments.

On Feb 6, 3:45 pm, "June Nebab" <jne...@idealcut.com> 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 <snip> Can you post an onstat -d and also an ls -l of the actual chunks (and if they are links, where the links go to?) errno 1 would suggest a permission error, but this is Linux :-/

On 6 Feb, 15:45, "June Nebab" <jne...@idealcut.com> 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 > > Redhat Enterprise Linux - AS v 4  2.6.9-67.ELsmp > IDS 9.4UC8 > 320GB SATA  subsystem. > > DISCLAIMER > > This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments thereto is privileged and/or confidential and is intended ONLY for the use of the individual(s) and/or entity(s) named above. If you are not the intended recipient, you are strictly prohibited from disclosing, printing, copying, using or disseminating this transmission and/or any such attachments and any information contained in this transmission and/or in any such attachments. ANY unauthorized interception of this transmission and/or any such attachments is a violation of federal criminal law. > If you have received this transmission in error, please notify the sender immediately and delete the transmission and all such attachments. ou have an I/O error on device /u/informix/devices/ids94/prod_dbs_hdb2'