Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add new mysql instance #177

Open
lukasz-borek opened this issue May 23, 2024 · 0 comments
Open

Add new mysql instance #177

lukasz-borek opened this issue May 23, 2024 · 0 comments

Comments

@lukasz-borek
Copy link

We are trying to create mysql instance @ 11.32 commserve:

>>> restore_from = 'a-o0'
>>> client_to_restore = commcell.clients.get(restore_from)
>>> agent = client.agents.get('mysql')
>>> print(agent)
"Mysql" Agent instance for Client: "a-o0"
>>> inst = agent.instances
>>> print(inst)
S. No.	      Instance      	       Agent        	       Client

  1  	a-o0_3306           	mysql               	a-o0
  2  	a-o0_3307           	mysql               	a-o0
>>> database_options = {'storage_policy': 'MYSQL_DATA_SP',
...                    'port': 'a-o0:3307',
...                    'mysql_user_name':'root',
...                    'mysql_password':'bbbbbb',
...                    'binary_directory':'/usr/bin',
...                    'config_file':'/etc/mysql/my_myrestore.cnf',
...                    'log_data_directory':'/data/my/myrestore/binlogs',
...                    'data_directory':'/data/my/myrestore/dane',
...                    'version': '8.0.36-28'
...                   }
>>> inst.add_mysql_instance(instance_name='testtt', database_options=database_options)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "~/venv/lib/python3.12/site-packages/cvpysdk/instance.py", line 1623, in add_mysql_instance
    self._process_add_response(request_json)
  File "~/venv/lib/python3.12/site-packages/cvpysdk/instance.py", line 418, in _process_add_response
    raise SDKException('Response', '101', self._update_response_(response.text))
cvpysdk.exception.SDKException: Response was not success
}subclientId":0,"clientId":461,"instanceName":"testtt","instanceId":-1,"_type_":0"entity":{

From WebServier.log :

0208 403   05/23 21:39:05 403   - WEBAPI-STARTED processing [POST]:[/Instance] request. : /Instance : AdditionalInfo[ ConsoleType[PythonSDK]]
**30208 403   05/23 21:39:05 403  CreateInstance - request handling interrupted : ['CV.WebServer.Handlers.HandlerException: XML error: please refer to logs for more details.**
   at CV.WebServer.Handlers.CVWebHandlerInstance.CreateInstance(CreateInstanceRequest req, Int32 userId, Int32 localeId)
   at CV.WebServer.Controllers.InstanceController.CreateInstance(CreateInstanceRequest req)
   at lambda_method381(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---

What we're doing wrong?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant