I had a similar problem with memory exhausted and taking too much time, when changing currency and logging in. I talked with elfling in another post.
I tried to disable all modules and enables one after another. but no change. then I logged all mysql queries and noticed that IG_CashOnDelivery Module and Klarna Invoice Module send queries again and again. so luckily I do not need both modules and uninstalled them and now it works like a charm. So what i can say: disabling module needn\’t be enough! Look for the SQL Queries!
The problem is there again. but this time i cannot find any solution. I can see in the SQL query log that some queries are fired and fired again when changing the currency. But there is nothing with a module this time. What do you mean by “show processlist”? I cannot find this method. My Hosting provider is now also looking for the error
Thanks. Unfortunately I have no clue of Shell or SSH. I can just see in the SQL Query Log that approx 110 queries are repeated 200 times, then a new connect and this happens 4 Times until the Internal Error stops the execution.
I have attached two files. First is going from product page to cart (works fine) and second is cart reload after currency change (just first 1500 lines). the currency change itself seems to work fine but the reload after it is causing the problem. I compared the two files, and from one point they are doing different things. Maybe if you have time, you may have a quick view on the files, and maybe you can see where the error occurs. Would be great!
That is so embarassing! When I searched for
in my code to find any occurrences (as you mentioned before), i must have put that line in one of my modules by accident. After I found out my own module was causing the error, I found that line and wanted to sink into the ground.