[HIVE-26048] Missing quotation mark in findReadyToClean query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0-alpha-1
• Fix Version/s: 4.0.0-alpha-1
• Labels: ACID pull-request-available
• Assignee: Antal Sinkovits
• Reporter: Antal Sinkovits
• Created: 18/Mar/22 08:00
• Updated: 17/Nov/22 08:48
• Resolved: 21/Mar/22 12:24

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)

Issue Links

• is caused by: HIVE-25943 Introduce compaction cleaner failed attempts threshold
• links to: GitHub Pull Request #3118