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

[PS8QA] PS startup is failing if we have innodb_buffer_pool_size option in the persisted configuration file and in startup command.

Details

    • Bug
    • Status: On Hold
    • High
    • Resolution: Fixed
    • 8.0.12-2rc1
    • None
    • None

    Description

      PS startup is failing if we have innodb_buffer_pool_size option in the persisted configuration file and in startup command.

      Testcase

      Start server with my.cnf file
      /dev/shm/qa/ps80/bin/mysqld --defaults-file=my.cnf &
      
      my.cnf
      
      [mysqld]
      core-file
      basedir=/dev/shm/qa/ps80
      tmpdir=/dev/shm/qa/ps80/data
      datadir=/dev/shm/qa/ps80/data
      plugin-load-add=tokudb=ha_tokudb.so
      tokudb-check-jemalloc=0
      plugin-load-add=rocksdb=ha_rocksdb.so
      socket=/dev/shm/qa/ps80/socket.sock
      port=14306
      log-error=/dev/shm/qa/ps80/log/master.err
      server-id=100
      
      2) Change innodb_buffer_pool_size configuration variable with the SET PERSISTstatement.
      
      8.0.12>select @@innodb_buffer_pool_size;
      +---------------------------+
      | @@innodb_buffer_pool_size |
      +---------------------------+
      |                 134217728 |
      +---------------------------+
      1 row in set (0.00 sec)
      
      8.0.12>SET PERSIST innodb_buffer_pool_size = 512 * 1024 * 1024;
      Query OK, 0 rows affected (0.00 sec)
      
      8.0.12>select @@innodb_buffer_pool_size;
      +---------------------------+
      | @@innodb_buffer_pool_size |
      +---------------------------+
      |                 536870912 |
      +---------------------------+
      1 row in set (0.00 sec)
      
      8.0.12>
      
      This variable info will be saved in mysqld-auto.cnf file (inside datadir)
      
      3) restart server with innodb_buffer_pool_size in startup command.
      
      /dev/shm/qa/ps80/bin/mysqld --defaults-file=my.cnf --innodb_buffer_pool_size=1G &
      
      Startup is failing with following error.
      
      2018-11-21T03:56:53.628241Z 0 [System] [MY-010116] [Server] /dev/shm/qa/ps80/bin/mysqld (mysqld 8.0.12-2-debug) starting as process 9804
      2018-11-21T03:56:55.375075Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
      2018-11-21T03:56:55.375298Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/dev/shm' in the path is accessible to all OS users. Consider choosing a different directory.
      2018-11-21T03:56:55.462166Z 0 [System] [MY-010931] [Server] /dev/shm/qa/ps80/bin/mysqld: ready for connections. Version: '8.0.12-2-debug'  socket: '/dev/shm/qa/ps80/socket.sock'  port: 14306  MySQL Community Server (GPL).
      2018-11-21T03:57:51.710485Z 11 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.12-2-debug).
      2018-11-21T03:57:54.575421Z 0 [Warning] [MY-010909] [Server] /dev/shm/qa/ps80/bin/mysqld: Forcing close of thread 10  user: 'root'.
      2018-11-21T03:57:56.406896Z 0 [System] [MY-010910] [Server] /dev/shm/qa/ps80/bin/mysqld: Shutdown complete (mysqld 8.0.12-2-debug)  MySQL Community Server (GPL).
      2018-11-21T03:57:56.967318Z 0 [System] [MY-010116] [Server] /dev/shm/qa/ps80/bin/mysqld (mysqld 8.0.12-2-debug) starting as process 18250
      2018-11-21T03:57:58.503848Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
      2018-11-21T03:57:58.504065Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/dev/shm' in the path is accessible to all OS users. Consider choosing a different directory.
      2018-11-21T03:57:58.647506Z 5 [ERROR] [MY-011268] [Server] Configuring persisted options failed: "Variable 'innodb_buffer_pool_size' can't be set to the value of '536870912'".
      2018-11-21T03:57:58.647583Z 0 [ERROR] [MY-010175] [Server] Setting persistent options failed.
      

       

      This issue is not reproduced with upstream 8.0.13 version. The upstream build will ignore innodb_buffer_pool_size value from the command line and use the value from mysqld-auto.cnf file.

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ramesh.sivaraman Ramesh Sivaraman (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 minutes
                  3m

                  Smart Checklist