XF 2.1 Running upgrade to 2.1.0 Alpha, step 18

[rdn]

This is the code right?

public function step18($position, array $stepData)
    {
        return $this->entityColumnsToJson('XF:Post', ['like_users'], $position, $stepData);
    }

Takes more than 1 hour only for this step.
Is it expected?

Server Specs
Intel Xeon E3-1231v3
32GB DDR3
SoftRaid 4 x 2TB SATA HDD
CentOS 7.6
PHP 7.3.1
MariaDB 10.3.12

Forum Stats:
Discussions: 551,798
Messages: 10,749,847

 

[Paul B]

With 10+ million posts that step can take a while.

Has it moved on since you posted?

 

[Mike]

I certainly wouldn't expect an hour -- I believe it should be showing a progress indicator as well (numbers changing). I suppose this could indicate that the step has hung. You could kill the upgrade process and restart it (it should pick up from that step) and see if that helps at all.

 

[rdn]

I just left it running and then sleep, now it's done.

I certainly wouldn't expect an hour

I guess my HDD is just very slow as CPU usage that time is very low.

Thanks!

 

[Kirby]

A Software RAID 10 on SATA HDD is severely limited on the amount of IOPS that can be performed.
With 10M posts I'd really try to get the DB on SSD.

 

[rdn]

It's just a DevSite on Dev Server, testing and testing every 2.1 Beta release until I'm 100% ready for Live Forum update soooon .

 

[rdn]

Running last Test Upgrade before doing it final next week.

On this server Specs:

CPU: Intel Xeon E3-1245v5 - 4c/8t - 3.5GHz /3.9GHz
RAM: 64GB DDR4 2133MHz
SoftRaid 2x1.2TB NVMe

Running upgrade to 2.1.0 Alpha, step 18... took 40 minutes.

 

[rdn]

Running upgrade to 2.1.0 Alpha, step 34... took 25 mins