Problems upgrading APACHE/PHP/Mysql on remote server

[M <mavem@xxxxxxx>]

Complete msg subject is "what can developer do when server provider
upgrades any of Apache/PHP/Mysql softwares to newer version and this
causes crash on already working transactions?"
I am posting this also into MySql discussion list.

I develop scripts for virtual stores, having probable market for my
programs but.... there are some questions I am really concerned, and one
of these questions is the subject of this message.
I develop my scripts locally in Win98 environment (Apache / PHP / MySql
installed) where check and debug my code, then when/if all is working
ok, transfer scripts vis ftp to Linux rented remote server.
I use another two remote servers (these are Linux free services) to
check my scripts, ftping also scripts there to check if these are
working ok before sendind to rented server.

It happened to me that some transactions began to crash on remote rented
server. Every time I ran a single PHP script to update database,
appeared '1054 Out of Sync' MySql error, and after some minutes,
appeared fatal 'Too many transactions...' error, then system halted and
after 30 minutes it became alive again.
These errors never happened into my local environment or free services I
use to check scripts, so I wrote remote server asking what was
happening. They answered for me 'oh no! now we are discovering, you were
killing our server with your transactions all these days, we have lost
some customeers because this, please dont run your scripts here to not
be obligued cut Mysql services for you'.
I passed all my sources to provider for they analyze what could be wrong
with my code, but they found any abnormal or wrong code into. The fact
is, every time one of my scripts executed, it spawned zillions of child
tasks into apache server, these tasks opened by MySql. Nobody was able
to discover where the problem was, because this script was  equal
(taking apart database fields) to other scripts which ran with no
problem

I ran PHPINFO on all environments I use and passed this info to server,
they analyzed and said probably any combination of apache/php/mysql
versions and/or/plus modules into their server was causing this problem,
but since it was impossible to discover source of error, we agree I
wouldnt run anymore my scripts on that server to not damage their
services.
Later, I rented another server provider and posted my scripts there.
They are working with no problem til today.

Now suppose I have lot of clients using my virtual store (and paying to
me for this service), suddenly remote server upgrades apache or php or
mysql (or install some new module into) and this causes crash into
scripts. What can I do?
I would like to hear from other people if this problems is (or else is
not) a common one in Apache /PHP / Mysql environment. Also would like to
know some suggestions: what to do when this happens?

Thanks in advanced

Miguel




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread77912@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php