Upgrade from 3.13.6 to 4.6.2 stuck for hours

Support & Bugs
1

Hi all,

I know that a Matomo upgrade can take a while but my upgrade from 3.13.6 to 4.6.2 is now stuck on the step 9 for more than 4 hours. The SQL request is:

ALTER TABLE ‘piwik_log_action’ CHANGE ‘name’ ‘name’ VARCHAR(4096);

Is it normal for this step to take that long? If yes, does than mean that my upgrade is going to take days? The database is around 150Go and the first 8 steps took a few seconds.

image
image1361×805 172 KB

Cheers,
Nicolas

2

Check if query is still executing by running following command in MySQL:
show full processlist