[MDEV-22481] Server crash after access to table with imported tablespace (after restart) Created: 2020-05-06 Updated: 2020-06-04 Resolved: 2020-06-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.4.12 |
| Fix Version/s: | 10.4.13 |
| Type: | Bug | Priority: | Major |
| Reporter: | Marek Šrom | Assignee: | Marko Mäkelä |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Cent OS 8 |
||
| Attachments: |
|
||||||||||||||||
| Issue Links: |
|
||||||||||||||||
| Description |
|
I created script to detach / attach database, attached database works fine until restart... To reproduce: CREATE DATABASE `db6` DEFAULT CHARACTER SET latin1 ; insert into a1 value(1); #export data #copy files db6/a1.frm, db6/a1.ibd, db6/a1.cfg somewhere else #unlock UNLOCK TABLES; #drop database DROP DATABASE db6; #restore database back #copy saved files db6/a1.cfg, db6/a1.frm, db6/a1.ibd back #change owner to mysql:mysql if needed #import tablespace #test
------
------ #restart service #test again select * from a1; ERROR 2006 (HY000): MySQL server has gone away Error log: To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.4.12-MariaDB Thread pointer: 0x7f96d0000c08 |
| Comments |
| Comment by Marko Mäkelä [ 2020-05-06 ] |
|
This looks like a duplicate of |
| Comment by Marek Šrom [ 2020-05-06 ] |
|
Sorry): I'd like to ask, if I understand there is a fix for import table space to avoid this... Shouldn't there be even some fix to avoid server crash in case of "corrupted" data file? I don't think server should crash in this case... I understand that database/table will be unaccessible but server crash? Thanks |
| Comment by Marek Šrom [ 2020-05-06 ] |
|
And sorry for bothering, but is there some information about MariaDB 10.4.13 release date? Thanks (if it's worth building myself or not...) |
| Comment by Marko Mäkelä [ 2020-06-04 ] |
|
|