AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] phpbb migration timeout

3 Posts
2 Users
0 Reactions
2,850 Views
Posts: 7
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@michael-tcr)
Active Member
Joined: 7 years ago
[#8860]

I'm getting a timeout error with my migration from phpbb.  I've tried to lower the cycle count from 200 to 100 and that allowed the processing to continue to about 13% and it stopped.

What's the proper course of action after receiving a timeout?

  • Refresh the page until completion?
  • Uninstall/reinstall wpforo, lower the cycle count and run the migration?
  • Some other steps?

2 Replies
Sofy
Posts: 5774
 Sofy
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@sofy)
Support Team
Joined: 8 years ago

Hi @michael-tcr,

I think you should reduce the 200 value and make it e.g. 80. 

So in address bar fond the &itempercycle=200 and change it to &itempercycle=80 then press F5. 


Posts: 7
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@michael-tcr)
Active Member
Joined: 7 years ago

Thanks Sofy!  I tried using several other values ... 100, 50, 20, 10 and they each resulted in a timeout.  I didn't get a page indicating a successful completion with any attempt.  The timeout problem looks to be more indicative of the shared server's resources. 

As an FYI, to restore the phpbb database to enable the local connection setup I had to generate a database script that contained one record per insert transaction. The typical multiple records per insert statement generated by a php admin database backup was timing out during post transactions which happen to be about 1M per post.  This also points to a resource contstraint my my customer's server.

My real concern was with re-running the migration after modifying the record count per cycle.  I didn't want duplicate records to be delivered.  There is a prompt just before running the migration that indicated something about duplication ... I can't recall the exact words ... but this was the basis of my concern.

After looking through the wpforo tables this morning... my concerns are realized ... the record counts are reflective of multiple inserts and the wpforo data is not usable in this state.

With the this new information, I have answered my own question ... if a timeout occurs, the wpforo plugin must be uninstalled and re-installed to reinitialize the underlying tables.  I suppose I'll have to try a value of "1" in view my server's timeout/resource problem.


Share: