Created
June 24, 2015 05:47
-
-
Save deinlandel/6f4a8082cc20185f1a6c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| com.navixy.common.storage.StorageException: Failed calling com.navixy.apiserver.storage.dao.TrackerDao.updateTraffic | |
| at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_67] | |
| at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_67] | |
| at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_67] | |
| at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_67] | |
| at com.navixy.commons.storage.dao.DaoEnhancer.createException(DaoEnhancer.java:54) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| at com.navixy.commons.storage.dao.DaoEnhancer.access$200(DaoEnhancer.java:21) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| at com.navixy.commons.storage.dao.DaoEnhancer$ExceptionConverter.intercept(DaoEnhancer.java:151) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| at DaoEnhancer_com.navixy.apiserver.storage.dao.TrackerDao$$EnhancerByCGLIB$$cc11daaa.updateTraffic(<generated>) ~[cglib-nodep-2.2.2.jar:na] | |
| at CacheEnhancer_com.navixy.apiserver.storage.dao.TrackerDao$$FastClassByCGLIB$$6e1878b4.invoke(<generated>) ~[cglib-nodep-2.2.2.jar:na] | |
| at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[cglib-nodep-2.2.2.jar:na] | |
| at com.navixy.commons.cache.DummyInterceptor.intercept(DummyInterceptor.java:21) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| at CacheEnhancer_com.navixy.apiserver.storage.dao.TrackerDao$$EnhancerByCGLIB$$c6048efe.updateTraffic(<generated>) ~[cglib-nodep-2.2.2.jar:na] | |
| at com.navixy.apiserver.jobs.billing.traffic.TrackerTrafficCharger.doTransactionAndUpdateTraffic(TrackerTrafficCharger.java:35) ~[api-server.jar:na] | |
| at com.navixy.apiserver.jobs.billing.traffic.TrackerTrafficCharger.doTransactionAndUpdateTraffic(TrackerTrafficCharger.java:16) ~[api-server.jar:na] | |
| at com.navixy.apiserver.jobs.billing.traffic.TrafficCharger.chargeOne(TrafficCharger.java:77) [api-server.jar:na] | |
| at com.navixy.apiserver.jobs.billing.traffic.TrafficCharger.tryChargeOne(TrafficCharger.java:64) [api-server.jar:na] | |
| at com.navixy.apiserver.jobs.billing.traffic.TrafficCharger.charge(TrafficCharger.java:47) [api-server.jar:na] | |
| at com.navixy.apiserver.jobs.billing.ChargeTrafficJob.execute(ChargeTrafficJob.java:29) [api-server.jar:na] | |
| at com.navixy.apiserver.jobs.AbstractApiJob.execute(AbstractApiJob.java:41) [api-server.jar:na] | |
| at org.quartz.core.JobRunShell.run(JobRunShell.java:207) [quartz-2.2.0.jar:na] | |
| at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560) [quartz-2.2.0.jar:na] | |
| Caused by: org.skife.jdbi.v2.exceptions.TransactionFailedException: Transaction failed do to exception being thrown from within the callback. See cause for the original exception. | |
| at org.skife.jdbi.v2.tweak.transactions.LocalTransactionHandler.inTransaction(LocalTransactionHandler.java:204) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.tweak.transactions.SerializableTransactionRunner.inTransaction(SerializableTransactionRunner.java:42) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.tweak.transactions.SerializableTransactionRunner.inTransaction(SerializableTransactionRunner.java:66) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.BasicHandle.inTransaction(BasicHandle.java:320) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.PassThroughTransactionHandler.invoke(PassThroughTransactionHandler.java:47) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject.invoke(SqlObject.java:147) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject$1.intercept(SqlObject.java:60) ~[jdbi-2.49.jar:na] | |
| at com.navixy.apiserver.storage.dao.TrackerDao$$EnhancerByCGLIB$$af4d8552.updateTraffic(<generated>) ~[jdbi-2.49.jar:na] | |
| at CacheEnhancer_com.navixy.apiserver.storage.dao.TrackerDao$$FastClassByCGLIB$$6e1878b4.invoke(<generated>) ~[cglib-nodep-2.2.2.jar:na] | |
| at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[cglib-nodep-2.2.2.jar:na] | |
| at com.navixy.commons.storage.dao.DaoEnhancer$ExceptionConverter.intercept(DaoEnhancer.java:148) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| ... 14 common frames omitted | |
| Caused by: com.navixy.common.storage.StorageException: Failed calling com.navixy.common.storage.dao.TransactionDao.debitBalance | |
| at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_67] | |
| at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_67] | |
| at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_67] | |
| at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_67] | |
| at com.navixy.commons.storage.dao.DaoEnhancer.createException(DaoEnhancer.java:54) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| at com.navixy.commons.storage.dao.DaoEnhancer.access$200(DaoEnhancer.java:21) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| at com.navixy.commons.storage.dao.DaoEnhancer$ExceptionConverter.intercept(DaoEnhancer.java:151) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| at DaoEnhancer_com.navixy.common.storage.dao.TransactionDao$$EnhancerByCGLIB$$2f452c2a.debitBalance(<generated>) ~[cglib-nodep-2.2.2.jar:na] | |
| at com.navixy.apiserver.jobs.billing.TransactionCallback.call(TransactionCallback.java:28) ~[api-server.jar:na] | |
| at com.navixy.apiserver.storage.dao.TrackerDao.updateTraffic(TrackerDao.java:646) ~[api-server.jar:na] | |
| at com.navixy.apiserver.storage.dao.TrackerDao$$EnhancerByCGLIB$$af4d8552.CGLIB$updateTraffic$56(<generated>) ~[jdbi-2.49.jar:na] | |
| at com.navixy.apiserver.storage.dao.TrackerDao$$EnhancerByCGLIB$$af4d8552$$FastClassByCGLIB$$ccd61a01.invoke(<generated>) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.PassThroughTransactionHandler$2.inTransaction(PassThroughTransactionHandler.java:53) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.tweak.transactions.LocalTransactionHandler.inTransaction(LocalTransactionHandler.java:193) ~[jdbi-2.49.jar:na] | |
| ... 24 common frames omitted | |
| Caused by: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction [statement:"SELECT dealer_id, balance, credits bonusBalance, credit_limit FROM users WHERE user_id = :userId FOR UPDATE", located:"SELECT dealer_id, balance, credits bonusBalance, credit_limit FROM users WHERE user_id = :userId FOR UPDATE", rewritten:"/* TransactionDao.getBalance */ SELECT dealer_id, balance, credits bonusBalance, credit_limit FROM users WHERE user_id = ? FOR UPDATE", arguments:{ positional:{}, named:{userId:43063}, finder:[]}] | |
| at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1322) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.Query.fold(Query.java:171) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.Query.first(Query.java:266) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.Query.first(Query.java:258) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.ResultReturnThing$SingleValueResultReturnThing.result(ResultReturnThing.java:96) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.ResultReturnThing.map(ResultReturnThing.java:32) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.QueryHandler.invoke(QueryHandler.java:45) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject.invoke(SqlObject.java:147) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject$1.intercept(SqlObject.java:60) ~[jdbi-2.49.jar:na] | |
| at com.navixy.common.storage.dao.TransactionDao$$EnhancerByCGLIB$$2208fcea.getBalance(<generated>) ~[jdbi-2.49.jar:na] | |
| at com.navixy.common.storage.dao.TransactionDao.debitBalance(TransactionDao.java:120) ~[api-server.jar:na] | |
| at com.navixy.common.storage.dao.TransactionDao$$EnhancerByCGLIB$$2208fcea.CGLIB$debitBalance$4(<generated>) ~[jdbi-2.49.jar:na] | |
| at com.navixy.common.storage.dao.TransactionDao$$EnhancerByCGLIB$$2208fcea$$FastClassByCGLIB$$2631a7db.invoke(<generated>) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.PassThroughTransactionHandler$2.inTransaction(PassThroughTransactionHandler.java:53) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.tweak.transactions.LocalTransactionHandler.inTransaction(LocalTransactionHandler.java:193) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.tweak.transactions.SerializableTransactionRunner.inTransaction(SerializableTransactionRunner.java:42) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.tweak.transactions.SerializableTransactionRunner.inTransaction(SerializableTransactionRunner.java:66) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.BasicHandle.inTransaction(BasicHandle.java:320) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.PassThroughTransactionHandler.invoke(PassThroughTransactionHandler.java:47) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject.invoke(SqlObject.java:147) ~[jdbi-2.49.jar:na] | |
| at org.skife.jdbi.v2.sqlobject.SqlObject$1.intercept(SqlObject.java:60) ~[jdbi-2.49.jar:na] | |
| at com.navixy.common.storage.dao.TransactionDao$$EnhancerByCGLIB$$2208fcea.debitBalance(<generated>) ~[jdbi-2.49.jar:na] | |
| at DaoEnhancer_com.navixy.common.storage.dao.TransactionDao$$FastClassByCGLIB$$1e1904cc.invoke(<generated>) ~[cglib-nodep-2.2.2.jar:na] | |
| at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[cglib-nodep-2.2.2.jar:na] | |
| at com.navixy.commons.storage.dao.DaoEnhancer$ExceptionConverter.intercept(DaoEnhancer.java:148) ~[commons-0.1.121-SNAPSHOT.jar:na] | |
| ... 32 common frames omitted | |
| Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction | |
| at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084) ~[mysql-connector-java-5.1.30.jar:na] | |
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) ~[mysql-connector-java-5.1.30.jar:na] | |
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) ~[mysql-connector-java-5.1.30.jar:na] | |
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) ~[mysql-connector-java-5.1.30.jar:na] | |
| at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1363) ~[mysql-connector-java-5.1.30.jar:na] | |
| at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:829) ~[mysql-connector-java-5.1.30.jar:na] | |
| at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307) ~[mysql-connector-java-5.1.30.jar:na] | |
| at com.zaxxer.hikari.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:44) ~[HikariCP-java6-2.2.5.jar:na] | |
| at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.execute(PreparedStatementJavassistProxy.java) ~[HikariCP-java6-2.2.5.jar:na] | |
| at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1316) ~[jdbi-2.49.jar:na] | |
| ... 57 common frames omitted | |
| 2015-06-24 05:00:52,902 INFO [DefaultScheduler_Worker-1] c.n.a.jobs.billing.TariffProlongationJob [TariffProlongationJob.java:24] Tariff prolongation | |
| 2015-06-24 05:00:53,800 INFO [qtp986716915-26520 - POST /user/auth/] c.n.a.s.security.StandardSecurityService [StandardSecurityService.java:128] Created session UserSession{type=STANDARD, userId=33383} Session{hash='37307e6cbbef3d98df1fb42638ccdbf6', expireDate=2015-07-24T05:00:53.798Z, timeZone=null} Identifiable{id=3165048} with sessionId=3165048 | |
| 2015-06-24 05:00:54,885 INFO [DefaultScheduler_Worker-1] c.n.a.jobs.billing.TariffProlongationJob [TariffProlongationJob.java:35] Tariff prolongation - DONE |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment