[DONE] Import-/DB-Problem

    • 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
      (X) 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 kann ich mich ganz bequem in der Datenbank bewegen. NUR: Es werden kein aktuellen Dateien importiert!

      Das Problem taucht seit einem Systemabsturz auf. Vor 2 Tagen ist der Rechner einfach abgeschmiert (bzw. eingefroren woraufhin ich ihn ausgeschaltet habe). Der Elephant und die PokerStars-Software liefen zu dem Zeitpunkt. Beim Hochfahren wollte der Rechner dann eine "Überprüfung" oder ähnliches durchführen, was ich jedoch abgebrochen habe. Nach dem Windowsstart gabs dann irgendeine Fehlermeldung das eine Datei beschädigt sei (irgendwas aus dem PokerStars-Verzeichnis), die Meldung hab ich allerdings nicht mehr im Kopf. Nach einem weiteren Hochfahren inklusive dieser "Überprüfung" beim Windows-Start war die Fehlermeldung weg.

      Aber seidem habe ich das Problem mit dem Elephant. Könnte also vielleicht was mit dem Absturz zu tun haben...

      Hier auch mal der Inhalt der Log-Datei, ich hoffe sehr irgendjemand weiß was damit anzufangen und kann mir helfen. Die geht noch ewig so weiter aber komplett kann ich die hier ja unmöglich posten :-/

      Vielen Dank und viele Grüße.

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







      2011-03-16 17:31:32,470 - 112 (UTC:2011-03-16 16:31:32,470) [1] INFO Welcome Message:
      ---------------------------------------- Launching 'Elephant.exe' (Version: 0.96.31219.2) ----------------------------------------------------------------------
      2011-03-16 17:31:34,135 - 1777 (UTC:2011-03-16 16:31:34,135) [3] INFO Welcome Message:
      -------------------- System Info --------------------
      CPU: AMD Athlon(tm) X2 Dual-Core QL-60 at 1900 Mhz with 2 cores (x64 Family 17 Model 3 Stepping 1)
      OS : Microsoft® Windows Vista™ Home Premium (Microsoft Windows NT 6.0.6002 Service Pack 2)
      RAM: 2.75GB
      Culture info: de-DE

      2011-03-16 17:31:43,784 - 11426 (UTC:2011-03-16 16:31:43,784) [1] INFO Welcome Message:
      -------------------- System Info --------------------
      CPU: AMD Athlon(tm) X2 Dual-Core QL-60 at 1900 Mhz with 2 cores (x64 Family 17 Model 3 Stepping 1)
      OS : Microsoft® Windows Vista™ Home Premium (Microsoft Windows NT 6.0.6002 Service Pack 2)
      RAM: 2.75GB
      Culture info: de-DE

      2011-03-16 17:31:51,615 - 19257 (UTC:2011-03-16 16:31:51,615) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 140085 of relation "playercache"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 140085 of relation "playercache"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT game_type_id, player_id, site_id, dateonly::date, num_players, position FROM playercache
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:51,679 - 19321 (UTC:2011-03-16 16:31:51,679) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 140085 of relation "playercache"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 140085 of relation "playercache"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT game_type_id, player_id, site_id, dateonly::date, num_players, position FROM playercache
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:51,736 - 19378 (UTC:2011-03-16 16:31:51,736) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 140085 of relation "playercache"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 140085 of relation "playercache"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT game_type_id, player_id, site_id, dateonly::date, num_players, position FROM playercache
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:51,799 - 19441 (UTC:2011-03-16 16:31:51,799) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 140085 of relation "playercache"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 140085 of relation "playercache"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT game_type_id, player_id, site_id, dateonly::date, num_players, position FROM playercache
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:51,866 - 19508 (UTC:2011-03-16 16:31:51,866) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 140085 of relation "playercache"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 140085 of relation "playercache"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT game_type_id, player_id, site_id, dateonly::date, num_players, position FROM playercache
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:51,929 - 19571 (UTC:2011-03-16 16:31:51,929) [1] ERROR PBNLogger: Exception caught in Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache()
      -------------------- System.NullReferenceException --------------------
      - Message: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Poker.PlayerCache.PlayerCacheLineCollection GetCache()
      - HelpLink: <null>
      - Source: Elephant.Base
      - InnerException: <null><none>
      - StackTrace:
      bei PokerStrategyElephant.Database.Caching.GetCache()
      2011-03-16 17:31:52,247 - 19889 (UTC:2011-03-16 16:31:52,247) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 1026 of relation "player"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 1026 of relation "player"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT * FROM player ORDER BY player_ID ASC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:53,353 - 20995 (UTC:2011-03-16 16:31:53,353) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 1026 of relation "player"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 1026 of relation "player"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT * FROM player ORDER BY player_ID ASC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:54,633 - 22275 (UTC:2011-03-16 16:31:54,633) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 1026 of relation "player"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 1026 of relation "player"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT * FROM player ORDER BY player_ID ASC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:55,714 - 23356 (UTC:2011-03-16 16:31:55,714) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 1026 of relation "player"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 1026 of relation "player"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT * FROM player ORDER BY player_ID ASC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:31:56,916 - 24558 (UTC:2011-03-16 16:31:56,916) [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 1026 of relation "player"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 1026 of relation "player"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: SELECT * FROM player ORDER BY player_ID ASC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2011-03-16 17:32:02,512 - 30154 (UTC:2011-03-16 16:32:02,512) [1] INFO Welcome Message: Installed PostgreSQL version: PostgreSQL 8.3.0, compiled by Visual C++ build 1400
      2011-03-16 17:32:02,626 - 30268 (UTC:2011-03-16 16:32:02,626) [10] ERROR PokerStrategyElephant: Error reading or interpreting database statistics
      -------------------- PS.Base.Database.DatabaseException --------------------
      - Message: could not execute query
      [ select
      pokerflavour, smallblind, bigblind, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      smallblind, bigblind, pokerflavour; ]
      [SQL: select
      pokerflavour, smallblind, bigblind, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      smallblind, bigblind, pokerflavour;]
      - 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 PokerStrategyElephant.MainForm.<SendDatabaseStatistics>b__41()
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ select
      pokerflavour, smallblind, bigblind, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      smallblind, bigblind, pokerflavour; ]
      [SQL: select
      pokerflavour, smallblind, bigblind, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      smallblind, bigblind, pokerflavour;]
      - SqlString: select
      pokerflavour, smallblind, bigblind, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      smallblind, bigblind, pokerflavour;
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: Npgsql.NpgsqlException<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)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 26320 of relation "pse_hands"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 26320 of relation "pse_hands"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: select
      pokerflavour, smallblind, bigblind, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      smallblind, bigblind, pokerflavour;
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null>1 items
      actual-sql-query - actual-sql-query
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei NHibernate.Driver.NHybridDataReader.Read()
      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)
      2011-03-16 17:32:02,640 - 30282 (UTC:2011-03-16 16:32:02,640) [10] ERROR PokerStrategyElephant: Error reading or interpreting database statistics
      -------------------- PS.Base.Database.DatabaseException --------------------
      - Message: could not execute query
      [ select
      'CashGame', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      pokerroom
      union select
      'Tournament', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype <> 0
      group by
      pokerroom;
      ]
      [SQL: select
      'CashGame', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      pokerroom
      union select
      'Tournament', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype <> 0
      group by
      pokerroom;
      ]
      - 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 PokerStrategyElephant.MainForm.<SendDatabaseStatistics>b__41()
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ select
      'CashGame', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      pokerroom
      union select
      'Tournament', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype <> 0
      group by
      pokerroom;
      ]
      [SQL: select
      'CashGame', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      pokerroom
      union select
      'Tournament', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype <> 0
      group by
      pokerroom;
      ]
      - SqlString: select
      'CashGame', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      pokerroom
      union select
      'Tournament', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype <> 0
      group by
      pokerroom;

      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: Npgsql.NpgsqlException<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)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: XX001: invalid page header in block 26320 of relation "pse_hands"
      - Severity: ERROR
      - Code: XX001
      - BaseMessage: invalid page header in block 26320 of relation "pse_hands"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\storage\buffer\bufmgr.c
      - Line: 309
      - Routine: ReadBuffer_common
      - ErrorSql: select
      'CashGame', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype = 0
      group by
      pokerroom
      union select
      'Tournament', pokerroom, count(*)
      from
      PSE_HANDS
      where
      handidtourneytype <> 0
      group by
      pokerroom;
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null>1 items
      actual-sql-query - actual-sql-query
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei NHibernate.Driver.NHybridDataReader.Read()
      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)
  • 3 Antworten
    • mrk1988
      mrk1988
      Bronze
      Dabei seit: 04.02.2007 Beiträge: 13.337
      Hallo jerome83,

      die Logfile Meldungen deuten auf eine defekte Datenbank hin. "invalid page header..." etc.

      Leg doch mal einfach eine neue Datenbank an und importier dort deine Hände erneut. Damit sollte eigentlich alles wieder klappen. Aktuell ist übrigens Version 0.99 des Elephants.

      Bitte um Feedback ob es mit einer neuen DB klappt.
    • jerome83
      jerome83
      Bronze
      Dabei seit: 31.07.2006 Beiträge: 223
      Original von mrk1988
      Hallo jerome83,

      die Logfile Meldungen deuten auf eine defekte Datenbank hin. "invalid page header..." etc.

      Leg doch mal einfach eine neue Datenbank an und importier dort deine Hände erneut. Damit sollte eigentlich alles wieder klappen. Aktuell ist übrigens Version 0.99 des Elephants.

      Bitte um Feedback ob es mit einer neuen DB klappt.
      Hat geklappt, vielen Dank :-D
    • mrk1988
      mrk1988
      Bronze
      Dabei seit: 04.02.2007 Beiträge: 13.337
      Okay, alles klar =)