stop working when access messages while updating feeds about rssguard HOT 22 CLOSED

Is this 100% reproducible every time you try?

from rssguard.

It's not but it happens most of time.

from rssguard.

OK, it seems that there is clearly problem with mainly MySQL, I will have to use producer-consumer pattern and send all SQL queries to one single class to consume it all in one single thread to avoid these SQL transaction horrors.

from rssguard.

I try to reproduce, but cannot. So you update a lot of feeds and madly clicking on messages and it crashes?

from rssguard.

Okay, I managed it to reproduce once, will try to fix and find bug.

from rssguard.

Does this bug happen with SQLite storage?

from rssguard.

So far, it's not reproducible with SQLite. Anyway, with MySQL, it seems can be easily make it crash by mark selected items as read/unread while updating feeds.

from rssguard.

Yes yes, I managed to make it crash too. I know where the core of the problem might be. I will try to think about fix. The goal is to allow multi-thread access to DB so that user can view messages when updating feeds.

from rssguard.

I will fix this this way:

1. All SQL operations when downloading new messages will be done in one single batch transaction. This will have two impacts:
   • When you update for example 10 feeds, all new messages from those feeds will get downloaded first and then all of them will be inserted into SQL at once. So if you update 10 feeds, you will see new messages after all feeds are updated.
   • This approach might bring another noticeable speed improvement, particularly when number of new messages will be high.
   • This approach will also lower SQL/HDD throttling.
2. All SQL operations in separate thread (feed updating) will have unique separated database connections.

from rssguard.

This should be fixed, please test it. Use latest code from [dev] branch.

from rssguard.

could you upload please? resumable link if possible. thanks.

from rssguard.

Will upload test release for you tomorrow maybe.

from rssguard.

just updated to v3.3.4, but I can test for this because RSS Guard is not responsive when updating feeds, but feeds successfully updated. I wonder it is because DB size

here is the log file (no feeds updated in this log because they were updated on previous run)
log.txt

from rssguard.

Yea, problem is that I moved some DB updating code to main UI thread, which results in app UI thread freezing. I will move the code to feed downloader thread in 3.3.5.

from rssguard.

I made some tweak to make sure that RSS Guard main windows is more responsive during updates. You can get latest automatically compiled development release here (It will compile for 15 minutes, so wait 15 minutes from time I post this.).

Let me know if it is better.

from rssguard.

https://transfer.sh/HB4gh/rssguard-win32.7z

from rssguard.

Hi, thanks for kindly fix the issue. I'm sorry can't test and give feedback, my network connection doesn't look good so got three times timeout already, will try again later.

from rssguard.

could you upload with resumable link? I have problems when donwloading from these link. It always stop in the middle of process and I need to start again from beginning which is waste lot of my data. Sorry for asking much.

from rssguard.

Don't you have working internet connection? No, I can't I already setup this automatic build machinery, partly for you brother, since you always ask for installers.

from rssguard.

Yes, I do but not good enough stability for download. Okay, fine. Thank you. :)

from rssguard.

I can tell that this problem is fixed with newer version. Thanks.

from rssguard.

Okay, perfectos

from rssguard.