News: LockWaitTimeoutException when upgrading to 15.1.0

[Emporea]

Nextcloud Server Version: 20.0.2 - docker compose

Preparing update

Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: All tables already have the correct collation -> nothing to do

Repair step: Repair SQLite autoincrement

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Updated database

Doctrine\DBAL\Exception\LockWaitTimeoutException: An exception occurred while executing 'DELETE FROM `oc_news_feeds` WHERE `oc_news_feeds`.`folder_id` NOT IN (SELECT DISTINCT id FROM `oc_news_folders`) AND `oc_news_feeds`.`folder_id` IS NOT NULL': SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

The update was unsuccessful. Please report this issue to the Nextcloud community.

Nextcloud got thrown into maintenance mode after trying to upgrade from 15.0.6 to 15.1.0; then this error occured.

Is a manual downgrade possible?

[Emporea]

I am now stuck in maintanance mode, nextcloud wants to occ upgrade, but it fails everytime.

[SMillerDev]

Try running the migration manually from the commandline.

[Emporea]

Okey. running occ upgrade via command line seems to work for me. I am now on 15.1.0. Thank You!
But I wouldn't consider this as solved, or should I close this issue?

[SMillerDev]

We can keep it open, but I don't think it's going to be easy to reproduce and the issue will probably be in the server code.

[ahyattdev]

My database is postgres, I am getting this upon upgrade:

 An exception occurred while executing 'ALTER TABLE oc_news_feeds ADD CONSTRAINT folder FOREIGN KEY (folder_id) REFERENCES oc_news_folders (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE': SQLSTATE[42804]: Datatype mismatch: 7 ERROR: foreign key constraint "folder" cannot be implemented DETAIL: Key columns "folder_id" and "id" are of incompatible types: numeric and bigint. 

[SMillerDev]

If you're not encountering the LockWaitTimeoutException, please make a new issue

[ahyattdev]

@SMillerDev ok i opened #972

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.