{"action":"created","issue":{"url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2/issues/965","repository_url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2","labels_url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2/issues/965/labels{/name}","comments_url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2/issues/965/comments","events_url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2/issues/965/events","html_url":"https://github.com/rbeckman-nextgen/test-mc2/issues/965","id":523163220,"node_id":"MDU6SXNzdWU1MjMxNjMyMjA=","number":965,"title":"Mirth 1.8 RC3 - could not prune message database","user":{"login":"rbeckman-nextgen","id":57539220,"node_id":"MDQ6VXNlcjU3NTM5MjIw","avatar_url":"https://avatars3.githubusercontent.com/u/57539220?v=4","gravatar_id":"","url":"https://api.github.com/users/rbeckman-nextgen","html_url":"https://github.com/rbeckman-nextgen","followers_url":"https://api.github.com/users/rbeckman-nextgen/followers","following_url":"https://api.github.com/users/rbeckman-nextgen/following{/other_user}","gists_url":"https://api.github.com/users/rbeckman-nextgen/gists{/gist_id}","starred_url":"https://api.github.com/users/rbeckman-nextgen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbeckman-nextgen/subscriptions","organizations_url":"https://api.github.com/users/rbeckman-nextgen/orgs","repos_url":"https://api.github.com/users/rbeckman-nextgen/repos","events_url":"https://api.github.com/users/rbeckman-nextgen/events{/privacy}","received_events_url":"https://api.github.com/users/rbeckman-nextgen/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2/milestones/7","html_url":"https://github.com/rbeckman-nextgen/test-mc2/milestone/7","labels_url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2/milestones/7/labels","id":4847122,"node_id":"MDk6TWlsZXN0b25lNDg0NzEyMg==","number":7,"title":"1.8.0","description":"Version 1.8, Build 0","creator":{"login":"rbeckman-nextgen","id":57539220,"node_id":"MDQ6VXNlcjU3NTM5MjIw","avatar_url":"https://avatars3.githubusercontent.com/u/57539220?v=4","gravatar_id":"","url":"https://api.github.com/users/rbeckman-nextgen","html_url":"https://github.com/rbeckman-nextgen","followers_url":"https://api.github.com/users/rbeckman-nextgen/followers","following_url":"https://api.github.com/users/rbeckman-nextgen/following{/other_user}","gists_url":"https://api.github.com/users/rbeckman-nextgen/gists{/gist_id}","starred_url":"https://api.github.com/users/rbeckman-nextgen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbeckman-nextgen/subscriptions","organizations_url":"https://api.github.com/users/rbeckman-nextgen/orgs","repos_url":"https://api.github.com/users/rbeckman-nextgen/repos","events_url":"https://api.github.com/users/rbeckman-nextgen/events{/privacy}","received_events_url":"https://api.github.com/users/rbeckman-nextgen/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":179,"state":"closed","created_at":"2019-11-14T22:44:33Z","updated_at":"2019-11-14T23:26:21Z","due_on":null,"closed_at":"2019-11-14T22:44:33Z"},"comments":1,"created_at":"2019-11-14T23:26:20Z","updated_at":"2019-11-14T23:26:23Z","closed_at":"2019-11-14T23:26:21Z","author_association":"OWNER","body":"Since I update from mirth 1.7.1 to mirth 1.8 RC3, mirth can't prune messages from database and I get this error in log.\n\n[2008-11-24 06:00:00,031]  WARN  (com.webreach.mirth.plugins.messagepruner.MessagePrunerService:260): could not prune message database\ncom.webreach.mirth.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException:   \n--- The error occurred while applying a parameter map.  \n--- Check the Message.pruneMessages-InlineParameterMap.  \n--- Check the statement (update failed).  \n--- Cause: java.sql.SQLException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'\nCaused by: java.sql.SQLException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'\n\tat com.webreach.mirth.server.controllers.DefaultMessageObjectController.pruneMessages(DefaultMessageObjectController.java:372)\n\tat com.webreach.mirth.plugins.messagepruner.MessagePrunerService.execute(MessagePrunerService.java:245)\n\tat org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n\tat org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   \n--- The error occurred while applying a parameter map.  \n--- Check the Message.pruneMessages-InlineParameterMap.  \n--- Check the statement (update failed).  \n--- Cause: java.sql.SQLException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'\nCaused by: java.sql.SQLException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'\n\tat com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)\n\tat com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505)\n\tat com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:528)\n\tat com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98)\n\tat com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:75)\n\tat com.webreach.mirth.server.controllers.DefaultMessageObjectController.pruneMessages(DefaultMessageObjectController.java:364)\n\t... 3 moreCaused by: java.sql.SQLException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)\n\tat com.mysql.jdbc.Connection.execSQL(Connection.java:2994)\n\tat com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)\n\tat com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:773)\n\tat com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)\n\tat com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)\n\tat com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)\n\t... 8 more\n\nImported Issue. Original Details:\nJira Issue Key: MIRTH-985\nReporter: omrubio\nCreated: 2008-11-24T04:06:20.000-0800"},"comment":{"url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2/issues/comments/554132403","html_url":"https://github.com/rbeckman-nextgen/test-mc2/issues/965#issuecomment-554132403","issue_url":"https://api.github.com/repos/rbeckman-nextgen/test-mc2/issues/965","id":554132403,"node_id":"MDEyOklzc3VlQ29tbWVudDU1NDEzMjQwMw==","user":{"login":"rbeckman-nextgen","id":57539220,"node_id":"MDQ6VXNlcjU3NTM5MjIw","avatar_url":"https://avatars3.githubusercontent.com/u/57539220?v=4","gravatar_id":"","url":"https://api.github.com/users/rbeckman-nextgen","html_url":"https://github.com/rbeckman-nextgen","followers_url":"https://api.github.com/users/rbeckman-nextgen/followers","following_url":"https://api.github.com/users/rbeckman-nextgen/following{/other_user}","gists_url":"https://api.github.com/users/rbeckman-nextgen/gists{/gist_id}","starred_url":"https://api.github.com/users/rbeckman-nextgen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbeckman-nextgen/subscriptions","organizations_url":"https://api.github.com/users/rbeckman-nextgen/orgs","repos_url":"https://api.github.com/users/rbeckman-nextgen/repos","events_url":"https://api.github.com/users/rbeckman-nextgen/events{/privacy}","received_events_url":"https://api.github.com/users/rbeckman-nextgen/received_events","type":"User","site_admin":false},"created_at":"2019-11-14T23:26:23Z","updated_at":"2019-11-14T23:26:23Z","author_association":"OWNER","body":"Still get following error:\r\n\r\nWARN  2008-12-01 13:20:02,406 [DefaultQuartzScheduler_Worker-1] com.webreach.mirth.plugins.messagepruner.MessagePrunerService: could not prune message database\r\ncom.webreach.mirth.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException:   \r\n--- The error occurred while applying a parameter map.  \r\n--- Check the Message.pruneMessages-InlineParameterMap.  \r\n--- Check the statement (update failed).  \r\n--- Cause: java.sql.SQLException: You can't specify target table 'MESSAGE' for update in FROM clause\r\nCaused by: java.sql.SQLException: You can't specify target table 'MESSAGE' for update in FROM clause\r\n\tat com.webreach.mirth.server.controllers.DefaultMessageObjectController.pruneMessages(DefaultMessageObjectController.java:387)\r\n\tat com.webreach.mirth.plugins.messagepruner.MessagePrunerService.execute(MessagePrunerService.java:245)\r\n\tat org.quartz.core.JobRunShell.run(JobRunShell.java:202)\r\n\tat org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)\r\nCaused by: com.ibatis.common.jdbc.exception.NestedSQLException:   \r\n--- The error occurred while applying a parameter map.  \r\n--- Check the Message.pruneMessages-InlineParameterMap.  \r\n--- Check the statement (update failed).  \r\n--- Cause: java.sql.SQLException: You can't specify target table 'MESSAGE' for update in FROM clause\r\nCaused by: java.sql.SQLException: You can't specify target table 'MESSAGE' for update in FROM clause\r\n\tat com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)\r\n\tat com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505)\r\n\tat com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:528)\r\n\tat com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98)\r\n\tat com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:75)\r\n\tat com.webreach.mirth.server.controllers.DefaultMessageObjectController.pruneMessages(DefaultMessageObjectController.java:370)\r\n\t... 3 more\r\nCaused by: java.sql.SQLException: You can't specify target table 'MESSAGE' for update in FROM clause\r\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)\r\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)\r\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)\r\n\tat com.mysql.jdbc.Connection.execSQL(Connection.java:2994)\r\n\tat com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)\r\n\tat com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:773)\r\n\tat com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)\r\n\tat com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)\r\n\tat com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)\r\n\t... 8 more\r\n\r\n\r\nFor MySQL, you can't select from a table you're updating/deleting at the same time.  JOIN would be a workaround, but it can't be used due to the \"messageFilterCriteria\" in the message SqlMap.\r\n\r\n\n\nImported Comment. Original Details:\nAuthor: chrisr\nCreated: 2008-12-01T14:32:03.000-0800"}}
{"actor":{"display_login":"rbeckman-nextgen"}}