maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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]>