Home › Toolset Professional Support › [Escalated to 2nd Tier] Database Upgrade – an error has occurred during the upgrade.
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: Types plugin
This topic contains 30 replies, has 3 voices.
Last updated by Nigel 3 years, 11 months ago.
Assisted by: Nigel.
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
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.
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.
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.
Languages: English (English ) Spanish (Español )
Timezone: Europe/London (GMT+00:00)
We're coming up to 24 hours, I hope it finished 🤞
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%)
Languages: English (English ) Spanish (Español )
Timezone: Europe/London (GMT+00:00)
Current status... 🤞
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.
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.
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!
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?
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.
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.
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**
I rolled back the database as you said.
Please check now.