XF2 upgrade takes a long time

[duderuud]

I just upgraded b1 to b2. The upgrade took a long time because of permissions (with 27mln posts)

Is this normal behaviour for every future upgrade or did it have to do with some specific bugfix so it was only needed in this upgrade?

 

[Chris D]

If it's what I suspect it is, then it will be exclusive to the Beta 2 upgrade. However, can you quantify what "a long time" is? And how many users?

 

[duderuud]

I would say 30 minutes for about 135k users

 

[Mike]

If you run the master data rebuild again (via /install/), does it take that long?

 

[Kirby]

I just did an upgrade from Beta 1 to Beta 2 (2.7M posts, 44K users), took less than 30 seconds via CLI.

 

[Mike]

If it's the permissions thing as mentioned, there is a fix in beta 2 for a bug in beta 1 which potentially caused many duplicate permission combination entries to be created, which would specifically explain a much longer permission rebuild time. The B2 upgrade script should be removing the duplicate permission combinations from users and the permission rebuilder should be removing any unused permission combinations.

I wouldn't expect the permission rebuild speed in B2 to be significantly different from the speed in 1.x for a given number of permission combinations.

 

[duderuud]

If you run the master data rebuild again (via /install/), does it take that long?

Will try that tonight. I ran a file check and that initiated a rebuild of trophies that is probably still running now...

 

[duderuud]

It is still "rebuilding trophies (2)", running for hours now (I would guess 8 hours).
Is there a way to check the progress? Looks like it hangs...

Edit: Cancelled the rebuilding and running master data rebuild to see if that will fix the problem...

 

[Mike]

That's an open bug: https://xenforo.com/community/threads/rebuilding-trophies.133546/

 

[duderuud]

Ah okay thanks

 

[duderuud]

Rebuilding the master data fixed the issue, no rebuilding after a file health check.

 

[Mike]

Was the master rebuild/permission rebuild the speed you expected this time?

 

[duderuud]

Yes, it took a while but not hours

 

[Mike]

Just as a point of comparison, how many rows do you have in xf_permission_combination in XF1 vs XF2 (now that you've run the subsequent rebuilds)? If they're not similar, that would either be a bug (if you haven't changed permissions; this was supposed to be cleared up in beta 2) or the cause of it potentially being slower.