Re: Assert Failed: Internal Error - Bus Error
Jeff Craig wrote:
> }>From ilist@rmy.emory.edu Mon Jul 14 05:24:28 1997
> }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP
> (950413.SGI.8.6.12/930416.SGI.AUTO)
> }> for <settler@dbintellect.com> id FAA06490; Mon, 14 Jul 1997
> 05:24:26 -0600
> }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1)
> id FAA20581 for informix-list-out; Mon, 14 Jul 1997 05:10:01 -0400
> (EDT)
> }>From: PROJECT Yakov Berkovitch 5055 <berko@cpm.elex.co.il>
> }>Message-Id: <33C9C6D3.78FE@cpm.elex.co.il>
> }>Subject: Assert Failed: Internal Error - Bus Error
> }>Date: Mon, 14 Jul 1997 06:27:32 GMT
> }>Reply-To: PROJECT Yakov Berkovitch 5055 <berko@cpm.elex.co.il>
> }>Organization: Telrad Ltd.
> }>Sender: informix-list-owner@rmy.emory.edu
> }>To: informix-list@rmy.emory.edu
> }>X-Informix-List-Id: <news.40382>
> }>
> }>Hello,
> }>
> }>we have a serious problem with our Informix release. I also don't
> know
> }>if newer release solved the problem.
> }>
> }>Here is our configuration:
> }> - Informix Online 7.12 UC1 on HPUX 9.05.
> }>
> }>The problem:
> }>Since a few days the oninit processes are going down almost one time
> per
> }>day. The big problem is that the application is already in service
> in
> }>one of our big customer. It's very difficult for us to reproduce the
>
> }>problem in our development site.
> }>
> }>Here is what was written in the online.log file:
> }>
> }>02:28:52 Logical Log 3916 Complete.
> }>02:33:59 Checkpoint Completed: duration was 8 seconds.
> }>02:39:06 Checkpoint Completed: duration was 5 seconds.
> }>02:44:14 Checkpoint Completed: duration was 5 seconds.
> }>02:47:33 Logical Log 3917 Complete.
> }>02:49:24 Checkpoint Completed: duration was 8 seconds.
> }>02:54:30 Checkpoint Completed: duration was 6 seconds.
> }>02:59:37 Checkpoint Completed: duration was 5 seconds.
> }>03:03:25 Logical Log 3918 Complete.
> }>03:03:57 Assert Failed: Internal Error - Bus Error
> }>03:03:57 Who:Session(126, atlas@gl1os1, 24700, -1029554752)
> }> Thread(49, sqlexec, c2a031b0, 1)
> }>03:03:57 Results: OnLine must abort
> }>03:03:57 Action: Reinitialize shared memory
> }>03:03:57 See Also: /tmp/af.316ced, shmem.316ced.0
> }>03:04:52 rsinit.c, line 9151, thread 49, proc id 24199, Bus Error.
> }>03:04:53 PANIC: Attempting to bring system down
> }>============================================
> }> - Also a core file is generated.
> }> - Can anybody (Informix people) tell me what is in the file
> rsinit.c
> }>line 9151. It always failed in this file and line.
> }> - We can also see that in the output
> }>"Who:Session(126, atlas@gl1os1, 24700, -1029554752)"
> }>the last number seems to be incorrect.
> }>
> }>My problem is also that i cannot look inside the memory dump
> }>'shmem.316ced.0' with the onstat -i tool. I get this error:
> }>
> }>HP_shmgetat(): Virtual address 0xc043b000 not available got
> 0xc3286000
> }>rinfile: shmget/shmat error errno=2
> }>
> }>====================================================
> }>You understand that it's very critical. The customer wants to drop
> }>Informix from his site !!!!!
> }>
> }>Every suggestion will help me.
> }>Our Informix supplier get also the description of the problem, but i
>
> }>prefer to ask more people.
> }>
> }>Also i know that there are newer release of Informix Online BUT if i
>
> }>need to replace the actual release i want to be sure that the
> problem
> }>will be solved !!
> }>
> }>Thanks for your help.
> }>--
> }>
> }>Yakov.
> }> <Yakov Berkovitch - berko@cpm.elex.co.il>
> }>
>
> I have received these on an Informix 7.20.UC2 version running on IRIX
> 6.2.
> We finally traced ours down to a problem in the way Informix was
> handling
> a conversion error. The SQL compared an INTEGER column with a CHAR
> constant. This problem "disappeared" in release 7.22, but that release
> had
> other problems, so we are waiting for Informix 7.23. In the meantime,
> we occasionally have PANICs, and the database server crashes. The only
>
> thing I can suggest is that your application developers check their
> programs to be sure that they have defined host variables and that the
>
> data they are putting into the host variables matches the data type of
> the
> column they are comparing to.
>
> -------------------------------------------------------------------
> Jeff Craig | dbINTELLECT Technologies, Inc.
> Senior Consultant | Golden, CO
> | (303) 275-6954 ext. 8008
> | email: settler@dbintellect.com
> | fax: (303) 275-2134
> -------------------------------------------------------------------
Hi!
I also received a similar problem on an Informix 7.20. UC1 version
running
on IRIX 6.2. I am not shure but we found a problem when there is a NULL
value in WHERE statement (SQL).Then we installed Informix 7.22. UC1,
but the problem remained.
I would be very pleased if you can tell me more about "your problems"
on
7.22 and if INFORMIX 7.23 is already available for SGI.
PS: I tought I am the only one with combination SGI - INFORMIX
Miran Nikolic
DBA and SGI administrator
Telekom Slovenije
Ljubljana
Slovenia
tel: +386 61 304 645
fax: +386 61 132 93 98
email: miran.nikolic@telekom.si