Schedule fixed time email get delayed due to continuous multiple DB lock wait time errors.

Description

database error: Lock wait timeout exceeded; try restarting transaction
File "/var/www/sites/coo/preside/system/externals/cfconcurrent/ThreadFactoryRunnableProxy.cfc", line 11, col 0
11: runnable.run();
File "/var/www/sites/coo/preside/system/services/concurrency/AbstractHeartBeat.cfc", line 30, col 0
30: $run();
File "/var/www/sites/coo/preside/system/services/concurrency/PresideEmailQueueHeartBeat.cfc", line 38, col 0
38: _getEmailMassSendingService().autoQueueScheduledSendouts();
File "/var/www/sites/coo/preside/system/services/email/EmailMassSendingService.cfc", line 221, col 0
221: totalQueued += queueSendout( oneTimeTemplate );
File "/var/www/sites/coo/preside/system/services/email/EmailMassSendingService.cfc", line 122, col 0
122: );
File "/var/www/sites/coo/preside/system/services/presideObjects/PresideObjectDecorator.cfc", line 53, col 0
53: return this._presideObjectService[ missingMethodName ]( argumentCollection = missingMethodArguments );
File "/var/www/sites/coo/preside/system/services/presideObjects/PresideObjectService.cfc", line 524, col 0
524: , returnType = "info"
File "/var/www/sites/coo/preside/system/services/presideObjects/PresideObjectService.cfc", line 3584, col 0
3584: return _getSqlRunner().runSql( argumentCollection = arguments );
File "/var/www/sites/coo/preside/system/services/database/SqlRunner.cfc", line 68, col 0
68: result = QueryExecute( sql=arguments.sql, params=params, options=options );

Environment

None

Assignee

Unassigned

Reporter

Johnson Cheng

Labels

None

Accepted

None

Affects versions

Priority

High
Configure