Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2018-11-17T06:54:49.608696Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 2754
- 2018-11-17T06:54:49.611699Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T06:54:49.821376Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T06:54:49.837051Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T06:54:50.061715Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T06:56:01.386811Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-17T07:00:46.268269Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-17T07:07:23.090337Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 2929
- 2018-11-17T07:07:23.093099Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T07:07:23.284554Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T07:07:23.289788Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-17T07:07:23.300747Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T07:07:23.522022Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T07:08:07.831968Z 9 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-17T08:54:51.300797Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-17T08:55:32.985683Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 97
- 2018-11-17T08:55:32.999910Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T08:55:33.814975Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T08:55:33.823296Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-17T08:55:33.845455Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T08:55:34.033789Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T08:55:41.148205Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-17T09:15:13.972089Z 0 [Warning] [MY-010909] [Server] /usr/local/mysql/bin/mysqld: Forcing close of thread 216 user: 'mrmc'.
- 2018-11-17T09:15:14.727090Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-17T09:15:40.707539Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 97
- 2018-11-17T09:15:40.783999Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T09:15:41.312243Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T09:15:41.318712Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-17T09:15:41.368388Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T09:15:41.529158Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T09:15:46.990158Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-17T09:18:37.828060Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-17T09:19:00.034796Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 97
- 2018-11-17T09:19:00.093080Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T09:19:00.627710Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T09:19:00.634520Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-17T09:19:00.704317Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T09:19:00.850130Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T09:20:10.345724Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-17T09:20:35.311497Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 98
- 2018-11-17T09:20:35.321202Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T09:20:35.778706Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T09:20:35.785291Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-17T09:20:35.807003Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T09:20:36.006600Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T09:24:29.728957Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-17T09:24:52.157887Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 98
- 2018-11-17T09:24:52.168243Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T09:24:52.664906Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T09:24:52.671873Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-17T09:24:52.693342Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T09:24:52.891733Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T17:27:03.422762Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-17T17:27:33.958720Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 98
- 2018-11-17T17:27:33.971215Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T17:27:34.497412Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T17:27:34.504909Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-17T17:27:34.527307Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T17:27:34.722578Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T17:30:43.504628Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-17T17:31:21.227473Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-17T17:31:43.806381Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 97
- 2018-11-17T17:31:43.823303Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-17T17:31:44.387015Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-17T17:31:44.393933Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-17T17:31:44.414897Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-17T17:31:44.622492Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-17T17:32:59.517149Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-19T05:31:29.842824Z 93 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1226:table2 == NULL thread 123145503961088
- 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/8.0/en/forcing-innodb-recovery.html
- InnoDB: about forcing recovery.
- 05:31:29 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.
- key_buffer_size=8388608
- read_buffer_size=131072
- max_used_connections=3
- max_threads=151
- thread_count=2
- connection_count=1
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67867 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7f94594a4400
- 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 = 70000c04eeb0 thread_stack 0x46000
- 0 mysqld 0x0000000105ac2d4c my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000104ef0456 handle_fatal_signal + 678
- 2 libsystem_platform.dylib 0x00007fff7a571b3d _sigtramp + 29
- 3 ??? 0x0000000114f15bc6 0x0 + 4646329286
- 4 libsystem_c.dylib 0x00007fff7a42f1c9 abort + 127
- 5 mysqld 0x0000000105e6be99 ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 329
- 6 mysqld 0x0000000105c03c1a dict_table_add_to_cache(dict_table_t*, unsigned long, mem_block_info_t*) + 490
- 7 mysqld 0x0000000105c296c1 dict_table_t* dd_open_table_one<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::__1::deque<char const*, ut_allocator<char const*> >&) + 7409
- 8 mysqld 0x0000000105c1a448 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 72
- 9 mysqld 0x0000000105cd47ad ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2797
- 10 mysqld 0x0000000104ad34f7 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x0000000104e96b25 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3621
- 12 mysqld 0x0000000104d23906 open_table(THD*, TABLE_LIST*, Open_table_context*) + 6406
- 13 mysqld 0x0000000104d28283 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 1955
- 14 mysqld 0x0000000104d2a54d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 109
- 15 mysqld 0x0000000104df14eb Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x0000000104df1bbe Sql_cmd_dml::execute(THD*) + 350
- 17 mysqld 0x0000000104da99a1 mysql_execute_command(THD*, bool) + 3937
- 18 mysqld 0x0000000104da7403 mysql_parse(THD*, Parser_state*, bool) + 915
- 19 mysqld 0x0000000104da507d dispatch_command(THD*, COM_DATA const*, enum_server_command) + 4173
- 20 mysqld 0x0000000104da6c83 do_command(THD*) + 467
- 21 mysqld 0x0000000104ed8744 handle_connection(void*) + 388
- 22 mysqld 0x0000000105ed0adc pfs_spawn_thread(void*) + 316
- 23 libsystem_pthread.dylib 0x00007fff7a57a305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff7a57d26f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff7a579415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7f9459508a28): SELECT idVersion FROM version
- Connection ID (thread ID): 93
- Status: NOT_KILLED
- The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
- information that should help you find out what is causing the crash.
- 2018-11-19T05:31:30.151443Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 18091
- 2018-11-19T05:31:30.183213Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-19T05:31:31.148019Z 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2018-11-19T05:31:31.156637Z 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2018-11-19T05:31:31.166442Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-19T05:31:31.173269Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-19T05:31:31.340694Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-19T05:31:31.397541Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-19T05:31:31.885110Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-21T05:08:45.953776Z 61 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1226:table2 == NULL thread 123145506988032
- 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/8.0/en/forcing-innodb-recovery.html
- InnoDB: about forcing recovery.
- 05:08:45 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.
- key_buffer_size=8388608
- read_buffer_size=131072
- max_used_connections=3
- max_threads=151
- thread_count=3
- connection_count=2
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67867 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7f9a25530e00
- 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 = 70000c331eb0 thread_stack 0x46000
- 0 mysqld 0x000000010e270d4c my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x000000010d69e456 handle_fatal_signal + 678
- 2 libsystem_platform.dylib 0x00007fff7a571b3d _sigtramp + 29
- 3 ??? 0x00000001155f4bc6 0x0 + 4653534150
- 4 libsystem_c.dylib 0x00007fff7a42f1c9 abort + 127
- 5 mysqld 0x000000010e619e99 ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 329
- 6 mysqld 0x000000010e3b1c1a dict_table_add_to_cache(dict_table_t*, unsigned long, mem_block_info_t*) + 490
- 7 mysqld 0x000000010e3d76c1 dict_table_t* dd_open_table_one<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::__1::deque<char const*, ut_allocator<char const*> >&) + 7409
- 8 mysqld 0x000000010e3c8448 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 72
- 9 mysqld 0x000000010e4827ad ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2797
- 10 mysqld 0x000000010d2814f7 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x000000010d644b25 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3621
- 12 mysqld 0x000000010d4d1906 open_table(THD*, TABLE_LIST*, Open_table_context*) + 6406
- 13 mysqld 0x000000010d4d6283 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 1955
- 14 mysqld 0x000000010d4d854d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 109
- 15 mysqld 0x000000010d59f4eb Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x000000010d59fbbe Sql_cmd_dml::execute(THD*) + 350
- 17 mysqld 0x000000010d5579a1 mysql_execute_command(THD*, bool) + 3937
- 18 mysqld 0x000000010d555403 mysql_parse(THD*, Parser_state*, bool) + 915
- 19 mysqld 0x000000010d55307d dispatch_command(THD*, COM_DATA const*, enum_server_command) + 4173
- 20 mysqld 0x000000010d554c83 do_command(THD*) + 467
- 21 mysqld 0x000000010d686744 handle_connection(void*) + 388
- 22 mysqld 0x000000010e67eadc pfs_spawn_thread(void*) + 316
- 23 libsystem_pthread.dylib 0x00007fff7a57a305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff7a57d26f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff7a579415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7f9a25554028): SELECT 1 FROM director_link WHERE actor_id=10966 AND media_id=3426 AND media_type='episode'
- Connection ID (thread ID): 61
- Status: NOT_KILLED
- The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
- information that should help you find out what is causing the crash.
- 2018-11-21T05:08:46.265280Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 40561
- 2018-11-21T05:08:46.275596Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-21T05:08:47.339631Z 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2018-11-21T05:08:47.349222Z 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2018-11-21T05:08:47.359866Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-21T05:08:47.366523Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-21T05:08:47.384538Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-21T05:08:47.390709Z 7 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-21T05:08:47.585148Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-21T05:08:51.630486Z 9 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1226:table2 == NULL thread 123145329303552
- 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/8.0/en/forcing-innodb-recovery.html
- InnoDB: about forcing recovery.
- 05:08:51 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.
- key_buffer_size=8388608
- read_buffer_size=131072
- max_used_connections=4
- max_threads=151
- thread_count=2
- connection_count=1
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67867 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7fc925883800
- 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 = 7000019bdeb0 thread_stack 0x46000
- 0 mysqld 0x0000000103442d4c my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000102870456 handle_fatal_signal + 678
- 2 libsystem_platform.dylib 0x00007fff7a571b3d _sigtramp + 29
- 3 ??? 0x000000010fe9bbc6 0x0 + 4561943494
- 4 libsystem_c.dylib 0x00007fff7a42f1c9 abort + 127
- 5 mysqld 0x00000001037ebe99 ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 329
- 6 mysqld 0x0000000103583c1a dict_table_add_to_cache(dict_table_t*, unsigned long, mem_block_info_t*) + 490
- 7 mysqld 0x00000001035a96c1 dict_table_t* dd_open_table_one<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::__1::deque<char const*, ut_allocator<char const*> >&) + 7409
- 8 mysqld 0x000000010359a448 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 72
- 9 mysqld 0x00000001036547ad ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2797
- 10 mysqld 0x00000001024534f7 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x0000000102816b25 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3621
- 12 mysqld 0x00000001026a3906 open_table(THD*, TABLE_LIST*, Open_table_context*) + 6406
- 13 mysqld 0x00000001026a8283 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 1955
- 14 mysqld 0x00000001026aa54d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 109
- 15 mysqld 0x00000001027714eb Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x0000000102771bbe Sql_cmd_dml::execute(THD*) + 350
- 17 mysqld 0x00000001027299a1 mysql_execute_command(THD*, bool) + 3937
- 18 mysqld 0x0000000102727403 mysql_parse(THD*, Parser_state*, bool) + 915
- 19 mysqld 0x000000010272507d dispatch_command(THD*, COM_DATA const*, enum_server_command) + 4173
- 20 mysqld 0x0000000102726c83 do_command(THD*) + 467
- 21 mysqld 0x0000000102858744 handle_connection(void*) + 388
- 22 mysqld 0x0000000103850adc pfs_spawn_thread(void*) + 316
- 23 libsystem_pthread.dylib 0x00007fff7a57a305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff7a57d26f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff7a579415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7fc92a300828): SELECT actor.name, actor_link.role, actor_link.cast_order, actor.art_urls, art.url FROM actor_link JOIN actor ON actor_link.actor_id=actor.actor_id LEFT JOIN art ON art.media_id=actor.actor_id AND art.media_type='actor' AND art.type='thumb' WHERE actor_link.media_id=1 AND actor_link.media_type='tvshow'ORDER BY actor_link.cast_order
- Connection ID (thread ID): 9
- Status: NOT_KILLED
- The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
- information that should help you find out what is causing the crash.
- 2018-11-21T05:08:56.916575Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 40564
- 2018-11-21T05:08:56.919415Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-21T05:08:57.288403Z 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2018-11-21T05:08:57.297028Z 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2018-11-21T05:08:57.304503Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-21T05:08:57.309976Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-21T05:08:57.321873Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-21T05:08:57.547416Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-21T05:09:35.536178Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-24T05:49:11.047013Z 606 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1226:table2 == NULL thread 123145351864320
- 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/8.0/en/forcing-innodb-recovery.html
- InnoDB: about forcing recovery.
- 05:49: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.
- key_buffer_size=8388608
- read_buffer_size=131072
- max_used_connections=4
- max_threads=151
- thread_count=4
- connection_count=3
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67867 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7fd14660c600
- 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 = 700002f41eb0 thread_stack 0x46000
- 0 mysqld 0x0000000108093d4c my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x00000001074c1456 handle_fatal_signal + 678
- 2 libsystem_platform.dylib 0x00007fff7a571b3d _sigtramp + 29
- 3 ??? 0x00000001111d1bc6 0x0 + 4582087622
- 4 libsystem_c.dylib 0x00007fff7a42f1c9 abort + 127
- 5 mysqld 0x000000010843ce99 ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 329
- 6 mysqld 0x00000001081d4c1a dict_table_add_to_cache(dict_table_t*, unsigned long, mem_block_info_t*) + 490
- 7 mysqld 0x00000001081fa6c1 dict_table_t* dd_open_table_one<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::__1::deque<char const*, ut_allocator<char const*> >&) + 7409
- 8 mysqld 0x00000001081eb448 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 72
- 9 mysqld 0x00000001082a57ad ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2797
- 10 mysqld 0x00000001070a44f7 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x0000000107467b25 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3621
- 12 mysqld 0x00000001072f4906 open_table(THD*, TABLE_LIST*, Open_table_context*) + 6406
- 13 mysqld 0x00000001072f9283 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 1955
- 14 mysqld 0x00000001072fb54d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 109
- 15 mysqld 0x00000001073c24eb Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x00000001073c2bbe Sql_cmd_dml::execute(THD*) + 350
- 17 mysqld 0x000000010737ac22 mysql_execute_command(THD*, bool) + 4578
- 18 mysqld 0x0000000107378403 mysql_parse(THD*, Parser_state*, bool) + 915
- 19 mysqld 0x000000010737607d dispatch_command(THD*, COM_DATA const*, enum_server_command) + 4173
- 20 mysqld 0x0000000107377c83 do_command(THD*) + 467
- 21 mysqld 0x00000001074a9744 handle_connection(void*) + 388
- 22 mysqld 0x00000001084a1adc pfs_spawn_thread(void*) + 316
- 23 libsystem_pthread.dylib 0x00007fff7a57a305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff7a57d26f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff7a579415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7fd1468e1428): DELETE from genre_link WHERE media_id=53 AND media_type='tvshow'
- Connection ID (thread ID): 606
- Status: NOT_KILLED
- The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
- information that should help you find out what is causing the crash.
- 2018-11-24T05:49:11.376846Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 74020
- 2018-11-24T05:49:11.383700Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-24T05:49:12.277418Z 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2018-11-24T05:49:12.286108Z 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2018-11-24T05:49:12.295256Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-24T05:49:12.303244Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-24T05:49:12.314815Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-24T05:49:12.504193Z 7 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
- 2018-11-24T05:49:12.524917Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-24T05:49:23.862932Z 11 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1226:table2 == NULL thread 123145525391360
- 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/8.0/en/forcing-innodb-recovery.html
- InnoDB: about forcing recovery.
- 05:49:23 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.
- key_buffer_size=8388608
- read_buffer_size=131072
- max_used_connections=3
- max_threads=151
- thread_count=2
- connection_count=1
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67867 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7f8338cbc800
- 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 = 70000d4beeb0 thread_stack 0x46000
- 0 mysqld 0x0000000101a4fd4c my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000100e7d456 handle_fatal_signal + 678
- 2 libsystem_platform.dylib 0x00007fff7a571b3d _sigtramp + 29
- 3 ??? 0x000000010e975bc6 0x0 + 4539767750
- 4 libsystem_c.dylib 0x00007fff7a42f1c9 abort + 127
- 5 mysqld 0x0000000101df8e99 ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 329
- 6 mysqld 0x0000000101b90c1a dict_table_add_to_cache(dict_table_t*, unsigned long, mem_block_info_t*) + 490
- 7 mysqld 0x0000000101bb66c1 dict_table_t* dd_open_table_one<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::__1::deque<char const*, ut_allocator<char const*> >&) + 7409
- 8 mysqld 0x0000000101ba7448 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 72
- 9 mysqld 0x0000000101c617ad ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2797
- 10 mysqld 0x0000000100a604f7 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x0000000100e23b25 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3621
- 12 mysqld 0x0000000100cb0906 open_table(THD*, TABLE_LIST*, Open_table_context*) + 6406
- 13 mysqld 0x0000000100cb5283 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 1955
- 14 mysqld 0x0000000100cb754d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 109
- 15 mysqld 0x0000000100d7e4eb Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x0000000100d7ebbe Sql_cmd_dml::execute(THD*) + 350
- 17 mysqld 0x0000000100d369a1 mysql_execute_command(THD*, bool) + 3937
- 18 mysqld 0x0000000100d34403 mysql_parse(THD*, Parser_state*, bool) + 915
- 19 mysqld 0x0000000100d3207d dispatch_command(THD*, COM_DATA const*, enum_server_command) + 4173
- 20 mysqld 0x0000000100d33c83 do_command(THD*) + 467
- 21 mysqld 0x0000000100e65744 handle_connection(void*) + 388
- 22 mysqld 0x0000000101e5dadc pfs_spawn_thread(void*) + 316
- 23 libsystem_pthread.dylib 0x00007fff7a57a305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff7a57d26f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff7a579415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7f8338d2a828): select * from movie_view WHERE playCount > 0
- Connection ID (thread ID): 11
- Status: NOT_KILLED
- The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
- information that should help you find out what is causing the crash.
- 2018-11-24T05:49:24.145181Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 74021
- 2018-11-24T05:49:24.147923Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-24T05:49:25.029293Z 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2018-11-24T05:49:25.037878Z 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2018-11-24T05:49:25.046954Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-24T05:49:25.053017Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-24T05:49:25.063593Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-24T05:49:25.281437Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-24T05:54:53.558663Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
- 2018-11-24T05:55:00.685603Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) starting as process 74080
- 2018-11-24T05:55:00.688514Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
- 2018-11-24T05:55:00.904790Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2018-11-24T05:55:00.910424Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/usr/local/mysql/data' in the path is accessible to all OS users. Consider choosing a different directory.
- 2018-11-24T05:55:00.922335Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.13' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
- 2018-11-24T05:55:01.138686Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2018-11-24T05:55:14.394010Z 8 [Warning] [MY-010055] [Server] IP address '192.168.1.5' could not be resolved: nodename nor servname provided, or not known
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement