Restore of MySQL da...
 
Notifications
Clear all

Restore of MySQL database not working withg MySQL 8 and 1.4.4

5 Posts
4 Users
0 Reactions
1,921 Views
Posts: 1
Topic starter
(@mikaelkj)
New Member
Joined: 5 years ago

Getting a connection kill error in the SolidCP log: (Have also applied the SQL provider fix for passwords issue, but no difference)

[2/20/2020 10:05:13 AM] ERROR: Cannot drop MySQL connection: KILL 4
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown thread id: 4
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at SolidCP.Providers.Database.MySqlServer.ExecuteNonQuery(String commandText, String connectionString)
   at SolidCP.Providers.Database.MySqlServer.CloseDatabaseConnections(String database)
4 Replies
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

Are you able to preform other MySQL actions fine?

Regards,

Trevor

Reply
Posts: 1
(@mbk7p)
New Member
Joined: 5 years ago

Hi Trevor,

Had to create a new account, the password reset function here seems broken... Just says the reset link is invalid.

Yes, everything else works fine, also backup. So very specific for this function. Seems to get an error when trying to drop connections...

Regards,

Mikael

Reply
Posts: 3
(@inabeel)
New Member
Joined: 4 years ago

Same happening with me. i am trying to install wordpress and getting these errors in my event viewer.
[1/26/2021 10:44:58 AM] ERROR: Cannot drop MySQL connection: KILL 2
System.NullReferenceException: Object reference not set to an instance of an object.
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at SolidCP.Providers.Database.MySqlServer.ExecuteNonQuery(String commandText, String connectionString)
at SolidCP.Providers.Database.MySqlServer.CloseDatabaseConnections(String database)

Reply
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hi Mikael,

Could you please log a bug report at https://github.com/FuseCP/SolidCP/issues/new?assignees=&labels=&template=bug_report.md&title= for this including details of OS etc? We can take a more detailed look into the issue.

Regards,

Trevor

Reply
Share: