I'm attempting to upgrade Cadence from 12.1 to 16.0 and beyond. None of my workflows will be open for longer than a month, but they all have been started on v12.1. Do I still need to run unsupported workflows command as described here:
MySQL/Postgres:
cadence admin db unsupported-workflow --db_type=<mysql/postgres> --db_address --db_port --username= --password= --db_name --lower_shard_bound= --upper_shard_bound= --rps --output_filename ./cadence_scan
If so, is my shard ID range simply 1-numHistoryShards? What are reasonable values for rps ?
Thanks!
Yes, you should still do it unless the workflow are already deleted by system due to retention config.
The reason is that there will be still some active internal tasks for those closed workflow, for example delete the workflow or visibility, or background scan etc. another reason is that Cadence allows users to use reset to reopen a closed workflow to any point of the history.
For RPS, it depends on your database current workload. I would try at least 10, and try a larger number if you think the database can take it on top of the current load.