Database update fails from 4.2.5. to 4.3.4

[bjoern.busch]

Reproduction steps

1. Update Chevereto docker image from 4.2.5. to 4.3.4.
   1. Pro edition
   2. New docker image has been created, update is not executed via CHEVERETO_SERVICING=server
2. Open the Website
3. Error is displayed about unknown column 'image_checksum'
4. Go to /dashboard
5. Database update is available to 4.3.4
6. Click to update button
7. Website shows no progress
8. Mariadb shows access denied for mysql user
   1. ok, this probably is related to the healthcheck and I have never noticed it so far. https://github.com/MariaDB/mariadb-docker/issues/430

Unexpected result

Database update fails

Error log message

[6837f46de0564] PDOException in /var/www/html/app/src/Legacy/G/DB.php:150

# Message [Code #42S22]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'image_checksum' in 'field list'

# URI
/

# Method
GET

# Time
2025-05-29T05:45:17+00:00 [1748497517]

# Incident 6837f46de0564

# Backtrace
------------------------------------------------------------
0 /var/www/html/app/src/Legacy/G/DB.php:150
{main}()
------------------------------------------------------------
1 /var/www/html/app/src/Legacy/G/DB.php:150
PDOStatement->execute()
------------------------------------------------------------
2 /var/www/html/app/src/Legacy/G/DB.php:165
Chevereto\Legacy\G\DB->exec()
------------------------------------------------------------
3 /var/www/html/app/src/Legacy/Classes/Listing.php:1074
Chevereto\Legacy\G\DB->fetchAll()
------------------------------------------------------------
4 /var/www/html/app/legacy/routes/explore.php:132
Chevereto\Legacy\Classes\Listing->exec()
------------------------------------------------------------
5 /var/www/html/app/legacy/routes/index.php:45
Chevereto\Legacy\G\Handler->{closure}(Chevereto\Legacy\G\Handler(#60))
------------------------------------------------------------
6 /var/www/html/app/src/Legacy/G/Handler.php:456
Chevereto\Legacy\G\Handler->{closure}(Chevereto\Legacy\G\Handler(#60))
------------------------------------------------------------
7 /var/www/html/app/src/Legacy/G/Handler.php:180
Chevereto\Legacy\G\Handler->processRequest()
------------------------------------------------------------
8 /var/www/html/app/legacy/load/web.php:668
Chevereto\Legacy\G\Handler->__construct(bool(true), Closure(#57), Closure(#59))
------------------------------------------------------------
9 /var/www/html/app/legacy/entrypoints/index.php:45
require_once(string(length=37))
------------------------------------------------------------
10 /var/www/html/index.php:12
require_once(string(length=46))
------------------------------------------------------------

2025/05/29 08:05:56,stderr,Try running each of the following statements in the database console to find the conflict.

2025/05/29 08:05:56,stderr,<pre style="overflow:auto;word-break:break-all;white-space:pre-wrap;"><code>>>> SQLSTATE[HY000]: General error: 2006 MySQL server has gone away</code></pre>

2025/05/29 08:05:56,stderr,Error executing the Chevereto update query.

2025/05/29 08:05:56,stderr,# Message

2025/05/29 08:05:56,stderr,

2025/05/29 08:05:56,stderr,[6837f9445619d] LogicException in /var/www/html/app/legacy/install/installer.php:2475

2025-05-29  6:17:54 42 [Warning] Access denied for user 'mysql'@'127.0.0.1' (using password: NO)

 

[Rodolfo]

Hello,

Soon as you provision a new version filesystem, the database update must be carried immediately. This one appears because you are accessing / where you probably have a listing.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'image_checksum' in 'field list'

You need to go to /dashboard or run app/bin/cli -C update to update the application database so it matches the application filesystem.

Now, your other issue:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

That is saying that the database is not there, usually when you run via Docker you should use a health check otherwise the thing doesn't wait for all services ready. For MariaDB use this (also restart always):

    restart: always
    healthcheck:
      test: ["CMD", "healthcheck.sh", "--su-mysql", "--connect"]
      interval: 10s
      timeout: 5s
      retries: 3

Let me know how it goes.