Apache Gobblin Gitter messages at 2019/08/12 20:41:34

[ap...@gmail.com]

####  ![](https://avatars0.githubusercontent.com/u/21955844?v=4&s=60) Rodrigo
Nicolas Garcia (rodrigongarcia)

**[2019-08-12T21:12:56.648Z]** hello i have problems whit DB store:

* * *

####  ![](https://avatars0.githubusercontent.com/u/21955844?v=4&s=60) Rodrigo
Nicolas Garcia (rodrigongarcia)

**[2019-08-12T21:12:57.552Z]** 2019-08-12 20:45:45 UTC ERROR [Task-committing-
pool-1] org.apache.gobblin.metastore.database.DatabaseJobHistoryStoreV100 254
- Failed to put a new job execution information record  
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait
timeout exceeded; try restarting transaction  
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:404)  
at com.mysql.jdbc.Util.getInstance(Util.java:387)  
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)  
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)  
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)  
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)  
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)  
at
com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)  
at
com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)  
at
com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)  
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)  
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)  
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)  
at
org.apache.gobblin.metastore.database.DatabaseJobHistoryStoreV100.updateProperty(DatabaseJobHistoryStoreV100.java:523)  
at
org.apache.gobblin.metastore.database.DatabaseJobHistoryStoreV100.put(DatabaseJobHistoryStoreV100.java:213)  
at
org.apache.gobblin.metastore.DatabaseJobHistoryStore.put(DatabaseJobHistoryStore.java:77)  
at
org.apache.gobblin.runtime.JobContext.storeJobExecutionInfo(JobContext.java:406)  
at
org.apache.gobblin.runtime.JobContext.handleNewTaskCompletionEvent(JobContext.java:417)  
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)  
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:498)  
at com.google.common.eventbus.EventHandler.handleEvent(EventHandler.java:74)  
at
com.google.common.eventbus.SynchronizedEventHandler.handleEvent(SynchronizedEventHandler.java:47)  
at com.google.common.eventbus.EventBus.dispatch(EventBus.java:314)  
at com.google.common.eventbus.EventBus.dispatchQueuedEvents(EventBus.java:296)  
at com.google.common.eventbus.EventBus.post(EventBus.java:267)  
at
org.apache.gobblin.runtime.local.LocalTaskStateTracker.onTaskCommitCompletion(LocalTaskStateTracker.java:125)  
at org.apache.gobblin.runtime.Task.commit(Task.java:968)  
at
org.apache.gobblin.runtime.GobblinMultiTaskAttempt$1$1.call(GobblinMultiTaskAttempt.java:168)  
at
org.apache.gobblin.runtime.GobblinMultiTaskAttempt$1$1.call(GobblinMultiTaskAttempt.java:163)  
at java.util.concurrent.FutureTask.run(FutureTask.java:266)  
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)  
at java.util.concurrent.FutureTask.run(FutureTask.java:266)  
at
org.apache.gobblin.util.executors.MDCPropagatingRunnable.run(MDCPropagatingRunnable.java:39)  
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)  
2019-08-12 20:45:45 UTC ERROR [Task-committing-pool-1]
org.apache.gobblin.runtime.JobContext 408 - Failed to write job execution
information to the job history store: java.io.IOException:
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait
timeout exceeded; try restarting transaction  
java.io.IOException: com.mysql.jd

* * *

####  ![](https://avatars0.githubusercontent.com/u/21955844?v=4&s=60) Rodrigo
Nicolas Garcia (rodrigongarcia)

**[2019-08-12T21:13:25.938Z]** i have 8 jobs standalone... some have that
problem?

* * *

####  ![](https://avatars0.githubusercontent.com/u/21955844?v=4&s=60) Rodrigo
Nicolas Garcia (rodrigongarcia)

**[2019-08-12T21:13:58.767Z]**
[![image.png](https://files.gitter.im/gobblin/Lobby/zBb2/thumb/image.png)](https://files.gitter.im/gobblin/Lobby/zBb2/image.png)

* * *