View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003727 | SymmetricDS | Bug | public | 2018-09-19 17:36 | 2018-10-31 18:59 |
| Reporter | hanes | Assigned To | josh-a-hicks | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.13 | ||||
| Target Version | 3.9.15 | Fixed in Version | 3.9.15 | ||
| Summary | 0003727: MySQL documentation needs updated to reflect need to grant the PROCESS priv for transaction id | ||||
| Description | user guide should reflect the need to grant the PROCESS priv due to the following: "We had to change the way we looked up the transaction id for MySQL versions after 5.7.6. Prior to 5.7.6 we used: select VARIABLE_VALUE from INFORMATION_SCHEMA.SESSION_STATUS where VARIABLE_NAME='COM_COMMIT'; Post 5.7.6 we are using: select TRX_ID from INFORMATION_SCHEMA.INNODB_TRX where TRX_MYSQL_THREAD_ID = CONNECTION_ID(); " | ||||
| Tags | No tags attached. | ||||
|
|
org.jumpmind.db.sql.SqlException: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:503) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:342) at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:224) at org.jumpmind.symmetric.service.impl.NodeService.updateNodeHost(NodeService.java:201) at org.jumpmind.symmetric.service.impl.NodeService.updateNodeHostForCurrentNode(NodeService.java:212) at org.jumpmind.symmetric.job.PushHeartbeatListener.heartbeat(PushHeartbeatListener.java:91) at org.jumpmind.symmetric.service.impl.DataService.heartbeat(DataService.java:2242) at org.jumpmind.symmetric.job.HeartbeatJob.doJob(HeartbeatJob.java:50) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:226) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:297) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:379) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:342) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501) ... 17 more |
|
SymmetricDS: 3.9 00c474cc 2018-10-16 14:57:33 Details Diff |
0003727: MySQL documentation needs updated to reflect need to grant the PROCESS priv for transaction id |
Affected Issues 0003727 |
|
| mod - symmetric-assemble/src/asciidoc/appendix/mysql.ad | Diff File | ||
|
SymmetricDS: 3.9 290095f7 2018-10-29 16:21:24 Details Diff |
0003727: MySQL documentation needs updated to reflect need to grant the PROCESS priv for transaction id |
Affected Issues 0003727 |
|
| mod - symmetric-assemble/src/asciidoc/appendix/mysql.ad | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-09-19 17:36 | hanes | New Issue | |
| 2018-09-19 17:36 | hanes | Note Added: 0001242 | |
| 2018-09-19 17:36 | hanes | Status | new => confirmed |
| 2018-09-19 17:39 | hanes | Summary | MySQL documentation needs updated to reflect need for grant PROCESS priv for transaction id => MySQL documentation needs updated to reflect need to grant the PROCESS priv for transaction id |
| 2018-09-19 17:39 | hanes | Description Updated | View Revisions |
| 2018-10-10 18:09 | hanes | Target Version | => 3.10.0 |
| 2018-10-16 19:00 | josh-a-hicks | Changeset attached | => SymmetricDS 3.9 00c474cc |
| 2018-10-25 19:04 | hanes | Target Version | 3.10.0 => 3.9.15 |
| 2018-10-29 20:13 | mmichalek | Assigned To | => mmichalek |
| 2018-10-29 20:13 | mmichalek | Status | confirmed => assigned |
| 2018-10-29 20:21 | mmichalek | Assigned To | mmichalek => josh-a-hicks |
| 2018-10-29 20:21 | mmichalek | Status | assigned => resolved |
| 2018-10-29 20:21 | mmichalek | Resolution | open => fixed |
| 2018-10-29 20:21 | mmichalek | Fixed in Version | => 3.9.15 |
| 2018-10-29 21:00 | mmichalek | Changeset attached | => SymmetricDS 3.9 290095f7 |
| 2018-10-31 18:59 | mmichalek | Status | resolved => closed |