NC15: Completion notification when running db:convert-filecache-bigint via cron

After upgrading to Version 15.0.4, I’m running the db:convert-filecache-bigint via cron (as I’m using shared hosting).

The command has started successfully according to the e-mail notification I received from cron.

Nextcloud is in maintenance mode - no apps have been loaded

Following columns will be updated:

  • activity.activity_id
  • activity.object_id
  • activity_mq.mail_id
  • filecache.fileid
  • filecache.parent
  • filecache.mimetype
  • filecache.mimepart
  • filecache.mtime
  • filecache.storage_mtime
  • storages.numeric_id

This can take up to hours, depending on the number of files in your instance!

How will I know this command has completed? Will there be a second e-mail?

I suppose if I check all those columns in phpMyAdmin and see that they’re already bigint then that must mean the conversion is completed. It might be nice if this use case had some completion notification functionality.

Is the runtime in your shared hosting limited via cron? Not that the process ends half-finished. In theory you can run the command again and if it was already done it should say nothing to do.
Checking via phpmyadmin is another idea.

Not having shell access at all, then cron is the only way I can run such commands.

When the cron command ran aagain one hour later, it said there was no work to be done, so it seemed to be finished.

Also, all the columns mentioned in the first run were bigint when I checked them in phpMyAdmin, so it seemed likely to be finished.