report template

    • noel50
      noel50
      Bronze
      Joined: 05.10.2009 Posts: 105
      Registration Date: 08 Jan 2010
      Posts: 30

      Thread Starter









      Report Template




      --------------------------------------------------------------------------------
      PokerStrategy.com Elephant version number: _____
      Please fill in the current version number, e.g. v0.69

      Which operating system:
      ( ) XP
      ( ) Vista
      (x ) Windows 7

      Which poker room:
      ( ) PartyPoker
      (x ) PokerStars
      ( ) Full Tilt Poker
      ( ) iPoker Network (e.g. William Hill Poker, Titan Poker, Mansion Poker, etc.)
      ( ) Everest Poker
      ( ) Others: ______________

      Which game type:
      ( x) Cash Game (NL, PL or FL and which limits?) 2/5c
      ( ) Tourney (which tourney types?)

      Have you searched the FAQ:
      See: FAQ
      (x ) Yes (but the problem isn't listed)
      ( ) No

      Relevant screenshot available:
      ( ) Yes
      (x ) No (a screenshot is irrelevant concerning the problem) dont know how to

      Error messages in the logfile:
      Where can I find the logfile on my computer? See here
      ( ) Yes (Please don't forget to post the logfile's content)
      ( ) No

      In case of problems related to the database:
      Was the PostgreSQL Database Service installed separately?
      ( ) Yes
      ( x) No (the Elephant has installed Postgres)

      Have you read the database section in the FAQ?
      See: here
      ( x) Yes (but the problem isn't listed) have a lot of errors this is new
      ( ) No

      Problem description:
      Please describe the problem and the circumstances of it's occurrences as detailed as possible
      database is not working
      2011-07-17 16:11:50,608 - [1] 78 INFO : -------------------- Launching 'Elephant.exe' (Version: 0.102.40520.2) --------------------
      2011-07-17 16:11:51,669 - [3] 1138 INFO : -------------------- System Info --------------------
      2011-07-17 16:11:51,669 - [3] 1138 INFO : CPU: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz at 2400 Mhz with 4 cores (Intel64 Family 6 Model 15 Stepping 11)
      2011-07-17 16:11:51,669 - [3] 1138 INFO : OS : Microsoft Windows 7 Enterprise (Microsoft Windows NT 6.1.7601 Service Pack 1)
      2011-07-17 16:11:51,669 - [3] 1138 INFO : RAM: 3.00GB
      2011-07-17 16:11:51,669 - [3] 1138 INFO : Culture info: en-US
      2011-07-17 16:11:54,087 - [1] 3556 INFO : -------------------- System Info --------------------
      2011-07-17 16:11:54,087 - [1] 3556 INFO : CPU: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz at 2400 Mhz with 4 cores (Intel64 Family 6 Model 15 Stepping 11)
      2011-07-17 16:11:54,087 - [1] 3556 INFO : OS : Microsoft Windows 7 Enterprise (Microsoft Windows NT 6.1.7601 Service Pack 1)
      2011-07-17 16:11:54,087 - [1] 3556 INFO : RAM: 3.00GB
      2011-07-17 16:11:54,087 - [1] 3556 INFO : Culture info: en-US
      2011-07-17 16:12:07,472 - [1] 16941 ERROR: Exception caught in Boolean PBN.Database.PostgreSQL.InitializeConnection(System.String ByRef)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: FATAL: 3D000: database "elephantdb" does not exist
      - Severity: FATAL
      - Code: 3D000
      - BaseMessage: database "elephantdb" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\init\postinit.c
      - Line: 387
      - Routine: InitPostgres
      - ErrorSql:
      - 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.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      at Npgsql.NpgsqlConnectedState.Startup(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 PBN.Database.PostgreSQL.InitializeConnection(String& in_sBinPath)
      2011-07-17 16:12:07,519 - [1] 16988 ERROR: Exception caught in Boolean PBN.Database.PostgreSQL.InitializeConnection(System.String ByRef)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: FATAL: 3D000: database "elephantdb" does not exist
      - Severity: FATAL
      - Code: 3D000
      - BaseMessage: database "elephantdb" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\init\postinit.c
      - Line: 387
      - Routine: InitPostgres
      - ErrorSql:
      - 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.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      at Npgsql.NpgsqlConnectedState.Startup(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 PBN.Database.PostgreSQL.InitializeConnection(String& in_sBinPath)
      2011-07-17 16:12:14,882 - [1] 24351 INFO : Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache(System.String) took 00:00:00.0566022(00:00:00.0016814/00:00:00.0000718)
      2011-07-17 16:12:17,612 - [1] 27081 WARN : Cannot find the version table - will export schema now.
      -------------------- PS.Common.Database.DatabaseException --------------------
      - Message: could not execute query
      [ SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0 ]
      [SQL: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0]
      - 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.VersionHistoryRepository.GetHighestVersion()
      at PSE.Database.Controller.ElephantDatabaseController.TryUpdateDatabase()
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0 ]
      [SQL: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0]
      - SqlString: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_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 PS.Database.nHibernate.Repositories.VersionHistoryRepository.<>c__DisplayClass4.<GetHighestVersion>b__3()
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- 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_16_0_, this_.Version as Version16_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)
      2011-07-17 16:12:19,047 - [1] 28516 INFO : Installed PostgreSQL version: PostgreSQL 8.3.0, compiled by Visual C++ build 1400
      2011-07-17 16:12:19,063 - [1] 28532 INFO : MainForm.UseDatabase took 00:00:04.2813611
      2011-07-17 16:12:22,617 - [1] 32087 INFO : MainForm.Init - before LoadSettings - 00:00:00.0001509
      2011-07-17 16:12:23,132 - [1] 32602 INFO : MainForm.Init - before StartPatchDatabase - 00:00:00.5105744
      2011-07-17 16:12:23,148 - [1] 32617 INFO : MainForm.Init - before UseDatabase - 00:00:00.5295084
      2011-07-17 16:12:23,241 - [1] 32711 INFO : Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache(System.String) took 00:00:00.0431453(00:00:00.0002408/00:00:00.0000008)
      2011-07-17 16:12:23,257 - [1] 32726 INFO : Installed PostgreSQL version: PostgreSQL 8.3.0, compiled by Visual C++ build 1400
      2011-07-17 16:12:23,257 - [1] 32726 INFO : MainForm.UseDatabase took 00:00:00.1055263
      2011-07-17 16:12:23,257 - [1] 32726 INFO : MainForm.Init - before InitTables - 00:00:00.6392123
      2011-07-17 16:12:23,257 - [1] 32726 INFO : MainForm.Init - before ReadPortalDesc - 00:00:00.6414943
      2011-07-17 16:12:23,834 - [1] 33304 INFO : MainForm.Init - before GenerateExistingPortalsAndPlayersList - 00:00:01.2113691
      2011-07-17 16:12:23,912 - [1] 33382 INFO : MainForm.Init took 00:00:01.2936152
      2011-07-17 16:12:24,224 - [1] 33694 INFO : MainForm._Loaded took 00:00:00.2590420
      2011-07-17 16:12:24,302 - [1] 33772 INFO : Starting background version check...
      2011-07-17 16:12:24,645 - [14] 34115 INFO : Background version check finished.
      Latest Version: 0.102.40520.2
      NewVersionAvail: False
      IgnoreUpdateVersion:

      2011-07-17 16:12:32,009 - [1] 41478 INFO : Initializing shutdown (shutting down controllers).
      2011-07-17 16:12:32,071 - [1] 41540 INFO : Finalising shutdown.
  • 7 replies