This release is a recommended update for all 6.7.x systems. It contains improvements to:

• the SFTP client to fix an issue when publishing to Titan FTP server
• the background scheduler (3rd-party library called Quartz) to reduce database deadlock

If you are publishing to a Titan FTP server over SFTP or are seeing logging similar to the following in your system logs, please upgrade to 6.7.2:

ERROR [ErrorLogger] An error occured while releasing trigger 'DEFAULT.Publish Request Check'
org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Lock wait timeout exceeded; try restarting transaction [See nested exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction]
   at org.quartz.impl.jdbcjobstore.UpdateLockRowSemaphore.executeSQL(UpdateLockRowSemaphore.java:107)
   at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:112)
   at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3756)
   at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3725)
   at org.quartz.impl.jdbcjobstore.JobStoreSupport.releaseAcquiredTrigger(JobStoreSupport.java:2804)
   at org.quartz.core.QuartzSchedulerThread.releaseTriggerRetryLoop(QuartzSchedulerThread.java:542)
   at org.quartz.core.QuartzSchedulerThread.releaseIfScheduleChangedSignificantly(QuartzSchedulerThread.java:441)
   at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:288)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
   at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
   at org.quartz.impl.jdbcjobstore.UpdateLockRowSemaphore.executeSQL(UpdateLockRowSemaphore.java:86)
... 7 more

Issues Resolved

• CSI-29 - SFTP: Problems publishing multiple levels of folders to Titan SFTP Server
• CSI-39 - Quartz Deadlock when purging deleted assets from the Recycle Bin

Please follow every available release Upgrade Guide for every version you skipped during the upgrade.