Datafeedr Support Forums  

Go Back   Datafeedr Support Forums > Current Version (V3) Forum > Problems
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Important - The support forums are now in "read-only" mode as we transition to an alternative help desk solution. Feel free to contact us here with any of your questions or search the forums for an existing solution.
 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 9th, 2011, 10:26 AM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default Datafeedr Plugin - Site Suspended...

Hostgator suspended one of my websites last night due to datafeedr plugin affecting the server.

Here is the snippet that I got from them showing the offending code:



The following query is the issue and you may need to present this information in order for the plugin creator/maintainer to resolve this issue.

mysql> explain SELECT DISTINCT wp_dfr_shop_products.* FROM wp_dfr_shop_products INNER JOIN wp_dfr_shop_p2c ON wp_dfr_shop_products.id=wp_dfr_shop_p2c.id WHERE wp_dfr_shop_p2c.cat_id IN(663390) AND (wp_dfr_shop_products.state=1) ORDER BY wp_dfr_shop_products.name ASC LIMIT 0, 3;
+----+-------------+----------------------+--------+---------------+---------+---------+----------------------------------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------+--------+---------------+---------+---------+----------------------------------------------+------+----------------------------------------------+
| 1 | SIMPLE | wp_dfr_shop_products | ALL | PRIMARY | NULL | NULL | NULL | 6554 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | wp_dfr_shop_p2c | eq_ref | PRIMARY | PRIMARY | 12 | hallowee_wrdp1.wp_dfr_shop_products.id,const | 1 | Using index; Distinct |
+----+-------------+----------------------+--------+---------------+---------+---------+----------------------------------------------+------+----------------------------------------------+
2 rows in set (0.00 sec)




Plugin Version is:3.3.3583

Approximately 5700 products in the store.

Last edited by LimitlessMktg : October 9th, 2011 at 10:29 AM.
  #2  
Old October 9th, 2011, 10:36 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

The query does not tell us what the issue is. What about the query caused Hostgator to suspend your account?

Eric
  #3  
Old October 9th, 2011, 10:47 AM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default

Quote:
Originally Posted by Eric View Post
Hi

The query does not tell us what the issue is. What about the query caused Hostgator to suspend your account?

Eric
They are saying it was that one.

Looks like it was doing a product update?



Running Processes:
hallowee 28092 6.3 0.8 57464 33128 ? SN 02:42 0:00 /usr/bin/php /home/hallowee/public_html/index.php

Running Queries:
*************************** 1. row ***************************
USER: hallowee_wrdp1
DB: hallowee_wrdp1
STATE:
TIME: 1
COMMAND: Sleep
INFO: NULL
*************************** 2. row ***************************
USER: hallowee_wrdp1
DB: hallowee_wrdp1
STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT wp_dfr_shop_products.* FROM wp_dfr_shop_products
INNER JOIN wp_dfr_shop_p2c ON wp_dfr_shop_products.id=wp_dfr_shop_p2c.id WHERE wp_dfr_shop_p2c.cat_id IN(663390) AND (wp_dfr_shop_products.state=1) ORDER BY wp_dfr_shop_products.name ASC LIMIT 0, 3

Current Site Requests:
173.245.50.223 dirtysexyhothalloweencostumes.c /wp-content/uploads/store/products/thumbnails/5680117428280
173.245.50.223 dirtysexyhothalloweencostumes.c /wp-content/uploads/store/products/thumbnails/5680133057149
173.245.50.225 dirtysexyhothalloweencostumes.c /wp-content/uploads/store/products/thumbnails/5680023498348
173.245.50.225 dirtysexyhothalloweencostumes.c /wp-content/uploads/store/products/thumbnails/5680118616408
173.245.50.239 dirtysexyhothalloweencostumes.c /wp-admin/load-scripts.php?c=1&load=hoverIntent,common,jque
173.245.50.239 dirtysexyhothalloweencostumes.c /wp-admin/load-scripts.php?c=1&load=hoverIntent,common,jque
173.245.50.239 dirtysexyhothalloweencostumes.c /wp-admin/load-scripts.php?c=1&load=jquery,utils&ver=fb5c27
173.245.50.239 dirtysexyhothalloweencostumes.c /wp-admin/load-scripts.php?c=1&load=jquery,utils&ver=fb5c27
173.245.50.239 dirtysexyhothalloweencostumes.c /wp-admin/load-styles.php?c=1&dir=ltr&load=global,wp-admin&
173.245.50.239 dirtysexyhothalloweencostumes.c /wp-admin/load-styles.php?c=1&dir=ltr&load=global,wp-admin&
173.245.50.239 dirtysexyhothalloweencostumes.c /wp-admin/plugins.php?plugin_status=all
173.245.50.239 dirtysexyhothalloweencostumes.c /wp-admin/plugins.php?plugin_status=dropins
173.245.50.29 dirtysexyhothalloweencostumes.c /thumbnail/56800234983513/super-deluxe-peacock-princess-cos
173.245.50.29 dirtysexyhothalloweencostumes.c /wp-content/uploads/store/products/thumbnails/5680136044161
66.249.67.199 dirtysexyhothalloweencostumes.c /costumes/red-knee-length-petticoat-crinolines-and-slips-56
66.249.67.199 dirtysexyhothalloweencostumes.c /costumes/wicked-witch-wizard-of-oz-costume-plus-size-wizar
66.249.67.199 dirtysexyhothalloweencostumes.c /costumes/womens-sexy-go-go-boots-in-black-halloween-costum
66.249.67.200 dirtysexyhothalloweencostumes.c /costumes/red-nylon-fishnet-pantyhose-stockings-and-tights-
66.249.67.200 dirtysexyhothalloweencostumes.c /costumes/womens-gypsy-costume-crystal-ball-gypsi-936200924
66.249.67.200 dirtysexyhothalloweencostumes.c /costumes/womens-sexy-deck-hand-costume-936201632944105/
66.249.67.246 dirtysexyhothalloweencostumes.c /costumes/sexy-goddess-of-twilight-plus-size-adult-vampire-
66.249.67.246 dirtysexyhothalloweencostumes.c /costumes/womens-sexy-goddess-costume-venus-936200480963134
66.249.67.247 dirtysexyhothalloweencostumes.c /costumes/red-mini-saloon-girl-hat-sexy-costume-accessories
66.249.67.247 dirtysexyhothalloweencostumes.c /costumes/sexy-dirty-cop-womens-costume-61902042309368/

[Sun Oct 9 02:42:21 CDT 2011] Server Load Before Suspension: 9.06, 8.36, 6.97

[Sun Oct 9 02:42:21 CDT 2011] Suspending /home/hallowee/public_html!

Waiting 60 Seconds for Server Load.

[Sun Oct 9 02:43:25 CDT 2011] Server Load After Suspension: 4.56, 7.22, 6.67

Waiting 60 Seconds for Server Load.

[Sun Oct 9 02:44:25 CDT 2011] Server Load After Suspension: 2.60, 6.20, 6.36
  #4  
Old October 9th, 2011, 11:19 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

Seems strange that a small store would cause load problems.

Product updates do create a lot of queries on your database and if your CPU or RAM allowances are low, then it could increase the load too much.

I would do this:

1. Install a good WP caching plugin. Try this: http://wordpress.org/extend/plugins/w3-total-cache/

2. Then, increase the interval at which your store is updated. Maybe just once a week. You can do so here: The Factory > Your Store > Store menu > Basic Store Settings. Also, clicking the [Update Settings Only] button is a very "lightweight" process that doesn't create that many queries. On the other hand, clicking the [Update Products and Settings] button can be server intensive.

Eric
  #5  
Old October 9th, 2011, 11:28 AM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default

W3 Total Cache was installed by them.

I've also enabled cloudflare and its configured within the cache plugin.


I had increased the update interval to daily, due to the products/time of year, prices are changing daily, but will set it back to the default.

They are going to take a look at it now and see if they will enable the site for public visitors again.

Thanks.


Quote:
Originally Posted by Eric View Post
Hi

Seems strange that a small store would cause load problems.

Product updates do create a lot of queries on your database and if your CPU or RAM allowances are low, then it could increase the load too much.

I would do this:

1. Install a good WP caching plugin. Try this: http://wordpress.org/extend/plugins/w3-total-cache/

2. Then, increase the interval at which your store is updated. Maybe just once a week. You can do so here: The Factory > Your Store > Store menu > Basic Store Settings. Also, clicking the [Update Settings Only] button is a very "lightweight" process that doesn't create that many queries. On the other hand, clicking the [Update Products and Settings] button can be server intensive.

Eric
  #6  
Old October 9th, 2011, 01:26 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

The posts related to updating problems have been moved to a new thread as per the forum posting rules: http://www.datafeedr.com/forums/show...6527#post16527
  #7  
Old October 9th, 2011, 06:04 PM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default

Finally got word back from Hostgator.

They reenabled my site, noticed CPU ramping up again, so disabled once again and have completely locked me out of the site.


I have asked for additional information on CPU usage ie MySQL, apache, etc. but they are very slow to respond today...

Datafeedr was definitely caught in a loop trying to update with cloudflare enabled, but now that cloudflare is removed, they still have all inbound traffic blocked, so it can't update. Not sure what is causing the CPU utilization. I would assume that if it were an SEO plugin, the CPU would be used, regardless. Its not like this site has ton of traffic, but the second they enable network connectivity, CPU usage climbs.
  #8  
Old October 9th, 2011, 06:05 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

What happens when Datafeedr is turned off?
  #9  
Old October 9th, 2011, 06:06 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Also, we made a change to the plugin which might help. A plugin upgrade and full store update will be necessary to take advantage of the changes.
  #10  
Old October 9th, 2011, 06:10 PM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default

Quote:
Originally Posted by Eric View Post
What happens when Datafeedr is turned off?
When I was able to get in there to disable it, the store was blank with datafeedr deactivated.

I updated the plugin, did a full update, then they disabled me again.

When I can get back in there, I will deactivate again and see what they say.
  #11  
Old October 9th, 2011, 07:16 PM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default

Quote:
Originally Posted by Eric View Post
Also, we made a change to the plugin which might help. A plugin upgrade and full store update will be necessary to take advantage of the changes.

Able to get back into the site.

I am not seeing a newer plugin than 3.3.3596


Going to disable the datafeedr plugin and see what they say.
  #12  
Old October 9th, 2011, 08:23 PM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default

So now they are trying to blame a bad setting in W3 Total Cache (disk enhanced caching) for the problem. A problem that they installed W3 Total Cache to resolve?!

They installed W3 Total Cache.
Enhanced disk caching is recommended for shared hosting.
Says pages were NOT being cached with that setting?


Now DNS is jacked up. I'm seeing it resolve BACK to cloudflare. Registrar has the correct NS settings. I think they just reenabled cloudflare...

Frustrated and losing faith in HostGator.
  #13  
Old October 9th, 2011, 09:26 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Ugh... sounds rough!

Try disabling the Datafeedr plugin and leaving it disabled. Then let HG try to figure out where the problem is. If the problem is not with Datafeedr, then the problem should exist again even with Datafeedr deactivated.


Eric
  #14  
Old October 9th, 2011, 09:40 PM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default

They have determined that the guy that installed the Total Cache followed an old document for preferred settings. They will be updating the doc with their new recommendations.



Putting this here to maybe help someone else out.

Hostgator and W3 Total Cache Settings

We do have a guide which is currently outdated, I have escalated this issue and we will update the tutorial as soon as possible, if you like to view it you can find it on the following page, please note the Page Cache Method: Disk (Enhanced) part is incorrect due to recent changes made to the plugin by its developers:
http://support.hostgator.com/article...zing-wordpress


I was able to connect from my mobile and kick off an update. It hung up for a while trying to update (I believe due to DNS issues) but now has apparently updated and products are back in the store front.

My ISP apparently still has cloudflare records for this site.

Thank you again for your persistence when the issue wasn't even yours...
  #15  
Old October 10th, 2011, 08:27 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

I'm glad you got it sorted out and thanks for posting that information from HostGator!

Eric
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Webhost Suspended our domain name. tkh378 Problems 1 May 31st, 2011 03:26 PM
Datafeedr Plugin 0.9.95 Released Eric News & Announcements 0 April 18th, 2008 09:07 PM


All times are GMT -5. The time now is 12:51 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.