Hi Albert,
I started poking around my code on my boxes. I have never had this particular error before.
I can see where the array is created in any of the apps, and where it is used in a few places. It looked like there was some association with persistent connections, like maybe the array is used to store persistent connections??? I could be all wrong - just kind of following hunches, but maybe the array either doesn’t get used (and fails) until something on the server happens. Perhaps the connections never release or go to too many… I don’t know much about this at all. But it may be something to check. Can you restart the Apache and maybe clear all connections and see if that causes the error to go away for a while?
Just for the hell of it, look at the directives on your machines. On mine, I do not have max_connections , rather , it has mysql.max_persistent Unlimited Unlimited
I also noticed the C: drive in the path, so this is on a windows box… I am on Linux on production… and have started my SC7 dev ONLY on linux box. Are both your dev and production on Windows? If so, maybe it is related to a LAMP implementation issue on Windows?
You said it was around for a long time, that it would happen but when you regen it would clear up for awhile… I wonder if that is a clue. Does regen and/or redeploy reset something , like the connections on the server? Maybe the new SC7 release that is failing more consistently has some change that makes it have a lower threshold for such a problem? Or maybe the regen/deploy does not clear the connection(s)… if that is even the problem.
If it would be of help to you, we could run a test app and DB set up on my Webfaction account if you want to test it up there. I can make a folder available for you if you need it. Skype or email tomorrow if I can assist in any way.
I am again just shooting in the dark here, but I feel your pain.
Hope SC can reproduce it quickly and solve
Jamie
PS Here is more from my phpinfo:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version mysqlnd 5.0.10
Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off