Latest Update Not Working :/

[thetomester13]

Updating from 1.4.0 to 1.5.1 is resulting in Wallabag not being able to start up properly. Seems to be a DB migration issue.

[doodlemania2]

@thetomester13 same here - do a restore to get back to 1.4 and we'll wait on @girish and team to check the migration situation

[thetomester13]

Actually for the past 2 days I've been waking up to my Wallabag instance not working since it keeps auto-updating I disabled automatic updates for now, but maybe the update should be taken 'offline'?

I managed to get some screenshots of the logs that look like they broke the instance:

I know this isn't the first update that broke Wallabag - is it worth looking into spinning up a 2.0 separate app with migration instructions?

[nebulon]

Indeed we hit this again. I will pull the update and report upstream.

[nebulon]

@thetomester13 actually do you still have the logs in text form and create an upstream issue with a paste of the failing section? I will then jump into that thread to offer help.

[thetomester13]

@nebulon I restored from my backup that was created while on 1.5.1 and got the logs. See the Github issue here. Feel free to add any more information if you feel it's needed.

[nebulon]

As mentioned in the other post, I've made a new attempt to publish it with a hopefully fixed startup script.

[malvim]

@nebulon Just updated to 1.5.2 and getting migration problems and such

[malvim]

like this:

20:03:36 - In AbstractPostgreSQLDriver.php line 89:
20:03:36 -                                                                                
20:03:36 -   An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients  
20:03:36 -   " DROP CONSTRAINT idx_user_oauth_client':                                    
20:03:36 -                                                                                
20:03:36 -   SQLSTATE[42704]: Undefined object: 7 ERROR:  constraint "idx_user_oauth_cli  
20:03:36 -   ent" of relation "wallabag_oauth2_clients" does not exist                    
20:03:36 -                                                                                
20:03:36 - 
20:03:36 - In PDOConnection.php line 91:
20:03:36 -                                                                                
20:03:36 -   SQLSTATE[42704]: Undefined object: 7 ERROR:  constraint "idx_user_oauth_cli  
20:03:36 -   ent" of relation "wallabag_oauth2_clients" does not exist                    
20:03:36 -                                                                                
20:03:36 - 
20:03:36 - In PDOConnection.php line 86:
20:03:36 -                                                                                
20:03:36 -   SQLSTATE[42704]: Undefined object: 7 ERROR:  constraint "idx_user_oauth_cli  
20:03:36 -   ent" of relation "wallabag_oauth2_clients" does not exist                    
20:03:36 -                                                                                
20:03:36 - 

[doodlemania2]

@malvim Same here - @girish - I do think we should fork and offer as a new app. That's several Revs of failed upgrades from legacy (not our fault, but might help with adoption if we had a clean new version). 15:C 12 Jan 15:55:26.626 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
Jan 12 09:55:26 15:C 12 Jan 15:55:26.627 # Redis version=4.0.9, bits=64, commit=00000000, modified=0, pid=15, just started
Jan 12 09:55:26 15:C 12 Jan 15:55:26.627 # Configuration loaded
Jan 12 09:55:26 15:M 12 Jan 15:55:26.629 * Running mode=standalone, port=6379.
Jan 12 09:55:26 15:M 12 Jan 15:55:26.629 # Server initialized
Jan 12 09:55:26 15:M 12 Jan 15:55:26.629 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
Jan 12 09:55:26 15:M 12 Jan 15:55:26.633 * DB loaded from disk: 0.003 seconds
Jan 12 09:55:26 15:M 12 Jan 15:55:26.634 * Ready to accept connections
Jan 12 09:55:27 Redis service endpoint listening on https://:::3000
Jan 12 09:55:27 2021-01-12 15:55:27,526 INFO success: redis entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Jan 12 09:55:27 2021-01-12 15:55:27,526 INFO success: redis-service entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Jan 12 23:00:04 [POST] /backup
Jan 12 23:00:04 backing up
Jan 12 23:00:04 15:M 13 Jan 05:00:04.866 * DB saved on disk
Jan 13 23:00:04 [POST] /backup
Jan 13 23:00:04 backing up
Jan 13 23:00:04 15:M 14 Jan 05:00:04.542 * DB saved on disk
Jan 14 23:00:05 [POST] /backup
Jan 14 23:00:05 backing up
Jan 14 23:00:06 15:M 15 Jan 05:00:06.214 * DB saved on disk
Jan 15 23:00:06 [POST] /backup
Jan 15 23:00:06 backing up
Jan 15 23:00:06 15:M 16 Jan 05:00:06.865 * DB saved on disk
Jan 16 23:00:05 [POST] /backup
Jan 16 23:00:05 backing up
Jan 16 23:00:05 15:M 17 Jan 05:00:05.682 * DB saved on disk
Jan 17 23:00:04 [POST] /backup
Jan 17 23:00:04 backing up
Jan 17 23:00:04 15:M 18 Jan 05:00:04.466 * DB saved on disk
Jan 18 19:49:37 [POST] /backup
Jan 18 19:49:37 backing up
Jan 18 19:49:37 15:M 19 Jan 01:49:37.814 * DB saved on disk
Jan 18 19:50:24 [GET] /healthcheck
Jan 18 19:57:30 + mkdir -p /run/wallabag/cache /run/wallabag/logs /run/wallabag/sessions
Jan 18 19:57:30 + sed -e 's/database_driver:./database_driver: pdo_pgsql/' -e 's/database_host:./database_host: postgresql/' -e 's/database_port:./database_port: 5432/' -e 's/database_name:./database_name: db2b5e244172f54b24892e5da4603c3f00/' -e 's/database_user:./database_user: user2b5e244172f54b24892e5da4603c3f00/' -e 's/database_password:./database_password: xjYkbFoxOr6akUreTftb7Q3PLcWEYcNgg5JePeLwXcNQ7hOVqDktVn0iuxZjwc2ztYjVrXYzmTLdvFLZsGPIrYdJBqr94sVcoSmiWAkPAH2X9oLlg2c8jXZSlfwfBomg/' -e 's/database_charset: ./database_charset: utf8/' -e 's,domain_name: .,domain_name: https://later.thedoodleproject.net,' -e 's/redis_host:./redis_host: redis-2b5e2441-72f5-4b24-892e-5da4603c3f00/' -e 's/redis_port:./redis_port: 6379/' -e 's/redis_password:./redis_password: uIwMlh8OVs2n8lzryNHucHedW7UQDNFr5Ur2JTm6I8QzxOeouvmyoe7ftapLsDi4zGC1j1uqY1P91dWYYJSSWv9Pr6hN6KUKpvnaSbMUi3vLj_tVPJWfm3leTlJFNK17/' -e 's/mailer_host:./mailer_host: mail:2525/' -e 's/mailer_user:./mailer_user: later.app@thedoodleproject.net/' -e 's/mailer_password:./mailer_password: isgalKoJVZh7wlBcTsLnCwEN3CGWBGapRPmrQlpwFG2y7jCNCPmAgd3HAZma2uMS5DqNKwe2EQZBBxsYsSc7BKdFKhQCxq9TP__jcJzhZkOSsogwAM4jpF9Fn535xwdI/' -e 's/from_email:./from_email: later.app@thedoodleproject.net/' -e 's/twofactor_sender:./twofactor_sender: later.app@thedoodleproject.net/' -e 's/fosuser_registration:./fosuser_registration: false/' -e 's/fosuser_confirmation:./fosuser_confirmation: false/' /app/code/parameters.yml
Jan 18 19:57:30 + sed -e 's/save_path:./save_path: '''/run/wallabag/sessions'''/' /app/code/config.yml
Jan 18 19:57:30 + sed -e 's/path:./path: '''/run/wallabag/wallabag.log'''/' /app/code/config_prod.yml
Jan 18 19:57:30 + [[ ! -f /app/data/php.ini ]]
Jan 18 19:57:30 + mkdir -p /app/data/uploads/import /app/data/assets/images /app/data/data
Jan 18 19:57:30 + chown -R www-data:www-data /run/wallabag /app/data
Jan 18 19:57:30 + gosu='/usr/local/bin/gosu www-data:www-data'
Jan 18 19:57:30 + [[ ! -f /app/data/.initialized ]]
Jan 18 19:57:30 + /usr/local/bin/gosu www-data:www-data php bin/console doctrine:migrations:migrate --env prod --no-interaction
Jan 18 19:57:30
Jan 18 19:57:30 Application Migrations
Jan 18 19:57:30
Jan 18 19:57:30
Jan 18 19:57:30 Migrating up to 20200428072628 from 20190425115043
Jan 18 19:57:30
Jan 18 19:57:30 ++ migrating 20190510141130
Jan 18 19:57:30
Jan 18 19:57:30 -> ALTER TABLE "wallabag_oauth2_access_tokens" DROP CONSTRAINT FK_368A4209A76ED395
Jan 18 19:57:30 -> ALTER TABLE "wallabag_oauth2_access_tokens" ADD CONSTRAINT FK_368A4209A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE
Jan 18 19:57:30 -> ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client
Jan 18 19:57:30 Migration 20190510141130 failed during Execution. Error An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':
Jan 18 19:57:30
Jan 18 19:57:30 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist
Jan 18 19:57:30 01:57:30 ERROR [console] Error thrown while running command "doctrine:migrations:migrate --env prod --no-interaction". Message: "An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':
Jan 18 19:57:30
Jan 18 19:57:30 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist" ["exception" => Doctrine\DBAL\Exception\DriverException { …},"command" => "doctrine:migrations:migrate --env prod --no-interaction","message" => """ An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients" DROP CONSTRAINT idx_user_oauth_client':\n \n SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_client" of relation "wallabag_oauth2_clients" does not exist """]
Jan 18 19:57:30
Jan 18 19:57:30 In AbstractPostgreSQLDriver.php line 89:
Jan 18 19:57:30
Jan 18 19:57:30 An exception occurred while executing 'ALTER TABLE "wallabag_oauth2_clients
Jan 18 19:57:30 " DROP CONSTRAINT idx_user_oauth_client':
Jan 18 19:57:30
Jan 18 19:57:30 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Jan 18 19:57:30 ent" of relation "wallabag_oauth2_clients" does not exist
Jan 18 19:57:30
Jan 18 19:57:30
Jan 18 19:57:30 In PDOConnection.php line 91:
Jan 18 19:57:30
Jan 18 19:57:30 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Jan 18 19:57:30 ent" of relation "wallabag_oauth2_clients" does not exist
Jan 18 19:57:30
Jan 18 19:57:30
Jan 18 19:57:30 In PDOConnection.php line 86:
Jan 18 19:57:30
Jan 18 19:57:30 SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "idx_user_oauth_cli
Jan 18 19:57:30 ent" of relation "wallabag_oauth2_clients" does not exist
Jan 18 19:57:30
Jan 18 19:57:30
Jan 18 19:57:30 doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
Jan 18 19:57:30

[girish]

+1 for forking the app. I think we spend too much time trying to make it update from some ancient release. It might be easier to export and import into new wallabag.

[bubonicfred]

@girish I see you've done the fork, If we were already on 1.5.1 (fresh install so no migration issue) on the old app do we need to install the new app and migrate over?

[nebulon]

@bubonicfred that is correct, unfortunately you have to install a new instance and then import via the built-in export/import feature

[thetomester13]

@nebulon FWIW I was able to spin up an instance of the new version and migrate everything over without hiccup today. Fingers crossed that we won't need such a migration for future updates...