Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Upgrading from 1.4.2.0 to 1.7.0.2 - mysql infinity loop after upgrade
 
dIGIMURDER
Jr. Member
 
Total Posts:  19
Joined:  2008-08-07
 

Hi,
i have trouble with magento upgrade from 1.4.2.0 to 1.7.0.2

With these steps :

1. backup old db to db1
2. download and unpack magento 1.7.0.2 to ~/www/magento-1.7.0.2/
3. install magento 1.7.0.2 to fresh db2
4. detect conflicts with magento-db-repair-tool-1.1.php
-corupped db : db1 (original 1.4.2.0)
-reference db : db2 (fresh 1.7.0.2)

5. repair all conflicts (duplicates, foreigen keys, etc...) until wagento-db-repair tool don’t detect errors;

6. in ~/www/magento-1.7.0.2/app/etc/local.xml replace db1 with db2
7. go to http://magento-1.7.0.2.mydomain.com/

8. waiting more than 4 hours and db is still working.
9. after db stop working, repeat step 7.
10. db still working.... nothing change. I think sql is in infinity loop

I have written small bash commant to monitor sql requests :

while true; do mysql -e “show processlist” | tee -a ~/logs/SQLPREKLAPANIE.log; sleep 0.5; clear; done;

I think queries is repeating in infinity loop.

here is first 10% from my log :
http://pastebin.com/YWMguyAR

Full log :
http://www.digi-m.sk/sqllog.log.bz2

Thank you for any suggestions.

-dM-

 
Magento Community Magento Community
Magento Community
Magento Community
 
freemanjacob
Jr. Member
 
Total Posts:  6
Joined:  2012-01-24
 

Hi, I know this method, but this way is really too difficult and complex. So you’d better, try some alternatives to upgrade your Magento.
I was able to successfully upgrade Magento to 1.7.using Connect Manager. Or if you are looking for something to avoid time losse, errors (missing data, duplicates, as they are inevitable while upgrading manually) You can use Cart2Cart ( http://www.shopping-cart-migration.com/shopping-cart-migration-options/223-magento-to-magento-migration ) service. But, it is not free. Nevertheless, check both ways

 
Magento Community Magento Community
Magento Community
Magento Community
 
kalenjordan
Sr. Member
 
Avatar
Total Posts:  218
Joined:  2011-10-31
Pasadena, CA
 

Hi @dM, so I’m not totally sure that I’m following the steps that you took, but it sounds like basically you:
1. Upgraded your 1.4.2.0 to 1.7.0.2 at db1
2. Installed 1.7.0.2 fresh at db2
3. Repaired db1 against db2 using the repair tool
4. Then your upgraded db1 worked for a little while
5. Then it stopped working

Let me know if I got that right.  Anyways, one thing that would be good to figure out is where this query is originating that you’re seeing show up in your logs.  I actually searched the core and didn’t see that foreign key anywhere.  Search your code base and see where it’s coming from.

I think the closest you’ll find is
FK_CORE_URL_REWRITE_CATEGORY
in Mage/Catalog/sql/catalog_setup/mysql4-install-1.4.0.0.0.php

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top