[DONE] could not execute query / Porgrammabsturz

    • jerome83
      jerome83
      Bronze
      Dabei seit: 31.07.2006 Beiträge: 223
      PokerStrategy.com Elephant Version: 0.96

      Betriebssystem:
      Microsoft® Windows Vista™ Home Premium (Microsoft Windows NT 6.0.6002 Service Pack 2)

      Auf welchen Pokerraum bezieht sich das Problem:
      ( ) PartyPoker
      ( ) PokerStars
      ( ) Full Tilt Poker
      ( ) iPoker Netzwerk (Mansion, Titan, etc.)
      ( ) andere:

      Problem in FAQ gesucht:
      (X) Ja
      ( ) Nein

      Screenshot vorhanden:
      ( ) Ja
      (X) Nein

      Fehlermeldungen im Logfile des Elephants vorhanden:
      (X) Ja
      ( ) Nein

      Bei Datenbankproblemen:
      PostgreSQL separat installiert:
      (X) Ja
      ( ) Nein, der Elephant hat Postgres mit installiert

      Datenbankproblem-Guide gelesen?
      (X) Ja
      ( ) Nein

      Genaue Problembeschreibung:

      Nach dem Start des Elephant bekomme ich die Fehlermeldung "could not execute query". Nachdem ich sie bestätigt habe und mit dem Spielen beginne stürzt der Elephant dann nachdem ein paar Hände importiert wurden sind einfach ab.

      Hier auch mal der Inhalt der Log-Datei, ich hoffe sehr irgendjemand weiß was damit anzufangen und kann mir helfen.

      Vielen Dank und viele Grüße.

      P.S.: Ich hab es mit "Aufräumen der DB" probiert, das ändert aber gar nichts.







      2011-01-17 17:07:29,399 - 160471 (UTC:2011-01-17 16:07:29,399) [1] INFO Welcome Message: Installed PostgreSQL version: PostgreSQL 8.3.0, compiled by Visual C++ build 1400
      2011-01-17 17:07:40,234 - 171306 (UTC:2011-01-17 16:07:40,234) [1] INFO VersionUpdate: Starting background version check...
      2011-01-17 17:07:41,655 - 172727 (UTC:2011-01-17 16:07:41,655) [16] INFO VersionUpdate: Background version check finished.
      Latest Version: 0.87.1381.2210
      NewVersionAvail: False
      IgnoreUpdateVersion:

      2011-01-17 17:08:02,829 - 193901 (UTC:2011-01-17 16:08:02,829) [6] ERROR PokerStrategy.Elephant.NHibernate.Repositories: Exception caught in Int32 PokerStrategy.Elephant.NHibernate.Repositories.HandRepository.GetLastUnprocessedHandCount(NHibernate.ISession)
      -------------------- PS.Base.Database.DatabaseException --------------------
      - Message: could not execute query
      [ select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1 ]
      [SQL: select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Base
      - InnerException: PS.Base.Database.DatabaseException<none>
      - StackTrace:
      bei PS.Base.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      bei PokerStrategy.Elephant.NHibernate.Repositories.HandRepositoryCore.GetLastUnprocessedHandCount(ISession session)
      bei PokerStrategy.Elephant.NHibernate.Repositories.HandRepository.GetLastUnprocessedHandCount(ISession session)
      -------------------- PS.Base.Database.DatabaseException --------------------
      - Message: could not execute query
      [ select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1 ]
      [SQL: select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Base
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      bei PS.Base.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      bei PokerStrategy.Elephant.NHibernate.SessionLayer.ExecuteSqlQuery(String sqlQuery)
      bei PokerStrategy.Elephant.NHibernate.Repositories.HandRepositoryCore.<>c__DisplayClassa.<GetLastUnprocessedHandCount>b__9()
      bei PS.Base.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1 ]
      [SQL: select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1]
      - SqlString: select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: System.IO.IOException<none>
      - StackTrace:
      bei NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      bei NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      bei NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      bei NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
      bei NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
      bei NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters)
      bei NHibernate.Impl.SqlQueryImpl.List()
      bei PokerStrategy.Elephant.NHibernate.SessionLayer.<>c__DisplayClass1.<ExecuteSqlQuery>b__0()
      bei PS.Base.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- System.IO.IOException --------------------
      - Message: Von der Übertragungsverbindung können keine Daten gelesen werden: Eine vorhandene Verbindung wurde vom Remotehost geschlossen.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Int32 Read(Byte[], Int32, Int32)
      - HelpLink: <null>
      - Source: System
      - InnerException: System.Net.Sockets.SocketException<none>
      - StackTrace:
      bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
      bei System.IO.BufferedStream.ReadByte()
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      bei Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context)
      bei Npgsql.NpgsqlConnector.Open()
      bei Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      bei Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      bei Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      bei Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      bei Npgsql.NpgsqlConnection.Open()
      bei NHibernate.Connection.DriverConnectionProvider.GetConnection()
      bei NHibernate.AdoNet.ConnectionManager.GetConnection()
      bei NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd)
      bei NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
      bei NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
      bei NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      bei NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      bei NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      -------------------- System.Net.Sockets.SocketException --------------------
      - Message: Eine vorhandene Verbindung wurde vom Remotehost geschlossen
      - ErrorCode: 10054
      - SocketErrorCode: ConnectionReset
      - NativeErrorCode: 10054
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Int32 Receive(Byte[], Int32, Int32, System.Net.Sockets.SocketFlags)
      - HelpLink: <null>
      - Source: System
      - InnerException: <null><none>
      - StackTrace:
      bei System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
      bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
      2011-01-17 17:08:03,869 - 194941 (UTC:2011-01-17 16:08:03,869) [6] ERROR PokerStrategy.Elephant.NHibernate.Repositories: An error occurred while accessing the nHibernate repositories.
      -------------------- PS.Base.Database.DatabaseException --------------------
      - Message: could not execute query
      [ select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1 ]
      [SQL: select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Base
      - InnerException: PS.Base.Database.DatabaseException<none>
      - StackTrace:
      bei PS.Base.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      bei PokerStrategy.Elephant.NHibernate.Repositories.HandRepositoryCore.GetLastUnprocessedHandCount(ISession session)
      bei PokerStrategy.Elephant.NHibernate.Repositories.HandRepository.GetLastUnprocessedHandCount(ISession session)
      -------------------- PS.Base.Database.DatabaseException --------------------
      - Message: could not execute query
      [ select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1 ]
      [SQL: select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Base
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      bei PS.Base.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      bei PokerStrategy.Elephant.NHibernate.SessionLayer.ExecuteSqlQuery(String sqlQuery)
      bei PokerStrategy.Elephant.NHibernate.Repositories.HandRepositoryCore.<>c__DisplayClassa.<GetLastUnprocessedHandCount>b__9()
      bei PS.Base.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1 ]
      [SQL: select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1]
      - SqlString: select count(*) from (select * from pse_hands where processstate=1 limit 5001) as t1
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: System.IO.IOException<none>
      - StackTrace:
      bei NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      bei NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      bei NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      bei NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
      bei NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
      bei NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters)
      bei NHibernate.Impl.SqlQueryImpl.List()
      bei PokerStrategy.Elephant.NHibernate.SessionLayer.<>c__DisplayClass1.<ExecuteSqlQuery>b__0()
      bei PS.Base.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- System.IO.IOException --------------------
      - Message: Von der Übertragungsverbindung können keine Daten gelesen werden: Eine vorhandene Verbindung wurde vom Remotehost geschlossen.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Int32 Read(Byte[], Int32, Int32)
      - HelpLink: <null>
      - Source: System
      - InnerException: System.Net.Sockets.SocketException<none>
      - StackTrace:
      bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
      bei System.IO.BufferedStream.ReadByte()
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      bei Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context)
      bei Npgsql.NpgsqlConnector.Open()
      bei Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      bei Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      bei Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      bei Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      bei Npgsql.NpgsqlConnection.Open()
      bei NHibernate.Connection.DriverConnectionProvider.GetConnection()
      bei NHibernate.AdoNet.ConnectionManager.GetConnection()
      bei NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd)
      bei NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
      bei NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
      bei NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      bei NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      bei NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      -------------------- System.Net.Sockets.SocketException --------------------
      - Message: Eine vorhandene Verbindung wurde vom Remotehost geschlossen
      - ErrorCode: 10054
      - SocketErrorCode: ConnectionReset
      - NativeErrorCode: 10054
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Int32 Receive(Byte[], Int32, Int32, System.Net.Sockets.SocketFlags)
      - HelpLink: <null>
      - Source: System
      - InnerException: <null><none>
      - StackTrace:
      bei System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
      bei System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
      2011-01-17 17:08:39,062 - 230134 (UTC:2011-01-17 16:08:39,062) [20] INFO ImportReport: Importing the complete queue took 00:00:55.7283286
      2011-01-17 17:23:20,222 - 1111294 (UTC:2011-01-17 16:23:20,222) [1] ERROR PBNLogger: Exception caught in Void PokerStrategyElephant.StatisticOverView.gridViewOverviewSessions_CustomDrawFooterCell(System.Object, DevExpress.XtraGrid.Views.Grid.FooterCellCustomDrawEventArgs)
      -------------------- System.InvalidCastException --------------------
      - Message: Das Objekt des Typs "System.Windows.Forms.BindingSource" kann nicht in Typ "System.Collections.Generic.List`1[PokerStrategyElephant.OverviewLine]" umgewandelt werden.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void gridViewOverviewSessions_CustomDrawFooterCell(System.Object, DevExpress.XtraGrid.Views.Grid.FooterCellCustomDrawEventArgs)
      - HelpLink: <null>
      - Source: Elephant.Base
      - InnerException: <null><none>
      - StackTrace:
      bei PokerStrategyElephant.StatisticOverView.gridViewOverviewSessions_CustomDrawFooterCell(Object sender, FooterCellCustomDrawEventArgs e)
      2011-01-17 17:23:20,332 - 1111404 (UTC:2011-01-17 16:23:20,332) [1] ERROR PBNLogger: Exception caught in Void PokerStrategyElephant.StatisticOverView.gridViewOverviewSessions_CustomDrawFooterCell(System.Object, DevExpress.XtraGrid.Views.Grid.FooterCellCustomDrawEventArgs)
      -------------------- System.InvalidCastException --------------------
      - Message: Das Objekt des Typs "System.Windows.Forms.BindingSource" kann nicht in Typ "System.Collections.Generic.List`1[PokerStrategyElephant.OverviewLine]" umgewandelt werden.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void gridViewOverviewSessions_CustomDrawFooterCell(System.Object, DevExpress.XtraGrid.Views.Grid.FooterCellCustomDrawEventArgs)
      - HelpLink: <null>
      - Source: Elephant.Base
      - InnerException: <null><none>
      - StackTrace:
      bei PokerStrategyElephant.StatisticOverView.gridViewOverviewSessions_CustomDrawFooterCell(Object sender, FooterCellCustomDrawEventArgs e)
      2011-01-17 17:29:30,198 - 1481270 (UTC:2011-01-17 16:29:30,198) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:31,225 - 1482297 (UTC:2011-01-17 16:29:31,225) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:32,278 - 1483350 (UTC:2011-01-17 16:29:32,278) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:33,388 - 1484460 (UTC:2011-01-17 16:29:33,388) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:34,413 - 1485485 (UTC:2011-01-17 16:29:34,413) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:35,543 - 1486615 (UTC:2011-01-17 16:29:35,543) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:36,591 - 1487663 (UTC:2011-01-17 16:29:36,591) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:37,616 - 1488688 (UTC:2011-01-17 16:29:37,616) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:38,642 - 1489714 (UTC:2011-01-17 16:29:38,642) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:39,711 - 1490783 (UTC:2011-01-17 16:29:39,711) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:40,780 - 1491852 (UTC:2011-01-17 16:29:40,780) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:41,837 - 1492909 (UTC:2011-01-17 16:29:41,837) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:42,891 - 1493963 (UTC:2011-01-17 16:29:42,891) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:43,917 - 1494989 (UTC:2011-01-17 16:29:43,917) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:43,938 - 1495010 (UTC:2011-01-17 16:29:43,938) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:43,940 - 1495012 (UTC:2011-01-17 16:29:43,940) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:44,969 - 1496041 (UTC:2011-01-17 16:29:44,969) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:44,989 - 1496061 (UTC:2011-01-17 16:29:44,989) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:44,990 - 1496062 (UTC:2011-01-17 16:29:44,990) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:46,007 - 1497079 (UTC:2011-01-17 16:29:46,007) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:46,069 - 1497141 (UTC:2011-01-17 16:29:46,069) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:46,071 - 1497143 (UTC:2011-01-17 16:29:46,071) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:47,118 - 1498190 (UTC:2011-01-17 16:29:47,118) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:47,134 - 1498206 (UTC:2011-01-17 16:29:47,134) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:47,135 - 1498207 (UTC:2011-01-17 16:29:47,135) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:48,156 - 1499228 (UTC:2011-01-17 16:29:48,156) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:48,183 - 1499255 (UTC:2011-01-17 16:29:48,183) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:48,184 - 1499256 (UTC:2011-01-17 16:29:48,184) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:49,209 - 1500281 (UTC:2011-01-17 16:29:49,209) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:49,232 - 1500304 (UTC:2011-01-17 16:29:49,232) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:49,234 - 1500306 (UTC:2011-01-17 16:29:49,234) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:50,251 - 1501323 (UTC:2011-01-17 16:29:50,251) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:50,276 - 1501348 (UTC:2011-01-17 16:29:50,276) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:50,278 - 1501350 (UTC:2011-01-17 16:29:50,278) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:51,308 - 1502380 (UTC:2011-01-17 16:29:51,308) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:51,333 - 1502405 (UTC:2011-01-17 16:29:51,333) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:51,335 - 1502407 (UTC:2011-01-17 16:29:51,335) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:52,388 - 1503460 (UTC:2011-01-17 16:29:52,388) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:52,410 - 1503482 (UTC:2011-01-17 16:29:52,410) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:52,412 - 1503484 (UTC:2011-01-17 16:29:52,412) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:53,651 - 1504723 (UTC:2011-01-17 16:29:53,651) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:53,668 - 1504740 (UTC:2011-01-17 16:29:53,668) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:53,669 - 1504741 (UTC:2011-01-17 16:29:53,669) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:54,728 - 1505800 (UTC:2011-01-17 16:29:54,728) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:54,742 - 1505814 (UTC:2011-01-17 16:29:54,742) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:54,743 - 1505815 (UTC:2011-01-17 16:29:54,743) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:55,775 - 1506847 (UTC:2011-01-17 16:29:55,775) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:55,832 - 1506904 (UTC:2011-01-17 16:29:55,832) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:55,833 - 1506905 (UTC:2011-01-17 16:29:55,833) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:29:56,885 - 1507957 (UTC:2011-01-17 16:29:56,885) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:29:56,940 - 1508012 (UTC:2011-01-17 16:29:56,940) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:29:56,941 - 1508013 (UTC:2011-01-17 16:29:56,941) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:00,136 - 1511208 (UTC:2011-01-17 16:30:00,136) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:01,615 - 1512687 (UTC:2011-01-17 16:30:01,615) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:01,617 - 1512689 (UTC:2011-01-17 16:30:01,617) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:02,635 - 1513707 (UTC:2011-01-17 16:30:02,635) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:02,674 - 1513746 (UTC:2011-01-17 16:30:02,674) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:02,675 - 1513747 (UTC:2011-01-17 16:30:02,675) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:03,687 - 1514759 (UTC:2011-01-17 16:30:03,687) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:03,716 - 1514788 (UTC:2011-01-17 16:30:03,716) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:03,717 - 1514789 (UTC:2011-01-17 16:30:03,717) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:04,755 - 1515827 (UTC:2011-01-17 16:30:04,755) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:04,879 - 1515951 (UTC:2011-01-17 16:30:04,879) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:04,881 - 1515953 (UTC:2011-01-17 16:30:04,881) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:05,907 - 1516979 (UTC:2011-01-17 16:30:05,907) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:05,973 - 1517045 (UTC:2011-01-17 16:30:05,973) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:05,975 - 1517047 (UTC:2011-01-17 16:30:05,975) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:06,992 - 1518064 (UTC:2011-01-17 16:30:06,992) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:07,005 - 1518077 (UTC:2011-01-17 16:30:07,005) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:07,007 - 1518079 (UTC:2011-01-17 16:30:07,007) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:08,047 - 1519119 (UTC:2011-01-17 16:30:08,047) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:08,063 - 1519135 (UTC:2011-01-17 16:30:08,063) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:08,064 - 1519136 (UTC:2011-01-17 16:30:08,064) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:09,097 - 1520169 (UTC:2011-01-17 16:30:09,097) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:09,116 - 1520188 (UTC:2011-01-17 16:30:09,116) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:09,117 - 1520189 (UTC:2011-01-17 16:30:09,117) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:10,778 - 1521850 (UTC:2011-01-17 16:30:10,778) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:10,791 - 1521863 (UTC:2011-01-17 16:30:10,791) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:10,792 - 1521864 (UTC:2011-01-17 16:30:10,792) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:12,032 - 1523104 (UTC:2011-01-17 16:30:12,032) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:12,152 - 1523224 (UTC:2011-01-17 16:30:12,152) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:12,153 - 1523225 (UTC:2011-01-17 16:30:12,153) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:13,167 - 1524239 (UTC:2011-01-17 16:30:13,167) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:13,181 - 1524253 (UTC:2011-01-17 16:30:13,181) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:13,182 - 1524254 (UTC:2011-01-17 16:30:13,182) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:14,192 - 1525264 (UTC:2011-01-17 16:30:14,192) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:14,207 - 1525279 (UTC:2011-01-17 16:30:14,207) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:14,208 - 1525280 (UTC:2011-01-17 16:30:14,208) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:15,224 - 1526296 (UTC:2011-01-17 16:30:15,224) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:15,248 - 1526320 (UTC:2011-01-17 16:30:15,248) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:15,250 - 1526322 (UTC:2011-01-17 16:30:15,250) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:30:16,281 - 1527353 (UTC:2011-01-17 16:30:16,281) [13] ERROR PBNLogger: Failed to GetLobbyWindowHandle(process.Id) with PID <5436>!
      The HUD will not be shown
      2011-01-17 17:30:16,297 - 1527369 (UTC:2011-01-17 16:30:16,297) [13] ERROR PBNLogger: Failed to create ClientMouseHooks for PID <5436> because we don't have a lobby window handle!
      The HUD will not be shown
      2011-01-17 17:30:16,298 - 1527370 (UTC:2011-01-17 16:30:16,298) [13] ERROR PBNLogger: Dont have clientMouseHooks -> Cannot show HUD
      2011-01-17 17:34:05,854 - 1756926 (UTC:2011-01-17 16:34:05,854) [20] INFO ImportReport: Importing the complete queue took 00:00:00.0824910
      2011-01-17 17:34:05,869 - 1756941 (UTC:2011-01-17 16:34:05,869) [20] INFO ImportReport: Importing the complete queue took 00:00:00.0028763
      2011-01-17 17:34:05,874 - 1756946 (UTC:2011-01-17 16:34:05,874) [20] INFO ImportReport: Importing the complete queue took 00:00:00.0026152
      2011-01-17 17:34:06,231 - 1757303 (UTC:2011-01-17 16:34:06,231) [10] ERROR PokerStrategy.Elephant.NHibernate.Extensions: Error retrieving database summary stats in Void PokerStrategy.Elephant.NHibernate.Extensions.TourneyOverviewStatsSummaryExtension.RefreshFromDatabase(PokerStrategy.Elephant.PokerHand.Analysis.Sng.TourneyOverviewStatsSummary)
      -------------------- System.ArgumentException --------------------
      - Message: Ein Element mit dem gleichen Schlüssel wurde bereits hinzugefügt.
      - ParamName: <null>
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void ThrowArgumentException(System.ExceptionResource)
      - HelpLink: <null>
      - Source: mscorlib
      - InnerException: <null><none>
      - StackTrace:
      bei System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
      bei System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
      bei PokerStrategy.Elephant.PokerHand.Analysis.Sng.TourneyOverviewStatsSummary.Reset()
      bei PokerStrategy.Elephant.NHibernate.Extensions.TourneyOverviewStatsSummaryExtension.RefreshFromDatabase(TourneyOverviewStatsSummary me)
      2011-01-17 17:36:34,356 - 1905428 (UTC:2011-01-17 16:36:34,356) [20] INFO ImportReport: Importing the complete queue took 00:00:00.0049388
      2011-01-17 17:38:12,399 - 2003471 (UTC:2011-01-17 16:38:12,399) [20] INFO ImportReport: Importing the complete queue took 00:00:00.0191206
  • 6 Antworten
    • Larres
      Larres
      Bronze
      Dabei seit: 07.09.2009 Beiträge: 2.402
      Hallo jerome83,

      die "could not execute query"-Melung ist nicht die Ursache für einen Crash. Hier scheint ehr die Verbindung zur Datenbank verloren gegangen zu sein ("Von der Übertragungsverbindung können keine Daten gelesen werden: Eine vorhandene Verbindung wurde vom Remotehost geschlossen.").
      Ist der PostgreSQL Database Service noch aktiv und am Laufen?
      Oder sind die lokalen Hand History Ordner oder die Datenbank via Netzwerk eingerichtet?

      Thx,
      L
    • jerome83
      jerome83
      Bronze
      Dabei seit: 31.07.2006 Beiträge: 223
      Original von Larres
      Ist der PostgreSQL Database Service noch aktiv und am Laufen? L
      Der ist sicher noch am Laufen. Ich kann auch problemlos anschließend mit dem Poker Tracker arbeiten, das läuft wie geschmiert. Das Problem mit der Meldung tritt auch erst auf seit ich den PT3 installiert habe, könnte da also die Ursache des Problems liegen? Sind dir da Probleme bekannt?

      Original von Larres
      Oder sind die lokalen Hand History Ordner oder die Datenbank via Netzwerk eingerichtet?
      L
      Nein, das sind sie nicht.

      Mir scheint als seien die Fehlermeldung und das Abstürzen zwei paar Schuhe die nicht zwangsläufig miteinander zu tun haben müssen.

      Was meinst du?

      Vielen Dank und viele Grüße.
    • jerome83
      jerome83
      Bronze
      Dabei seit: 31.07.2006 Beiträge: 223
      Hat denn keiner mehr Lösungsvorschläge?

      Viele Grüße...
    • Larres
      Larres
      Bronze
      Dabei seit: 07.09.2009 Beiträge: 2.402
      Hi jerome83,

      also Elephant und Poker Tracker 3 Datenbanken harmonieren normaler Weise nebeneinander, die neue PT3 Datenbank allein dürfte also nicht das Problem sein.

      Dennoch sieht es hier ehr nach einem Datenbank-Issue und weniger nach einem Elephant Problem aus. Um dem nachzugehen würde ich vorschlagen, Du installierst Dir einmal das Postgre Tool pgAdmin (click to download). Verbindest Dich dann damit mit Deinem Postgre Server, loggst Dich dort auf Deine Elephant Datenbank ein und guckst Dir mal die Tabellen besagter Datenbank an (unter /Schemas/public/Tables), ob diese überhaupt problemlos gelesen werden können.

      Wenn das problemlos klappt, dann reproduziere bitte nochmal den Crash des Elephants und poste dann das Windows Eventlog hierher (interessant wären dann die Einträge zur Application vor dem eigentlichen Crash).

      Thx,
      L
    • jerome83
      jerome83
      Bronze
      Dabei seit: 31.07.2006 Beiträge: 223
      Hallo Larres,

      ich habe das von dir genannte Programm installiert und mir die Tabellen angesehen. Nichts auffäliges zu erkennen...

      Der Versuch den Crash zu rekonstruieren ist dann leider fehlgeschlagen.
      Grund: Der Elephant läuft auf einmal tadellos. Sowohl das Verbindungsproblem mit der Datenbank als auch das Abstürzen während einer Session haben sich in Luft aufgelöst.

      Keine Ahnung warum aber auf einmal funktioniert alles.

      Ich danke euch für eure Mühen und hoffe ich werde euch in dieser Sache nie mehr kontaktieren müssen ;)

      Viele Grüße und viele Dank.
    • Larres
      Larres
      Bronze
      Dabei seit: 07.09.2009 Beiträge: 2.402
      Okay. Freut mich, dass ich helfen konnte.

      Cheers & close.
      L