Unable to Log Into Cloudera Manager - Associated MySQL Logs Report "APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!" (Doc ID 2399242.1)

Last updated on SEPTEMBER 13, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.8.0 and later
Linux x86-64

Symptoms

It is not possible to log into Cloudera Manager.

1. The Cloudera Manager server log on the CM host, Node 3 by default on the BDA, /var/log/cloudera-scm-server/cloudera-scm-server.log reports:

...
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. ]
which will not be reported to listeners!
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

2. The corresponding MySQL log on the CM host, Node 3 by default on the BDA, /var/log/mysqld.log reports:

...
<timestamp> WARN Timer-0:com.mchange.v2.async.ThreadPoolAsynchronousRunner:
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@<user> -- APPARENT DEADLOCK!!! Creating emergency
threads for unassigned pending tasks!
...

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

Cause

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Unable to Log Into Cloudera Manager - Associated MySQL Logs Report "APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!" (Doc ID 2399242.1)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

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