Elephant crash

    • ghanisha
      ghanisha
      Bronze
      Joined: 04.07.2011 Posts: 208
      Hi.
      I have installed Elephant for a while now but I have still not been able to use it in my poker room, William Hill. Sometimes, when I open the application, it is able to import the hand histories from my poker room, and I can see a few stats and graphs, but every time I try to use it at a cash table, I get the message that "stats will appear soon", but as soon as a hand is played and Elephant tries to enter it in the database, I get an Elephant error, saying it can't insert, and then it crashes (this application needs to close message). In the logs it says something about not connecting to 127.0.0.1, but it is different than the error that appear to other users, believe me I have read all the other topics and tried all the solutions offered, including reinstalling the database, checking if it's running, etc.

      I will copy a part of my Elephant log (I don't know if you can attach files),maybe it will be of some help. Thank you.

      the first part, when I launch it: "
      2011-07-28 12:46:33,343 - [1] 437 INFO : -------------------- Launching 'Elephant.exe' (Version: 0.103.40707.3) --------------------
      2011-07-28 12:46:40,359 - [1] 7453 INFO : -------------------- System Info --------------------
      2011-07-28 12:46:40,359 - [1] 7453 INFO : CPU: Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz at 1800 Mhz with 2 cores (x86 Family 6 Model 15 Stepping 2)
      2011-07-28 12:46:40,359 - [1] 7453 INFO : OS : Microsoft Windows XP Professional (Microsoft Windows NT 5.1.2600 Service Pack 3)
      2011-07-28 12:46:40,359 - [1] 7453 INFO : RAM: 3.25GB
      2011-07-28 12:46:40,359 - [1] 7453 INFO : Culture info: en-US
      2011-07-28 12:46:57,015 - [1] 24109 INFO : MainForm.Init - before LoadSettings - 00:00:00.0003284
      2011-07-28 12:47:09,250 - [1] 36343 INFO : MainForm.Init - before StartPatchDatabase - 00:00:12.2343755
      2011-07-28 12:47:09,890 - [1] 36984 INFO : MainForm.Init - before UseDatabase - 00:00:12.8672356
      2011-07-28 12:47:10,765 - [1] 37859 INFO : Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache(System.String) took 00:00:00.4863859(00:00:00.1859317/00:00:00.1508823)
      2011-07-28 12:47:25,000 - [1] 52093 INFO : Installed PostgreSQL version: PostgreSQL 8.3.0, compiled by Visual C++ build 1400
      2011-07-28 12:47:25,000 - [1] 52093 INFO : MainForm.UseDatabase took 00:00:15.1080364
      2011-07-28 12:47:25,000 - [1] 52093 INFO : MainForm.Init - before InitTables - 00:00:27.9826937
      2011-07-28 12:47:25,000 - [1] 52093 INFO : MainForm.Init - before ReadPortalDesc - 00:00:27.9839760
      2011-07-28 12:47:32,078 - [1] 59171 INFO : MainForm.Init - before GenerateExistingPortalsAndPlayersList - 00:00:35.0638109
      2011-07-28 12:47:32,203 - [1] 59296 INFO : MainForm.Init took 00:00:35.1923010
      2011-07-28 12:47:33,234 - [11] 60328 ERROR: Found lobby window: 'william hill poker: nickname: ghanisha | players: 6443 | tables: 1308 | tournaments: 310'
      2011-07-28 12:47:33,781 - [4] 60875 ERROR: Exception caught in System.Collections.Generic.IEnumerable`1[PS.Poker.IHand] PS.Database.nHibernate.Repositories.HandRepository.GetLastUnprocessedHands(NHibernate.ISession, Int32)
      -------------------- PS.Common.Database.DatabaseException --------------------
      - Message: could not execute query
      [ SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc ]
      Positional parameters: #0>Analysed
      [SQL: SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Common.Database
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      at PS.Database.nHibernate.Repositories.HandRepositoryCore.GetLastUnprocessedHands(ISession session, Int32 handcount)
      at PS.Database.nHibernate.Repositories.HandRepository.GetLastUnprocessedHands(ISession session, Int32 handcount)
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc ]
      Positional parameters: #0>Analysed
      [SQL: SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc]
      - SqlString: SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: Npgsql.NpgsqlException<none>
      - StackTrace:
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
      at NHibernate.Impl.CriteriaImpl.List(IList results)
      at NHibernate.Impl.CriteriaImpl.List()
      at NHibernate.Linq.CriteriaResultReader`1.List()
      at NHibernate.Linq.CriteriaResultReader`1.<GetEnumerator>d__0.MoveNext()
      at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
      at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
      at PS.Database.nHibernate.Repositories.HandRepositoryCore.<>c__DisplayClass7.<GetLastUnprocessedHands>b__6()
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Severity:
      - Code:
      - BaseMessage: Failed to establish a connection to '127.0.0.1'.
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File:
      - Line:
      - Routine:
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: System.Exception<none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at NHibernate.Connection.DriverConnectionProvider.GetConnection()
      at NHibernate.AdoNet.ConnectionManager.GetConnection()
      at NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd)
      at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
      at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
      at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      -------------------- System.Exception --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      2011-07-28 12:47:34,468 - [4] 61562 ERROR: An error occurred while accessing the nHibernate repositories.
      -------------------- PS.Common.Database.DatabaseException --------------------
      - Message: could not execute query
      [ SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc ]
      Positional parameters: #0>Analysed
      [SQL: SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Common.Database
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      at PS.Database.nHibernate.Repositories.HandRepositoryCore.GetLastUnprocessedHands(ISession session, Int32 handcount)
      at PS.Database.nHibernate.Repositories.HandRepository.GetLastUnprocessedHands(ISession session, Int32 handcount)
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc ]
      Positional parameters: #0>Analysed
      [SQL: SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc]
      - SqlString: SELECT this_.UniqueHandId as UniqueHa1_12_0_, this_.HandId as HandId12_0_, this_.PokerRoom as PokerRoom12_0_, this_.HandIDLimit as HandIDLi4_12_0_, this_.HandIDTourneyType as HandIDTo5_12_0_, this_.FlopCardsString as FlopCard6_12_0_, this_.HandCurrency as HandCurr7_12_0_, this_.ActionCurrency as ActionCu8_12_0_, this_.TableName as TableName12_0_, this_.TableType as TableType12_0_, this_.PlayDate as PlayDate12_0_, this_.MissingSmallBlind as Missing12_12_0_, this_.PokerFlavour as PokerFl13_12_0_, this_.GameLimit as GameLimit12_0_, this_.TourneyKind as Tourney15_12_0_, this_.BigBlind as BigBlind12_0_, this_.SmallBlind as SmallBlind12_0_, this_.Antes as Antes12_0_, this_.BigBet as BigBet12_0_, this_.SmallBet as SmallBet12_0_, this_.HandHistory as HandHis21_12_0_, this_.Pot as Pot12_0_, this_.Rake as Rake12_0_, this_.HasShowdown as HasShow24_12_0_, this_.TurnString as TurnString12_0_, this_.RiverString as RiverSt26_12_0_, this_.Hero as Hero12_0_, this_.Button as Button12_0_, this_.TableSize as TableSize12_0_, this_.HighestPlayerSeatNumber as Highest30_12_0_, this_.ProcessState as Process31_12_0_, this_.TourneyId as TourneyId12_0_, this_.HeroAmountWon_amount as HeroAmo33_12_0_, this_.HeroAmountWon_currency as HeroAmo34_12_0_, this_.HeroHasSeenFlop as HeroHas35_12_0_, this_.PlayerCount as PlayerC36_12_0_ FROM PSE_Hands this_ WHERE not (this_.ProcessState = ?) ORDER BY this_.PlayDate desc
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: Npgsql.NpgsqlException<none>
      - StackTrace:
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
      at NHibernate.Impl.CriteriaImpl.List(IList results)
      at NHibernate.Impl.CriteriaImpl.List()
      at NHibernate.Linq.CriteriaResultReader`1.List()
      at NHibernate.Linq.CriteriaResultReader`1.<GetEnumerator>d__0.MoveNext()
      at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
      at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
      at PS.Database.nHibernate.Repositories.HandRepositoryCore.<>c__DisplayClass7.<GetLastUnprocessedHands>b__6()
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Severity:
      - Code:
      - BaseMessage: Failed to establish a connection to '127.0.0.1'.
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File:
      - Line:
      - Routine:
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: System.Exception<none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at NHibernate.Connection.DriverConnectionProvider.GetConnection()
      at NHibernate.AdoNet.ConnectionManager.GetConnection()
      at NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd)
      at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
      at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
      at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      -------------------- System.Exception --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      2011-07-28 12:47:35,062 - [9] 62156 ERROR: Exception caught in Int32 PS.Database.nHibernate.Repositories.HandRepository.GetLastUnprocessedHandCount(NHibernate.ISession)
      -------------------- PS.Common.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.Common.Database
      - InnerException: PS.Common.Database.DatabaseException<none>
      - StackTrace:
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      at PS.Database.nHibernate.Repositories.HandRepositoryCore.GetLastUnprocessedHandCount(ISession session)
      at PS.Database.nHibernate.Repositories.HandRepository.GetLastUnprocessedHandCount(ISession session)
      -------------------- PS.Common.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.Common.Database
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      at PS.Database.nHibernate.SessionLayer.ExecuteSqlQuery(String sqlQuery)
      at PS.Database.nHibernate.Repositories.HandRepositoryCore.<>c__DisplayClassa.<GetLastUnprocessedHandCount>b__9()
      at PS.Common.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: Npgsql.NpgsqlException<none>
      - StackTrace:
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
      at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
      at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters)
      at NHibernate.Impl.SqlQueryImpl.List()
      at PS.Database.nHibernate.SessionLayer.<>c__DisplayClass1.<ExecuteSqlQuery>b__0()
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Severity:
      - Code:
      - BaseMessage: Failed to establish a connection to '127.0.0.1'.
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File:
      - Line:
      - Routine:
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: System.Exception<none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at NHibernate.Connection.DriverConnectionProvider.GetConnection()
      at NHibernate.AdoNet.ConnectionManager.GetConnection()
      at NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd)
      at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
      at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
      at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      -------------------- System.Exception --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)"

      It continues a while like this, then when I open a cash table, this is a log from yesterday because today it crashes before getting to that part: "

      2011-07-27 11:43:21,234 - [1] 187 INFO : -------------------- Launching 'Elephant.exe' (Version: 0.103.40707.3) --------------------
      2011-07-27 11:43:23,171 - [3] 2125 INFO : -------------------- System Info --------------------
      2011-07-27 11:43:23,187 - [3] 2140 INFO : CPU: Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz at 1799 Mhz with 2 cores (x86 Family 6 Model 15 Stepping 2)
      2011-07-27 11:43:23,187 - [3] 2140 INFO : OS : Microsoft Windows XP Professional (Microsoft Windows NT 5.1.2600 Service Pack 3)
      2011-07-27 11:43:23,187 - [3] 2140 INFO : RAM: 3.25GB
      2011-07-27 11:43:23,187 - [3] 2140 INFO : Culture info: en-US
      2011-07-27 11:43:25,421 - [1] 4375 INFO : -------------------- System Info --------------------
      2011-07-27 11:43:25,421 - [1] 4375 INFO : CPU: Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz at 1799 Mhz with 2 cores (x86 Family 6 Model 15 Stepping 2)
      2011-07-27 11:43:25,421 - [1] 4375 INFO : OS : Microsoft Windows XP Professional (Microsoft Windows NT 5.1.2600 Service Pack 3)
      2011-07-27 11:43:25,421 - [1] 4375 INFO : RAM: 3.25GB
      2011-07-27 11:43:25,421 - [1] 4375 INFO : Culture info: en-US
      2011-07-27 11:43:33,593 - [1] 12546 INFO : MainForm.Init - before LoadSettings - 00:00:00.0002799
      2011-07-27 11:43:37,968 - [1] 16921 INFO : MainForm.Init - before StartPatchDatabase - 00:00:04.3742581
      2011-07-27 11:43:38,687 - [1] 17640 INFO : MainForm.Init - before UseDatabase - 00:00:05.1012734
      2011-07-27 11:43:41,015 - [1] 19968 INFO : Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache(System.String) took 00:00:01.9648091(00:00:00.2774803/00:00:00.1210904)
      2011-07-27 11:43:52,437 - [1] 31390 INFO : Installed PostgreSQL version: PostgreSQL 8.3.0, compiled by Visual C++ build 1400
      2011-07-27 11:43:52,437 - [1] 31390 INFO : MainForm.UseDatabase took 00:00:13.7414034
      2011-07-27 11:43:52,437 - [1] 31390 INFO : MainForm.Init - before InitTables - 00:00:18.8525032
      2011-07-27 11:43:52,437 - [1] 31390 INFO : MainForm.Init - before ReadPortalDesc - 00:00:18.8537760
      2011-07-27 11:43:55,765 - [1] 34718 INFO : MainForm.Init - before GenerateExistingPortalsAndPlayersList - 00:00:22.1722418
      2011-07-27 11:43:56,015 - [1] 34968 INFO : MainForm.Init took 00:00:22.4224097
      2011-07-27 11:44:00,703 - [1] 39656 INFO : MainForm._Loaded took 00:00:04.4478793
      2011-07-27 11:44:00,703 - [1] 39656 INFO : Starting background version check...
      2011-07-27 11:44:02,234 - [13] 41187 INFO : Background version check finished.
      Latest Version: 0.102.40520.2
      NewVersionAvail: False
      IgnoreUpdateVersion:

      2011-07-27 11:44:26,000 - [11] 64953 ERROR: Error in Void PokerStrategyElephant.Hud.HudClient.UpdateTableList(System.Diagnostics.Process[])
      2011-07-27 11:44:26,031 - [11] 64984 ERROR: No lobby window found!
      2011-07-27 11:44:26,234 - [11] 65187 ERROR: Error in Void PokerStrategyElephant.Hud.HudClient.UpdateTableList(System.Diagnostics.Process[])
      2011-07-27 11:44:26,234 - [11] 65187 ERROR: No lobby window found!
      2011-07-27 11:44:26,437 - [11] 65390 ERROR: Error in Void PokerStrategyElephant.Hud.HudClient.UpdateTableList(System.Diagnostics.Process[])
      2011-07-27 11:44:26,437 - [11] 65390 ERROR: No lobby window found!
      2011-07-27 11:44:27,562 - [11] 66515 ERROR: No lobby window found!
      2011-07-27 11:44:27,562 - [11] 66515 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:28,593 - [11] 67546 ERROR: No lobby window found!
      2011-07-27 11:44:28,593 - [11] 67546 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:29,609 - [11] 68562 ERROR: No lobby window found!
      2011-07-27 11:44:29,609 - [11] 68562 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:30,640 - [11] 69593 ERROR: No lobby window found!
      2011-07-27 11:44:30,640 - [11] 69593 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:31,656 - [11] 70609 ERROR: No lobby window found!
      2011-07-27 11:44:31,656 - [11] 70609 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:32,687 - [11] 71640 ERROR: No lobby window found!
      2011-07-27 11:44:32,687 - [11] 71640 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:33,703 - [11] 72656 ERROR: No lobby window found!
      2011-07-27 11:44:33,703 - [11] 72656 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:34,734 - [11] 73687 ERROR: No lobby window found!
      2011-07-27 11:44:34,734 - [11] 73687 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:35,750 - [11] 74703 ERROR: No lobby window found!
      2011-07-27 11:44:35,750 - [11] 74703 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:36,781 - [11] 75734 ERROR: No lobby window found!
      2011-07-27 11:44:36,781 - [11] 75734 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:37,796 - [11] 76750 ERROR: No lobby window found!
      2011-07-27 11:44:37,812 - [11] 76765 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:38,828 - [11] 77781 ERROR: No lobby window found!
      2011-07-27 11:44:38,828 - [11] 77781 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:39,859 - [11] 78812 ERROR: No lobby window found!
      2011-07-27 11:44:39,859 - [11] 78812 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:40,875 - [11] 79828 ERROR: No lobby window found!
      2011-07-27 11:44:40,875 - [11] 79828 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:41,906 - [11] 80859 ERROR: No lobby window found!
      2011-07-27 11:44:41,906 - [11] 80859 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:42,921 - [11] 81875 ERROR: No lobby window found!
      2011-07-27 11:44:42,921 - [11] 81875 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:43,953 - [11] 82906 ERROR: No lobby window found!
      2011-07-27 11:44:43,953 - [11] 82906 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:44,968 - [11] 83921 ERROR: No lobby window found!
      2011-07-27 11:44:44,968 - [11] 83921 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:46,000 - [11] 84953 ERROR: No lobby window found!
      2011-07-27 11:44:46,000 - [11] 84953 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:47,015 - [11] 85968 ERROR: No lobby window found!
      2011-07-27 11:44:47,015 - [11] 85968 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:48,046 - [11] 87000 ERROR: No lobby window found!
      2011-07-27 11:44:48,046 - [11] 87000 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:49,078 - [11] 88031 ERROR: No lobby window found!
      2011-07-27 11:44:49,078 - [11] 88031 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:50,093 - [11] 89046 ERROR: No lobby window found!
      2011-07-27 11:44:50,093 - [11] 89046 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:51,203 - [11] 90156 ERROR: No lobby window found!
      2011-07-27 11:44:51,203 - [11] 90156 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:52,234 - [11] 91187 ERROR: No lobby window found!
      2011-07-27 11:44:52,250 - [11] 91203 ERROR: Failed to GetLobbyWindowHandle(process.Id) with PID <1212> (D:\work\poker\William Hill Poker\casino.exe)!
      The HUD will not be shown
      2011-07-27 11:44:53,296 - [11] 92250 ERROR: Found lobby window: 'william hill poker: players: 5272 | tables: 1132 | tournaments: 221'
      2011-07-27 11:49:47,890 - [7] 386843 ERROR: Found lobby window: 'william hill poker: nickname: ghanisha | players: 5369 | tables: 1156 | tournaments: 222'
      2011-07-27 11:55:02,859 - [3] 701812 ERROR: Exception caught in System.Collections.Generic.IList`1[System.String] PS.Database.nHibernate.Repositories.HandRepository.GetDuplicateUniqueIds(System.Collections.Generic.IEnumerable`1[PS.Poker.IHand])
      -------------------- PS.Common.Database.DatabaseException --------------------
      - Message: could not execute query
      [ SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' )) ]
      [SQL: SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' ))]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Common.Database
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      at PS.Database.nHibernate.SessionLayer.ExecuteSqlQuery[T](String sqlQuery)
      at PS.Database.nHibernate.Repositories.HandRepositoryCore.GetDuplicateUniqueIds(IEnumerable`1 handsToCheck)
      at PS.Database.nHibernate.Repositories.HandRepository.GetDuplicateUniqueIds(IEnumerable`1 handsToCheck)
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' )) ]
      [SQL: SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' ))]
      - SqlString: SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' ))
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: Npgsql.NpgsqlException<none>
      - StackTrace:
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
      at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
      at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters)
      at NHibernate.Impl.SqlQueryImpl.List[T]()
      at PS.Database.nHibernate.SessionLayer.<>c__DisplayClass4`1.<ExecuteSqlQuery>b__3()
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Severity:
      - Code:
      - BaseMessage: Failed to establish a connection to '127.0.0.1'.
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File:
      - Line:
      - Routine:
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: System.Exception<none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at NHibernate.Connection.DriverConnectionProvider.GetConnection()
      at NHibernate.AdoNet.ConnectionManager.GetConnection()
      at NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd)
      at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
      at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
      at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      -------------------- System.Exception --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      2011-07-27 11:55:02,937 - [3] 701890 ERROR: An error occurred while accessing the nHibernate repositories.
      -------------------- PS.Common.Database.DatabaseException --------------------
      - Message: could not execute query
      [ SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' )) ]
      [SQL: SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' ))]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Common.Database
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      at PS.Database.nHibernate.SessionLayer.ExecuteSqlQuery[T](String sqlQuery)
      at PS.Database.nHibernate.Repositories.HandRepositoryCore.GetDuplicateUniqueIds(IEnumerable`1 handsToCheck)
      at PS.Database.nHibernate.Repositories.HandRepository.GetDuplicateUniqueIds(IEnumerable`1 handsToCheck)
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' )) ]
      [SQL: SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' ))]
      - SqlString: SELECT uniquehandid from pse_hands WHERE (pokerRoom=4 and handid IN ( '2862615751' ))
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: Npgsql.NpgsqlException<none>
      - StackTrace:
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)
      at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)
      at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters)
      at NHibernate.Impl.SqlQueryImpl.List[T]()
      at PS.Database.nHibernate.SessionLayer.<>c__DisplayClass4`1.<ExecuteSqlQuery>b__3()
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Severity:
      - Code:
      - BaseMessage: Failed to establish a connection to '127.0.0.1'.
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File:
      - Line:
      - Routine:
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: System.Exception<none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at NHibernate.Connection.DriverConnectionProvider.GetConnection()
      at NHibernate.AdoNet.ConnectionManager.GetConnection()
      at NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd)
      at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
      at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
      at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      -------------------- System.Exception --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      2011-07-27 11:55:04,453 - [10] 703406 ERROR: Error retrieving database summary stats in Void PS.nHibernate.Extensions.TourneyOverviewStatsSummaryExtension.RefreshFromDatabase(PS.Poker.Tournament.TourneyOverviewStatsSummary)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Severity:
      - Code:
      - BaseMessage: Failed to establish a connection to '127.0.0.1'.
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File:
      - Line:
      - Routine:
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: System.Exception<none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at PS.nHibernate.Extensions.TourneyOverviewStatsSummaryExtension.RefreshFromDatabase(TourneyOverviewStatsSummary me)
      -------------------- System.Exception --------------------
      - Message: Failed to establish a connection to '127.0.0.1'.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Open(Npgsql.NpgsqlConnector)
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context)"
  • 3 replies
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi ghanisha,

      please have a look at the thread Solution for: "failed to establish a connection to '127.0.0.1' ".

      Thx,
      L
    • ghanisha
      ghanisha
      Bronze
      Joined: 04.07.2011 Posts: 208
      Hi, thank you for your response. As I said before, I have read that whole thread and others that seemed similar and tried all the solutions offered.

      But, I said that I should try again to uninstall Elephant and PostGres and delete all traces after uninstall, then do another fresh install of everything. The install went smoothly, I was able to install Postgres together with Elephant, and the setup said the database was created successfully.

      But, as soon as I launched Elephant, I got a database error message, that some insert or select had failed. I checked if it was importing my hand history and it was, it took a few hours to do it (I don't know why it was so slow).

      I opened my poker rooms, sat for a while at some tables, nothing was happening except for the message "not enough hands". After a while it stopped importing hands and the hands at the tables i was playing had the status "pending" for import, but none of them were running. I decided to restart Elephant, and, after a while, I started to see the stats at the tables. I was very happy, but, unfortunately, this did not last long. After a while Elephant crashed, like it did before. I restarted it and it crashed again, after an even shorter while.

      I don't know what to think. If the stats appear for a while it's clear that Elephant is able to make a connection, and then something happens that severs the connection and makes Elephant crash.

      I really have given up hope to find a solution. I am only posting this in the hope that it will be useful to someone. I will probably look for another HUD that I hope will work on William Hill. Thanks for your time!
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi ghanisha,

      is your connection issue with the database has been solved or not? We could have our database specialist contacting you.

      And in order to set up the auto import and cash game HUD on William Hill correctly please consider the following:

      - Run your poker client and the PokerStrategy.com Elephant with administrator privileges.
      - Set up your poker client to instantly save the Hand Histories locally.
      - Save the Hand Histories in English.
      - Make sure the path of your locally saved Hand Histories is listed at the Elephant's Configuration page and the folder's import state is set to 'active'.
      - Make sure your poker room screenname is listed properly at PokerStrategy.com Elephant's portal settings (to be found at Cash Game & Settings/Sites). Please note the William Hill aliases are listed there at 'Titan Poker' (the oldest supported iPoker client).
      - Make sure the HUD itself is 'activated' (to be checked at Cash Game & Settings/HUD/Settings) and the minimum handcount required to display stats is set to a resonable value (e.g. '1', not to high!).

      And finally, if it's still not working smoothly: Check the import status and possible errors on Elephant's import page.

      Thx,
      L