PHP Archives - Chris Mcintosh

I ran into an issue with a Laravel application I was working on. The issue was related to a long running job. The job generally takes between 10 to 15 minutes to complete.

Before the job kicked off we would change a value in the database to indicate the job was in progress – we’ll call this state as “active”. At the end of the job we would change the value in the database back – we’ll call this state “inactive”. Changing the record back would allow the record to be picked up by other jobs in the future.

At the end of the job (job still in progress) I could see the value as being set to “inactive” (as desired). However once the job was fully over – a peek into the database would show the record as “active” still. So during the job we would get a false positive of our database record being changed. After the job the record would “snap back” to an undesired state of “active”.

I tried multiple things to rectify this issue and get our database changes to stick after the job completed. One thing that worked – but felt “icky” – was chaining a job onto the main job to do database cleanup. Discovering that this chained job worked led me to discover that the DB::transaction was “locking” the record and preventing permanent changes. Once the DB::commit() line fired our “temporary” changes would go away.

In this instance it made more sense to not use a DB transaction method instead of chaining the job on. Especially since this job runs for so long. Hopefully this can help you identify similar issues in your long running jobs. The best course of action for your application might be different than my solution.

Good luck!

Ensure the Timber Plugin or Composer dependency is installed
Install the Events Calendar Plugin
This works for the free version. If using the paid version of the plugin – you might have to modify the other steps.
Activate the Events Calendar Plugin
Create the template file for the override
Create a file at the following location inside the Timber theme tribe/events/v2/default-template.php
Add the code to the template file
See code snippet 1 below
Render the markup in twig
See code snippet 2

Code Snippet 1

<?php
/**
 * Default Events Template
 *
 * @package TribeEventsCalendar
 * @version 4.6.23
 *
 */

use Tribe\Events\Views\V2\Template_Bootstrap;

if ( ! defined( 'ABSPATH' ) ) {
	die( '-1' );
}

$context = Timber::get_context();
$context['tribe_markup'] = tribe( Template_Bootstrap::class )->get_view_html();
Timber::render( array( 'events.twig' ), $context );

Code Snippet 2

  <div class="events-container">
    {{tribe_markup}}
  </div>

More related information can be found here https://github.com/timber/timber/issues/312#issue-39623334

Database Timing Out or Not Persisting Changes on Laravel Chained Jobs

Using The Events Calendar Plugin with Timber and Twig

Code Snippet 1

Code Snippet 2