Hi (first of all, thanks for your attention & sorry for my bad english hahaha also this is not a programming error, or thats what I think, I think this is an error in some configuration of the server or something else but I dont know what)
I have a php script (is running like a process of linux, its not running on the web browser) that send SMS via SMPP on the port 2055 (using sockets in php) & then inserts like 10,000 rows into a dababase on MySQL, the script gets the data from a XML file; firts it was running in a shared server (Hostgator is our hosting provider) & at the begining it worked fine, with no trouble, but 5 months later an error appear, the process just die with no reason, the script only sent & inserted 700 rows in the table of the database & the process didnt show any warning or error, nothing appears in the error logs, & I didnt make any change in the script
Hostgator never helped us hahaha so we decided to move the script from the shared server to a dedicated server; I thought it was a memory problem or something like that, but when we move the script to the dedicated server the problem just get worse, the script die when has just sent & inserted 40 to 50 rows to the database
the information about this error:
the shared server is on Red Hat 4.1.2-46 & the dedicated server is on CentOS 5.4
I have commented the line that sends the SMS, & the problem remains
in the shared server, at the begining the script was fine, but then the script started to die when has just inserted 700 aprox. in the database, & now the script is dying when has inserted 2500 rows, its better but we didnt change anything
in the dedicated server, the script dies when has just inserted like 40 row in the table
the script, before it dies, change to a zombie process & we dont know why
the usage of memory appears to be 0.3%, and of the cpu appears to be 0.7% to 1%
I have changed the max memory limit of php to 128Mb, and even to -1 (so php wont have any limit) but the problem remains
we have the limit of 50 connections of mysql at the same time, so I think this is not the problem
Im using mysqli to connect from php to mysql
Hostgator report that they haven't made any change or update in the servers
what could be the problem?? what should I do??? what should I search??? is something in the logic Im missing?? what steps do I have to follow when managing & searching problems of process on Linux???
thank you very much, I think this is not a programming problem, but you have more experience than me, you can tell me
thanks!!! bye!!! :)
