# Historian Warning sqlth\_drv already exists **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [March 10, 2026, 8:57am UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414 "2026-03-10T08:57:45Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![y.parashchuk](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/y.parashchuk/32/37781_2.png) [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Post date:** [March 10, 2026, 8:57am UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/1 "2026-03-10T08:57:45Z")
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: 1. Empty DB is created in PostgreSQL DB 2. I disabled historian provider in Ignition 3. Disabled DB connection to historian DB in Ignition (it referencing old DB - not new one which I created in step 1) 4. Cleared log files (deleted folder with DB connection name inside C:\Program Files\Inductive Automation\Ignition\data\datacache) 5. Changed path (in DB connection) to the new DB which was created in step 1. 6. Enabled DB connection. 7. 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? ![DB Listen Addresses](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/8/88f7c8cb0dc91baae0ce30096016528ebd652aa0.png) ![DB Postgres User permissions](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/f/ef478213b1b78064929c0b948fb6df50b688178e.png) ![IGN DB connection](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/94e3832f8878292d1f4d7e66ebf19094c73f33ce.png) ![IGN DB connection Translator](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7a38129359a811a06b08528d7b6df534b6eb6de8.png) ![IGN DB connection Warning](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/1/0137067015df11cded4355964b6b90fb56604dcf.png) ---
**Author:** ![y.parashchuk](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/y.parashchuk/32/37781_2.png) [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Post date:** [March 10, 2026, 9:31am UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/3 "2026-03-10T09:31:43Z")
Thanks for suggestion. I did those by stopping ignition service and deleting folder and then started service back, but it not helped. ---
**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\ **Post date:** [March 10, 2026, 9:32am UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/4 "2026-03-10T09:32:21Z")
Sorry, I noticed after I posted that you had already tried that, hence the deletion ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 10, 2026, 5:44pm UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/5 "2026-03-10T17:44:08Z")
Try setting the `gateway.Database.TableVerifier` logger on the gateway to DEBUG. I suspect we're not able to see the existing `sqlth_drv` table, possibly due to some permissions or scoping error with the DB, and so the translator is trying to regenerate it each time. That logger should tell you what we're trying to do. ---
**Author:** ![y.parashchuk](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/y.parashchuk/32/37781_2.png) [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Post date:** [March 11, 2026, 10:22am UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/6 "2026-03-11T10:22:20Z")
> [@paul-griffith](#): > > TableVerifier It cannot find the table by some reason. I experimented with Extra Connection Properties → currentSchema=public Also tried set currentSchema=public as a part of Connect URL → tsdb?currentSchema=public Both did not change return from a logger Querying existing tables: Schema='' remaining empty. Also tried to set all privilege's which I could find to the user which Ignition uses to connect to DB: Firewalls on both VM are turned off completely. Also interesting that if I create new empty DB and create new connection to it in Ignition all works without any warning until I restart the Ignition service. Also if I delete data from a sqlth\_drv after a while (few minutes) ignition will add required data back to it. So looks like it can write to it, can create it but cannot see that it exists. Will appreciate any other suggestions. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/f/bf1adf114b4dbc8e5d2f9da9ddee8ba9a10c670d.png) ![1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/c/3c71eecaa02023f805fa58003615540c8a9db5bc.png) ![2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/5/b5e580fc5ddfbe89ffec9c3c40ca9f1674821663.png) ![3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7d2ab747cbc10bcccbfdbe70e3f83d403fbec288.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 11, 2026, 3:33pm UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/7 "2026-03-11T15:33:44Z")
I'd contact support at this point. Best case, this is something they've seen before and they can guide you to a solution. Worst case, they can reproduce it and get it filed as a bug internally that requires code changes on our part. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 11, 2026, 3:41pm UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/8 "2026-03-11T15:41:45Z")
Side note: Are you actually using the `postgres` role for your connection from Ignition? That is the DB super user by default, and isn't wise to use in your application. If you want Ignition to have total control over its DB, but just that, consider creating an `ignition` DB user and making it the owner of the database. That enables normal table/view/whatever creation, but gives no other control over the DB cluster installation (particularly the security parts) from Ignition. ---
**Author:** ![y.parashchuk](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/y.parashchuk/32/37781_2.png) [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Post date:** [March 11, 2026, 8:11pm UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/9 "2026-03-11T20:11:54Z")
No I am not planning to use it in production, I have ignition user with all required permissions, but log constantly has warning so i decided to test it with postgres user. It's not a production yet, it's been stages to go to production in a few weeks. Thanks for the note. ---
**Author:** ![y.parashchuk](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/y.parashchuk/32/37781_2.png) [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Post date:** [March 20, 2026, 8:38pm UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/10 "2026-03-20T20:38:36Z")
Hi, Is there are updates on this topic? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 20, 2026, 11:17pm UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/11 "2026-03-20T23:17:27Z")
No. _You_ need to contact [Support](https://support.inductiveautomation.com/hc/en-us) so they can take a look at your live system and collect more information from you. This forum isn't an official support venue and there's no SLAs or other such guarantees. Get in contact with support, they'll collect more information from you, and either help you fix the problem or get a bug ticket filed internally. ---
**Author:** ![y.parashchuk](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/y.parashchuk/32/37781_2.png) [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Post date:** [March 24, 2026, 3:23pm UTC](https://forum.inductiveautomation.com/t/historian-warning-sqlth-drv-already-exists/114414/12 "2026-03-24T15:23:02Z")
Help from support worked: The error you are receiving is most likely due to the JDBC Translator not recognizing that a table has already been created when it checks for tables. Can you check the Postgres Translator on your gateway and make sure the Translator has following - Create Table Syntax has: `CREATE TABLE IF NOT EXISTS {tablename} ({creationdef}{primarykeydef})` - Create Index Syntax has: `CREATE INDEX IF NOT EXISTS {indexname} ON {tablename}({columnname})`. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/a/3a8453d5564377797f1cf7655e3c307c6a4dc270.png)