Post-upgrade to 10.2509.1

Attention: If you are upgrading from an earlier version to a higher or the latest version, ensure that you complete the post-upgrade steps for each intermediate release that are listed on the post-upgrade page. If a version is not listed on the page, it means there are no post-upgrade steps required for that release.

After updating the service image to 10.2509.1, complete the following steps to correct the status of Cassandra upgrade records.

Procedure

Log in to Cassandra. Access the Cassandra node and log in using cqlsh.
Select the Keyspace using the following command.
```
USE <iv_keyspace>;
```

Run the following queries to verify the status of the upgrade records.

SELECT dc,sts FROM inv_upgrade WHERE id = 's1490_11-create_es_index' ALLOW FILTERING;
SELECT dc,sts FROM inv_upgrade WHERE id = 's1490_10-create_es_index' ALLOW FILTERING;

Validate the status and ensure that both records return the status as complete, as shown in the following example.
```
 dc | sts
----+----------
  local | complete
```
If both records show complete status, no further action is required. If any record is not in the complete state, proceed to the next step.
Correct the status only if required. If any record is not in the complete state, complete the following steps.
1. Stop the SIP Controller Manager deployment.
  Stop the Controller Manager and wait for 5 minutes before making any updates to the database.
2. Update the status to complete.
  Run the UPDATE query only for the records that are not in the complete state. For example:
```
UPDATE inv_upgrade SET sts = 'complete' WHERE id = 's1490_11-create_es_index' AND dc = 'local';
UPDATE inv_upgrade SET sts = 'complete' WHERE id = 's1490_10-create_es_index' AND dc = 'local';
```
  Important: Ensure the dc value used in the UPDATE statement matches exactly with the value returned in the SELECT query from step 4.

Re-verify the status.

Re-run the SELECT queries from step 3 and confirm that both records are now in the complete state.

SELECT dc,sts FROM inv_upgrade WHERE id = 's1490_11-create_es_index' ALLOW FILTERING;
SELECT dc,sts FROM inv_upgrade WHERE id = 's1490_10-create_es_index' ALLOW FILTERING;

Start the SIP Controller Manager deployment.
Restart the Controller Manager deployment to resume normal operations.
Complete final validation. Ensure that no records in the database remain in an error state and the system continues to function normally.