Отказано в доступе: невозможно настроить кластер Sandbox InnoDB в Windows 10 с помощью установщика MySQL

  1. Под High Availability я выбрал InnoDB Cluster и выбрали Set Up a Local Server Cluster for Testing Only.

  2. За Cluster Log Verbosity Level я выбрал DEBUG.

  3. В InnoDB Cluster Size был установлен на 3 MySQL Server Sandbox Instances. Я также предоставилMySQL Root Password

  4. Под Authentication Method Я выбрал Use Strong Password Encryption for Authentication.

Под Apply Configuration вот где проблема начинается:

  1. Preparing administrative tools for InnoDB Cluster ПРОШЛО
  2. Deleting existing sandbox innoDB cluster ПРОШЛО
  3. Creating sandbox InnoDB cluster instances ПРОШЛО
  4. Configuring sandbox InnoDB cluster НЕ УДАЛОСЬ
LOG:

Beginning configuration step: Configuring sandbox InnoDB cluster (check the Log tab for details)

Configuring sandbox InnoDB cluster...
Setting up InnoDB cluster...
A new InnoDB cluster will be created on instance 'localhost:3310'.
Validating instance configuration at localhost:3310...
Please note that sandbox instances are only suitable for deploying test clusters for use within the same host.
NOTE: Instance detected as a sandbox.
This instance reports its own address as 127.0.0.1:3310
Instance configuration is suitable.
NOTE: Group Replication will communicate with other members using '127.0.0.1:33101'. Use the localAddress option to override.
Creating InnoDB cluster 'sandboxCluster' on '127.0.0.1:3310'...
Adding Seed Instance...
Cluster successfully created. Use Cluster.addInstance() to add MySQL instances.
At least 3 instances are needed for the cluster to be able to withstand up to
one server failure.
Waiting until seed instance reaches ONLINE status.
Failed to create the InnoDB cluster. Message: Cluster.addInstance: Argument #1: Invalid URI: Illegal character [|] found at position 6 at C:\Users\msode\AppData\Local\Temp\de6f7c87-819f-4428-b049-ea0cdd667508\innodbclusteradmin\bin\ic.js:309:6
Seed instance reached ONLINE status.
in       throw ("Failed to create the InnoDB cluster. Message: " +
Adding instances to the cluster...
         ^
Setting the recovery method to clone.
An error occurred while configuring the sandbox InnoDB cluster.
Deleting the production InnoDB cluster administrative tools temporary directory...
An error occurred trying to dele the InnoDB cluster administrative tools temporary directory after 3 attempts:
The process cannot access the file 'C:\Users\msode\AppData\Local\Temp\de6f7c87-819f-4428-b049-ea0cdd667508\innodbclusteradmin\bin' because it is being used by another process.
Ended configuration step: Configuring sandbox InnoDB cluster (check the Log tab for details)

Две ключевые проблемы (я предполагаю) из приведенного выше ЖУРНАЛА:

1. Failed to create the InnoDB cluster. Message: Cluster.addInstance: Argument #1: Invalid URI: Illegal character [|] found at position 6 at C:\Users\msode\AppData\Local\Temp\de6f7c87-819f-4428-b049-ea0cdd667508\innodbclusteradmin\bin\ic.js:309:6

2. An error occurred trying to dele the InnoDB cluster administrative tools temporary directory after 3 attempts:
The process cannot access the file 'C:\Users\msode\AppData\Local\Temp\de6f7c87-819f-4428-b049-ea0cdd667508\innodbclusteradmin\bin' because it is being used by another process.

Вот что я обнаружил с Process Explorer а также Resource Monitor:

ATTEMPT-1
cmd.exe  >  conhost.exe  >  mysqld.exe (path: Access Denied)

ATTEMPT-2
cmd.exe  >  conhost.exe  >  mysqld.exe (path: Access Denied)

ATTEMPT-3
cmd.exe  >  conhost.exe  >  mysqld.exe (path: Access Denied)

Как я могу исправить эту проблему?

0 ответов

Другие вопросы по тегам