HM2 Lagging, PostgreSQL throwing errors in event viewer
Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. 01-25-2012, 08:04 AM #1
    Hielko
    Hielko is offline
    Junior Member
    Join Date
    Apr 2010
    Posts
    5

    Default HM2 Lagging, PostgreSQL throwing errors in event viewer

    I have followed the steps in http://hm2faq.holdemmanager.com/ques...+is+lagging%3F and found no working solution, but I noticed that PostgreSQL is throwing a lot of errors in the event viewer. The errors appear every 20/30 seconds or so, and are all similair to this one. In the task manager I also see that CPU usage of HM2 spikes to 25% (quadcore) with a high frequency, and when this happends Stars and HM2 stop responding for 1 second or so.

    2012-01-23 14:54:05 CETERROR: prepared statement "insertplayer" already exists
    2012-01-23 14:54:05 CETSTATEMENT: PREPARE INSERTPLAYER (text,smallint,integer,integer,smallint) AS Insert into players (playername,pokersite_id,cashhands,tourneyhands,op timizationstatus) values ($1,$2,$3,$4,$5) RETURNING player_id;

    PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,intege r,
    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);
    Reply With Quote Reply With Quote
  2. 01-25-2012, 10:24 AM #2
    Patvs
    Patvs is offline
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Which Operating System, Firewall, and Anti-Virus are you using?

    For W7 and Vista you must set \holdem manager\holdemmanager.exe, hudfuncsapp.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager2 installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab.

    Add exceptions to the windows firewall for those files even if the firewall is turned off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily.

    Make sure your video card drivers and windows auto updates are fully updated. Make sure you have Microsoft .NET Framework 3.5 SP1 (or later for w7) installed.

    Turn off User Account Control: How to Disable and Turn Off UAC in Windows 7 « My Digital Life

    --


    Which PostgreSQl version are you using?
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
    Reply With Quote Reply With Quote
  3. 01-25-2012, 10:37 AM #3
    Hielko
    Hielko is offline
    Junior Member
    Join Date
    Apr 2010
    Posts
    5

    Default

    I have win7 64-bit, using the standard windows firewall (have added exceptions for HM and hud) and using no anti-virus.

    My video drivers are fully updated, and I'm using .Net Framework 4 and UAC is off.

    I'm using PostfreSQL version 8.4

    So seems to me that those things aren't the problem.
    Reply With Quote Reply With Quote
  4. 01-25-2012, 05:22 PM #4
    Patvs
    Patvs is offline
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Read:
    http://forums.holdemmanager.com/mana...ease-tips.html,
    and
    http://hm2faq.holdemmanager.com/ques...+is+lagging%3F


    And turn off logging by editing the postgresql.config file.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
    Reply With Quote Reply With Quote
  5. 01-29-2012, 12:56 PM #5
    Hielko
    Hielko is offline
    Junior Member
    Join Date
    Apr 2010
    Posts
    5

    Default

    I basically tried everything; even removed and reinstalled postgress + HM2, and reimported all hands instead of trying to import it from my old HM1 DB. This did fix the DB errors i got first, but HM2 is still lagging. When I play I see very frequent spikes in CPU usage (multiple times/minute) and during a cpu usage spike Stars stops responding.

    The CPU usage is caused by the holdemmanger.exe process, and I'm almost sure that the problem is not on my side (fast quadcore pc, 8GB ram, sdd, up2date drivers). I do have a DB with more than 1.5 million hands, but this shouldn't be a problem I think.

    I suspect that HM2 or the hud is performing some potentially cpu-intensive code in the main execution thread, instead in a helper/worker thread. Happy to help a developer troubleshout this.
    Reply With Quote Reply With Quote
  6. 01-29-2012, 09:23 PM #6
    Patvs
    Patvs is offline
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Update to: http://forums.holdemmanager.com/hm2-...nner-beta.html

    Turn off Notecaddy
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
    Reply With Quote Reply With Quote
  7. 01-30-2012, 07:40 AM #7
    Hielko
    Hielko is offline
    Junior Member
    Join Date
    Apr 2010
    Posts
    5

    Default

    Updated to the latest version, maybe that will fix things. Turning off notecaddy was one of the first things i did.
    Reply With Quote Reply With Quote
  8. 11-07-2012, 12:24 PM #8
    robisterino
    robisterino is offline
    Junior Member
    Join Date
    Oct 2012
    Posts
    3

    Default

    solution to the insertplayer errors in the eventvwr:
    install latest 8.4 version of postgresql: Thank you for downloading PostgreSQL! | EnterpriseDB
    Reply With Quote Reply With Quote
  9. 02-27-2017, 09:12 PM #9
    nicosellier
    nicosellier is offline
    Member
    Join Date
    Dec 2014
    Posts
    60

    Default

    Multiple postgres 9.6.2 errors in event viewer
    Windows 7 * 64
    Hello, what should I do?
    I have a lot of errors for postgres that are :

    Nom du journal :Application
    Source : PostgreSQL
    Date : 27/02/2017 20:02:37
    ID de l’événement :0
    Catégorie de la tâche :Aucun
    Niveau : Erreur
    Mots clés : Classique
    Utilisateur : N/A
    Ordinateur : nicosellier-HP
    Description :
    2017-02-27 20:02:37 CET ERREUR: l'instruction préparée « insertplayer » existe déjà
    2017-02-27 20:02:37 CET INSTRUCTION : PREPARE INSERTPLAYER (text,smallint,integer,integer,smallint) AS Insert into players (playername,pokersite_id,cashhands,tourneyhands,op timizationstatus) values ($1,$2,$3,$4,$5) RETURNING player_id;

    PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,intege r,
    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-27T19:02:37.000000000Z" />
    <EventRecordID>1166614</EventRecordID>
    <Channel>Application</Channel>
    <Computer>nicosellier-HP</Computer>
    <Security />
    </System>
    <EventData>
    <Data>2017-02-27 20:02:37 CET ERREUR: l'instruction préparée « insertplayer » existe déjà
    2017-02-27 20:02:37 CET INSTRUCTION : PREPARE INSERTPLAYER (text,smallint,integer,integer,smallint) AS Insert into players (playername,pokersite_id,cashhands,tourneyhands,op timizationstatus) values ($1,$2,$3,$4,$5) RETURNING player_id;

    PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,intege r,
    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>





















    Nom du journal :Application
    Source : PostgreSQL
    Date : 27/02/2017 20:01:26
    ID de l’événement :0
    Catégorie de la tâche :Aucun
    Niveau : Erreur
    Mots clés : Classique
    Utilisateur : N/A
    Ordinateur : nicosellier-HP
    Description :
    2017-02-27 20:01:26 CET ERREUR: l'instruction préparée « insertplayer » existe déjà
    2017-02-27 20:01:26 CET INSTRUCTION : PREPARE INSERTPLAYER (text,smallint,integer,integer,smallint) AS Insert into players (playername,pokersite_id,cashhands,tourneyhands,op timizationstatus) values ($1,$2,$3,$4,$5) RETURNING player_id;

    PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,intege r,
    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
    , WonN
    Reply With Quote Reply With Quote
  10. 03-02-2017, 06:01 PM #10
    udbrky
    udbrky is offline
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    If you continue to have problems, please duplicate the issue and send us log files with a detailed description of what you were doing and what problems you were experiencing:
    - Open Windows Event Viewer's (Control Panel > System & Security > Administrative Tools or Start > Search > 'Event Viewer') > Windows Logs > Applications.
    - Check for any errors and send the information (Save All Events As...).
    - Please send a log file as well - Hold'Em Manager 2 FAQs - Poker Software :: How Do I Send a Log File to Holdem Manager Support?

    When sending any files please zip them (right-click > send to > compressed folder) before attaching them to an email. If the attachment is larger than 10MB please upload them to a file hosting site like dropbox, then right-click > 'copy public link' and paste the download link directly into the support ticket email. If you have any problems with dropbox try using filedropper.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. postgreSql win 7 64bit event error
    By Cgreen in forum Manager General
    Replies: 1
    Last Post: 10-21-2010, 08:28 AM
  2. PostgreSQL errors in Event viewer
    By Michaelooch in forum Manager General
    Replies: 3
    Last Post: 07-10-2010, 03:16 PM
  3. New errors in Event Mgr, Source: SideBySide
    By hemfan in forum Manager General
    Replies: 5
    Last Post: 07-04-2009, 04:25 PM
  4. PostgreSQL Install Errors
    By cloranrm in forum Manager General
    Replies: 1
    Last Post: 06-08-2009, 10:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules