Skip to content

DBD::SQLite::st execute failed: disk I/O error #109

@smukee

Description

@smukee

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?!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions