[
https://issues.apache.org/jira/browse/HIVE-25675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17439231#comment-17439231
]
Stamatis Zampetakis commented on HIVE-25675:
--------------------------------------------
A similar problem was observed in HIVE-24395 but unfortunately as it is
revealed by this case the fix is not enough to guarantee that the database is
ready.
> Intermittent PSQLException when trying to connect to Postgres in tests
> ----------------------------------------------------------------------
>
> Key: HIVE-25675
> URL: https://issues.apache.org/jira/browse/HIVE-25675
> Project: Hive
> Issue Type: Bug
> Components: Testing Infrastructure
> Affects Versions: 4.0.0
> Reporter: Stamatis Zampetakis
> Assignee: Stamatis Zampetakis
> Priority: Major
>
> The following exception appears intermittently when running tests using
> dockerized Postgres.
> {noformat}
> Unexpected exception org.postgresql.util.PSQLException: FATAL: the database
> system is starting up
> 21:26:55 at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:525)
> 21:26:55 at
> org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:146)
> 21:26:55 at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:197)
> 21:26:55 at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
> 21:26:55 at
> org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:217)
> 21:26:55 at org.postgresql.Driver.makeConnection(Driver.java:458)
> 21:26:55 at org.postgresql.Driver.connect(Driver.java:260)
> 21:26:55 at java.sql.DriverManager.getConnection(DriverManager.java:664)
> 21:26:55 at java.sql.DriverManager.getConnection(DriverManager.java:247)
> 21:26:55 at
> org.apache.hadoop.hive.ql.externalDB.AbstractExternalDB.execute(AbstractExternalDB.java:191)
> 21:26:55 at
> org.apache.hadoop.hive.ql.qoption.QTestDatabaseHandler.beforeTest(QTestDatabaseHandler.java:116)
> 21:26:55 at
> org.apache.hadoop.hive.ql.qoption.QTestOptionDispatcher.beforeTest(QTestOptionDispatcher.java:79)
> 21:26:55 at
> org.apache.hadoop.hive.ql.QTestUtil.cliInit(QTestUtil.java:717)
> 21:26:55 at
> org.apache.hadoop.hive.cli.control.CoreCliDriver.runTest(CoreCliDriver.java:189)
> 21:26:55 at
> org.apache.hadoop.hive.cli.control.CliAdapter.runTest(CliAdapter.java:104)
> 21:26:55 at
> org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver(TestMiniLlapLocalCliDriver.java:62)
> {noformat}
> As the exception indicates when we try to connect to Postgres the database is
> not yet completely ready despite the fact that the respective port is open
> thus leading to the previous exception.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
