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 January 10th, 2012, 05:22 AM
ayorofrance ayorofrance is offline
 
Join Date: Sep 2010
Posts: 430
Default Update Failed

Hi Eric,

I am getting Datafeedr Notification - Store Update Failed emails more frequently now...

I have mostly ignored them but given that they keep appearing I've decided to figure out what is going on.

So I got this email on shop 31858 this morning:
Code:
This is to inform you that the automatic update on your website (www.xxxxxxx.xxx) has failed. Please see the error message(s) below:

ERROR: 
-Update cannot complete, please try again, 
Technical details:
plugin/plugin:139 view=category
app/tracker:61 track: no referrer
app/update:90 BEGIN: status=read
app/update:139 UPDATE FAILED
app/update:139 UPDATE FAILED
ERROR: err_update_error hung at read (lock=16279)(122)
After which I went online to do a manual Product and Settings update.

This reported Success, however I received this email shortly afterwards:
Code:
This is to inform you that the automatic update on your website (www.xxxxxxx.xxx) has failed. Please see the error message(s) below:

ERROR: 
-Error (mysql: (0) [INSERT INTO sr_dfr_xopt(skey,sval) VALUES('update_lock', 6237)]), 
Technical details:
plugin/plugin:139 view=category
app/tracker:61 track: no referrer
app/update:90 BEGIN: status=download
app/update:139 UPDATE FAILED
ERROR: mysql: (0) [INSERT INTO sr_dfr_xopt(skey,sval) VALUES('update_lock', 6237)] (663)
Does this mean the manual update did not succeed?

And what could be the reason I get these emails frequently?

I believe I mainly (only?) get these emails on my larger stores (10,000 - 25.000 products).

It's mostly the err_update_error hung message but these are some of the other messages I have seen:

Code:
ERROR: 
-Error (mysql: (0) [INSERT IGNORE INTO sg_dfr_shop_products_tmp(id,net_id,net_code,network,merchant_id,merchant,name,slu]), 
Technical details:
plugin/plugin:139 view=category
app/tracker:61 track: no referrer
app/update:90 BEGIN: status=read
app/update:139 UPDATE FAILED
ERROR: mysql: (0) [INSERT IGNORE INTO sg_dfr_shop_products_tmp(id,net_id,net_code,network,merchant_id,merchant,name,slu] (663)
Code:
ERROR: 
-Error (mysql: (0) [INSERT INTO sg_dfr_xopt(skey,sval) VALUES('update_lock', 12192)]), 
Technical details:
plugin/plugin:139 view=category
app/tracker:61 track: no referrer
app/update:90 BEGIN: status=read
app/update:139 UPDATE FAILED
ERROR: mysql: (0) [INSERT INTO sg_dfr_xopt(skey,sval) VALUES('update_lock', 12192)] (663)
Code:
ERROR: 
-Store data cannot be read, 
Technical details:
plugin/plugin:139 view=category
app/tracker:68 track: internal referrer=(http://xxxxxx.xxx/s/c/xxxxxxxxxxxxxxx)
app/update:90 BEGIN: status=read
unlink /xxxx/xxxx/wordpress/xxxx/tmp/xxxx/_dfrtmp_6f9e234d4ceb2f9bcd92826709a89080
app/reader:68 header: expect: 3.4 found: %2F%2ADATAFEEDR%3A3.3%2A%2F%0A
app/update:139 UPDATE FAILED
ERROR: err_read bad_header_version(122)
__________________
WordPress Security - Is your WordPress secure? Get our FREE checklist and find out.

Easy-Email - Access ALL your email accounts with one login & synchronize automatically on all your computers.
  #2  
Old January 10th, 2012, 11:15 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

We had some issues with the Factory yesterday. If you are still getting these error messages, can you PM me the following information:

BLOG LOGIN INFO with ADMINISTRATOR PERMISSIONS (Temporary login information preferred)
Admin URL:
Username:
Password:

FTP LOGIN INFORMATION (Temporary login information preferred)
Host:
Login:
Password:

Thanks,
Eric
  #3  
Old January 11th, 2012, 11:44 AM
ayorofrance ayorofrance is offline
 
Join Date: Sep 2010
Posts: 430
Default

Hi Eric,

Unfortunately these errors have been happening sporadically over some time now.

I did another update of this shop this morning, which returned an 'Update Successful' message in the UI and shortly thereafter I got this email:

Code:
ERROR: 
-Error (mysql: (0) [INSERT IGNORE INTO sr_dfr_shop_p2c_tmp(id,cat_id) VALUES (1690900574017303,597427), (169090057491487]), 
Technical details:
plugin/plugin:139 view=category
app/tracker:61 track: no referrer
app/update:90 BEGIN: status=read
app/update:139 UPDATE FAILED
ERROR: mysql: (0) [INSERT IGNORE INTO sr_dfr_shop_p2c_tmp(id,cat_id) VALUES (1690900574017303,597427), (169090057491487] (663)
This afternoon I redid the shop update, and so far no email...

Does the email mean that the shop update was not successful after all?

Do you still need the login info?

Sorry I can't be more specific :-(

Cheers,

Anders
__________________
WordPress Security - Is your WordPress secure? Get our FREE checklist and find out.

Easy-Email - Access ALL your email accounts with one login & synchronize automatically on all your computers.
  #4  
Old January 11th, 2012, 12:05 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

Yes, please send us information so that we can try to troubleshoot this.

Thanks,
Eric
  #5  
Old January 11th, 2012, 05:31 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

"not_readable" is thrown when the downloaded feed becomes unreadable for some reason. The most probable reason is when the script that cleans up the shared /tmp directory at regular intervals cannot run. We had the issue in the past and the remedy was to use a private directory inside yours webspace for temporary files.

Here's how to add a tmp directory inside your webspace:
http://www.datafeedr.com/forums/show...4437#post24437

Eric
  #6  
Old January 11th, 2012, 05:48 PM
ayorofrance ayorofrance is offline
 
Join Date: Sep 2010
Posts: 430
Default

Hi Eric,

Thanks for looking into this... I'll setup private dirs and take it from there...

Cheers,

Anders
__________________
WordPress Security - Is your WordPress secure? Get our FREE checklist and find out.

Easy-Email - Access ALL your email accounts with one login & synchronize automatically on all your computers.
 


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
Update failed TheFerryman Problems 14 January 4th, 2012 12:22 PM
UPDATE FAILED Papada Problems 1 December 30th, 2011 12:35 PM
Update failed TheFerryman Problems 4 October 25th, 2011 03:43 PM
UPDATE FAILED macfink Problems 6 October 5th, 2011 10:12 AM
Shop update: Failed Kaetemar Problems 4 February 8th, 2011 02:20 PM


All times are GMT -5. The time now is 03:40 AM.


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