Temporary Disk I/O Stalls; LCP Frag Watchdog : No progress on Table (Doc ID 1582813.1)

Last updated on OCTOBER 04, 2017

Applies to:

MySQL Cluster - Version 6.3 and later
Generic Linux

Symptoms

During periods with high load, for example while creating backups or executing bulk updates particularly if these involve large BLOBs, disk I/O activities are temporary stalling.

For performance critical I/O activities this may cause temporary errors and/or the data node to crash. Examples of performance critical I/O in MySQL Cluster are:

 

One sign of the issue - although not necessarily required - is 100% disk utilisation while nothing is written to or read from the disk, for example:

 

Changes

The more memory that is available on the server, the more likely this issue is to happen, so the issue may begin after installing more memory or upgrading to a new server with more memory available.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms