Hi, Reindl! 1. Do you actually have <datadir>/dbmail/*271* files ? 2. What did you do to end up in this situation? May be an interrupted ALTER TABLE? A crash or kill -9, perhaps?
On Sep 11, Reindl Harald wrote: > as far as i remember i was told 10.3 is able to fix that after a full > dcade now but it don't > > 2019-09-11 18:18:12 0 [ERROR] InnoDB: Operating system error number 2 in a > file operation. > 2019-09-11 18:18:12 0 [ERROR] InnoDB: The error means the system cannot find > the path specified. > 2019-09-11 18:18:12 0 [ERROR] InnoDB: If you are installing InnoDB, remember > that you must create directories yourself, InnoDB does not create them. > 2019-09-11 18:18:12 0 [ERROR] InnoDB: Cannot open datafile for read-only: > './dbmail/#sql2-704-271.ibd' OS error: 71 > 2019-09-11 18:18:12 0 [ERROR] InnoDB: Operating system error number 2 in a > file operation. > 2019-09-11 18:18:12 0 [ERROR] InnoDB: The error means the system cannot find > the path specified. > 2019-09-11 18:18:12 0 [ERROR] InnoDB: If you are installing InnoDB, remember > that you must create directories yourself, InnoDB does not create them. > 2019-09-11 18:18:12 0 [ERROR] InnoDB: Could not find a valid tablespace file > for ``dbmail`.`#sql2-704-271``. Please refer to > https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to > resolve the issue. > 2019-09-11 18:18:12 0 [Warning] InnoDB: Ignoring tablespace for > `dbmail`.`#sql2-704-271` because it could not be opened. > > MariaDB [(none)]> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES > WHERE NAME LIKE '%#sql%'; > +----------+----------------------+------+--------+-------+------------+---------------+------------+ > | TABLE_ID | NAME | FLAG | N_COLS | SPACE | ROW_FORMAT | > ZIP_PAGE_SIZE | SPACE_TYPE | > +----------+----------------------+------+--------+-------+------------+---------------+------------+ > | 672 | dbmail/#sql2-704-271 | 41 | 5 | 545 | Compressed | 8192 > | Single | > +----------+----------------------+------+--------+-------+------------+---------------+------------+ > 1 row in set (0.002 sec) > > MariaDB [(none)]> use dbmail > ERROR 1051 (42S02): Unknown table 'dbmail.dbmail/#sql2-704-271' > MariaDB [dbmail]> DROP TABLE `dbmail#sql2-704-271`; > ERROR 1051 (42S02): Unknown table 'dbmail.dbmail#sql2-704-271' > MariaDB [dbmail]> Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
