Duplicate tables being created in Azure MySQL Database

Jazeem Ilyas 31 Reputation points
2021-03-19T06:59:11.883+00:00

Hi,

We are facing a strange issue using Azure MySQL databases. recently we noticed that tables with same name are being shown under databases in one of our Azure MySQL database instance. We have no idea how this is possible as we cannot create table with same name in MySQL.

As an example we have a table named as mst_transport_bus. when we execute show tables command 3 such table names are displayed in the list. any change made to one reflects in all the other mst_transport_bus table.

What could be the issue here?

Any assistance will be appreciated.

Thank you

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
759 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Bashar Hussein 6 Reputation points
    2021-04-06T00:41:15.54+00:00

    Hello @Nikita Makarov @Wenjian Feng @Jazeem Ilyas @ray @Bas Weitjens @Jose Cotto My name is Bashar Hussein and I am a program manager in the Azure Database for MySQL, this issue was caused by a bug which was mitigated with a hotfix, users needs to restart Azure Database for MySQL server for the hotfix to take affect.

    Users may restart the server using instructions here: https://learn.microsoft.com/en-us/azure/mysql/howto-restart-server-portal

    We apologize for any inconvenience occurred due to this bug. Please feel free to reach out to me if you have further concerns or questions about this bug.

    Regards
    Bashar Hussein
    Senior Program Manager | Azure Database for MySQL
    bashar.hussein@microsoft.com

    1 person found this answer helpful.
    0 comments No comments

  2. Wenjian Feng 41 Reputation points
    2021-03-25T04:27:18.54+00:00

    We also have the same issue.
    But with the different mysql client tools present different situations. Sequel pro can show duplicate table name, but Navicat Premium can't show duplicate table name.
    With mysql command line also show duplicate table name.

    0 comments No comments

  3. Nikita Makarov 1 Reputation point
    2021-03-31T17:58:39.403+00:00

    I have the same issue, with Azure MySQL

    SHOW VARIABLES LIKE "%version%";

    innodb_version            5.7.32 
    protocol_version          10 
    slave_type_conversions 
    tls_version               TLSv1,TLSv1.1,TLSv1.2 
    version                   5.7.32-log 
    version_comment           MySQL Community Server (GPL) 
    version_compile_machine   x86_64 
    version_compile_os        Win64 
    
    SELECT TABLE_NAME, TABLE_SCHEMA, count(TABLE_NAME) from information_schema.`TABLES` GROUP BY TABLE_NAME, TABLE_SCHEMA HAVING count(TABLE_NAME) >=2;
    

    Shows more than one tables with the same name within one schema

    That makes it unavailable to use the Doctrine library to migrate DB state because it uses SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
    See https://github.com/doctrine/dbal/blob/4.0.x/src/Platforms/MySQLPlatform.php#L274

    Please let me know how to fix duplicates in information_schema :)

    PS: The issue is not reproduced on MySQL 5.7.32 docker container


  4. Kiet Nhi Tran 1 Reputation point Microsoft Employee
    2021-07-13T06:17:51.923+00:00

    hi @Bashar Hussein ,

    One of partner is still facing this issue. Even their server restarted everyday. The hotfix you mentioned above seems to not taking effect. Duplicate tables still happens.
    When they query tables info in information_schema, there are 2 rows for same tables.
    Is there any hint for this issue? any other thing need to do to resolve the issue?

    Feel free reach out to me for further discussion.

    Thanks,
    Nhi

    0 comments No comments

  5. Bashar Hussein 6 Reputation points
    2021-07-13T18:12:36.117+00:00

    Hello @Kiet Nhi Tran please reach out to the team at AskAzureDBforMySQL@abdou .microsoft.com, Please also file a support ticket to log the information about the issue.

    0 comments No comments