I can't make a new one MySQL server commServer Version 11.28.79, error in processing message. Please check evmgrs.log for more details

  • 14 September 2023
  • 9 replies
  • 121 views

Badge +2

I can't make a new one MySQL server commServer Version 11.28.79, error in processing message. Please check evmgrs.log for more details


9 replies

Badge +2

I can't make a new one MySQL server commServer Version 11.28.79, error in processing message. Please check evmgrs.log for more details.

Userlevel 4
Badge +11

Hi Damião,

Have you checked the EvMgrS.log (located within the “Log Files” folder) file at the time of the error appearing in the GUI?

It will hopefully give some additional hints of what the issue might be.

Badge +2

EvMgrS.log

5248  2588  09/15 07:50:12 ### ServerManagerInvoker::Invoke() - Response received from remote host [<?xml version="1.0" encoding="UTF-8" standalone="no" ?><Workflow_WorkflowCompletionResponse contextId="00b0b802-1bc0-45a1-89e8-99cd7b531c1b" endTime="1694775012" errorCode="10" errorMessage="failed to execute database query, please check workflow engine log for more details" jobId="0" outputs="&lt;outputs>&lt;returnCode />&lt;returnString />&lt;outputXML />&lt;/outputs>" startTime="1694775012" status="10" statusCode="0" version="1"><workflow workflowId="146" workflowName="Assign Storage Policy in New Database Instance Creation"/></Workflow_WorkflowCompletionResponse>]
5248  2588  09/15 07:50:12 ### WorkflowControler::SendAnyWorkflowRequest() - clientId=[2], returnCode=[0]
5248  2588  09/15 07:50:12 ### BusinessLogicWorkflow::AnalyzeResponse() - Error: Messagehandler workflow[Assign Storage Policy in New Database Instance Creation] failed to complete, workflow engine error Code [10]
5248  22d0  09/15 07:50:14 ### processMessgeOnSocket() - INFO: Dropping the socket [0x00000000000015D4] due to communications problem, errno[0], bytesAvailable[0].
5248  2b28  09/15 07:53:02 ### DBBase-SQL() - dbcursors.cpp:300, Warning: Stored Procedure Procedure CTClientPropertiesLoading exceeded threshold time of 10, time taken: 41, Debug: [,0,0,0,'',1,1]
5248  2584  09/15 07:53:50 ### ServerManagerInvoker::Invoke() - Response received from remote host [<?xml version="1.0" encoding="UTF-8" standalone="no" ?><Workflow_WorkflowCompletionResponse contextId="7a72518f-4bbb-449a-96d4-950df7fbf536" endTime="1694775230" errorCode="10" errorMessage="failed to execute database query, please check workflow engine log for more details" jobId="0" outputs="&lt;outputs>&lt;returnCode />&lt;returnString />&lt;outputXML />&lt;/outputs>" startTime="1694775229" status="10" statusCode="0" version="1"><workflow workflowId="146" workflowName="Assign Storage Policy in New Database Instance Creation"/></Workflow_WorkflowCompletionResponse>]
5248  2584  09/15 07:53:50 ### WorkflowControler::SendAnyWorkflowRequest() - clientId=[2], returnCode=[0]
5248  2584  09/15 07:53:50 ### BusinessLogicWorkflow::AnalyzeResponse() - Error: Messagehandler workflow[Assign Storage Policy in New Database Instance Creation] failed to complete, workflow engine error Code [10]
5248  2bb8  09/15 07:54:27 ### EvAppPlan::ProcessDeletionPendingPlan() - Abandoned plan items deletion status: no abandoned entities found.
5248  2580  09/15 07:54:46 ### ServerManagerInvoker::Invoke() - Response received from remote host [<?xml version="1.0" encoding="UTF-8" standalone="no" ?><Workflow_WorkflowCompletionResponse contextId="4c7be6a0-5692-4ab0-b2bc-ae94c5751bea" endTime="1694775286" errorCode="10" errorMessage="failed to execute database query, please check workflow engine log for more details" jobId="0" outputs="&lt;outputs>&lt;returnCode />&lt;returnString />&lt;outputXML />&lt;/outputs>" startTime="1694775286" status="10" statusCode="0" version="1"><workflow workflowId="146" workflowName="Assign Storage Policy in New Database Instance Creation"/></Workflow_WorkflowCompletionResponse>]
5248  2580  09/15 07:54:46 ### WorkflowControler::SendAnyWorkflowRequest() - clientId=[2], returnCode=[0]
5248  2580  09/15 07:54:46 ### BusinessLogicWorkflow::AnalyzeResponse() - Error: Messagehandler workflow[Assign Storage Policy in New Database Instance Creation] failed to complete, workflow engine error Code [10]
5248  608   09/15 07:54:49 ### CWorkQueueAdmin::ProcessWildcardDIP() - Received request to process wildcard dip with parameters : [<?xml version="1.0" encoding="UTF-8" standalone="no" ?><App_WildcardDIPWorkqueueParams requestType="7"><clientUpdate _type_="3" clientId="990"/></App_WildcardDIPWorkqueueParams>]
5248  608   09/15 07:54:49 ### CWorkQueueAdmin::ProcessWildcardDIP() - Successfully processed DIP request

Badge +2

EvMgrS.log

18   09/15 08:01:16 ### authenticateThread() - Challenge client[127.0.0.1] on socket[0x0000000000001C8C]
5248  2558  09/15 08:01:31 ### DBBase-SQL() - dbcursors.cpp:300, Warning: Stored Procedure Procedure RptSaveSLA exceeded threshold time of 10, time taken: 17, Debug: [,0]
5248  2584  09/15 08:02:24 ### ServerManagerInvoker::Invoke() - Response received from remote host [<?xml version="1.0" encoding="UTF-8" standalone="no" ?><Workflow_WorkflowCompletionResponse contextId="b1506ffe-1297-4d7c-ab70-48be3d8bed6d" endTime="1694775744" errorCode="10" errorMessage="failed to execute database query, please check workflow engine log for more details" jobId="0" outputs="&lt;outputs>&lt;returnCode />&lt;returnString />&lt;outputXML />&lt;/outputs>" startTime="1694775743" status="10" statusCode="0" version="1"><workflow workflowId="146" workflowName="Assign Storage Policy in New Database Instance Creation"/></Workflow_WorkflowCompletionResponse>]
5248  2584  09/15 08:02:24 ### WorkflowControler::SendAnyWorkflowRequest() - clientId=[2], returnCode=[0]
5248  2584  09/15 08:02:24 ### BusinessLogicWorkflow::AnalyzeResponse() - Error: Messagehandler workflow[Assign Storage Policy in New Database Instance Creation] failed to complete, workflow engine error Code [10]

Userlevel 4
Badge +11

Thank you Damião,

The error looks like an issue with one of our Workflows during the Client Creation, particularly with the “Assign Storage Policy in New Database Instance Creation” Workflow.

I can see we have had other case recently with a similar condition.

Please raise a case with Commvault Support so we can run a deep dive analysis and provide a solution.

Badge +2
Thank you Javier,We have an incident Incident Update: 230829-707 open, but so far it has not been resolved!
Badge +2
Thank you Javier Do you know if a similar case was resolved?
Badge +2

The final solution was deactived the workflow thats has the error and then we can config the subclient.

 

Tnks

Badge +2

Javier, good morning.
With help from Commvault, the problem was related to the workload that was corrupted.
The steps to resolve the issue were:
--
1 - Registered with Commcell as an administrator
2 - Storage policy disabled (Disabled Assign Storage Policy in New Database Instance Creation)
3 - MySQL client created, backup ok.

Reply