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

Spider table crashes the server after the mysql_list_fields() client's call and produces weird result for SHOW FIELDS.

Details

    Description

      As we did

      CREATE TABLE test.t (c INT) PARTITION BY LIST COLUMNS (c) (PARTITION p DEFAULT ENGINE=SPIDER);
      

      With the debug server started we do

      mysql test
      

      The server crashes in my_eof()
      :0(_GI__assert_fail)[0x7ffcb3d6f532]
      addr2line: 'sql/mysqld': No such file
      sql/mysqld(_ZN16Diagnostics_area14set_eof_statusEP3THD+0x9f)[0x7ffcb62d8fb3]
      sql/mysqld(_Z6my_eofP3THD+0x3d)[0x7ffcb6213478]
      sql/mysqld(_Z18mysqld_list_fieldsP3THDP10TABLE_LISTPKc+0x283)[0x7ffcb63c5dc6]
      sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1b72)[0x7ffcb631fe4a]
      sql/mysqld(_Z10do_commandP3THD+0x753)[0x7ffcb631dc32]
      sql/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1d2)[0x7ffcb649bd6f]

      It passes if we do

      mysql -A test
      

      But the result of SHOW FIELDS is weird.

      MariaDB [test]> show fields from test.t;
      ERROR 1429 (HY000): Unable to connect to foreign data source: localhost
      MariaDB [test]> show fields from test.t;
      +-------+---------+------+-----+---------+-------+
      | Field | Type    | Null | Key | Default | Extra |
      +-------+---------+------+-----+---------+-------+
      | c     | int(11) | YES  |     | NULL    |       |
      +-------+---------+------+-----+---------+-------+
      1 row in set (0.00 sec)
      
      

      Attachments

        Activity

          holyfoot Alexey Botchkov created issue -
          holyfoot Alexey Botchkov made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          holyfoot Alexey Botchkov added a comment - https://github.com/MariaDB/server/commit/bebd58a08dcd39cfad0f78d9fcbf391b3a4b7183
          holyfoot Alexey Botchkov made changes -
          Assignee Alexey Botchkov [ holyfoot ] Nayuta Yanagisawa [ JIRAUSER47117 ]
          Status In Progress [ 3 ] In Review [ 10002 ]

          holyfoot bebd58a is OK to push.

          nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - holyfoot bebd58a is OK to push.
          nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
          Assignee Nayuta Yanagisawa [ JIRAUSER47117 ] Alexey Botchkov [ holyfoot ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 125938 ] MariaDB v4 [ 143713 ]
          holyfoot Alexey Botchkov made changes -
          Fix Version/s 10.3.33 [ 26805 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          holyfoot Alexey Botchkov made changes -
          Fix Version/s 10.4.25 [ 27510 ]
          Fix Version/s 10.5.16 [ 27508 ]
          Fix Version/s 10.6.8 [ 27506 ]
          Fix Version/s 10.7.4 [ 27504 ]
          holyfoot Alexey Botchkov made changes -
          Fix Version/s 10.6.6 [ 26811 ]
          Fix Version/s 10.6.8 [ 27506 ]

          People

            holyfoot Alexey Botchkov
            holyfoot Alexey Botchkov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.