Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
4.0.0-alpha-1
-
None
Description
Missing quotation mark causes postgres column error
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)
Attachments
Issue Links
- is caused by
-
HIVE-25943 Introduce compaction cleaner failed attempts threshold
- Closed
- links to