Skip to content

initialDelaySeconds not always high enough #184

@Fgruntjes

Description

@Fgruntjes

Hello,

We noticed when percona is very slow with initialisation (30+ seconds) then the container gets killed during initialisation resulting in a situation where the MYSQL_DATABASE, MYSQL_USER and MYSQL_PASSWORD setup is not finished and also on reboot will not finish any more.

Our initialize logs:

kd logs -f test-mysql-mysql-0 mysql
Initializing database
2018-12-18T15:50:08.083714Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
 100
 100
2018-12-18T15:50:19.116704Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-12-18T15:50:21.151180Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-12-18T15:50:21.818731Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a05f8644-02dc-11e9-b6c9-da420a8a8563.
2018-12-18T15:50:21.952705Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-12-18T15:50:22.511862Z 0 [Warning] CA certificate ca.pem is self signed.
2018-12-18T15:50:22.571768Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2018-12-18T15:50:59.047101Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-12-18T15:50:59.047146Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-12-18T15:50:59.047153Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-12-18T15:50:59.047173Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-12-18T15:50:59.047176Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-12-18T15:50:59.047184Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-12-18T15:50:59.047209Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-12-18T15:50:59.047214Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
Database initialized
MySQL init process in progress...
2018-12-18T15:51:18.699399Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-12-18T15:51:18.701982Z 0 [Note] mysqld (mysqld 5.7.23-24-log) starting as process 311 ...
2018-12-18T15:51:18.710431Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-12-18T15:51:18.710469Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-12-18T15:51:18.710476Z 0 [Note] InnoDB: Uses event mutexes
2018-12-18T15:51:18.710481Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-12-18T15:51:18.710486Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-12-18T15:51:18.710491Z 0 [Note] InnoDB: Using Linux native AIO
2018-12-18T15:51:18.711244Z 0 [Note] InnoDB: Number of pools: 1
2018-12-18T15:51:18.711439Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-12-18T15:51:18.742928Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2018-12-18T15:51:18.773014Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-12-18T15:51:18.786148Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-12-18T15:51:19.088391Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2018-12-18T15:51:19.141757Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
MySQL init process in progress...
2018-12-18T15:51:20.111764Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
MySQL init process in progress...

and then it was killed by the timeout.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions