AbleCommerce Forums
»
AbleCommerce
»
General Questions
»
Maintenance routine ExecuteReader requires an open and available Connection. The connection's curr
Rank: Advanced Member
Groups: Developers
Joined: 11/7/2018(UTC) Posts: 301
Thanks: 21 times Was thanked: 5 time(s) in 5 post(s)
|
We have a site that shows this error any time anything in the maintenance routine runs, for each step in the routine. ExecuteReader requires an open and available Connection. The connection's current state is closed
I put in code to log the open connections before it runs and it displays one open connection, as it always does in admin system reports. I have looked through the code for ExecuteReader in custom code and all custom code uses NHibernate. I looked in Sql Server settings, comparing all the properties with another database and they were the same. Have you seen this before? Can you give any help? All the Google results I find refer to custom sql using sql data commands, etc, not nHibernate. Thanks
|
|
|
|
Rank: Advanced Member
Groups: System, Administrators, Developers, Registered, HelpDesk Joined: 10/29/2018(UTC) Posts: 465
Thanks: 4 times Was thanked: 34 time(s) in 33 post(s)
|
Hi Judy,
This will need to be answered by a developer. Our lead dev is out of the office until next week. I will ask him to update then. |
Thanks for your support!
Katie Secure eCommerce Software and Hosting |
|
|
|
Rank: Advanced Member
Groups: Developers
Joined: 11/7/2018(UTC) Posts: 301
Thanks: 21 times Was thanked: 5 time(s) in 5 post(s)
|
I think the issue is in deleting the page views. I constructed sql scripts to run the MaintainUsers routine on these two sites. On the first one, they had > 1,000,000 anonymous users going back to 2001. The sql script to delete pageviews ran around 20 minutes then stopped because transaction log was full. Then after 15 minutes it stopped again. The second site had 223,000 anonymous users and the script to delete page views stopped twice because transaction log was full. After the second time, I checked and there were still 18,000,000 entries in the page views table. I finally just had to truncate the table to get things to finish up. I think this is probably because of bots. They are more and more affecting our sites- enough that we have had to start using under attack mode on ClouldFlare at times. Have you had issues on the sites you host?
|
|
|
|
Rank: Advanced Member
Groups: System, Administrators, Developers, Registered, HelpDesk Joined: 10/29/2018(UTC) Posts: 465
Thanks: 4 times Was thanked: 34 time(s) in 33 post(s)
|
Hi Judy,
No, we haven't had anything near these numbers. Any past maintenance issues were resolved in Gold, as far as I remember. These seem like extreme cases, and I have had a number of issues with bots these days. Everything from contact form spamming to payment card attacks. So frustrating.
Using manual SQL scripts is, unfortunately, the best way to deal with the excessive records - especially since the transaction logging is impacted and causing additional problems.
We have been thinking about implementing Cloudflare, but I was worried about costs. |
Thanks for your support!
Katie Secure eCommerce Software and Hosting |
|
|
|
Rank: Advanced Member
Groups: Developers
Joined: 11/7/2018(UTC) Posts: 301
Thanks: 21 times Was thanked: 5 time(s) in 5 post(s)
|
There is a free CloudFlare account that has the basics and I believe it has the under attack option with it. Sucuri also has bot protection features and it starts at 9.99 a month.
|
|
|
|
Rank: Advanced Member
Groups: System, Administrators, Developers, Registered, HelpDesk Joined: 10/29/2018(UTC) Posts: 465
Thanks: 4 times Was thanked: 34 time(s) in 33 post(s)
|
Thanks Judy. Appreciate the info. I've been recommending CloudFlare to several people now, and I didn't know they had a free version. I will be looking into this for sure. |
Thanks for your support!
Katie Secure eCommerce Software and Hosting |
|
|
|
AbleCommerce Forums
»
AbleCommerce
»
General Questions
»
Maintenance routine ExecuteReader requires an open and available Connection. The connection's curr
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The AbleCommerce Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close