If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > informix database shutdown suddenly

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-23-03, 20:33
zzx806 zzx806 is offline
Registered User
 
Join Date: Dec 2003
Location: China,Fujian
Posts: 8
informix database shutdown suddenly

informix database v7.30 uc2 work on SGI irix6.5 ,
shutdown suddenlu when it work on. This take from online.log:

assert failed:unexpected virtual processor termination .
pid=2036936,exit=0x9 ;

There is no abnormity about hardware .


please give me some advice . thank your help.
Reply With Quote
  #2 (permalink)  
Old 12-24-03, 06:21
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Re: informix database shutdown suddenly

Quote:
Originally posted by zzx806
informix database v7.30 uc2 work on SGI irix6.5 ,
shutdown suddenlu when it work on. This take from online.log:

assert failed:unexpected virtual processor termination .
pid=2036936,exit=0x9 ;

There is no abnormity about hardware .


please give me some advice . thank your help.
Hi,

The error code=0x9, i think that is: "Bad file number". Please check if connection is via shared memory or tcp/tli.
And check for SO parameters NFILES or similar.

BTW: Marry Christmas !!!

Gustavo.
Reply With Quote
  #3 (permalink)  
Old 12-25-03, 19:45
zzx806 zzx806 is offline
Registered User
 
Join Date: Dec 2003
Location: China,Fujian
Posts: 8
Re: informix database shutdown suddenly

gurey:thank your reply and bless .
and i am sorry ,can you speak more detail about
" SO parameters NFILES or similar "

at the same time there is message in os log file(/var/adm/SYSLOG)

"alert: process 2036936 killed due to insufficient memory/swap"

does it change onconfig file can solve the question.
Reply With Quote
  #4 (permalink)  
Old 12-30-03, 16:30
fprose fprose is offline
Registered User
 
Join Date: Apr 2003
Location: Phoenix, AZ
Posts: 177
Re: informix database shutdown suddenly

Check the size of your configured instance vs. physical memory on the server. Then check configured swap space and see how much in use.

Rule one, you don't want to swap.
Rule two, have enough space to swap if you do - cause if the OS decides to swap out Informix, that's going to take a big chunk of your swap space.
__________________
Fred Prose
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On