Magento/MySQL/Server Issue -

We are currently experiencing an issue with our Magento website.

The indexing is not working on our site for the 'Catalog URL Rewrites' index.

The error that is shown when indexing the 'Catalog URL Rewrites' index is:

"Catalog URL Rewrites index process unknown error:

exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /var/www/vhosts/[url removed, login to view]:252"

We have tried the following fixes / configuration examples (which have not worked):

1. [url removed, login to view]

2. [url removed, login to view]

3. [url removed, login to view]


1. We also tried restarting our VPS each time we made a change.

2. We deleted the locks found in 'var/locks/' before reindexing.

3. We ran the following command to reindex "php -d max_execution_time=0 [url removed, login to view] --reindex catalog_url" to ensure no timeouts.


Please quote total price for the job to fix this issue.

Full info will be provided to succesful candidate, including access info.

This is a production environment, only quote if you know this issue and can resolve it!

We are using:
- Magento - v1.9
- Plesk - 12.0.18 Update #15
- OS - CentOS 6.4 (Final)
- PHP Panda! Multi-PHP installer - This is installed for managing multiple php versions on our VPS.

Beceriler: Magento, MySQL, PHP, Plesk, UNIX

Daha fazlasını gör: vps price, pdo website, db transaction, magento, debugging, vps error, php pdo, pdo, magento server configuration, exceeded mysql, reindexing, mysql general error, resolve server, found server, server issue, catalog url rewrites, magento url fix, mysql lock, magento rewrites, magento sqlstate hy000

İşveren Hakkında:
( 0 değerlendirme ) Melbourne, Australia

Proje NO: #7320365

Bu iş için 24 freelancer ortalamada $165 teklif veriyor


Hello, Here are Magento Experts , 1. Easy access on IMs like Gtalk, Skype, Yahoo and MSN 2. Excellent Communication Skills 3. Immediate response to concerns and queries 4. Payments linked to delivery miles Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(147 Değerlendirme)

We are highly interested to work with you on this project and can assure you quality results ready to start immediately some of our developed websites are listed below E-commerce [login to view URL] http://w Daha Fazla

$421 AUD in 10 gün içinde
(229 Değerlendirme)

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. We insist to follow these steps before you award the project to us: - We (technical team) will review the job and Daha Fazla

$824 AUD in 10 gün içinde
(79 Değerlendirme)

I have read your job posting and I am sure that can do the job. I have more than 4 years experience in magento. It would be great if I have a chance to discuss with you more. I also have Magento certificate. You Daha Fazla

$150 AUD in 3 gün içinde
(208 Değerlendirme)

Hello, Is it possible to check the issue on dev server or admin ? I can help you in this regard. Thanks

$80 AUD in 2 gün içinde
(94 Değerlendirme)

Hello ! It would be really useful for me to know the following things: 1. what's your VPS configuration? 2. how many products do you have in your magento store ? 3. the output of the sql line: "show engine innodb Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(216 Değerlendirme)

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Daha Fazla

$210 AUD in 5 gün içinde
(112 Değerlendirme)

Hello Let's explore the requirement and kindly let us know if you would like us to share our skills & experiences with previous development.

$238 AUD in 16 gün içinde
(86 Değerlendirme)

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can fix your Magento/MySQL/Server Issue according to your exact requirements. Please Before Awarding this proj Daha Fazla

$368 AUD in 10 gün içinde
(105 Değerlendirme)

I have 6+ years experience in web development and 4+ years on Magento. I am also a Magento Certified developer. Please have a look on below url:- [login to view URL] I Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(102 Değerlendirme)

Hi, i am a magento expert. I have carefully read this project .I can do it for you. Let me do it. Thanks.

$111 AUD in 2 gün içinde
(51 Değerlendirme)

Hi, i fixed the same issue yesterday. i will fix it easily. I am PHP, Magento expert having 5 years of experience... recently i completed these projects [login to view URL] [login to view URL] Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(168 Değerlendirme)

Hi! I can help your fix your problem. Read the following points for "Why me": - I'll do the clean fix. - I'll make the static fix; static and dynamic fix; dynamic. - I'll make the fix update friendly. - I'll m Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(68 Değerlendirme)

Hello buyer, I can resolve and fix the issue with your Magento website. I shall make it to work the indexing on your site for the 'Catalog URL Rewrites' index. Thanks, kamaladukia

$250 AUD in 7 gün içinde
(41 Değerlendirme)

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(15 Değerlendirme)

Hello, a few words about me: I am system / network administrator. I manage over 300 servers with different purposes: web servers, sql servers, voip servers, filesharing servers, email servers and so on. Each ser Daha Fazla

$50 AUD in 2 gün içinde
(26 Değerlendirme)

Dear sir, I will complete your project within 3 days, LIFETIME error free guarantee and provide ONE YEAR support... I have gone through your outsourced requirement "Magento/MySQL/Server Issue - " and have analysed Daha Fazla

$155 AUD in 3 gün içinde
(28 Değerlendirme)

Hello, Thank you for submitting your requirements!!! I was looking through your project requirements and I do believe it's something we have experience in previous development and we can complete in a reasonable Daha Fazla

$55 AUD in 2 gün içinde
(18 Değerlendirme)

Please compare my magento sites’ loadtime and quality with others on the softwares ([login to view URL], [login to view URL] and [login to view URL] (though in some sites I did not work for loading speed an Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(4 Değerlendirme)

I'm David from Xieles Support. We have done many server setup which includes web service, mail service, DNS service. We are experts in fixing Magento errors. Xieles Support has been in server administration and tech Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(3 Değerlendirme)