View Issue Details

IDProjectCategoryView StatusLast Update
0003727SymmetricDSBugpublic2018-10-16 15:00
ReporterhanesAssigned To 
Prioritynormal 
Status confirmedResolutionopen 
Product Version3.9.13 
Target Version3.10.0Fixed in Version 
Summary0003727: MySQL documentation needs updated to reflect need to grant the PROCESS priv for transaction id
Descriptionuser 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();
"

Activities

hanes

2018-09-19 13:36

developer   ~0001242

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

Related Changesets

SymmetricDS: 3.9 00c474cc

2018-10-16 14:57:33

josh-a-hicks

Details Diff
0003727: MySQL documentation needs updated to reflect need to grant the
PROCESS priv for transaction id

0003727
mod - symmetric-assemble/src/asciidoc/appendix/mysql.ad Diff File

Issue History

Date Modified Username Field Change
2018-09-19 13:36 hanes New Issue
2018-09-19 13:36 hanes Note Added: 0001242
2018-09-19 13:36 hanes Status new => confirmed
2018-09-19 13: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 13:39 hanes Description Updated View Revisions
2018-10-10 14:09 hanes Target Version => 3.10.0
2018-10-16 15:00 josh-a-hicks Changeset attached => SymmetricDS 3.9 00c474cc