mariadb/mysql won't start on TrueNAS 12.2

RandomBloke85

Dabbler
Joined
May 22, 2021
Messages
23
<div class="bbWrapper">Patrick, your strategy worked like a charm - absolutely wonderful. I can't thank you enough. Everything is running fine again with no data loss.<br /> <br /> Yes, Redis is installed and enabled. Many other users have the same problem, there is already a ticket on github. Maybe I dive into this sometime, but it could be as well a simple bug.<br /> <br /> So thanks again and this time I'll learn about snaps... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=":wink:" title="Wink :wink:" loading="lazy" data-shortname=":wink:" /></div>
 

RandomBloke85

Dabbler
Joined
May 22, 2021
Messages
23
<div class="bbWrapper">After all, a couple of days later, I did find a small problem:<br /> <br /> I created the users and assigned them to the group &quot;family&quot;. When I go into users in Nextcloud, I see myself in the Admin group, the others in the family group, but when I click on &quot;Everyone&quot; it results in a error message. Did I a mistake I made somewhere caused this error?<br /> <br /> Please note: I'm completly aware of the fact, that this is not the Nextcloud forum. I just wanted to rule out the possibilty, that my not so textbook installation and creation of users has something to do with this error. It might as well just be a NC 22.2.0.2 error.</div>
 

Patrick M. Hausen

Hall of Famer
Joined
Nov 25, 2013
Messages
7,776
<div class="bbWrapper">The &quot;occ thing&quot; does have a &quot;check database consistency&quot; command, IIRC - I'd try that first.</div>
 

RandomBloke85

Dabbler
Joined
May 22, 2021
Messages
23
<div class="bbWrapper">Alright, thank you, but I don't know how to do that. I just created the user &quot;Test&quot; and it won't show anywhere. It is created in /mnt/data, but not visible in the user admin panel.</div>
 
Last edited:

Patrick M. Hausen

Hall of Famer
Joined
Nov 25, 2013
Messages
7,776
<div class="bbWrapper"><code class="bbCodeInline">su -m www -c &quot;/usr/local/bin/php /usr/local/www/nextcloud/occ&quot;</code> will list all commands the &quot;occ&quot; tool supports.</div>
 

RandomBloke85

Dabbler
Joined
May 22, 2021
Messages
23
<div class="bbWrapper">Ha! Fixed it! <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":smile:" title="Smile :smile:" loading="lazy" data-shortname=":smile:" /> Again, thanks to you Patrick.<br /> <br /> After checking the logs with awful lot of utf8mb4 charset related errors, I ran occ db:convert-mysql-charset. That worked for me. So everything is running fine now.</div>
 

Patrick M. Hausen

Hall of Famer
Joined
Nov 25, 2013
Messages
7,776
<div class="bbWrapper">That should have been shown in the admin section of the web UI. You probably want to check again if more conversions are missing. Normaly it tells you the exact occ subcommand to run.</div>
 

RandomBloke85

Dabbler
Joined
May 22, 2021
Messages
23
<div class="bbWrapper">I didn't know that of course. I've checked the admin settings but couldn't find anything pointing to any missing conversions. Where would such a message be located? In case you refer to the system generated report in support/system information, there is nothing of relevance there.</div>
 

Patrick M. Hausen

Hall of Famer
Joined
Nov 25, 2013
Messages
7,776
<div class="bbWrapper">Settings &gt; Administration &gt; Overview.<br /> <br /> If anything like <code class="bbCodeInline">occ db:convert-mysql-charset</code> needs to be done Nextcloud should be telling you in this dialog:<br /> <script class="js-extraPhrases" type="application/json"> { "lightbox_close": "Close", "lightbox_next": "Next", "lightbox_previous": "Previous", "lightbox_error": "The requested content cannot be loaded. Please try again later.", "lightbox_start_slideshow": "Start slideshow", "lightbox_stop_slideshow": "Stop slideshow", "lightbox_full_screen": "Full screen", "lightbox_thumbnails": "Thumbnails", "lightbox_download": "Download", "lightbox_share": "Share", "lightbox_zoom": "Zoom", "lightbox_new_window": "New window", "lightbox_toggle_sidebar": "Toggle sidebar" } </script> <a href="https://www.truenas.com/community/attachments/bildschirmfoto-2021-11-10-um-19-02-15-png.50663/" target="_blank" class="js-lbImage"><img src="https://www.truenas.com/community/data/attachments/50/50245-a8e1dca60531110c395b66fe09b7a595.jpg" class="bbImage " style="" alt="Bildschirmfoto 2021-11-10 um 19.02.15.png" title="Bildschirmfoto 2021-11-10 um 19.02.15.png" width="781" height="150" loading="lazy" /></a> <br /> <br /> So instead of &quot;All checks passed&quot; it should say &quot;you need to convert some database tables to ...&quot; or &quot;some indexes are missing, you can add them by running `occ foo` ...&quot;</div>
 

RandomBloke85

Dabbler
Joined
May 22, 2021
Messages
23
<div class="bbWrapper">That was &quot;all clear&quot; all the time and didn't show the utf8mb4-issue. But you're right, if something is wrong, it shows up there. But I've learned again from you, so danke und schönen Abend <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":smile:" title="Smile :smile:" loading="lazy" data-shortname=":smile:" /></div>
 
Top