My Oracle Support Banner

Sisgot_p: Several Sleeping Session On Mysql Database (Doc ID 1967349.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 5.5 version, Miscellaneous Storage Engine Problem

When attempting to query,
the following error occurs.

ERROR
-----------------------
Got error -1 when reading table './mydb/mytablename'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run a query that takes a lock
2. Kill the query while still locked
3. Check the error log for notice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users see spurious details in the error log.

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.