search

wallabag / docker

Official docker-composer for wallabag.
618 stars 154 forks source link

500s after an update and migration #211

Open rdelcorro opened 4 years ago

rdelcorro commented 4 years ago

Hi, I am seeing this error after an update:

Stack trace:
#0 /var/www/wallabag/vendor/craue/config-bundle/Util/Config.php(77): Craue\ConfigBundle\Util\Config->createNotFoundException('piwik_enabled')
#1 /var/www/wallabag/vendor/craue/config-bundle/Twig/Extension/ConfigTemplateExtension.php(96): Craue\ConfigBundle\Util\Config->get('piwik_enabled')
#2 /var/www/wallabag/var/cache/prod/twig/e5/e59b3c6ba046bc5541ec427c6fe013ac603e567122ed934d6dc17178083d1b89.php(96): Craue\ConfigBundle\Twig\Extension\ConfigTemplateExtension->getSetting('piwik_enabled')
#3 /var/www/wallabag/vendor/twig/twig/src/Template.php(443): __TwigTemplate_248ffdebaf41f0c401270de5135adaa2a06bcf1a73c1cf5c0f36284706bf3bb5->doDisplay(Array, Array)
#4 /var/www/wallabag/vendor/twig/twig/src/Template.php(414): Twig\Template->displayWithErrorHandling(Array, Array)
#5 /var/www/wallabag/var/cache/prod/twig/d9/d956e063b" while reading response header from upstream, client: 172.19.0.1, server: _, request: "GET /login HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "wallabag.home.ramirodelcorro.com"

I also followed the docs and migrated the database:

/ # /var/www/wallabag/bin/console doctrine:migrations:migrate --env=prod --no-interaction
PHP Warning:  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /var/www/wallabag/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php on line 2636
PHP Warning:  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /var/www/wallabag/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php on line 2665

                    Application Migrations                    

No migrations to execute.
j0k3r commented 4 years ago

If you got that error, it means that migration didn't run: https://github.com/wallabag/wallabag/blob/557e810c1f2b2e662f163fc419014e80d5484e3a/app/DoctrineMigrations/Version20200428072628.php

From which version to which version did you upgrade?

rdelcorro commented 4 years ago

Hi @j0k3r, I did see the migration output once, but I lost the shell. I did not know what version I had as this was a simple docker pull from latest. Is there a way to see detailed error logs somehow? I am using the official wallabag/wallabag:latest image with a database that is dedicated and linked to the container. Could it be that my env is not prod? What is the env that the container runs by default?

RaraAvis8 commented 4 years ago

I have the same error. I've updated from docker image 2.3.2(not sure about the last digit) to 2.3.8.

I've run migrations script and I saved the output:

Click to expand ``` Application Migrations Migrating up to 20171125164500 from 0 ++ migrating 20160401000000 -> CREATE TABLE `wallabag_craue_config_setting` (name VARCHAR(255) NOT NULL, value VARCHAR(255) DEFAULT NULL, section VARCHAR(255) DEFAULT NULL, PRIMARY KEY(name)); -> CREATE UNIQUE INDEX UNIQ_5D9649505E237E06 ON `wallabag_craue_config_setting` (name); -> CREATE TABLE `wallabag_tagging_rule` (id INTEGER NOT NULL, config_id INTEGER DEFAULT NULL, rule VARCHAR(255) NOT NULL, tags CLOB NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_2D9B3C5424DB0683 FOREIGN KEY (config_id) REFERENCES `wallabag_config` (id) NOT DEFERRABLE INITIALLY IMMEDIATE); -> CREATE INDEX IDX_2D9B3C5424DB0683 ON `wallabag_tagging_rule` (config_id); -> CREATE TABLE `wallabag_tag` (id INTEGER NOT NULL, label CLOB NOT NULL, slug VARCHAR(128) NOT NULL, PRIMARY KEY(id)); -> CREATE UNIQUE INDEX UNIQ_4CA58A8C989D9B62 ON `wallabag_tag` (slug); -> CREATE TABLE `wallabag_entry` (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, title CLOB DEFAULT NULL, url CLOB DEFAULT NULL, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL, language CLOB DEFAULT NULL, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL, preview_picture CLOB DEFAULT NULL, is_public BOOLEAN DEFAULT '0', PRIMARY KEY(id), CONSTRAINT FK_F4D18282A76ED395 FOREIGN KEY (user_id) REFERENCES `wallabag_user` (id) NOT DEFERRABLE INITIALLY IMMEDIATE); -> CREATE INDEX IDX_F4D18282A76ED395 ON `wallabag_entry` (user_id); -> CREATE TABLE `wallabag_entry_tag` (entry_id INTEGER NOT NULL, tag_id INTEGER NOT NULL, PRIMARY KEY(entry_id, tag_id), CONSTRAINT FK_C9F0DD7CBA364942 FOREIGN KEY (entry_id) REFERENCES `wallabag_entry` (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_C9F0DD7CBAD26311 FOREIGN KEY (tag_id) REFERENCES `wallabag_tag` (id) NOT DEFERRABLE INITIALLY IMMEDIATE); -> CREATE INDEX IDX_C9F0DD7CBA364942 ON `wallabag_entry_tag` (entry_id); -> CREATE INDEX IDX_C9F0DD7CBAD26311 ON `wallabag_entry_tag` (tag_id); -> CREATE TABLE `wallabag_config` (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, theme VARCHAR(255) NOT NULL, items_per_page INTEGER NOT NULL, language VARCHAR(255) NOT NULL, rss_token VARCHAR(255) DEFAULT NULL, rss_limit INTEGER DEFAULT NULL, reading_speed DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY(id), CONSTRAINT FK_87E64C53A76ED395 FOREIGN KEY (user_id) REFERENCES `wallabag_user` (id) NOT DEFERRABLE INITIALLY IMMEDIATE); -> CREATE UNIQUE INDEX UNIQ_87E64C53A76ED395 ON `wallabag_config` (user_id); -> CREATE TABLE `wallabag_oauth2_refresh_tokens` (id INTEGER NOT NULL, client_id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, token VARCHAR(255) NOT NULL, expires_at INTEGER DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id), CONSTRAINT FK_20C9FB2419EB6921 FOREIGN KEY (client_id) REFERENCES `wallabag_oauth2_clients` (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_20C9FB24A76ED395 FOREIGN KEY (user_id) REFERENCES `wallabag_user` (id) NOT DEFERRABLE INITIALLY IMMEDIATE); -> CREATE UNIQUE INDEX UNIQ_20C9FB245F37A13B ON `wallabag_oauth2_refresh_tokens` (token); -> CREATE INDEX IDX_20C9FB2419EB6921 ON `wallabag_oauth2_refresh_tokens` (client_id); -> CREATE INDEX IDX_20C9FB24A76ED395 ON `wallabag_oauth2_refresh_tokens` (user_id); -> CREATE TABLE `wallabag_oauth2_access_tokens` (id INTEGER NOT NULL, client_id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, token VARCHAR(255) NOT NULL, expires_at INTEGER DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id), CONSTRAINT FK_368A420919EB6921 FOREIGN KEY (client_id) REFERENCES `wallabag_oauth2_clients` (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_368A4209A76ED395 FOREIGN KEY (user_id) REFERENCES `wallabag_user` (id) NOT DEFERRABLE INITIALLY IMMEDIATE); -> CREATE UNIQUE INDEX UNIQ_368A42095F37A13B ON `wallabag_oauth2_access_tokens` (token); -> CREATE INDEX IDX_368A420919EB6921 ON `wallabag_oauth2_access_tokens` (client_id); -> CREATE INDEX IDX_368A4209A76ED395 ON `wallabag_oauth2_access_tokens` (user_id); -> CREATE TABLE `wallabag_oauth2_auth_codes` (id INTEGER NOT NULL, client_id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, token VARCHAR(255) NOT NULL, redirect_uri CLOB NOT NULL, expires_at INTEGER DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id), CONSTRAINT FK_EE52E3FA19EB6921 FOREIGN KEY (client_id) REFERENCES `wallabag_oauth2_clients` (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_EE52E3FAA76ED395 FOREIGN KEY (user_id) REFERENCES `wallabag_user` (id) NOT DEFERRABLE INITIALLY IMMEDIATE); -> CREATE UNIQUE INDEX UNIQ_EE52E3FA5F37A13B ON `wallabag_oauth2_auth_codes` (token); -> CREATE INDEX IDX_EE52E3FA19EB6921 ON `wallabag_oauth2_auth_codes` (client_id); -> CREATE INDEX IDX_EE52E3FAA76ED395 ON `wallabag_oauth2_auth_codes` (user_id); -> CREATE TABLE `wallabag_oauth2_clients` (id INTEGER NOT NULL, random_id VARCHAR(255) NOT NULL, redirect_uris CLOB NOT NULL, secret VARCHAR(255) NOT NULL, allowed_grant_types CLOB NOT NULL, PRIMARY KEY(id)); -> CREATE TABLE `wallabag_user` (id INTEGER NOT NULL, username VARCHAR(180) NOT NULL, username_canonical VARCHAR(180) NOT NULL, email VARCHAR(180) NOT NULL, email_canonical VARCHAR(180) NOT NULL, enabled BOOLEAN NOT NULL, salt VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, last_login DATETIME DEFAULT NULL, locked BOOLEAN NOT NULL, expired BOOLEAN NOT NULL, expires_at DATETIME DEFAULT NULL, confirmation_token VARCHAR(255) DEFAULT NULL, password_requested_at DATETIME DEFAULT NULL, roles CLOB NOT NULL, credentials_expired BOOLEAN NOT NULL, credentials_expire_at DATETIME DEFAULT NULL, name CLOB DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, authCode INTEGER DEFAULT NULL, twoFactorAuthentication BOOLEAN NOT NULL, trusted CLOB DEFAULT NULL, PRIMARY KEY(id)); -> CREATE UNIQUE INDEX UNIQ_1D63E7E592FC23A8 ON `wallabag_user` (username_canonical); -> CREATE UNIQUE INDEX UNIQ_1D63E7E5A0D96FBF ON `wallabag_user` (email_canonical); -> CREATE UNIQUE INDEX UNIQ_1D63E7E5C05FB297 ON `wallabag_user` (confirmation_token); -> CREATE TABLE `wallabag_annotation` (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, entry_id INTEGER DEFAULT NULL, text CLOB NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, quote VARCHAR(255) NOT NULL, ranges CLOB NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_A7AED006A76ED395 FOREIGN KEY (user_id) REFERENCES `wallabag_user` (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A7AED006BA364942 FOREIGN KEY (entry_id) REFERENCES `wallabag_entry` (id) NOT DEFERRABLE INITIALLY IMMEDIATE); -> CREATE INDEX IDX_A7AED006A76ED395 ON `wallabag_annotation` (user_id); -> CREATE INDEX IDX_A7AED006BA364942 ON `wallabag_annotation` (entry_id); ++ migrated (0.11s) ++ migrating 20160410190541 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('share_public', '1', 'entry') -> ALTER TABLE wallabag_entry ADD COLUMN uid VARCHAR(23) DEFAULT NULL ++ migrated (0.02s) ++ migrating 20160812120952 -> CREATE TEMPORARY TABLE __temp__wallabag_oauth2_clients AS SELECT id, random_id, redirect_uris, secret, allowed_grant_types FROM wallabag_oauth2_clients -> DROP TABLE wallabag_oauth2_clients -> CREATE TABLE wallabag_oauth2_clients (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, random_id VARCHAR(255) NOT NULL COLLATE BINARY, secret VARCHAR(255) NOT NULL COLLATE BINARY, redirect_uris CLOB NOT NULL, allowed_grant_types CLOB NOT NULL, name CLOB NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_635D765EA76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE) -> INSERT INTO wallabag_oauth2_clients (id, random_id, redirect_uris, secret, allowed_grant_types) SELECT id, random_id, redirect_uris, secret, allowed_grant_types FROM __temp__wallabag_oauth2_clients -> DROP TABLE __temp__wallabag_oauth2_clients -> CREATE INDEX IDX_635D765EA76ED395 ON wallabag_oauth2_clients (user_id) ++ migrated (0.02s) ++ migrating 20160911214952 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('import_with_redis', 0, 'import') -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('import_with_rabbitmq', 0, 'import') ++ migrated (0s) ++ migrating 20160916201049 -> DELETE FROM `wallabag_craue_config_setting` WHERE name = 'pocket_consumer_key'; -> ALTER TABLE wallabag_config ADD COLUMN pocket_consumer_key VARCHAR(255) DEFAULT NULL ++ migrated (0.02s) ++ migrating 20161001072726 SS skipped (Reason: Migration can only be executed safely on 'mysql' or 'postgresql'.) ++ migrating 20161022134138 SS skipped (Reason: This migration only apply to MySQL) ++ migrating 20161024212538 SS skipped (Reason: It seems that you already played this migration.) ++ migrating 20161031132655 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('download_images_enabled', 0, 'misc') ++ migrated (0s) ++ migrating 20161104073720 -> DROP INDEX IDX_F4D18282A76ED395 -> CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid FROM wallabag_entry -> DROP TABLE wallabag_entry -> CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id)) -> INSERT INTO wallabag_entry (id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid) SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid FROM __temp__wallabag_entry -> DROP TABLE __temp__wallabag_entry -> CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id) -> CREATE INDEX IDX_entry_created_at ON wallabag_entry (created_at) ++ migrated (0.02s) ++ migrating 20161106113822 -> ALTER TABLE wallabag_config ADD COLUMN action_mark_as_read INTEGER DEFAULT 0 ++ migrated (0.02s) ++ migrating 20161117071626 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('share_unmark', 0, 'entry') -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('unmark_url', 'https://unmark.it', 'entry') ++ migrated (0s) ++ migrating 20161118134328 -> ALTER TABLE wallabag_entry ADD COLUMN http_status VARCHAR(3) DEFAULT NULL ++ migrated (0.02s) ++ migrating 20161122144743 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('restricted_access', 0, 'entry') ++ migrated (0s) ++ migrating 20161122203647 -> DROP INDEX UNIQ_1D63E7E5C05FB297 -> DROP INDEX UNIQ_1D63E7E5A0D96FBF -> DROP INDEX UNIQ_1D63E7E592FC23A8 -> CREATE TEMPORARY TABLE __temp__wallabag_user AS SELECT id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expires_at, confirmation_token, password_requested_at, roles, credentials_expire_at, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted FROM wallabag_user -> DROP TABLE wallabag_user -> CREATE TABLE wallabag_user (id INTEGER NOT NULL, username VARCHAR(180) NOT NULL COLLATE BINARY, username_canonical VARCHAR(180) NOT NULL COLLATE BINARY, email VARCHAR(180) NOT NULL COLLATE BINARY, email_canonical VARCHAR(180) NOT NULL COLLATE BINARY, enabled BOOLEAN NOT NULL, salt VARCHAR(255) NOT NULL COLLATE BINARY, password VARCHAR(255) NOT NULL COLLATE BINARY, last_login DATETIME DEFAULT NULL, locked BOOLEAN NOT NULL, expires_at DATETIME DEFAULT NULL, confirmation_token VARCHAR(255) DEFAULT NULL COLLATE BINARY, password_requested_at DATETIME DEFAULT NULL, roles CLOB NOT NULL COLLATE BINARY, credentials_expire_at DATETIME DEFAULT NULL, name CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, authCode INTEGER DEFAULT NULL, twoFactorAuthentication BOOLEAN NOT NULL, trusted CLOB DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id)) -> INSERT INTO wallabag_user (id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expires_at, confirmation_token, password_requested_at, roles, credentials_expire_at, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted) SELECT id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expires_at, confirmation_token, password_requested_at, roles, credentials_expire_at, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted FROM __temp__wallabag_user -> DROP TABLE __temp__wallabag_user -> CREATE UNIQUE INDEX UNIQ_1D63E7E5C05FB297 ON wallabag_user (confirmation_token) -> CREATE UNIQUE INDEX UNIQ_1D63E7E5A0D96FBF ON wallabag_user (email_canonical) -> CREATE UNIQUE INDEX UNIQ_1D63E7E592FC23A8 ON wallabag_user (username_canonical) ++ migrated (0.02s) ++ migrating 20161128084725 -> ALTER TABLE wallabag_config ADD COLUMN list_mode INTEGER DEFAULT NULL ++ migrated (0.02s) ++ migrating 20161128131503 -> DROP INDEX UNIQ_1D63E7E592FC23A8 -> DROP INDEX UNIQ_1D63E7E5A0D96FBF -> DROP INDEX UNIQ_1D63E7E5C05FB297 -> CREATE TEMPORARY TABLE __temp__wallabag_user AS SELECT id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted FROM wallabag_user -> DROP TABLE wallabag_user -> CREATE TABLE wallabag_user (id INTEGER NOT NULL, username VARCHAR(180) NOT NULL COLLATE BINARY, username_canonical VARCHAR(180) NOT NULL COLLATE BINARY, email VARCHAR(180) NOT NULL COLLATE BINARY, email_canonical VARCHAR(180) NOT NULL COLLATE BINARY, enabled BOOLEAN NOT NULL, salt VARCHAR(255) NOT NULL COLLATE BINARY, password VARCHAR(255) NOT NULL COLLATE BINARY, last_login DATETIME DEFAULT NULL, confirmation_token VARCHAR(255) DEFAULT NULL COLLATE BINARY, password_requested_at DATETIME DEFAULT NULL, roles CLOB NOT NULL COLLATE BINARY, name CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, authCode INTEGER DEFAULT NULL, twoFactorAuthentication BOOLEAN NOT NULL, trusted CLOB DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id)) -> INSERT INTO wallabag_user (id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted) SELECT id, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, name, created_at, updated_at, authCode, twoFactorAuthentication, trusted FROM __temp__wallabag_user -> DROP TABLE __temp__wallabag_user -> CREATE UNIQUE INDEX UNIQ_1D63E7E592FC23A8 ON wallabag_user (username_canonical) -> CREATE UNIQUE INDEX UNIQ_1D63E7E5A0D96FBF ON wallabag_user (email_canonical) -> CREATE UNIQUE INDEX UNIQ_1D63E7E5C05FB297 ON wallabag_user (confirmation_token) ++ migrated (0.02s) ++ migrating 20161214094402 SS skipped (Reason: It seems that you already played this migration.) ++ migrating 20161214094403 -> DROP INDEX IDX_entry_created_at -> DROP INDEX IDX_F4D18282A76ED395 -> CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid, http_status FROM wallabag_entry -> DROP TABLE wallabag_entry -> CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id)) -> INSERT INTO wallabag_entry (id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid, http_status) SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid, http_status FROM __temp__wallabag_entry -> DROP TABLE __temp__wallabag_entry -> CREATE INDEX IDX_entry_created_at ON wallabag_entry (created_at) -> CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id) -> CREATE INDEX IDX_entry_uid ON wallabag_entry (uid) ++ migrated (0.03s) ++ migrating 20170127093841 -> DROP INDEX IDX_entry_uid -> DROP INDEX IDX_F4D18282A76ED395 -> DROP INDEX IDX_entry_created_at -> CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid, http_status FROM wallabag_entry -> DROP TABLE wallabag_entry -> CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, is_public BOOLEAN DEFAULT '0', uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id)) -> INSERT INTO wallabag_entry (id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid, http_status) SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, uid, http_status FROM __temp__wallabag_entry -> DROP TABLE __temp__wallabag_entry -> CREATE INDEX IDX_entry_uid ON wallabag_entry (uid) -> CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id) -> CREATE INDEX IDX_entry_created_at ON wallabag_entry (created_at) -> CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred) -> CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived) ++ migrated (0.02s) ++ migrating 20170327194233 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('share_scuttle', '1', 'entry') -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('scuttle_url', 'http://scuttle.org', 'entry') ++ migrated (0s) ++ migrating 20170405182620 -> ALTER TABLE wallabag_entry ADD COLUMN published_at DATETIME DEFAULT NULL -> ALTER TABLE wallabag_entry ADD COLUMN published_by CLOB DEFAULT NULL ++ migrated (0.02s) ++ migrating 20170407200919 -> DROP INDEX IDX_entry_archived -> DROP INDEX IDX_entry_starred -> DROP INDEX IDX_entry_created_at -> DROP INDEX IDX_F4D18282A76ED395 -> DROP INDEX IDX_entry_uid -> CREATE TEMPORARY TABLE __temp__wallabag_entry AS SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, uid, http_status, published_at, published_by FROM wallabag_entry -> DROP TABLE wallabag_entry -> CREATE TABLE wallabag_entry (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, title CLOB DEFAULT NULL COLLATE BINARY, url CLOB DEFAULT NULL COLLATE BINARY, is_archived BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content CLOB DEFAULT NULL COLLATE BINARY, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, mimetype CLOB DEFAULT NULL COLLATE BINARY, language CLOB DEFAULT NULL COLLATE BINARY, reading_time INTEGER DEFAULT NULL, domain_name CLOB DEFAULT NULL COLLATE BINARY, preview_picture CLOB DEFAULT NULL COLLATE BINARY, uid VARCHAR(23) DEFAULT NULL COLLATE BINARY, http_status VARCHAR(3) DEFAULT NULL COLLATE BINARY, published_at DATETIME DEFAULT NULL, published_by CLOB DEFAULT NULL COLLATE BINARY, PRIMARY KEY(id)) -> INSERT INTO wallabag_entry (id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, uid, http_status, published_at, published_by) SELECT id, user_id, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, uid, http_status, published_at, published_by FROM __temp__wallabag_entry -> DROP TABLE __temp__wallabag_entry -> CREATE INDEX IDX_entry_archived ON wallabag_entry (is_archived) -> CREATE INDEX IDX_entry_starred ON wallabag_entry (is_starred) -> CREATE INDEX IDX_entry_created_at ON wallabag_entry (created_at) -> CREATE INDEX IDX_F4D18282A76ED395 ON wallabag_entry (user_id) -> CREATE INDEX IDX_entry_uid ON wallabag_entry (uid) ++ migrated (0.03s) ++ migrating 20170420134133 -> DELETE FROM `wallabag_craue_config_setting` WHERE name = 'download_pictures'; ++ migrated (0s) ++ migrating 20170501115751 -> CREATE TABLE "wallabag_site_credential" (id INTEGER NOT NULL, user_id INTEGER NOT NULL, host VARCHAR(255) NOT NULL, username CLOB NOT NULL, password CLOB NOT NULL, createdAt DATETIME NOT NULL, PRIMARY KEY(id)) -> CREATE INDEX idx_user ON "wallabag_site_credential" (user_id) ++ migrated (0.02s) ++ migrating 20170510082609 SS skipped (Reason: This migration only apply to MySQL) ++ migrating 20170511115400 -> ALTER TABLE wallabag_entry ADD COLUMN headers CLOB DEFAULT NULL ++ migrated (0.02s) ++ migrating 20170511211659 -> CREATE TEMPORARY TABLE __temp__wallabag_annotation AS SELECT id, user_id, entry_id, text, created_at, updated_at, quote, ranges FROM `wallabag_annotation` -> DROP TABLE `wallabag_annotation` -> CREATE TABLE `wallabag_annotation` ( id INTEGER PRIMARY KEY NOT NULL, user_id INTEGER DEFAULT NULL, entry_id INTEGER DEFAULT NULL, text CLOB NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, quote CLOB NOT NULL, ranges CLOB NOT NULL, CONSTRAINT FK_A7AED006A76ED395 FOREIGN KEY (user_id) REFERENCES wallabag_user (id), CONSTRAINT FK_A7AED006BA364942 FOREIGN KEY (entry_id) REFERENCES wallabag_entry (id) ON DELETE CASCADE ); CREATE INDEX IDX_A7AED006A76ED395 ON wallabag_annotation (user_id); CREATE INDEX IDX_A7AED006BA364942 ON wallabag_annotation (entry_id); -> INSERT INTO `wallabag_annotation` (id, user_id, entry_id, text, created_at, updated_at, quote, ranges) SELECT id, user_id, entry_id, text, created_at, updated_at, quote, ranges FROM __temp__wallabag_annotation; -> DROP TABLE __temp__wallabag_annotation ++ migrated (0s) ++ migrating 20170602075214 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('api_user_registration', '0', 'api') ++ migrated (0s) ++ migrating 20170606155640 SS skipped (Reason: It seems that you already played this migration.) ++ migrating 20170719231144 SS skipped (Reason: Migration can only be executed safely on 'mysql' or 'postgresql'.) ++ migrating 20170824113337 -> ALTER TABLE wallabag_entry ADD COLUMN starred_at DATETIME DEFAULT NULL ++ migrated (0.02s) ++ migrating 20171008195606 SS skipped (Reason: Migration can only be executed safely on 'mysql' or 'postgresql'.) ++ migrating 20171105202000 -> ALTER TABLE wallabag_entry ADD COLUMN origin_url CLOB DEFAULT NULL ++ migrated (0.02s) ++ migrating 20171120163128 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('store_article_headers', '0', 'entry') ++ migrated (0s) ++ migrating 20171125164500 -> INSERT INTO `wallabag_craue_config_setting` (name, value, section) VALUES ('shaarli_share_origin_url', '0', 'entry') ++ migrated (0s) ------------------------ ++ finished in 0.47s ++ 36 migrations executed ++ 138 sql queries ```

As you can see the migration that @j0k3r has mentioned didn't run.

My output after startup:

Click to expand ``` Starting provisioner... [WARNING]: Found both group and host with same name: localhost PLAY [localhost] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var TASK [Gathering Facts] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var ok: [localhost] TASK [needed dirs] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var ok: [localhost] => (item=/var/www/wallabag/app) ok: [localhost] => (item=/var/www/wallabag/app/config) ok: [localhost] => (item=/var/www/wallabag/data) ok: [localhost] => (item=/var/www/wallabag/data/assets) ok: [localhost] => (item=/var/www/wallabag/data/db) TASK [write parameters.yml] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var ok: [localhost] TASK [stat] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var skipping: [localhost] TASK [notify install for sqlite] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var skipping: [localhost] TASK [wait for db container] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var ok: [localhost] TASK [add mariadb db] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var ok: [localhost] TASK [add mariadb user] bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var An exception occurred during task execution. To see the full traceback, use -vvv. The error was: InvalidPrivsError: unable to parse the MySQL grant string: GRANT USAGE ON entrypoint.sh TO `wallabag`@`%` IDENTIFIED BY PASSWORD '*923BF1CA46DC359979E118F0D054CB07F766D0EF' fatal: [localhost]: FAILED! => {"changed": false, "msg": "unable to parse the MySQL grant string: GRANT USAGE ON entrypoint.sh TO `wallabag`@`%` IDENTIFIED BY PASSWORD '*923BF1CA46DC359979E118F0D054CB07F766D0EF'"} to retry, use: --limit @/etc/ansible/entrypoint.retry PLAY RECAP bin dev entrypoint.sh etc home lib media mnt opt proc root run sbin srv sys tmp usr var localhost : ok=5 changed=0 unreachable=0 failed=1 Provisioner finished. 2020/09/16 17:41:24 [error] 169#169: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught RuntimeException: Setting "piwik_enabled" couldn't be found. in /var/www/wallabag/vendor/craue/config-bundle/Util/Config.php:182 Stack trace: #0 /var/www/wallabag/vendor/craue/config-bundle/Util/Config.php(77): Craue\ConfigBundle\Util\Config->createNotFoundException('piwik_enabled') #1 /var/www/wallabag/vendor/craue/config-bundle/Twig/Extension/ConfigTemplateExtension.php(96): Craue\ConfigBundle\Util\Config->get('piwik_enabled') #2 /var/www/wallabag/var/cache/prod/twig/99/994fd5ff685e7766b0b98f065dbf9bc1cee41d3a1fd7e273dad03ec77de406ea.php(96): Craue\ConfigBundle\Twig\Extension\ConfigTemplateExtension->getSetting('piwik_enabled') #3 /var/www/wallabag/vendor/twig/twig/src/Template.php(443): __TwigTemplate_db4337c191a6c07fb38e9dd6d101d488171a837afe3f6b3afeb0583405165c3c->doDisplay(Array, Array) #4 /var/www/wallabag/vendor/twig/twig/src/Template.php(414): Twig\Template->displayWithErrorHandling(Array, Array) #5 /var/www/wallabag/var/cache/prod/twig/75/7509a9153df8a4c2f" while reading response header from upstream, client: 172.18.0.7, server: _, request: "GET /login HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "wallabag.yurtagames.com" 172.18.0.7 - - [16/Sep/2020:17:41:24 +0000] "GET /login HTTP/1.1" 500 31 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" 2020/09/16 17:41:35 [error] 169#169: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught RuntimeException: Setting "piwik_enabled" couldn't be found. in /var/www/wallabag/vendor/craue/config-bundle/Util/Config.php:182 Stack trace: #0 /var/www/wallabag/vendor/craue/config-bundle/Util/Config.php(77): Craue\ConfigBundle\Util\Config->createNotFoundException('piwik_enabled') #1 /var/www/wallabag/vendor/craue/config-bundle/Twig/Extension/ConfigTemplateExtension.php(96): Craue\ConfigBundle\Util\Config->get('piwik_enabled') #2 /var/www/wallabag/var/cache/prod/twig/99/994fd5ff685e7766b0b98f065dbf9bc1cee41d3a1fd7e273dad03ec77de406ea.php(96): Craue\ConfigBundle\Twig\Extension\ConfigTemplateExtension->getSetting('piwik_enabled') #3 /var/www/wallabag/vendor/twig/twig/src/Template.php(443): __TwigTemplate_db4337c191a6c07fb38e9dd6d101d488171a837afe3f6b3afeb0583405165c3c->doDisplay(Array, Array) #4 /var/www/wallabag/vendor/twig/twig/src/Template.php(414): Twig\Template->displayWithErrorHandling(Array, Array) 172.18.0.7 - - [16/Sep/2020:17:41:35 +0000] "GET /login HTTP/1.1" 500 31 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" #5 /var/www/wallabag/var/cache/prod/twig/75/7509a9153df8a4c2f" while reading response header from upstream, client: 172.18.0.7, server: _, request: "GET /login HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "wallabag.yurtagames.com" 172.18.0.7 - - [16/Sep/2020:18:06:24 +0000] "POST /oauth/v2/token HTTP/1.1" 400 98 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" 172.18.0.7 - - [16/Sep/2020:18:06:24 +0000] "POST /oauth/v2/token HTTP/1.1" 400 98 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" 172.18.0.7 - - [16/Sep/2020:18:06:29 +0000] "POST /oauth/v2/token HTTP/1.1" 400 98 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" 172.18.0.7 - - [16/Sep/2020:18:06:35 +0000] "POST /oauth/v2/token HTTP/1.1" 400 98 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" 172.18.0.7 - - [16/Sep/2020:18:06:59 +0000] "POST /oauth/v2/token HTTP/1.1" 400 98 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" 172.18.0.7 - - [16/Sep/2020:18:07:28 +0000] "POST /oauth/v2/token HTTP/1.1" 400 98 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" 2020/09/16 18:07:34 [error] 169#169: *11 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught RuntimeException: Setting "piwik_enabled" couldn't be found. in /var/www/wallabag/vendor/craue/config-bundle/Util/Config.php:182 Stack trace: #0 /var/www/wallabag/vendor/craue/config-bundle/Util/Config.php(77): Craue\ConfigBundle\Util\Config->createNotFoundException('piwik_enabled') #1 /var/www/wallabag/vendor/craue/config-bundle/Twig/Extension/ConfigTemplateExtension.php(96): Craue\ConfigBundle\Util\Config->get('piwik_enabled') #2 /var/www/wallabag/var/cache/prod/twig/99/994fd5ff685e7766b0b98f065dbf9bc1cee41d3a1fd7e273dad03ec77de406ea.php(96): Craue\ConfigBundle\Twig\Extension\ConfigTemplateExtension->getSetting('piwik_enabled') #3 /var/www/wallabag/vendor/twig/twig/src/Template.php(443): __TwigTemplate_db4337c191a6c07fb38e9dd6d101d488171a837afe3f6b3afeb0583405165c3c->doDisplay(Array, Array) #4 /var/www/wallabag/vendor/twig/twig/src/Template.php(414): Twig\Template->displayWithErrorHandling(Array, Array) #5 /var/www/wallabag/var/cache/prod/twig/75/7509a9153df8a4c2f" while reading response header from upstream, client: 172.18.0.7, server: _, request: "GET /login HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "wallabag.yurtagames.com" 172.18.0.7 - - [16/Sep/2020:18:07:34 +0000] "GET /login HTTP/1.1" 500 31 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36" ```

Versions that I use:

RaraAvis8 commented 4 years ago

I've updated to the latest docker image and I've connected to the container and there no Version20200428072628.php migration in it:

/var/www/wallabag/app/DoctrineMigrations # ls
Version20160401000000.php  Version20161022134138.php  Version20161118134328.php  Version20161214094403.php  Version20170501115751.php  Version20170719231144.php
Version20160410190541.php  Version20161024212538.php  Version20161122144743.php  Version20170127093841.php  Version20170510082609.php  Version20170824113337.php
Version20160812120952.php  Version20161031132655.php  Version20161122203647.php  Version20170327194233.php  Version20170511115400.php  Version20171008195606.php
Version20160911214952.php  Version20161104073720.php  Version20161128084725.php  Version20170405182620.php  Version20170511211659.php  Version20171105202000.php
Version20160916201049.php  Version20161106113822.php  Version20161128131503.php  Version20170407200919.php  Version20170602075214.php  Version20171120163128.php
Version20161001072726.php  Version20161117071626.php  Version20161214094402.php  Version20170420134133.php  Version20170606155640.php  Version20171125164500.php