Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-4206

Basic Sysbench run fails with basic MyROCKS install due to lack of open files

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.20-18
    • Component/s: MyRocks
    • Labels:

      Description

      I have installed MyRocks in  Percona Server 5.7  - have not done any tuning

      As I run sysbench in about 1.5 hours it crashes with  not enough file descriptors:

       

      2017-09-03T23:58:22.783244Z 330275 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/ndb_binlog_index.frm' (errno: 24 - Too many open files)
      2017-09-03T23:58:22.783295Z 330275 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/proc.frm' (errno: 24 - Too many open files)
      2017-09-03T23:58:22.783313Z 330275 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/procs_priv.frm' (errno: 24 - Too many open files)
      2017-09-03T23:58:22.783329Z 330275 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/proxies_priv.frm' (errno: 24 - Too many open files)
      2017-09-03T23:59:22.733264Z 330350 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/ndb_binlog_index.frm' (errno: 24 - Too many open files)
      2017-09-03T23:59:22.733313Z 330350 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/proc.frm' (errno: 24 - Too many open files)
      2017-09-03T23:59:22.733330Z 330350 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/procs_priv.frm' (errno: 24 - Too many open files)
      2017-09-03T23:59:22.733344Z 330350 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/proxies_priv.frm' (errno: 24 - Too many open files)
      2017-09-04T00:00:18.063482Z 0 [ERROR] Error in accept: Too many open files
      2017-09-04T00:00:48.073804Z 330440 [Note] Aborted connection 330440 to db: 'sbtest' user: 'sbtest' host: 'localhost' (Got an error reading communication packets
      )
      2017-09-04T00:00:48.073820Z 330439 [Note] Aborted connection 330439 to db: 'sbtest' user: 'sbtest' host: 'localhost' (Got an error reading communication packets
      )
      2017-09-04T00:00:48.073896Z 330442 [Note] Aborted connection 330442 to db: 'sbtest' user: 'sbtest' host: 'localhost' (Got an error reading communication packets

       

      sysbench -rate=100  rand-type=uniform --threads=4 --report-interval=1 --percentile=99 --events=0 --time=36000 --histogram=on  -db-ps-mode=auto --mysql-user=sbtest --mysql-password=sbtest  /usr/share/sysbench/oltp_read_write.lua --table_size=10000000 run

       

      .....

      [ 4372s ] thds: 4 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,99%): 0.00 err/s: 0.00 reconn/s: 0.00
      [ 4372s ] queue length: 14796, concurrency: 4
      FATAL: mysql_stmt_execute() returned error 2013 (Lost connection to MySQL server during query) for query 'COMMIT'
      (last message repeated 2 times)
      FATAL: `thread_run' function failed: /usr/share/sysbench/oltp_common.lua:403: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query
      (last message repeated 2 times)
      FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'BEGIN'
      FATAL: `thread_run' function failed: /usr/share/sysbench/oltp_common.lua:399: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query
      root@skullnuc:/var/lib/mysql-files# sysbench --rate=100 --rand-type=uniform --threads=4 --report-interval=1 --percentile=99 --events=0 --time=36000 --histogram=on --db-ps-mode=auto --mysql-user=sbtest --mysql-password=sbtest /usr/share/sysbench/oltp_read_write.lua --table_size=10000000 run

       

      Suggestion:  Upon standard installation we need to ensure MySQL is configured to allow enough file descriptors to allow RocksDB to operate without problems.

       

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                george.lorch George Lorch
                Reporter:
                pz Peter Zaitsev
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: