| Bug #76298 | Print reason for error: Error 1005: Can\'t create table \'t\' (errno: 13) | ||
|---|---|---|---|
| Submitted: | 12 Mar 2015 15:30 | Modified: | 14 Dec 2015 14:41 |
| Reporter: | Sven Sandberg | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Errors | Severity: | S3 (Non-critical) |
| Version: | 5.6 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[14 Dec 2015 14:41]
Paul DuBois
Noted in 5.8.0 changelog. The server now tries to provide more informative messages for these error codes: ER_CANT_CREATE_DB, ER_CANT_CREATE_TABLE, ER_DB_DROP_DELETE, ER_DB_DROP_RMDIR, ER_ERROR_DURING_COMMIT, ER_ERROR_DURING_ROLLBACK, ER_GET_ERRNO.
Description: This failure was seen on Hudson: rpl.rpl_row_img_idx_full 'row' w5 [ fail ] Test ended at 2015-03-04 12:30:14 CURRENT_TEST: rpl.rpl_row_img_idx_full mysqltest: In included file ".\include\rpl_row_img_general_loop.inc": included from .\include\rpl_row_img_general_loop.inc at line 36: At line 36: query 'CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= $server_1_engine;' failed: 1005: Can't create table 't' (errno: 13) "Errno 13" isn't very helpful. You can translate it using extra/perror, but this is user-unfriendly since it requires access to the machine, plus you need to know about this tool. Better if the server includes the reason in the message itself. How to repeat: http://fimafeng11.no.oracle.com:8080/job/reviews-windows-5.1-5.5-5.6/2459/consoleText