Error with SchedulerTaskWorker & Lock wait timeout exceeded

Moderator: crythias

Post Reply
skilled
OTRS expert
Posts: 68
Joined: 11 Apr 2018, 13:53
OTRS Version?: 6.0.16

Error with SchedulerTaskWorker & Lock wait timeout exceeded

Post by skilled »

Hello all,

I hope this time, that i get an answer or help if it is possible with my issue because last three topics from me I could not get an answer.
I had errors the first one with Invalid value for String & Error creating DateTime object :

Code: Select all

Sun Mar 24 03:53:54 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 	Could not create new scheduler recurrent task ArticleSearchIndexRebuild!
Sun Mar 24 03:53:37 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Error creating DateTime object.
Sun Mar 24 03:53:37 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Invalid value for String: .
Sun Mar 24 03:53:37 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Invalid date/time string .
Sun Mar 24 02:41:39 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 	Could not create new scheduler recurrent task EscalationCheck!
Sun Mar 24 02:41:01 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Error creating DateTime object.
Sun Mar 24 02:41:01 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Invalid value for String: .
Sun Mar 24 02:41:01 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Invalid date/time string .
it is not happing every day, last week it happed four times, two times with Could not create new scheduler recurrent task ArticleSearchIndexRebuild!
and one time with Could not create new scheduler recurrent task MailQueueSend! and one time with Could not create new scheduler recurrent task EscalationCheck!
What it could be this error, or how to find out the reason?

Second error:

Code: Select all

Sat Mar 23 22:11:48 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 21:33:54 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 21:33:54 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 21:10:34 2019 (Europe/Berlin) 	error 	OTRS-otrs.Console.pl-Maint::Session::DeleteExpired-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:52:45 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:52:44 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:52:42 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:49:11 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:48:58 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:48:49 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:48:36 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:47:46 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:47:45 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:47:44 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:46:22 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:45:26 2019 (Europe/Berlin) 	error 	OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-28 	Lock wait timeout exceeded; try restarting transaction, SQL: 'DELETE FROM scheduler_task WHERE id = ?'
Sat Mar 23 20:44:12 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:44:12 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:44:07 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:27:34 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:27:32 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:27:26 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:17:17 2019 (Europe/Berlin) 	error 	OTRS-otrs.Console.pl-Maint::Ticket::EscalationCheck-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:12:50 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:06:15 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:06:15 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Sat Mar 23 20:06:11 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-28 	Lock wait timeout exceeded; try restarting transaction, SQL: '
Is this error related with innodb_lock_wait_timeout environment variable?or if it is happed for one time, should not be big problem, because it happed one time till now.

I will be grateful for any help/tips

Thanks

root
Moderator
Posts: 1939
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: Error with SchedulerTaskWorker & Lock wait timeout exceeded

Post by root »

Hi,

My first approcha would be check the support data center for problems and the check with otrs.Console.pl Maint::Daemon::Summary (please provide the output if possible).

- Roy
OTRS 5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Do you need professional services for the ((OTRS)) Community Edition? Check out https://www.znuny.com/

skilled
OTRS expert
Posts: 68
Joined: 11 Apr 2018, 13:53
OTRS Version?: 6.0.16

Re: Error with SchedulerTaskWorker & Lock wait timeout exceeded

Post by skilled »

root wrote:
27 Mar 2019, 14:26
Hi,

My first approcha would be check the support data center for problems and the check with otrs.Console.pl Maint::Daemon::Summary (please provide the output if possible).

- Roy
Hi Roy,

first thanks for your help.
I checked already in Support Data collector and I did not see any error except in FAQ :
Package Installation Status (FAQ 6.0.16)
Some packages are not correctly installed.

I disabled few pages of FAQ for the customer and for public, I changed the name of files, so that's why I had this error, but otherwise no errors.

I did the command otrs.Console.pl Maint::Daemon::Summary and the output:

Code: Select all

Gathering summary for all daemons...

  System configuration sync:
    Daemon is active.

  Tasks to be executed in future:
    There are currently no tasks to be executed in future.

  Recurrent cron tasks:
  +---------------------------------+---------------------+-------------+---------------+---------------------+
  | Name                            | Last Execution      | Last Status | Last Duration | Next Execution      |
  +---------------------------------+---------------------+-------------+---------------+---------------------+
  | ArticleSearchIndexRebuild       | 2019-03-28 10:40:00 | Success     | 1.0 Second(s) | 2019-03-28 10:41:00 |
  | CommunicationLogDelete          | 2019-03-28 03:00:00 | Success     | < 1 Second    | 2019-03-29 03:00:00 |
  | ConfigurationDeploymentCleanup  | 2019-03-24 00:40:00 | Success     | < 1 Second    | 2019-03-31 00:40:00 |
  | CoreCacheCleanup                | 2019-03-24 00:20:00 | Success     | 2.0 Second(s) | 2019-03-31 00:20:00 |
  | EscalationCheck                 | 2019-03-28 10:40:00 | Success     | < 1 Second    | 2019-03-28 10:45:00 |
  | GenerateDashboardStats          | 2019-03-28 10:05:00 | Success     | 1.0 Second(s) | 2019-03-28 11:05:00 |
  | GeneticInterfaceDebugLogCleanup | 2019-03-28 03:02:00 | Success     | < 1 Second    | 2019-03-29 03:02:00 |
  | LoaderCacheDelete               | 2019-03-24 00:30:00 | Success     | < 1 Second    | 2019-03-31 00:30:00 |
  | MailAccountFetch                | 2019-03-28 10:40:00 | Success     | < 1 Second    | 2019-03-28 10:50:00 |
  | MailQueueSend                   | 2019-03-28 10:40:00 | Success     | 1.0 Second(s) | 2019-03-28 10:41:00 |
  | OTRSBusinessAvailabilityCheck   | 2019-03-28 10:35:00 | Success     | < 1 Second    | 2019-03-28 10:55:00 |
  | OTRSBusinessEntitlementCheck    | 2019-03-28 10:25:00 | Success     | < 1 Second    | 2019-03-28 10:45:00 |
  | RegistrationUpdateSend          | 2019-03-28 10:30:00 | Success     | < 1 Second    | 2019-03-28 11:30:00 |
  | RenewCustomerSMIMECertificates  | 2019-03-28 02:02:00 | Success     | < 1 Second    | 2019-03-29 02:02:00 |
  | SessionDeleteExpired            | 2019-03-28 08:55:00 | Success     | < 1 Second    | 2019-03-28 10:55:00 |
  | SpoolMailsReprocess             | 2019-03-28 00:10:00 | Success     | < 1 Second    | 2019-03-29 00:10:00 |
  | SupportDataCollectAsynchronous  | 2019-03-28 10:01:00 | Success     | < 1 Second    | 2019-03-28 11:01:00 |
  | TicketAcceleratorRebuild        | 2019-03-28 01:01:00 | Success     | < 1 Second    | 2019-03-29 01:01:00 |
  | TicketDraftDeleteExpired        | 2019-03-28 09:55:00 | Success     | < 1 Second    | 2019-03-28 10:55:00 |
  | TicketNumberCounterCleanup      | 2019-03-28 10:40:00 | Success     | < 1 Second    | 2019-03-28 10:50:00 |
  | TicketPendingCheck              | 2019-03-28 08:45:00 | Success     | < 1 Second    | 2019-03-28 10:45:00 |
  | TicketUnlockTimeout             | 2019-03-28 10:35:00 | Success     | < 1 Second    | 2019-03-28 11:35:00 |
  | WebUploadCacheCleanup           | 2019-03-28 09:46:00 | Success     | < 1 Second    | 2019-03-28 10:46:00 |
  +---------------------------------+---------------------+-------------+---------------+---------------------+

  Recurrent generic agent tasks:
    There are currently no generic agent recurring tasks configured.

  Unhandled Worker Tasks:
    There are currently no tasks waiting to be executed.

  Handled Worker Tasks:
    There are currently no tasks being executed.
Thanks in advance

skilled
OTRS expert
Posts: 68
Joined: 11 Apr 2018, 13:53
OTRS Version?: 6.0.16

Re: Error with SchedulerTaskWorker & Lock wait timeout exceeded

Post by skilled »

i got today new error:

Code: Select all

Mon Apr 1 02:01:58 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 	Error creating DateTime object.
Mon Apr 1 02:01:57 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 	Error creating DateTime object.
Mon Apr 1 02:01:56 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 	Error creating DateTime object.
Mon Apr 1 02:01:55 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 	Error creating DateTime object.
Mon Apr 1 02:01:53 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 	Error creating DateTime object.
Mon Apr 1 02:01:52 2019 (Europe/Berlin) 	error 	OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 	Error creating DateTime object.
It happened from 31.03.2019 till 01.04.2019.
I am not sure what is it? I do not know if it has affected the database or like that?
I took to the logs under: opt->otrs->var->logs->Daemon then i choosed one of a lot of logfiles for SchedulerCronTaskManager and it contains:

Code: Select all

ERROR: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-28 Perl: 5.26.1 OS: linux Time: Sun Mar 31 14:20:05 2019

 Message: Error creating DateTime object.

 Traceback (40139): 
   Module: Kernel::System::DateTime::new Line: 154
   Module: Kernel::System::ObjectManager::_ObjectBuild Line: 306
   Module: Kernel::System::ObjectManager::Create Line: 241
   Module: Kernel::System::CronEvent::PreviousEventGet Line: 226
   Module: Kernel::System::Daemon::SchedulerDB::CronTaskToExecute Line: 1437
   Module: Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager::Run Line: 102
   Module: (eval) Line: 314
   Module: main::Start Line: 314
   Module: /opt/otrs/bin/otrs.Daemon.pl Line: 135
I restarted the cron.sh and Daemon

any help?

Thanks

Post Reply