error - prepared statement "insertplayer" already
Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Mar 2009
    Posts
    21

    Default error - prepared statement "insertplayer" already

    i seem to be getting a large number of errors and computer seems to have really slowed down lately i have only recently started using notecaddy and searched the problem and notecaddy appears to be the issue. the other thread i found was slightly different to my problem so thought i post the problem here


    Log Name: Application
    Source: PostgreSQL
    Date: 29/10/2014 16:14:43
    Event ID: 0
    Task Category: None
    Level: Error
    Keywords: Classic
    User: N/A
    Computer: brookspc1-HP
    Description:
    2014-10-29 16:14:43 GMTERROR: prepared statement "insertplayer" already exists
    2014-10-29 16:14:43 GMTSTATEMENT: 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);

    Event Xml:
    <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="2014-10-29T16:14:43.000000000Z" />
    <EventRecordID>172527</EventRecordID>
    <Channel>Application</Channel>
    <Computer>brookspc1-HP</Computer>
    <Security />
    </System>
    <EventData>
    <Data>2014-10-29 16:14:43 GMTERROR: prepared statement "insertplayer" already exists
    2014-10-29 16:14:43 GMTSTATEMENT: 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>

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    I'm really sorry and I know there is nothing more frustrating than having issues like this when trying to play. I hope i can help you resolve this quickly.

    What is your hard drive model, RAM and CPU? You can find this in your Control Panel - System - Device Manager. Sometimes lower spec PC's can contribute to lagging but that is not to say we can't still improve it further.

    Does it help if you try disabling Note Caddy? Open HUD Settings, make sure you are on the HUD Designer tab, and uncheck "Show Caddy notes in HUD." Restart HM2. You can re-enable it, we're just suggesting narrowing down things.

    In the meantime while you reply with those details I have a couple of things you can try that will improve the performance of your PC in general

    Please check these 2 FAQs and try all the steps there to see if they help:
    - http://hm2faq.holdemmanager.com/ques...%28Firewall%29 - Resolves issues where security software continually try to scan files and processes which can slow down your PC
    - http://hm2faq.holdemmanager.com/ques...rts+%26+HUD%29 - General tips and solutions for performance issues

    If you continue to have problems, please reproduce the problem, describe exactly what you were doing, and attach your log.txt file -
    http://hm2faq.holdemmanager.com/ques...ger+Support%3F

    Please send to support@holdemmanager.com with a link to this thread.

    These are benign excess logging that more recent versions of Postgres and can be ignored.
    Regards udbrky (Chris)

  3. #3
    Senior Member
    Join Date
    Mar 2010
    Posts
    102

    Default

    I know this is a three year old thread but I've been experience performance issues as well and have tried all sorts of things to resolve them. While going through different things I ran across the same errors in my event log. Looks like it happens whenever hands are imported so every few seconds throughout a session.

    Can one of the developers please look into this as either the db call isn't correct or something is going on if there's some sort of db pooling library used. It may not be the cause of the performance issues but having 100's or 1,000's of error events created a session, plus the exceptions from pgsql can't be good.

    Using latest non-beta version of hm2 pgsql 9.3 i believe and win10.

  4. #4
    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
    Regards udbrky (Chris)

Similar Threads

  1. "Root Element is missing error" + "Unhanded exception"
    By Chips8 in forum Manager General
    Replies: 3
    Last Post: 05-05-2013, 12:41 PM
  2. Replies: 2
    Last Post: 10-07-2012, 01:40 PM
  3. Replies: 6
    Last Post: 12-29-2011, 02:54 PM
  4. Replies: 1
    Last Post: 07-15-2011, 09:32 PM
  5. Replies: 9
    Last Post: 06-27-2011, 07:01 PM

Posting Permissions

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