Skip Navigation

[Escalated to 2nd Tier] Database Upgrade – an error has occurred during the upgrade.

This support ticket is created 4 years, 2 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 -
- 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 -

Supporter timezone: Europe/London (GMT+00:00)

Tagged: 

This topic contains 30 replies, has 3 voices.

Last updated by Nigel 3 years, 11 months ago.

Assisted by: Nigel.

Author
Posts
#1785275

Max
error.png

I am trying to update a huge database and I get an error after more than 20 hours of updating.
Is there any other way to upgrade?

What is the link to your site?
hidden link

#1785923

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi Max

I discussed this with the developer in question who said to escalate, where he will look into it further, it looks like a problem with the session timing out during the migration, and he will need to produce a fix for that.

So I'm escalating this and will get back to you when I have some feedback to share.

#1817599

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi Max

Types 3.4.2 has been published today and it includes a fix for this, specifically it should prevent the migration timing out when it takes a very long time.

#1817635

Max

Hi Nigel

Thank you for not forgetting about me.
I received a message about a new version of the Toolset. I upgraded to 3.4.2 and started the database upgrade process.
The process will take some time. When it's finished, I'll come back here.

#1818707

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

We're coming up to 24 hours, I hope it finished 🤞

#1818763

Max

The process is not yet complete.
The upgrade takes approximately 21 hours. I haven’t come that far yet, it usually ended at 8 hours.
Therefore, this time I am more optimistic.
Fingers crossed, waiting for the finish😉
Current status: 14 hour(s) remaining (72%)

#1819911

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Current status... 🤞

#1820557

Max

Status .. completed😉.
But... all singles of CPTs (just on them I use a views with relationships) give error 500 and a white screen, because the execution time is too long.
So despite all this effort and time, I rolled back to an interrupted state using the rollback Toolset function, and now everything works fine. My thinking about this is that something went wrong while upgrading the database (although I got a successful migration message and small errors - "Database layer mode has been updated successfully. The upgrade has finished with some warnings. This may be caused by small inconsistencies in the database and it most probably has no impact on your site..."). I will try the whole process again and report the results. If possible, do not close the ticket, this process will take a couple of days.
Anyway, thanks for keeping in touch.

#1822291

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi Max

I'm waiting on more details from another client who said that the migration completed successfully, but then some of her Views that included fields of related posts were much slower than before the migration, which sounds somewhat similar to what you describe.

When you have completed the migration if you run into the same problem make a note of what in particular doesn't work.

Evidently your site is very large and it may not be possible for us to get a copy to test, but if you can describe the specific set up of what fails then we can try to reproduce it. (Or we may discover something with the site of the other client, which I think is rather smaller.)

Let me know when you are in a position to re-test and if you discover anything.

#1822363

Max

Hi Nigel

Thanks for the details. Yesterday I started the upgrade process again, it has not finished yet. If the problem reoccurs, I'll investigate in more detail. I will also try to provide you with a copy of the database for testing.

Thanks!

#1824469

Max

Hi Nigel

I have finally completed the migration process. But unfortunately the result is the same.
I found it causing an awful slowdown and a 500 error. This is a view that uses a one-to-many relationship.
If I remove it from the content template, the page loads as quickly as it did before the upgrade.
Of course, removing this view is not an option for me😉
What can I provide so that you can investigate this in more detail?

#1825069

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Nigel is on Vacation. This is Minesh here and I'll take care of this ticket. Hope this is OK.

I will require the duplicator copy of your site before the migration.
=> https://toolset.com/faq/provide-supporters-copy-site/

I hope you already have a backup before you run migration. In addition to that I will also require problem URL where I can see the view which you claim that it took too much time to load and any other additional details that you would like to share.

I have set the next reply to private which means only you and I have access to it.

#1825787

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Thank you Max.

I've passed all the information you shared to our Devs and I will keep you posts as soon as I know more.

#1825797

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

I just got the news that.

*** Please make a FULL BACKUP of your DATABASE**
Can you please navigate to section "Rollback after the migration of the relationship data structures" on the following link: Scrrenshot: hidden link
=> hidden link
And perform the rollback and once you done please let me know.
*** Please make a FULL BACKUP of your DATABASE**

#1825799

Max

I rolled back the database as you said.
Please check now.