Here are the requested details. Where are using Isolation Level 1. Our programs are based on jdbc queries, using Hibernate O/R mapping, tomcat and dbcp connection pooling.
I've got some trace with a whole example with all statements made by both sessions involved in deadlock. If it can help, I can send it directly (it seems to be too big for the list).
Philippe
POSTE AVEC SESSION SESSION = 265170 2004-04-30 14:02:57,124 DEBUG [http8080-Processor4] persistence.CGLIBPersistenceHandler (CGLIBPersistenceHandler.java:109) - Executing with transaction: fr.infologic.superviseur.services.mvtmanager.impl.MouvementManagerServiceImpl.registerPickingMouvement 2004-04-30 14:02:57,134 DEBUG [http8080-Processor4] hibernate.SQL (BatcherImpl.java:223) - select ik, noDosCre, noDosRes, noSocCom, code, noCliLiv, noCliCde, datCde, datDepart, hDepart, datLimiteRecept as datLimi11_, datLiv, datPrep, heurePrep, ordreLiv, refCLi, typCde, rayon, LivNom, LivAdrNormalisee as LivAdrN20_, LivAdresse, LivComplementAdresse as LivComp22_, LivCodeInsee as LivCode23_, LivCodePostal as LivCode24_, LivVille, noLivPays, LivLibPays, LivTel, LivFax, LivEmail, LivSiteWEB, LivLieuFonct as LivLieu32_, comment, refTelev, noTra, noPremDegroup as noPremD36_, txtLibre, flagBonPrep as flagBon38_, flagManq, flagSolde, flagModif, flagAnnule, flagGesCo, flagCommence as flagCom44_, flagCtrlPal as flagCtr45_, flagPicking as flagPic46_, flagGesCoUrgent as flagGes47_, cumulCde, cumulRAL, nbrColis, datSolde, datImportation as datImpo52_, anteriorite as anterio53_, codeGroupAnt as codeGro54_, datCre, datMod, etat, origine, flagHistorise as flagHis59_, flagAEpurer as flagAEp60_ from SV_Commande where ik =? for update 2004-04-30 14:02:57,134 INFO [http8080-Processor4] jdbc.CallableStatementSapDB (CallableStatementSapDB.java:326) - SESSION = 265170 2004-04-30 14:02:57,414 DEBUG [http8080-Processor4] hibernate.SQL (BatcherImpl.java:223) - select fract0_.ik as ik0_, fract0_.noDosCre as noDosCre0_, fract0_.noDosRes as noDosRes0_, fract0_.code as code0_, fract0_.noCde as noCde0_, fract0_.noCdeLig as noCdeLig0_, fract0_.comFractExpe as comFract7_0_, fract0_.noEmb as noEmb0_, fract0_.pCB as pCB0_, fract0_.qtePrep as qtePrep0_, fract0_.cumManq as cumManq0_, fract0_.cumPrep as cumPrep0_, fract0_.noUnitPrep as noUnitPrep0_, fract0_.cumManqP as cumManqP0_, fract0_.modePrep as modePrep0_, fract0_.noMotifSolde as noMotif16_0_, fract0_.noFilePrep as noFilePrep0_, fract0_.noTypPrepLot as noTypPr18_0_, fract0_.noTypPrepAcqui as noTypPr19_0_, fract0_.noTypPrepPiece as noTypPr20_0_, fract0_.modeAcces as modeAcces0_, fract0_.typFract as typFract0_, fract0_.flagBonPrep as flagBon23_0_, fract0_.flagEtiq as flagEtiq0_, fract0_.flagManq as flagManq0_, fract0_.flagSolde as flagSolde0_, fract0_.flagModif as flagModif0_, fract0_.flagFGesCo as flagFGesCo0_, fract0_.flagCtrlPal as flagCtr29_0_, fract0_.flagPicking as flagPic30_0_, fract0_.noFilePrepReport as noFileP31_0_, fract0_.noRouleauPiece as noRoule32_0_, fract0_.noMaquette as noMaquette0_, fract0_.pxPVC as pxPVC0_, fract0_.noMonPVC as noMonPVC0_, fract0_.noMonCompostage as noMonCo36_0_, fract0_.ReelNbColis as ReelNbC37_0_, fract0_.ReelPds as ReelPds0_, fract0_.ReelNbPiece as ReelNbP39_0_, fract0_.ReelNbUE as ReelNbUE0_, fract0_.PickingNbColis as Picking41_0_, fract0_.PickingPds as PickingPds0_, fract0_.PickingNbPiece as Picking43_0_, fract0_.PickingNbUE as Picking44_0_, fract0_.noLibEtiq as noLibEtiq0_, fract0_.noUnitPicking as noUnitP46_0_, fract0_.noMethodePrep as noMetho47_0_, fract0_.noEnsemblePalettisation as noEnsem48_0_, fract0_.noReglage as noReglage0_, fract0_.datCre as datCre0_, fract0_.datMod as datMod0_, fract0_.etat as etat0_, fract0_.origine as origine0_, fract0_.flagHistorise as flagHis54_0_, fract0_.flagAEpurer as flagAEp55_0_ from SV_Fract fract0_ where fract0_.ik=? 2004-04-30 14:02:57,414 INFO [http8080-Processor4] jdbc.CallableStatementSapDB (CallableStatementSapDB.java:326) - SESSION = 265170 2004-04-30 14:02:57,434 DEBUG [http8080-Processor4] hibernate.SQL (BatcherImpl.java:223) - select typcommand0_.ik as ik0_, typcommand0_.noDosCre as noDosCre0_, typcommand0_.noDosRes as noDosRes0_, typcommand0_.code as code0_, typcommand0_.lib as lib0_, typcommand0_.typCde as typCde0_, typcommand0_.selec as selec0_, typcommand0_.selecDatPrep as selecDat8_0_, typcommand0_.manquantPrep as manquant9_0_, typcommand0_.noMotif as noMotif0_, typcommand0_.surplusPrep as surplus11_0_, typcommand0_.annulULflagCtrl as annulUL12_0_, typcommand0_.ctrlPalette as ctrlPal13_0_, typcommand0_.retourGesCo as retourG14_0_, typcommand0_.delaiGesCo as delaiGesCo0_, typcommand0_.nivRetourGesCo as nivReto16_0_, typcommand0_.creationXml as creatio17_0_, typcommand0_.histoMvt as histoMvt0_, typcommand0_.noCompteur as noCompteur0_, typcommand0_.noCriterePal as noCrite20_0_, typcommand0_.delaiGesCoDepart as delaiGe21_0_, typcommand0_.delaiHeureLimite as delaiHe22_0_, typcommand0_.noFormatCodeTrieurPalette as noForma23_0_, typcommand0_.datCre as datCre0_, typcommand0_.datMod as datMod0_, typcommand0_.etat as etat0_, typcommand0_.origine as origine0_ from SV_TypCommande typcommand0_ where typcommand0_.ik=? 2004-04-30 14:02:57,434 INFO [http8080-Processor4] jdbc.CallableStatementSapDB (CallableStatementSapDB.java:326) - SESSION = 265170 2004-04-30 14:02:57,434 DEBUG [http8080-Processor4] hibernate.SQL (BatcherImpl.java:223) - select unite0_.ik as ik0_, unite0_.noDosCre as noDosCre0_, unite0_.noDosRes as noDosRes0_, unite0_.code as code0_, unite0_.libStd as libStd0_, unite0_.libCourt as libCourt0_, unite0_.libAbreg as libAbreg0_, unite0_.typUnite as typUnite0_, unite0_.datCre as datCre0_, unite0_.datMod as datMod0_, unite0_.etat as etat0_, unite0_.origine as origine0_ from SV_Unite unite0_ where unite0_.ik=? 2004-04-30 14:02:57,444 INFO [http8080-Processor4] jdbc.CallableStatementSapDB (CallableStatementSapDB.java:326) - SESSION = 265170 2004-04-30 14:02:57,444 DEBUG [http8080-Processor4] hibernate.SQL (BatcherImpl.java:223) - select unite0_.ik as ik0_, unite0_.noDosCre as noDosCre0_, unite0_.noDosRes as noDosRes0_, unite0_.code as code0_, unite0_.libStd as libStd0_, unite0_.libCourt as libCourt0_, unite0_.libAbreg as libAbreg0_, unite0_.typUnite as typUnite0_, unite0_.datCre as datCre0_, unite0_.datMod as datMod0_, unite0_.etat as etat0_, unite0_.origine as origine0_ from SV_Unite unite0_ where unite0_.ik=? 2004-04-30 14:02:57,444 INFO [http8080-Processor4] jdbc.CallableStatementSapDB (CallableStatementSapDB.java:326) - SESSION = 265170 2004-04-30 14:02:57,454 DEBUG [http8080-Processor4] persistence.DefaultPersistenceContext (DefaultPersistenceContext.java:102) - Committing hibernate transaction 2004-04-30 14:02:57,464 DEBUG [http8080-Processor4] hibernate.SQL (BatcherImpl.java:223) - insert into SV_Mouvement (noDosCre, noDosRes, noFract, code, noCde, noCdeLig, datExped, datFab, datPrep, datPrepSaisie, lot, noArt, noEmb, noUtilisateur, noPoste, noProd, qteUL, noUnitPrep, pdsBrut, pdsNetReel, noUnitLogis, numPesee, noMotifSolde, noSite, flagTransmis, flagAnnule, flagConsomme, qteUC, pdsNetLivre, comment, pCB, noCalibre, typMvt, typManquant, noRouleauPiece, noMaquette, tare, pdsEnleve, noContenant, datCre, datMod, etat, origine, flagHistorise, flagAEpurer, ik) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2004-04-30 14:02:57,474 INFO [http8080-Processor4] jdbc.CallableStatementSapDB (CallableStatementSapDB.java:326) - SESSION = 265170 2004-04-30 14:02:57,484 DEBUG [http8080-Processor4] hibernate.SQL (BatcherImpl.java:223) - update SV_Fract set noDosCre=?, noDosRes=?, code=?, noCde=?, noCdeLig=?, comFractExpe=?, noEmb=?, pCB=?, qtePrep=?, cumManq=?, cumPrep=?, noUnitPrep=?, cumManqP=?, modePrep=?, noMotifSolde=?, noFilePrep=?, noTypPrepLot=?, noTypPrepAcqui=?, noTypPrepPiece=?, modeAcces=?, typFract=?, flagBonPrep=?, flagEtiq=?, flagManq=?, flagSolde=?, flagModif=?, flagFGesCo=?, flagCtrlPal=?, flagPicking=?, noFilePrepReport=?, noRouleauPiece=?, noMaquette=?, pxPVC=?, noMonPVC=?, noMonCompostage=?, ReelNbColis=?, ReelPds=?, ReelNbPiece=?, ReelNbUE=?, PickingNbColis=?, PickingPds=?, PickingNbPiece=?, PickingNbUE=?, noLibEtiq=?, noUnitPicking=?, noMethodePrep=?, noEnsemblePalettisation=?, noReglage=?, datCre=?, datMod=?, etat=?, origine=?, flagHistorise=?, flagAEpurer=? where ik=? 2004-04-30 14:02:57,484 INFO [http8080-Processor4] jdbc.CallableStatementSapDB (CallableStatementSapDB.java:326) - SESSION = 265170
POSTE AVEC SESSION SESSION = 265168
2004-04-30 14:02:55,762 DEBUG [http8080-Processor8]
persistence.CGLIBPersistenceHandler (CGLIBPersistenceHandler.java:63) - Executing
without transaction:
fr.infologic.superviseur.services.modifile.impl.ModiFileChangeServiceImpl.changeFile
2004-04-30 14:02:55,772 DEBUG [http8080-Processor8]
persistence.DefaultPersistenceContext (DefaultPersistenceContext.java:35) -
Opening hibernate session
2004-04-30 14:02:55,852 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(StatementSapDB.java:352) - SESSION = 265168
2004-04-30 14:02:55,872 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select x.ik as ik, x.noDosCre as noDosCre, x.noDosRes as
noDosRes, x.code as code, x.lib as lib, x.nbPers as nbPers, x.noSite as noSite,
x.noLieu as noLieu, x.noContenant as noConten9_, x.codeOuv as codeOuv,
x.noTrieurEntree as noTrieu11_, x.noTrieurSortie as noTrieu12_, x.datCre as datCre,
x.datMod as datMod, x.etat as etat, x.origine as origine from SV_Poste x where (?
in(select fileprep0_.filePrep from SV_Poste_FilePrep fileprep0_ where
x.ik=fileprep0_.noPoste))and(x.noDosRes=? )
2004-04-30 14:02:55,872 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:55,942 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select fileprep0_.ik as ik0_, fileprep0_.noDosCre as
noDosCre0_, fileprep0_.noDosRes as noDosRes0_, fileprep0_.code as code0_,
fileprep0_.codeOuv as codeOuv0_, fileprep0_.lib as lib0_, fileprep0_.typeFile as
typeFile0_, fileprep0_.noFileReport as noFileRe8_0_, fileprep0_.noScenarioFileCde as
noScenar9_0_, fileprep0_.noScenarioFileArt as noScena10_0_,
fileprep0_.filtreEnsemblePalette as filtreE11_0_, fileprep0_.datCre as datCre0_,
fileprep0_.datMod as datMod0_, fileprep0_.etat as etat0_, fileprep0_.origine as
origine0_ from SV_FilePrep fileprep0_ where fileprep0_.ik=?
2004-04-30 14:02:55,952 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,072 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select fract0_.ik as ik, fract0_.noDosCre as noDosCre,
fract0_.noDosRes as noDosRes, fract0_.code as code, fract0_.noCde as noCde,
fract0_.noCdeLig as noCdeLig, fract0_.comFractExpe as comFract7_, fract0_.noEmb as
noEmb, fract0_.pCB as pCB, fract0_.qtePrep as qtePrep, fract0_.cumManq as cumManq,
fract0_.cumPrep as cumPrep, fract0_.noUnitPrep as noUnitPrep, fract0_.cumManqP as
cumManqP, fract0_.modePrep as modePrep, fract0_.noMotifSolde as noMotif16_,
fract0_.noFilePrep as noFilePrep, fract0_.noTypPrepLot as noTypPr18_,
fract0_.noTypPrepAcqui as noTypPr19_, fract0_.noTypPrepPiece as noTypPr20_,
fract0_.modeAcces as modeAcces, fract0_.typFract as typFract, fract0_.flagBonPrep as
flagBon23_, fract0_.flagEtiq as flagEtiq, fract0_.flagManq as flagManq,
fract0_.flagSolde as flagSolde, fract0_.flagModif as flagModif, fract0_.flagFGesCo as
flagFGesCo, fract0_.flagCtrlPal as flagCtr29_, fract0_.flagPicking as flagPic30_,
fract0_.noFilePrepReport as noFileP31_, fract0_.noRouleauPiece as noRoule32_,
fract0_.noMaquette as noMaquette, fract0_.pxPVC as pxPVC, fract0_.noMonPVC as
noMonPVC, fract0_.noMonCompostage as noMonCo36_, fract0_.ReelNbColis as ReelNbC37_,
fract0_.ReelPds as ReelPds, fract0_.ReelNbPiece as ReelNbP39_, fract0_.ReelNbUE as
ReelNbUE, fract0_.PickingNbColis as Picking41_, fract0_.PickingPds as PickingPds,
fract0_.PickingNbPiece as Picking43_, fract0_.PickingNbUE as Picking44_,
fract0_.noLibEtiq as noLibEtiq, fract0_.noUnitPicking as noUnitP46_,
fract0_.noMethodePrep as noMetho47_, fract0_.noEnsemblePalettisation as noEnsem48_,
fract0_.noReglage as noReglage, fract0_.datCre as datCre, fract0_.datMod as datMod,
fract0_.etat as etat, fract0_.origine as origine, fract0_.flagHistorise as flagHis54_,
fract0_.flagAEpurer as flagAEp55_ from SV_Fract fract0_ where (fract0_.ik in(? , ? , ?
, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))
2004-04-30 14:02:56,082 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,152 DEBUG [http8080-Processor8]
persistence.CGLIBPersistenceHandler (CGLIBPersistenceHandler.java:109) - Executing
with transaction:
fr.infologic.superviseur.services.modifile.impl.ModiFileChangeServiceImpl.doChangeFile
2004-04-30 14:02:56,162 DEBUG [http8080-Processor8]
persistence.DefaultPersistenceContext (DefaultPersistenceContext.java:80) -
Starting hibernate transaction
2004-04-30 14:02:56,172 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select cdelig0_.noCde as x0_0_ from SV_CdeLig cdelig0_
where (cdelig0_.ik=? )and(cdelig0_.noDosRes=? )
2004-04-30 14:02:56,182 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,202 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select ik, noDosCre, noDosRes, noSocCom, code, noCliLiv,
noCliCde, datCde, datDepart, hDepart, datLimiteRecept as datLimi11_, datLiv, datPrep,
heurePrep, ordreLiv, refCLi, typCde, rayon, LivNom, LivAdrNormalisee as LivAdrN20_,
LivAdresse, LivComplementAdresse as LivComp22_, LivCodeInsee as LivCode23_,
LivCodePostal as LivCode24_, LivVille, noLivPays, LivLibPays, LivTel, LivFax,
LivEmail, LivSiteWEB, LivLieuFonct as LivLieu32_, comment, refTelev, noTra,
noPremDegroup as noPremD36_, txtLibre, flagBonPrep as flagBon38_, flagManq, flagSolde,
flagModif, flagAnnule, flagGesCo, flagCommence as flagCom44_, flagCtrlPal as
flagCtr45_, flagPicking as flagPic46_, flagGesCoUrgent as flagGes47_, cumulCde,
cumulRAL, nbrColis, datSolde, datImportation as datImpo52_, anteriorite as anterio53_,
codeGroupAnt as codeGro54_, datCre, datMod, etat, origine, flagHistorise as
flagHis59_, flagAEpurer as flagAEp60_ from SV_Commande where ik =? for update
2004-04-30 14:02:56,212 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,222 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select fract0_.ik as ik0_, fract0_.noDosCre as
noDosCre0_, fract0_.noDosRes as noDosRes0_, fract0_.code as code0_, fract0_.noCde as
noCde0_, fract0_.noCdeLig as noCdeLig0_, fract0_.comFractExpe as comFract7_0_,
fract0_.noEmb as noEmb0_, fract0_.pCB as pCB0_, fract0_.qtePrep as qtePrep0_,
fract0_.cumManq as cumManq0_, fract0_.cumPrep as cumPrep0_, fract0_.noUnitPrep as
noUnitPrep0_, fract0_.cumManqP as cumManqP0_, fract0_.modePrep as modePrep0_,
fract0_.noMotifSolde as noMotif16_0_, fract0_.noFilePrep as noFilePrep0_,
fract0_.noTypPrepLot as noTypPr18_0_, fract0_.noTypPrepAcqui as noTypPr19_0_,
fract0_.noTypPrepPiece as noTypPr20_0_, fract0_.modeAcces as modeAcces0_,
fract0_.typFract as typFract0_, fract0_.flagBonPrep as flagBon23_0_, fract0_.flagEtiq
as flagEtiq0_, fract0_.flagManq as flagManq0_, fract0_.flagSolde as flagSolde0_,
fract0_.flagModif as flagModif0_, fract0_.flagFGesCo as flagFGesCo0_,
fract0_.flagCtrlPal as flagCtr29_0_, fract0_.flagPicking as flagPic30_0_,
fract0_.noFilePrepReport as noFileP31_0_, fract0_.noRouleauPiece as noRoule32_0_,
fract0_.noMaquette as noMaquette0_, fract0_.pxPVC as pxPVC0_, fract0_.noMonPVC as
noMonPVC0_, fract0_.noMonCompostage as noMonCo36_0_, fract0_.ReelNbColis as
ReelNbC37_0_, fract0_.ReelPds as ReelPds0_, fract0_.ReelNbPiece as ReelNbP39_0_,
fract0_.ReelNbUE as ReelNbUE0_, fract0_.PickingNbColis as Picking41_0_,
fract0_.PickingPds as PickingPds0_, fract0_.PickingNbPiece as Picking43_0_,
fract0_.PickingNbUE as Picking44_0_, fract0_.noLibEtiq as noLibEtiq0_,
fract0_.noUnitPicking as noUnitP46_0_, fract0_.noMethodePrep as noMetho47_0_,
fract0_.noEnsemblePalettisation as noEnsem48_0_, fract0_.noReglage as noReglage0_,
fract0_.datCre as datCre0_, fract0_.datMod as datMod0_, fract0_.etat as etat0_,
fract0_.origine as origine0_, fract0_.flagHistorise as flagHis54_0_,
fract0_.flagAEpurer as flagAEp55_0_ from SV_Fract fract0_ where fract0_.ik=?
2004-04-30 14:02:56,232 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,232 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select mouvement0_.ik as x0_0_ from SV_Mouvement
mouvement0_ where (mouvement0_.typMvt=? )and(mouvement0_.noFract=?
)and(mouvement0_.flagConsomme=? )and(mouvement0_.flagAnnule=?
)and(mouvement0_.noDosRes=? )
2004-04-30 14:02:56,243 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,763 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select cdelig0_.noCde as x0_0_ from SV_CdeLig cdelig0_
where (cdelig0_.ik=? )and(cdelig0_.noDosRes=? )
2004-04-30 14:02:56,763 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,853 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select ik, noDosCre, noDosRes, noSocCom, code, noCliLiv,
noCliCde, datCde, datDepart, hDepart, datLimiteRecept as datLimi11_, datLiv, datPrep,
heurePrep, ordreLiv, refCLi, typCde, rayon, LivNom, LivAdrNormalisee as LivAdrN20_,
LivAdresse, LivComplementAdresse as LivComp22_, LivCodeInsee as LivCode23_,
LivCodePostal as LivCode24_, LivVille, noLivPays, LivLibPays, LivTel, LivFax,
LivEmail, LivSiteWEB, LivLieuFonct as LivLieu32_, comment, refTelev, noTra,
noPremDegroup as noPremD36_, txtLibre, flagBonPrep as flagBon38_, flagManq, flagSolde,
flagModif, flagAnnule, flagGesCo, flagCommence as flagCom44_, flagCtrlPal as
flagCtr45_, flagPicking as flagPic46_, flagGesCoUrgent as flagGes47_, cumulCde,
cumulRAL, nbrColis, datSolde, datImportation as datImpo52_, anteriorite as anterio53_,
codeGroupAnt as codeGro54_, datCre, datMod, etat, origine, flagHistorise as
flagHis59_, flagAEpurer as flagAEp60_ from SV_Commande where ik =? for update
2004-04-30 14:02:56,863 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,873 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select fract0_.ik as ik0_, fract0_.noDosCre as
noDosCre0_, fract0_.noDosRes as noDosRes0_, fract0_.code as code0_, fract0_.noCde as
noCde0_, fract0_.noCdeLig as noCdeLig0_, fract0_.comFractExpe as comFract7_0_,
fract0_.noEmb as noEmb0_, fract0_.pCB as pCB0_, fract0_.qtePrep as qtePrep0_,
fract0_.cumManq as cumManq0_, fract0_.cumPrep as cumPrep0_, fract0_.noUnitPrep as
noUnitPrep0_, fract0_.cumManqP as cumManqP0_, fract0_.modePrep as modePrep0_,
fract0_.noMotifSolde as noMotif16_0_, fract0_.noFilePrep as noFilePrep0_,
fract0_.noTypPrepLot as noTypPr18_0_, fract0_.noTypPrepAcqui as noTypPr19_0_,
fract0_.noTypPrepPiece as noTypPr20_0_, fract0_.modeAcces as modeAcces0_,
fract0_.typFract as typFract0_, fract0_.flagBonPrep as flagBon23_0_, fract0_.flagEtiq
as flagEtiq0_, fract0_.flagManq as flagManq0_, fract0_.flagSolde as flagSolde0_,
fract0_.flagModif as flagModif0_, fract0_.flagFGesCo as flagFGesCo0_,
fract0_.flagCtrlPal as flagCtr29_0_, fract0_.flagPicking as flagPic30_0_,
fract0_.noFilePrepReport as noFileP31_0_, fract0_.noRouleauPiece as noRoule32_0_,
fract0_.noMaquette as noMaquette0_, fract0_.pxPVC as pxPVC0_, fract0_.noMonPVC as
noMonPVC0_, fract0_.noMonCompostage as noMonCo36_0_, fract0_.ReelNbColis as
ReelNbC37_0_, fract0_.ReelPds as ReelPds0_, fract0_.ReelNbPiece as ReelNbP39_0_,
fract0_.ReelNbUE as ReelNbUE0_, fract0_.PickingNbColis as Picking41_0_,
fract0_.PickingPds as PickingPds0_, fract0_.PickingNbPiece as Picking43_0_,
fract0_.PickingNbUE as Picking44_0_, fract0_.noLibEtiq as noLibEtiq0_,
fract0_.noUnitPicking as noUnitP46_0_, fract0_.noMethodePrep as noMetho47_0_,
fract0_.noEnsemblePalettisation as noEnsem48_0_, fract0_.noReglage as noReglage0_,
fract0_.datCre as datCre0_, fract0_.datMod as datMod0_, fract0_.etat as etat0_,
fract0_.origine as origine0_, fract0_.flagHistorise as flagHis54_0_,
fract0_.flagAEpurer as flagAEp55_0_ from SV_Fract fract0_ where fract0_.ik=?
2004-04-30 14:02:56,883 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:56,903 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select mouvement0_.ik as x0_0_ from SV_Mouvement
mouvement0_ where (mouvement0_.typMvt=? )and(mouvement0_.noFract=?
)and(mouvement0_.flagConsomme=? )and(mouvement0_.flagAnnule=?
)and(mouvement0_.noDosRes=? )
2004-04-30 14:02:56,903 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:57,114 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select cdelig0_.noCde as x0_0_ from SV_CdeLig cdelig0_
where (cdelig0_.ik=? )and(cdelig0_.noDosRes=? )
2004-04-30 14:02:57,124 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:57,154 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select ik, noDosCre, noDosRes, noSocCom, code, noCliLiv,
noCliCde, datCde, datDepart, hDepart, datLimiteRecept as datLimi11_, datLiv, datPrep,
heurePrep, ordreLiv, refCLi, typCde, rayon, LivNom, LivAdrNormalisee as LivAdrN20_,
LivAdresse, LivComplementAdresse as LivComp22_, LivCodeInsee as LivCode23_,
LivCodePostal as LivCode24_, LivVille, noLivPays, LivLibPays, LivTel, LivFax,
LivEmail, LivSiteWEB, LivLieuFonct as LivLieu32_, comment, refTelev, noTra,
noPremDegroup as noPremD36_, txtLibre, flagBonPrep as flagBon38_, flagManq, flagSolde,
flagModif, flagAnnule, flagGesCo, flagCommence as flagCom44_, flagCtrlPal as
flagCtr45_, flagPicking as flagPic46_, flagGesCoUrgent as flagGes47_, cumulCde,
cumulRAL, nbrColis, datSolde, datImportation as datImpo52_, anteriorite as anterio53_,
codeGroupAnt as codeGro54_, datCre, datMod, etat, origine, flagHistorise as
flagHis59_, flagAEpurer as flagAEp60_ from SV_Commande where ik =? for update
2004-04-30 14:02:57,154 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:57,154 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select fract0_.ik as ik0_, fract0_.noDosCre as
noDosCre0_, fract0_.noDosRes as noDosRes0_, fract0_.code as code0_, fract0_.noCde as
noCde0_, fract0_.noCdeLig as noCdeLig0_, fract0_.comFractExpe as comFract7_0_,
fract0_.noEmb as noEmb0_, fract0_.pCB as pCB0_, fract0_.qtePrep as qtePrep0_,
fract0_.cumManq as cumManq0_, fract0_.cumPrep as cumPrep0_, fract0_.noUnitPrep as
noUnitPrep0_, fract0_.cumManqP as cumManqP0_, fract0_.modePrep as modePrep0_,
fract0_.noMotifSolde as noMotif16_0_, fract0_.noFilePrep as noFilePrep0_,
fract0_.noTypPrepLot as noTypPr18_0_, fract0_.noTypPrepAcqui as noTypPr19_0_,
fract0_.noTypPrepPiece as noTypPr20_0_, fract0_.modeAcces as modeAcces0_,
fract0_.typFract as typFract0_, fract0_.flagBonPrep as flagBon23_0_, fract0_.flagEtiq
as flagEtiq0_, fract0_.flagManq as flagManq0_, fract0_.flagSolde as flagSolde0_,
fract0_.flagModif as flagModif0_, fract0_.flagFGesCo as flagFGesCo0_,
fract0_.flagCtrlPal as flagCtr29_0_, fract0_.flagPicking as flagPic30_0_,
fract0_.noFilePrepReport as noFileP31_0_, fract0_.noRouleauPiece as noRoule32_0_,
fract0_.noMaquette as noMaquette0_, fract0_.pxPVC as pxPVC0_, fract0_.noMonPVC as
noMonPVC0_, fract0_.noMonCompostage as noMonCo36_0_, fract0_.ReelNbColis as
ReelNbC37_0_, fract0_.ReelPds as ReelPds0_, fract0_.ReelNbPiece as ReelNbP39_0_,
fract0_.ReelNbUE as ReelNbUE0_, fract0_.PickingNbColis as Picking41_0_,
fract0_.PickingPds as PickingPds0_, fract0_.PickingNbPiece as Picking43_0_,
fract0_.PickingNbUE as Picking44_0_, fract0_.noLibEtiq as noLibEtiq0_,
fract0_.noUnitPicking as noUnitP46_0_, fract0_.noMethodePrep as noMetho47_0_,
fract0_.noEnsemblePalettisation as noEnsem48_0_, fract0_.noReglage as noReglage0_,
fract0_.datCre as datCre0_, fract0_.datMod as datMod0_, fract0_.etat as etat0_,
fract0_.origine as origine0_, fract0_.flagHistorise as flagHis54_0_,
fract0_.flagAEpurer as flagAEp55_0_ from SV_Fract fract0_ where fract0_.ik=?
2004-04-30 14:02:57,154 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:57,164 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select mouvement0_.ik as x0_0_ from SV_Mouvement
mouvement0_ where (mouvement0_.typMvt=? )and(mouvement0_.noFract=?
)and(mouvement0_.flagConsomme=? )and(mouvement0_.flagAnnule=?
)and(mouvement0_.noDosRes=? )
2004-04-30 14:02:57,164 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:57,364 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select cdelig0_.noCde as x0_0_ from SV_CdeLig cdelig0_
where (cdelig0_.ik=? )and(cdelig0_.noDosRes=? )
2004-04-30 14:02:57,364 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
2004-04-30 14:02:57,364 DEBUG [http8080-Processor8] hibernate.SQL
(BatcherImpl.java:223) - select ik, noDosCre, noDosRes, noSocCom, code, noCliLiv,
noCliCde, datCde, datDepart, hDepart, datLimiteRecept as datLimi11_, datLiv, datPrep,
heurePrep, ordreLiv, refCLi, typCde, rayon, LivNom, LivAdrNormalisee as LivAdrN20_,
LivAdresse, LivComplementAdresse as LivComp22_, LivCodeInsee as LivCode23_,
LivCodePostal as LivCode24_, LivVille, noLivPays, LivLibPays, LivTel, LivFax,
LivEmail, LivSiteWEB, LivLieuFonct as LivLieu32_, comment, refTelev, noTra,
noPremDegroup as noPremD36_, txtLibre, flagBonPrep as flagBon38_, flagManq, flagSolde,
flagModif, flagAnnule, flagGesCo, flagCommence as flagCom44_, flagCtrlPal as
flagCtr45_, flagPicking as flagPic46_, flagGesCoUrgent as flagGes47_, cumulCde,
cumulRAL, nbrColis, datSolde, datImportation as datImpo52_, anteriorite as anterio53_,
codeGroupAnt as codeGro54_, datCre, datMod, etat, origine, flagHistorise as
flagHis59_, flagAEpurer as flagAEp60_ from SV_Commande where ik =? for update
2004-04-30 14:02:57,374 INFO [http8080-Processor8] jdbc.CallableStatementSapDB
(CallableStatementSapDB.java:326) - SESSION = 265168
L� on a un dead lock...
select * from lock_holder
SESSION TRANSCOUNT PROCESS USERNAME DATE TIME TERMID LASTWRITE
LOCKMODE LOCKSTATE APPLPROCESS APPLNODE OWNER TABLENAME
TABLEID ROWIDLENGTH ROWIDHEX ROWID
265168 151747 38 PCRM 2004-04-30 13:48:44 main
? row_share ? 0 10.0.3.94 PCRM SV_FRACT
00000000000007FD 7
00C91761280020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
265168 151747 38 PCRM 2004-04-30 13:48:44 main
? row_exclusive ? 0 10.0.3.94 PCRM SV_COMMANDE
0000000000000ADE 7
00C91722941450000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
265170 151755 39 PCRM 2004-04-30 13:50:32
Processor2 1860 row_exclusive ? 0 10.0.3.94 PCRM
SV_COMMANDE 0000000000000ADE 7
00C91760624650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
265170 151755 39 PCRM 2004-04-30 13:50:32
Processor2 1860 row_exclusive write 0 10.0.3.94 PCRM
SV_MOUVEMENT 0000000000000AEA 7
00C91766196140000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
select * from lock_requestor
SESSION TRANSCOUNT PROCESS USERNAME DATE TIME TERMID REQTIMEOUT
LASTWRITE REQMODE REQSTATE APPLPROCESS APPLNODE OWNER
TABLENAME TABLEID ROWIDLENGTH ROWIDHEX ROWID
265168 151747 38 PCRM 2004-04-30 13:48:44 main
3200 ? row_exclusive ? 0 10.0.3.94 PCRM
SV_COMMANDE 0000000000000ADE 7
00C91760624650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
265169 151762 37 PCRM 2004-04-30 13:50:25
Processor3 3200 ? row_exclusive ? 0 10.0.3.94
PCRM SV_COMMANDE 0000000000000ADE 7
00C91760624650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
265170 151755 39 PCRM 2004-04-30 13:50:32
Processor2 3200 1800 row_exclusive write 0
10.0.3.94 PCRM SV_FRACT 00000000000007FD 7
00C91761280020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
265171 151754 40 PCRM 2004-04-30 13:50:33
Processor1 3200 ? row_share ? 0 10.0.3.94
PCRM SV_COMMANDE 0000000000000ADE 7
00C91760624650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
265172 151759 41 PCRM 2004-04-30 13:50:37
Processor1 3200 ? row_exclusive ? 0 10.0.3.94
PCRM SV_COMMANDE 0000000000000ADE 7
00C91760624650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
