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

spider3.3.11 hit a bug! mysqld crash

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.1
    • N/A
    • None
    • mariadb10.1.22 spider3.3.11

    Description

      HI, I have compiled installed spider3.3.11 into MariaDB10.1.22 , but encountered a BUG, mysqld crash

      for example:

      MariaDB [test]> select `k` from sbtest limit 10;    
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      

      ---------------------------------------------------------------------------
      error log:

      170504 13:30:26 [ERROR] mysqld got signal 8 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
       
      Query: select `k` from sbtest limit 10
       
      170504 13:30:27 mysqld_safe Number of processes running now: 0
      170504 13:30:27 mysqld_safe mysqld restarted
      

      MariaDB [test]> select * from sbtest limit 1;
      +----+---+---+----------------------------------------------------+
      | id | k | c | pad                                                |
      +----+---+---+----------------------------------------------------+
      |  1 | 0 |   | qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |
      +----+---+---+----------------------------------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> select id,k,c,pad from sbtest limit 1; 
      +----+---+---+----------------------------------------------------+
      | id | k | c | pad                                                |
      +----+---+---+----------------------------------------------------+
      |  1 | 0 |   | qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |
      +----+---+---+----------------------------------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> select id from sbtest limit 1;        
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      MariaDB [test]> select k from sbtest limit 1;  
      ERROR 2006 (HY000): MySQL server has gone away
      No connection. Trying to reconnect...
      Connection id:    3
      Current database: test
       
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      

      --------------------------------------------------------------------------------------------------------------

      CREATE TABLE `sbtest` (
        `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `k` int(10) unsigned NOT NULL DEFAULT '0',
        `c` char(120) NOT NULL DEFAULT '',
        `pad` char(60) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`),
        KEY `k` (`k`)
      ) ENGINE=SPIDER DEFAULT CHARSET=utf8 COMMENT='wrapper "mysql", table "sbtest",srv "backend1"'
      

      Attachments

        Activity

          People

            jacob-mathew Jacob Mathew (Inactive)
            hiller1 hiller1
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.