[MDEV-24595] Create database Created: 2021-01-14  Updated: 2021-02-15  Resolved: 2021-02-15

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4.13
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Roberto Leal Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

RDS in AWS



 Description   

I had to run twice a create database, something like this:

mysql> create database tmp_009;
Query OK, 1 row affected (0.08 sec)
 
mysql> show databases;
+-----------------------+
| Database              |
+-----------------------+
| cfdi                               |
| tmp_001                      |
| information_schema    |
| innodb                |
| mysql                 |
| performance_schema    |
+-----------------------+
6 rows in set (0.10 sec)
 
mysql> create database tmp_009;
Query OK, 1 row affected (0.09 sec)
 
mysql> show databases;
+-----------------------+
| Database              |
+-----------------------+
| cfdi                             |
| tmp_001                  |
| tmp_009                 |
| information_schema    |
| innodb                |
| mysql                 |
| performance_schema    |
+-----------------------+
7 rows in set (0.10 sec)

the first time didn´t create it, I can´t replicate the error, but I have to run the script twice.



 Comments   
Comment by Sergei Golubchik [ 2021-01-15 ]

could you please paste the output of

show databases;
select hex(schema_name) from information_schema.schemata;

?

Generated at Thu Feb 08 09:31:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.