-
Notifications
You must be signed in to change notification settings - Fork 31
Description
I'm using Mojolicious and Mojo::SQLite and have some cron jobs set up using Mojolicious::Plugin::Cron so this is my setup for the DB:
my $sql = Mojo::SQLite->new('sqlite:mydatabase.db');
my $migrations = Mojo::SQLite::Migrations->new(sqlite => $sql);
$migrations->from_file('./sqlite.sql')->migrate(2);
my $db = $sql->db;
I have several cron jobs that run at different times, one of them runs every minute and looks for the users in a log file and update those users and sets an expiry date for them in the database.
Every minute that the cron job executes when I open the web UI to see if the users are updated(SELECT QUERY) I get this one in my log file:
[2023-10-10 11:26:16.65533] [112418] [error] [exyHuG0SVvjy] DBD::SQLite::st execute failed: disk I/O error at /srv/control/lib/Control/Controller/Dashboard.pm line 24.
And the apps fails to run.
When I comment the update query, and the cron executes, I won't get this error.
$db->update('users', { expiry => $expiry }, { id => $u->{id} } );
Any idea what could be the issue here?!