Database Critical error



  • Hello,

    While cleaning my C: disk to make more room, i accidentally deleted the content of C:\Users\YourUsername\AppData\Roaming\Hand2Note\h2ndb\base.

    After that i am not able to open H2N cause i am receiving following error...

    System.InvalidOperationException: Failed to open database connection. Please, check your PostgreSQL database settings and reboot your computer. ---> Npgsql.PostgresException: 3D000: database "postgres" does not exist
    at Npgsql.NpgsqlConnector.<DoReadMessage>d__148.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult() at Npgsql.NpgsqlConnector.<ReadMessage>d__147.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Npgsql.NpgsqlConnector.<ReadMessage>d__147.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult()
    at Npgsql.NpgsqlConnector.<Open>d__136.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Npgsql.ConnectorPool.<AllocateLong>d__24.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult() at Npgsql.NpgsqlConnection.<Open>d__28.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Npgsql.NpgsqlConnection.Open() at Common.ConnectionExtensions.Open(ServerConnection sc, String dbName) --- End of inner exception stack trace --- at Common.ConnectionExtensions.Open(ServerConnection sc, String dbName) at Common.ConnectionExtensions.Open(ServerConnection sc) at Common.PgDatabaseHelper.DatabaseExists(String databaseName, ServerConnection sc) at Hand2NoteCore.Loader.<>c.<LoadAsync>b__1_0() at System.Threading.Tasks.Task1.InnerInvoke()
    at System.Threading.Tasks.Task.Execute()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Hand2NoteCore.Loader.<LoadAsync>d__1.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Hand2Note.App.<LoadAsync>d__4.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
    at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
    Inner exception
    Npgsql.PostgresException (0x80004005): 3D000: database "postgres" does not exist
    at Npgsql.NpgsqlConnector.<DoReadMessage>d__148.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult() at Npgsql.NpgsqlConnector.<ReadMessage>d__147.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Npgsql.NpgsqlConnector.<ReadMessage>d__147.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult()
    at Npgsql.NpgsqlConnector.<Open>d__136.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Npgsql.ConnectorPool.<AllocateLong>d__24.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at System.Runtime.CompilerServices.ValueTaskAwaiter`1.GetResult()
    at Npgsql.NpgsqlConnection.<Open>d__28.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Npgsql.NpgsqlConnection.Open()
    at Common.ConnectionExtensions.Open(ServerConnection sc, String dbName)

    How can i fix it? Please help me out with that!

    Thank you



  • keepcalm GLOBAL MODERATOR 23 Apr 2018, 15:11

    Please try to remove the file DbServer.cg that is located in the folder C:\Program Files\Hand2Note\ by default.


    GT-HUD for Hand2Note
    https://progt-pack.com
    alt text
    DYNAMIC HUD (video-preview)
    New Simple HUD (video-preview)
    POPUPs GT-HUD (video-preview)
    SpinFire HUD (video-preview)
    MTT-SNG Pack (video-preview)
    Shaolin HUD for PM
    Available test period for SpinFire HUD/Shaolin HUD
    Contact us:
    Skype: gt-pack
    E-mail: support@progt-pack.com



  • Deleted it but unfortunitely it did not fix the problem. Still getting the same error :(


  • Global Moderator

    In this case, try to proceed with full reinstallation:

    1. Check that you have installed all latest updates for Windows

    2. Remove your database. By default, it is located in the next folder:
      C:\Users\ <YourUsername>\AppData\Roaming\Hand2Note\h2ndb

    3. If you need to save your settings, copy Config and Notes folders in a safe place before uninstalling Hand2Note:
      FAQ. Moving Config

    4. Uninstall Hand2Note. After the uninstallation has finished please delete all files from the install directory (default folder is located in C:\Program Files\Hand2Note).

    5. Install the latest version of Hand2Note for PokerMaster:

    http://hand2note.com/

    1. Register your license key in Configuration->Other Options->License

    Then, run Hand2Note in the default configuration and check whether the issue persists.


Log in to reply
 

Looks like your connection to Hand2Note was lost, please wait while we try to reconnect.