Hi all
I having issue with Ignition and PostgreSQL DB as historian DB.
Ignition generates waring each 1 minute that sqlth_drv table is already exists - and indeed it exists, and has data inside which was added there by Ignition itself. I spend a lot of time trying to fix this warning but I cannot find the cause of it since Ignition clearly has access to DB (it creates table and writes data to it).
So one of latest test which I did is following:
- Empty DB is created in PostgreSQL DB
- I disabled historian provider in Ignition
- Disabled DB connection to historian DB in Ignition (it referencing old DB - not new one which I created in step 1)
- Cleared log files (deleted folder with DB connection name inside C:\Program Files\Inductive Automation\Ignition\data\datacache)
- Changed path (in DB connection) to the new DB which was created in step 1.
- Enabled DB connection.
- Enabled historian provider
After all those steps Ignition created tables in a DB and starts writing data to it with no issues. No warnings yet, but in the moment when VM is rebooted or Ignition service is restarted waring appears each minute - Ignition continue writing historian data into DB with no issue (at least I am no seeing issues)
There are no other DB connection which looking in same DB.
Original set up had redundancy for Ignition but for test porpoises I shut down backup VM.
Set up which I have:
Ignition 8.1.19 Windows Server 2025 Standard v24H2
PostgreSQL v18.1 Windows Server 2025 Standard v24H2
Does somebody faced this issue before?
Is there any suggestions what can I test or do in order to figure out / fix this warning?
