gistfile1.txt

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
### The error may involve com.vevo.ripple.storage.mapper.UserPropertyMapper.createPropertyKey-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO user_properties (id, legacy_user_id, vevo_user_id, property_type) VALUES (NULL, ?, ?, ?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:172) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:157) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:52) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.sun.proxy.$Proxy100.createPropertyKey(Unknown Source) ~[na:na]
	at com.vevo.ripple.storage.UserPropertiesStorage.createProperty(UserPropertiesStorage.java:294) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.vevo.ripple.storage.UserPropertiesStorage.lambda$deleteAndCreate$2(UserPropertiesStorage.java:124) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.vevo.genesis.module.mybatis.SessionHelper.execTransactional(SessionHelper.java:71) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.vevo.genesis.module.mybatis.SessionHelper.execTransactional(SessionHelper.java:64) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.vevo.ripple.storage.UserPropertiesStorage.deleteAndCreate(UserPropertiesStorage.java:114) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.vevo.ripple.api.resource.UserPropertiesResource.saveProperty(UserPropertiesResource.java:115) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:315) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:297) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:267) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.glassfish.jersey.jetty.JettyHttpContainer.handle(JettyHttpContainer.java:195) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.eclipse.jetty.server.Server.handle(Server.java:497) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) [ripple-1.0-SNAPSHOT-all.jar:na]
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) [ripple-1.0-SNAPSHOT-all.jar:na]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_91]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_91]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_91]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_91]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.Util.getInstance(Util.java:387) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:45) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:73) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75) ~[ripple-1.0-SNAPSHOT-all.jar:na]
	at org.apache.ibatis.session.defaults.