Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

App "Not responding" after [2.6.0] update

Scheduled Pinned Locked Moved Tiny Tiny RSS
16 Posts 5 Posters 432 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    p44 translator
    wrote on last edited by
    #1

    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
    
    girishG 2 Replies Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to p44 on last edited by
    #2

    @p44 Is it always reproducible? If you roll back to previous version and then try to update again?

    I have stopped ttrss updates in the meantime.

    P necrevistonnezrN 3 Replies Last reply
    0
  • P Offline
    P Offline
    p44 translator
    replied to girish on last edited by
    #3

    @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.

    1 Reply Last reply
    0
  • P Offline
    P Offline
    p44 translator
    replied to girish on last edited by
    #4

    @girish Hello Girish, I tried again to update to 2.6.0 and problem is still there. Problem is always reproducible.

    1 Reply Last reply
    0
  • necrevistonnezrN Offline
    necrevistonnezrN Offline
    necrevistonnezr
    replied to girish on last edited by
    #5

    @girish No issues with two instances here...

    1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    wrote on last edited by
    #6

    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...

    P 1 Reply Last reply
    2
  • B Offline
    B Offline
    borg
    wrote on last edited by
    #7

    Also just updated with no issues here.

    1 Reply Last reply
    0
  • P Offline
    P Offline
    p44 translator
    replied to girish on last edited by
    #8

    @girish Thank's Girish, I updated again and now is all fine. Thank's a lot

    1 Reply Last reply
    0
  • ruihildtR Offline
    ruihildtR Offline
    ruihildt
    wrote on last edited by ruihildt
    #9

    @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.

    girishG 2 Replies Last reply
    1
  • girishG Offline
    girishG Offline
    girish Staff
    replied to ruihildt on last edited by
    #10

    @ruihildt Looks like maybe there is some race in upstream migration logic, maybe you can try to clone+update and see if it's reproducible.

    ruihildtR 1 Reply Last reply
    1
  • ruihildtR Offline
    ruihildtR Offline
    ruihildt
    replied to girish on last edited by
    #11

    @girish I duplicated the app from a backup and tried to update, and it still fails.

    What should I do next?

    1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to p44 on last edited by
    #12

    @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?

    ruihildtR 1 Reply Last reply
    0
  • ruihildtR Offline
    ruihildtR Offline
    ruihildt
    replied to girish on last edited by ruihildt
    #13

    @girish

    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();
    	}
    
    girishG 1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to ruihildt on last edited by
    #14

    @ruihildt Is this fix there - https://dev.tt-rss.org/fox/tt-rss/commit/b148d2f5153f9711120b3a3ac50ee84509c9cdfb ?

    ruihildtR 1 Reply Last reply
    0
  • ruihildtR Offline
    ruihildtR Offline
    ruihildt
    replied to girish on last edited by
    #15

    @girish Yes.

    1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to ruihildt on last edited by
    #16

    @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) ?

    1 Reply Last reply
    0

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.