SQL Node Keeps Throwing Error "NDB: Could Not Acquire Global Schema Lock (4009)Cluster Failure"

(Doc ID 1932839.1)

Last updated on JUNE 09, 2017

Applies to:

MySQL Cluster - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

When trying to use DML or DDL statements (example: 'create database', 'delete table', etc) in MySQL Cluster environment, or failing to allocate NodeId for API, the following error is shown in MySQL error log file:

Changes

Variable ndb-cluster-connection-pool increased or API slots removed.

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