<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">OK war doch aussagekräftig. Es läuft wieder.<div class=""><br class=""></div><div class="">ich habe nach dem mariadb can’t init tc log gegooglet und habe mehrer einträge gefunden die sagten das diese Log datei wahrscheinlich durch ein out of space problem corrupt geworden sind. Also habe ich unte /var/lib/mysql geschaut und da war diese Datei und ich konnte sie nicht öffnen, weil Permission denied.</div><div class=""><br class=""></div><div class="">Die Lösung war jetzt, das ich diese Datei gelöscht habe und dann das System rebootet habe. Nun läuft mariadb wieder, die tc.log datei wurde neu erstellt.</div><div class=""><br class=""></div><div class="">Vielen Dank für die Schnelle Hilfe, vor allem wo man schauen muss um den Fehler zu finden. Ich habe dabei wieder viel gelernt</div><div class=""><br class=""></div><div class="">Viele Grüße</div><div class="">Tobias</div><div class=""><div><blockquote type="cite" class=""><div class="">Am 28.03.2020 um 15:44 schrieb Tobias Lehr <<a href="mailto:tobias.lehr@me.com" class="">tobias.lehr@me.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Also nach deiner Anleitung komme ich nicht weiter, da schon die im schritt mysql error log aktivieren genannte Datei nicht existiert.<div class=""><br class=""></div><div class="">Ich habe aber unter /var/log/mysql/ die error.log gefunden.</div><div class=""><br class=""></div><div class="">das ist die ausgabe wenn ich versucht habe mysql über systemctl start mysql zu starten:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;" class=""><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Using mutexes to ref count buffer pool pages</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: The InnoDB memory heap is disabled</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Compressed tables use zlib 1.2.8</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Using Linux native AIO</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Using generic crc32 instructions</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Initializing buffer pool, size = 128.0M</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Completed initialization of buffer pool</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Highest supported file format is Barracuda.</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: 128 rollback segment(s) are active.</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Waiting for purge to start</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] InnoDB: Percona XtraDB (<a href="http://www.percona.com/" class="">http://www.percona.com</a>) 5.6.35-80.0 started; log sequence number 1359030093</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1442837312 [Note] InnoDB: Dumping buffer pool(s) not yet started</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] Plugin 'FEEDBACK' is disabled.</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [Note] Recovering after a crash using tc.log</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [ERROR] Can't init tc log</span></div><div style="margin: 0px; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2020-03-28 15:39:05 1988235264 [ERROR] Aborting</span></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class="">leider nicht sehr aussagekräftig</span></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Gruß Tobias</span></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class=""><blockquote type="cite" class=""><div class="">Am 28.03.2020 um 15:02 schrieb Daniel Lauckner <<a href="mailto:vz@jahp.de" class="">vz@jahp.de</a>>:</div><br class="Apple-interchange-newline"><div class=""><div class="">Hallo,<br class=""><br class=""><br class="">dann schau mal nach dem Logfile.<br class=""><a href="http://www.sysadminslife.com/linux/mysql-log-file-aktivieren-error-vs-query-vs-slow-query/" class="">http://www.sysadminslife.com/linux/mysql-log-file-aktivieren-error-vs-query-vs-slow-query/</a><br class=""><br class=""><br class="">mfg Daniel<br class=""><br class=""></div></div></blockquote></div><br class=""></div></div></div></blockquote></div><br class=""></div></body></html>