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

Spider crashes when running sysbench

    XMLWordPrintable

Details

    Description

      This is a copy of an email sent to me by hiller1231

      [root@vm-48 sysbench]# sysbench
      --test=/root/sysbench/sysbench/tests/db/oltp.lua
      --mysql-table-engine=innodb --oltp-table-size=10000 --max-requests=0
      --max-time=60 --num-threads=100 --oltp-tables-count=1
      --report-interval=10 --mysql-host=192.168.1.52 --mysql-port=3306
      --mysql-user=admin --mysql-password=123456  --mysql-db=backend run
      sysbench 0.5:  multi-threaded system evaluation benchmark
       
      Running the test with following options:
      Number of threads: 100
      Report intermediate results every 10 second(s)
      Random number generator seed is 0 and will be ignored
       
      Threads started!
       
      ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5016' failed: 12701 Remote MySQL server has gone away
      ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5004' failed: 12701 Remote MySQL server has gone away
      ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5412' failed: 12701 Remote MySQL server has gone away
      ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5004' failed: 12701 Remote MySQL server has gone away
      ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5002' failed: 12701 Remote MySQL server has gone away
      [root@vm-48 sysbench]#
      [root@vm-48 sysbench]# mysql -h192.168.1.52 -uadmin -p123456 -e
      "select count(*) from backend.sbtest1;"
      +----------+
      | count(*) |
      +----------+
      |    10000 |
      +----------+
       
      (root@localhost) [(none)]> select @@spider_version;
      +------------------+
      | @@spider_version |
      +------------------+
      | 3.2.19           |

      Attachments

        Activity

          People

            serg Sergei Golubchik
            monty Michael Widenius
            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.