Simple Machines Community Forum

SMF Support => SMF 2.1.x Support => Topic started by: gevv on March 14, 2018, 02:40:29 AM

Title: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 14, 2018, 02:40:29 AM
Hi,

large data base changes error

14% Overall Progress
0.2%Step Progress

Database Changes
Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 2.
Executing: "Changing column names." (1 of 41 - of this script)

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
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Illori on March 14, 2018, 05:08:20 AM
why are you upgrading to SMF 2.1? we dont recommend anyone use it in production.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 14, 2018, 06:06:52 AM
why is there SMF 2.1.x Support ?

I'm testing

real server duplicate form data base and files  I'm testing
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: albertlast on March 14, 2018, 11:22:10 AM
Thanks for invest your time to testing the upgrade process.

At the moment the information are to less to help you,
could you check the php error log maybe you see/find ther some information about the upgrade process.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Juan Carlos on March 14, 2018, 12:42:13 PM
I had the same problem with the last  hitub upgrade

Was my first problem with the updates  for 2.1
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: albertlast on March 14, 2018, 12:49:46 PM
Can you also check you php error log,
the information is otherwise very low.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 14, 2018, 12:57:23 PM
There are 129 errors all the same

Quote
PHP Notice:  Undefined index: updating_smf_installation in /.../upgrade.php on line 225

upgrade.php line 225

Code: [Select]
$upcontext['page_title'] = $txt['updating_smf_installation'];
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: albertlast on March 14, 2018, 01:02:57 PM
In the last changes,
the support for different language in the upgrade process was added.

Look like that one or more bugs was by this progress.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Antes on March 14, 2018, 01:13:01 PM
There are 129 errors all the same

Quote
PHP Notice:  Undefined index: updating_smf_installation in /.../upgrade.php on line 225

upgrade.php line 225

Code: [Select]
$upcontext['page_title'] = $txt['updating_smf_installation'];

I assume you are using Turkish language files (beta3). Keep your forum in English till RC1 or RC2.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 14, 2018, 02:29:02 PM
I do the installation in English (try english)

The reason for the error is the language file?

Quote
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



Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Kindred on March 14, 2018, 03:41:19 PM
no...

that message is actually normal.

either wait... or click there.

with one board, having 20 million posts and a database of over 2 gigabytes, upgrading from 1.1.x to 2.0, it took 34 hours to do the upgrade.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 14, 2018, 04:10:38 PM
""click here"" continuous click?

It should automatically continue in a few seconds

similarly forum maintance    

(https://www.simplemachines.org/community/index.php?action=dlattach;topic=559327.0;attach=257077)




Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Kindred on March 14, 2018, 06:16:57 PM
except this "continue" is not the same thing at all...  this continue appears because the server has not responded - not because the script has a built in wait queue.

So, no...   it can't do the same thing and this continue script is pretty much expected to happen on a forum of any real/large size...

What happens if you just wait?
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: shawnb61 on March 14, 2018, 07:31:51 PM
How large is this database?  How many messages/users?   

I am able to upgrade using the current 2.1b4 from today's github with no problems.  I just tried it on a tiny forum and a mid-sized (200k posts) forum.  Both went smoothly & quickly, just a couple minutes each. 

Second questions - the latter screenshot is from doing forum maintenance, not the upgrade - does that mean your upgrade completed?   Are you attempting forum maintenance in 2.1 or 2.0?   

Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 15, 2018, 04:30:36 AM
@Kindred    Message is actually normal. Backplane data base changes operation in progress?

@shawnb61 just an example forum maintance  system

Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Kindred on March 15, 2018, 09:01:36 AM
with a sufficiently large database or sufficiently slow host -- yes, that message is actually normal.

Let it be, or click the continue....   chances are it will eventually reconnect and continue.  If it doesn't, after 30 mins or so... then try restarting...   if that still doesn't work, then come back for more help.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: shawnb61 on March 15, 2018, 09:14:43 AM
How large is the database?   # of users/posts?

Any errors logged?

Has it ever gotten past that first step?
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 16, 2018, 02:53:26 AM
user 43610  post 804138  topic 74748

no other error logged

The same problem continues

Contact I hosting company  values to be upgraded  max_execution_time and max_input_time

then i will try again
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: shawnb61 on March 16, 2018, 03:02:43 PM
Can you describe the exact step-by-step process you follow when you do the upgrade?

Everybody does this a little differently...  Where do you get the source?  Do you copies files from /other to forum root?  Which ones?  Do you clean up any files beforehand?  If this is a test environment, was your test environment fully operational before you did the upgrade?  (Meaning, is settings.php defined properly for the current environment?) 
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 16, 2018, 03:52:14 PM
all forum files copied to folder

create new database and forum database import (mysq dummper)


download smf repair_settings.php  and replace  new db username and password , folder paths, etc

forum control everything looks fine  test ok.

download smf  2.1b4 (github )

2.1 b4 new file operations (overwrite all files, move contents for other folder, etc)

start upgrading

lang error  skip try english continuation..

after error
Quote
14% Overall Progress
0.2%Step Progress

Database Changes
Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 2.
Executing: "Changing column names." (1 of 41 - of this script)

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

Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Kindred on March 16, 2018, 04:04:30 PM
Wrong order of steps.
get 2.0,x running in your new folder BEFORE starting any copy or other upgrade process.

Make sure 2.0.x is running correctly in that location with its own database.

THEN start the upgrade process by replacing the files.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Illori on March 16, 2018, 04:06:36 PM
i think that is what the user said was done, or that is how i read it at least.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: Kindred on March 16, 2018, 04:52:49 PM
ummm.... maybe I misread it.
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: shawnb61 on March 16, 2018, 05:27:46 PM
Yeah, that's what I think is meant by:
Quote
forum control everything looks fine  test ok.

What bugs me is that it can clearly connect, but it barfs as soon as it tries to manipulate the DB.   And it never gets past the VERY FIRST step...  (Which is old 2.0 stuff, just a safety measure...)


New question:  Does the user you are using in repair_settings.php & in Settings.php have *ALL* privileges necessary to alter the database?   

Grant that DB user EVERYTHING...
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: shawnb61 on March 16, 2018, 09:06:41 PM
(Note I split snrj's language-related post to a separate topic:
https://www.simplemachines.org/community/index.php?topic=559373.0  ...)
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 17, 2018, 04:14:25 AM
Yes *ALL*
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: albertlast on March 17, 2018, 04:21:43 AM
Based on the vid from snrj,
i created a pr how should fix the issue: https://github.com/SimpleMachines/SMF2.1/pull/4635
Only this three lines are realy needed: https://github.com/albertlast/SMF2.1/blob/0c81146e2e6db4037fbf30b0d30edd4fc237a67c/other/upgrade.php#L482-L484
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: gevv on March 17, 2018, 05:29:52 AM
problem solved   (solution: https://www.simplemachines.org/community/index.php?topic=559373.0)

thanks @snrj and others
Title: Re: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco
Post by: shawnb61 on March 17, 2018, 10:46:57 AM
This is an issue & it is confirmed.

If you start the upgrade process with a language other than English, AND, you do not clear out the Themes directory beforehand, you have numerous challenges.  The DB hanging issue above, & depending on your environment, you may get a bunch of 'undefined index' messages as well. 

I'll log a 2.1 issue for this.  It should handle this more gracefully.

EDIT:  Issue logged - https://github.com/SimpleMachines/SMF2.1/issues/4636