Guest User

Untitled

a guest
Mar 5th, 2019
170
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2019-03-04T13:42:20.6NZ mysqld_safe Logging to '/usr/local/var/mysql/miniserver.local.err'.
  2. 2019-03-04T13:42:20.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
  3. 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
  4. 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
  5. 2019-03-04T14:42:41.981616+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  6. 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.
  7. 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
  8. 2019-03-05T22:25:26.982397+01:00 11299 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145518362624
  9. InnoDB: We intentionally generate a memory trap.
  10. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  11. InnoDB: If you get repeated assertion failures or crashes, even
  12. InnoDB: immediately after the mysqld startup, there may be
  13. InnoDB: corruption in the InnoDB tablespace. Please refer to
  14. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  15. InnoDB: about forcing recovery.
  16. 21:25:26 UTC - mysqld got signal 6 ;
  17. This could be because you hit a bug. It is also possible that this binary
  18. or one of the libraries it was linked against is corrupt, improperly built,
  19. or misconfigured. This error can also be caused by malfunctioning hardware.
  20. Attempting to collect some information that could help diagnose the problem.
  21. As this is a crash and something is definitely wrong, the information
  22. collection process might fail.
  23.  
  24. key_buffer_size=8388608
  25. read_buffer_size=131072
  26. max_used_connections=20
  27. max_threads=151
  28. thread_count=8
  29. connection_count=7
  30. It is possible that mysqld could use up to
  31. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  32. Hope that's ok; if not, decrease some variables in the equation.
  33.  
  34. Thread pointer: 0x7ff6930f7200
  35. Attempting backtrace. You can use the following information to find out
  36. where mysqld died. If you see no messages after this, something went
  37. terribly wrong...
  38. stack_bottom = 70000ce0aeb0 thread_stack 0x46000
  39. 0 mysqld 0x000000010249e748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  40. 1 mysqld 0x0000000101b03c20 handle_fatal_signal + 688
  41. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  42. 3 ??? 0x0000000110a3b380 0x0 + 4574131072
  43. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  44. 5 mysqld 0x000000010279acac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  45. 6 mysqld 0x000000010259b45b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  46. 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
  47. 8 mysqld 0x00000001025ab144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  48. 9 mysqld 0x0000000102642be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  49. 10 mysqld 0x00000001017efb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  50. 11 mysqld 0x0000000101abe6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  51. 12 mysqld 0x000000010199a9f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  52. 13 mysqld 0x000000010199e4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  53. 14 mysqld 0x00000001019a089d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  54. 15 mysqld 0x0000000101a3bde1 Sql_cmd_dml::prepare(THD*) + 75
  55. 16 mysqld 0x0000000101a3c2d7 Sql_cmd_dml::execute(THD*) + 237
  56. 17 mysqld 0x0000000101a02a54 mysql_execute_command(THD*, bool) + 3771
  57. 18 mysqld 0x0000000101a00b1c mysql_parse(THD*, Parser_state*, bool) + 838
  58. 19 mysqld 0x00000001019ff8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  59. 20 mysqld 0x0000000101a0047f do_command(THD*) + 293
  60. 21 mysqld 0x0000000101af0eff handle_connection(void*) + 368
  61. 22 mysqld 0x00000001027ef43b pfs_spawn_thread(void*) + 321
  62. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  63. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  64. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  65.  
  66. Trying to get some variables.
  67. Some pointers may be invalid and cause the dump to abort.
  68. Query (7ff691792a28): DELETE FROM director_link WHERE media_id=12 AND media_type='tvshow'
  69. Connection ID (thread ID): 11299
  70. Status: NOT_KILLED
  71.  
  72. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  73. information that should help you find out what is causing the crash.
  74. 2019-03-05T21:25:27.6NZ mysqld_safe mysqld restarted
  75. 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
  76. 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
  77. 2019-03-05T22:25:39.166765+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  78. 2019-03-05T22:25:39.194024+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  79. 2019-03-05T22:25:39.348821+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  80. 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.
  81. 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
  82. 2019-03-05T22:25:43.495427+01:00 10 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145481494528
  83. InnoDB: We intentionally generate a memory trap.
  84. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  85. InnoDB: If you get repeated assertion failures or crashes, even
  86. InnoDB: immediately after the mysqld startup, there may be
  87. InnoDB: corruption in the InnoDB tablespace. Please refer to
  88. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  89. InnoDB: about forcing recovery.
  90. 21:25:43 UTC - mysqld got signal 6 ;
  91. This could be because you hit a bug. It is also possible that this binary
  92. or one of the libraries it was linked against is corrupt, improperly built,
  93. or misconfigured. This error can also be caused by malfunctioning hardware.
  94. Attempting to collect some information that could help diagnose the problem.
  95. As this is a crash and something is definitely wrong, the information
  96. collection process might fail.
  97.  
  98. key_buffer_size=8388608
  99. read_buffer_size=131072
  100. max_used_connections=2
  101. max_threads=151
  102. thread_count=2
  103. connection_count=1
  104. It is possible that mysqld could use up to
  105. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  106. Hope that's ok; if not, decrease some variables in the equation.
  107.  
  108. Thread pointer: 0x7f9f4ef1e200
  109. Attempting backtrace. You can use the following information to find out
  110. where mysqld died. If you see no messages after this, something went
  111. terribly wrong...
  112. stack_bottom = 70000aae1eb0 thread_stack 0x46000
  113. 0 mysqld 0x000000010c910748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  114. 1 mysqld 0x000000010bf75c20 handle_fatal_signal + 688
  115. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  116. 3 ??? 0x00000001113d9380 0x0 + 4584215424
  117. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  118. 5 mysqld 0x000000010cc0ccac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  119. 6 mysqld 0x000000010ca0d45b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  120. 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
  121. 8 mysqld 0x000000010ca1d144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  122. 9 mysqld 0x000000010cab4be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  123. 10 mysqld 0x000000010bc61b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  124. 11 mysqld 0x000000010bf306b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  125. 12 mysqld 0x000000010be0c9f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  126. 13 mysqld 0x000000010be104c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  127. 14 mysqld 0x000000010be1289d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  128. 15 mysqld 0x000000010beadde1 Sql_cmd_dml::prepare(THD*) + 75
  129. 16 mysqld 0x000000010beae2d7 Sql_cmd_dml::execute(THD*) + 237
  130. 17 mysqld 0x000000010be74a07 mysql_execute_command(THD*, bool) + 3694
  131. 18 mysqld 0x000000010be72b1c mysql_parse(THD*, Parser_state*, bool) + 838
  132. 19 mysqld 0x000000010be718b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  133. 20 mysqld 0x000000010be7247f do_command(THD*) + 293
  134. 21 mysqld 0x000000010bf62eff handle_connection(void*) + 368
  135. 22 mysqld 0x000000010cc6143b pfs_spawn_thread(void*) + 321
  136. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  137. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  138. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  139.  
  140. Trying to get some variables.
  141. Some pointers may be invalid and cause the dump to abort.
  142. Query (7f9f4efa2a28): select * from movie_view
  143. Connection ID (thread ID): 10
  144. Status: NOT_KILLED
  145.  
  146. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  147. information that should help you find out what is causing the crash.
  148. 2019-03-05T21:25:43.6NZ mysqld_safe mysqld restarted
  149. 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
  150. 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
  151. 2019-03-05T22:25:49.474991+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  152. 2019-03-05T22:25:49.501650+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  153. 2019-03-05T22:25:49.526962+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  154. 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.
  155. 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
  156. 2019-03-05T22:25:54.628294+01:00 13 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145439277056
  157. InnoDB: We intentionally generate a memory trap.
  158. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  159. InnoDB: If you get repeated assertion failures or crashes, even
  160. InnoDB: immediately after the mysqld startup, there may be
  161. InnoDB: corruption in the InnoDB tablespace. Please refer to
  162. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  163. InnoDB: about forcing recovery.
  164. 21:25:54 UTC - mysqld got signal 6 ;
  165. This could be because you hit a bug. It is also possible that this binary
  166. or one of the libraries it was linked against is corrupt, improperly built,
  167. or misconfigured. This error can also be caused by malfunctioning hardware.
  168. Attempting to collect some information that could help diagnose the problem.
  169. As this is a crash and something is definitely wrong, the information
  170. collection process might fail.
  171.  
  172. key_buffer_size=8388608
  173. read_buffer_size=131072
  174. max_used_connections=4
  175. max_threads=151
  176. thread_count=3
  177. connection_count=2
  178. It is possible that mysqld could use up to
  179. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  180. Hope that's ok; if not, decrease some variables in the equation.
  181.  
  182. Thread pointer: 0x7fddc6ba7800
  183. Attempting backtrace. You can use the following information to find out
  184. where mysqld died. If you see no messages after this, something went
  185. terribly wrong...
  186. stack_bottom = 70000829eeb0 thread_stack 0x46000
  187. 0 mysqld 0x0000000101dab748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  188. 1 mysqld 0x0000000101410c20 handle_fatal_signal + 688
  189. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  190. 3 ??? 0x00000001061e5380 0x0 + 4397618048
  191. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  192. 5 mysqld 0x00000001020a7cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  193. 6 mysqld 0x0000000101ea845b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  194. 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
  195. 8 mysqld 0x0000000101eb8144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  196. 9 mysqld 0x0000000101f4fbe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  197. 10 mysqld 0x00000001010fcb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  198. 11 mysqld 0x00000001013cb6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  199. 12 mysqld 0x00000001012a79f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  200. 13 mysqld 0x00000001012ab4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  201. 14 mysqld 0x00000001012ad89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  202. 15 mysqld 0x0000000101348de1 Sql_cmd_dml::prepare(THD*) + 75
  203. 16 mysqld 0x00000001013492d7 Sql_cmd_dml::execute(THD*) + 237
  204. 17 mysqld 0x000000010130fa07 mysql_execute_command(THD*, bool) + 3694
  205. 18 mysqld 0x000000010130db1c mysql_parse(THD*, Parser_state*, bool) + 838
  206. 19 mysqld 0x000000010130c8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  207. 20 mysqld 0x000000010130d47f do_command(THD*) + 293
  208. 21 mysqld 0x00000001013fdeff handle_connection(void*) + 368
  209. 22 mysqld 0x00000001020fc43b pfs_spawn_thread(void*) + 321
  210. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  211. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  212. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  213.  
  214. Trying to get some variables.
  215. Some pointers may be invalid and cause the dump to abort.
  216. Query (7fddc8502028): select * from episode_view ORDER BY dateAdded desc, idEpisode desc LIMIT 10
  217. Connection ID (thread ID): 13
  218. Status: NOT_KILLED
  219.  
  220. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  221. information that should help you find out what is causing the crash.
  222. 2019-03-05T21:25:54.6NZ mysqld_safe mysqld restarted
  223. 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
  224. 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
  225. 2019-03-05T22:25:58.807728+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  226. 2019-03-05T22:25:58.835078+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  227. 2019-03-05T22:25:58.861719+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  228. 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.
  229. 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
  230. 2019-03-05T22:26:52.138627+01:00 19 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145363304448
  231. InnoDB: We intentionally generate a memory trap.
  232. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  233. InnoDB: If you get repeated assertion failures or crashes, even
  234. InnoDB: immediately after the mysqld startup, there may be
  235. InnoDB: corruption in the InnoDB tablespace. Please refer to
  236. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  237. InnoDB: about forcing recovery.
  238. 21:26:52 UTC - mysqld got signal 6 ;
  239. This could be because you hit a bug. It is also possible that this binary
  240. or one of the libraries it was linked against is corrupt, improperly built,
  241. or misconfigured. This error can also be caused by malfunctioning hardware.
  242. Attempting to collect some information that could help diagnose the problem.
  243. As this is a crash and something is definitely wrong, the information
  244. collection process might fail.
  245.  
  246. key_buffer_size=8388608
  247. read_buffer_size=131072
  248. max_used_connections=3
  249. max_threads=151
  250. thread_count=3
  251. connection_count=2
  252. It is possible that mysqld could use up to
  253. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  254. Hope that's ok; if not, decrease some variables in the equation.
  255.  
  256. Thread pointer: 0x7fe374596800
  257. Attempting backtrace. You can use the following information to find out
  258. where mysqld died. If you see no messages after this, something went
  259. terribly wrong...
  260. stack_bottom = 700003a2aeb0 thread_stack 0x46000
  261. 0 mysqld 0x0000000106e1d748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  262. 1 mysqld 0x0000000106482c20 handle_fatal_signal + 688
  263. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  264. 3 ??? 0x000000010f4a0380 0x0 + 4551476096
  265. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  266. 5 mysqld 0x0000000107119cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  267. 6 mysqld 0x0000000106f1a45b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  268. 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
  269. 8 mysqld 0x0000000106f2a144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  270. 9 mysqld 0x0000000106fc1be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  271. 10 mysqld 0x000000010616eb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  272. 11 mysqld 0x000000010643d6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  273. 12 mysqld 0x00000001063199f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  274. 13 mysqld 0x000000010631d4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  275. 14 mysqld 0x000000010631f89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  276. 15 mysqld 0x00000001063bade1 Sql_cmd_dml::prepare(THD*) + 75
  277. 16 mysqld 0x00000001063bb2d7 Sql_cmd_dml::execute(THD*) + 237
  278. 17 mysqld 0x0000000106381a07 mysql_execute_command(THD*, bool) + 3694
  279. 18 mysqld 0x000000010637fb1c mysql_parse(THD*, Parser_state*, bool) + 838
  280. 19 mysqld 0x000000010637e8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  281. 20 mysqld 0x000000010637f47f do_command(THD*) + 293
  282. 21 mysqld 0x000000010646feff handle_connection(void*) + 368
  283. 22 mysqld 0x000000010716e43b pfs_spawn_thread(void*) + 321
  284. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  285. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  286. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  287.  
  288. Trying to get some variables.
  289. Some pointers may be invalid and cause the dump to abort.
  290. Query (7fe374817c28): SELECT * FROM tvshow_view
  291. Connection ID (thread ID): 19
  292. Status: NOT_KILLED
  293.  
  294. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  295. information that should help you find out what is causing the crash.
  296. 2019-03-05T21:26:52.6NZ mysqld_safe mysqld restarted
  297. 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
  298. 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
  299. 2019-03-05T22:26:55.927104+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  300. 2019-03-05T22:26:55.953271+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  301. 2019-03-05T22:26:55.980408+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  302. 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.
  303. 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
  304. 2019-03-05T22:26:57.893351+01:00 9 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145326616576
  305. InnoDB: We intentionally generate a memory trap.
  306. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  307. InnoDB: If you get repeated assertion failures or crashes, even
  308. InnoDB: immediately after the mysqld startup, there may be
  309. InnoDB: corruption in the InnoDB tablespace. Please refer to
  310. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  311. InnoDB: about forcing recovery.
  312. 21:26:57 UTC - mysqld got signal 6 ;
  313. This could be because you hit a bug. It is also possible that this binary
  314. or one of the libraries it was linked against is corrupt, improperly built,
  315. or misconfigured. This error can also be caused by malfunctioning hardware.
  316. Attempting to collect some information that could help diagnose the problem.
  317. As this is a crash and something is definitely wrong, the information
  318. collection process might fail.
  319.  
  320. key_buffer_size=8388608
  321. read_buffer_size=131072
  322. max_used_connections=1
  323. max_threads=151
  324. thread_count=2
  325. connection_count=1
  326. It is possible that mysqld could use up to
  327. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  328. Hope that's ok; if not, decrease some variables in the equation.
  329.  
  330. Thread pointer: 0x7ff7ecb78200
  331. Attempting backtrace. You can use the following information to find out
  332. where mysqld died. If you see no messages after this, something went
  333. terribly wrong...
  334. stack_bottom = 70000172deb0 thread_stack 0x46000
  335. 0 mysqld 0x000000010949a748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  336. 1 mysqld 0x0000000108affc20 handle_fatal_signal + 688
  337. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  338. 3 ??? 0x0000000114b8b380 0x0 + 4642616192
  339. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  340. 5 mysqld 0x0000000109796cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  341. 6 mysqld 0x000000010959745b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  342. 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
  343. 8 mysqld 0x00000001095a7144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  344. 9 mysqld 0x000000010963ebe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  345. 10 mysqld 0x00000001087ebb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  346. 11 mysqld 0x0000000108aba6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  347. 12 mysqld 0x00000001089969f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  348. 13 mysqld 0x000000010899a4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  349. 14 mysqld 0x000000010899c89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  350. 15 mysqld 0x0000000108a37de1 Sql_cmd_dml::prepare(THD*) + 75
  351. 16 mysqld 0x0000000108a382d7 Sql_cmd_dml::execute(THD*) + 237
  352. 17 mysqld 0x00000001089fea07 mysql_execute_command(THD*, bool) + 3694
  353. 18 mysqld 0x00000001089fcb1c mysql_parse(THD*, Parser_state*, bool) + 838
  354. 19 mysqld 0x00000001089fb8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  355. 20 mysqld 0x00000001089fc47f do_command(THD*) + 293
  356. 21 mysqld 0x0000000108aeceff handle_connection(void*) + 368
  357. 22 mysqld 0x00000001097eb43b pfs_spawn_thread(void*) + 321
  358. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  359. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  360. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  361.  
  362. Trying to get some variables.
  363. Some pointers may be invalid and cause the dump to abort.
  364. 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
  365. Connection ID (thread ID): 9
  366. Status: NOT_KILLED
  367.  
  368. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  369. information that should help you find out what is causing the crash.
  370. 2019-03-05T21:26:57.6NZ mysqld_safe mysqld restarted
  371. 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
  372. 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
  373. 2019-03-05T22:26:59.917272+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  374. 2019-03-05T22:26:59.944386+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  375. 2019-03-05T22:26:59.972591+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  376. 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.
  377. 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
  378. 2019-03-05T22:27:01.763709+01:00 11 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145480679424
  379. InnoDB: We intentionally generate a memory trap.
  380. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  381. InnoDB: If you get repeated assertion failures or crashes, even
  382. InnoDB: immediately after the mysqld startup, there may be
  383. InnoDB: corruption in the InnoDB tablespace. Please refer to
  384. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  385. InnoDB: about forcing recovery.
  386. 21:27:01 UTC - mysqld got signal 6 ;
  387. This could be because you hit a bug. It is also possible that this binary
  388. or one of the libraries it was linked against is corrupt, improperly built,
  389. or misconfigured. This error can also be caused by malfunctioning hardware.
  390. Attempting to collect some information that could help diagnose the problem.
  391. As this is a crash and something is definitely wrong, the information
  392. collection process might fail.
  393.  
  394. key_buffer_size=8388608
  395. read_buffer_size=131072
  396. max_used_connections=2
  397. max_threads=151
  398. thread_count=3
  399. connection_count=2
  400. It is possible that mysqld could use up to
  401. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  402. Hope that's ok; if not, decrease some variables in the equation.
  403.  
  404. Thread pointer: 0x7faeb8eb8000
  405. Attempting backtrace. You can use the following information to find out
  406. where mysqld died. If you see no messages after this, something went
  407. terribly wrong...
  408. stack_bottom = 70000aa1aeb0 thread_stack 0x46000
  409. 0 mysqld 0x0000000109038748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  410. 1 mysqld 0x000000010869dc20 handle_fatal_signal + 688
  411. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  412. 3 ??? 0x0000000111caa380 0x0 + 4593460096
  413. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  414. 5 mysqld 0x0000000109334cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  415. 6 mysqld 0x000000010913545b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  416. 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
  417. 8 mysqld 0x0000000109145144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  418. 9 mysqld 0x00000001091dcbe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  419. 10 mysqld 0x0000000108389b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  420. 11 mysqld 0x00000001086586b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  421. 12 mysqld 0x00000001085349f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  422. 13 mysqld 0x00000001085384c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  423. 14 mysqld 0x000000010853a89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  424. 15 mysqld 0x00000001085d5de1 Sql_cmd_dml::prepare(THD*) + 75
  425. 16 mysqld 0x00000001085d62d7 Sql_cmd_dml::execute(THD*) + 237
  426. 17 mysqld 0x000000010859ca07 mysql_execute_command(THD*, bool) + 3694
  427. 18 mysqld 0x000000010859ab1c mysql_parse(THD*, Parser_state*, bool) + 838
  428. 19 mysqld 0x00000001085998b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  429. 20 mysqld 0x000000010859a47f do_command(THD*) + 293
  430. 21 mysqld 0x000000010868aeff handle_connection(void*) + 368
  431. 22 mysqld 0x000000010938943b pfs_spawn_thread(void*) + 321
  432. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  433. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  434. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  435.  
  436. Trying to get some variables.
  437. Some pointers may be invalid and cause the dump to abort.
  438. Query (7faeba43b228): SELECT * FROM tvshow_view
  439. Connection ID (thread ID): 11
  440. Status: NOT_KILLED
  441.  
  442. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  443. information that should help you find out what is causing the crash.
  444. 2019-03-05T21:27:01.6NZ mysqld_safe mysqld restarted
  445. 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
  446. 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
  447. 2019-03-05T22:27:03.972162+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  448. 2019-03-05T22:27:03.999376+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  449. 2019-03-05T22:27:04.026956+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  450. 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.
  451. 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
  452. 2019-03-05T22:27:08.257280+01:00 14 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145346654208
  453. InnoDB: We intentionally generate a memory trap.
  454. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  455. InnoDB: If you get repeated assertion failures or crashes, even
  456. InnoDB: immediately after the mysqld startup, there may be
  457. InnoDB: corruption in the InnoDB tablespace. Please refer to
  458. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  459. InnoDB: about forcing recovery.
  460. 21:27:08 UTC - mysqld got signal 6 ;
  461. This could be because you hit a bug. It is also possible that this binary
  462. or one of the libraries it was linked against is corrupt, improperly built,
  463. or misconfigured. This error can also be caused by malfunctioning hardware.
  464. Attempting to collect some information that could help diagnose the problem.
  465. As this is a crash and something is definitely wrong, the information
  466. collection process might fail.
  467.  
  468. key_buffer_size=8388608
  469. read_buffer_size=131072
  470. max_used_connections=2
  471. max_threads=151
  472. thread_count=3
  473. connection_count=2
  474. It is possible that mysqld could use up to
  475. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  476. Hope that's ok; if not, decrease some variables in the equation.
  477.  
  478. Thread pointer: 0x7fb538a40000
  479. Attempting backtrace. You can use the following information to find out
  480. where mysqld died. If you see no messages after this, something went
  481. terribly wrong...
  482. stack_bottom = 700002a49eb0 thread_stack 0x46000
  483. 0 mysqld 0x00000001097cf748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  484. 1 mysqld 0x0000000108e34c20 handle_fatal_signal + 688
  485. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  486. 3 ??? 0x0000000111986380 0x0 + 4590166912
  487. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  488. 5 mysqld 0x0000000109acbcac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  489. 6 mysqld 0x00000001098cc45b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  490. 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
  491. 8 mysqld 0x00000001098dc144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  492. 9 mysqld 0x0000000109973be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  493. 10 mysqld 0x0000000108b20b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  494. 11 mysqld 0x0000000108def6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  495. 12 mysqld 0x0000000108ccb9f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  496. 13 mysqld 0x0000000108ccf4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  497. 14 mysqld 0x0000000108cd189d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  498. 15 mysqld 0x0000000108d6cde1 Sql_cmd_dml::prepare(THD*) + 75
  499. 16 mysqld 0x0000000108d6d2d7 Sql_cmd_dml::execute(THD*) + 237
  500. 17 mysqld 0x0000000108d33a07 mysql_execute_command(THD*, bool) + 3694
  501. 18 mysqld 0x0000000108d31b1c mysql_parse(THD*, Parser_state*, bool) + 838
  502. 19 mysqld 0x0000000108d308b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  503. 20 mysqld 0x0000000108d3147f do_command(THD*) + 293
  504. 21 mysqld 0x0000000108e21eff handle_connection(void*) + 368
  505. 22 mysqld 0x0000000109b2043b pfs_spawn_thread(void*) + 321
  506. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  507. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  508. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  509.  
  510. Trying to get some variables.
  511. Some pointers may be invalid and cause the dump to abort.
  512. Query (7fb5389cd828): select * from movie_view ORDER BY dateAdded desc, idMovie desc LIMIT 10
  513. Connection ID (thread ID): 14
  514. Status: NOT_KILLED
  515.  
  516. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  517. information that should help you find out what is causing the crash.
  518. 2019-03-05T21:27:08.6NZ mysqld_safe mysqld restarted
  519. 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
  520. 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
  521. 2019-03-05T22:27:10.307413+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  522. 2019-03-05T22:27:10.333873+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  523. 2019-03-05T22:27:10.361252+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  524. 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.
  525. 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
  526. 2019-03-05T22:27:21.381286+01:00 8 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145409622016
  527. InnoDB: We intentionally generate a memory trap.
  528. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  529. InnoDB: If you get repeated assertion failures or crashes, even
  530. InnoDB: immediately after the mysqld startup, there may be
  531. InnoDB: corruption in the InnoDB tablespace. Please refer to
  532. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  533. InnoDB: about forcing recovery.
  534. 21:27:21 UTC - mysqld got signal 6 ;
  535. This could be because you hit a bug. It is also possible that this binary
  536. or one of the libraries it was linked against is corrupt, improperly built,
  537. or misconfigured. This error can also be caused by malfunctioning hardware.
  538. Attempting to collect some information that could help diagnose the problem.
  539. As this is a crash and something is definitely wrong, the information
  540. collection process might fail.
  541.  
  542. key_buffer_size=8388608
  543. read_buffer_size=131072
  544. max_used_connections=1
  545. max_threads=151
  546. thread_count=2
  547. connection_count=1
  548. It is possible that mysqld could use up to
  549. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  550. Hope that's ok; if not, decrease some variables in the equation.
  551.  
  552. Thread pointer: 0x7fec44328e00
  553. Attempting backtrace. You can use the following information to find out
  554. where mysqld died. If you see no messages after this, something went
  555. terribly wrong...
  556. stack_bottom = 700006656eb0 thread_stack 0x46000
  557. 0 mysqld 0x000000010b505748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  558. 1 mysqld 0x000000010ab6ac20 handle_fatal_signal + 688
  559. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  560. 3 ??? 0x0000000119e8f380 0x0 + 4729664384
  561. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  562. 5 mysqld 0x000000010b801cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  563. 6 mysqld 0x000000010b60245b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  564. 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
  565. 8 mysqld 0x000000010b612144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  566. 9 mysqld 0x000000010b6a9be4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  567. 10 mysqld 0x000000010a856b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  568. 11 mysqld 0x000000010ab256b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  569. 12 mysqld 0x000000010aa019f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  570. 13 mysqld 0x000000010aa054c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  571. 14 mysqld 0x000000010aa0789d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  572. 15 mysqld 0x000000010aaa2de1 Sql_cmd_dml::prepare(THD*) + 75
  573. 16 mysqld 0x000000010aaa32d7 Sql_cmd_dml::execute(THD*) + 237
  574. 17 mysqld 0x000000010aa69a07 mysql_execute_command(THD*, bool) + 3694
  575. 18 mysqld 0x000000010aa67b1c mysql_parse(THD*, Parser_state*, bool) + 838
  576. 19 mysqld 0x000000010aa668b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  577. 20 mysqld 0x000000010aa6747f do_command(THD*) + 293
  578. 21 mysqld 0x000000010ab57eff handle_connection(void*) + 368
  579. 22 mysqld 0x000000010b85643b pfs_spawn_thread(void*) + 321
  580. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  581. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  582. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  583.  
  584. Trying to get some variables.
  585. Some pointers may be invalid and cause the dump to abort.
  586. Query (7fec44324628): select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet ORDER BY sets.idSet
  587. Connection ID (thread ID): 8
  588. Status: NOT_KILLED
  589.  
  590. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  591. information that should help you find out what is causing the crash.
  592. 2019-03-05T21:27:21.6NZ mysqld_safe mysqld restarted
  593. 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
  594. 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
  595. 2019-03-05T22:27:23.490885+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  596. 2019-03-05T22:27:23.517230+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  597. 2019-03-05T22:27:23.543579+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  598. 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.
  599. 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
  600. 2019-03-05T22:30:00.493321+01:00 15 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145539186688
  601. InnoDB: We intentionally generate a memory trap.
  602. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  603. InnoDB: If you get repeated assertion failures or crashes, even
  604. InnoDB: immediately after the mysqld startup, there may be
  605. InnoDB: corruption in the InnoDB tablespace. Please refer to
  606. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  607. InnoDB: about forcing recovery.
  608. 21:30:00 UTC - mysqld got signal 6 ;
  609. This could be because you hit a bug. It is also possible that this binary
  610. or one of the libraries it was linked against is corrupt, improperly built,
  611. or misconfigured. This error can also be caused by malfunctioning hardware.
  612. Attempting to collect some information that could help diagnose the problem.
  613. As this is a crash and something is definitely wrong, the information
  614. collection process might fail.
  615.  
  616. key_buffer_size=8388608
  617. read_buffer_size=131072
  618. max_used_connections=6
  619. max_threads=151
  620. thread_count=7
  621. connection_count=6
  622. It is possible that mysqld could use up to
  623. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  624. Hope that's ok; if not, decrease some variables in the equation.
  625.  
  626. Thread pointer: 0x7feb48e8d800
  627. Attempting backtrace. You can use the following information to find out
  628. where mysqld died. If you see no messages after this, something went
  629. terribly wrong...
  630. stack_bottom = 70000e1e6eb0 thread_stack 0x46000
  631. 0 mysqld 0x000000010ed68748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  632. 1 mysqld 0x000000010e3cdc20 handle_fatal_signal + 688
  633. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  634. 3 ??? 0x0000000111aec380 0x0 + 4591633280
  635. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  636. 5 mysqld 0x000000010f064cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  637. 6 mysqld 0x000000010ee6545b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  638. 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
  639. 8 mysqld 0x000000010ee75144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  640. 9 mysqld 0x000000010ef0cbe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  641. 10 mysqld 0x000000010e0b9b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  642. 11 mysqld 0x000000010e3886b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  643. 12 mysqld 0x000000010e2649f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  644. 13 mysqld 0x000000010e2684c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  645. 14 mysqld 0x000000010e26a89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  646. 15 mysqld 0x000000010e305de1 Sql_cmd_dml::prepare(THD*) + 75
  647. 16 mysqld 0x000000010e3062d7 Sql_cmd_dml::execute(THD*) + 237
  648. 17 mysqld 0x000000010e2cca07 mysql_execute_command(THD*, bool) + 3694
  649. 18 mysqld 0x000000010e2cab1c mysql_parse(THD*, Parser_state*, bool) + 838
  650. 19 mysqld 0x000000010e2c98b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  651. 20 mysqld 0x000000010e2ca47f do_command(THD*) + 293
  652. 21 mysqld 0x000000010e3baeff handle_connection(void*) + 368
  653. 22 mysqld 0x000000010f0b943b pfs_spawn_thread(void*) + 321
  654. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  655. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  656. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  657.  
  658. Trying to get some variables.
  659. Some pointers may be invalid and cause the dump to abort.
  660. Query (7feb4abef628): select * from movie_view
  661. Connection ID (thread ID): 15
  662. Status: NOT_KILLED
  663.  
  664. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  665. information that should help you find out what is causing the crash.
  666. 2019-03-05T21:30:00.6NZ mysqld_safe mysqld restarted
  667. 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
  668. 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
  669. 2019-03-05T22:30:02.997645+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  670. 2019-03-05T22:30:03.024082+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  671. 2019-03-05T22:30:03.051584+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  672. 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.
  673. 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
  674. 2019-03-05T22:30:10.491050+01:00 12 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145323704320
  675. InnoDB: We intentionally generate a memory trap.
  676. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  677. InnoDB: If you get repeated assertion failures or crashes, even
  678. InnoDB: immediately after the mysqld startup, there may be
  679. InnoDB: corruption in the InnoDB tablespace. Please refer to
  680. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  681. InnoDB: about forcing recovery.
  682. 21:30:10 UTC - mysqld got signal 6 ;
  683. This could be because you hit a bug. It is also possible that this binary
  684. or one of the libraries it was linked against is corrupt, improperly built,
  685. or misconfigured. This error can also be caused by malfunctioning hardware.
  686. Attempting to collect some information that could help diagnose the problem.
  687. As this is a crash and something is definitely wrong, the information
  688. collection process might fail.
  689.  
  690. key_buffer_size=8388608
  691. read_buffer_size=131072
  692. max_used_connections=1
  693. max_threads=151
  694. thread_count=2
  695. connection_count=1
  696. It is possible that mysqld could use up to
  697. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  698. Hope that's ok; if not, decrease some variables in the equation.
  699.  
  700. Thread pointer: 0x7f90b0803600
  701. Attempting backtrace. You can use the following information to find out
  702. where mysqld died. If you see no messages after this, something went
  703. terribly wrong...
  704. stack_bottom = 700001466eb0 thread_stack 0x46000
  705. 0 mysqld 0x00000001018f7748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  706. 1 mysqld 0x0000000100f5cc20 handle_fatal_signal + 688
  707. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  708. 3 ??? 0x0000000110e54380 0x0 + 4578427776
  709. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  710. 5 mysqld 0x0000000101bf3cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  711. 6 mysqld 0x00000001019f445b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  712. 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
  713. 8 mysqld 0x0000000101a04144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  714. 9 mysqld 0x0000000101a9bbe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  715. 10 mysqld 0x0000000100c48b59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  716. 11 mysqld 0x0000000100f176b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  717. 12 mysqld 0x0000000100df39f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  718. 13 mysqld 0x0000000100df74c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  719. 14 mysqld 0x0000000100df989d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  720. 15 mysqld 0x0000000100e94de1 Sql_cmd_dml::prepare(THD*) + 75
  721. 16 mysqld 0x0000000100e952d7 Sql_cmd_dml::execute(THD*) + 237
  722. 17 mysqld 0x0000000100e5ba07 mysql_execute_command(THD*, bool) + 3694
  723. 18 mysqld 0x0000000100e59b1c mysql_parse(THD*, Parser_state*, bool) + 838
  724. 19 mysqld 0x0000000100e588b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  725. 20 mysqld 0x0000000100e5947f do_command(THD*) + 293
  726. 21 mysqld 0x0000000100f49eff handle_connection(void*) + 368
  727. 22 mysqld 0x0000000101c4843b pfs_spawn_thread(void*) + 321
  728. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  729. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  730. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  731.  
  732. Trying to get some variables.
  733. Some pointers may be invalid and cause the dump to abort.
  734. 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
  735. Connection ID (thread ID): 12
  736. Status: NOT_KILLED
  737.  
  738. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  739. information that should help you find out what is causing the crash.
  740. 2019-03-05T21:30:10.6NZ mysqld_safe mysqld restarted
  741. 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
  742. 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
  743. 2019-03-05T22:30:12.887813+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  744. 2019-03-05T22:30:12.915344+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  745. 2019-03-05T22:30:12.955068+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  746. 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.
  747. 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
  748. 2019-03-05T22:31:43.827572+01:00 10 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1230:table2 == NULL thread 123145523470336
  749. InnoDB: We intentionally generate a memory trap.
  750. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  751. InnoDB: If you get repeated assertion failures or crashes, even
  752. InnoDB: immediately after the mysqld startup, there may be
  753. InnoDB: corruption in the InnoDB tablespace. Please refer to
  754. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  755. InnoDB: about forcing recovery.
  756. 21:31:43 UTC - mysqld got signal 6 ;
  757. This could be because you hit a bug. It is also possible that this binary
  758. or one of the libraries it was linked against is corrupt, improperly built,
  759. or misconfigured. This error can also be caused by malfunctioning hardware.
  760. Attempting to collect some information that could help diagnose the problem.
  761. As this is a crash and something is definitely wrong, the information
  762. collection process might fail.
  763.  
  764. key_buffer_size=8388608
  765. read_buffer_size=131072
  766. max_used_connections=1
  767. max_threads=151
  768. thread_count=2
  769. connection_count=1
  770. It is possible that mysqld could use up to
  771. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67874 K bytes of memory
  772. Hope that's ok; if not, decrease some variables in the equation.
  773.  
  774. Thread pointer: 0x7fa325aace00
  775. Attempting backtrace. You can use the following information to find out
  776. where mysqld died. If you see no messages after this, something went
  777. terribly wrong...
  778. stack_bottom = 70000d2e9eb0 thread_stack 0x46000
  779. 0 mysqld 0x00000001105aa748 my_print_stacktrace(unsigned char*, unsigned long) + 60
  780. 1 mysqld 0x000000010fc0fc20 handle_fatal_signal + 688
  781. 2 libsystem_platform.dylib 0x00007fff76a14b3d _sigtramp + 29
  782. 3 ??? 0x000000011e5ea380 0x0 + 4804486016
  783. 4 libsystem_c.dylib 0x00007fff768d21c9 abort + 127
  784. 5 mysqld 0x00000001108a6cac ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 332
  785. 6 mysqld 0x00000001106a745b dict_make_room_in_cache(unsigned long, unsigned long) + 0
  786. 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
  787. 8 mysqld 0x00000001106b7144 dict_table_t* dd_open_table<dd::Table>(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*) + 60
  788. 9 mysqld 0x000000011074ebe4 ha_innobase::open(char const*, int, unsigned int, dd::Table const*) + 2792
  789. 10 mysqld 0x000000010f8fbb59 handler::ha_open(TABLE*, char const*, int, int, dd::Table const*) + 87
  790. 11 mysqld 0x000000010fbca6b8 open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*) + 3267
  791. 12 mysqld 0x000000010faa69f6 open_table(THD*, TABLE_LIST*, Open_table_context*) + 5139
  792. 13 mysqld 0x000000010faaa4c6 open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*) + 859
  793. 14 mysqld 0x000000010faac89d open_tables_for_query(THD*, TABLE_LIST*, unsigned int) + 111
  794. 15 mysqld 0x000000010fb47de1 Sql_cmd_dml::prepare(THD*) + 75
  795. 16 mysqld 0x000000010fb482d7 Sql_cmd_dml::execute(THD*) + 237
  796. 17 mysqld 0x000000010fb0ea07 mysql_execute_command(THD*, bool) + 3694
  797. 18 mysqld 0x000000010fb0cb1c mysql_parse(THD*, Parser_state*, bool) + 838
  798. 19 mysqld 0x000000010fb0b8b3 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 6323
  799. 20 mysqld 0x000000010fb0c47f do_command(THD*) + 293
  800. 21 mysqld 0x000000010fbfceff handle_connection(void*) + 368
  801. 22 mysqld 0x00000001108fb43b pfs_spawn_thread(void*) + 321
  802. 23 libsystem_pthread.dylib 0x00007fff76a1d305 _pthread_body + 126
  803. 24 libsystem_pthread.dylib 0x00007fff76a2026f _pthread_start + 70
  804. 25 libsystem_pthread.dylib 0x00007fff76a1c415 thread_start + 13
  805.  
  806. Trying to get some variables.
  807. Some pointers may be invalid and cause the dump to abort.
  808. Query (7fa325d91628): select * from movie_view WHERE ((movie_view.playCount IS NULL OR movie_view.playCount < 1))
  809. Connection ID (thread ID): 10
  810. Status: NOT_KILLED
  811.  
  812. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  813. information that should help you find out what is causing the crash.
  814. 2019-03-05T21:31:43.6NZ mysqld_safe mysqld restarted
  815. 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
  816. 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
  817. 2019-03-05T22:31:46.537591+01:00 0 [System] [MY-010229] [Server] Starting crash recovery...
  818. 2019-03-05T22:31:46.567699+01:00 0 [System] [MY-010232] [Server] Crash recovery finished.
  819. 2019-03-05T22:31:46.595023+01:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  820. 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.
  821. 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
RAW Paste Data