SMF Large Upgrade "Server has not responded for 30 seconds."

Started by Selroth, October 27, 2009, 06:47:43 AM

Previous topic - Next topic

Selroth

I've attached a screenshot of the error below.  Seems there are multiple threads, many dating last year, that encounter this issue.  One resolved by switching hosts (not an option for most people), another went about not upgrading at all and resolving a different problem.  I'd like to attack this problem much more directly.

Obviously, we all need a bit more information to fix the problem.  Where can I look to provide you the information you need? 

Here are my notes including the proceedures I'm going about this install:
Quote
-Backup old database using PHPAdmin.  Select all settings for export.
-Backup old files using file manager, zip function.
-Copy Database
    Log into server using ssh
    execute command
         mysql -u myUser - p myPassword myNewDatabase < myFile.sql
-Copy/unzip old files to new location
-Adjust Settings.php
    update board url
    update database info
    update paths
<<<Clone copy of SMF 1.x works!>>>
-Adjust directories in Control Panel Server Settings
-Adjust theme directories in SMF control panel
    -reset all theme paths
    -reset everyone to SMF default core
-Maintenance mode
<<<Cloning complete, ready for upgrade>>>

-Upload/replace files from SMF Large Upgrade package (in this case, using smf_2-0-rc1-2_upgrade.zip)
-Browse to http://website/upgrade.php
-Verify settings, continue

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Executing database changes
Please be patient - this may take some time on large forums. The timeelapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 2.
Executing: "Updating and creating indexes..." (1 of 19 - of this script).

Upgrade.  Error: Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again

I've left it run for over 4 hours once.  So that obviously isn't it :)
Everything is built from imagination.

Aleksi "Lex" Kilpinen

Normally you can just ignore that "error" as the script will continue regardless. But if you've waited for 4 hours, it really starts to sound strange. How large is your database?
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Selroth

About 70MB.  Too large for a PhpMyAdmin import, thus the direct to mySQL command.
Everything is built from imagination.

Aleksi "Lex" Kilpinen

That is small. REAL small. The upgrade should be done in virtually no time.

Could you try again, and this time tick the debug option to have extra information shown of the
progress, so we would know where it actually stops.

And after that, if it does this again - check your server error logs for anything that might be related.

Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Selroth

I've done the debug option, however the only difference is more spaces in the screen.  Is there somewhere I should look for a log file that it creates?  Nothing new in "public_html/smf/error_log" file.  I have a server error log that shows nothing new for this domain, a raw access log that doesn't seem to have any relevant information.  There might be a MySQL log if I poke around in ssh, though I'm a noob in that.

I appreciate your help!  I know volunteering to help people can be rather un-rewarding.  If we do resolve this, let me know of any way to compensate you :)
Everything is built from imagination.

Aleksi "Lex" Kilpinen

That seems strange. It says "Done" on the messages indexes, and then seems to start the same thing again.
If nothing came up on any errorlogs - I'm a bit unsure as to how to go from here.

Could you just post specs on what version are you upgrading, and to what version are you upgrading to,
and what version of php and mysql are you running - and in the meantime I'll ask if someone else on the team knows the upgrade script better...
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Selroth

I am running SMF 1.1.10, upgrading to SMF 2.0 RC1.2.

PHP version
5.2.10
MySQL version
5.0.81-community-
log
Architecture
x86_64
Operating system
Linux
Thanks again!
Everything is built from imagination.

Aleksi "Lex" Kilpinen

Hi selroth, I got a hint for this - but it seems like something is missing from your 1.1 database.
Are you sure the database was exported / imported completely and nothing went missing?
What mods have you installed to the 1.1 forum that might have changed the database side?

I do wonder if this could be fixed by trying to run the 1.1.10 upgrade script first to the database, before running the 2.0 upgrade, I don't know... ::)
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Selroth

Just for giggles I tried it with the 1.1.10 upgrade, and I got the attached results.  However, this is directly after the 2.0 upgrade, so not a fresh plate.  Still, got past "updating indexes"....

Everything is built from imagination.

Aleksi "Lex" Kilpinen

Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Selroth

Oddly enough, the resolution in the FAQ didn't make any difference.  I have upgraded MySql to the latest as of yesterday, so my current versions are as follows:

Apache version
2.2.14 (Unix)
PHP version
5.2.10
MySQL version
5.1.37
Architecture
x86_64
Operating system
Linux
And still the following error:
QuoteUpgrading...Updating Settings.php... Successful.
Updating and creating indexes...         Unsuccessful!
                     This query:            <blockquote>ALTER TABLE smf_smileys
ORDER BY LENGTH(code) DESC;
</blockquote>            Caused the error:            <blockquote>Youhave an error in your SQL syntax; check the manual that corresponds toyour MySQL server version for the right syntax to use near '(code)DESC' at line 2</blockquote>

Anyway, this is a bit beside the point here.  I'll try upgrading a fresh SMF 1.1.10 install later tonight and see if that works on my server.  I'll keep things posted!
Everything is built from imagination.

Aleksi "Lex" Kilpinen

Try the other solution?

The second way to resolve this for upgrading is to open "upgrade_1-1.sql" with a text editor and find the following:


ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC;


Replacing this with:


ALTER TABLE {$db_prefix}smileys
ORDER BY code DESC;
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Selroth

Worked like a charm!  Perhaps an if statement and a version check is in order for the upgrade scripts?  :)

QuoteUpgrading...Making SMF MySQL strict compatible... Successful.
Adding more room for the buddy list Successful.
Change some column types to accomodate more messages. Successful.
Final clean up... Successful.
Taking the forum out of maintenance mode... Successful.
         Upgrade Complete         That wasn't so hard, was it?  Now you are ready to use your installation of SMF.  Hope you like it!
But, we're not quite done.  I'll see if I can do an upgrade to SMF 2 now.
Everything is built from imagination.

Selroth

No Change on SMF 2.0 upgrade.  Exact same error.  Again, I'll try later tonight with a vanilla SMF 1.1.10 install.
Everything is built from imagination.

Aleksi "Lex" Kilpinen

Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Selroth

*Sigh*

Fresh install of SMF 1.1.10.  Tested it, it worked, no mods, perfectly smooth install.

Uploaded the SMF 2.0 RC1-2 upgrade replacing files, provided admin username and password, and exact same problem with the "Server has not responded for 30 seconds."

So now we know it's definitely not any mods, more than likely not a corrupted database.  So...  server setting somewhere?  Bugged upgrade script (though I'm assuming it's been tested, and there'd be a lot more issues...)?

If you'd like to play around with it some yourself I can create you webspace, FTP account, and a database.  Though, you probably have better things to do with your time :)

Unfortunately I'm out of ideas and I'm not seeing any debug information or anything that could lead me in the right way for trouble-shooting.  Would I be authorized to modify the upgrade.php script myself for troubleshooting?
Everything is built from imagination.

Aleksi "Lex" Kilpinen

You can always edit smf files for your own use, and if you find out a fix, please let us know what it was that  was holding you back.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

H

Are you able to try running the upgrade through SSH?
Have you try running the queries to add the indexes manually? (Let me know if you want me to explain in more detail :))
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Selroth

Nope, I certainly haven't tried that.  I only have a basic understanding of MySQL queries, so I may need a reference on how to accomplish this.  I'm not entirely sure what the objective of this step is either - perhaps I should spend a bit more time looking at the installer, which I assumed dynamically generated the queries.
Everything is built from imagination.

H

The queries are in upgrade.php. Most contain php variables for the table prefix and perhaps other settings to.

For some reason your upgrade is hanging on adding indexes. Adding indexes can help the performance of certain queries. Adding them is a fairly expensive procedure which if it is going slower than it should, might cause the server to timeout

It is fairly late here right now, but I can provide the exact queries tomorrow, if you still require them then :)
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Advertisement: