[DONE] Ele stürzt bei Import ab

    • Kabummix
      Kabummix
      Bronze
      Dabei seit: 06.07.2009 Beiträge: 52
      PokerStrategy.com Elephant Version: 0.67, 0.69, 0.84
      Betriebssystem:
      (x) XP
      ( ) Vista
      ( ) Windows 7

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

      Problem in FAQ gesucht: (Siehe: hier)
      (x) Ja
      ( ) Nein

      Screenshot vorhanden:
      ( ) Ja
      (x) Nein

      Fehlermeldungen im Logfile vorhanden:
      (Wo finde ich die Log-Datei auf meinem Computer? Siehe: hier)
      (x) Ja
      ( ) Nein

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

      Datenbankproblem-Guide gelesen? (Siehe: hier)
      (x) Ja
      ( ) Nein

      Genaue Problembeschreibung:
      Ich hab jetzt seit ca. 1 Woche das Problem ,dass mein Elephant beim einlesen bzw. anlaysieren von Daten des letzten Tages(inzwischen schon ein paar mehr) einfach stehen bleibt.
      Wenn man dem Ladebalken trauen kann, immer an der gleichen Stelle.

      Ich habs jetzt mit den Versionen 0.67, 0.69 und 0.84 versucht, aber überall das Gleiche.

      Logfile:

      2010-06-30 02:37:17,078 - 1796 (UTC:2010-06-30 00:37:17,078) [1] INFO Welcome Message:
      ---------------------------------------- Launching 'Elephant.exe' (Version: 0.84.1297.2106) ----------------------------------------------------------------------
      2010-06-30 02:37:20,937 - 5656 (UTC:2010-06-30 00:37:20,937) [5] INFO Welcome Message:
      -------------------- System Info --------------------
      CPU: AMD Sempron(tm) 3000+ at 1991 Mhz with 1 cores (x86 Family 6 Model 10 Stepping 0)
      OS : Microsoft Windows XP Home Edition (Microsoft Windows NT 5.1.2600 Service Pack 3)
      RAM: 0.94GB
      Culture info: de-DE

      2010-06-30 02:38:06,265 - 50984 (UTC:2010-06-30 00:38:06,265) [5] ERROR PBNLogger: Exception caught in System.String PokerStrategyElephant.RSSUpdateThread.GetRSSFeed(System.String, Boolean)
      -------------------- System.Xml.XmlException --------------------
      - Message: Root element is missing.
      - LineNumber: 0
      - LinePosition: 0
      - SourceUri:
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Throw(System.Exception)
      - HelpLink: <null>
      - Source: System.Xml
      - InnerException: <null><none>
      - StackTrace:
      at System.Xml.XmlTextReaderImpl.Throw(Exception e)
      at System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res)
      at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
      at System.Xml.XmlTextReaderImpl.Read()
      at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
      at System.Xml.XmlDocument.Load(XmlReader reader)
      at System.Xml.XmlDocument.LoadXml(String xml)
      at PokerStrategyElephant.RSSUpdateThread.GetRSSFeed(String rssURL, Boolean showShortBlog)
      2010-06-30 02:43:44,140 - 388859 (UTC:2010-06-30 00:43:44,140) [1] WARN PokerStrategy.Elephant.NHibernate: Cannot find the version table - will export schema now.
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ SELECT this_.InstallDate as InstallD1_11_0_, this_.Version as Version11_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0 ]
      [SQL: SELECT this_.InstallDate as InstallD1_11_0_, this_.Version as Version11_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0]
      - SqlString: SELECT this_.InstallDate as InstallD1_11_0_, this_.Version as Version11_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0
      - 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[T]()
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.GetElementList(MethodCallExpression call, Int32 count)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.HandleFirstCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.VisitMethodCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.GetResults(MethodCallExpression expr)
      at NHibernate.Linq.Visitors.RootVisitor.HandleImmediateResultsCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.RootVisitor.VisitMethodCall(MethodCallExpression expr)
      at NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateQueryTranslator.TranslateInternal(Expression expression)
      at NHibernate.Linq.Visitors.NHibernateQueryTranslator.Translate(Expression expression, QueryOptions queryOptions)
      at NHibernate.Linq.NHibernateQueryProvider.TranslateExpression(Expression expression)
      at NHibernate.Linq.NHibernateQueryProvider.Execute(Expression expression)
      at NHibernate.Linq.QueryProvider.System.Linq.IQueryProvider.Execute[T](Expression expression)
      at System.Linq.Queryable.First[TSource](IQueryable`1 source)
      at PokerStrategy.Elephant.NHibernate.Repositories.VersionHistoryRepository.GetHighestVersion()
      at PokerStrategy.Elephant.NHibernate.DatabaseMaintenance.TryUpdateDatabase()
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42P01: relation "pse_versionhistory" does not exist
      - Severity: ERROR
      - Code: 42P01
      - BaseMessage: relation "pse_versionhistory" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\catalog\namespace.c
      - Line: 273
      - Routine: RangeVarGetRelid
      - ErrorSql: SELECT this_.InstallDate as InstallD1_11_0_, this_.Version as Version11_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit ((1)::int4)
      - 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:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
      at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
      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)
      2010-06-30 02:51:16,390 - 841109 (UTC:2010-06-30 00:51:16,390) [1] INFO VersionUpdate: Starting background version check...
      2010-06-30 02:51:30,218 - 854937 (UTC:2010-06-30 00:51:30,218) [5] INFO VersionUpdate: Background version check finished.
      Latest Version: 0.76.548.1239
      NewVersionAvail: False
      IgnoreUpdateVersion:

      2010-06-30 02:51:33,421 - 858140 (UTC:2010-06-30 00:51:33,421) [1] ERROR PBNLogger: Exception caught in Int32 PBN.Database.PostgreSQL.ExecuteNonQuery(System.String)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 58P01: could not open relation 1663/16438/17466: No such file or directory
      - Severity: ERROR
      - Code: 58P01
      - BaseMessage: could not open relation 1663/16438/17466: No such file or directory
      - Detail:
      - Hint:
      - Position:
      - Where: SQL statement "DELETE FROM triggstop"
      PL/pgSQL function "deflag_archive" line 1 at EXECUTE statement
      - File: .\src\backend\storage\smgr\md.c
      - Line: 523
      - Routine: mdopen
      - ErrorSql: INSERT INTO triggstop (actiontype) VALUES ('imported')
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteNonQuery()
      at PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      2010-06-30 02:51:33,437 - 858156 (UTC:2010-06-30 00:51:33,437) [1] ERROR PBNLogger:


      Der letzte Abschnitt mit "could not open relation...." wiederholt sich dann in 5-7 minütigem Abstand im Log.
  • 4 Antworten