Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2019-03-04T13:42:20.6NZ mysqld_safe Logging to '/usr/local/var/mysql/miniserver.local.err'.
- 2019-03-04T13:42:20.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
- 2019-03-04T14:42:21.403495+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 1443
- 2019-03-04T14:42:21.641153+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-04T14:42:41.981616+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-04T14:42:42.675092+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-04T14:42:42.758078+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:25:26.982397+01:00 11299 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145518362624
- 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.
- 21:25:26 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=20
- max_threads=151
- thread_count=8
- connection_count=7
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7ff6930f7200
- 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 = 70000ce0aeb0 thread_stack 0x46000
- 0 mysqld 0x000000010249e748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000101b03c20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x0000000110a3b380 0x0 + 4574131072
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x000000010279acac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x000000010259b45b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x00000001025b8acc 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*> >&) + 6557
- 8 mysqld 0x00000001025ab144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x0000000102642be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x00000001017efb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x0000000101abe6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x000000010199a9f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x000000010199e4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x00000001019a089d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x0000000101a3bde1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x0000000101a3c2d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x0000000101a02a54 mysql_execute_command(THD*, bool) + 3771
- 18 mysqld 0x0000000101a00b1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x00000001019ff8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x0000000101a0047f do_command(THD*) + 293
- 21 mysqld 0x0000000101af0eff handle_connection(void*) + 368
- 22 mysqld 0x00000001027ef43b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7ff691792a28): DELETE FROM director_link WHERE media_id=12 AND media_type='tvshow'
- Connection ID (thread ID): 11299
- 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.
- 2019-03-05T21:25:27.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:25:28.714886+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28665
- 2019-03-05T22:25:28.900985+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:25:39.166765+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:25:39.194024+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:25:39.348821+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:25:39.737581+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:25:39.870878+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:25:43.495427+01:00 10 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145481494528
- 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.
- 21:25:43 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=2
- 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 = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7f9f4ef1e200
- 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 = 70000aae1eb0 thread_stack 0x46000
- 0 mysqld 0x000000010c910748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x000000010bf75c20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x00000001113d9380 0x0 + 4584215424
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x000000010cc0ccac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x000000010ca0d45b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x000000010ca2aacc 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*> >&) + 6557
- 8 mysqld 0x000000010ca1d144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x000000010cab4be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x000000010bc61b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x000000010bf306b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x000000010be0c9f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x000000010be104c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x000000010be1289d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x000000010beadde1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x000000010beae2d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x000000010be74a07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x000000010be72b1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x000000010be718b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x000000010be7247f do_command(THD*) + 293
- 21 mysqld 0x000000010bf62eff handle_connection(void*) + 368
- 22 mysqld 0x000000010cc6143b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7f9f4efa2a28): select * from movie_view
- Connection ID (thread ID): 10
- 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.
- 2019-03-05T21:25:43.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:25:44.636660+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28688
- 2019-03-05T22:25:44.675155+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:25:49.474991+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:25:49.501650+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:25:49.526962+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:25:49.579850+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:25:49.702927+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:25:54.628294+01:00 13 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145439277056
- 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.
- 21:25:54 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=3
- connection_count=2
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7fddc6ba7800
- 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 = 70000829eeb0 thread_stack 0x46000
- 0 mysqld 0x0000000101dab748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000101410c20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x00000001061e5380 0x0 + 4397618048
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x00000001020a7cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x0000000101ea845b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x0000000101ec5acc 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*> >&) + 6557
- 8 mysqld 0x0000000101eb8144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x0000000101f4fbe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x00000001010fcb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x00000001013cb6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x00000001012a79f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x00000001012ab4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x00000001012ad89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x0000000101348de1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x00000001013492d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x000000010130fa07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x000000010130db1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x000000010130c8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x000000010130d47f do_command(THD*) + 293
- 21 mysqld 0x00000001013fdeff handle_connection(void*) + 368
- 22 mysqld 0x00000001020fc43b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7fddc8502028): select * from episode_view ORDER BY dateAdded desc, idEpisode desc LIMIT 10
- Connection ID (thread ID): 13
- 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.
- 2019-03-05T21:25:54.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:25:55.756077+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28707
- 2019-03-05T22:25:55.799649+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:25:58.807728+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:25:58.835078+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:25:58.861719+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:25:58.909577+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:25:59.035982+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:26:52.138627+01:00 19 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145363304448
- 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.
- 21:26:52 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 = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7fe374596800
- 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 = 700003a2aeb0 thread_stack 0x46000
- 0 mysqld 0x0000000106e1d748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000106482c20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x000000010f4a0380 0x0 + 4551476096
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x0000000107119cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x0000000106f1a45b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x0000000106f37acc 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*> >&) + 6557
- 8 mysqld 0x0000000106f2a144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x0000000106fc1be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x000000010616eb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x000000010643d6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x00000001063199f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x000000010631d4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x000000010631f89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x00000001063bade1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x00000001063bb2d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x0000000106381a07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x000000010637fb1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x000000010637e8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x000000010637f47f do_command(THD*) + 293
- 21 mysqld 0x000000010646feff handle_connection(void*) + 368
- 22 mysqld 0x000000010716e43b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7fe374817c28): SELECT * FROM tvshow_view
- Connection ID (thread ID): 19
- 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.
- 2019-03-05T21:26:52.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:26:52.989308+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28744
- 2019-03-05T22:26:53.029525+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:26:55.927104+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:26:55.953271+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:26:55.980408+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:26:56.037440+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:26:56.150023+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:26:57.893351+01:00 9 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145326616576
- 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.
- 21:26:57 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=1
- 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 = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7ff7ecb78200
- 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 = 70000172deb0 thread_stack 0x46000
- 0 mysqld 0x000000010949a748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000108affc20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x0000000114b8b380 0x0 + 4642616192
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x0000000109796cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x000000010959745b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x00000001095b4acc 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*> >&) + 6557
- 8 mysqld 0x00000001095a7144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x000000010963ebe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x00000001087ebb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x0000000108aba6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x00000001089969f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x000000010899a4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x000000010899c89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x0000000108a37de1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x0000000108a382d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x00000001089fea07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x00000001089fcb1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x00000001089fb8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x00000001089fc47f do_command(THD*) + 293
- 21 mysqld 0x0000000108aeceff handle_connection(void*) + 368
- 22 mysqld 0x00000001097eb43b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7ff7ec97fa28): SELECT movie_view.idSet,COUNT(1) AS c FROM movie_view JOIN sets ON sets.idSet = movie_view.idSet GROUP BY movie_view.idSet HAVING c>1
- 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.
- 2019-03-05T21:26:57.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:26:58.582592+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28756
- 2019-03-05T22:26:58.590121+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:26:59.917272+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:26:59.944386+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:26:59.972591+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:27:00.021302+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:27:00.144732+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:27:01.763709+01:00 11 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145480679424
- 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.
- 21:27:01 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=2
- 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 = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7faeb8eb8000
- 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 = 70000aa1aeb0 thread_stack 0x46000
- 0 mysqld 0x0000000109038748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x000000010869dc20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x0000000111caa380 0x0 + 4593460096
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x0000000109334cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x000000010913545b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x0000000109152acc 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*> >&) + 6557
- 8 mysqld 0x0000000109145144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x00000001091dcbe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x0000000108389b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x00000001086586b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x00000001085349f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x00000001085384c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x000000010853a89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x00000001085d5de1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x00000001085d62d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x000000010859ca07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x000000010859ab1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x00000001085998b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x000000010859a47f do_command(THD*) + 293
- 21 mysqld 0x000000010868aeff handle_connection(void*) + 368
- 22 mysqld 0x000000010938943b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7faeba43b228): SELECT * FROM tvshow_view
- 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.
- 2019-03-05T21:27:01.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:27:02.453312+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28768
- 2019-03-05T22:27:02.460798+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:27:03.972162+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:27:03.999376+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:27:04.026956+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:27:04.074710+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:27:04.200550+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:27:08.257280+01:00 14 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145346654208
- 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.
- 21:27:08 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=2
- 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 = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7fb538a40000
- 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 = 700002a49eb0 thread_stack 0x46000
- 0 mysqld 0x00000001097cf748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000108e34c20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x0000000111986380 0x0 + 4590166912
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x0000000109acbcac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x00000001098cc45b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x00000001098e9acc 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*> >&) + 6557
- 8 mysqld 0x00000001098dc144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x0000000109973be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x0000000108b20b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x0000000108def6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x0000000108ccb9f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x0000000108ccf4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x0000000108cd189d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x0000000108d6cde1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x0000000108d6d2d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x0000000108d33a07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x0000000108d31b1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x0000000108d308b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x0000000108d3147f do_command(THD*) + 293
- 21 mysqld 0x0000000108e21eff handle_connection(void*) + 368
- 22 mysqld 0x0000000109b2043b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7fb5389cd828): select * from movie_view ORDER BY dateAdded desc, idMovie desc LIMIT 10
- Connection ID (thread ID): 14
- 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.
- 2019-03-05T21:27:08.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:27:08.950324+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28787
- 2019-03-05T22:27:08.957684+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:27:10.307413+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:27:10.333873+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:27:10.361252+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:27:10.408881+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:27:10.536047+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:27:21.381286+01:00 8 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145409622016
- 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.
- 21:27:21 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=1
- 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 = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7fec44328e00
- 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 = 700006656eb0 thread_stack 0x46000
- 0 mysqld 0x000000010b505748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x000000010ab6ac20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x0000000119e8f380 0x0 + 4729664384
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x000000010b801cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x000000010b60245b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x000000010b61facc 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*> >&) + 6557
- 8 mysqld 0x000000010b612144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x000000010b6a9be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x000000010a856b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x000000010ab256b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x000000010aa019f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x000000010aa054c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x000000010aa0789d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x000000010aaa2de1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x000000010aaa32d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x000000010aa69a07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x000000010aa67b1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x000000010aa668b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x000000010aa6747f do_command(THD*) + 293
- 21 mysqld 0x000000010ab57eff handle_connection(void*) + 368
- 22 mysqld 0x000000010b85643b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7fec44324628): select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet ORDER BY sets.idSet
- Connection ID (thread ID): 8
- 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.
- 2019-03-05T21:27:21.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:27:22.149261+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28801
- 2019-03-05T22:27:22.156690+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:27:23.490885+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:27:23.517230+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:27:23.543579+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:27:23.591298+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:27:23.720583+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:30:00.493321+01:00 15 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145539186688
- 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.
- 21:30:00 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=6
- max_threads=151
- thread_count=7
- connection_count=6
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7feb48e8d800
- 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 = 70000e1e6eb0 thread_stack 0x46000
- 0 mysqld 0x000000010ed68748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x000000010e3cdc20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x0000000111aec380 0x0 + 4591633280
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x000000010f064cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x000000010ee6545b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x000000010ee82acc 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*> >&) + 6557
- 8 mysqld 0x000000010ee75144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x000000010ef0cbe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x000000010e0b9b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x000000010e3886b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x000000010e2649f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x000000010e2684c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x000000010e26a89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x000000010e305de1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x000000010e3062d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x000000010e2cca07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x000000010e2cab1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x000000010e2c98b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x000000010e2ca47f do_command(THD*) + 293
- 21 mysqld 0x000000010e3baeff handle_connection(void*) + 368
- 22 mysqld 0x000000010f0b943b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7feb4abef628): select * from movie_view
- Connection ID (thread ID): 15
- 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.
- 2019-03-05T21:30:00.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:30:01.533660+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28864
- 2019-03-05T22:30:01.541397+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:30:02.997645+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:30:03.024082+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:30:03.051584+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:30:03.104468+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:30:03.265725+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:30:10.491050+01:00 12 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145323704320
- 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.
- 21:30:10 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=1
- 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 = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7f90b0803600
- 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 = 700001466eb0 thread_stack 0x46000
- 0 mysqld 0x00000001018f7748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x0000000100f5cc20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x0000000110e54380 0x0 + 4578427776
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x0000000101bf3cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x00000001019f445b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x0000000101a11acc 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*> >&) + 6557
- 8 mysqld 0x0000000101a04144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x0000000101a9bbe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x0000000100c48b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x0000000100f176b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x0000000100df39f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x0000000100df74c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x0000000100df989d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x0000000100e94de1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x0000000100e952d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x0000000100e5ba07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x0000000100e59b1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x0000000100e588b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x0000000100e5947f do_command(THD*) + 293
- 21 mysqld 0x0000000100f49eff handle_connection(void*) + 368
- 22 mysqld 0x0000000101c4843b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7f90b0ddce28): SELECT movie_view.idSet,COUNT(1) AS c FROM movie_view JOIN sets ON sets.idSet = movie_view.idSet GROUP BY movie_view.idSet HAVING c>1
- Connection ID (thread ID): 12
- 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.
- 2019-03-05T21:30:10.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:30:11.450494+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28883
- 2019-03-05T22:30:11.457831+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:30:12.887813+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:30:12.915344+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:30:12.955068+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:30:13.001279+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:30:13.116068+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
- 2019-03-05T22:31:43.827572+01:00 10 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145523470336
- 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.
- 21:31:43 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=1
- 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 = 67874 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x7fa325aace00
- 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 = 70000d2e9eb0 thread_stack 0x46000
- 0 mysqld 0x00000001105aa748 my_print_stacktrace(unsigned char*, unsigned long) + 60
- 1 mysqld 0x000000010fc0fc20 handle_fatal_signal + 688
- 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
- 3 ??? 0x000000011e5ea380 0x0 + 4804486016
- 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
- 5 mysqld 0x00000001108a6cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
- 6 mysqld 0x00000001106a745b dict_make_room_in_cache(unsigned long, unsigned long) + 0
- 7 mysqld 0x00000001106c4acc 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*> >&) + 6557
- 8 mysqld 0x00000001106b7144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
- 9 mysqld 0x000000011074ebe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
- 10 mysqld 0x000000010f8fbb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
- 11 mysqld 0x000000010fbca6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
- 12 mysqld 0x000000010faa69f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
- 13 mysqld 0x000000010faaa4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
- 14 mysqld 0x000000010faac89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
- 15 mysqld 0x000000010fb47de1 Sql_cmd_dml::prepare(THD*) + 75
- 16 mysqld 0x000000010fb482d7 Sql_cmd_dml::execute(THD*) + 237
- 17 mysqld 0x000000010fb0ea07 mysql_execute_command(THD*, bool) + 3694
- 18 mysqld 0x000000010fb0cb1c mysql_parse(THD*, Parser_state*, bool) + 838
- 19 mysqld 0x000000010fb0b8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
- 20 mysqld 0x000000010fb0c47f do_command(THD*) + 293
- 21 mysqld 0x000000010fbfceff handle_connection(void*) + 368
- 22 mysqld 0x00000001108fb43b pfs_spawn_thread(void*) + 321
- 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
- 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
- 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (7fa325d91628): select * from movie_view WHERE ((movie_view.playCount IS NULL OR movie_view.playCount < 1))
- Connection ID (thread ID): 10
- 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.
- 2019-03-05T21:31:43.6NZ mysqld_safe mysqld restarted
- 2019-03-05T22:31:44.893188+01:00 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.15) starting as process 28907
- 2019-03-05T22:31:44.902425+01:00 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
- 2019-03-05T22:31:46.537591+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
- 2019-03-05T22:31:46.567699+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
- 2019-03-05T22:31:46.595023+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2019-03-05T22:31:46.693247+01:00 0 [System] [MY-010931] [Server] /usr/local/opt/mysql/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Homebrew.
- 2019-03-05T22:31:46.765186+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement