1
|
19/08/2016
|
2
|
4.30pm
|
3
|
|
4
|
App1 RIB_System.log.62
|
5
|
[2016-08-19 16:01:07,601 ERROR](com.ib.enterprise.services.ib101_access.IBGenericLoginServices) - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
|
6
|
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
|
7
|
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
|
8
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 94) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
9
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
|
10
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
|
11
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
|
12
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
|
13
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
|
14
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
|
15
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
|
16
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
|
17
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
|
18
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
|
19
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
|
20
|
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
|
21
|
|
22
|
|
23
|
App1 svr2 SystemOut_16.08.19_16.37.45
|
24
|
[8/19/16 16:01:07:601 SGT] 00000021 SystemOut O [19/08/2016] [16:01:07:601] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
|
25
|
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
|
26
|
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
|
27
|
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
|
28
|
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
|
29
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 94) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
30
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
|
31
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
|
32
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
|
33
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
|
34
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
|
35
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
|
36
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
|
37
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
|
38
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
|
39
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
|
40
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
|
41
|
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
|
42
|
|
43
|
|
44
|
App2 RIB_System.log.211
|
45
|
[2016-08-19 16:28:37,810 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
46
|
at java.lang.Integer.parseInt(Integer.java:428)
|
47
|
at java.lang.Integer.valueOf(Integer.java:565)
|
48
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
49
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
50
|
|
51
|
[2016-08-19 16:30:48,252 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
52
|
at java.lang.Integer.parseInt(Integer.java:428)
|
53
|
at java.lang.Integer.valueOf(Integer.java:565)
|
54
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
55
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
56
|
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
|
57
|
|
58
|
App2 svr1 SystemErr_16.08.19_17.14.13
|
59
|
[8/19/16 16:41:09:959 SGT] 00000022 SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserTransactionHistory]
|
60
|
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
|
61
|
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
|
62
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 107) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
63
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
|
64
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
|
65
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
|
66
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
|
67
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
|
68
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
|
69
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
|
70
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
|
71
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
|
72
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
|
73
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
|
74
|
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
|
75
|
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2275)
|
76
|
|
77
|
|
78
|
|
79
|
|
80
|
|
81
|
====================================================================================================================================================================================
|
82
|
22/08/2016
|
83
|
2.43pm & 4:00pm - 4:30pm
|
84
|
|
85
|
App1 RIB_System.log.35
|
86
|
[2016-08-22 14:40:43,363 ERROR](com.ib.enterprise.services.ib101_access.IBGenericLoginServices) - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
|
87
|
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
|
88
|
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
|
89
|
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
|
90
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 118) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
91
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
|
92
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
|
93
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
|
94
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
|
95
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
|
96
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
|
97
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
|
98
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
|
99
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
|
100
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
|
101
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
|
102
|
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
|
103
|
|
104
|
App2 svr2 SystemOut_16.08.22_15.02.50
|
105
|
[8/22/16 14:40:43:363 SGT] 00000056 SystemOut O [22/08/2016] [14:40:43:363] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
|
106
|
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
|
107
|
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
|
108
|
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
|
109
|
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
|
110
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 118) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
111
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
|
112
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
|
113
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
|
114
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
|
115
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
|
116
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
|
117
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
|
118
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
|
119
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
|
120
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
|
121
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
|
122
|
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
|
123
|
|
124
|
|
125
|
|
126
|
App2 RIB_System.log.118
|
127
|
[2016-08-22 14:41:50,140 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
128
|
at java.lang.Integer.parseInt(Integer.java:428)
|
129
|
at java.lang.Integer.valueOf(Integer.java:565)
|
130
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
131
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
132
|
|
133
|
App2 RIB_System.log.117
|
134
|
[2016-08-22 14:44:54,923 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
135
|
at java.lang.Integer.parseInt(Integer.java:428)
|
136
|
at java.lang.Integer.valueOf(Integer.java:565)
|
137
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
138
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
139
|
|
140
|
App2 RIB_System.log.113
|
141
|
[2016-08-22 16:02:34,219 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
142
|
at java.lang.Integer.parseInt(Integer.java:428)
|
143
|
at java.lang.Integer.valueOf(Integer.java:565)
|
144
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
145
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
146
|
|
147
|
[2016-08-22 16:05:22,124 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
148
|
at java.lang.Integer.parseInt(Integer.java:428)
|
149
|
at java.lang.Integer.valueOf(Integer.java:565)
|
150
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
151
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
152
|
|
153
|
[2016-08-22 16:07:02,674 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
154
|
at java.lang.Integer.parseInt(Integer.java:428)
|
155
|
at java.lang.Integer.valueOf(Integer.java:565)
|
156
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
157
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
158
|
|
159
|
App2 RIB_System.log.112
|
160
|
[2016-08-22 16:21:14,199 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
161
|
at java.lang.Integer.parseInt(Integer.java:428)
|
162
|
at java.lang.Integer.valueOf(Integer.java:565)
|
163
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
164
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
165
|
|
166
|
[2016-08-22 16:22:46,545 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
|
167
|
at java.lang.Integer.parseInt(Integer.java:428)
|
168
|
at java.lang.Integer.valueOf(Integer.java:565)
|
169
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
170
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
171
|
|
172
|
|
173
|
App2 svr1 SystemOut_16.08.22_14.48.16
|
174
|
[8/22/16 14:41:01:081 SGT] 00000059 SystemOut O [22/08/2016] [14:41:01:081] [ERROR] [IBInterbankFundTransferConfirmServices]:527 - Error details : java.lang.NumberFormatException: null
|
175
|
at java.lang.Integer.parseInt(Integer.java:428)
|
176
|
at java.lang.Integer.valueOf(Integer.java:565)
|
177
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
178
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
179
|
|
180
|
[8/22/16 14:41:49:844 SGT] 00000044 SystemOut O [22/08/2016] [14:41:49:844] [ERROR] [IBInterbankFundTransferConfirmServices]:527 - Error details : java.lang.NumberFormatException: null
|
181
|
at java.lang.Integer.parseInt(Integer.java:428)
|
182
|
at java.lang.Integer.valueOf(Integer.java:565)
|
183
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
184
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
185
|
|
186
|
[8/22/16 14:44:54:923 SGT] 00000045 SystemOut O [22/08/2016] [14:44:54:923] [ERROR] [IBInterbankFundTransferConfirmServices]:527 - Error details : java.lang.NumberFormatException: null
|
187
|
at java.lang.Integer.parseInt(Integer.java:428)
|
188
|
at java.lang.Integer.valueOf(Integer.java:565)
|
189
|
at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
|
190
|
at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
|
191
|
|
192
|
[8/22/16 14:39:40:090 SGT] 0000006f SystemOut O [22/08/2016] [14:39:40:090] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not retrieve snapshot: [net.penril.ibss.core.hibernate.IbCustAccounts#component[accountNumber,userId]{userId=40534, accountNumber=1007021000062252}]
|
193
|
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
|
194
|
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
|
195
|
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1075)
|
196
|
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:269)
|
197
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 111) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
198
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
|
199
|
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4762)
|
200
|
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1682)
|
201
|
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:955)
|
202
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:3120)
|
203
|
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1051)
|
204
|
|
205
|
|
206
|
App2 svr1 SystemOut_16.08.22_16.14.06
|
207
|
[8/22/16 16:11:10:887 SGT] 00000060 SystemOut O [22/08/2016] [16:11:10:887] [ERROR] [JDBCExceptionReporter]:101 - Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
208
|
[8/22/16 16:11:10:887 SGT] 00000060 SystemOut O [22/08/2016] [16:11:10:887] [ERROR] [JDBCExceptionReporter]:101 - Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
209
|
[8/22/16 16:11:10:902 SGT] 00000060 SystemOut O [22/08/2016] [16:11:10:902] [ERROR] [IBGenericLoginServices]:527 - Error code : 9999
|
210
|
[8/22/16 16:11:10:902 SGT] 00000060 SystemOut O [22/08/2016] [16:11:10:902] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
|
211
|
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
|
212
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
213
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
|
214
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
|
215
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
|
216
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
|
217
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
|
218
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
|
219
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
|
220
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
|
221
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
|
222
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
|
223
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
|
224
|
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
|
225
|
|
226
|
|
227
|
[8/22/16 16:17:24:036 SGT] 00000060 SystemOut O Socket input data (in Hex): [22/08/2016] [16:17:24:052] [ERROR] [JDBCExceptionReporter]:101 - Transaction (Process ID 99) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
228
|
[8/22/16 16:17:24:052 SGT] 0000006f SystemOut O [22/08/2016] [16:17:24:052] [ERROR] [JDBCExceptionReporter]:101 - Transaction (Process ID 99) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
229
|
[8/22/16 16:17:24:067 SGT] 0000006f SystemOut O [22/08/2016] [16:17:24:067] [ERROR] [IBGenericLoginServices]:527 - Error code : 9999
|
230
|
[8/22/16 16:17:24:067 SGT] 0000006f SystemOut O [22/08/2016] [16:17:24:067] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not retrieve snapshot: [net.penril.ibss.core.hibernate.IbCustAccounts#component[accountNumber,userId]{userId=60191, accountNumber=2007201000094725}]
|
231
|
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
|
232
|
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
|
233
|
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java
|
234
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 99) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
235
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
|
236
|
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4762)
|
237
|
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1682)
|
238
|
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:955)
|
239
|
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:3120)
|
240
|
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1051)
|