• Options
• Login
• Register
• Desktop Style
• Accelerated Mobile Pages Theme

QAP freezing or takes seconds to respond occasionally

• Index

  • Jean Lalonde Support Forum
  • QUICK ACCESS POPUP FORUM
  • QAP SUPPORT
  • QAP freezing or takes seconds to respond occasionally
• QAP freezing or takes seconds to respond occasionally

• QAP freezing or takes seconds to respond occasionally

  LaurentG > 2020-06-03 01:25

  I have the same issue from time to time.
  In 100% of cases, problem is fixed by
  - exiting QAP
  - deleting the QAP_Frequent.DB database (in QAP data folder)
  - restarting QAP
  
  I'm convinced that for any (unknown...) reason this database is sometimes corrupted. As a result, QAP takes very very very long time accessing it, that explains the long time to respond.
  
  When I say I have the issue "from time to time", to be more specific (and honest...) I got it 3 times in one year.
  
  => @sinfulslave : I hope this may help you
  => @Jean : It could be interesting that you add some "detector" (I do not find the right word....) to understand in a first time when this corruption occurs, and then, in a second time, how and why.

• RE: recent folders, ....

  Jean Lalonde > 2020-06-03 08:00

  (2020-06-03 01:25)LaurentG Wrote: => @Jean : It could be interesting that you add some "detector" (I do not find the right word....) to understand in a first time when this corruption occurs, and then, in a second time, how and why.

  
  Hi Laurent,
  
  This bug won't be easy to catch because it seems to be very infrequent. I'll review the code to see if there is any situation where an infinite loop would occur. I can also add debugging code around this.
  
  When does this occur? First time you open the menu after you launched QAP or anytime after when you open the QAP menu?
  
  When QAP looks "frozen", is the mouse pointer icon gets stuck to the "wait" icon (blue circle)?
  
  And does it affect other Windows applications or the Windows Explorer?
  
  Thanks for your input,
  
  Jean
  
  PS: I'll move this to a new thread specific to this topic.

• RE: QAP freezing occasionally

  LaurentG > 2020-06-03 12:44

  > I'll review the code to see if there is any situation where an infinite loop would occur.
  
  I don't think the issue is in QAP, but in the sqlite database itself. Since deleting it solves (or better, removes) the issue.
  My asumption is that QAP tries to get something in database, but waits for the abnormally slow answer from sqlite DB. Maybe until a timeout ?
  
  > When does this occur? First time you open the menu after you launched QAP or anytime after when you open the QAP menu?
  
  When this occured, I really do NOT remember if it was the first menu opened or not since QAP start. But most of the time, when issue occured, I stopped QAP then re-launched it. 
  And I noticed that starting of QAP was generally quite long (icon remained brown a long time before becoming blue). Longer than usually, I don't know (usually, I do not look at the ico : QAP starts automatically with Windows)
  But it seems to me that opening first menu after this long restart was fast.
  If my remembering is OK, I would say that it is using QAP after a long time with QAP in the background but not really used, that the issue appeared.
  
  > When QAP looks "frozen", is the mouse pointer icon gets stuck to the "wait" icon (blue circle)?
  
  I do not remember exactly, but I would say yes.
  
  
  > And does it affect other Windows applications or the Windows Explorer?
  
  As far as I remember, the answer is no.
  
  You'll find I'm not vey precise.... but it's because
  - it didn't occur often (twice in several months)
  - the first time, we had some exchanges and I tried to investigate more in detail
  - but the second time, I didn't spend too much time in investigation, but prefered make the issue to disappear by removing the "guilty" database.
  
  Next time (if there is a next time !) if you are interested in, I'll send you a copy of the "guilty" database.

• RE: QAP freezing occasionally

  Jean Lalonde > 2020-06-04 07:59

  This are other issues reported to me by email related to the database crashing QAP. I'm thinking of disabling the QAP database in the next release. The QAP database is not essential to QAP and disabling it only removes features that should improve QAP performance (when it does not crash it...) and some non-critical features like usage statistics.
  
  Until this is done, you can disable the database without losing any essential QAP features. Go in "Options, Database" section. Please, let me know if this solve the issue.
  
  Jean

• RE: QAP freezing occasionally

  LaurentG > 2020-06-05 07:48

  Jean,
  
  I did it... but as a result, I've lost the Frequent Files and Frequent folders, if database is deactivated....
  While I use them (at least frequent folders).
  
  Since the issue is very unfrequent, I prefer then to reactivate the database....

• RE: QAP freezing occasionally

  Jean Lalonde > 2020-06-05 07:52

  This is true. I forgot to mention this, of course.
  
  I'll follow-up with you by email for more info on your config.

• RE: QAP freezing occasionally

  dr Winchell > 2020-06-05 08:01

  I have a similar problem occasionally. The program doesn't respond to a middle mouse wheel click or Win+W .
  
  My computer is works normally other than this. After about 10 seconds or so, QAP resumes responding.
  
  I realize this type of problem is extra hard to troubleshoot since it happens randomly.
  
  Cheers, Dale

• RE: QAP freezing occasionally

  Jean Lalonde > 2020-06-05 20:09

  Dale:
  > I realize this type of problem is extra hard to troubleshoot since it happens randomly.
  
  Yes, it is...
  
  Laurent:
  > Next time (if there is a next time !) if you are interested in, I'll send you a copy of the "guilty" database.
  
  Yes, please.

• RE: QAP freezing occasionally

  dr Winchell > 2020-06-06 06:03

  I can get it to respond again by clicking the icon in the system tray, selecting Customize, and then Close and I'm good to go.

• RE: QAP freezing occasionally

  LaurentG > 2020-06-06 08:09

  Dale : My personal experience is that each time I got this issue, I've been able to make it completely disappear by
  - stopping QAP
  - deleting the QAP_Frequent.DB  database (and its backup) in QAP parameters folder
  - restart QAP
  
  Result : QAP rebuilds partially the database (from recent files of Windows, AFAIK) that makes the 1st start a little bit longer than usual.
  Due to database deletion, we lose the "Frequent Files" and Folders (but we still have the "Recent" ones), but progressively, the "Frequent" ones are regenerated.
  
  My asumption (still to be proven.....) is that problem was due to a corruption of the database.
  
  And I think it could help Jean to investigate if you send him a copy of your database. There is very little "private" informations in it (the list of files and folders you have accessed in the past), so I do not ask you to upload it here on the forum to everybody, but I guess you could send it "privately" to Jean.

• RE: QAP freezing or takes seconds to respond occasionally

  Jean Lalonde > 2020-06-07 18:27

  Thanks for your input, Laurent and Dale.
  
  Reading your posts, I'm not 100% sure you are facing exactly the same issue. Especially because you have pretty different solutions (deleting the database vs just waiting or opening/closing the "Customize" window). But it is so infrequent that we know very little about this(these) issue(s) for now.
  
  If/When this occurs again, it would help if you could describe with a little more details what happened, what you were doing with QAP just before the QAP freeze.
  
  > And I noticed that starting of QAP was generally quite long (icon remained brown a long time before becoming blue). Longer than usually, I don't know (usually, I do not look at the ico : QAP starts automatically with Windows)
  
  Since v10.x, at launch time, QAP is now loading from the database (if it is enabled) the usage stats associated to each favorite. This can take some time if you have many favorites. But this is usually happening as part of your PC boot process so you do not realy see it. You would only notice this delay if you need to restart QAP.
  
  Jean
• Next Oldest Next Newest