Nextcloud 12 upgrade

I’ve decided to upgrade old Nextcloud 12 which I was using for a while to version 13 but I’ve experienced some issues. I think the problem is caused by big oc_filecache table so upgrade is stuck 48+ hours.

mysql> show table status like "oc_filecache"\G;
*************************** 1. row ***************************
           Name: oc_filecache
         Engine: InnoDB
        Version: 10
     Row_format: Compressed
           Rows: 14387677
 Avg_row_length: 136
    Data_length: 1970176000
Max_data_length: 0
   Index_length: 2412077056
      Data_free: 1476395008
 Auto_increment: 32926128
    Create_time: 2019-08-09 20:43:11
    Update_time: 2019-09-10 23:33:55
     Check_time: NULL
      Collation: utf8mb4_bin
       Checksum: NULL
 Create_options: row_format=COMPRESSED
1 row in set (0.00 sec)

-rw-r----- 1 mysql mysql 5.5G Sep 10 23:33 oc_filecache.ibd

Is there anything I can do about this problem?

Do you and your users have around 14 mio files and folders (roughly)? It could be that some clean-up routines are not working, check on the admin interface when the cronjob was run for the last time.

Please upgrade from NC13 through to NC15 or later to run a supported version.