[MDEV-12382] Query crashes CREATE TABLE XX AS SELECT * FROM YY Created: 2017-03-28 Updated: 2019-05-20 Resolved: 2019-05-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera, Server |
| Affects Version/s: | 10.1.22 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Anton | Assignee: | Jan Lindström (Inactive) |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | galera | ||
| Environment: |
Redhat 7.3 |
||
| Attachments: |
error-log.mariadb.galera.log
galera.cnf
my.cnf
|
||||||||||||
| Issue Links: |
|
||||||||||||
| Description |
|
Hi there, my mariaDB with Galera enabled is crashing when a tool that is creating some schemas running the following query CREATE TABLE DP_ORDERBY_BACKUP AS SELECT * FROM DP_ORDERBY. The problem is whenever the tool is trying to run the query (s. above) the mariadb cluster is crashing without any warning and not just one node, all of them are unavailable. The DP_ORDERBY table is empty, I have tried running the same query where the DP_ORDERBY table has one value in it in that case mariadb is running fine. I've looked also into other issues (s. linked issues) but somehow this failure was fixed in older versions but still appearing in my 10.1.22 version. Any input helps thanks! |