XF 2.1 Running upgrade to 2.0.0 Beta 2, step 2?

[rdn]

What are the task on this step?
It's taking 16 hours now just on that step.

Server Specs
Intel Xeon E3-1231v3 4c / 8t- 3.4GHz
32GB DDR3 1333 MHz
SoftRaid 4x2TB SATA HDD
CentOS 7.6
PHP 7.2.13
MariaDB 10.3.11

Forum Stats
Total Members: 1,062,327
Discussions: 540,268
Messages: 10,561,799

 

[Mike]

This shouldn't take that long. Is the number changing? It sounds like it got stuck in some sort of loop which may be indicative of some unexpected data in the DB.

What does this query return?

SELECT user_id, user_group_list, COUNT(*) AS total,
   GROUP_CONCAT(permission_combination_id ORDER BY permission_combination_id) AS ids
FROM xf_permission_combination
GROUP BY user_id, user_group_list
HAVING total > 1

 

[rdn]

Is the number changing?

Yes the (6540) part is changing/increasing but slowly.

 

[rdn]

What does this query return?

 

[rdn]

It sounds like it got stuck in some sort of loop which may be indicative of some unexpected data in the DB.

My Live forum is using MariaDB 10.2, then exported the database and imported on this Dev Server using MariaDB 10.3.
Does it matter?

 

[Mike]

Assuming the step is still running, if you run that query again, are the results any different?

If it's still the same, if you submit a ticket where we can get access to the files and trigger the upgrade script (presumably via the CLI), I can do some analysis. We haven't had any other reports of issues with this code that I'm aware of and I see no reason for this to fail like this.

 

[rdn]

Assuming the step is still running

Yes on ssh > screen Mode.

if you run that query again, are the results any different?

Same.

if you submit a ticket where we can get access to the files and trigger the upgrade script

I will create a ticket now.