Music app stuck without being able to update - General error: 4047 InnoDB

[nightcobe]

I followed this guide to install Docker and Collabora

HowTo: Ubuntu + Docker + Nextcloud + Talk + Collabora

1.Overview This is a general guide to setting up a functional Nextcloud instance using Ubuntu Server 18.04.3, Docker CE, Docker-Compose, Collabora CODE, and an Apache reverse proxy. By the end (and as of writing), this setup will have an A+ rating on Nextcloud Security Scan and Qualys SSL Server Test and a valid, self-updating certificate from Let’s Encrypt. I will also cover how to update everything. I will do my best to plainly emphasize things that you will need to change, but it will mainly…

Now I have a problem that the Music app is hindering me from doing anything in my Nextcloud. It all started after I tried to update all apps in the GUI in Nextcloud and then suddenly the music app won’t update and leaves me with an error.

The only right thing to do at the moment I feel is to remove my nextcloud docker image and then reinstall an updated version of it again. How do I do that? Can I reconnect with Collabora easily? Will my data inevitably be lost?

Can I just remove the three old Nextcloud images?

REPOSITORY TAG IMAGE ID CREATED SIZE
nextcloud latest 82ea99d60d77 4 days ago 905MB
onlyoffice/documentserver latest 9a2d35676972 6 days ago 2.71GB
redis latest ddcca4b8a6f0 13 days ago 105MB
collabora/code latest 8d8e22d44a64 2 weeks ago 1.39GB
mariadb latest 45eaeedf03de 3 weeks ago 409MB
instrumentisto/coturn latest 170432ce18ed 7 months ago 18.8MB
nextcloud custom 3ba3e5ce8318 7 months ago 900MB
nextcloud apache 10fa80752a04 7 months ago 809MB
nextcloud < none> d76db1378a35 7 months ago 809MB
hello-world latest bf756fb1ae65 20 months ago 13.3kB

I have tried many things like removing or disabling the music app but it does not work.

Thanks for any help!

Cordially,
Martin Book

[KarlF12]

@nightcobe

Now I have a problem that the Music app is hindering me from doing anything in my Nextcloud.

What is it doing?

@nightcobe

It all started after I tried to update all apps in the GUI in Nextcloud and then suddenly the music app won’t update and leaves me with an error.

What error?

@nightcobe

I have tried many things like removing or disabling the music app but it does not work.

Did you try updating or disabling it with OCC?

@nightcobe

Can I just remove the three old Nextcloud images?

Yes, it should be fine to remove older image versions from Docker. I think it will let you know if one of them is still in use by a container.

@nightcobe

The only right thing to do at the moment I feel is to remove my nextcloud docker image and then reinstall an updated version of it again. How do I do that? Can I reconnect with Collabora easily? Will my data inevitably be lost?

I think this is probably not the solution to whatever is going on, but as long as your data folder and database are intact, you should not lose any data. It’s not stored in the container itself.

[nightcobe]

Thank you for your reply.

This is what happens:

When trying to update this is what I get

This is what I receive when I try OCC UPGRADE
occ upgrade
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Setting log level to debug
Turned on maintenance mode
Updating database schema
Updated database
Updating …
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘UPDATE oc_music_albums SET created = ? WHERE created IS NULL’ with params [“2021-08-31 07:23:26”]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘created’ in ‘where clause’
Update failed
Maintenance mode is kept active
Resetting log level

I tried pulling a new docker image but I am not sure I can migrate the attachments from the old to the new. There are two old Nextcloud images that still are in use, the ones down the list:

REPOSITORY TAG IMAGE ID CREATED SIZE
nextcloud latest 82ea99d60d77 4 days ago 905MB
onlyoffice/documentserver latest 9a2d35676972 6 days ago 2.71GB
redis latest ddcca4b8a6f0 13 days ago 105MB
collabora/code latest 8d8e22d44a64 2 weeks ago 1.39GB
mariadb latest 45eaeedf03de 3 weeks ago 409MB
instrumentisto/coturn latest 170432ce18ed 7 months ago 18.8MB
nextcloud custom 3ba3e5ce8318 7 months ago 900MB
nextcloud apache 10fa80752a04 7 months ago 809MB
hello-world latest bf756fb1ae65 20 months ago 13.3kB

If this is the occ command for updating an app it does not seem to do much good:

occ app:update music
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade

Trying to remove it is to no avail either:

occ app:remove music
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Error: An exception occurred while executing ‘UPDATE oc_appconfig SET configvalue = ? WHERE (appid = ?) AND (configkey = ?) AND ((configvalue IS NULL) OR (configvalue <> ?))’ with params [“no”, “music”, “enabled”, “no”]:

SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

[nightcobe]

But this is really where I describe and try to get help with the music app error and get back into my Nextcloud

Music App Error - Nextcloud will not upgrade - Not possible to access Nextcloud

When I try to login to my Nextcloud I get a message that an app needs to be updated and that it is the Music (music) app that needs it: [uponsignin] However, when I click “Update App” I get the following: [AppUpdate] When I try to “occ upgrade” in terminal because they tell me that is another way of doing it, I get this error message: __ Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do…

This thread is mainly a question if I can get rid of my old Nextcloud image and load a new one and get back into it that way. Like a really hard reset…

I really want to use my Nextcloud and I do not know what to do.

[wwe]

from your screenshots I have the feeling you are running the upgrade from the Web - did you? Docker containers are expected to upgrade by changing the image tag. If you have (had) NC19 running try to get rid of you old containers and restart explicitly using a newer version (n+1 so if you where running 19 continue with 20).

replace

image: nextcloud

with

image: nextcloud:20

or :20.0.12 if you want to be more precise.

your data should remain untouched if you carefully followed the guide.

alternatively you could try to remove the app folder before you upgrade - may this help to complete the upgrade…

[nightcobe]

Unfortunately, this is not my problem.

I did not try to upgrade Nextcloud at all. I updated the Apps in the Nextcloud UI. Suddenly I was kicked out of it and found myself at the first screenshot above telling me that I needed to upgrade the Music app.

When I tried clicking the above button I got an error and was stuck. Because of this error I am not able to enter Nextcloud at all.

The people creating the Music app tried to help me here: https://github.com/owncloud/music/issues/889

Haven’t helped, unfortunately.

Your suggestion might help but I do not know how to test it. Are these commands in terminal:
image: nextcloud
image: nextcloud:20
?

Otherwise, what steps can I take to replace the one with the other?

How do I get rid of the docker containers? Isn’t it the Images I want to get rid of?

Talk to me like I were your four year old child, though I bet they would understand all of this better than I do.

Thank you very much for any light you might bring in this.

Cordially,
Martin

[nightcobe]

KarlF12:

Sorry to disturb you, but do you have any suggestions how I can do the things suggested here

App Update Required - Music - Cannot login to Nextcloud server

under your suggested installation of Nextcloud Docker?

Thanks for any pointers!

Cordially,
Martin Book

[KarlF12]

@nightcobe

SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

This is a known issue with MariaDB 10.6 and Nextcloud. Try this.

@jontyb

For anyone following this hitting an error like:

SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

… This is due to an issue with new versions of MariaDB. Full details can be found in this thread .

The solution is to add the following to the mariadb portion of your docker-compose.yml:

command: ['--innodb_read_only_compressed=OFF']

For example:

  mariadb:
    image: mariadb
    container_name: nextcloud-mariadb
    restart: unless-stopped
    command: ['--innodb_read_only_compressed=OFF']
    volumes:
      - ${NEXTCLOUD_ROOT}/mariadb:/var/lib/mysql
    environment:
      - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
      - MYSQL_PASSWORD=${MYSQL_PASSWORD}
      - MYSQL_DATABASE=nextcloud
      - MYSQL_USER=nextcloud
    networks:
      - nextcloud

[nightcobe]

Trying it right away now. Thanks!

[KarlF12]

Also remember to run docker-compose up -d to update the container config after making changes.

[nightcobe]

You are incredible, KarlF12!

This was the solution!

Now it updated everything without a problem!

THANK YOU!