InnoDB: Tablespace 27, name 'picore/ragendaitemcopresenters', file './picore/ragendaitemcopresenters.ibd' is missing! InnoDB: Tablespace 28, name 'picore/ragendaitemdocuments', file './picore/ragendaitemdocuments.ibd' is missing! InnoDB: Tablespace 29, name 'picore/ragendaitemnotes', file './picore/ragendaitemnotes.ibd' is missing! InnoDB: Tablespace 30, name 'picore/ragendaitempresenters', file './picore/ragendaitempresenters.ibd' is missing! InnoDB: Tablespace 31, name 'picore/rdocumentnotes', file './picore/rdocumentnotes.ibd' is missing! InnoDB: Tablespace 32, name 'picore/rlibrarylibrarians', file './picore/rlibrarylibrarians.ibd' is missing! InnoDB: Tablespace 33, name 'picore/rlibraryorganisers', file './picore/rlibraryorganisers.ibd' is missing! InnoDB: Tablespace 34, name 'picore/rlibrarysublibraries', file './picore/rlibrarysublibraries.ibd' is missing! InnoDB: Tablespace 35, name 'picore/rmeetingattendees', file './picore/rmeetingattendees.ibd' is missing! InnoDB: Tablespace 36, name 'picore/rmeetingcomments', file './picore/rmeetingcomments.ibd' is missing! InnoDB: Tablespace 37, name 'picore/rmeetingdocuments', file './picore/rmeetingdocuments.ibd' is missing! InnoDB: Tablespace 38, name 'picore/rmeetingnotes', file './picore/rmeetingnotes.ibd' is missing! InnoDB: Tablespace 39, name 'picore/rmeetingorganisers', file './picore/rmeetingorganisers.ibd' is missing! InnoDB: Tablespace 40, name 'piserver/deleted_meeting', file './piserver/deleted_meeting.ibd' is missing! [warn] kq_init: detected broken kqueue; not using.: No such file or directory Starting crash recovery... Crash recovery finished. CA certificate ca.pem is self signed. /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.12' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL. /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL. /usr/local/mysql/bin/mysqld (mysqld 8.0.12) starting as process 103 Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive InnoDB: Tablespace 2, name 'piclient/metadataactionpoint', file './piclient/metadataactionpoint.ibd' is missing! InnoDB: Tablespace 3, name 'piclient/metadataagendaitem', file './piclient/metadataagendaitem.ibd' is missing! InnoDB: Tablespace 4, name 'piclient/metadatadocument', file './piclient/metadatadocument.ibd' is missing! InnoDB: Tablespace 5, name 'piclient/metadatadocumentversion', file './piclient/metadatadocumentversion.ibd' is missing! InnoDB: Tablespace 6, name 'piclient/metadatalibrary', file './piclient/metadatalibrary.ibd' is missing! InnoDB: Tablespace 7, name 'piclient/metadatameeting', file './piclient/metadatameeting.ibd' is missing! InnoDB: Tablespace 8, name 'piclient/queuedelete', file './piclient/queuedelete.ibd' is missing! InnoDB: Tablespace 9, name 'piclient/queuenew', file './piclient/queuenew.ibd' is missing! InnoDB: Tablespace 10, name 'piclient/queueupdate', file './piclient/queueupdate.ibd' is missing! InnoDB: Tablespace 11, name 'picore/actionpoint', file './picore/actionpoint.ibd' is missing! InnoDB: Tablespace 12, name 'picore/agendaitem', file './picore/agendaitem.ibd' is missing! InnoDB: Tablespace 13, name 'picore/document', file './picore/document.ibd' is missing! InnoDB: Tablespace 14, name 'picore/documentversion', file './picore/documentversion.ibd' is missing! InnoDB: Tablespace 15, name 'picore/library', file './picore/library.ibd' is missing! InnoDB: Tablespace 16, name 'picore/lookupcontactmethod', file './picore/lookupcontactmethod.ibd' is missing! InnoDB: Tablespace 17, name 'picore/meeting', file './picore/meeting.ibd' is missing! InnoDB: Tablespace 18, name 'picore/note', file './picore/note.ibd' is missing! InnoDB: Tablespace 19, name 'picore/organisation', file './picore/organisation.ibd' is missing! InnoDB: Tablespace 20, name 'picore/person', file './picore/person.ibd' is missing! InnoDB: Tablespace 21, name 'picore/personcontactmethod', file './picore/personcontactmethod.ibd' is missing! InnoDB: Tablespace 22, name 'picore/ractionpointassignees', file './picore/ractionpointassignees.ibd' is missing! InnoDB: Tablespace 23, name 'picore/ractionpointdocuments', file './picore/ractionpointdocuments.ibd' is missing! InnoDB: Tablespace 24, name 'picore/ractionpointnotes', file './picore/ractionpointnotes.ibd' is missing! InnoDB: Tablespace 25, name 'picore/ragendaitemcomments', file './picore/ragendaitemcomments.ibd' is missing! InnoDB: Tablespace 26, name 'picore/ragendaitemcontributors', file './picore/ragendaitemcontributors.ibd' is missing! InnoDB: Tablespace 27, name 'picore/ragendaitemcopresenters', file './picore/ragendaitemcopresenters.ibd' is missing! InnoDB: Tablespace 28, name 'picore/ragendaitemdocuments', file './picore/ragendaitemdocuments.ibd' is missing! InnoDB: Tablespace 29, name 'picore/ragendaitemnotes', file './picore/ragendaitemnotes.ibd' is missing! InnoDB: Tablespace 30, name 'picore/ragendaitempresenters', file './picore/ragendaitempresenters.ibd' is missing! InnoDB: Tablespace 31, name 'picore/rdocumentnotes', file './picore/rdocumentnotes.ibd' is missing! InnoDB: Tablespace 32, name 'picore/rlibrarylibrarians', file './picore/rlibrarylibrarians.ibd' is missing! InnoDB: Tablespace 33, name 'picore/rlibraryorganisers', file './picore/rlibraryorganisers.ibd' is missing! InnoDB: Tablespace 34, name 'picore/rlibrarysublibraries', file './picore/rlibrarysublibraries.ibd' is missing! InnoDB: Tablespace 35, name 'picore/rmeetingattendees', file './picore/rmeetingattendees.ibd' is missing! InnoDB: Tablespace 36, name 'picore/rmeetingcomments', file './picore/rmeetingcomments.ibd' is missing! InnoDB: Tablespace 37, name 'picore/rmeetingdocuments', file './picore/rmeetingdocuments.ibd' is missing! InnoDB: Tablespace 38, name 'picore/rmeetingnotes', file './picore/rmeetingnotes.ibd' is missing! InnoDB: Tablespace 39, name 'picore/rmeetingorganisers', file './picore/rmeetingorganisers.ibd' is missing! InnoDB: Tablespace 40, name 'piserver/deleted_meeting', file './piserver/deleted_meeting.ibd' is missing! [warn] kq_init: detected broken kqueue; not using.: No such file or directory CA certificate ca.pem is self signed. /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.12' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL. InnoDB: Trying to access missing tablespace 2 InnoDB: Trying to access missing tablespace 3 InnoDB: Trying to access missing tablespace 4 InnoDB: Trying to access missing tablespace 5 InnoDB: Trying to access missing tablespace 6 InnoDB: Trying to access missing tablespace 7 InnoDB: Trying to access missing tablespace 8 InnoDB: Trying to access missing tablespace 9 InnoDB: Trying to access missing tablespace 10 InnoDB: Trying to access missing tablespace 11 InnoDB: Trying to access missing tablespace 12 InnoDB: Trying to access missing tablespace 13 InnoDB: Trying to access missing tablespace 14 InnoDB: Trying to access missing tablespace 15 InnoDB: Trying to access missing tablespace 16 InnoDB: Trying to access missing tablespace 17 InnoDB: Trying to access missing tablespace 18 InnoDB: Trying to access missing tablespace 19 InnoDB: Trying to access missing tablespace 20 InnoDB: Trying to access missing tablespace 21 InnoDB: Trying to access missing tablespace 22 InnoDB: Trying to access missing tablespace 23 InnoDB: Trying to access missing tablespace 24 InnoDB: Trying to access missing tablespace 25 InnoDB: Trying to access missing tablespace 26 InnoDB: Trying to access missing tablespace 27 InnoDB: Trying to access missing tablespace 28 InnoDB: Trying to access missing tablespace 29 InnoDB: Trying to access missing tablespace 30 InnoDB: Trying to access missing tablespace 31 InnoDB: Trying to access missing tablespace 32 InnoDB: Trying to access missing tablespace 33 InnoDB: Trying to access missing tablespace 34 InnoDB: Trying to access missing tablespace 35 InnoDB: Trying to access missing tablespace 36 InnoDB: Trying to access missing tablespace 37 InnoDB: Trying to access missing tablespace 38 InnoDB: Trying to access missing tablespace 39 InnoDB: Trying to access missing tablespace 40 InnoDB: Assertion failure: dict0dict.cc:3308:for_table || ref_table InnoDB: thread 123145453891584 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. 07:43:02 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=5 max_threads=151 thread_count=6 connection_count=5 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67870 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fb2cc99e200 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 = 70000908eeb0 thread_stack 0x46000 0 mysqld 0x00000001079285ec my_print_stacktrace(unsigned char*, unsigned long) + 60 1 mysqld 0x0000000106d85e76 handle_fatal_signal + 678 2 libsystem_platform.dylib 0x00007fff691a3b3d _sigtramp + 29 3 mysqld 0x0000000108c1c008 icu_59::RegexCompile::findCaseInsensitiveStarters(int, icu_59::UnicodeSet*)::RECaseFixData + 313656 4 libsystem_c.dylib 0x00007fff690621c9 abort + 127 5 mysqld 0x0000000107cb507c ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 252 6 mysqld 0x0000000107a6486b dict_foreign_add_to_cache(dict_foreign_t*, char const**, bool, bool, dict_err_ignore_t) + 1659 7 mysqld 0x0000000107a7c2df dd_table_load_fk_from_dd(dict_table_t*, dd::Table const*, char const**, dict_err_ignore_t, bool) + 1439 8 mysqld 0x0000000107a81d9b dict_table_t* dd_open_table_one(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::__1::deque >&) + 7963 9 mysqld 0x0000000107a7305c dd_table_open_on_dd_obj(dd::cache::Dictionary_client*, dd::Table const&, dd::Partition const*, char const*, dict_table_t*&, THD*) + 1996 10 mysqld 0x0000000107a75735 dd_table_open_on_name(THD*, MDL_ticket**, char const*, bool, unsigned long) + 1861 11 mysqld 0x0000000107b4db9b innobase_get_table_statistics(char const*, char const*, unsigned long long, dd::Properties const&, dd::Properties const&, unsigned int, ha_statistics*) + 1451 12 mysqld 0x00000001078e3e2b dd::info_schema::Table_statistics::read_stat_from_SE(THD*, String const&, String const&, String const&, String const&, unsigned int, unsigned int, unsigned long long, char const*, char const*, dd:: [truncated, 311 bytes total] 13 mysqld 0x00000001078e3705 dd::info_schema::Table_statistics::read_stat(THD*, String const&, String const&, String const&, char const*, String const&, unsigned int, unsigned int, String const&, unsigned long long, char const [truncated, 371 bytes total] 14 mysqld 0x0000000106a3ada2 dd::info_schema::Table_statistics::read_stat(THD*, String const&, String const&, String const&, char const*, unsigned long long, char const*, char const*, unsigned long long const&, unsigned long l [truncated, 313 bytes total] 15 mysqld 0x0000000106a3163e get_table_statistics(Item**, unsigned int, dd::info_schema::enum_table_stats_type, bool*) + 958 16 mysqld 0x0000000106a31258 Item_func_internal_table_rows::val_int() + 40 17 mysqld 0x00000001069cb015 Item::save_in_field_inner(Field*, bool) + 709 18 mysqld 0x00000001069cf70e Item_view_ref::save_in_field_inner(Field*, bool) + 78 19 mysqld 0x0000000106bf7aca end_write(JOIN*, QEP_TAB*, bool) + 346 20 mysqld 0x0000000106bf90fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 21 mysqld 0x0000000106bf8ae1 sub_select(JOIN*, QEP_TAB*, bool) + 913 22 mysqld 0x0000000106bf90fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 23 mysqld 0x0000000106bf8c4a sub_select(JOIN*, QEP_TAB*, bool) + 1274 24 mysqld 0x0000000106c16c75 JOIN_CACHE::join_null_complements(bool) + 405 25 mysqld 0x0000000106c16202 JOIN_CACHE::join_records(bool) + 498 26 mysqld 0x0000000106bf447b sub_select_op(JOIN*, QEP_TAB*, bool) + 75 27 mysqld 0x0000000106bf87d7 sub_select(JOIN*, QEP_TAB*, bool) + 135 28 mysqld 0x0000000106bf87d7 sub_select(JOIN*, QEP_TAB*, bool) + 135 29 mysqld 0x0000000106bf87d7 sub_select(JOIN*, QEP_TAB*, bool) + 135 30 mysqld 0x0000000106bf37f8 JOIN::exec() + 888 31 mysqld 0x0000000106c8c8c1 handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) + 545 32 mysqld 0x0000000106c4f420 execute_show(THD*, TABLE_LIST*) + 624 33 mysqld 0x0000000106c4a0a4 mysql_execute_command(THD*, bool) + 4580 34 mysqld 0x0000000106c47af6 mysql_parse(THD*, Parser_state*) + 886 35 mysqld 0x0000000106c46408 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 7544 36 mysqld 0x0000000106c47363 do_command(THD*) + 467 37 mysqld 0x0000000106d6f0e4 handle_connection(void*) + 372 38 mysqld 0x0000000107d1cbbc pfs_spawn_thread(void*) + 316 39 libsystem_pthread.dylib 0x00007fff691ac339 _pthread_body + 126 40 libsystem_pthread.dylib 0x00007fff691af2a7 _pthread_start + 70 41 libsystem_pthread.dylib 0x00007fff691ab445 thread_start + 13 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb2c94c5428): show table status like 'actionPoint' 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. /usr/local/mysql/bin/mysqld (mysqld 8.0.12) starting as process 531 Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive InnoDB: Tablespace 2, name 'piclient/metadataactionpoint', file './piclient/metadataactionpoint.ibd' is missing! InnoDB: Tablespace 3, name 'piclient/metadataagendaitem', file './piclient/metadataagendaitem.ibd' is missing! InnoDB: Tablespace 4, name 'piclient/metadatadocument', file './piclient/metadatadocument.ibd' is missing! InnoDB: Tablespace 5, name 'piclient/metadatadocumentversion', file './piclient/metadatadocumentversion.ibd' is missing! InnoDB: Tablespace 6, name 'piclient/metadatalibrary', file './piclient/metadatalibrary.ibd' is missing! InnoDB: Tablespace 7, name 'piclient/metadatameeting', file './piclient/metadatameeting.ibd' is missing! InnoDB: Tablespace 8, name 'piclient/queuedelete', file './piclient/queuedelete.ibd' is missing! InnoDB: Tablespace 9, name 'piclient/queuenew', file './piclient/queuenew.ibd' is missing! InnoDB: Tablespace 10, name 'piclient/queueupdate', file './piclient/queueupdate.ibd' is missing! InnoDB: Tablespace 11, name 'picore/actionpoint', file './picore/actionpoint.ibd' is missing! InnoDB: Tablespace 12, name 'picore/agendaitem', file './picore/agendaitem.ibd' is missing! InnoDB: Tablespace 13, name 'picore/document', file './picore/document.ibd' is missing! InnoDB: Tablespace 14, name 'picore/documentversion', file './picore/documentversion.ibd' is missing! InnoDB: Tablespace 15, name 'picore/library', file './picore/library.ibd' is missing! InnoDB: Tablespace 16, name 'picore/lookupcontactmethod', file './picore/lookupcontactmethod.ibd' is missing! InnoDB: Tablespace 17, name 'picore/meeting', file './picore/meeting.ibd' is missing! InnoDB: Tablespace 18, name 'picore/note', file './picore/note.ibd' is missing! InnoDB: Tablespace 19, name 'picore/organisation', file './picore/organisation.ibd' is missing! InnoDB: Tablespace 20, name 'picore/person', file './picore/person.ibd' is missing! InnoDB: Tablespace 21, name 'picore/personcontactmethod', file './picore/personcontactmethod.ibd' is missing! InnoDB: Tablespace 22, name 'picore/ractionpointassignees', file './picore/ractionpointassignees.ibd' is missing! InnoDB: Tablespace 23, name 'picore/ractionpointdocuments', file './picore/ractionpointdocuments.ibd' is missing! InnoDB: Tablespace 24, name 'picore/ractionpointnotes', file './picore/ractionpointnotes.ibd' is missing! InnoDB: Tablespace 25, name 'picore/ragendaitemcomments', file './picore/ragendaitemcomments.ibd' is missing! InnoDB: Tablespace 26, name 'picore/ragendaitemcontributors', file './picore/ragendaitemcontributors.ibd' is missing! InnoDB: Tablespace 27, name 'picore/ragendaitemcopresenters', file './picore/ragendaitemcopresenters.ibd' is missing! InnoDB: Tablespace 28, name 'picore/ragendaitemdocuments', file './picore/ragendaitemdocuments.ibd' is missing! InnoDB: Tablespace 29, name 'picore/ragendaitemnotes', file './picore/ragendaitemnotes.ibd' is missing! InnoDB: Tablespace 30, name 'picore/ragendaitempresenters', file './picore/ragendaitempresenters.ibd' is missing! InnoDB: Tablespace 31, name 'picore/rdocumentnotes', file './picore/rdocumentnotes.ibd' is missing! InnoDB: Tablespace 32, name 'picore/rlibrarylibrarians', file './picore/rlibrarylibrarians.ibd' is missing! InnoDB: Tablespace 33, name 'picore/rlibraryorganisers', file './picore/rlibraryorganisers.ibd' is missing! InnoDB: Tablespace 34, name 'picore/rlibrarysublibraries', file './picore/rlibrarysublibraries.ibd' is missing! InnoDB: Tablespace 35, name 'picore/rmeetingattendees', file './picore/rmeetingattendees.ibd' is missing! InnoDB: Tablespace 36, name 'picore/rmeetingcomments', file './picore/rmeetingcomments.ibd' is missing! InnoDB: Tablespace 37, name 'picore/rmeetingdocuments', file './picore/rmeetingdocuments.ibd' is missing! InnoDB: Tablespace 38, name 'picore/rmeetingnotes', file './picore/rmeetingnotes.ibd' is missing! InnoDB: Tablespace 39, name 'picore/rmeetingorganisers', file './picore/rmeetingorganisers.ibd' is missing! InnoDB: Tablespace 40, name 'piserver/deleted_meeting', file './piserver/deleted_meeting.ibd' is missing! [warn] kq_init: detected broken kqueue; not using.: No such file or directory Starting crash recovery... Crash recovery finished. CA certificate ca.pem is self signed. /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.12' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL. InnoDB: Trying to access missing tablespace 3 InnoDB: Trying to access missing tablespace 4 InnoDB: Trying to access missing tablespace 5 InnoDB: Trying to access missing tablespace 6 InnoDB: Trying to access missing tablespace 7 InnoDB: Trying to access missing tablespace 8 InnoDB: Trying to access missing tablespace 9 InnoDB: Trying to access missing tablespace 10 InnoDB: Trying to access missing tablespace 12 InnoDB: Trying to access missing tablespace 13 InnoDB: Trying to access missing tablespace 14 InnoDB: Trying to access missing tablespace 15 InnoDB: Trying to access missing tablespace 16 InnoDB: Trying to access missing tablespace 17 InnoDB: Trying to access missing tablespace 18 InnoDB: Trying to access missing tablespace 19 InnoDB: Trying to access missing tablespace 20 InnoDB: Trying to access missing tablespace 21 InnoDB: Trying to access missing tablespace 25 InnoDB: Trying to access missing tablespace 26 InnoDB: Trying to access missing tablespace 27 InnoDB: Trying to access missing tablespace 28 InnoDB: Trying to access missing tablespace 29 InnoDB: Trying to access missing tablespace 30 InnoDB: Trying to access missing tablespace 31 InnoDB: Trying to access missing tablespace 32 InnoDB: Trying to access missing tablespace 33 InnoDB: Trying to access missing tablespace 34 InnoDB: Trying to access missing tablespace 35 InnoDB: Trying to access missing tablespace 36 InnoDB: Trying to access missing tablespace 37 InnoDB: Trying to access missing tablespace 38 InnoDB: Trying to access missing tablespace 39 InnoDB: Trying to access missing tablespace 40 InnoDB: Assertion failure: dict0dict.cc:3308:for_table || ref_table InnoDB: thread 123145418919936 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. 07:44:48 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 = 67870 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fe75dbde600 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 = 700006f34eb0 thread_stack 0x46000 0 mysqld 0x000000010e68b5ec my_print_stacktrace(unsigned char*, unsigned long) + 60 1 mysqld 0x000000010dae8e76 handle_fatal_signal + 678 2 libsystem_platform.dylib 0x00007fff691a3b3d _sigtramp + 29 3 mysqld 0x000000010f885490 outputHexBytes(long long, int, char*, int*, int)::gHexChars + 29632 4 libsystem_c.dylib 0x00007fff690621c9 abort + 127 5 mysqld 0x000000010ea1807c ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 252 6 mysqld 0x000000010e7c786b dict_foreign_add_to_cache(dict_foreign_t*, char const**, bool, bool, dict_err_ignore_t) + 1659 7 mysqld 0x000000010e7df2df dd_table_load_fk_from_dd(dict_table_t*, dd::Table const*, char const**, dict_err_ignore_t, bool) + 1439 8 mysqld 0x000000010e7e4d9b dict_table_t* dd_open_table_one(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::__1::deque >&) + 7963 9 mysqld 0x000000010e7d605c dd_table_open_on_dd_obj(dd::cache::Dictionary_client*, dd::Table const&, dd::Partition const*, char const*, dict_table_t*&, THD*) + 1996 10 mysqld 0x000000010e7d8735 dd_table_open_on_name(THD*, MDL_ticket**, char const*, bool, unsigned long) + 1861 11 mysqld 0x000000010e8b0b9b innobase_get_table_statistics(char const*, char const*, unsigned long long, dd::Properties const&, dd::Properties const&, unsigned int, ha_statistics*) + 1451 12 mysqld 0x000000010e646e2b dd::info_schema::Table_statistics::read_stat_from_SE(THD*, String const&, String const&, String const&, String const&, unsigned int, unsigned int, unsigned long long, char const*, char const*, dd:: [truncated, 311 bytes total] 13 mysqld 0x000000010e646705 dd::info_schema::Table_statistics::read_stat(THD*, String const&, String const&, String const&, char const*, String const&, unsigned int, unsigned int, String const&, unsigned long long, char const [truncated, 371 bytes total] 14 mysqld 0x000000010d79dda2 dd::info_schema::Table_statistics::read_stat(THD*, String const&, String const&, String const&, char const*, unsigned long long, char const*, char const*, unsigned long long const&, unsigned long l [truncated, 313 bytes total] 15 mysqld 0x000000010d79463e get_table_statistics(Item**, unsigned int, dd::info_schema::enum_table_stats_type, bool*) + 958 16 mysqld 0x000000010d794258 Item_func_internal_table_rows::val_int() + 40 17 mysqld 0x000000010d72e015 Item::save_in_field_inner(Field*, bool) + 709 18 mysqld 0x000000010d73270e Item_view_ref::save_in_field_inner(Field*, bool) + 78 19 mysqld 0x000000010d95aaca end_write(JOIN*, QEP_TAB*, bool) + 346 20 mysqld 0x000000010d95c0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 21 mysqld 0x000000010d95bae1 sub_select(JOIN*, QEP_TAB*, bool) + 913 22 mysqld 0x000000010d95c0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 23 mysqld 0x000000010d95bc4a sub_select(JOIN*, QEP_TAB*, bool) + 1274 24 mysqld 0x000000010d95c0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 25 mysqld 0x000000010d95bc4a sub_select(JOIN*, QEP_TAB*, bool) + 1274 26 mysqld 0x000000010d95c0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 27 mysqld 0x000000010d95bae1 sub_select(JOIN*, QEP_TAB*, bool) + 913 28 mysqld 0x000000010d95c0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 29 mysqld 0x000000010d95bae1 sub_select(JOIN*, QEP_TAB*, bool) + 913 30 mysqld 0x000000010d95c0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 31 mysqld 0x000000010d95bae1 sub_select(JOIN*, QEP_TAB*, bool) + 913 32 mysqld 0x000000010d9567da JOIN::exec() + 858 33 mysqld 0x000000010d9ef8c1 handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) + 545 34 mysqld 0x000000010d9b2420 execute_show(THD*, TABLE_LIST*) + 624 35 mysqld 0x000000010d9ad0a4 mysql_execute_command(THD*, bool) + 4580 36 mysqld 0x000000010d9aaaf6 mysql_parse(THD*, Parser_state*) + 886 37 mysqld 0x000000010d9a9408 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 7544 38 mysqld 0x000000010d9aa363 do_command(THD*) + 467 39 mysqld 0x000000010dad20e4 handle_connection(void*) + 372 40 mysqld 0x000000010ea7fbbc pfs_spawn_thread(void*) + 316 41 libsystem_pthread.dylib 0x00007fff691ac339 _pthread_body + 126 42 libsystem_pthread.dylib 0x00007fff691af2a7 _pthread_start + 70 43 libsystem_pthread.dylib 0x00007fff691ab445 thread_start + 13 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fe75b4a7828): show table status like 'agendaItem' 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. /usr/local/mysql/bin/mysqld (mysqld 8.0.12) starting as process 544 Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive InnoDB: Tablespace 2, name 'piclient/metadataactionpoint', file './piclient/metadataactionpoint.ibd' is missing! InnoDB: Tablespace 3, name 'piclient/metadataagendaitem', file './piclient/metadataagendaitem.ibd' is missing! InnoDB: Tablespace 4, name 'piclient/metadatadocument', file './piclient/metadatadocument.ibd' is missing! InnoDB: Tablespace 5, name 'piclient/metadatadocumentversion', file './piclient/metadatadocumentversion.ibd' is missing! InnoDB: Tablespace 6, name 'piclient/metadatalibrary', file './piclient/metadatalibrary.ibd' is missing! InnoDB: Tablespace 7, name 'piclient/metadatameeting', file './piclient/metadatameeting.ibd' is missing! InnoDB: Tablespace 8, name 'piclient/queuedelete', file './piclient/queuedelete.ibd' is missing! InnoDB: Tablespace 9, name 'piclient/queuenew', file './piclient/queuenew.ibd' is missing! InnoDB: Tablespace 10, name 'piclient/queueupdate', file './piclient/queueupdate.ibd' is missing! InnoDB: Tablespace 11, name 'picore/actionpoint', file './picore/actionpoint.ibd' is missing! InnoDB: Tablespace 12, name 'picore/agendaitem', file './picore/agendaitem.ibd' is missing! InnoDB: Tablespace 13, name 'picore/document', file './picore/document.ibd' is missing! InnoDB: Tablespace 14, name 'picore/documentversion', file './picore/documentversion.ibd' is missing! InnoDB: Tablespace 15, name 'picore/library', file './picore/library.ibd' is missing! InnoDB: Tablespace 16, name 'picore/lookupcontactmethod', file './picore/lookupcontactmethod.ibd' is missing! InnoDB: Tablespace 17, name 'picore/meeting', file './picore/meeting.ibd' is missing! InnoDB: Tablespace 18, name 'picore/note', file './picore/note.ibd' is missing! InnoDB: Tablespace 19, name 'picore/organisation', file './picore/organisation.ibd' is missing! InnoDB: Tablespace 20, name 'picore/person', file './picore/person.ibd' is missing! InnoDB: Tablespace 21, name 'picore/personcontactmethod', file './picore/personcontactmethod.ibd' is missing! InnoDB: Tablespace 22, name 'picore/ractionpointassignees', file './picore/ractionpointassignees.ibd' is missing! InnoDB: Tablespace 23, name 'picore/ractionpointdocuments', file './picore/ractionpointdocuments.ibd' is missing! InnoDB: Tablespace 24, name 'picore/ractionpointnotes', file './picore/ractionpointnotes.ibd' is missing! InnoDB: Tablespace 25, name 'picore/ragendaitemcomments', file './picore/ragendaitemcomments.ibd' is missing! InnoDB: Tablespace 26, name 'picore/ragendaitemcontributors', file './picore/ragendaitemcontributors.ibd' is missing! InnoDB: Tablespace 27, name 'picore/ragendaitemcopresenters', file './picore/ragendaitemcopresenters.ibd' is missing! InnoDB: Tablespace 28, name 'picore/ragendaitemdocuments', file './picore/ragendaitemdocuments.ibd' is missing! InnoDB: Tablespace 29, name 'picore/ragendaitemnotes', file './picore/ragendaitemnotes.ibd' is missing! InnoDB: Tablespace 30, name 'picore/ragendaitempresenters', file './picore/ragendaitempresenters.ibd' is missing! InnoDB: Tablespace 31, name 'picore/rdocumentnotes', file './picore/rdocumentnotes.ibd' is missing! InnoDB: Tablespace 32, name 'picore/rlibrarylibrarians', file './picore/rlibrarylibrarians.ibd' is missing! InnoDB: Tablespace 33, name 'picore/rlibraryorganisers', file './picore/rlibraryorganisers.ibd' is missing! InnoDB: Tablespace 34, name 'picore/rlibrarysublibraries', file './picore/rlibrarysublibraries.ibd' is missing! InnoDB: Tablespace 35, name 'picore/rmeetingattendees', file './picore/rmeetingattendees.ibd' is missing! InnoDB: Tablespace 36, name 'picore/rmeetingcomments', file './picore/rmeetingcomments.ibd' is missing! InnoDB: Tablespace 37, name 'picore/rmeetingdocuments', file './picore/rmeetingdocuments.ibd' is missing! InnoDB: Tablespace 38, name 'picore/rmeetingnotes', file './picore/rmeetingnotes.ibd' is missing! InnoDB: Tablespace 39, name 'picore/rmeetingorganisers', file './picore/rmeetingorganisers.ibd' is missing! InnoDB: Tablespace 40, name 'piserver/deleted_meeting', file './piserver/deleted_meeting.ibd' is missing! [warn] kq_init: detected broken kqueue; not using.: No such file or directory Starting crash recovery... Crash recovery finished. CA certificate ca.pem is self signed. /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.12' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL. InnoDB: Trying to access missing tablespace 2 InnoDB: Trying to access missing tablespace 4 InnoDB: Trying to access missing tablespace 5 InnoDB: Trying to access missing tablespace 6 InnoDB: Trying to access missing tablespace 7 InnoDB: Trying to access missing tablespace 8 InnoDB: Trying to access missing tablespace 9 InnoDB: Trying to access missing tablespace 10 InnoDB: Trying to access missing tablespace 11 InnoDB: Trying to access missing tablespace 13 InnoDB: Trying to access missing tablespace 14 InnoDB: Trying to access missing tablespace 15 InnoDB: Trying to access missing tablespace 16 InnoDB: Trying to access missing tablespace 17 InnoDB: Trying to access missing tablespace 18 InnoDB: Trying to access missing tablespace 19 InnoDB: Trying to access missing tablespace 20 InnoDB: Trying to access missing tablespace 21 InnoDB: Trying to access missing tablespace 22 InnoDB: Trying to access missing tablespace 23 InnoDB: Trying to access missing tablespace 24 InnoDB: Trying to access missing tablespace 31 InnoDB: Trying to access missing tablespace 32 InnoDB: Trying to access missing tablespace 33 InnoDB: Trying to access missing tablespace 34 InnoDB: Trying to access missing tablespace 35 InnoDB: Trying to access missing tablespace 36 InnoDB: Trying to access missing tablespace 37 InnoDB: Trying to access missing tablespace 38 InnoDB: Trying to access missing tablespace 39 InnoDB: Trying to access missing tablespace 40 InnoDB: Assertion failure: dict0dict.cc:3308:for_table || ref_table InnoDB: thread 123145353748480 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. 07:45:05 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 = 67870 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fb2c62a4200 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 = 70000310deb0 thread_stack 0x46000 0 mysqld 0x00000001054dc5ec my_print_stacktrace(unsigned char*, unsigned long) + 60 1 mysqld 0x0000000104939e76 handle_fatal_signal + 678 2 libsystem_platform.dylib 0x00007fff691a3b3d _sigtramp + 29 3 mysqld 0x00000001067d0008 icu_59::RegexCompile::findCaseInsensitiveStarters(int, icu_59::UnicodeSet*)::RECaseFixData + 313656 4 libsystem_c.dylib 0x00007fff690621c9 abort + 127 5 mysqld 0x000000010586907c ut_dbg_assertion_failed(char const*, char const*, unsigned long) + 252 6 mysqld 0x000000010561886b dict_foreign_add_to_cache(dict_foreign_t*, char const**, bool, bool, dict_err_ignore_t) + 1659 7 mysqld 0x00000001056302df dd_table_load_fk_from_dd(dict_table_t*, dd::Table const*, char const**, dict_err_ignore_t, bool) + 1439 8 mysqld 0x0000000105635d9b dict_table_t* dd_open_table_one(dd::cache::Dictionary_client*, TABLE const*, char const*, dd::Table const*, THD*, std::__1::deque >&) + 7963 9 mysqld 0x000000010562705c dd_table_open_on_dd_obj(dd::cache::Dictionary_client*, dd::Table const&, dd::Partition const*, char const*, dict_table_t*&, THD*) + 1996 10 mysqld 0x0000000105629735 dd_table_open_on_name(THD*, MDL_ticket**, char const*, bool, unsigned long) + 1861 11 mysqld 0x0000000105701b9b innobase_get_table_statistics(char const*, char const*, unsigned long long, dd::Properties const&, dd::Properties const&, unsigned int, ha_statistics*) + 1451 12 mysqld 0x0000000105497e2b dd::info_schema::Table_statistics::read_stat_from_SE(THD*, String const&, String const&, String const&, String const&, unsigned int, unsigned int, unsigned long long, char const*, char const*, dd:: [truncated, 311 bytes total] 13 mysqld 0x0000000105497705 dd::info_schema::Table_statistics::read_stat(THD*, String const&, String const&, String const&, char const*, String const&, unsigned int, unsigned int, String const&, unsigned long long, char const [truncated, 371 bytes total] 14 mysqld 0x00000001045eeda2 dd::info_schema::Table_statistics::read_stat(THD*, String const&, String const&, String const&, char const*, unsigned long long, char const*, char const*, unsigned long long const&, unsigned long l [truncated, 313 bytes total] 15 mysqld 0x00000001045e563e get_table_statistics(Item**, unsigned int, dd::info_schema::enum_table_stats_type, bool*) + 958 16 mysqld 0x00000001045e5258 Item_func_internal_table_rows::val_int() + 40 17 mysqld 0x000000010457f015 Item::save_in_field_inner(Field*, bool) + 709 18 mysqld 0x000000010458370e Item_view_ref::save_in_field_inner(Field*, bool) + 78 19 mysqld 0x00000001047abaca end_write(JOIN*, QEP_TAB*, bool) + 346 20 mysqld 0x00000001047ad0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 21 mysqld 0x00000001047acae1 sub_select(JOIN*, QEP_TAB*, bool) + 913 22 mysqld 0x00000001047ad0fa evaluate_join_record(JOIN*, QEP_TAB*) + 602 23 mysqld 0x00000001047acc4a sub_select(JOIN*, QEP_TAB*, bool) + 1274 24 mysqld 0x00000001047cac75 JOIN_CACHE::join_null_complements(bool) + 405 25 mysqld 0x00000001047ca202 JOIN_CACHE::join_records(bool) + 498 26 mysqld 0x00000001047a847b sub_select_op(JOIN*, QEP_TAB*, bool) + 75 27 mysqld 0x00000001047ac7d7 sub_select(JOIN*, QEP_TAB*, bool) + 135 28 mysqld 0x00000001047ac7d7 sub_select(JOIN*, QEP_TAB*, bool) + 135 29 mysqld 0x00000001047ac7d7 sub_select(JOIN*, QEP_TAB*, bool) + 135 30 mysqld 0x00000001047a77f8 JOIN::exec() + 888 31 mysqld 0x00000001048408c1 handle_query(THD*, LEX*, Query_result*, unsigned long long, unsigned long long) + 545 32 mysqld 0x0000000104803420 execute_show(THD*, TABLE_LIST*) + 624 33 mysqld 0x00000001047fe0a4 mysql_execute_command(THD*, bool) + 4580 34 mysqld 0x00000001047fbaf6 mysql_parse(THD*, Parser_state*) + 886 35 mysqld 0x00000001047fa408 dispatch_command(THD*, COM_DATA const*, enum_server_command) + 7544 36 mysqld 0x00000001047fb363 do_command(THD*) + 467 37 mysqld 0x00000001049230e4 handle_connection(void*) + 372 38 mysqld 0x00000001058d0bbc pfs_spawn_thread(void*) + 316 39 libsystem_pthread.dylib 0x00007fff691ac339 _pthread_body + 126 40 libsystem_pthread.dylib 0x00007fff691af2a7 _pthread_start + 70 41 libsystem_pthread.dylib 0x00007fff691ab445 thread_start + 13 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fb2c42b8828): show table status like 'actionPoint' 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. /usr/local/mysql/bin/mysqld (mysqld 8.0.12) starting as process 548 Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive InnoDB: Tablespace 2, name 'piclient/metadataactionpoint', file './piclient/metadataactionpoint.ibd' is missing! InnoDB: Tablespace 3, name 'piclient/metadataagendaitem', file './piclient/metadataagendaitem.ibd' is missing! InnoDB: Tablespace 4, name 'piclient/metadatadocument', file './piclient/metadatadocument.ibd' is missing! InnoDB: Tablespace 5, name 'piclient/metadatadocumentversion', file './piclient/metadatadocumentversion.ibd' is missing! InnoDB: Tablespace 6, name 'piclient/metadatalibrary', file './piclient/metadatalibrary.ibd' is missing! InnoDB: Tablespace 7, name 'piclient/metadatameeting', file './piclient/metadatameeting.ibd' is missing! InnoDB: Tablespace 8, name 'piclient/queuedelete', file './piclient/queuedelete.ibd' is missing! InnoDB: Tablespace 9, name 'piclient/queuenew', file './piclient/queuenew.ibd' is missing! InnoDB: Tablespace 10, name 'piclient/queueupdate', file './piclient/queueupdate.ibd' is missing! InnoDB: Tablespace 11, name 'picore/actionpoint', file './picore/actionpoint.ibd' is missing! InnoDB: Tablespace 12, name 'picore/agendaitem', file './picore/agendaitem.ibd' is missing! InnoDB: Tablespace 13, name 'picore/document', file './picore/document.ibd' is missing! InnoDB: Tablespace 14, name 'picore/documentversion', file './picore/documentversion.ibd' is missing! InnoDB: Tablespace 15, name 'picore/library', file './picore/library.ibd' is missing! InnoDB: Tablespace 16, name 'picore/lookupcontactmethod', file './picore/lookupcontactmethod.ibd' is missing! InnoDB: Tablespace 17, name 'picore/meeting', file './picore/meeting.ibd' is missing! InnoDB: Tablespace 18, name 'picore/note', file './picore/note.ibd' is missing! InnoDB: Tablespace 19, name 'picore/organisation', file './picore/organisation.ibd' is missing! InnoDB: Tablespace 20, name 'picore/person', file './picore/person.ibd' is missing! InnoDB: Tablespace 21, name 'picore/personcontactmethod', file './picore/personcontactmethod.ibd' is missing! InnoDB: Tablespace 22, name 'picore/ractionpointassignees', file './picore/ractionpointassignees.ibd' is missing! InnoDB: Tablespace 23, name 'picore/ractionpointdocuments', file './picore/ractionpointdocuments.ibd' is missing! InnoDB: Tablespace 24, name 'picore/ractionpointnotes', file './picore/ractionpointnotes.ibd' is missing! InnoDB: Tablespace 25, name 'picore/ragendaitemcomments', file './picore/ragendaitemcomments.ibd' is missing! InnoDB: Tablespace 26, name 'picore/ragendaitemcontributors', file './picore/ragendaitemcontributors.ibd' is missing! InnoDB: Tablespace 27, name 'picore/ragendaitemcopresenters', file './picore/ragendaitemcopresenters.ibd' is missing! InnoDB: Tablespace 28, name 'picore/ragendaitemdocuments', file './picore/ragendaitemdocuments.ibd' is missing! InnoDB: Tablespace 29, name 'picore/ragendaitemnotes', file './picore/ragendaitemnotes.ibd' is missing! InnoDB: Tablespace 30, name 'picore/ragendaitempresenters', file './picore/ragendaitempresenters.ibd' is missing! InnoDB: Tablespace 31, name 'picore/rdocumentnotes', file './picore/rdocumentnotes.ibd' is missing! InnoDB: Tablespace 32, name 'picore/rlibrarylibrarians', file './picore/rlibrarylibrarians.ibd' is missing! InnoDB: Tablespace 33, name 'picore/rlibraryorganisers', file './picore/rlibraryorganisers.ibd' is missing! InnoDB: Tablespace 34, name 'picore/rlibrarysublibraries', file './picore/rlibrarysublibraries.ibd' is missing! InnoDB: Tablespace 35, name 'picore/rmeetingattendees', file './picore/rmeetingattendees.ibd' is missing! InnoDB: Tablespace 36, name 'picore/rmeetingcomments', file './picore/rmeetingcomments.ibd' is missing! InnoDB: Tablespace 37, name 'picore/rmeetingdocuments', file './picore/rmeetingdocuments.ibd' is missing! InnoDB: Tablespace 38, name 'picore/rmeetingnotes', file './picore/rmeetingnotes.ibd' is missing! InnoDB: Tablespace 39, name 'picore/rmeetingorganisers', file './picore/rmeetingorganisers.ibd' is missing! InnoDB: Tablespace 40, name 'piserver/deleted_meeting', file './piserver/deleted_meeting.ibd' is missing! [warn] kq_init: detected broken kqueue; not using.: No such file or directory Starting crash recovery... Crash recovery finished. CA certificate ca.pem is self signed. /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.12' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.