Toad World® Forums

Local storage is not available

I am using TDP 5.1 and I am getting error message 'Local storage is not available'. Tried with Setting.xml, renaming folders, re-install TDP etc. Below are the log file comments when I ran TDP from command prompt...can someone please share a solution:

Sorry for using old post but I am also getting 'Local Storage Connection' issue and attaching the log file here...

2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: complete: sp_ui_tag_add.sql
2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: complete: sp_ui_tag_clear.sql
2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: complete: sp_ui_tag_remove.sql
2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: Fail to execute updateHubSchema.sql --> CALL hub_migrate_20140116_1(
2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: 7: Error on rename of '.\hub_information_schema#sql-2ec0_4.frm' to '.\hub_information_schema\hub_object_types.frm' (Errcode: 13 - Permission denied)
2019-11-13 21:19:32Z E HUBGUARDIAN error: HubGuardian.StartGuardian(): Could not get Data Hub connection data
2019-11-13 21:19:32Z thread# 22 D HUBMETAOPERATIONS leaving: HubDatabaseMetaOperations.InitHubEngine(root@localhost)
2019-11-13 21:19:32Z thread# 22 D CreateConnection MySql.Data.MySqlClient.MySqlConnection: Username=root;Password=*****;Connection Timeout=15;Pooling=false;Interactive=true;Treat Tiny As Boolean=false;Allow User Variables=true;Functions Return String=true;Old Guids=true;Server=127.0.0.1;Port=64905;Protocol=socket;CharSet=utf8
2019-11-13 21:19:33Z E PREPROCESS_EXCEPTION Error Message - Unable to connect to any of the specified MySQL hosts.
2019-11-13 21:19:33Z E PREPROCESS_EXCEPTION Error Stack - at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Quest.Toad.CloudDB.CloudDBConnection.OpenInitialTestConnection()
2019-11-13 21:19:33Z E PREPROCESS_EXCEPTION Error Message - There was a connect error. Check that the server, username, password and port are correct, that you have registered this user using the registration tab, and that the registered user has not been disabled
2019-11-13 21:19:33Z E PREPROCESS_EXCEPTION Error Stack - at Quest.Toad.CloudDB.CloudDBConnection.OpenInitialTestConnection()
at Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()

First thought in my mind is that you have anti-virus application installed and the application blocks the rename.

Please note that such security programs do not actually purposely prohibit access to the files MySQL creates. Instead, when security programs check files changes on system, they need to lock them. If we try to rename the locked file, will get permission denied.

Solutions would be:

  1. Disable real-time scanning for anti-virus application, not recommended
  2. Add directory or file exclusions in anti-virus application
  • Directory exclusions: C:\Users<user>\AppData\Local\Quest Software\Toad Data Point Hub Data\data\
  • File exclusions: C:\Users<user>\AppData\Local\Quest Software\Toad Data Point Hub Data\data\**\*.frm

Thanks but this did not resolve the issue. Any other thought?

And did you try to run Toad as Administrator? It looks like to me as there is some issue with access / privileges when we try to start Local Storage.
Did you ever tried some of our previous version? Would be great if you can confirm us you have a same issue.

If you try to connect to Local Storage Connection multiple times, will you get the error in same place which is to rename a temp file to '.\hub_information_schema*hub_object_types.frm*'? If it's security application blocks the action, you probably would get the error in different places.

Another simple way to test permission issue is you create a file under the location and try to rename it manually.

If you can manually rename it, then your account should have enough permission, something else is blocking the rename action when connecting to Local Storage. Otherwise your account does not have permission to rename.