Erreurs observateur d'événements

[nicolassellier]

bonjour

j'ai des centaines de rapport d'erreurs comme la suivante ( 2/minute)

Que dois je faire ?

cordialement

Nom du journal :ApplicationSource :       PostgreSQLDate :         28/02/2017 21:18:24ID de l'événement :0Catégorie de la tâche :AucunNiveau :       ErreurMots clés :    ClassiqueUtilisateur :  N/AOrdinateur :   nicosellier-HPDescription :2017-02-28 21:18:24 CET ERREUR:  l'instruction préparée « insertplayer ? existe déjà2017-02-28 21:18:24 CET INSTRUCTION :  PREPARE INSERTPLAYER (text,smallint,integer,integer,smallint) AS  Insert into players (playername,pokersite_id,cashhands,tourneyhands,optimizationstatus) values ($1,$2,$3,$4,$5) RETURNING player_id; 		PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,integer,	integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer)	as 	Update CompiledPlayerResults set totalhands = totalhands + $6	, TotalAmountWonincents = TotalAmountWonincents + $7	, TotalRakeincents = TotalRakeincents + $8	, TotalBBsWon = TotalBBsWon + $9	, VPIPHands = VPIPHands + $10	, PFRHands = PFRHands + $11	, CouldColdCall = CouldColdCall + $12	, DidColdCall = DidColdCall + $13	, CouldThreeBet = CouldThreeBet + $14	, DidThreeBet = DidThreeBet + $15	, CouldSqueeze = CouldSqueeze + $16	, DidSqueeze = DidSqueeze + $17	, FacingTwoPreflopRaisers = FacingTwoPreflopRaisers + $18	, CalledTwoPreflopRaisers = CalledTwoPreflopRaisers + $19	, RaisedTwoPreflopRaisers = RaisedTwoPreflopRaisers + $20	, SmallBlindStealAttempted = SmallBlindStealAttempted + $21	, SmallBlindStealDefended = SmallBlindStealDefended + $22	, SmallBlindStealReraised = SmallBlindStealReraised + $23	, BigBlindStealAttempted = BigBlindStealAttempted + $24	, BigBlindStealDefended = BigBlindStealDefended + $25	, BigBlindStealReraised = BigBlindStealReraised + $26	, SawNonSmallShowdown = SawNonSmallShowdown + $27	, WonNonSmallShowdown = WonNonSmallShowdown + $28	, SawLargeShowdown = SawLargeShowdown + $29	, WonLargeShowdown = WonLargeShowdown + $30	, SawNonSmallShowdownLimpedFlop = SawNonSmallShowdownLimpedFlop + $31	, WonNonSmallShowdownLimpedFlop = WonNonSmallShowdownLimpedFlop + $32	, SawLargeShowdownLimpedFlop = SawLargeShowdownLimpedFlop + $33	, WonLargeShowdownLimpedFlop = WonLargeShowdownLimpedFlop + $34	, WonHand = WonHand + $35	, WonHandWhenSawFlop = WonHandWhenSawFlop + $36	, WonHandWhenSawTurn = WonHandWhenSawTurn + $37	, WonHandWhenSawRiver = WonHandWhenSawRiver + $38	, FacedThreeBetPreflop = FacedThreeBetPreflop + $39	, FoldedToThreeBetPreflop = FoldedToThreeBetPreflop + $40	, CalledThreeBetPreflop = CalledThreeBetPreflop + $41	, RaisedThreeBetPreflop = RaisedThreeBetPreflop + $42	, FacedFourBetPreflop = FacedFourBetPreflop + $43	, FoldedToFourBetPreflop = FoldedToFourBetPreflop + $44	, CalledFourBetPreflop = CalledFourBetPreflop + $45	, RaisedFourBetPreflop = RaisedFourBetPreflop + $46	, TurnFoldIPPassOnFlopCB = TurnFoldIPPassOnFlopCB + $47	, TurnCallIPPassOnFlopCB = TurnCallIPPassOnFlopCB + $48	, TurnRaiseIPPassOnFlopCB = TurnRaiseIPPassOnFlopCB + $49	, RiverFoldIPPassOnTurnCB = RiverFoldIPPassOnTurnCB + $50	, RiverCallIPPassOnTurnCB = RiverCallIPPassOnTurnCB + $51	, RiverRaiseIPPassOnTurnCB = RiverRaiseIPPassOnTurnCB + $52	, SawFlop = SawFlop + $53	, SawShowdown = SawShowdown + $54	, WonShowdown = WonShowdown + $55	, TotalBets = TotalBets + $56	, TotalCalls = TotalCalls + $57	, FlopContinuationBetPossible = FlopContinuationBetPossible + $58	, FlopContinuationBetMade = FlopContinuationBetMade + $59	, TurnContinuationBetPossible = TurnContinuationBetPossible + $60	, TurnContinuationBetMade = TurnContinuationBetMade + $61	, RiverContinuationBetPossible = RiverContinuationBetPossible + $62	, RiverContinuationBetMade = RiverContinuationBetMade + $63	, FacingFlopContinuationBet = FacingFlopContinuationBet + $64	, FoldedToFlopContinuationBet = FoldedToFlopContinuationBet + $65	, CalledFlopContinuationBet = CalledFlopContinuationBet + $66	, RaisedFlopContinuationBet = RaisedFlopContinuationBet + $67	, FacingTurnContinuationBet = FacingTurnContinuationBet + $68	, FoldedToTurnContinuationBet = FoldedToTurnContinuationBet + $69	, CalledTurnContinuationBet = CalledTurnContinuationBet + $70	, RaisedTurnContinuationBet = RaisedTurnContinuationBet + $71	, FacingRiverContinuationBet = FacingRiverContinuationBet + $72	, FoldedToRiverContinuationBet = FoldedToRiverContinuationBet + $73	, CalledRiverContinuationBet = CalledRiverContinuationBet + $74	, RaisedRiverContinuationBet = RaisedRiverContinuationBet + $75	, TotalPostFlopStreetsSeen = TotalPostFlopStreetsSeen + $76	, totalaggressivepostflopstreetsseen = totalaggressivepostflopstreetsseen + $77	 where compiledplayerresults_id = (select compiledplayerresults_id from compiledplayerresults where player_id = $1	and playedyearandmonth = $2	and numberofplayers = $3	and gametype_id = $4	and bbgroup_id = $5 limit 1);XML de l'événement :<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">  <System>    <Provider Name="PostgreSQL" />    <EventID Qualifiers="0">0</EventID>    <Level>2</Level>    <Task>0</Task>    <Keywords>0x80000000000000</Keywords>    <TimeCreated SystemTime="2017-02-28T20:18:24.000000000Z" />    <EventRecordID>1168153</EventRecordID>    <Channel>Application</Channel>    <Computer>nicosellier-HP</Computer>    <Security />  </System>  <EventData>    <Data>2017-02-28 21:18:24 CET ERREUR:  l'instruction préparée « insertplayer ? existe déjà2017-02-28 21:18:24 CET INSTRUCTION :  PREPARE INSERTPLAYER (text,smallint,integer,integer,smallint) AS  Insert into players (playername,pokersite_id,cashhands,tourneyhands,optimizationstatus) values ($1,$2,$3,$4,$5) RETURNING player_id; 		PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,integer,	integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer,integer,integer,integer,	integer,integer)	as 	Update CompiledPlayerResults set totalhands = totalhands + $6	, TotalAmountWonincents = TotalAmountWonincents + $7	, TotalRakeincents = TotalRakeincents + $8	, TotalBBsWon = TotalBBsWon + $9	, VPIPHands = VPIPHands + $10	, PFRHands = PFRHands + $11	, CouldColdCall = CouldColdCall + $12	, DidColdCall = DidColdCall + $13	, CouldThreeBet = CouldThreeBet + $14	, DidThreeBet = DidThreeBet + $15	, CouldSqueeze = CouldSqueeze + $16	, DidSqueeze = DidSqueeze + $17	, FacingTwoPreflopRaisers = FacingTwoPreflopRaisers + $18	, CalledTwoPreflopRaisers = CalledTwoPreflopRaisers + $19	, RaisedTwoPreflopRaisers = RaisedTwoPreflopRaisers + $20	, SmallBlindStealAttempted = SmallBlindStealAttempted + $21	, SmallBlindStealDefended = SmallBlindStealDefended + $22	, SmallBlindStealReraised = SmallBlindStealReraised + $23	, BigBlindStealAttempted = BigBlindStealAttempted + $24	, BigBlindStealDefended = BigBlindStealDefended + $25	, BigBlindStealReraised = BigBlindStealReraised + $26	, SawNonSmallShowdown = SawNonSmallShowdown + $27	, WonNonSmallShowdown = WonNonSmallShowdown + $28	, SawLargeShowdown = SawLargeShowdown + $29	, WonLargeShowdown = WonLargeShowdown + $30	, SawNonSmallShowdownLimpedFlop = SawNonSmallShowdownLimpedFlop + $31	, WonNonSmallShowdownLimpedFlop = WonNonSmallShowdownLimpedFlop + $32	, SawLargeShowdownLimpedFlop = SawLargeShowdownLimpedFlop + $33	, WonLargeShowdownLimpedFlop = WonLargeShowdownLimpedFlop + $34	, WonHand = WonHand + $35	, WonHandWhenSawFlop = WonHandWhenSawFlop + $36	, WonHandWhenSawTurn = WonHandWhenSawTurn + $37	, WonHandWhenSawRiver = WonHandWhenSawRiver + $38	, FacedThreeBetPreflop = FacedThreeBetPreflop + $39	, FoldedToThreeBetPreflop = FoldedToThreeBetPreflop + $40	, CalledThreeBetPreflop = CalledThreeBetPreflop + $41	, RaisedThreeBetPreflop = RaisedThreeBetPreflop + $42	, FacedFourBetPreflop = FacedFourBetPreflop + $43	, FoldedToFourBetPreflop = FoldedToFourBetPreflop + $44	, CalledFourBetPreflop = CalledFourBetPreflop + $45	, RaisedFourBetPreflop = RaisedFourBetPreflop + $46	, TurnFoldIPPassOnFlopCB = TurnFoldIPPassOnFlopCB + $47	, TurnCallIPPassOnFlopCB = TurnCallIPPassOnFlopCB + $48	, TurnRaiseIPPassOnFlopCB = TurnRaiseIPPassOnFlopCB + $49	, RiverFoldIPPassOnTurnCB = RiverFoldIPPassOnTurnCB + $50	, RiverCallIPPassOnTurnCB = RiverCallIPPassOnTurnCB + $51	, RiverRaiseIPPassOnTurnCB = RiverRaiseIPPassOnTurnCB + $52	, SawFlop = SawFlop + $53	, SawShowdown = SawShowdown + $54	, WonShowdown = WonShowdown + $55	, TotalBets = TotalBets + $56	, TotalCalls = TotalCalls + $57	, FlopContinuationBetPossible = FlopContinuationBetPossible + $58	, FlopContinuationBetMade = FlopContinuationBetMade + $59	, TurnContinuationBetPossible = TurnContinuationBetPossible + $60	, TurnContinuationBetMade = TurnContinuationBetMade + $61	, RiverContinuationBetPossible = RiverContinuationBetPossible + $62	, RiverContinuationBetMade = RiverContinuationBetMade + $63	, FacingFlopContinuationBet = FacingFlopContinuationBet + $64	, FoldedToFlopContinuationBet = FoldedToFlopContinuationBet + $65	, CalledFlopContinuationBet = CalledFlopContinuationBet + $66	, RaisedFlopContinuationBet = RaisedFlopContinuationBet + $67	, FacingTurnContinuationBet = FacingTurnContinuationBet + $68	, FoldedToTurnContinuationBet = FoldedToTurnContinuationBet + $69	, CalledTurnContinuationBet = CalledTurnContinuationBet + $70	, RaisedTurnContinuationBet = RaisedTurnContinuationBet + $71	, FacingRiverContinuationBet = FacingRiverContinuationBet + $72	, FoldedToRiverContinuationBet = FoldedToRiverContinuationBet + $73	, CalledRiverContinuationBet = CalledRiverContinuationBet + $74	, RaisedRiverContinuationBet = RaisedRiverContinuationBet + $75	, TotalPostFlopStreetsSeen = TotalPostFlopStreetsSeen + $76	, totalaggressivepostflopstreetsseen = totalaggressivepostflopstreetsseen + $77	 where compiledplayerresults_id = (select compiledplayerresults_id from compiledplayerresults where player_id = $1	and playedyearandmonth = $2	and numberofplayers = $3	and gametype_id = $4	and bbgroup_id = $5 limit 1);</Data>  </EventData></Event>

[Dylav]

Bonjour Nicolas,

 

L'événement que tu nous présentes concerne le logiciel PostgreSQL, qui est un système de gestion de bases de données relationnelles.

• Utilises-tu ce logiciel ?
• Les autres erreurs signalées par l'observateur d'événements concernent-elles le même logiciel ?

Si la réponse est Oui aux deux questions, je te suggère de soumettre ton problème sur le forum PostgreSQLFr.