Duplicate Tag IDs After Redundancy Failover

Ignition
1

Hi everyone,

I’m experiencing an issue with Ignition 8.1.45 (upgraded from 8.1.7 with the same problem) running in a redundant setup connected to a Postgres 13 database. Here’s the scenario:

  1. When new history tags are created while the first gateway is in the Master role, the corresponding entries are correctly inserted into the sqlth_te table.
  2. After a failover and subsequent role reversal, when the first gateway becomes the Master again, Tag Historian re-creates the IDs of the most recently created tags. However, it reuses IDs that are already associated with other tags or retire them ¿?.
  3. This results in trends, tables, and reports showing a mix of data from different tags, as queries are executed using the duplicated IDs.

Has anyone encountered this issue before or have any recommendations on how to resolve it? Any insights would be greatly appreciated!

Thanks in advance!

Example 1

Results_1
Results_1676×503 94.8 KB

Example 2:

Results_2
Results_2791×515 192 KB

2

Hello Jorge ,

I am having the same issue, I was wondering if you found the way to fixed?

Best regards.