panic on IDS10 - AIX 5.3 - File mt.c

Posted in 2006

Topics: SQL Development & Query Writing, Error Codes & Troubleshooting, Logging & Checkpoints, Platform-Specific Issues

Support Informix — Fri, 03 Nov 2006 08:16:26 — source: IIUG Forums & Mailing Lists

We are migrating to IDS10.00.FC3R1 on AIX5.3 The new production system is now in test. An assertion failed occurs, ... while no activity on the database. The errpt errlog from AIX report no hard neither soft failure. The engine seems to have a problem in module mt.c. I ignore what is stands for. Has someone seen this before ? Yves Dieltiens 16:44:05 Fuzzy Checkpoint Completed: duration was 0 seconds, 5 buffers not flushed. 16:44:05 Checkpoint loguniq 35, logpos 0x13850b8, timestamp: 0x12133888 16:44:05 Maximum server connections 7 19:19:05 Assert Failed: yield_processor: Conditional latch count non-zero in thread 7 19:19:05 IBM Informix Dynamic Server Version 10.00.FC3R1 19:19:05 Who: Session(1, informix@dvzoeps1, 0, 70000002037f028) Thread(7, main_loop(), 700000020345028, 1) File: mt.c Line: 14978 19:19:05 stack trace for pid 397406 written to /tmp/af.3ef3699 19:19:05 See Also: /tmp/af.3ef3699, shmem.3ef3699.0 19:19:11 mt.c, line 14978, thread 7, proc id 397406, yield_processor: Conditional latch count non-zero in thread 7 . 19:19:12 The Master Daemon Died 19:19:12 PANIC: Attempting to bring system down *****DISCLAIMER***** Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde en vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit bericht gewijzigd is. Bezoek onze website: http://www.dofi.fgov.be ---------------------------------------- *****DISCLAIMER***** Ce message et toutes les pieces jointes sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des Etrangers decline toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. Visiter notre site web: http://www.dofi.fgov.be

↪ replying to Support Informix

knliew — Fri, 03 Nov 2006 08:41:39 — source: IIUG Forums & Mailing Lists

We seen same error before with the same version of OS & IDS. Problem happen inconsistently when we run this SQL stmt: Select a from tab1 wherecol in ( select colx from tab2 where colx > x and coly>y); We fixed the problem with IDS 10 FC5W2 version. Support Informix wrote: >We are migrating to IDS10.00.FC3R1 on AIX5.3 > >The new production system is now in test. > >An assertion failed occurs, ... while no activity on the database. > >The errpt errlog from AIX report no hard neither soft failure. > >The engine seems to have a problem in module mt.c. > >I ignore what is stands for. > >Has someone seen this before ? > >Yves Dieltiens > >16:44:05 Fuzzy Checkpoint Completed: duration was 0 seconds, 5 buffers not >flushed. > >16:44:05 Checkpoint loguniq 35, logpos 0x13850b8, timestamp: 0x12133888 > >16:44:05 Maximum server connections 7 > >19:19:05 Assert Failed: yield_processor: Conditional latch count non-zero >in thread 7 > >19:19:05 IBM Informix Dynamic Server Version 10.00.FC3R1 > >19:19:05 Who: Session(1, informix@dvzoeps1, 0, 70000002037f028) > >Thread(7, main_loop(), 700000020345028, 1) > >File: mt.c Line: 14978 > >19:19:05 stack trace for pid 397406 written to /tmp/af.3ef3699 > >19:19:05 See Also: /tmp/af.3ef3699, shmem.3ef3699.0 > >19:19:11 mt.c, line 14978, thread 7, proc id 397406, yield_processor: >Conditional latch count non-zero in thread 7 > >.. > >19:19:12 The Master Daemon Died > >19:19:12 PANIC: Attempting to bring system down > >*****DISCLAIMER***** >Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde >en vertrouwelijk. >Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en >de verzender te verwittigen. >Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet >toegestaan, tenzij anders vermeld. >Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de >Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit >bericht gewijzigd is. >Bezoek onze website: http://www.dofi.fgov.be > >---------------------------------------- >*****DISCLAIMER***** >Ce message et toutes les pieces jointes sont etablis a l'intention exclusive >de ses destinataires et sont confidentiels. >Si vous recevez ce message par erreur, merci de le detruire et d'en avertir >l'expediteur. >Toute utilisation de ce message non conforme a sa destination, toute diffusion >ou toute publication, totale ou partielle, est interdite, sauf autorisation >expresse. >L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des >Etrangers decline toute responsabilite au titre de ce message, dans >l'hypothese ou il aurait ete modifie. >Visiter notre site web: http://www.dofi.fgov.be > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > >

↪ replying to Support Informix

A. V. GIRI RAJU — Fri, 17 Nov 2006 15:35:40 — source: IIUG Forums & Mailing Lists

i think the should be more info in /tmp/af.3ef3699 if you could post assert failure file might give us more info. - G ______________________________________________________________ From: "Support Informix" <supinformix@dofi.fgov.be> Reply-To: ids@iiug.org To: ids@iiug.org Subject: panic on IDS10 - AIX 5.3 - File mt.c [7720] Date: Fri, 3 Nov 2006 03:16:26 -0500 (EST) >We are migrating to IDS10.00.FC3R1 on AIX5.3 > >The new production system is now in test. > >An assertion failed occurs, ... while no activity on the database. > >The errpt errlog from AIX report no hard neither soft failure. > >The engine seems to have a problem in module mt.c. > >I ignore what is stands for. > >Has someone seen this before ? > >Yves Dieltiens > >16:44:05 Fuzzy Checkpoint Completed: duration was 0 seconds, 5 buffers not >flushed. > >16:44:05 Checkpoint loguniq 35, logpos 0x13850b8, timestamp: 0x12133888 > >16:44:05 Maximum server connections 7 > >19:19:05 Assert Failed: yield_processor: Conditional latch count non-zero >in thread 7 > >19:19:05 IBM Informix Dynamic Server Version 10.00.FC3R1 > >19:19:05 Who: Session(1, informix@dvzoeps1, 0, 70000002037f028) > >Thread(7, main_loop(), 700000020345028, 1) > >File: mt.c Line: 14978 > >19:19:05 stack trace for pid 397406 written to /tmp/af.3ef3699 > >19:19:05 See Also: /tmp/af.3ef3699, shmem.3ef3699.0 > >19:19:11 mt.c, line 14978, thread 7, proc id 397406, yield_processor: >Conditional latch count non-zero in thread 7 > >.. > >19:19:12 The Master Daemon Died > >19:19:12 PANIC: Attempting to bring system down > >*****DISCLAIMER***** >Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde >en vertrouwelijk. >Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en >de verzender te verwittigen. >Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet >toegestaan, tenzij anders vermeld. >Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de >Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit >bericht gewijzigd is. >Bezoek onze website: http://www.dofi.fgov.be > >---------------------------------------- >*****DISCLAIMER***** >Ce message et toutes les pieces jointes sont etablis a l'intention exclusive >de ses destinataires et sont confidentiels. >Si vous recevez ce message par erreur, merci de le detruire et d'en avertir >l'expediteur. >Toute utilisation de ce message non conforme a sa destination, toute diffusion >ou toute publication, totale ou partielle, est interdite, sauf autorisation >expresse. >L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des >Etrangers decline toute responsabilite au titre de ce message, dans >l'hypothese ou il aurait ete modifie. >Visiter notre site web: http://www.dofi.fgov.be > > >****************************************************************** ************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Spice up your IM conversations. New, colorful and animated emoticons. [1]Get chatting! References 1. http://g.msn.com/8HMAENIN/2752??PS=47575

↪ replying to A. V. GIRI RAJU

Support Informix — Mon, 20 Nov 2006 07:01:05 — source: IIUG Forums & Mailing Lists

We opened a case by Informix and they told us we 're in case --BUG 173090 : SERVER CRASH WITH "ASSERT FAILED: YIELD_PROCESSOR: --CONDITIONAL LATCH COUNT NON-ZERO IN THREAD 7" AT 2ND NODE IN A 2-NODE --REPLICATION SCENARIO. (The bug appears even without REPLICATION) We have to install IDS 10.00.FC5 Now we are still validating secondary passport advantage manager to download this version. We hope this will resume this case. Yves -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Sent: 17 November 2006 16:36 To: ids@iiug.org Subject: RE: panic on IDS10 - AIX 5.3 - File mt.c [7824] i think the should be more info in /tmp/af.3ef3699 if you could post assert failure file might give us more info. - G ______________________________________________________________ From: "Support Informix" <supinformix@dofi.fgov.be> Reply-To: ids@iiug.org To: ids@iiug.org Subject: panic on IDS10 - AIX 5.3 - File mt.c [7720] Date: Fri, 3 Nov 2006 03:16:26 -0500 (EST) >We are migrating to IDS10.00.FC3R1 on AIX5.3 > >The new production system is now in test. > >An assertion failed occurs, ... while no activity on the database. > >The errpt errlog from AIX report no hard neither soft failure. > >The engine seems to have a problem in module mt.c. > >I ignore what is stands for. > >Has someone seen this before ? > >Yves Dieltiens > >16:44:05 Fuzzy Checkpoint Completed: duration was 0 seconds, 5 buffers not >flushed. > >16:44:05 Checkpoint loguniq 35, logpos 0x13850b8, timestamp: 0x12133888 > >16:44:05 Maximum server connections 7 > >19:19:05 Assert Failed: yield_processor: Conditional latch count non-zero >in thread 7 > >19:19:05 IBM Informix Dynamic Server Version 10.00.FC3R1 > >19:19:05 Who: Session(1, informix@dvzoeps1, 0, 70000002037f028) > >Thread(7, main_loop(), 700000020345028, 1) > >File: mt.c Line: 14978 > >19:19:05 stack trace for pid 397406 written to /tmp/af.3ef3699 > >19:19:05 See Also: /tmp/af.3ef3699, shmem.3ef3699.0 > >19:19:11 mt.c, line 14978, thread 7, proc id 397406, yield_processor: >Conditional latch count non-zero in thread 7 > >.. > >19:19:12 The Master Daemon Died > >19:19:12 PANIC: Attempting to bring system down > >*****DISCLAIMER***** >Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde >en vertrouwelijk. >Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en >de verzender te verwittigen. >Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet >toegestaan, tenzij anders vermeld. >Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de >Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit >bericht gewijzigd is. >Bezoek onze website: http://www.dofi.fgov.be > >---------------------------------------- >*****DISCLAIMER***** >Ce message et toutes les pieces jointes sont etablis a l'intention exclusive >de ses destinataires et sont confidentiels. >Si vous recevez ce message par erreur, merci de le detruire et d'en avertir >l'expediteur. >Toute utilisation de ce message non conforme a sa destination, toute diffusion >ou toute publication, totale ou partielle, est interdite, sauf autorisation >expresse. >L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des >Etrangers decline toute responsabilite au titre de ce message, dans >l'hypothese ou il aurait ete modifie. >Visiter notre site web: http://www.dofi.fgov.be > > >****************************************************************** ************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Spice up your IM conversations. New, colorful and animated emoticons. [1]Get chatting! References 1. http://g.msn.com/8HMAENIN/2752??PS=47575 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. *****DISCLAIMER***** Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde en vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit bericht gewijzigd is. Bezoek onze website: http://www.dofi.fgov.be ---------------------------------------- *****DISCLAIMER***** Ce message et toutes les pieces jointes sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des Etrangers decline toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. Visiter notre site web: http://www.dofi.fgov.be

Glossary

checkpoint