"Internal Server Error The server was unable to complete your request" After upgrading docker image

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
, ,
16

thanks, I solved it by adding the combinatin of your suggestions and added this line in my docker-compose.yaml:

services:
  db:
     image: mariadb
     command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW --skip-innodb-read-only-compressed --innodb_read_only_compressed=OFF

Then I successfully updated from NC 20 to 21 with

docker-compose pull && docker-compose up

And after turning off the maintenance mode with

docker exec --user www-data ${DOCKERNAME} php occ maintenance:mode --off

I updated all apps with the website-updater.

And everything works fine!

I tried to debug this a bit further:

After the update, I tried to remove the command line again, but then still NC doesn’t start so i added the command line again.

Strange is: I still have that same error in the log, but it seems to cause no harm any more:

[ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).  
[ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

By the way: after removing this part, NC also starts fine:

 --innodb_read_only_compressed=OFF

So maybe that part wasn’t important, or just for the update and afterwards it isn’t needed any more.

2 Likes