[jira] [Created] (IGNITE-3035) Recent JDBC discovery changes cause errors for Postgres and Microsoft SQL Server databases

["Peter Griffiths (JIRA)" <ji...@apache.org>]

Peter Griffiths created IGNITE-3035:
---------------------------------------

             Summary: Recent JDBC discovery changes cause errors for Postgres and Microsoft SQL Server databases
                 Key: IGNITE-3035
                 URL: https://issues.apache.org/jira/browse/IGNITE-3035
             Project: Ignite
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.6
            Reporter: Peter Griffiths


The changes introduced by IGNITE-1993 to the TcpDiscoveryJdbcIpFinder  class to introduce Oracle compatibility cause errors when Postgres or Microsoft SQL Server are used as the database.  No such issues were encountered using either database before.

The first node to join a grid succeeds and creates the IP table in the database, but any further node attempting to join the grid throws the following error (for Postgres):
{code}
Failed to register local node address in IP finder on start (retrying every 2000 ms).: class org.apache.ignite.spi.IgniteSpiException: Failed to initialize DB schema.
...
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
{code}

The same behaviour occurs when using Microsoft SQL Server, but it throws a different error.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)