Create a new version of paste:

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