Advertisement:

Author Topic: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco  (Read 2250 times)

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
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
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,303
why are you upgrading to SMF 2.1? we dont recommend anyone use it in production.

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
why is there SMF 2.1.x Support ?

I'm testing

real server duplicate form data base and files  I'm testing
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 589
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.

Offline Juan Carlos

  • Jr. Member
  • **
  • Posts: 225
  • Gender: Male
I had the same problem with the last  hitub upgrade

Was my first problem with the updates  for 2.1
Juan Carlos

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 589
Can you also check you php error log,
the information is otherwise very low.

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
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'];
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 589
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.

Offline Antes

  • Evil Black Cat
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,951
  • Gender: Male
  • Black cat rulz!
    • Antes on GitHub
    • merta on LinkedIn
    • @XinYenFon on Twitter
    • WoWSnips
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.
You can support me directly via Patreon

In Catnip We Trust.
The solution is Catnip!
Vote for Catnip!

Current Project(s): [ WoWSnips ]
Past Project(s): [ ezPortal ] # [ Lunarfall ] # [ RDD (HTML5) ]

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
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



ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,506
  • Gender: Male
    • Kindred-999 on GitHub
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.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
""click here"" continuous click?

It should automatically continue in a few seconds

similarly forum maintance    






ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,506
  • Gender: Male
    • Kindred-999 on GitHub
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?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,434
    • sbulen on GitHub
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?   

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
@Kindred    Message is actually normal. Backplane data base changes operation in progress?

@shawnb61 just an example forum maintance  system

ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,506
  • Gender: Male
    • Kindred-999 on GitHub
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.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,434
    • sbulen on GitHub
How large is the database?   # of users/posts?

Any errors logged?

Has it ever gotten past that first step?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
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
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,434
    • sbulen on GitHub
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?) 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
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

ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,506
  • Gender: Male
    • Kindred-999 on GitHub
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.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,303
i think that is what the user said was done, or that is how i read it at least.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,506
  • Gender: Male
    • Kindred-999 on GitHub
ummm.... maybe I misread it.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,434
    • sbulen on GitHub
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...
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,434
    • sbulen on GitHub
(Note I split snrj's language-related post to a separate topic:
https://www.simplemachines.org/community/index.php?topic=559373.0  ...)
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
Yes *ALL*
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 589

Offline gevv

  • Full Member
  • ***
  • Posts: 552
  • Gender: Male
  • ElkArte powerful forum software
    • elkarte on GitHub
    • https://www.elkarte.net/
problem solved   (solution: https://www.simplemachines.org/community/index.php?topic=559373.0)

thanks @snrj and others
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 1,434
    • sbulen on GitHub
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
« Last Edit: March 17, 2018, 10:58:57 AM by shawnb61 »
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp