You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Stamatis Zampetakis (Jira)" <ji...@apache.org> on 2021/11/05 12:29:00 UTC

[jira] [Assigned] (HIVE-25675) Intermittent PSQLException when trying to connect to Postgres in tests

     [ https://issues.apache.org/jira/browse/HIVE-25675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stamatis Zampetakis reassigned HIVE-25675:
------------------------------------------


> 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)