tca=# SELECT id, val->'source'->>'uuid' as tca_m_uuid, "destinationUrl", "destinationUuid", "creationDate", "lastUpdated", "sourceUuid" FROM "endpointLink" WHERE "type" = 'HYBRIDMANAGER_PAIRED';
id | tca_m_uuid | destinationUrl | destinationUuid | creationDate | lastUpdated | sourceUuid
----+--------------------------------------------------------+---------------------------------------------+--------------------------------------------------------+----------------------------+----------------------------+--------------------------------------------------------
47 | 2yyyyyyyy-xxxxxx-xxxx-xxxxxxxxxxx | https://tca-cpxxxxx.com | 2yyyyyyy--xxxxxx-xxxx-xxxxxxxxxxx | 2024-05-02 09:41:05.011638 | 2024-05-07 07:09:29.252849 | 2yyyyyyyy--xxxxxx-xxxx-xxxxxxxxxxx
52 | 2yyyyyyyy--xxxxxx-xxxx-xxxxxxxxxxx | https://tca-cpxxxxx.com | 2yyyyyyyy--xxxxxx-xxxx-xxxxxxxxxxx | 2024-05-07 08:31:10.201297 | 2025-09-18 11:24:03.397378 | 2yyyyyyyy--xxxxxx-xxxx-xxxxxxxxxxx
(2 rows)
TCP 5
In TCA 3.4 new pairing feature introduced which needs exactly one TCA-M per TCA-CP.
kubectl exec -it postgres-0 -n tca-mgr -- psql -d tca -U tca_admin -h localhost
select * from "endpointLink" where val->>'isSelf' = 'true';
Kindly ensure that you roll back TCAP-CP upgrade using the Snapshot of tca-cp appliance to last known good status and then perform the following steps:
Note down the TCA-M uuid and compare it with the above out put. we need to delete the other stale entry.
Example:
Active TCA-M : 2yyyyyyyy--xxxxxx-xxxx-xxxxxxxxxxx1e26801a3570
Stale TCA-M: 2yyyyyyyy--xxxxxx-xxxx-xxxxxxxxxxx76df34c67d47
Delete from "endpointLink" where id in (select id from "endpointLink" where val::TEXT LIKE '%2yyyyyyyy--xxxxxx-xxxx-xxxxxxxxxxx76df34c67d47%');
exit
Refer the following document which has the detailed procedure to upgrade TCA-CP Appliance