You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Antal Sinkovits (Jira)" <ji...@apache.org> on 2022/03/18 08:03:00 UTC
[jira] [Work started] (HIVE-26048) Missing quotation mark in findReadyToClean query
[ https://issues.apache.org/jira/browse/HIVE-26048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-26048 started by Antal Sinkovits.
----------------------------------------------
> Missing quotation mark in findReadyToClean query
> ------------------------------------------------
>
> Key: HIVE-26048
> URL: https://issues.apache.org/jira/browse/HIVE-26048
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.0
> Reporter: Antal Sinkovits
> Assignee: Antal Sinkovits
> Priority: Major
> Labels: ACID
>
> Missing quotation mark causes postgres column error
> {code}
> 2022-03-18T00:53:43,314 ERROR [Thread-651] compactor.Cleaner: Caught an exception in the main loop of compactor cleaner, MetaException(message:Unable to connect to transaction database org.postgresql.util.PSQLException: ERROR: column "cq_retry_retention" does not exist
> Position: 485
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
> at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
> at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
> at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
> at org.apache.hive.com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:108)
> at org.apache.hive.com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
> at org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findReadyToClean(CompactionTxnHandler.java:374)
> at org.apache.hadoop.hive.ql.txn.compactor.Cleaner.run(Cleaner.java:146)
> )
> at org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findReadyToClean(CompactionTxnHandler.java:397)
> at org.apache.hadoop.hive.ql.txn.compactor.Cleaner.run(Cleaner.java:146)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)