/ Yunohost doesn’t boot anymore
My YunoHost server
Hardware: Internet Cube (LIME 1) with VPN
YunoHost version: not sure / should be the latest in july 2020
I have access to my server : file system on the SD card / physically to the olimex
Are you in a special context or did you perform some particular tweaking on your YunoHost instance ? : yes
If yes, please explain: It’s pretty hard to explaint it fully, but I have this server since 2015, so there is a lot of things I did modifiy during theses years in order to make things work (before Yunohost corrected it). Lastly, thanks to the diagnosis tool, I did edit a few to get back in the normal installation. I was as close as possible to its recommendations. I guess it’s good to have all of it in mind.
Description of my issue
On july 16th, my cube got down and nothing happened anymore at boot (it didn’t even appeared on the local network). The LIME 1 card looked like it oddly reacted when plugged in (the orange LED didn’t blink anymore), and the SD card looked fully functionnal, so I decided to get a new LIME 1 in order to make it easier for me and not have to make a new install on a LIME 2.
I now have the new LIME 1. It seems to react a bit differently in terms of LED blinking, but in the end, I have nothing more once the SD is in.
While, again, the SD nothing’s corrupted looking at fsck, and nothing is on readonly mode.
So I am confused : it doesn’t look corrupted.
I have been able to get a HDMI cable that I plugged on my videoprojector (I have nothing better to use next to the internet box and the cube). It writes “no signal”.
The ext4 partition of the Cube ain’t full. There are a bit more of 2.5Gb of free space.
I really don’t know where to check to get deeper, does anyone have any idea?
I can access to every logs, that all stopped the same day : july 16th. In the ones I’ve read (syslog & kern) I haven’t seen any error correlated to the situation, but I don’t know where to look and what for.
Yunohost doesn’t boot
Mon serveur YunoHost
Matériel : Brique Internet avec VPN
Version de YunoHost : pas certain, normalement la dernière quand nous étions en juillet 2020
J’ai accès à mon serveur : système de fichiers sur la carte SD / physiquement à la olimex
tes-vous dans un contexte particulier ou avez-vous effectué des modifications particulières sur votre instance ? : oui
Si oui, expliquer: C’est assez dur d’être exhaustif, mais j’ai ce serveur depuis 2015, donc il y a beaucoup de choses que j’ai modifiées durant ces années pour que tout fonctionne (avant que Yunohost ne le corrige). Dernièrement, avec l’aide de l’outil de diagnostic, j’ai pu revenir un peu vers l’installation normale. J’étais aussi proche que ça m’était possible de ses recommandations. Je pense que ça reste bien d’avoir ça à l’esprit.
Description du problème
Le 16 juillet, ma brique est tombée down et plus rien au boot (même pas d’apparition en réseau local). La carte LIME 1 avait l’air de réagir bizarrement au branchement (la LED orange ne clignotait plus), et la carte SD semblait parfaitement fonctionnelle, donc j’ai décidé d’acheter une nouvelle LIME 1 pour me simplifier les choses et ne pas avoir à refaire une installation sur une LIME 2.
J’ai désormais la nouvelle LIME 1. Elle semble réagir un peu différemment en termes de clignotement des LED, mais au final, je n’ai pas plus de résultat une fois la carte SD dedans.
Or, sur la carte SD, rien de corrompu d’après fsck, et rien n’est en lecture seule.
Donc je suis confus : elle n’a pas l’air corrompue.
J’ai pu mettre la main sur un câble HDMI que j’ai branché à mon vidéoprojecteur (je n’ai rien de plus pratique sous la main près de la box et de la brique). Il indique “aucun signal”.
La partition ext4 de la Brique n’est pas pleine, il reste un peu plus de 2.5Go.
Je ne sais pas bien où regarder pour avance, est-ce que quelqu’un a des idées ?
Je peux accéder à tous les logs, qui se sont arrêtés le même jour : le 16 juillet. Dans ceux que j’ai regardé (syslog & kern) je n’ai vu aucune erreur semblant liée à la situation, mais je ne sais ni ou ni quoi chercher.
Logs
syslog :
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat FreshRSS[955]: FreshRSS actualize le_traquemort...
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat FreshRSS[955]: FreshRSS actualize fx...
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat FreshRSS[955]: FreshRSS actualize india...
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat FreshRSS[955]: FreshRSS actualize tzitzimitl...
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b69a3340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat FreshRSS[955]: FreshRSS actualize komodo...
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b6981340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b6981340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b6981340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b6981340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:04 cyphergoat FreshRSS[955]: FreshRSS actualization done for 6 users, using 4.00 MiB of memory, in 0 day(s), 0 hour(s), 0 minute(s) and 0 seconds.
Jul 16 09:00:04 cyphergoat mysqld[26317]: 2020-07-16 09:00:04 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:07 cyphergoat mysqld[26317]: 2020-07-16 09:00:07 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:07 cyphergoat mysqld[26317]: 2020-07-16 09:00:07 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:07 cyphergoat mysqld[26317]: 2020-07-16 09:00:07 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:07 cyphergoat mysqld[26317]: 2020-07-16 09:00:07 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:07 cyphergoat mysqld[26317]: 2020-07-16 09:00:07 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:07 cyphergoat mysqld[26317]: 2020-07-16 09:00:07 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:07 cyphergoat mysqld[26317]: 2020-07-16 09:00:07 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:08 cyphergoat mysqld[26317]: 2020-07-16 09:00:08 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:09 cyphergoat mysqld[26317]: 2020-07-16 09:00:09 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:10 cyphergoat mysqld[26317]: 2020-07-16 09:00:10 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:10 cyphergoat mysqld[26317]: 2020-07-16 09:00:10 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:10 cyphergoat mysqld[26317]: 2020-07-16 09:00:10 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:10 cyphergoat mysqld[26317]: 2020-07-16 09:00:10 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:10 cyphergoat mysqld[26317]: 2020-07-16 09:00:10 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
Jul 16 09:00:10 cyphergoat mysqld[26317]: 2020-07-16 09:00:10 b695f340 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
kern.log :
ul 16 06:25:36 cyphergoat kernel: [75739.038834] Out of memory: Kill process 7233 (mysqld) score 171 or sacrifice child
Jul 16 06:25:36 cyphergoat kernel: [75739.046640] Killed process 7233 (mysqld) total-vm:584612kB, anon-rss:83688kB, file-rss:2616kB, shmem-rss:0kB
Jul 16 06:30:09 cyphergoat kernel: [76011.693964] IPv6: ADDRCONF(NETDEV_UP): wlan0: link is not ready
Jul 16 06:30:09 cyphergoat kernel: [76011.852984] IPv6: ADDRCONF(NETDEV_CHANGE): wlan0: link becomes ready
yunohost-api.log :
2020-07-13 15:06:17,675 DEBUG geventwebsocket.handler run_application - Initializing WebSocket
2020-07-13 15:06:17,681 DEBUG geventwebsocket.handler upgrade_websocket - Validating WebSocket request
2020-07-13 15:06:17,703 INFO geventwebsocket.handler log_request - 127.0.0.1 - - [2020-07-13 15:06:17] "GET /installed HTTP/1.1" 200 159 0.021154
2020-07-15 09:23:32,502 DEBUG moulinette.actionsmap __init__ - loading actions map namespace 'yunohost'
2020-07-15 09:23:33,392 DEBUG moulinette.actionsmap __init__ - extra parameter classes loaded: ['required', 'pattern']
2020-07-15 09:23:33,414 DEBUG moulinette.interface __init__ - initializing base actions map parser for api
2020-07-15 09:23:46,205 DEBUG moulinette.interface.api run - starting the server instance in localhost:6787 with websocket=True
2020-07-15 15:06:52,437 DEBUG geventwebsocket.handler run_application - Initializing WebSocket
2020-07-15 15:06:52,448 DEBUG geventwebsocket.handler upgrade_websocket - Validating WebSocket request
2020-07-15 15:06:52,475 INFO geventwebsocket.handler log_request - 127.0.0.1 - - [2020-07-15 15:06:52] "GET /installed HTTP/1.1" 200 159 0.036306
yunohost-cli.log :
https://paste.yunohost.org/uzakasufaj.sql