Database connection errors after upgrading PostgreSQL to v.10
Posted by Anna Christian on 12/11/2017 08:29 AM
Issue: after upgrading the PostgreSQL database to v.10, the Ignition Gateway log posts errors containing the
Solution: update the JDBC driver for PostgreSQL.
After upgrading the PostgreSQL database to v.10 (from one of the previous versions), the Ignition Gateway log posts errors when queries creating new rows are run, for example:
TagHistoryDatasourceSink 18Oct2017 13:24:04 Error modifying tag information in the database.
This message can be misleading as clearly PostgreSQL v. 10 is a later version than v. Postgres 8.2. The actual issue is a result of using an older JDBC driver to connect to your database. Ignition comes with JDBC drivers for major databases pre-installed, but when new database version that requires an updated driver is released by the database developer, this pre-packaged driver may end up not working for the newly released database. Since in this case the error messages are typically a result of some functionality that the older driver does not support and is unable to correctly deal with, the error messages returned to Ignition may potentially be unhelpful or misleading. The solution to the problem in cases like that is to update the JDBC driver to the latest version provided by the database developer.
To resolve the issue follow the steps below:
You should now see that the new errors related to this database connections stopped appearing and that the data is now getting inserted into the database.