Tiny Tiny RSS - might drop support for MySQL

[girish]

@necrevistonnezr Do you happen to know what's the latest on MySQL support ? https://community.tt-rss.org/t/failed-updating-to-version-136/2096/24 atleast says "it won't happen" .

I can't find any db preference info in https://tt-rss.org/wiki/InstallationNotes atleast (many links there are broken). https://tt-rss.org/wiki/InstallationNotesHost says anything is OK but the document itself is deprecated.

[girish]

Digging the forum further:

• It seem OPML is the way to migrate - https://community.tt-rss.org/t/upgrade-path-from-a-very-old-version/5081/2 . This might be a bit lossy though.
• MySQL support flakiness - https://community.tt-rss.org/t/looks-like-mysql-in-tt-rss-is-over-upd-or-is-it/4368 and https://community.tt-rss.org/t/errors-on-edit-feed-and-edit-filter-dialogs/4365 .

So, any opposition for just creating a new TTRSS package with Postgres and deprecate the current one?

[necrevistonnezr]

@girish Not from me…

[nebulon]

We've released a new package with a new appstore id for the postgresql version of tinytinyrss. This is a whole new package, so automatic updates will not migrate to postgres, as there is no good way to automatically migrate.

We've written the steps to migrate over via OPML at https://docs.cloudron.io/apps/tinytinyrss/#migrating-from-mysql-to-postgresql

[necrevistonnezr]

My suggestion is to include migrating steps for your plugins as well! If people forget, they might need to reconfigure their plugins (incl. Fever to connect to a whole bunch of apps) as well....

[necrevistonnezr]

After reimporting the OPML (mind you: including settings), none of my feeds update anymore:

Update process failed with exit code: 110 ()

[nebulon]

do you have any more context to that error? Worked here for my instance, it took the app a bit to catch up with all feeds though.

[necrevistonnezr]

Could be the - built-in! - plugin af_psql_trgm: Marks similar articles as read (requires pg_trgm):

Apr 22 14:31:51 [14:31:51/8] Base feed: https://roundcube.net/feeds/atom.xml
Apr 22 14:31:51 [14:31:51/8] => Roundcube Webmail Project News (ID: 71, U: kdj [2]), last updated: never
Apr 22 14:31:51 [14:31:51/164] Lock: update_daemon-feed-71.lock
Apr 22 14:31:52 PHP Warning: PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR: function "similarity" does not exist
Apr 22 14:31:52 LINE 1: select 'similarity'::regproc
Apr 22 14:31:52 ^ in /app/code/plugins/af_psql_trgm/init.php:287
Apr 22 14:31:52 Stack trace:
Apr 22 14:31:52 #0 /app/code/plugins/af_psql_trgm/init.php(287): PDO->query()
Apr 22 14:31:52 #1 /app/code/classes/PluginHost.php(348): Af_Psql_Trgm->hook_article_filter()
Apr 22 14:31:52 #2 /app/code/classes/RSSUtils.php(919): PluginHost->chain_hooks_callback()
Apr 22 14:31:52 #3 /app/code/update.php(231): RSSUtils::update_rss_feed()
Apr 22 14:31:52 #4 {main} in /app/code/classes/PluginHost.php on line 351
Apr 22 14:31:52 [14:31:52/164] Exception while updating feed 71: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block (/app/code/classes/RSSUtils.php:1061)
Apr 22 14:31:52 [14:31:52/8] <= 1.0067 (sec) exit code: 110
Apr 22 14:31:52 [14:31:52/8] !! Last error: Update process failed with exit code: 110 ()
Apr 22 14:31:52 PHP Notice: Update process for feed 71 (Roundcube Webmail Project News, owner UID: 2) failed with exit code: 110 (Update process failed with exit code: 110 ()). in /app/code/classes/Logger.php on line 50

[necrevistonnezr]

Sure enough, after disabling the plugin, the feeds are populated...
So, we do have PostgreSQL but some function seems to be missing to use the similarity check: https://gitlab.tt-rss.org/tt-rss/tt-rss/-/blob/master/plugins/af_psql_trgm/init.php

[nebulon]

Cloudron's postgres already supports pg_trgm extension, maybe tinytinyrss does not create it during the db migrations?

[nebulon]

Right so after running CREATE EXTENSION pg_trgm; manually, it starts to work. I've pushed a change which ensures the extension is created, waiting for the app tests to suceed.

[nebulon]

Package update is out now. Took a bit to get the tests sorted.