Skip to content

SQL: clean old auto-updates#5649

Merged
Alkarex merged 1 commit intoFreshRSS:edgefrom
Alkarex:clean-old-autoupdates-again
Sep 12, 2023
Merged

SQL: clean old auto-updates#5649
Alkarex merged 1 commit intoFreshRSS:edgefrom
Alkarex:clean-old-autoupdates-again

Conversation

@Alkarex
Copy link
Copy Markdown
Member

@Alkarex Alkarex commented Sep 10, 2023

Should help with some DB lock issues.

Complete #3558 after #5625 already cherry-picked from it.

Also removed the following non-problematic auto-updates, simply because they were older than the above ones (October 2018)

Should help with some DB lock issues.

Complete FreshRSS#3558 after FreshRSS#5625 already cherry-picked from it.

* Removed auto-update of MySQL GUID case sensitivity
FreshRSS#2078
  * Contributed to a DB lock in FreshRSS#5008

Also removed the following non-problematic auto-updates, simply because they were older than the above ones
* Auto-create custom labels (1.12.0) FreshRSS#2027
* Auto-add JSON column for feeds (1.11.0) FreshRSS#1838
* Auto-create temporary tables (1.7.0) FreshRSS#1470
@widowild1
Copy link
Copy Markdown

widowild1 commented Sep 10, 2023

Hello Alexandre,
I'm relaunching freshrss en edge which has been down for months, there are already 15000 articles, I'll get back to you in a few days, I also have about 2000 feeds (some of which are no longer working).

EDIT: après une optimisation de la base de données via freshrss, j’ai l’apparition de ces messages:
`

2023-09-10 18:17:39 cURL error 6: Could not resolve host: ayende.com [https://ayende.com/atom.xml]
  2023-09-10 18:17:29
  2023-09-10 18:16:44
  2023-09-10 18:16:43
  2023-09-10 18:16:29
  2023-09-10 18:16:19
  2023-09-10 18:15:19
  2023-09-10 18:15:09

`
https://privatebin.net/?7759ce01a6d8c138#3acJWxXu5zEfNWn6fzJ8Ku2q719CXgZpdxWtFXo5ARup

@Alkarex Alkarex merged commit f050a94 into FreshRSS:edge Sep 12, 2023
@Alkarex Alkarex deleted the clean-old-autoupdates-again branch September 12, 2023 08:43
@widowild1
Copy link
Copy Markdown

I'm giving you some feedback, I left freshrss running for several days, I did an optimization today as well as a purge, I have absolutely no more error messages like I had previously in my first post.

For me, the problem is solved.

@Alkarex
Copy link
Copy Markdown
Member Author

Alkarex commented Sep 15, 2023

Excellent, thanks for the feedback @widowild1 👍🏻

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

SQL error updateFeed: database is locked for feed

2 participants