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
- relates to
-
PS-5043 Merge MySQL 8.0.13
-
- Done
-