utzer [Friendica]

utzer [Friendica] via Friendica Support

utzer [Friendica]
4 years ago from Fediverse

Unexpectedly my #Friendica Server went into maintenance mode this night (I guess). I think it got stuck in the maintenance mode.

On the page I see:

#0 [internal function]: Friendica\Module\Maintenance::content(Array)
#1 /srv/http/src/App/Page.php(332): call_user_func(Array, Array)
#2 /srv/http/src/App/Page.php(388): Friendica\App\Page->initContent(Object(Friendica\App\Module), Object(Friendica\App\Mode))
#3 /srv/http/src/App.php(576): Friendica\App\Page->run(Object(Friendica\App), Object(Friendica\App\BaseURL), Object(Friendica\App\Mode), Object(Friendica\App\Module), Object(Friendica\Core\L10n), Object(Friendica\Core\Config\JitConfig), Object(Friendica\Core\PConfig\JitPConfig))
#4 /srv/http/index.php(42): Friendica\App->runFrontend(Object(Friendica\App\Module), Object(Friendica\App\Router), Object(Friendica\Core\PConfig\JitPConfig), Object(Friendica\App\Authentication), Object(Friendica\App\Page))
#5 {main}

I tried to run "bin/console dbstructure update", but in mysql there is no processes.

Should I try to finish maintenance mode manually?

!Friendica Support

#friendica !Friendica Support

Michael Vogel

4 years ago

Check if the database itself is running any processes by calling "show processlist" from the MySQL console.

utzer [Friendica]

4 years ago from Fediverse

@Michael Vogel I did, nothing there.

MariaDB [(none)]> Show Processlist;
+--------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| Id     | User        | Host      | db   | Command | Time | State                    | Info             | Progress |
+--------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
|      1 | system user |           | NULL | Daemon  | NULL | InnoDB purge coordinator | NULL             |    0.000 |
|      2 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|      3 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|      4 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|      5 | system user |           | NULL | Daemon  | NU

@Michael Vogel I did, nothing there.

MariaDB [(none)]> Show Processlist;
+--------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
| Id     | User        | Host      | db   | Command | Time | State                    | Info             | Progress |
+--------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
|      1 | system user |           | NULL | Daemon  | NULL | InnoDB purge coordinator | NULL             |    0.000 |
|      2 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|      3 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|      4 | system user |           | NULL | Daemon  | NULL | InnoDB purge worker      | NULL             |    0.000 |
|      5 | system user |           | NULL | Daemon  | NULL | InnoDB shutdown handler  | NULL             |    0.000 |
| 287528 | root        | localhost | NULL | Query   |    0 | Init                     | Show Processlist |    0.000 |
+--------+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
6 rows in set (0.000 sec)

Also I just switched from RC to master, so I was not expecting an update.

@Michael Vogel

Michael Vogel

4 years ago

Call bin/console dbstructure update -f. And then manually deactivate the maintenance mode.

utzer [Friendica]

4 years ago from Fediverse

@Michael Vogel there was no output for the -f added to the command, I deactivated the maintenance mode and it looks good now.

Thanks.

Can we add some fallback that prevents this somehow? Probably you already thought about that and implemented something, if not then can we add something?

@Michael Vogel

⇧