[DONE] BUG:HUD:Elephant lost DB & hangup if you try to close windows with Advanced HUD

    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,065
      If you open advanced HUD & try to close it you cann`t do it because this window is hangup. After that Elephant lost current DB & opens many message about new DB creation.
      On the screenshot user got about 18 similar messages


      PC configuration: Win XP + AMD. :f_cry: :f_cry:
      Workaround: Disable Advanced HUD.
  • 15 replies
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi stanisluv,

      thanks for your report, we're looking into the issue. But to which "advanced HUD" exactly are you referring to? The Expert/Beginner HUD or the Player Details Popup opened by clicking on the HUD of a certain player?

      And have you already tried to open/close it running only one table - could it somehow be related to the amount of simultaneously running poker tables?

      Thx in advance,
      L
    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,065
      Hi Larres,
      I mean the Player Details Popup opened by clicking on the HUD of a certain player. I cann`t reproduce this bug because I don`t have this issue but I can ask about this issue for 1 table. :)
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi,

      we also had no luck trying to reproduce this issue.
      And it would be nice if we could get a saved Elephant logfile of this situation.

      Cheers,
      L
    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,065
      Ok. I try to get the file. :)
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi there,

      any news here?

      Thx,
      L
    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,065
      I catch tthe similar bug too I think there are 2 different bugs:
      I Lost DB connection.
      II Elephant hangup.

      I If Elephant lost DB connection then it cann`t reconnect automatically. It`s so easy to check it:
      1) when you play on 1 table simply stop PostgreSQL service.
      2) Wait 2 hands(you should get 2 error messages).
      3) Start service.
      After that you still receive message that DB connection is lost.
      To reconnect Elephant you should: Open Database management\Check connection settings.

      II Sometime Elephant may hangup when after lost connection.
      This is 2 messages from events log :
      code:
      - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      - <System>
        <Provider Name="PokerStrategy.com Elephant" /> 
        <EventID Qualifiers="0">0</EventID> 
        <Level>4</Level> 
        <Task>0</Task> 
        <Keywords>0x80000000000000</Keywords> 
        <TimeCreated SystemTime="2010-09-24T23:49:38.000000000Z" /> 
        <EventRecordID>24964</EventRecordID> 
        <Channel>Application</Channel> 
        <Computer>abcdef-PC</Computer> 
        <Security /> 
        </System>
      - <EventData>
        <Data>Unhandled error: System.Exception: Failed to establish a connection to '127.0.0.1'. в System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) в System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) в PokerStrategyElephant.ImportHandHistories.ReportEndOfImport() в PokerStrategyElephant.ImportArchivToDBThread.DoThread() в System.Threading.ThreadHelper.ThreadStart_Context(Object state) в System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx) в System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) в System.Threading.ThreadHelper.ThreadStart() Please refer to the log file for further details.</Data> 
        </EventData>
        </Event>


      Next message inform that procces was terminated
      code:
      - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      - <System>
        <Provider Name=".NET Runtime" /> 
        <EventID Qualifiers="0">1026</EventID> 
        <Level>2</Level> 
        <Task>0</Task> 
        <Keywords>0x80000000000000</Keywords> 
        <TimeCreated SystemTime="2010-09-24T23:49:39.000000000Z" /> 
        <EventRecordID>24965</EventRecordID> 
        <Channel>Application</Channel> 
        <Computer>abcdef-PC</Computer> 
        <Security /> 
        </System>
      - <EventData>
        <Data>Приложение: Elephant.exe Версия платформы: v4.0.30319 Описание. Процесс был завершен из-за необработанного исключения. Сведения об исключении: System.Exception Стек: в System.Windows.Forms.Control.MarshaledInvoke(System.Windows.Forms.Control, System.Delegate, System.Object[], Boolean) в System.Windows.Forms.Control.Invoke(System.Delegate, System.Object[]) в PokerStrategyElephant.ImportHandHistories.ReportEndOfImport() в PokerStrategyElephant.ImportArchivToDBThread.DoThread() в System.Threading.ThreadHelper.ThreadStart_Context(System.Object) в System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) в System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) в System.Threading.ThreadHelper.ThreadStart()</Data> 
        </EventData>
        </Event>


      I also have information from log file:
      code:
      2010-09-25 02:37:42,342 - 5769062 (UTC:2010-09-24 22:37:42,342) [1] INFO  Welcome Message: Installed PostgreSQL version: PostgreSQL 8.3.10, compiled by Visual C++ build 1400
      2010-09-25 03:49:17,464 - 10064184 (UTC:2010-09-24 23:49:17,464) [22] ERROR PBNLogger: 
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: The Connection is broken.
      - Severity: 
      - Code: 
      - BaseMessage: The Connection is broken.
      - Detail: 
      - Hint: 
      - Position: 
      - Where: 
      - File: 
      - Line: 
      - Routine: 
      - ErrorSql: 
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean NextResult()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: System.IO.IOException<none>
      - StackTrace:
         в Npgsql.ForwardsOnlyDataReader.NextResult()
         в Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
         в Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
         в Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
         в Npgsql.NpgsqlCommand.ExecuteReader()
         в PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
          -------------------- System.IO.IOException --------------------
          - Message: Не удается прочитать данные из транспортного соединения: Попытка установить соединение была безуспешной, т.к. от другого компьютера за требуемое время не получен нужный отклик, или было разорвано уже установленное соединение из-за неверного отклика уже подключенного компьютера.
          - Data: System.Collections.ListDictionaryInternal
          - TargetSite: Int32 Read(Byte[], Int32, Int32)
          - HelpLink: <null>
          - Source: System
          - InnerException: System.Net.Sockets.SocketException<none>
          - StackTrace:
         в System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
         в System.IO.BufferedStream.ReadByte()
         в Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
         в Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
         в Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
         в Npgsql.ForwardsOnlyDataReader.NextResult()
              -------------------- System.Net.Sockets.SocketException --------------------
              - Message: Попытка установить соединение была безуспешной, т.к. от другого компьютера за требуемое время не получен нужный отклик, или было разорвано уже установленное соединение из-за неверного отклика уже подключенного компьютера
              - ErrorCode: 10060
              - SocketErrorCode: TimedOut
              - NativeErrorCode: 10060
              - Data: System.Collections.ListDictionaryInternal
              - TargetSite: Int32 Receive(Byte[], Int32, Int32, System.Net.Sockets.SocketFlags)
              - HelpLink: <null>
              - Source: System
              - InnerException: <null><none>
              - StackTrace:
         в System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
         в System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
      2010-09-25 03:49:18,404 - 10065124 (UTC:2010-09-24 23:49:18,404) [22] ERROR PBNLogger: 
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: The Connection is broken.
      - Severity: 
      - Code: 
      - BaseMessage: The Connection is broken.
      - Detail: 
      - Hint: 
      - Position: 
      - Where: 
      - File: 
      - Line: 
      - Routine: 
      - ErrorSql: 
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Npgsql.ForwardsOnlyDataReader GetReader(System.Data.CommandBehavior)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: System.IO.IOException<none>
      - StackTrace:
         в Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
         в Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
         в Npgsql.NpgsqlCommand.ExecuteReader()
         в PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
          -------------------- System.IO.IOException --------------------
          - Message: Не удается записать данные в транспортное соединение: Удаленный хост принудительно разорвал существующее подключение.
          - Data: System.Collections.ListDictionaryInternal
          - TargetSite: Void Write(Byte[], Int32, Int32)
          - HelpLink: <null>
          - Source: System
          - InnerException: System.Net.Sockets.SocketException<none>
          - StackTrace:
         в System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
         в System.IO.BufferedStream.Flush()
         в Npgsql.NpgsqlQuery.WriteToStream(Stream outputStream)
         в Npgsql.NpgsqlReadyState.QueryEnum(NpgsqlConnector context, NpgsqlCommand command)
         в Npgsql.NpgsqlConnector.QueryEnum(NpgsqlCommand queryCommand)
         в Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
              -------------------- System.Net.Sockets.SocketException --------------------
              - Message: Удаленный хост принудительно разорвал существующее подключение
              - ErrorCode: 10054
              - SocketErrorCode: ConnectionReset
              - NativeErrorCode: 10054
              - Data: System.Collections.ListDictionaryInternal
              - TargetSite: Int32 Send(Byte[], Int32, Int32, System.Net.Sockets.SocketFlags)
              - HelpLink: <null>
              - Source: System
              - InnerException: <null><none>
              - StackTrace:
         в System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
         в System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)


      PS. I don`t get any aditional info for problem on screenshot but I think that this infromantion connected with that problem. :(
    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,065
      The user reproduce the problem on one table.
      This is the final messages in log-file:

      code:
      010-09-27 20:04:39,046 - 1435031 (UTC:2010-09-27 16:04:39,046) [16] ERROR PBNLogger: 
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42501: could not open file "C:/WINDOWS/TEMP/CommentsPlayers.ele" for writing: Permission denied
      - Severity: ERROR
      - Code: 42501
      - BaseMessage: could not open file "C:/WINDOWS/TEMP/CommentsPlayers.ele" for writing: Permission denied
      - Detail: 
      - Hint: 
      - Position: 
      - Where: 
      - File: .\src\backend\commands\copy.c
      - Line: 1238
      - Routine: DoCopyTo
      - ErrorSql: COPY (SELECT TRIM(comment,'\''), author_id, player_name, site_id FROM comment_on_player) TO 'C:/WINDOWS/TEMP/CommentsPlayers.ele' WITH DELIMITER ',' CSV QUOTE AS '\'' NULL AS 'NULL'
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
         в Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
         в Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
         в Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
         в Npgsql.ForwardsOnlyDataReader.NextResult()
         в Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
         в Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
         в Npgsql.NpgsqlCommand.ExecuteNonQuery()
         в PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      2010-09-27 20:04:54,046 - 1450031 (UTC:2010-09-27 16:04:54,046) [16] ERROR PBNLogger: Exception caught in Boolean PBN.Database.PostgreSQL.InitializeConnection(System.String ByRef)
      -------------------- System.Exception --------------------
      - Message: Timeout while getting a connection from pool.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Npgsql.NpgsqlConnector RequestPooledConnector(Npgsql.NpgsqlConnection)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
         в Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
         в Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
         в Npgsql.NpgsqlConnection.Open()
         в PBN.Database.PostgreSQL.InitializeConnection(String& in_sBinPath)
      2010-09-27 20:04:54,046 - 1450031 (UTC:2010-09-27 16:04:54,046) [16] ERROR PBNLogger: Exception caught in Void PokerStrategyElephant.HudWindowPlayerDetails.RefreshMatrix()
      -------------------- System.NullReferenceException --------------------
      - Message: Ссылка на объект не указывает на экземпляр объекта.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Poker.Classes.PlayerStatisticRatioCollection GetCustomizedHudLinesFromCache(System.Collections.Generic.List`1[System.String], System.Collections.Generic.List`1[Poker.Classes.Statistics+HudValue], System.String, PokerStrategyElephant.DatabaseFilter, Boolean, Int32, Int32)
      - HelpLink: <null>
      - Source: Elephant
      - InnerException: <null><none>
      - StackTrace:
         в PokerStrategyElephant.Database.MainQuery.GetCustomizedHudLinesFromCache(List`1 playerNames, List`1 request, String siteId, DatabaseFilter filter, Boolean useStrippedNames, Int32 minimumHands, Int32 minimumHandsPlayerStats)
         в PokerStrategyElephant.HudWindowPlayerDetails.RefreshMatrix()
      2010-09-27 20:04:54,062 - 1450046 (UTC:2010-09-27 16:04:54,062) [16] ERROR PBNLogger: Exception caught in Void PokerStrategyElephant.HudWindowPlayerDetails.RefreshMatrix()
      -------------------- System.NullReferenceException --------------------
      - Message: Ссылка на объект не указывает на экземпляр объекта.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Poker.Classes.PlayerStatisticRatioCollection GetCustomizedHudLinesFromCache(System.Collections.Generic.List`1[System.String], System.Collections.Generic.List`1[Poker.Classes.Statistics+HudValue], System.String, PokerStrategyElephant.DatabaseFilter, Boolean, Int32, Int32)
      - HelpLink: <null>
      - Source: Elephant
      - InnerException: <null><none>
      - StackTrace:
         в PokerStrategyElephant.Database.MainQuery.GetCustomizedHudLinesFromCache(List`1 playerNames, List`1 request, String siteId, DatabaseFilter filter, Boolean useStrippedNames, Int32 minimumHands, Int32 minimumHandsPlayerStats)
         в PokerStrategyElephant.HudWindowPlayerDetails.RefreshMatrix()

      You can download full log file here: http://drop.io/yit1q1x1276
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Thx, we'll have a closer look.

      Cheers,
      L
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi there,

      according to the error message:

      42501: could not open file "C:/WINDOWS/TEMP/CommentsPlayers.ele" for writing: Permission denied

      The user needs to add user permissions to allow writing for himself, the postgre standard user and/or the elephant user to the c:/Windows/Temp folder.

      That should work.

      Cheers,
      L
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi stanisluv,

      any news here? Is it done? Can we close this thread?

      Thx,
      L
    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,065
      I close the thread when it will be done. Ok?
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      ok, go ahead ;)
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi all,

      I'm going to close this abondoned thread now.

      Cheers,
      L
    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,065
      Hi Larres,

      I got the answer from user & now I`m sure that this is not a bug. User simply has problem with Elephant installation because:
      1) He cann`t fix this issue
      2) He has problem with Player filter. He say that this filter doesnt` work but I know that this bug already fixed.
      3) May be he still has problem with HUD on PokerStars (jumping HUD) but as we know this problem already fixed too.

      Best regards
      Stanislav.
    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,065
      Hi all.
      I find the cause of this issue!!! This is ESET NOD32 The software simply block access to C:/WINDOWS/TEMP for PokerStrategy Elephant.

      PS. May be anti-virus software block access for FTP HH folder in: [IN:000764] BUG:Autoimport:Win 7:FTP: Autoimport for FTP doesn`t work on Windows 7