RE: 1 node in cluster fails hourly: Ndb kernel is stuck in: JobHandling

The machine is certainly not swapping, there is ample RAM.

Our load averages are typically:

3.76 (1 min) 3.40 (5 mins) 3.26 (15 mins)

Sure enough we can optimize queries (FORCE INDEX anyone?) but for now our priority is stability.

Thanks

-----Original Message-----
From: Stewart Smith [mailto:stewart@mysql.com] Sent: 03 October 2007 04:33
To: James Graham
Cc: cluster@lists.mysql.com
Subject: Re: 1 node in cluster fails hourly: Ndb kernel is stuck in: JobHandling

On Mon, 2007-10-01 at 09:51 +0100, James Graham wrote:
> Since yesterday evening, one of our data nodes has been crashing every
> hour or so.
> Our setup is a load balancer running the ndb_mgm, and 2 machines
running
> ndbd/mysqld.
>
> The error is below:
> Time: Monday 1 October 2007 - 06:54:03
> Status: Temporary error, restart node
> Message: WatchDog terminate, internal error or massive overload on the
> machine r
> unning this node (Internal error, programming error or missing error
> message, pl
> ease report a bug)
> Error: 6050
> Error data: Job Handling
> Error object: WatchDog.cpp
> Program: ndbd
> Pid: 4218
> Trace: /var/lib/mysql-cluster/ndb_3_trace.log.21
> Version: Version 5.0.32

Is the machine overloaded? swapping at all?

-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@sip.us.mysql.com
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek