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

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

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.

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

Ok. I try to get the file.

Hi there,

any news here?

Thx,
L

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 :

- <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

- <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:

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.

The user reproduce the problem on one table.
This is the final messages in log-file:

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

Thx, we'll have a closer look.

Cheers,
L

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

Hi stanisluv,

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

Thx,
L

I close the thread when it will be done. Ok?

ok, go ahead

Hi all,

I'm going to close this abondoned thread now.

Cheers,
L

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.

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