Bonjour,

J'utilise la version 5.0.22 de Mysql InnoDB.
Je programme en Java avec le framework Hibernate et Spring.
Apparement, selon les forums Hibernate et Spring, mon problème est au niveau de mysql...
Ecplise affiche dans sa console des erreurs de deadlocks.

Je n'arrive pas à trouver une solution à ce problème.

Pouvez vous m'aider.
Je joins le code de ma table et le texte affiché dans ma console.

Merci d'avance.

Jeff
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
 
 
0 [main] INFO core.CollectionFactory  - JDK 1.4+ collections available
61 [main] INFO xml.XmlBeanDefinitionReader  - Loading XML bean definitions from class path resource [applicationContextGamma.xml]
414 [main] INFO framework.DefaultAopProxyFactory  - CGLIB2 available: proxyTargetClass feature enabled
575 [main] INFO cfg.Environment  - Hibernate 3.1.3
583 [main] INFO cfg.Environment  - hibernate.properties not found
588 [main] INFO cfg.Environment  - using CGLIB reflection optimizer
590 [main] INFO cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
958 [main] INFO cfg.HbmBinder  - Mapping class: com.mauro.personnes.bean.Personne -> personnes
985 [main] INFO hibernate3.LocalSessionFactoryBean  - Building new Hibernate SessionFactory
1102 [main] INFO connection.ConnectionProviderFactory  - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
1471 [main] INFO cfg.SettingsFactory  - RDBMS: MySQL, version: 5.0.22-Debian_0ubuntu6.06-log
1472 [main] INFO cfg.SettingsFactory  - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.3 ( $Date: 2006-07-26 17:26:47 +0200 (Wed, 26 Jul 2006) $, $Revision: 5553 $ )
1590 [main] INFO dialect.Dialect  - Using dialect: org.hibernate.dialect.MySQLDialect
1598 [main] INFO transaction.TransactionFactoryFactory  - Using default transaction strategy (direct JDBC transactions)
1603 [main] INFO transaction.TransactionManagerLookupFactory  - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1603 [main] INFO cfg.SettingsFactory  - Automatic flush during beforeCompletion(): disabled
1603 [main] INFO cfg.SettingsFactory  - Automatic session close at end of transaction: disabled
1604 [main] INFO cfg.SettingsFactory  - JDBC batch size: 15
1604 [main] INFO cfg.SettingsFactory  - JDBC batch updates for versioned data: disabled
1605 [main] INFO cfg.SettingsFactory  - Scrollable result sets: enabled
1605 [main] INFO cfg.SettingsFactory  - JDBC3 getGeneratedKeys(): enabled
1605 [main] INFO cfg.SettingsFactory  - Connection release mode: on_close
1606 [main] INFO cfg.SettingsFactory  - Maximum outer join fetch depth: 2
1606 [main] INFO cfg.SettingsFactory  - Default batch fetch size: 1
1606 [main] INFO cfg.SettingsFactory  - Generate SQL with comments: disabled
1606 [main] INFO cfg.SettingsFactory  - Order SQL updates by primary key: disabled
1606 [main] INFO cfg.SettingsFactory  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1610 [main] INFO ast.ASTQueryTranslatorFactory  - Using ASTQueryTranslatorFactory
1610 [main] INFO cfg.SettingsFactory  - Query language substitutions: {}
1610 [main] INFO cfg.SettingsFactory  - Second-level cache: enabled
1610 [main] INFO cfg.SettingsFactory  - Query cache: disabled
1610 [main] INFO cfg.SettingsFactory  - Cache provider: org.hibernate.cache.EhCacheProvider
1621 [main] INFO cfg.SettingsFactory  - Optimize cache for minimal puts: disabled
1621 [main] INFO cfg.SettingsFactory  - Structured second-level cache entries: disabled
1631 [main] INFO cfg.SettingsFactory  - Statistics: disabled
1631 [main] INFO cfg.SettingsFactory  - Deleted entity synthetic identifier rollback: disabled
1631 [main] INFO cfg.SettingsFactory  - Default entity-mode: pojo
1695 [main] INFO impl.SessionFactoryImpl  - building session factory
1723 [main] WARN config.Configurator  - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/usr/lib/hibernate-3.1/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
2136 [main] INFO impl.SessionFactoryObjectFactory  - Not binding factory to JNDI, no JNDI name configured
2208 [main] INFO hibernate3.HibernateTransactionManager  - Using DataSource [org.apache.commons.dbcp.BasicDataSource@1f4cbee] of Hibernate SessionFactory for HibernateTransactionManager
2311 [main] INFO datasource.JdbcTransactionObjectSupport  - JDBC 3.0 Savepoint class is available
2449 [main] INFO xml.XmlBeanDefinitionReader  - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2515 [main] INFO support.SQLErrorCodesFactory  - SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
thread n° 0 [1155807472901] : lancé
thread n° 1 [1155807472922] : lancé
thread n° 0 [1155807472961] : 0 -> 1 pour la version 1
thread n° 0 [1155807472962] : début attente
thread n° 3 [1155807472962] : lancé
thread n° 3 [1155807472966] : 0 -> 1 pour la version 1
thread n° 4 [1155807472967] : lancé
thread n° 5 [1155807472970] : lancé
thread n° 2 [1155807472970] : lancé
thread n° 6 [1155807472971] : lancé
thread n° 7 [1155807472972] : lancé
thread n° 8 [1155807472972] : lancé
thread n° 9 [1155807472973] : lancé
thread n° 0 [1155807473021] : fin attente
thread n° 3 [1155807472967] : début attente
thread n° 4 [1155807473024] : 0 -> 1 pour la version 1
thread n° 4 [1155807473024] : début attente
thread n° 1 [1155807473028] : 0 -> 1 pour la version 1
thread n° 1 [1155807473028] : début attente
thread n° 6 [1155807473032] : 0 -> 1 pour la version 1
thread n° 6 [1155807473032] : début attente
thread n° 9 [1155807473100] : 0 -> 1 pour la version 1
thread n° 9 [1155807473101] : début attente
thread n° 3 [1155807473101] : fin attente
thread n° 4 [1155807473106] : fin attente
thread n° 1 [1155807473111] : fin attente
2911 [Thread-8] WARN util.JDBCExceptionReporter  - SQL Error: 1213, SQLState: 40001
2911 [Thread-8] ERROR util.JDBCExceptionReporter  - Deadlock found when trying to get lock; try restarting transaction
thread n° 6 [1155807473173] : fin attente
2923 [Thread-8] ERROR def.AbstractFlushingEventListener  - Could not synchronize database state with session
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
	at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:815)
	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
	at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:813)
	at com.mauro.personnes.DAO.DaoImplCommon.updatePersonne(DaoImplCommon.java:105)
	at com.mauro.personnes.DAO.DaoImplCommon.saveOne(DaoImplCommon.java:57)
	at com.mauro.personnes.services.ServiceImpl.saveOne(ServiceImpl.java:34)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
	at $Proxy1.saveOne(Unknown Source)
	at com.mauro.personnes.tests.ThreadServiceMajEnfants.run(ThreadServiceMajEnfants.java:65)
Caused by: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
	at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:657)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
	... 23 more
Exception in thread "Thread-8" org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: Could not execute JDBC batch update; SQL [update personnes set VERSION=?, NOM=?, PRENOM=?, DATENAISSANCE=?, MARIE=?, NBENFANTS=? where ID=?]; Deadlock found when trying to get lock; try restarting transaction; nested exception is java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
	at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:657)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
	at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:815)
	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
	at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:813)
	at com.mauro.personnes.DAO.DaoImplCommon.updatePersonne(DaoImplCommon.java:105)
	at com.mauro.personnes.DAO.DaoImplCommon.saveOne(DaoImplCommon.java:57)
	at com.mauro.personnes.services.ServiceImpl.saveOne(ServiceImpl.java:34)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
	at $Proxy1.saveOne(Unknown Source)
	at com.mauro.personnes.tests.ThreadServiceMajEnfants.run(ThreadServiceMajEnfants.java:65)
thread n° 9 [1155807473195] : fin attente
2945 [Thread-4] WARN util.JDBCExceptionReporter  - SQL Error: 1213, SQLState: 40001
2945 [Thread-4] ERROR util.JDBCExceptionReporter  - Deadlock found when trying to get lock; try restarting transaction
2945 [Thread-4] ERROR def.AbstractFlushingEventListener  - Could not synchronize database state with session
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
	at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:815)
	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
	at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:813)
	at com.mauro.personnes.DAO.DaoImplCommon.updatePersonne(DaoImplCommon.java:105)
	at com.mauro.personnes.DAO.DaoImplCommon.saveOne(DaoImplCommon.java:57)
	at com.mauro.personnes.services.ServiceImpl.saveOne(ServiceImpl.java:34)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
	at $Proxy1.saveOne(Unknown Source)
	at com.mauro.personnes.tests.ThreadServiceMajEnfants.run(ThreadServiceMajEnfants.java:65)
Caused by: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
	at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:657)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
	... 23 more
Exception in thread "Thread-4" org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: Could not execute JDBC batch update; SQL [update personnes set VERSION=?, NOM=?, PRENOM=?, DATENAISSANCE=?, MARIE=?, NBENFANTS=? where ID=?]; Deadlock found when trying to get lock; try restarting transaction; nested exception is java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
	at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:657)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
	at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:815)
	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
	at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:813)
	at com.mauro.personnes.DAO.DaoImplCommon.updatePersonne(DaoImplCommon.java:105)
	at com.mauro.personnes.DAO.DaoImplCommon.saveOne(DaoImplCommon.java:57)
	at com.mauro.personnes.services.ServiceImpl.saveOne(ServiceImpl.java:34)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
	at $Proxy1.saveOne(Unknown Source)
	at com.mauro.personnes.tests.ThreadServiceMajEnfants.run(ThreadServiceMajEnfants.java:65)
thread n° 3 [1155807473215] : a terminé et passé le nombre d'enfants à 1
thread n° 9 [1155807473241] : version corrompue ou personne inexistante
thread n° 6 [1155807473252] : version corrompue ou personne inexistante
thread n° 6 [1155807473256] : 1 -> 2 pour la version 2
thread n° 6 [1155807473256] : début attente
thread n° 9 [1155807473257] : 1 -> 2 pour la version 2
thread n° 9 [1155807473257] : début attente
thread n° 6 [1155807473307] : fin attente
thread n° 9 [1155807473314] : fin attente
thread n° 9 [1155807473320] : version corrompue ou personne inexistante
thread n° 6 [1155807473444] : a terminé et passé le nombre d'enfants à 2
thread n° 9 [1155807473444] : 2 -> 3 pour la version 3
thread n° 9 [1155807473444] : début attente
thread n° 9 [1155807473455] : fin attente
thread n° 9 [1155807473479] : a terminé et passé le nombre d'enfants à 3
thread n° 8 [1155807473488] : 3 -> 4 pour la version 4
thread n° 8 [1155807473488] : début attente
thread n° 8 [1155807473504] : fin attente
thread n° 7 [1155807473521] : 3 -> 4 pour la version 4
thread n° 7 [1155807473521] : début attente
thread n° 7 [1155807473531] : fin attente
thread n° 2 [1155807473542] : 3 -> 4 pour la version 4
thread n° 2 [1155807473542] : début attente
thread n° 8 [1155807473543] : a terminé et passé le nombre d'enfants à 4
thread n° 7 [1155807473544] : version corrompue ou personne inexistante
thread n° 2 [1155807473553] : fin attente
thread n° 7 [1155807473560] : 4 -> 5 pour la version 5
thread n° 7 [1155807473560] : début attente
thread n° 2 [1155807473564] : version corrompue ou personne inexistante
thread n° 2 [1155807473567] : 4 -> 5 pour la version 5
thread n° 2 [1155807473567] : début attente
thread n° 7 [1155807473570] : fin attente
thread n° 2 [1155807473579] : fin attente
thread n° 7 [1155807473583] : a terminé et passé le nombre d'enfants à 5
thread n° 2 [1155807473585] : version corrompue ou personne inexistante
thread n° 2 [1155807473590] : 5 -> 6 pour la version 6
thread n° 2 [1155807473590] : début attente
thread n° 0 [1155807473591] : version corrompue ou personne inexistante
thread n° 0 [1155807473594] : 5 -> 6 pour la version 6
thread n° 0 [1155807473594] : début attente
thread n° 2 [1155807473600] : fin attente
thread n° 0 [1155807473610] : fin attente
thread n° 2 [1155807473613] : a terminé et passé le nombre d'enfants à 6
thread n° 0 [1155807473616] : version corrompue ou personne inexistante
thread n° 0 [1155807473628] : 6 -> 7 pour la version 7
thread n° 0 [1155807473628] : début attente
thread n° 5 [1155807473637] : 6 -> 7 pour la version 7
thread n° 5 [1155807473637] : début attente
thread n° 0 [1155807473639] : fin attente
thread n° 0 [1155807473647] : a terminé et passé le nombre d'enfants à 7
thread n° 5 [1155807473648] : fin attente
thread n° 5 [1155807473652] : version corrompue ou personne inexistante
thread n° 5 [1155807473655] : 7 -> 8 pour la version 8
thread n° 5 [1155807473655] : début attente
thread n° 5 [1155807473665] : fin attente
thread n° 5 [1155807473697] : a terminé et passé le nombre d'enfants à 8
8
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
 
CREATE TABLE `personnes` (
  `ID` int(11) NOT NULL,
  `VERSION` bigint(20) default NULL,
  `NOM` varchar(50) default NULL,
  `PRENOM` varchar(50) default NULL,
  `DATENAISSANCE` datetime default NULL,
  `MARIE` bit(1) default NULL,
  `NBENFANTS` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;