Timing out
Posted: 09 Nov 2018, 23:10
I'm experiencing difficulty with the opencats database I am using. It is hosted on the same machine I am using to access it yet it keeps timing out, if I refresh then it will load properly MOST of the time, BUT if I enter notes or have it up more than a few seconds when I hit enter it times out and I lose what I just wrote.
I have developed a work around - copying everything I write before I post it so that when it times out, I can paste it in instead of rewriting it and risking losing content. Sometimes it takes 2 or 3 times to put the note in before it STAYS in. Chronic Timing out.
This makes it VERY difficult/frustrating to get a good call rhythm going.
This is the error message
----------------------------------------------------------------------------------------
Error Connecting to Database
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
===============================
I had this problem prior and was told to do the following:
********************************************************************
mysqlcheck --check --auto-repair --all-databases
mysqlcheck --optimize --all-databases
..then restart mysql
********************************************************************
I have tried THIS - SEVERAL times and the issue persists. To be transparent I did back up the old database, create a NEW instance on a NEW computer and then migrate the data over. the issue was FIXED prior to backup but started misbehaving a few days after install (when I started using it).
I have over 700 records. . . I am getting ready to do important 1,000 more . . . I'd like to have the issues solved before I do the import.
Please let me know if you need anything to help diagnose the issue. THANK YOU!
I have developed a work around - copying everything I write before I post it so that when it times out, I can paste it in instead of rewriting it and risking losing content. Sometimes it takes 2 or 3 times to put the note in before it STAYS in. Chronic Timing out.
This makes it VERY difficult/frustrating to get a good call rhythm going.
This is the error message
----------------------------------------------------------------------------------------
Error Connecting to Database
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
===============================
I had this problem prior and was told to do the following:
********************************************************************
mysqlcheck --check --auto-repair --all-databases
mysqlcheck --optimize --all-databases
..then restart mysql
********************************************************************
I have tried THIS - SEVERAL times and the issue persists. To be transparent I did back up the old database, create a NEW instance on a NEW computer and then migrate the data over. the issue was FIXED prior to backup but started misbehaving a few days after install (when I started using it).
I have over 700 records. . . I am getting ready to do important 1,000 more . . . I'd like to have the issues solved before I do the import.
Please let me know if you need anything to help diagnose the issue. THANK YOU!