Bug #74921 [ERROR] Invalid (old?) table or database name 'a@b'

• Submitted: 19 Nov 2014 1:32
• Modified: 20 Nov 2014 2:59
• Reporter: Roel Van de Paar
• Status: Duplicate
• Category: MySQL Server: Logging
• Severity: S2 (Serious)
• Version: 5.6.20
• OS: Any
• CPU Architecture: Any
• Tags: opt

[19 Nov 2014 1:32] Roel Van de Paar

Description:
Version: '5.6.20'  socket: '/sda/mysql-5.6.20-linux-glibc2.5-x86_64/socket.sock'  port: 17231  MySQL Community Server (GPL)
2014-11-19 10:20:23 3417 [ERROR] Invalid (old?) table or database name 'a@b'

I have seen this at exactly the same time as a crash. I expect that with some testcase tweaking it may be able to sig11 mysqld with this.

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE DATABASE `#mysql50#a@b`;
SHOW DATABASES LIKE "TEST%";

[19 Nov 2014 5:42] MySQL Verification Team

Hello Roel,

Thank you for the report.
This is duplicate of Bug #73920.

// with 5.6.23

[test]> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.6.23                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.6.23-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | Linux                                                   |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

[test]> CREATE DATABASE `#mysql50#a@b`;
Query OK, 1 row affected (0.00 sec)

[test]> SHOW DATABASES LIKE "TEST%";
Empty set (0.00 sec)

[test]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| #mysql50#a@b       |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)

[test]> CREATE DATABASE `#mysql50#mysqltest-1`;
Query OK, 1 row affected (0.00 sec)

[test]> show databases;
+----------------------+
| Database             |
+----------------------+
| information_schema   |
| #mysql50#a@b         |
| mysql                |
| #mysql50#mysqltest-1 |
| performance_schema   |
| test                 |
+----------------------+
6 rows in set (0.00 sec)

// Extracted from 

2014-11-21 12:44:27 6982 [ERROR] Invalid (old?) table or database name 'a@b'
2014-11-21 12:44:33 6982 [ERROR] Invalid (old?) table or database name 'a@b'
2014-11-21 12:44:47 6982 [ERROR] Invalid (old?) table or database name 'a@b'
2014-11-21 12:44:47 6982 [ERROR] Invalid (old?) table or database name 'mysqltest-1'

Thanks,
Umesh

[20 Nov 2014 2:59] Roel Van de Paar

Agreed