[Tiki-devel] Tiki database crashing mysql
Bernard Sfez via TikiWiki-devel <[email protected]>
| Newsgroups | gmane.comp.cms.tiki.devel |
|---|---|
| Message-ID | <[email protected]> |
Hello, I have an issue I have never seen with a specific database of a Tiki25 on a Debian11 Virtualmin all updated. (working fine this morning) I did an usual mysqldump and it never completed. "mysqldump got error 2013 lost connection to mysql server during query when using lock tables" After that mariadb was unresponsive in a way I had to reboot the server. Then find out that now matter I do with this database crashes and require a reboot (sometimes I have to turn it off and on back) Even opening the database in PHPmyadmin crashed the MariaDB server. 🤷🏻♂️ I ran "mysqlcheck -u root -p --all-databases” and it froze after tiki_search.stats ok. When I look at /var/lib/mysql/this_database I see the file after tiki_search, tiki_secdb.ibd is pretty big. -rw-rw---- 1 mysql mysql 1147 Jan 26 19:51 tiki_search_stats.frm -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 tiki_search_stats.ibd -rw-rw---- 1 mysql mysql 2871 Dec 14 15:58 tiki_secdb.frm -rw-rw---- 1 mysql mysql 25165824 Jan 4 14:24 tiki_secdb.ibd -rw-rw---- 1 mysql mysql 6305 Dec 14 15:56 tiki_sefurl_regex_out.frm Could it be the reason ? Is it safe to delete it and try to see if I can re-run database:update ? —— I also see I have a lot of those: -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_0000000000000df3_INDEX_1.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_0000000000000df3_INDEX_2.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_0000000000000df3_INDEX_3.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_0000000000000df3_INDEX_4.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_0000000000000df3_INDEX_5.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_0000000000000df3_INDEX_6.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_BEING_DELETED.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_BEING_DELETED_CACHE.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_CONFIG.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_DELETED.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_000000000000093b_DELETED_CACHE.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_0000000000000e2f_INDEX_1.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_0000000000000e2f_INDEX_2.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_0000000000000e2f_INDEX_3.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_0000000000000e2f_INDEX_4.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_0000000000000e2f_INDEX_5.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_0000000000000e2f_INDEX_6.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_BEING_DELETED.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_BEING_DELETED_CACHE.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_CONFIG.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_DELETED.ibd -rw-rw---- 1 mysql mysql 98304 Dec 14 15:56 FTS_0000000000000962_DELETED_CACHE.ibd Bernard _______________________________________________ TikiWiki-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel