Unix Technical Forum

assert failed

This is a discussion on assert failed within the Informix forums, part of the Database Server Software category; --> I received the following error on our server while updating a company symbol. Any ideas as to the cause ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 07:51 AM
Brum
 
Posts: n/a
Default assert failed

I received the following error on our server while updating a company
symbol. Any ideas as to the cause and solution???

Thanks...

22:30:18 Assert Failed: Dynamic Server 2000 must abort
22:30:18 Informix Dynamic Server 2000 Version 9.21.UC4
22:30:18 Who: Session(138270, user@servername, 39366, -1609288968)
Thread(147105, sqlexec, a0126fb8, 3)
File: rsbuff.c Line: 3618
22:30:18 Results: Dynamic Server 2000 must abort
22:30:18 Action: Reinitialize shared memory
22:30:18 stack trace for pid 20142 written to /tmp/af.42896fba
22:30:18 See Also: /tmp/af.42896fba
22:30:27 rsbuff.c, line 3618, thread 147105, proc id 20142, Dynamic
Server 2000
must abort.
22:30:27 Fatal error in ADM VP at mt.c:11462
22:30:27 Unexpected virtual processor termination, pid = 20142, exit
= 0x100

22:30:27 PANIC: Attempting to bring system down
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 07:51 AM
Alan
 
Posts: n/a
Default Re: assert failed

Hello, I always meet the similar error before and sent all related log
file to IBM. The only solution from IBM is upgrade our IDS to 9.4....

Anyway, my suggestion is is to read the file trace file
(/tmp/af.42896fba in your case), find out which SQL statement cause the
fault. (I know this is difficult, because the SQL could be run without
any problem after you restart IDS). Good Luck.

Brum wrote:
> I received the following error on our server while updating a company
> symbol. Any ideas as to the cause and solution???
>
> Thanks...
>
> 22:30:18 Assert Failed: Dynamic Server 2000 must abort
> 22:30:18 Informix Dynamic Server 2000 Version 9.21.UC4
> 22:30:18 Who: Session(138270, user@servername, 39366, -1609288968)
> Thread(147105, sqlexec, a0126fb8, 3)
> File: rsbuff.c Line: 3618
> 22:30:18 Results: Dynamic Server 2000 must abort
> 22:30:18 Action: Reinitialize shared memory
> 22:30:18 stack trace for pid 20142 written to /tmp/af.42896fba
> 22:30:18 See Also: /tmp/af.42896fba
> 22:30:27 rsbuff.c, line 3618, thread 147105, proc id 20142, Dynamic
> Server 2000
> must abort.
> 22:30:27 Fatal error in ADM VP at mt.c:11462
> 22:30:27 Unexpected virtual processor termination, pid = 20142, exit
> = 0x100
>
> 22:30:27 PANIC: Attempting to bring system down

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 07:51 AM
Guy Bowerman
 
Posts: n/a
Default Re: assert failed

Take a look at the af file: /tmp/af.42896fba for more information.
You'll sometimes see this type of AF if the physical log has overflowed.
You'd be able to confirm or rule that out from the af file.

Regards
Guy

Brum wrote:
> I received the following error on our server while updating a company
> symbol. Any ideas as to the cause and solution???
>
> Thanks...
>
> 22:30:18 Assert Failed: Dynamic Server 2000 must abort
> 22:30:18 Informix Dynamic Server 2000 Version 9.21.UC4
> 22:30:18 Who: Session(138270, user@servername, 39366, -1609288968)
> Thread(147105, sqlexec, a0126fb8, 3)
> File: rsbuff.c Line: 3618
> 22:30:18 Results: Dynamic Server 2000 must abort
> 22:30:18 Action: Reinitialize shared memory
> 22:30:18 stack trace for pid 20142 written to /tmp/af.42896fba
> 22:30:18 See Also: /tmp/af.42896fba
> 22:30:27 rsbuff.c, line 3618, thread 147105, proc id 20142, Dynamic
> Server 2000
> must abort.
> 22:30:27 Fatal error in ADM VP at mt.c:11462
> 22:30:27 Unexpected virtual processor termination, pid = 20142, exit
> = 0x100
>
> 22:30:27 PANIC: Attempting to bring system down

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-20-2008, 07:51 AM
scottishpoet
 
Posts: n/a
Default Re: assert failed

9.21.UC4???

This is unsupported. maybe thats why you are posting on here instead
of calling support?

You haven;t posted the af file, /tmp/af.42896fba, only the online log.

Can you post the stack from the failling thread? and maybe the sql
from the failing thread too?


tbrumley@munder.com (Brum) wrote in message news:<bc21821a.0410081026.7b1b459d@posting.google. com>...
> I received the following error on our server while updating a company
> symbol. Any ideas as to the cause and solution???
>
> Thanks...
>
> 22:30:18 Assert Failed: Dynamic Server 2000 must abort
> 22:30:18 Informix Dynamic Server 2000 Version 9.21.UC4
> 22:30:18 Who: Session(138270, user@servername, 39366, -1609288968)
> Thread(147105, sqlexec, a0126fb8, 3)
> File: rsbuff.c Line: 3618
> 22:30:18 Results: Dynamic Server 2000 must abort
> 22:30:18 Action: Reinitialize shared memory
> 22:30:18 stack trace for pid 20142 written to /tmp/af.42896fba
> 22:30:18 See Also: /tmp/af.42896fba
> 22:30:27 rsbuff.c, line 3618, thread 147105, proc id 20142, Dynamic
> Server 2000
> must abort.
> 22:30:27 Fatal error in ADM VP at mt.c:11462
> 22:30:27 Unexpected virtual processor termination, pid = 20142, exit
> = 0x100
>
> 22:30:27 PANIC: Attempting to bring system down

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:49 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com