Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.11
-
None
-
Windows 7
Workstation / Lenovo D30
Description
I have several databases:
- fire_curr: 10 tables, number of rows between 100 and 16 Mio
- fire_curr_add: 20 tables, number of rows between 100 and 16 Mio
and many other databases on the same MariaDB instance. When I submit an sql to fire_curr_add, for example:
SELECT COUNT(*) FROM fire_curr_add.patient |
I get connection to the server and results. When I send the query
to fire_curr, for example:
SELECT COUNT(*) FROM fire_curr.patient |
I get the error:
MariaDB: ERROR 2013 (HY000): Lost connection to MySQL server during query
and the service stops. When I restart the service each time I want to access the database curr the serivice stops. This is not the case for nearly all other databases
of the same instance. The instance and databases exists since 6 month and I had never such problems.
Other affected database, tables and columns:
I have access to database information_schema. For example, I can count the rows of table system_variables:
SELECT COUNT(*) FROM system_variables |
But if I try the same with table columns:
SELECT COUNT(*) FROM columns |
the connection will be lost.
This works:
SELECT COUNT(*) FROM tables |
Also this:
*SELECT table_schema, table_name FROM tables |
But if I submit
SELECT * FROM tables |
or
SELECT table_schema, table_name, engine, table_rows |
FROM tables |
LIMIT 10
|
the connection will be lost.
Summary: some database disconnect the mysql-server and also some columns of tables.
This problems was also submitted to stackoverflow.
Attachmemts
- WS20130124-2_20171130-2.zip: contains the compete err-file.
- jira_01_select.gif: mysql-terminal output
Other relevant informations:
- 20-23.11.2017 All tables have been copied from fire_curr to fire_curr_add and processed in fire_curr_add.
- 29.11.2017 Version 10.2.6 was upgraded to 10.2.11, but problem persists.