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.ValueTaskAwaiter
1.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.Task
1.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.ValueTaskAwaiter
1.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
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 :(
-
In this case, try to proceed with full reinstallation:
-
Check that you have installed all latest updates for Windows
-
Remove your database. By default, it is located in the next folder:
C:\Users\ <YourUsername>\AppData\Roaming\Hand2Note\h2ndb -
If you need to save your settings, copy Config and Notes folders in a safe place before uninstalling Hand2Note:
FAQ. Moving Config -
Uninstall Hand2Note. After the uninstallation has finished please delete all files from the install directory (default folder is located in C:\Program Files\Hand2Note).
-
Install the latest version of Hand2Note for PokerMaster:
- Register your license key in Configuration->Other Options->License
Then, run Hand2Note in the default configuration and check whether the issue persists.
-