maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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 security@xxxxxxxxxxx