2018-06-18T10:10:58.458227Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-06-18T10:10:58.458568Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-06-18T10:10:58.472094Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-06-18T10:10:59.058696Z 0 [Warning] InnoDB: New log files created, LSN=45790 2018-06-18T10:10:59.123385Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2018-06-18T10:10:59.179969Z 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: e5b3312d-72df-11e8-aa8f-00163edc1089. 2018-06-18T10:10:59.181999Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2018-06-18T10:10:59.466377Z 0 [Warning] CA certificate ca.pem is self signed. 2018-06-18T10:10:59.608641Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2018-06-18T10:11:00.430180Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2018-06-18T10:11:00.430221Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-06-18T10:11:00.430243Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-06-18T10:11:00.430284Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-06-18T10:11:00.430298Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-06-18T10:11:00.430322Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-06-18T10:11:00.430958Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-06-18T10:11:00.430981Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-06-18T10:11:02.540770Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-06-18T10:11:02.659798Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-06-18T10:11:02.659901Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-06-18T10:11:02.659927Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 92 ... 2018-06-18T10:11:02.672102Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-06-18T10:11:02.672151Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-06-18T10:11:02.672161Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-06-18T10:11:02.672167Z 0 [Note] InnoDB: Uses event mutexes 2018-06-18T10:11:02.672173Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-06-18T10:11:02.672179Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-06-18T10:11:02.672185Z 0 [Note] InnoDB: Using Linux native AIO 2018-06-18T10:11:02.672433Z 0 [Note] InnoDB: Number of pools: 1 2018-06-18T10:11:02.672580Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-06-18T10:11:02.688132Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-06-18T10:11:02.691027Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-06-18T10:11:02.695685Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-06-18T10:11:02.712934Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-06-18T10:11:02.716751Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-06-18T10:11:02.752734Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-06-18T10:11:02.839782Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-06-18T10:11:02.840589Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-06-18T10:11:02.884771Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-06-18T10:11:02.887166Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-06-18T10:11:02.887187Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-06-18T10:11:02.888741Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 2570643 2018-06-18T10:11:02.889522Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-06-18T10:11:02.889699Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-06-18T10:11:02.906325Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-06-18T10:11:02.906346Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-06-18T10:11:02.908801Z 0 [Warning] CA certificate ca.pem is self signed. 2018-06-18T10:11:02.908898Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-06-18T10:11:02.942207Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180618 10:11:02 2018-06-18T10:11:02.991818Z 0 [Note] Event Scheduler: Loaded 0 events 2018-06-18T10:11:02.992182Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-06-18T10:11:02.992226Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-06-18T10:11:02.992233Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-06-18T10:11:03.109455Z 0 [Note] End of list of non-natively partitioned tables 2018-06-18T10:11:03.556406Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-18T10:11:03.620134Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-18T10:22:16.170270Z 13 [Note] Aborted connection 13 to db: 'unconnected' user: 'root' host: 'localhost' (Unknown error) 2018-06-20T12:02:17.849875Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-06-20 12:02:17 0x7fca3d7de700 InnoDB: Assertion failure in thread 140506591782656 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 12:02:17 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=3 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7fca4972b890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7fca476b1067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fca476b2448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7fca49724064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fca4776462d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-06-20T12:11:44.277876Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-06-20T12:11:44.399839Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-06-20T12:11:44.399940Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-06-20T12:11:44.399965Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-06-20T12:11:44.443655Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-06-20T12:11:44.443702Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-06-20T12:11:44.443716Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-06-20T12:11:44.443723Z 0 [Note] InnoDB: Uses event mutexes 2018-06-20T12:11:44.443730Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-06-20T12:11:44.443737Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-06-20T12:11:44.443744Z 0 [Note] InnoDB: Using Linux native AIO 2018-06-20T12:11:44.444010Z 0 [Note] InnoDB: Number of pools: 1 2018-06-20T12:11:44.444175Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-06-20T12:11:44.456789Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-06-20T12:11:44.459544Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-06-20T12:11:44.463059Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-06-20T12:11:44.481016Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-06-20T12:11:44.491031Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-06-20T12:11:44.494860Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3953290 2018-06-20T12:11:44.494883Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3953299 2018-06-20T12:11:44.494893Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-06-20T12:11:44.494900Z 0 [Note] InnoDB: Starting crash recovery. 2018-06-20T12:11:44.688572Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-06-20T12:11:44.965477Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-06-20T12:11:44.965501Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-06-20T12:11:44.966496Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-06-20T12:11:45.005444Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-06-20T12:11:45.007339Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-06-20T12:11:45.007354Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-06-20T12:11:45.008505Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 3953299 2018-06-20T12:11:45.009368Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-06-20T12:11:45.009441Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-06-20T12:11:45.044122Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-06-20T12:11:45.044139Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-06-20T12:11:45.048972Z 0 [Warning] CA certificate ca.pem is self signed. 2018-06-20T12:11:45.049738Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-06-20T12:11:45.059916Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180620 12:11:45 2018-06-20T12:11:45.063832Z 0 [ERROR] /opt/mysql-5.7/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 2018-06-20T12:11:45.064794Z 0 [Warning] Checking table: './mysql/user' 2018-06-20T12:11:45.064817Z 0 [ERROR] 1 client is using or hasn't closed the table properly 2018-06-20T12:11:45.163374Z 0 [Note] Event Scheduler: Loaded 0 events 2018-06-20T12:11:45.163628Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-06-20T12:11:45.163644Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-06-20T12:11:45.163651Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-06-20T12:11:45.261789Z 0 [Note] End of list of non-natively partitioned tables 2018-06-20T12:11:45.294975Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-20T12:11:45.325435Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-26T09:35:44.306782Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-06-26 09:35:44 0x7fe8a4389700 InnoDB: Assertion failure in thread 140637164312320 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 09:35:44 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7fe8b02d6890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7fe8ae25c067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fe8ae25d448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7fe8b02cf064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fe8ae30f62d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-06-26T10:32:51.206267Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-06-26T10:32:51.319838Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-06-26T10:32:51.319928Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-06-26T10:32:51.319954Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-06-26T10:32:51.338736Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-06-26T10:32:51.338789Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-06-26T10:32:51.338805Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-06-26T10:32:51.338813Z 0 [Note] InnoDB: Uses event mutexes 2018-06-26T10:32:51.338822Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-06-26T10:32:51.338831Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-06-26T10:32:51.338839Z 0 [Note] InnoDB: Using Linux native AIO 2018-06-26T10:32:51.339117Z 0 [Note] InnoDB: Number of pools: 1 2018-06-26T10:32:51.339328Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-06-26T10:32:51.359170Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-06-26T10:32:51.363734Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-06-26T10:32:51.369879Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-06-26T10:32:51.458208Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-06-26T10:32:51.473592Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-06-26T10:32:51.479296Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 5270727 2018-06-26T10:32:51.479315Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 5270736 2018-06-26T10:32:51.479327Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-06-26T10:32:51.479336Z 0 [Note] InnoDB: Starting crash recovery. 2018-06-26T10:32:51.748486Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-06-26T10:32:52.626143Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-06-26T10:32:52.626167Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-06-26T10:32:52.627921Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-06-26T10:32:52.703362Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-06-26T10:32:52.705758Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-06-26T10:32:52.705792Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-06-26T10:32:52.708683Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 5270736 2018-06-26T10:32:52.709216Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-06-26T10:32:52.711016Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-06-26T10:32:52.746813Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180626 10:32:52 2018-06-26T10:32:52.756476Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-06-26T10:32:52.756491Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-06-26T10:32:52.763487Z 0 [Warning] CA certificate ca.pem is self signed. 2018-06-26T10:32:52.763946Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-06-26T10:32:53.087415Z 0 [Note] Event Scheduler: Loaded 0 events 2018-06-26T10:32:53.088120Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-06-26T10:32:53.088143Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-06-26T10:32:53.088150Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-06-26T10:32:53.426391Z 0 [Note] End of list of non-natively partitioned tables 2018-06-26T10:32:53.428635Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-26T10:32:53.458026Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-26T13:01:02.790108Z 10 [Warning] InnoDB: Retry attempts for reading partial data failed. 2018-06-26T13:01:02.790180Z 10 [ERROR] InnoDB: Tried to read 16384 bytes at offset 98304, but was only able to read 0 2018-06-26T13:01:02.790197Z 10 [ERROR] InnoDB: Operating system error number 5 in a file operation. 2018-06-26T13:01:02.790214Z 10 [ERROR] InnoDB: Error number 5 means 'Input/output error' 2018-06-26T13:01:02.790224Z 10 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html 2018-06-26T13:01:02.790233Z 10 [ERROR] InnoDB: File (unknown): 'read' returned OS error 105. Cannot continue operation 2018-06-26T13:01:02.790240Z 10 [ERROR] InnoDB: Cannot continue operation. 2018-06-26T13:01:02.792747Z 0 [Warning] InnoDB: Retry attempts for reading partial data failed. 2018-06-26T13:01:02.792771Z 0 [ERROR] InnoDB: Tried to read 16384 bytes at offset 5259264, but was only able to read 0 2018-06-26T13:01:02.792779Z 0 [ERROR] InnoDB: Operating system error number 5 in a file operation. 2018-06-26T13:01:02.792788Z 0 [ERROR] InnoDB: Error number 5 means 'Input/output error' 2018-06-26T13:01:02.792795Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html 2018-06-26T13:01:02.792803Z 0 [ERROR] InnoDB: File (unknown): 'read' returned OS error 105. Cannot continue operation 2018-06-26T13:01:02.792809Z 0 [ERROR] InnoDB: Cannot continue operation. 2018-06-26T13:01:02.858509Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-06-26T13:02:42.896519Z 0 [Warning] InnoDB: 7 threads created by InnoDB had not exited at shutdown! 2018-06-26T13:02:42.896519Z 10 [Warning] InnoDB: 7 threads created by InnoDB had not exited at shutdown! 13:02:42 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ *** Error in `/opt/mysql-5.7/sbin/mysqld': free(): corrupted unsorted chunks: 0x0000000003916560 *** key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=33 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f367c0008c0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Fatal signal 6 while backtracing 2018-06-26T13:33:06.865348Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-06-26T13:33:06.979879Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-06-26T13:33:06.979973Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-06-26T13:33:06.979997Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-06-26T13:33:06.988823Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-06-26T13:33:06.988871Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-06-26T13:33:06.988885Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-06-26T13:33:06.988893Z 0 [Note] InnoDB: Uses event mutexes 2018-06-26T13:33:06.988900Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-06-26T13:33:06.988908Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-06-26T13:33:06.988916Z 0 [Note] InnoDB: Using Linux native AIO 2018-06-26T13:33:06.989171Z 0 [Note] InnoDB: Number of pools: 1 2018-06-26T13:33:06.989330Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-06-26T13:33:06.999941Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-06-26T13:33:07.002639Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-06-26T13:33:07.005881Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-06-26T13:33:07.029877Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-06-26T13:33:07.040895Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-06-26T13:33:07.045463Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 5915757 2018-06-26T13:33:07.045482Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 5915766 2018-06-26T13:33:07.045495Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-06-26T13:33:07.045507Z 0 [Note] InnoDB: Starting crash recovery. 2018-06-26T13:33:07.256057Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-06-26T13:33:07.453415Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-06-26T13:33:07.453446Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-06-26T13:33:07.454678Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-06-26T13:33:07.497151Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-06-26T13:33:07.498928Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-06-26T13:33:07.498943Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-06-26T13:33:07.500538Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 5915766 2018-06-26T13:33:07.500996Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-06-26T13:33:07.501080Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-06-26T13:33:07.507201Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180626 13:33:07 2018-06-26T13:33:07.518275Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-06-26T13:33:07.518289Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-06-26T13:33:07.524138Z 0 [Warning] CA certificate ca.pem is self signed. 2018-06-26T13:33:07.524736Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-06-26T13:33:07.684478Z 0 [Note] Event Scheduler: Loaded 0 events 2018-06-26T13:33:07.684697Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-06-26T13:33:07.684715Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-06-26T13:33:07.684722Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-06-26T13:33:07.816271Z 0 [Note] End of list of non-natively partitioned tables 2018-06-26T13:33:07.876828Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-26T13:33:07.906420Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-29T03:11:22.101332Z 0 [Warning] InnoDB: Retry attempts for reading partial data failed. 2018-06-29T03:11:22.101416Z 0 [ERROR] InnoDB: Tried to read 16384 bytes at offset 3981312, but was only able to read 0 2018-06-29T03:11:22.101430Z 0 [ERROR] InnoDB: Operating system error number 5 in a file operation. 2018-06-29T03:11:22.101449Z 0 [ERROR] InnoDB: Error number 5 means 'Input/output error' 2018-06-29T03:11:22.101468Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html 2018-06-29T03:11:22.101478Z 0 [ERROR] InnoDB: File (unknown): 'read' returned OS error 105. Cannot continue operation 2018-06-29T03:11:22.101486Z 0 [ERROR] InnoDB: Cannot continue operation. 2018-06-29T03:11:26.554602Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-06-29T03:13:02.211425Z 0 [Warning] InnoDB: 7 threads created by InnoDB had not exited at shutdown! 2018-06-29T03:33:21.038084Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-06-29T03:33:21.159673Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-06-29T03:33:21.159756Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-06-29T03:33:21.159789Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-06-29T03:33:21.172985Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-06-29T03:33:21.173029Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-06-29T03:33:21.173043Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-06-29T03:33:21.173050Z 0 [Note] InnoDB: Uses event mutexes 2018-06-29T03:33:21.173058Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-06-29T03:33:21.173064Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-06-29T03:33:21.173071Z 0 [Note] InnoDB: Using Linux native AIO 2018-06-29T03:33:21.173355Z 0 [Note] InnoDB: Number of pools: 1 2018-06-29T03:33:21.173502Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-06-29T03:33:21.191450Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-06-29T03:33:21.194535Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-06-29T03:33:21.198376Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-06-29T03:33:21.216151Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-06-29T03:33:21.226720Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-06-29T03:33:21.230527Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 6674741 2018-06-29T03:33:21.230559Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 6674750 2018-06-29T03:33:21.230569Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-06-29T03:33:21.230576Z 0 [Note] InnoDB: Starting crash recovery. 2018-06-29T03:33:21.433381Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-06-29T03:33:21.638053Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-06-29T03:33:21.638106Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-06-29T03:33:21.639344Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-06-29T03:33:21.682020Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-06-29T03:33:21.684039Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-06-29T03:33:21.684054Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-06-29T03:33:21.685434Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 6674750 2018-06-29T03:33:21.685933Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-06-29T03:33:21.686113Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-06-29T03:33:21.692384Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180629 3:33:21 2018-06-29T03:33:21.701484Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-06-29T03:33:21.701500Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-06-29T03:33:21.704354Z 0 [Warning] CA certificate ca.pem is self signed. 2018-06-29T03:33:21.704662Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-06-29T03:33:21.817748Z 0 [Note] Event Scheduler: Loaded 0 events 2018-06-29T03:33:21.818119Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-06-29T03:33:21.818150Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-06-29T03:33:21.818157Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-06-29T03:33:21.932065Z 0 [Note] End of list of non-natively partitioned tables 2018-06-29T03:33:22.053123Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-06-29T03:33:22.086364Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-02T06:31:27.095762Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-07-02 06:31:27 0x7f3f5b2ea700 InnoDB: Assertion failure in thread 139910089451264 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 06:31:27 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f3f67237890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f3f651bd067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f3f651be448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7f3f67230064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f3f6527062d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-07-02T06:33:34.814993Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-07-02T06:33:34.927829Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-07-02T06:33:34.927919Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-07-02T06:33:34.927952Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-07-02T06:33:34.937972Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-07-02T06:33:34.938009Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-07-02T06:33:34.938021Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-02T06:33:34.938028Z 0 [Note] InnoDB: Uses event mutexes 2018-07-02T06:33:34.938035Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-07-02T06:33:34.938041Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-07-02T06:33:34.938048Z 0 [Note] InnoDB: Using Linux native AIO 2018-07-02T06:33:34.938275Z 0 [Note] InnoDB: Number of pools: 1 2018-07-02T06:33:34.938451Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-07-02T06:33:34.949714Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-07-02T06:33:34.952772Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-07-02T06:33:34.956543Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-07-02T06:33:34.975423Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-07-02T06:33:34.985845Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-02T06:33:34.989767Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 7568541 2018-07-02T06:33:34.989792Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 7568550 2018-07-02T06:33:34.989802Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-07-02T06:33:34.989810Z 0 [Note] InnoDB: Starting crash recovery. 2018-07-02T06:33:35.195322Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-07-02T06:33:35.398829Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-07-02T06:33:35.398858Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-07-02T06:33:35.399949Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-07-02T06:33:35.440861Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-07-02T06:33:35.442849Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-07-02T06:33:35.442871Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-07-02T06:33:35.444338Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 7568550 2018-07-02T06:33:35.445075Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-07-02T06:33:35.445297Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-07-02T06:33:35.452151Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180702 6:33:35 2018-07-02T06:33:35.459120Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-07-02T06:33:35.459133Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-07-02T06:33:35.461952Z 0 [Warning] CA certificate ca.pem is self signed. 2018-07-02T06:33:35.462227Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-07-02T06:33:35.569997Z 0 [Note] Event Scheduler: Loaded 0 events 2018-07-02T06:33:35.570181Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-07-02T06:33:35.570197Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-07-02T06:33:35.570203Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-07-02T06:33:35.702203Z 0 [Note] End of list of non-natively partitioned tables 2018-07-02T06:33:35.829917Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-02T06:33:35.860321Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-06T06:26:46.129510Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ghn_www_la_magicieuse_org/ghn_options.ibd. 2018-07-06 06:26:46 0x7fe805b39700 InnoDB: Assertion failure in thread 140634504795904 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 06:26:46 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7fe811a86890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7fe80fa0c067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fe80fa0d448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7fe811a7f064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fe80fabf62d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-07-06T06:33:50.905815Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-07-06T06:33:51.019798Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-07-06T06:33:51.019907Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-07-06T06:33:51.019931Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-07-06T06:33:51.031745Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-07-06T06:33:51.031788Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-07-06T06:33:51.031805Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-06T06:33:51.031826Z 0 [Note] InnoDB: Uses event mutexes 2018-07-06T06:33:51.031834Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-07-06T06:33:51.031841Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-07-06T06:33:51.031849Z 0 [Note] InnoDB: Using Linux native AIO 2018-07-06T06:33:51.032116Z 0 [Note] InnoDB: Number of pools: 1 2018-07-06T06:33:51.032298Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-07-06T06:33:51.045243Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-07-06T06:33:51.048195Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-07-06T06:33:51.051791Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-07-06T06:33:51.071109Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-07-06T06:33:51.082563Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-06T06:33:51.086625Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 10249509 2018-07-06T06:33:51.086641Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 10249518 2018-07-06T06:33:51.086650Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-07-06T06:33:51.086658Z 0 [Note] InnoDB: Starting crash recovery. 2018-07-06T06:33:51.288202Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-07-06T06:33:51.536046Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-07-06T06:33:51.536102Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-07-06T06:33:51.537250Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-07-06T06:33:51.577194Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-07-06T06:33:51.578930Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-07-06T06:33:51.578946Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-07-06T06:33:51.580346Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 10249518 2018-07-06T06:33:51.581520Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-07-06T06:33:51.581816Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-07-06T06:33:51.594645Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-07-06T06:33:51.594658Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-07-06T06:33:51.603373Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180706 6:33:51 2018-07-06T06:33:51.613361Z 0 [Warning] CA certificate ca.pem is self signed. 2018-07-06T06:33:51.613661Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-07-06T06:33:51.751539Z 0 [Note] Event Scheduler: Loaded 0 events 2018-07-06T06:33:51.751741Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-07-06T06:33:51.751759Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-07-06T06:33:51.751766Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-07-06T06:33:52.058431Z 0 [Note] End of list of non-natively partitioned tables 2018-07-06T06:33:52.060700Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-06T06:33:52.093916Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-12T06:28:31.858510Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-07-12 06:28:31 0x7f5a9460b700 InnoDB: Assertion failure in thread 140027013150464 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 06:28:31 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=4 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f5aa0558890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f5a9e4de067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f5a9e4df448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7f5aa0551064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f5a9e59162d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-07-12T06:34:06.048490Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-07-12T06:34:06.167828Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-07-12T06:34:06.167932Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-07-12T06:34:06.167956Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-07-12T06:34:06.180433Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-07-12T06:34:06.180471Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-07-12T06:34:06.180496Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-12T06:34:06.180504Z 0 [Note] InnoDB: Uses event mutexes 2018-07-12T06:34:06.180512Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-07-12T06:34:06.180520Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-07-12T06:34:06.180528Z 0 [Note] InnoDB: Using Linux native AIO 2018-07-12T06:34:06.180804Z 0 [Note] InnoDB: Number of pools: 1 2018-07-12T06:34:06.180987Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-07-12T06:34:06.194484Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-07-12T06:34:06.198114Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-07-12T06:34:06.202276Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-07-12T06:34:06.221611Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-07-12T06:34:06.232333Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-12T06:34:06.236912Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 12386943 2018-07-12T06:34:06.236932Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 12386952 2018-07-12T06:34:06.236942Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-07-12T06:34:06.236950Z 0 [Note] InnoDB: Starting crash recovery. 2018-07-12T06:34:06.449301Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-07-12T06:34:06.669998Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-07-12T06:34:06.670035Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-07-12T06:34:06.671208Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-07-12T06:34:06.716192Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-07-12T06:34:06.718417Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-07-12T06:34:06.718440Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-07-12T06:34:06.719653Z 0 [Note] InnoDB: Waiting for purge to start 2018-07-12T06:34:06.770223Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 12386952 2018-07-12T06:34:06.770973Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-07-12T06:34:06.771194Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-07-12T06:34:06.778401Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180712 6:34:06 2018-07-12T06:34:06.785830Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-07-12T06:34:06.785843Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-07-12T06:34:06.789252Z 0 [Warning] CA certificate ca.pem is self signed. 2018-07-12T06:34:06.789640Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-07-12T06:34:06.920801Z 0 [Note] Event Scheduler: Loaded 0 events 2018-07-12T06:34:06.921134Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-07-12T06:34:06.921158Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-07-12T06:34:06.921173Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-07-12T06:34:07.040597Z 0 [Note] End of list of non-natively partitioned tables 2018-07-12T06:34:07.045631Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-12T06:34:07.073808Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-20T10:36:49.095765Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-07-20 10:36:49 0x7f3798c94700 InnoDB: Assertion failure in thread 139876763256576 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 10:36:49 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f37a4be1890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f37a2b67067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f37a2b68448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7f37a4bda064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f37a2c1a62d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-07-20T11:34:22.101408Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-07-20T11:34:22.219900Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-07-20T11:34:22.220010Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-07-20T11:34:22.220048Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-07-20T11:34:22.231126Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-07-20T11:34:22.231161Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-07-20T11:34:22.231185Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-20T11:34:22.231193Z 0 [Note] InnoDB: Uses event mutexes 2018-07-20T11:34:22.231213Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-07-20T11:34:22.231220Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-07-20T11:34:22.231227Z 0 [Note] InnoDB: Using Linux native AIO 2018-07-20T11:34:22.231689Z 0 [Note] InnoDB: Number of pools: 1 2018-07-20T11:34:22.231870Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-07-20T11:34:22.244227Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-07-20T11:34:22.247393Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-07-20T11:34:22.251118Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-07-20T11:34:22.271090Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-07-20T11:34:22.282325Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-20T11:34:22.287048Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 14828146 2018-07-20T11:34:22.287064Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 14828155 2018-07-20T11:34:22.287075Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-07-20T11:34:22.287081Z 0 [Note] InnoDB: Starting crash recovery. 2018-07-20T11:34:22.478512Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-07-20T11:34:22.738883Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-07-20T11:34:22.738923Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-07-20T11:34:22.740158Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-07-20T11:34:22.782694Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-07-20T11:34:22.784478Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-07-20T11:34:22.784492Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-07-20T11:34:22.785124Z 0 [Note] InnoDB: Waiting for purge to start 2018-07-20T11:34:22.835724Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 14828155 2018-07-20T11:34:22.836707Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-07-20T11:34:22.836873Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-07-20T11:34:22.853639Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-07-20T11:34:22.853666Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-07-20T11:34:22.857414Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180720 11:34:22 2018-07-20T11:34:22.882888Z 0 [Warning] CA certificate ca.pem is self signed. 2018-07-20T11:34:22.883331Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-07-20T11:34:23.052405Z 0 [Note] Event Scheduler: Loaded 0 events 2018-07-20T11:34:23.052681Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-07-20T11:34:23.052697Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-07-20T11:34:23.052703Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-07-20T11:34:23.361599Z 0 [Note] End of list of non-natively partitioned tables 2018-07-20T11:34:23.364041Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-20T11:34:23.396423Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-23T07:40:36.320100Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-07-23 07:40:36 0x7f518fba4700 InnoDB: Assertion failure in thread 139988280428288 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 07:40:36 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f519baf1890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f5199a77067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f5199a78448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7f519baea064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f5199b2a62d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-07-23T08:34:37.825811Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-07-23T08:34:37.939728Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-07-23T08:34:37.939796Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-07-23T08:34:37.939822Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-07-23T08:34:37.950767Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-07-23T08:34:37.950804Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-07-23T08:34:37.950816Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-23T08:34:37.950822Z 0 [Note] InnoDB: Uses event mutexes 2018-07-23T08:34:37.950828Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-07-23T08:34:37.950835Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-07-23T08:34:37.950841Z 0 [Note] InnoDB: Using Linux native AIO 2018-07-23T08:34:37.951076Z 0 [Note] InnoDB: Number of pools: 1 2018-07-23T08:34:37.951274Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-07-23T08:34:37.963270Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-07-23T08:34:37.966208Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-07-23T08:34:37.970746Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-07-23T08:34:37.991013Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-07-23T08:34:38.001684Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-23T08:34:38.005659Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 16149030 2018-07-23T08:34:38.005682Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 16149039 2018-07-23T08:34:38.005692Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-07-23T08:34:38.005701Z 0 [Note] InnoDB: Starting crash recovery. 2018-07-23T08:34:38.201644Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-07-23T08:34:38.403194Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-07-23T08:34:38.403270Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-07-23T08:34:38.404251Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-07-23T08:34:38.443810Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-07-23T08:34:38.445970Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-07-23T08:34:38.445988Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-07-23T08:34:38.446599Z 0 [Note] InnoDB: Waiting for purge to start 2018-07-23T08:34:38.497113Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 16149039 2018-07-23T08:34:38.498207Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-07-23T08:34:38.498270Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-07-23T08:34:38.502382Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180723 8:34:38 2018-07-23T08:34:38.509658Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-07-23T08:34:38.509671Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-07-23T08:34:38.512503Z 0 [Warning] CA certificate ca.pem is self signed. 2018-07-23T08:34:38.512814Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-07-23T08:34:38.618566Z 0 [Note] Event Scheduler: Loaded 0 events 2018-07-23T08:34:38.618732Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-07-23T08:34:38.618748Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-07-23T08:34:38.618754Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-07-23T08:34:38.728415Z 0 [Note] End of list of non-natively partitioned tables 2018-07-23T08:34:38.839552Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-23T08:34:38.865808Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-25T10:28:02.997733Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-07-25 10:28:02 0x7f97bc5b2700 InnoDB: Assertion failure in thread 140289676879616 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 10:28:02 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f97c84ff890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f97c6485067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f97c6486448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7f97c84f8064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f97c653862d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-07-25T10:34:51.192432Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-07-25T10:34:51.307957Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-07-25T10:34:51.308035Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-07-25T10:34:51.308073Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-07-25T10:34:51.317957Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-07-25T10:34:51.318004Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-07-25T10:34:51.318018Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-25T10:34:51.318024Z 0 [Note] InnoDB: Uses event mutexes 2018-07-25T10:34:51.318031Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-07-25T10:34:51.318037Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-07-25T10:34:51.318044Z 0 [Note] InnoDB: Using Linux native AIO 2018-07-25T10:34:51.318304Z 0 [Note] InnoDB: Number of pools: 1 2018-07-25T10:34:51.318453Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-07-25T10:34:51.330707Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-07-25T10:34:51.333781Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-07-25T10:34:51.337653Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-07-25T10:34:51.357027Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-07-25T10:34:51.367444Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-25T10:34:51.371490Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 17292997 2018-07-25T10:34:51.371514Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 17293006 2018-07-25T10:34:51.371540Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-07-25T10:34:51.371553Z 0 [Note] InnoDB: Starting crash recovery. 2018-07-25T10:34:51.569460Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-07-25T10:34:51.772589Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-07-25T10:34:51.772615Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-07-25T10:34:51.773611Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-07-25T10:34:51.814913Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-07-25T10:34:51.816843Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-07-25T10:34:51.816871Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-07-25T10:34:51.818540Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 17293006 2018-07-25T10:34:51.819435Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-07-25T10:34:51.819597Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-07-25T10:34:51.824881Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180725 10:34:51 2018-07-25T10:34:51.835202Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-07-25T10:34:51.835266Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-07-25T10:34:51.838565Z 0 [Warning] CA certificate ca.pem is self signed. 2018-07-25T10:34:51.838805Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-07-25T10:34:51.941561Z 0 [Note] Event Scheduler: Loaded 0 events 2018-07-25T10:34:51.941803Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-07-25T10:34:51.941829Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-07-25T10:34:51.941844Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-07-25T10:34:52.041850Z 0 [Note] End of list of non-natively partitioned tables 2018-07-25T10:34:52.208137Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-07-25T10:34:52.237455Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-08-06T21:44:11.836122Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-08-06 21:44:11 0x7fa05cf29700 InnoDB: Assertion failure in thread 140326730897152 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 21:44:11 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=3 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7fa068e76890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7fa066dfc067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fa066dfd448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7fa068e6f064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fa066eaf62d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-08-06T21:48:06.856934Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-06T21:48:06.979911Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-06T21:48:06.980035Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-08-06T21:48:06.980074Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-08-06T21:48:07.009713Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-08-06T21:48:07.009759Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-06T21:48:07.009774Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-06T21:48:07.009781Z 0 [Note] InnoDB: Uses event mutexes 2018-08-06T21:48:07.009789Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-06T21:48:07.009796Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-06T21:48:07.009803Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-06T21:48:07.010114Z 0 [Note] InnoDB: Number of pools: 1 2018-08-06T21:48:07.010277Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-06T21:48:07.023803Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-08-06T21:48:07.027130Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-06T21:48:07.031390Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-06T21:48:07.119313Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-08-06T21:48:07.145351Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-06T21:48:07.150470Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 20881197 2018-08-06T21:48:07.150499Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20881206 2018-08-06T21:48:07.150509Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-08-06T21:48:07.150518Z 0 [Note] InnoDB: Starting crash recovery. 2018-08-06T21:48:07.377213Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-08-06T21:48:07.887631Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-06T21:48:07.887666Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-06T21:48:07.888711Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-06T21:48:08.012186Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-06T21:48:08.014149Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-06T21:48:08.014166Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-06T21:48:08.022270Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 20881206 2018-08-06T21:48:08.022771Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-06T21:48:08.024859Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-08-06T21:48:08.062215Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180806 21:48:08 2018-08-06T21:48:08.075755Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-08-06T21:48:08.075771Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-08-06T21:48:08.084819Z 0 [Warning] CA certificate ca.pem is self signed. 2018-08-06T21:48:08.085700Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-08-06T21:48:08.404537Z 0 [Note] Event Scheduler: Loaded 0 events 2018-08-06T21:48:08.405326Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-08-06T21:48:08.405354Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-08-06T21:48:08.405365Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-08-06T21:48:08.614695Z 0 [Note] End of list of non-natively partitioned tables 2018-08-06T21:48:08.899140Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-08-06T21:48:08.929660Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-08-07T21:34:44.115619Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-08-07 21:34:44 0x7f24a1f06700 InnoDB: Assertion failure in thread 139795312436992 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 21:34:44 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f24ade53890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f24abdd9067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f24abdda448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7f24ade4c064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f24abe8c62d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-08-07T21:48:32.022482Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-07T21:48:32.139947Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-07T21:48:32.140052Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-08-07T21:48:32.140080Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-08-07T21:48:32.153074Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-08-07T21:48:32.153116Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-07T21:48:32.153128Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-07T21:48:32.153136Z 0 [Note] InnoDB: Uses event mutexes 2018-08-07T21:48:32.153143Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-07T21:48:32.153150Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-07T21:48:32.153157Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-07T21:48:32.153492Z 0 [Note] InnoDB: Number of pools: 1 2018-08-07T21:48:32.153656Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-07T21:48:32.169222Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-08-07T21:48:32.172216Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-07T21:48:32.176938Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-07T21:48:32.201650Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-08-07T21:48:32.224279Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-07T21:48:32.228231Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 21531898 2018-08-07T21:48:32.228259Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 21531907 2018-08-07T21:48:32.228270Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-08-07T21:48:32.228279Z 0 [Note] InnoDB: Starting crash recovery. 2018-08-07T21:48:32.454236Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-08-07T21:48:32.728538Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-07T21:48:32.728562Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-07T21:48:32.729525Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-07T21:48:32.809170Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-07T21:48:32.811677Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-07T21:48:32.811695Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-07T21:48:32.812657Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-07T21:48:32.863099Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 21531907 2018-08-07T21:48:32.863936Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-08-07T21:48:32.864033Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-07T21:48:32.870764Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180807 21:48:32 2018-08-07T21:48:32.878626Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-08-07T21:48:32.878643Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-08-07T21:48:32.882605Z 0 [Warning] CA certificate ca.pem is self signed. 2018-08-07T21:48:32.882844Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-08-07T21:48:33.047303Z 0 [Note] Event Scheduler: Loaded 0 events 2018-08-07T21:48:33.047485Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-08-07T21:48:33.047515Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-08-07T21:48:33.047528Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-08-07T21:48:33.279790Z 0 [Note] End of list of non-natively partitioned tables 2018-08-07T21:48:33.281889Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-08-07T21:48:33.312971Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-08-10T06:52:28.108895Z 0 [ERROR] [FATAL] InnoDB: Native Linux AIO interface. io_submit() call failed when resubmitting a partial I/O request on the file ./ibtmp1. 2018-08-10 06:52:28 0x7f8a19384700 InnoDB: Assertion failure in thread 140231105332992 in file ut0ut.cc line 917 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 06:52:28 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=3 max_threads=33 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 57810 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /opt/mysql-5.7/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8c61b] /opt/mysql-5.7/sbin/mysqld(handle_fatal_signal+0x479)[0x7908a9] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f8a252d1890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f8a23257067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f8a23258448] /opt/mysql-5.7/sbin/mysqld[0x76445f] /opt/mysql-5.7/sbin/mysqld(_ZN2ib5fatalD1Ev+0x15d)[0x105ddad] /opt/mysql-5.7/sbin/mysqld(_ZN15LinuxAIOHandler4pollEPP10fil_node_tPPvP9IORequest+0x239)[0xf46929] /opt/mysql-5.7/sbin/mysqld(_Z14os_aio_handlermPP10fil_node_tPPvP9IORequest+0x63b)[0xf49e4b] /opt/mysql-5.7/sbin/mysqld(_Z12fil_aio_waitm+0x40)[0x1115400] /opt/mysql-5.7/sbin/mysqld(io_handler_thread+0x108)[0x1000428] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7f8a252ca064] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f8a2330a62d] You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2018-08-10T07:48:46.910414Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-10T07:48:47.027920Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-10T07:48:47.028041Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-08-10T07:48:47.028080Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.20-18-log) starting as process 59 ... 2018-08-10T07:48:47.041809Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-08-10T07:48:47.041864Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-10T07:48:47.041875Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-10T07:48:47.041883Z 0 [Note] InnoDB: Uses event mutexes 2018-08-10T07:48:47.041890Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-10T07:48:47.041896Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-10T07:48:47.041903Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-10T07:48:47.042188Z 0 [Note] InnoDB: Number of pools: 1 2018-08-10T07:48:47.042365Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-10T07:48:47.055961Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-08-10T07:48:47.058894Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-10T07:48:47.062866Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-10T07:48:47.082436Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-08-10T07:48:47.094211Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-10T07:48:47.098459Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 22408210 2018-08-10T07:48:47.098477Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 22408219 2018-08-10T07:48:47.098487Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-08-10T07:48:47.098495Z 0 [Note] InnoDB: Starting crash recovery. 2018-08-10T07:48:47.300846Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-08-10T07:48:47.506848Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-10T07:48:47.506883Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-10T07:48:47.507973Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-10T07:48:47.553122Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-10T07:48:47.555479Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-10T07:48:47.555496Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-10T07:48:47.556762Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.20-18 started; log sequence number 22408219 2018-08-10T07:48:47.557423Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-08-10T07:48:47.557647Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-10T07:48:47.564556Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180810 7:48:47 2018-08-10T07:48:47.575325Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-08-10T07:48:47.575340Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-08-10T07:48:47.577919Z 0 [Warning] CA certificate ca.pem is self signed. 2018-08-10T07:48:47.578167Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-08-10T07:48:47.680061Z 0 [Note] Event Scheduler: Loaded 0 events 2018-08-10T07:48:47.680297Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.20-18-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-08-10T07:48:47.680314Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-08-10T07:48:47.680321Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-08-10T07:48:47.774401Z 0 [Note] End of list of non-natively partitioned tables 2018-08-10T07:48:47.925212Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-08-10T07:48:47.955276Z 4 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-12-20T01:21:56.855005Z 0 [Note] Giving 0 client threads a chance to die gracefully 2018-12-20T01:21:56.855046Z 0 [Note] Shutting down slave threads 2018-12-20T01:21:56.855054Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-12-20T01:21:56.855063Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-12-20T01:21:56.855131Z 0 [Note] Binlog end 2018-12-20T01:21:56.856336Z 0 [Note] Shutting down plugin 'ngram' 2018-12-20T01:21:56.856350Z 0 [Note] Shutting down plugin 'partition' 2018-12-20T01:21:56.856356Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-12-20T01:21:56.856361Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-12-20T01:21:56.856367Z 0 [Note] Shutting down plugin 'CSV' 2018-12-20T01:21:56.856374Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-12-20T01:21:56.856416Z 0 [Note] Shutting down plugin 'MEMORY' 2018-12-20T01:21:56.856423Z 0 [Note] Shutting down plugin 'MyISAM' 2018-12-20T01:21:56.856444Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-12-20T01:21:56.856450Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-12-20T01:21:56.856457Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2018-12-20T01:21:56.856461Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-12-20T01:21:56.856466Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-12-20T01:21:56.856471Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-12-20T01:21:56.856476Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-12-20T01:21:56.856480Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-12-20T01:21:56.856485Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-12-20T01:21:56.856489Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-12-20T01:21:56.856495Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-12-20T01:21:56.856500Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-12-20T01:21:56.856504Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-12-20T01:21:56.856509Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-12-20T01:21:56.856515Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-12-20T01:21:56.856519Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-12-20T01:21:56.856524Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-12-20T01:21:56.856529Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-12-20T01:21:56.856533Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-12-20T01:21:56.856538Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-12-20T01:21:56.856542Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-12-20T01:21:56.856547Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-12-20T01:21:56.856551Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-12-20T01:21:56.856555Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-12-20T01:21:56.856560Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-12-20T01:21:56.856564Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-12-20T01:21:56.856569Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-12-20T01:21:56.856573Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-12-20T01:21:56.856577Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-12-20T01:21:56.856582Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-12-20T01:21:56.856599Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-12-20T01:21:56.856603Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-12-20T01:21:56.856608Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2018-12-20T01:21:56.856613Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2018-12-20T01:21:56.856617Z 0 [Note] Shutting down plugin 'XTRADB_RSEG' 2018-12-20T01:21:56.856622Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2018-12-20T01:21:56.856626Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2018-12-20T01:21:56.856631Z 0 [Note] Shutting down plugin 'InnoDB' 2018-12-20T01:21:56.856713Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-12-20T01:21:56.856773Z 0 [Note] InnoDB: Starting shutdown... 2018-12-20T01:21:56.984775Z 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/data/db/mysql/ib_buffer_pool 2018-12-20T01:21:56.987193Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181220 1:21:56 2018-12-20T01:21:57.157166Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-12-20T01:21:58.803339Z 0 [Note] InnoDB: Shutdown completed; log sequence number 39438223 2018-12-20T01:21:58.804185Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-12-20T01:21:58.804203Z 0 [Note] Shutting down plugin 'sha256_password' 2018-12-20T01:21:58.804210Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-12-20T01:21:58.804498Z 0 [Note] Shutting down plugin 'binlog' 2018-12-20T01:21:58.806461Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: Shutdown complete 2018-12-20T01:22:13.593479Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-12-20T01:22:13.713827Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-12-20T01:22:13.714272Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-12-20T01:22:13.714331Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.23-23-log) starting as process 50 ... 2018-12-20T01:22:13.728528Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-12-20T01:22:13.728615Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-12-20T01:22:13.728659Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-12-20T01:22:13.728682Z 0 [Note] InnoDB: Uses event mutexes 2018-12-20T01:22:13.728700Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-12-20T01:22:13.728720Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-12-20T01:22:13.728738Z 0 [Note] InnoDB: Using Linux native AIO 2018-12-20T01:22:13.729300Z 0 [Note] InnoDB: Number of pools: 1 2018-12-20T01:22:13.729616Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-12-20T01:22:13.744180Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-12-20T01:22:13.747987Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-12-20T01:22:13.752640Z 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-20T01:22:13.831639Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-12-20T01:22:13.837778Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-12-20T01:22:13.900623Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-12-20T01:22:14.182899Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-12-20T01:22:14.183838Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-12-20T01:22:14.249248Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-12-20T01:22:14.251421Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-12-20T01:22:14.251450Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-12-20T01:22:14.253101Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-23 started; log sequence number 39438223 2018-12-20T01:22:14.253802Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-12-20T01:22:14.254181Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-12-20T01:22:14.268826Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-12-20T01:22:14.268859Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-12-20T01:22:14.284904Z 0 [Warning] CA certificate ca.pem is self signed. 2018-12-20T01:22:14.285304Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-12-20T01:22:14.306451Z 0 [Warning] Insecure configuration for --pid-file: Location '/srv/run' in the path is accessible to all OS users. Consider choosing a different directory. 2018-12-20T01:22:14.402039Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181220 1:22:14 2018-12-20T01:22:14.603859Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.23-23-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-12-20T01:22:18.792365Z 0 [Note] Giving 0 client threads a chance to die gracefully 2018-12-20T01:22:18.792413Z 0 [Note] Shutting down slave threads 2018-12-20T01:22:18.792423Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-12-20T01:22:18.792476Z 0 [Note] Binlog end 2018-12-20T01:22:18.792803Z 0 [Note] Shutting down plugin 'ngram' 2018-12-20T01:22:18.792841Z 0 [Note] Shutting down plugin 'partition' 2018-12-20T01:22:18.792855Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-12-20T01:22:18.792863Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-12-20T01:22:18.792870Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-12-20T01:22:18.792882Z 0 [Note] Shutting down plugin 'MyISAM' 2018-12-20T01:22:18.792896Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-12-20T01:22:18.792904Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2018-12-20T01:22:18.792911Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-12-20T01:22:18.792918Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-12-20T01:22:18.792924Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-12-20T01:22:18.792931Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-12-20T01:22:18.792937Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-12-20T01:22:18.792943Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-12-20T01:22:18.792950Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-12-20T01:22:18.792956Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-12-20T01:22:18.792963Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-12-20T01:22:18.792969Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-12-20T01:22:18.792976Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-12-20T01:22:18.792982Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-12-20T01:22:18.792989Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-12-20T01:22:18.792995Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-12-20T01:22:18.793002Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-12-20T01:22:18.793008Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-12-20T01:22:18.793014Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-12-20T01:22:18.793021Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-12-20T01:22:18.793027Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-12-20T01:22:18.793033Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-12-20T01:22:18.793045Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-12-20T01:22:18.793058Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-12-20T01:22:18.793071Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-12-20T01:22:18.793083Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-12-20T01:22:18.793093Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-12-20T01:22:18.793100Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-12-20T01:22:18.793107Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-12-20T01:22:18.793114Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-12-20T01:22:18.793121Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-12-20T01:22:18.793141Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2018-12-20T01:22:18.793185Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2018-12-20T01:22:18.793194Z 0 [Note] Shutting down plugin 'XTRADB_RSEG' 2018-12-20T01:22:18.793202Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2018-12-20T01:22:18.793215Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2018-12-20T01:22:18.793234Z 0 [Note] Shutting down plugin 'InnoDB' 2018-12-20T01:22:18.793330Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-12-20T01:22:18.793465Z 0 [Note] InnoDB: Starting shutdown... 2018-12-20T01:22:18.893686Z 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/data/db/mysql/ib_buffer_pool 2018-12-20T01:22:18.898224Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181220 1:22:18 2018-12-20T01:22:19.394031Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-12-20T01:22:20.611800Z 0 [Note] InnoDB: Shutdown completed; log sequence number 40694039 2018-12-20T01:22:20.612752Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-12-20T01:22:20.612781Z 0 [Note] Shutting down plugin 'MEMORY' 2018-12-20T01:22:20.612799Z 0 [Note] Shutting down plugin 'CSV' 2018-12-20T01:22:20.612814Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-12-20T01:22:20.612887Z 0 [Note] Shutting down plugin 'sha256_password' 2018-12-20T01:22:20.612903Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-12-20T01:22:20.613282Z 0 [Note] Shutting down plugin 'binlog' 2018-12-20T01:22:20.614461Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: Shutdown complete 2018-12-20T01:22:20.747583Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-12-20T01:22:20.861916Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-12-20T01:22:20.862393Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2018-12-20T01:22:20.862463Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.23-23-log) starting as process 120 ... 2018-12-20T01:22:20.876638Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-12-20T01:22:20.876699Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-12-20T01:22:20.876725Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-12-20T01:22:20.876736Z 0 [Note] InnoDB: Uses event mutexes 2018-12-20T01:22:20.876749Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-12-20T01:22:20.876760Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-12-20T01:22:20.876770Z 0 [Note] InnoDB: Using Linux native AIO 2018-12-20T01:22:20.877142Z 0 [Note] InnoDB: Number of pools: 1 2018-12-20T01:22:20.877374Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-12-20T01:22:20.891506Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2018-12-20T01:22:20.895954Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-12-20T01:22:20.900612Z 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-20T01:22:20.919478Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2018-12-20T01:22:20.923581Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-12-20T01:22:20.949058Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2018-12-20T01:22:21.115021Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-12-20T01:22:21.115836Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-12-20T01:22:21.161797Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-12-20T01:22:21.164208Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-12-20T01:22:21.164232Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-12-20T01:22:21.166199Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-23 started; log sequence number 40694039 2018-12-20T01:22:21.166706Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2018-12-20T01:22:21.166776Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-12-20T01:22:21.179083Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-12-20T01:22:21.179112Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2018-12-20T01:22:21.180442Z 0 [Warning] CA certificate ca.pem is self signed. 2018-12-20T01:22:21.180526Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-12-20T01:22:21.180926Z 0 [Warning] Insecure configuration for --pid-file: Location '/srv/run' in the path is accessible to all OS users. Consider choosing a different directory. 2018-12-20T01:22:21.218595Z 0 [Note] Event Scheduler: Loaded 0 events 2018-12-20T01:22:21.218862Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.23-23-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2018-12-20T01:22:21.233480Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181220 1:22:21 2018-12-20T01:22:21.767484Z 2 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2018-12-20T01:22:21.830087Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2019-01-21T11:18:33.927170Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2019-01-21T11:18:34.041917Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-01-21T11:18:34.042614Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2019-01-21T11:18:34.042666Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.23-23-log) starting as process 59 ... 2019-01-21T11:18:34.066727Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2019-01-21T11:18:34.066794Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-01-21T11:18:34.066821Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-01-21T11:18:34.066834Z 0 [Note] InnoDB: Uses event mutexes 2019-01-21T11:18:34.066847Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-01-21T11:18:34.066860Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-01-21T11:18:34.066872Z 0 [Note] InnoDB: Using Linux native AIO 2019-01-21T11:18:34.067304Z 0 [Note] InnoDB: Number of pools: 1 2019-01-21T11:18:34.067585Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-01-21T11:18:34.104683Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2019-01-21T11:18:34.109464Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-01-21T11:18:34.117779Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-01-21T11:18:34.216515Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2019-01-21T11:18:34.237314Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-01-21T11:18:34.276506Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 57294612 2019-01-21T11:18:34.276552Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 57294621 2019-01-21T11:18:34.276578Z 0 [Note] InnoDB: Database was not shutdown normally! 2019-01-21T11:18:34.276599Z 0 [Note] InnoDB: Starting crash recovery. 2019-01-21T11:18:34.406019Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2019-01-21T11:18:35.296166Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-01-21T11:18:35.296223Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-01-21T11:18:35.298112Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-01-21T11:18:35.402368Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-01-21T11:18:35.406595Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-01-21T11:18:35.406624Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-01-21T11:18:35.408059Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-23 started; log sequence number 57294621 2019-01-21T11:18:35.409343Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2019-01-21T11:18:35.410087Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-01-21T11:18:35.446970Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190121 11:18:35 2019-01-21T11:18:35.450409Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2019-01-21T11:18:35.450448Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2019-01-21T11:18:35.503993Z 0 [Warning] CA certificate ca.pem is self signed. 2019-01-21T11:18:35.504406Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2019-01-21T11:18:35.548103Z 0 [Warning] Insecure configuration for --pid-file: Location '/srv/run' in the path is accessible to all OS users. Consider choosing a different directory. 2019-01-21T11:18:36.218197Z 0 [Note] Event Scheduler: Loaded 0 events 2019-01-21T11:18:36.218599Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.23-23-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2019-01-21T11:18:36.221554Z 2 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2019-01-21T11:18:36.278654Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2019-06-10T17:04:22.651125Z 0 [Note] Giving 0 client threads a chance to die gracefully 2019-06-10T17:04:22.651175Z 0 [Note] Shutting down slave threads 2019-06-10T17:04:22.651196Z 0 [Note] Forcefully disconnecting 0 remaining clients 2019-06-10T17:04:22.651211Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-06-10T17:04:22.662956Z 0 [Note] Binlog end 2019-06-10T17:04:22.933287Z 0 [Note] Shutting down plugin 'ngram' 2019-06-10T17:04:22.936092Z 0 [Note] Shutting down plugin 'partition' 2019-06-10T17:04:22.936123Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2019-06-10T17:04:22.936949Z 0 [Note] Shutting down plugin 'ARCHIVE' 2019-06-10T17:04:22.936968Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2019-06-10T17:04:22.936980Z 0 [Note] Shutting down plugin 'MyISAM' 2019-06-10T17:04:22.939552Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2019-06-10T17:04:22.939571Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2019-06-10T17:04:22.939581Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2019-06-10T17:04:22.939591Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2019-06-10T17:04:22.939601Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2019-06-10T17:04:22.939610Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2019-06-10T17:04:22.939621Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2019-06-10T17:04:22.939631Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2019-06-10T17:04:22.939640Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2019-06-10T17:04:22.939650Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2019-06-10T17:04:22.939659Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2019-06-10T17:04:22.939669Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2019-06-10T17:04:22.939678Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2019-06-10T17:04:22.939688Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2019-06-10T17:04:22.939698Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2019-06-10T17:04:22.939707Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2019-06-10T17:04:22.939717Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2019-06-10T17:04:22.939726Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2019-06-10T17:04:22.939735Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2019-06-10T17:04:22.939744Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2019-06-10T17:04:22.939754Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2019-06-10T17:04:22.939763Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2019-06-10T17:04:22.939772Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2019-06-10T17:04:22.939781Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2019-06-10T17:04:22.939791Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2019-06-10T17:04:22.939800Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2019-06-10T17:04:22.939809Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2019-06-10T17:04:22.939818Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2019-06-10T17:04:22.939828Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2019-06-10T17:04:22.939849Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2019-06-10T17:04:22.939860Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2019-06-10T17:04:22.939870Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2019-06-10T17:04:22.939880Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2019-06-10T17:04:22.939889Z 0 [Note] Shutting down plugin 'XTRADB_RSEG' 2019-06-10T17:04:22.939899Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2019-06-10T17:04:22.939909Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2019-06-10T17:04:22.939919Z 0 [Note] Shutting down plugin 'InnoDB' 2019-06-10T17:04:22.969335Z 0 [Note] InnoDB: FTS optimize thread exiting. 2019-06-10T17:04:22.969511Z 0 [Note] InnoDB: Starting shutdown... 2019-06-10T17:04:23.091244Z 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/data/db/mysql/ib_buffer_pool 2019-06-10T17:04:23.133913Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190610 17:04:23 2019-06-10T17:04:23.883269Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2019-06-10T17:04:25.707333Z 0 [Note] InnoDB: Shutdown completed; log sequence number 219189209 2019-06-10T17:04:25.710804Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-06-10T17:04:25.710920Z 0 [Note] Shutting down plugin 'MEMORY' 2019-06-10T17:04:25.710958Z 0 [Note] Shutting down plugin 'CSV' 2019-06-10T17:04:25.711101Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2019-06-10T17:04:25.725677Z 0 [Note] Shutting down plugin 'sha256_password' 2019-06-10T17:04:25.725716Z 0 [Note] Shutting down plugin 'mysql_native_password' 2019-06-10T17:04:25.736973Z 0 [Note] Shutting down plugin 'binlog' 2019-06-10T17:04:25.825280Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: Shutdown complete 2019-06-10T17:20:39.297098Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2019-06-10T17:20:39.412636Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-06-10T17:20:39.413320Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2019-06-10T17:20:39.413370Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.23-23-log) starting as process 58 ... 2019-06-10T17:20:39.433373Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2019-06-10T17:20:39.433428Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-06-10T17:20:39.433448Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-06-10T17:20:39.433459Z 0 [Note] InnoDB: Uses event mutexes 2019-06-10T17:20:39.433470Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-06-10T17:20:39.433481Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-06-10T17:20:39.433492Z 0 [Note] InnoDB: Using Linux native AIO 2019-06-10T17:20:39.433833Z 0 [Note] InnoDB: Number of pools: 1 2019-06-10T17:20:39.434069Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-06-10T17:20:39.458975Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2019-06-10T17:20:39.463543Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-06-10T17:20:39.470908Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-06-10T17:20:39.535250Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2019-06-10T17:20:39.540619Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-06-10T17:20:39.621819Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2019-06-10T17:20:40.015127Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-06-10T17:20:40.016106Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-06-10T17:20:40.097643Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-06-10T17:20:40.106986Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-06-10T17:20:40.107017Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-06-10T17:20:40.108271Z 0 [Note] InnoDB: Waiting for purge to start 2019-06-10T17:20:40.158991Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-23 started; log sequence number 219189209 2019-06-10T17:20:40.159525Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-06-10T17:20:40.159701Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2019-06-10T17:20:40.297864Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2019-06-10T17:20:40.297893Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2019-06-10T17:20:40.322673Z 0 [Warning] CA certificate ca.pem is self signed. 2019-06-10T17:20:40.323040Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2019-06-10T17:20:40.339329Z 0 [Warning] Insecure configuration for --pid-file: Location '/srv/run' in the path is accessible to all OS users. Consider choosing a different directory. 2019-06-10T17:20:40.600867Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190610 17:20:40 2019-06-10T17:20:41.288909Z 0 [Note] Event Scheduler: Loaded 0 events 2019-06-10T17:20:41.289276Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.23-23-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2019-06-10T17:20:41.455715Z 2 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2019-06-10T17:20:41.533398Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2019-09-03T15:50:55.001659Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21914ms. The settings might not be optimal. (flushed=0, during the time.) 2020-02-10T10:03:45.810838Z 133383 [Note] Access denied for user '517130'@'localhost' (using password: YES) 2020-08-30T20:17:26.056007Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-08-30T20:17:26.056073Z 0 [Note] Shutting down slave threads 2020-08-30T20:17:26.056095Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-08-30T20:17:26.056114Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-08-30T20:17:26.066370Z 0 [Note] Binlog end 2020-08-30T20:17:26.909381Z 0 [Note] Shutting down plugin 'ngram' 2020-08-30T20:17:26.913076Z 0 [Note] Shutting down plugin 'partition' 2020-08-30T20:17:26.913102Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-08-30T20:17:26.915246Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-08-30T20:17:26.915269Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-08-30T20:17:26.915279Z 0 [Note] Shutting down plugin 'MyISAM' 2020-08-30T20:17:26.918081Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-08-30T20:17:26.918104Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2020-08-30T20:17:26.918114Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-08-30T20:17:26.918123Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-08-30T20:17:26.918132Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-08-30T20:17:26.918142Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-08-30T20:17:26.918151Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-08-30T20:17:26.918160Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-08-30T20:17:26.918169Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-08-30T20:17:26.918178Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-08-30T20:17:26.918187Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-08-30T20:17:26.918196Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-08-30T20:17:26.918206Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-08-30T20:17:26.918215Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-08-30T20:17:26.918234Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-08-30T20:17:26.918244Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-08-30T20:17:26.918255Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-08-30T20:17:26.918268Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-08-30T20:17:26.918280Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-08-30T20:17:26.918298Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-08-30T20:17:26.918307Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-08-30T20:17:26.918316Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-08-30T20:17:26.918325Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-08-30T20:17:26.918334Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-08-30T20:17:26.918355Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-08-30T20:17:26.918364Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-08-30T20:17:26.918373Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-08-30T20:17:26.918385Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-08-30T20:17:26.918395Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-08-30T20:17:26.918405Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-08-30T20:17:26.918415Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-08-30T20:17:26.918424Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2020-08-30T20:17:26.918433Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2020-08-30T20:17:26.918443Z 0 [Note] Shutting down plugin 'XTRADB_RSEG' 2020-08-30T20:17:26.918452Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2020-08-30T20:17:26.918461Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2020-08-30T20:17:26.918470Z 0 [Note] Shutting down plugin 'InnoDB' 2020-08-30T20:17:26.930556Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-08-30T20:17:26.930684Z 0 [Note] InnoDB: Starting shutdown... 2020-08-30T20:17:27.071035Z 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/data/db/mysql/ib_buffer_pool 2020-08-30T20:17:27.087502Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200830 20:17:27 2020-08-30T20:17:27.531988Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2020-08-30T20:17:29.215592Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1312844205 2020-08-30T20:17:29.241460Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-08-30T20:17:29.241503Z 0 [Note] Shutting down plugin 'MEMORY' 2020-08-30T20:17:29.241516Z 0 [Note] Shutting down plugin 'CSV' 2020-08-30T20:17:29.241567Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-08-30T20:17:29.244157Z 0 [Note] Shutting down plugin 'sha256_password' 2020-08-30T20:17:29.244177Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-08-30T20:17:29.264293Z 0 [Note] Shutting down plugin 'binlog' 2020-08-30T20:17:29.282638Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: Shutdown complete 2020-08-30T21:24:26.301165Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2020-08-30T21:24:26.423181Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-08-30T21:24:26.423572Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2020-08-30T21:24:26.423637Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.23-23-log) starting as process 56 ... 2020-08-30T21:24:26.444529Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2020-08-30T21:24:26.444594Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-08-30T21:24:26.444612Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-08-30T21:24:26.444624Z 0 [Note] InnoDB: Uses event mutexes 2020-08-30T21:24:26.444636Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-08-30T21:24:26.444655Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2020-08-30T21:24:26.444666Z 0 [Note] InnoDB: Using Linux native AIO 2020-08-30T21:24:26.445008Z 0 [Note] InnoDB: Number of pools: 1 2020-08-30T21:24:26.445228Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-08-30T21:24:26.504382Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2020-08-30T21:24:26.508237Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-08-30T21:24:26.512643Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-08-30T21:24:26.576428Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2020-08-30T21:24:26.582541Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-08-30T21:24:26.657150Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2020-08-30T21:24:26.971372Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-08-30T21:24:26.972479Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-08-30T21:24:27.030480Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-08-30T21:24:27.033304Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-08-30T21:24:27.033328Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-08-30T21:24:27.034923Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-23 started; log sequence number 1312844205 2020-08-30T21:24:27.035466Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-08-30T21:24:27.035644Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2020-08-30T21:24:27.142210Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-08-30T21:24:27.142250Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-08-30T21:24:27.173088Z 0 [Warning] CA certificate ca.pem is self signed. 2020-08-30T21:24:27.173396Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-08-30T21:24:27.191848Z 0 [Warning] Insecure configuration for --pid-file: Location '/srv/run' in the path is accessible to all OS users. Consider choosing a different directory. 2020-08-30T21:24:27.884631Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200830 21:24:27 2020-08-30T21:24:28.016991Z 0 [Note] Event Scheduler: Loaded 0 events 2020-08-30T21:24:28.017291Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.23-23-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2020-08-30T21:24:28.020004Z 2 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2020-08-30T21:24:28.082581Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2020-11-25T23:06:54.229964Z 170553 [Note] Access denied for user 'votre_utilisateur_de_bdd'@'localhost' (using password: YES) 2021-09-18T19:20:43.033860Z 666172 [Note] Access denied for user 'votre_utilisateur_de_bdd'@'localhost' (using password: YES) 2022-01-06T23:41:19.616451Z 847921 [Note] Access denied for user 'votre_utilisateur_de_bdd'@'localhost' (using password: YES) 2022-05-17T01:04:38.143919Z 1186238 [Note] Access denied for user 'votre_utilisateur_de_bdd'@'localhost' (using password: YES) 2022-06-09T02:34:13.284918Z 1284985 [Note] Access denied for user 'votre_utilisateur_de_bdd'@'localhost' (using password: YES) 2022-07-25T04:45:41.174392Z 1594374 [Note] Access denied for user 'votre_utilisateur_de_bdd'@'localhost' (using password: YES) 2022-09-07T02:22:05.088814Z 1902804 [Note] Access denied for user 'votre_utilisateur_de_bdd'@'localhost' (using password: YES) 2022-09-18T10:59:31.691379Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-09-18T10:59:31.691447Z 0 [Note] Shutting down slave threads 2022-09-18T10:59:31.691466Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-09-18T10:59:31.691479Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-09-18T10:59:31.691849Z 0 [Note] Binlog end 2022-09-18T10:59:31.705559Z 0 [Note] Shutting down plugin 'ngram' 2022-09-18T10:59:31.705847Z 0 [Note] Shutting down plugin 'partition' 2022-09-18T10:59:31.705861Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-09-18T10:59:31.706045Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-09-18T10:59:31.706057Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-09-18T10:59:31.706066Z 0 [Note] Shutting down plugin 'MyISAM' 2022-09-18T10:59:31.706378Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-09-18T10:59:31.706392Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2022-09-18T10:59:31.706400Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-09-18T10:59:31.706407Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-09-18T10:59:31.706415Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-09-18T10:59:31.706423Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-09-18T10:59:31.706431Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-09-18T10:59:31.706439Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-09-18T10:59:31.706447Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-09-18T10:59:31.706455Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-09-18T10:59:31.706468Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-09-18T10:59:31.706513Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-09-18T10:59:31.706529Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-09-18T10:59:31.706558Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-09-18T10:59:31.706567Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-09-18T10:59:31.706575Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-09-18T10:59:31.706583Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-09-18T10:59:31.706591Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-09-18T10:59:31.706608Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-09-18T10:59:31.706621Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-09-18T10:59:31.706629Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-09-18T10:59:31.706638Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-09-18T10:59:31.706646Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-09-18T10:59:31.706654Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-09-18T10:59:31.706669Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-09-18T10:59:31.706677Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-09-18T10:59:31.706685Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-09-18T10:59:31.706693Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-09-18T10:59:31.706701Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-09-18T10:59:31.706710Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-09-18T10:59:31.706718Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-09-18T10:59:31.706743Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2022-09-18T10:59:31.706751Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2022-09-18T10:59:31.706759Z 0 [Note] Shutting down plugin 'XTRADB_RSEG' 2022-09-18T10:59:31.706767Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2022-09-18T10:59:31.706774Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2022-09-18T10:59:31.706782Z 0 [Note] Shutting down plugin 'InnoDB' 2022-09-18T10:59:31.710026Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-09-18T10:59:31.710182Z 0 [Note] InnoDB: Starting shutdown... 2022-09-18T10:59:31.812926Z 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/data/db/mysql/ib_buffer_pool 2022-09-18T10:59:31.816958Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220918 10:59:31 2022-09-18T10:59:32.111350Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2022-09-18T10:59:33.287755Z 0 [Note] InnoDB: Shutdown completed; log sequence number 4980704664 2022-09-18T10:59:33.288858Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-09-18T10:59:33.288902Z 0 [Note] Shutting down plugin 'MEMORY' 2022-09-18T10:59:33.288915Z 0 [Note] Shutting down plugin 'CSV' 2022-09-18T10:59:33.289081Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-09-18T10:59:33.289652Z 0 [Note] Shutting down plugin 'sha256_password' 2022-09-18T10:59:33.289703Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-09-18T10:59:33.293221Z 0 [Note] Shutting down plugin 'binlog' 2022-09-18T10:59:33.297116Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: Shutdown complete 2022-09-18T13:44:19.117579Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2022-09-18T13:44:19.229748Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-09-18T13:44:19.230078Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2022-09-18T13:44:19.230102Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.23-23-log) starting as process 56 ... 2022-09-18T13:44:19.238691Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2022-09-18T13:44:19.238722Z 0 [Note] InnoDB: PUNCH HOLE support available 2022-09-18T13:44:19.238730Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-09-18T13:44:19.238733Z 0 [Note] InnoDB: Uses event mutexes 2022-09-18T13:44:19.238737Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-09-18T13:44:19.238740Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2022-09-18T13:44:19.238743Z 0 [Note] InnoDB: Using Linux native AIO 2022-09-18T13:44:19.238935Z 0 [Note] InnoDB: Number of pools: 1 2022-09-18T13:44:19.239051Z 0 [Note] InnoDB: Using CPU crc32 instructions 2022-09-18T13:44:19.250858Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2022-09-18T13:44:19.253159Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-18T13:44:19.256003Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2022-09-18T13:44:19.372239Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2022-09-18T13:44:19.375583Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-09-18T13:44:19.415684Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2022-09-18T13:44:19.609836Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-18T13:44:19.610249Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-18T13:44:19.649905Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-18T13:44:19.650881Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-09-18T13:44:19.650891Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-09-18T13:44:19.651895Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-23 started; log sequence number 4980704664 2022-09-18T13:44:19.652505Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2022-09-18T13:44:19.652633Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-09-18T13:44:19.740438Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-09-18T13:44:19.740461Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-09-18T13:44:19.760241Z 0 [Warning] CA certificate ca.pem is self signed. 2022-09-18T13:44:19.760477Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-09-18T13:44:19.789091Z 0 [Warning] Insecure configuration for --pid-file: Location '/srv/run' in the path is accessible to all OS users. Consider choosing a different directory. 2022-09-18T13:44:20.547903Z 0 [Note] Event Scheduler: Loaded 0 events 2022-09-18T13:44:20.548110Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.23-23-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona 2022-09-18T13:44:20.549582Z 2 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2022-09-18T13:44:20.571290Z 3 [Note] Access denied for user 'hosting-db'@'localhost' (using password: NO) 2022-09-18T13:44:20.761837Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220918 13:44:20 2022-10-30T20:15:23.928554Z 285477 [Note] Access denied for user 'votre_utilisateur_de_bdd'@'localhost' (using password: YES) 2023-06-12T21:22:18.233890Z 0 [Note] Giving 0 client threads a chance to die gracefully 2023-06-12T21:22:18.233961Z 0 [Note] Shutting down slave threads 2023-06-12T21:22:18.233967Z 0 [Note] Forcefully disconnecting 0 remaining clients 2023-06-12T21:22:18.233981Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2023-06-12T21:22:18.234369Z 0 [Note] Binlog end 2023-06-12T21:22:18.250076Z 0 [Note] Shutting down plugin 'ngram' 2023-06-12T21:22:18.250207Z 0 [Note] Shutting down plugin 'partition' 2023-06-12T21:22:18.250212Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2023-06-12T21:22:18.250320Z 0 [Note] Shutting down plugin 'ARCHIVE' 2023-06-12T21:22:18.250325Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2023-06-12T21:22:18.250329Z 0 [Note] Shutting down plugin 'MyISAM' 2023-06-12T21:22:18.250859Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2023-06-12T21:22:18.250865Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2023-06-12T21:22:18.250867Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2023-06-12T21:22:18.250870Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2023-06-12T21:22:18.250872Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2023-06-12T21:22:18.250874Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2023-06-12T21:22:18.250877Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2023-06-12T21:22:18.250879Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2023-06-12T21:22:18.250881Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2023-06-12T21:22:18.250884Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2023-06-12T21:22:18.250886Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2023-06-12T21:22:18.250888Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2023-06-12T21:22:18.250890Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2023-06-12T21:22:18.250892Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2023-06-12T21:22:18.251016Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2023-06-12T21:22:18.251020Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2023-06-12T21:22:18.251023Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2023-06-12T21:22:18.251025Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2023-06-12T21:22:18.251027Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2023-06-12T21:22:18.251031Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2023-06-12T21:22:18.251160Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2023-06-12T21:22:18.251164Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2023-06-12T21:22:18.251166Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2023-06-12T21:22:18.251169Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2023-06-12T21:22:18.251171Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2023-06-12T21:22:18.251173Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2023-06-12T21:22:18.251176Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2023-06-12T21:22:18.251178Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2023-06-12T21:22:18.251180Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2023-06-12T21:22:18.251183Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2023-06-12T21:22:18.251185Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2023-06-12T21:22:18.251187Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2023-06-12T21:22:18.251195Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2023-06-12T21:22:18.251197Z 0 [Note] Shutting down plugin 'XTRADB_RSEG' 2023-06-12T21:22:18.251199Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2023-06-12T21:22:18.251201Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2023-06-12T21:22:18.251204Z 0 [Note] Shutting down plugin 'InnoDB' 2023-06-12T21:22:18.253473Z 0 [Note] InnoDB: FTS optimize thread exiting. 2023-06-12T21:22:18.253529Z 0 [Note] InnoDB: Starting shutdown... 2023-06-12T21:22:18.388018Z 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/data/db/mysql/ib_buffer_pool 2023-06-12T21:22:18.391915Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 230612 21:22:18 2023-06-12T21:22:19.254706Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2023-06-12T21:22:20.816889Z 0 [Note] InnoDB: Shutdown completed; log sequence number 6635868832 2023-06-12T21:22:20.818174Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2023-06-12T21:22:20.818187Z 0 [Note] Shutting down plugin 'MEMORY' 2023-06-12T21:22:20.818193Z 0 [Note] Shutting down plugin 'CSV' 2023-06-12T21:22:20.818359Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2023-06-12T21:22:20.818959Z 0 [Note] Shutting down plugin 'sha256_password' 2023-06-12T21:22:20.818983Z 0 [Note] Shutting down plugin 'mysql_native_password' 2023-06-12T21:22:20.821404Z 0 [Note] Shutting down plugin 'binlog' 2023-06-12T21:22:20.825592Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: Shutdown complete 2023-06-12T21:22:35.785572Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2023-06-12T21:22:35.897702Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2023-06-12T21:22:35.897889Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2023-06-12T21:22:35.897909Z 0 [Note] /opt/mysql-5.7/sbin/mysqld (mysqld 5.7.23-23-log) starting as process 56 ... 2023-06-12T21:22:35.907406Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2023-06-12T21:22:35.907433Z 0 [Note] InnoDB: PUNCH HOLE support available 2023-06-12T21:22:35.907441Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2023-06-12T21:22:35.907444Z 0 [Note] InnoDB: Uses event mutexes 2023-06-12T21:22:35.907448Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2023-06-12T21:22:35.907451Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2023-06-12T21:22:35.907455Z 0 [Note] InnoDB: Using Linux native AIO 2023-06-12T21:22:35.907638Z 0 [Note] InnoDB: Number of pools: 1 2023-06-12T21:22:35.907755Z 0 [Note] InnoDB: Using CPU crc32 instructions 2023-06-12T21:22:35.916507Z 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M 2023-06-12T21:22:35.919066Z 0 [Note] InnoDB: Completed initialization of buffer pool 2023-06-12T21:22:35.921748Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2023-06-12T21:22:35.985736Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite 2023-06-12T21:22:35.989827Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2023-06-12T21:22:36.034029Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /srv/data/db/mysql/xb_doublewrite, size 3932160 bytes 2023-06-12T21:22:36.253043Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-06-12T21:22:36.253963Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-06-12T21:22:36.297410Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2023-06-12T21:22:36.298442Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2023-06-12T21:22:36.298460Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2023-06-12T21:22:36.299546Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-23 started; log sequence number 6635868832 2023-06-12T21:22:36.300079Z 0 [Note] InnoDB: Loading buffer pool(s) from /srv/data/db/mysql/ib_buffer_pool 2023-06-12T21:22:36.300290Z 0 [Note] Plugin 'FEDERATED' is disabled. 2023-06-12T21:22:36.347591Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2023-06-12T21:22:36.347606Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2023-06-12T21:22:36.413189Z 0 [Warning] CA certificate ca.pem is self signed. 2023-06-12T21:22:36.413415Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2023-06-12T21:22:36.439596Z 0 [Warning] Insecure configuration for --pid-file: Location '/srv/run' in the path is accessible to all OS users. Consider choosing a different directory. 2023-06-12T21:22:37.215584Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230612 21:22:37 2023-06-12T21:22:37.370212Z 0 [Note] /opt/mysql-5.7/sbin/mysqld: ready for connections. Version: '5.7.23-23-log' socket: '/srv/run/mysqld/mysqld.sock' port: 0 Percona