Author Topic: MySQL Errors on Install (Read 5375 times)

Chris Burgess · February 11, 2009, 12:39:28 pm

Yes, you understood what I meant by #1. I was suspecting that the MySQL timeout was happening during the FTP upload phase, which I believe happens when you upload a ZIP file via the Joomla web interface. If as you say you aren't using that method, then this is not the cause of the MySQL timeout.

Unfortunately, that means that some other long process is causing your MySQL server to give up part way through the installation.

If your hosting program allows you to configure the MySQL server parameters (on shared hosting you may be lucky enough to have this option, and on a VPS or dedicated machine it's within your powers) then you can try #2 yourself. Otherwise you'll need to approach the provider and request it.

This may not be something they offer, and then you'll need to find a workaround. To debug the delay, you might like to look at the Joomla install script, and see which stage of the installation precedes the SQL which is displayed in your error; that's the point where the server times out, so you may want to look at ways of removing that delay.

Good luck - keep us posted!

kecker · February 12, 2009, 03:30:24 pm

In working with my server admins, I finally got this to work. Although it sounds like the install script could probably be improved to prevent this sort of error.

I created a Joomla user account for the server admins so that they could attempt the installs themselves....and monitor how the server reacted. Here is there response:

Quote

I monitored mysql connections while attempting the install procedure you outlined.
The first time it failed as described, after cleaning up the failed install per your
instructions, I tried a second time -- this time it fully succeeded (With no server
changes, this was simply a second attempt). What I found out is that the installer
appears to take a very long time to complete, it opens a single connection to mysql,
and then does multiple queries during the course of the install. While the
connection can be open for quite some time before the server would close it, the
time the connection itself can be idle is much less -- this is to prevent high load
on shared services. The server itself was under a very low load (under 1) during
both attempts. The install itself appeared to take close to a minute to complete,
and the queries were fairly spaced out. It seems in most attempts the delay between
two queries was causing the connection to drop. It would appear the delay was just
barely long enough to cause this -- as the second attempt succeeded.

Seems to me that if the install script is going to take some time in between MySQL queries, that perhaps it could close and reopen that connection in between? Or perhaps collect data and do processing up front or something to that extent so the connection isn't sitting idle for as long?

Of course I say that not having really looking very closely at the install scripts.

CiviCRM Community Forums (archive)

News:

Author Topic: MySQL Errors on Install (Read 5375 times)

Chris Burgess

Re: MySQL Errors on Install

kecker

Re: MySQL Errors on Install