Details
-
Task
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
Description
It would be great if we could improve the quality of some or all error messages.
For example:
CREATE TABLE t (i INT KEY); |
ALTER TABLE t DISCARD TABLESPACE; |
SELECT * FROM t; |
Will lead to (in the CLI):
|
10.9.0 b5852ffbeebc3000982988383daeefb0549e058a (Debug) |
10.9.0-dbg>SELECT * FROM t;
|
ERROR 1814 (HY000): Tablespace has been discarded for table `t`
|
Which is sufficiently clear to understand what is happening, or at least to get a good hint in the case where the SELECT happens much later than the DISCARD TABLESPACE.
However, the error log is much more cryptic:
|
10.9.0 b5852ffbeebc3000982988383daeefb0549e058a (Debug) |
2022-02-26 8:11:50 0 [Note] /test/MD140222-mariadb-10.9.0-linux-x86_64-dbg/bin/mysqld: ready for connections.
|
Version: '10.9.0-MariaDB-debug' socket: '/test/MD140222-mariadb-10.9.0-linux-x86_64-dbg/socket.sock' port: 27815 MariaDB Server
|
2022-02-26 8:12:08 6 [ERROR] Got error 194 when reading table './test/t'
|
Sysadmins would have to use the bin/perror tool (if they know it exists), or search online, to find out what is happening. We can save them from having to take this extra and unnecessary step by automating (and improving) the error to message step:
|
Proposed Output |
2022-02-26 8:12:08 6 [ERROR] Got error 194 when reading table './test/t' (Tablespace is missing for a table)
|
It would seem that this is low hanging fruit and a feature easy to implement.
Attachments
Issue Links
- relates to
-
MDEV-19849 InnoDB should and can be more specific with errno: 168 "Unknown (generic) error from engine". The output for MyISAM, Aria and RocksDB can also be improved.
-
- Confirmed
-
-
-
- Open
-
-
-
- Open
-