App "Not responding" after [2.6.0] update
-
Dear All,
I've app "Not responding" after 2.6.0 update, with this error code:
Aug 05 08:54:06 [06:54:06/13] Lock: update.lock Aug 05 08:54:06 [06:54:06/13] Type 'yes' to continue. Aug 05 08:54:06 [06:54:06/13] Starting migration to 147... Aug 05 08:54:06 [06:54:06/13] Failed on line: create fulltext index ttrss_entries_title_search_idx on ttrss_entries(title) Aug 05 08:54:06 [06:54:06/13] Migration failed: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ttrss_entries_title_search_idx' Aug 05 08:54:06 PHP Warning: Failed to apply migration 147 for ttrss_version: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ttrss_entries_title_search_idx' in /app/code/classes/db/migrations.php on line 191 Aug 05 08:54:19 ==> Creating config Aug 05 08:54:19 ==> Changing permissions Aug 05 08:54:19 ==> Updating schema
-
@girish I went back to 2.5.0 and now it works... Later on I'll try again to update and I'll let to know.
-
@girish Hello Girish, I tried again to update to 2.6.0 and problem is still there. Problem is always reproducible.
-
@girish No issues with two instances here...
-
Yeah quite strange because all our other instances updated well.
But this exact same error is reported upstream at https://community.tt-rss.org/t/plugin-suggestion-similar-articles-as-read-but-for-mysql/4994 and the fix is https://dev.tt-rss.org/fox/tt-rss/commit/b148d2f5153f9711120b3a3ac50ee84509c9cdfb which is already in the package...
-
Also just updated with no issues here.
-
@girish Thank's Girish, I updated again and now is all fine. Thank's a lot
-
@girish I have has the same issue after automatic update to 2.6
I tried to revert and update it again, but it still fails, here's where it gets stuck:
ug 07 16:18:28 ==> Creating config Aug 07 16:18:28 ==> Changing permissions Aug 07 16:18:28 ==> Updating schema Aug 07 16:18:28 [14:18:28/12] Lock: update.lock Aug 07 16:18:28 [14:18:28/12] Type 'yes' to continue. Aug 07 16:18:28 [14:18:28/12] Starting migration to 147...
Have reverted to 2.5 for now.
-
@p44 said in App "Not responding" after [2.6.0] update:
Aug 05 08:54:06 PHP Warning: Failed to apply migration 147 for ttrss_version: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ttrss_entries_title_search_idx' in /app/code/classes/db/migrations.php on line 191
@ruihildt Do you get the same error as above? If so, can you put the app in repair mode and tell me what's on line 191 above?
-
ruihildtreplied to girish on Aug 15, 2022, 1:58 PM last edited by ruihildt Aug 15, 2022, 1:59 PM
Here's the relevant function, line 191 is the second exception:
function migrate() : bool { if ($this->get_version() == -1) { try { $this->migrate_to(0); } catch (PDOException $e) { user_error("Failed to load base schema for {$this->migrations_table}: " . $e->getMessage(), E_USER_WARNING); return false; } } for ($i = $this->get_version() + 1; $i <= $this->get_max_version(); $i++) { try { $this->migrate_to($i); } catch (PDOException $e) { user_error("Failed to apply migration ${i} for {$this->migrations_table}: " . $e->getMessage(), E_USER_WARNING); return false; //throw $e; } } return !$this->is_migration_needed(); }
-
@ruihildt Is this fix there - https://dev.tt-rss.org/fox/tt-rss/commit/b148d2f5153f9711120b3a3ac50ee84509c9cdfb ?
-
@ruihildt said in App "Not responding" after [2.6.0] update:
I tried to revert and update it again, but it still fails, here's where it gets stuck:
Just to double check, is your issue same as the original issue? Or is the issue that the migration gets stuck (in which case, this is some other issue) ?
3/16