{"action":"created","issue":{"url":"https://api.github.com/repos/moqui/moqui-framework/issues/341","repository_url":"https://api.github.com/repos/moqui/moqui-framework","labels_url":"https://api.github.com/repos/moqui/moqui-framework/issues/341/labels{/name}","comments_url":"https://api.github.com/repos/moqui/moqui-framework/issues/341/comments","events_url":"https://api.github.com/repos/moqui/moqui-framework/issues/341/events","html_url":"https://github.com/moqui/moqui-framework/issues/341","id":381830220,"node_id":"MDU6SXNzdWUzODE4MzAyMjA=","number":341,"title":"Mysql Deadlock on the second time load","user":{"login":"nbzx","id":679463,"node_id":"MDQ6VXNlcjY3OTQ2Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/679463?v=4","gravatar_id":"","url":"https://api.github.com/users/nbzx","html_url":"https://github.com/nbzx","followers_url":"https://api.github.com/users/nbzx/followers","following_url":"https://api.github.com/users/nbzx/following{/other_user}","gists_url":"https://api.github.com/users/nbzx/gists{/gist_id}","starred_url":"https://api.github.com/users/nbzx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nbzx/subscriptions","organizations_url":"https://api.github.com/users/nbzx/orgs","repos_url":"https://api.github.com/users/nbzx/repos","events_url":"https://api.github.com/users/nbzx/events{/privacy}","received_events_url":"https://api.github.com/users/nbzx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-11-17T05:27:53Z","updated_at":"2018-11-26T02:18:26Z","closed_at":null,"author_association":"NONE","body":"Moqui 2.1.0\r\nAt mysql 5.5、5.6、5.7、8.0，First load successfully completed. But second load is report：\r\n` Error in JDBC update for SQL UPDATE USER_LOGIN_HISTORY SET SUCCESSFUL_LOGIN=?, LAST_UPDATED_STAMP=? WHERE USER_ID=? AND FROM_DATE=?\r\n13:14:11.961  WARN RequireNewTx                o.m.i.e.EntityValueImpl Error updating [moqui.security.UserLoginHistory: {fromDate=2010-02-03 00:00:00.0, lastUpdatedStamp=2018-11-16 21:12:31.907, userId=EX_JOHN_DOE, successfulLogin=Y}] tx a Bitronix Transaction with GTRID [3139322E3136382E312E36000001672015B1A300000026], status=ACTIVE, 1 resource(s) enlisted (started Fri Nov 16 21:12:31 PST 2018) con Group: transactional, Con: a ConnectionJavaProxy of a JdbcPooledConnection from datasource transactional_DS in state ACCESSIBLE with usage count 1 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@f780f5c on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@f780f5c: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction\r\n13:14:11.988  WARN RequireNewTx      o.moqui.i.c.TransactionFacadeImpl Transaction rollback. The rollback was originally caused by: Error loading entity data\r\norg.xml.sax.SAXException: Error storing entity [moqui.security.UserLoginHistory] value (line 28): Error updating UserLoginHistory {fromDate=2010-02-03 00:00:00.0, userId=EX_JOHN_DOE}: record lock conflict found [40001]\r\n`"},"comment":{"url":"https://api.github.com/repos/moqui/moqui-framework/issues/comments/441499480","html_url":"https://github.com/moqui/moqui-framework/issues/341#issuecomment-441499480","issue_url":"https://api.github.com/repos/moqui/moqui-framework/issues/341","id":441499480,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTQ5OTQ4MA==","user":{"login":"nbzx","id":679463,"node_id":"MDQ6VXNlcjY3OTQ2Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/679463?v=4","gravatar_id":"","url":"https://api.github.com/users/nbzx","html_url":"https://github.com/nbzx","followers_url":"https://api.github.com/users/nbzx/followers","following_url":"https://api.github.com/users/nbzx/following{/other_user}","gists_url":"https://api.github.com/users/nbzx/gists{/gist_id}","starred_url":"https://api.github.com/users/nbzx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nbzx/subscriptions","organizations_url":"https://api.github.com/users/nbzx/orgs","repos_url":"https://api.github.com/users/nbzx/repos","events_url":"https://api.github.com/users/nbzx/events{/privacy}","received_events_url":"https://api.github.com/users/nbzx/received_events","type":"User","site_admin":false},"created_at":"2018-11-26T02:18:26Z","updated_at":"2018-11-26T02:18:26Z","author_association":"NONE","body":"The deadlock problem also exists in moqui 2.1.1 rc2 occurs in the first load\r\n10:14:20.649  WARN RequireNewTx      o.moqui.i.c.TransactionFacadeImpl Transaction rollback. The rollback was originally caused by: Error loading entity data\r\norg.xml.sax.SAXException: Error storing entity [moqui.basic.Enumeration] value (line 33): Error creating Enumeration {enumId=DST_PURCHASED_DATA}: record lock conflict found [40001]\r\n        at org.moqui.impl.entity.EntityDataLoaderImpl$EntityXmlHandler.endElement(EntityDataLoaderImpl.groovy:770) ~[moqui_temp4654131186079161880WEB-INF_lib_moqui-framework-2.1.1-rc2.jar.:2.1.1-rc2]"}}
{"actor":{"display_login":"nbzx"}}