Nothing but problems since I upgraded... now Database Error 0071

Last November I upgraded from 1.3.8 to 1.5.5 and it's been one thing after another. Now for the last two weeks my site keeps knocking out my hosts server and he has no clue why. At this very moment I have Database Error 0071 and can't access the database. And all sites hosted by him are down and it's my zencart that's doing this. I can access ftp though so nothing wrong with files. I've triggered this several times now by editing an order to mark shipped or editing a product using the admin panel. Also triggered one time when I went to log into phpmyadmin.
Once he resets Apache (I think that's what he's doing) the site then works again for a while until something (and he doesn't know what) knocks it out again. Anyone have any clue what's up here? He said he thought if I could use php 7 it would fix it but my Zen apparently won't work with that because some of the plugins I use often won't work with 7. I've asked him constantly if the logs say anything and he never answers so they apparently don't say anything or hes missing the problem. I don't know much about this stuff but if you have anything helpful I can relay to him that's appreciated much!

Seems to be an ongoing issue with the host.
https://www.zen-cart.com/showthread....setting-Apache
https://www.zen-cart.com/showthread....re-reset-fixes
https://www.zen-cart.com/showthread....led-new-server

Quote:

---

Originally Posted by osdmarine

Also triggered one time when I went to log into phpmyadmin.

---

That would have nothing to do with Zen Cart. That would be a server-specific problem between the server-supplied phpMyAdmin software and your MySQL database.

Quote:

---

Originally Posted by osdmarine

I've asked him constantly if the logs say anything and he never answers so they apparently don't say anything or hes missing the problem.

---

Find out why he never answers. One host I worked with "never answered" when I asked about logs, and it turns out that's because the actually were never looking ... found out that it was because they had no idea how to read server logs. Ended up finally moving to a host who knew what it meant to manage and troubleshoot server issues.

He's telling me right now he thinks using php 7 will fix it. I use easypopulate often though processing orders and even most current version I'm using causes an error when he puts me on php 7 and it won't work.
The issue seems to be triggered when a change to the database happens. Its like it keeps building up until apache crashes. Last time was at 3:31pm today when someone was trying to place an order. The order never completed and the database went down right then. He said also he's increased my memory alotment to way more than any of his other customers too. That fixed some problems I was having a month ago but this new 0071 error thing has only been happening for the last couple weeks. And he says hes made no new changes in the last couple weeks either.

Are there any myDEBUG*.log files present in the store's /logs directory that identify a database-related issue?

As for easypopulate and php 7, not sure which is being used, but EasyPopulate V4 has been maintained compatible. There are other programs that also do bulk database maintenance either following the Easy Populate concept or not.

But the important thing first is being able to accept orders and make money. Anything after that should be able to be worked out.

Quote:

---

Originally Posted by lat9

Are there any myDEBUG*.log files present in the store's /logs directory that identify a database-related issue?

---

I didn't recognize any problems but also forwarded all logs to my host guy that seemed to be during the times of problems. If he looked at them (a BIG if), he never told me he saw any problems.

Quote:

---

Originally Posted by osdmarine

I didn't recognize any problems but also forwarded all logs to my host guy that seemed to be during the times of problems. If he looked at them (a BIG if), he never told me he saw any problems.

---

So, there are a bunch of people here that might be able to offer suggestions if those logs are posted here (start with the most recent of them), also if they are admin logs, suggest sanitizing out the admin directory name.

Quote:

---

Originally Posted by mc12345678

So, there are a bunch of people here that might be able to offer suggestions if those logs are posted here (start with the most recent of them), also if they are admin logs, suggest sanitizing out the admin directory name.

---

These logs are really big but there's two types. The paypal logs when an order is placed and a log that has errors in it. I looked at the error ones and they basically say can't connect to the database. The attached image is the logs and you can see at 8:21 the server first kicked out then the 8:31 logs are all server down. Then by 9:39 its apparently working again because I got another order. I don't think my hosting guy fixed it either tonight because he has no clue apparently when it kicks out. I forgot to mention it also seems to fix itself too over time but I'm missing orders so I can't wait for that!

Attachment 17802

OK just got this message from my hosting guy...

"To be specific this error (0071) means too many files are open at one time. I
have gotten this error on my site recently as well.
All of my efforts so far did not work. I just found another place where
I can increase limits. Most of this is low level commands and not a
graphical interface. I have tried and tested many fixed this evening
that may have brought your site down for a few seconds a few times.
I have not been able to run backups for a while. I turned them off back
when the server started crashing late at night. Each time I tried a fix
I was still not able to run a full backup. It would produce the same
type of error you would get.
As of now I really think we are good to go due to the above statement
and a manual mysql upgrade. I have been able to run many backups in a
row and nothing is failing. If you get any logs of any errors going
forward please tell me right away. I did not upgrade your php."

The image of logs I posted above showing where it went down around 8:30 was when he was working on it. He says he thinks by upgrading mysql it has fixed it. We'll see I guess! Thanks all for the help and advice its appreciated much!