Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24562

FederatedX does not show real error

    XMLWordPrintable

    Details

      Description

      FederatedX (MariaDB) does not rise the underlying error in usable way:

      CREATE TABLE `test_fed` (
        `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `data` varchar(128) DEFAULT NULL,
        `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`)
      ) ENGINE="FEDERATED" DEFAULT CHARSET=latin1
      CONNECTION='mysql-57'
      ;
      

      ERROR 1434 (HY000): Can't create federated table. Foreign data src error:  database: 'test'  username: 'app'  hostname: '127.0.0.1'
       
      SQL> show warnings;
      +---------+------+-----------------------------------------------------------------------------------------------------------------+
      | Level   | Code | Message                                                                                                         |
      +---------+------+-----------------------------------------------------------------------------------------------------------------+
      | Error   | 1434 | Can't create federated table. Foreign data src error:  database: 'test'  username: 'app'  hostname: '127.0.0.1' |
      | Warning | 1030 | Got error 1 "Operation not permitted" from storage engine FEDERATED                                             |
      +---------+------+-----------------------------------------------------------------------------------------------------------------+
      

      The reason for the error was just that the table did not exist on the remote system. It took me some time to find that out.

      Either display a proper error message or write the error in the MariaDB error log.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            oli Oli Sennhauser
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: