dbTalk Databases Forums  

[Info-ingres] iircp.log error messages

comp.databases.ingres comp.databases.ingres


Discuss [Info-ingres] iircp.log error messages in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
martin.bowes@ctsu.ox.ac.uk
 
Posts: n/a

Default [Info-ingres] iircp.log error messages - 03-16-2005 , 05:27 AM






Hi Dudes,

II2.5/0011 patch 9563.

Can anyone explain the significance of the following messages
from iircp.log:
!Tue Mar 15 20:45:24 2005 Reducing session 00000001402C86C0
priority to 6, waiting for LG LPB mutex 18
!Tue Mar 15 20:45:24 2005 Reducing session 00000001402C86C0
priority to 3, waiting for LG LPB mutex 18
!Tue Mar 15 20:45:24 2005 Reducing session 00000001402C86C0
priority to 1, waiting for LG LPB mutex 18

I presume the session is in the recovery server and not the
dbms server. I had a huge flurry of these last night and early this
morning the server stalled with several sessions in mutex and logstat
showed status CPSTALL.

I suspect the problem has been from the elderly OS DUNIX 5.1
having problems with threads.

I'm trying to schedulle in an OS upgrade to 5.1b PK3 at the
moment. And am moving towards an upgrade of ingres to II2.6. Anyone
have any other suggestions.

Martin Bowes
--
Duckman: Hummana Hummana Howwa!!
Cornfed: Either you're babbling, or you just told me in Cherokee that my
scrotum was many colored.


Reply With Quote
  #2  
Old   
martin.bowes@ctsu.ox.ac.uk
 
Posts: n/a

Default RE: [Info-ingres] iircp.log error messages - 03-16-2005 , 06:33 AM






Hi Jean-Luc

I've just checked, and the system does have
round_robin_switch_rate = 0

Marty

On 16 Mar 2005 at 11:51, Hampton, Jean Luc wrote:

Quote:
Hi Martin,

It sounds Kernel related...
round_robin_switch_rate = A value that determines (per second of CPU
time) the number of context switches that can occur between processes
with the same priority and the time slice allotted to each process.

The default is 0 (in fact 100 context switches per second)
very often, the good old sys_check (the favorite Tru64 sys admin tool)
advises you to change it to something else

With Ingres : don't do that - otherwise logging system "deadlock"
warranted: all sessions waiting for a CPFLUSH that will never happen

So , round_robin_switch_rate = 0

Cheers
Jean-Luc
--
Random Duckman Quote #75:
Duckman: Alright, come-on. We don't even have a plot yet!




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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.