This site uses cookies to improve your browsing experience. By continuing to browse the website, you accept such cookies. For more details and to change your settings, see our Cookie Policy and Privacy Policy. Close

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