Hi All,
We have finished out our pilot program for our security awareness training - Everything was sorted out with the issues we had and so we have rolled out the training to all our users.
In order to do this we have increased the amount of people in the security group to include all staff. Once we do this we have an awareness program which no longer works.
So here are the symptoms we are now experiencing
-
Emails are being sent to users
-
The user accepts the invite and logs in and is presented with the following screen
- The total number of people in the training group is not being updated it is still at 16 - There is now a lot more people than 16 in the security group
- Cron job ran with no issues last night
I have done some basic troubleshooting so far which is as follows
-
Test Getting Members of a Group returns all the members of the group which are supposed to be there
-
Test Getting List of Groups works as it should
-
At one point in debug mode we got the following
Database Error
Error: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
SQL Query: UPDATE
eramba_enterprise
.awareness_programs
SETworkflow_status
= 4,modified
= ‘2017-02-07 09:42:56’ WHEREeramba_enterprise
.awareness_programs
.id
= ‘8’
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
Stack Trace
CORE/Cake/Model/Datasource/DboSource.php line 468 → PDOStatement->execute(array) CORE/Cake/Model/Datasource/DboSource.php line 434 → DboSource->_execute(string, array) CORE/Cake/Model/Datasource/Database/Mysql.php line 415 → DboSource->execute(string) CORE/Cake/Model/Model.php line 1924 → Mysql->update(AwarenessProgram, array, array) CORE/Cake/Model/Model.php line 1758 → Model->_doSave(array, array) APP/Controller/WorkflowsController.php line 1054 → Model->save(array, boolean) APP/Controller/WorkflowsController.php line 1361 → WorkflowsController->saveData(string, string, integer) APP/Controller/WorkflowsController.php line 1130 → WorkflowsController->beforeRequestApproval(string, string, string) APP/Controller/WorkflowsController.php line 1094 → WorkflowsController->beforeRequestValidation(string, string) [internal function] → WorkflowsController->requestValidation(string, string) CORE/Cake/Controller/Controller.php line 491 → ReflectionMethod->invokeArgs(WorkflowsController, array) CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction(CakeRequest) CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(WorkflowsController, CakeRequest) APP/webroot/index.php line 110 → Dispatcher->dispatch(CakeRequest, CakeResponse)
Trying to start and stop the program makes no difference either apart from sending multiple mails out to people, this in itself causes issues as outlook sees the volume of mails coming in and marks it as spam.
Could someone get in touch with me please as this is becoming a bit of a disaster