=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ grep rough audit - static analysis tool v2.8 written by @Wireghoul =================================[justanotherhacker.com]=== libminion-perl-10.14+dfsg/t/pg.t-699- ok $job->info->{delayed} > $job->info->{created}, 'delayed timestamp'; libminion-perl-10.14+dfsg/t/pg.t:700: $minion->backend->pg->db->query("UPDATE minion_jobs SET delayed = NOW() - INTERVAL '1 day' WHERE id = ?", $id); libminion-perl-10.14+dfsg/t/pg.t-701- ok $job = $worker->dequeue(0), 'job dequeued'; ############################################## libminion-perl-10.14+dfsg/t/pg.t-916- libminion-perl-10.14+dfsg/t/pg.t:917: $minion->backend->pg->db->query('UPDATE minion_jobs SET delayed = NOW() WHERE id = ?', $id); libminion-perl-10.14+dfsg/t/pg.t-918- ok $job = $worker->dequeue(0), 'job dequeued'; ############################################## libminion-perl-10.14+dfsg/t/pg.t-928- libminion-perl-10.14+dfsg/t/pg.t:929: $minion->backend->pg->db->query('UPDATE minion_jobs SET delayed = NOW() WHERE id = ?', $id); libminion-perl-10.14+dfsg/t/pg.t-930- ok $job = $worker->register->dequeue(0), 'job dequeued'; ############################################## libminion-perl-10.14+dfsg/t/pg.t-946- is $job->info->{state}, 'inactive', 'right state'; libminion-perl-10.14+dfsg/t/pg.t:947: $minion->backend->pg->db->query('UPDATE minion_jobs SET delayed = NOW() WHERE id = ?', $id); libminion-perl-10.14+dfsg/t/pg.t-948- ok $job = $worker->register->dequeue(0), 'job dequeued'; ############################################## libminion-perl-10.14+dfsg/t/pg.t-967- ok $job->info->{retried} < $job->info->{delayed}, 'delayed timestamp'; libminion-perl-10.14+dfsg/t/pg.t:968: $minion->backend->pg->db->query('UPDATE minion_jobs SET delayed = NOW() WHERE id = ?', $id); libminion-perl-10.14+dfsg/t/pg.t-969- ok $job = $worker->register->dequeue(0), 'job dequeued'; ############################################## libminion-perl-10.14+dfsg/t/pg.t-1195- my $pg = $minion->backend->pg; libminion-perl-10.14+dfsg/t/pg.t:1196: $pg->db->query("UPDATE minion_jobs SET expires = NOW() - INTERVAL '1 day' WHERE id = ?", $id); libminion-perl-10.14+dfsg/t/pg.t-1197- is $minion->jobs({states => ['inactive']})->total, 0, 'job has expired'; ############################################## libminion-perl-10.14+dfsg/t/pg.t-1206- ok $job->finish, 'job finished'; libminion-perl-10.14+dfsg/t/pg.t:1207: $pg->db->query("UPDATE minion_jobs SET expires = NOW() - INTERVAL '1 day' WHERE id = ?", $id); libminion-perl-10.14+dfsg/t/pg.t-1208- $minion->repair; ############################################## libminion-perl-10.14+dfsg/t/pg.t-1215- ok $job->fail, 'job failed'; libminion-perl-10.14+dfsg/t/pg.t:1216: $pg->db->query("UPDATE minion_jobs SET expires = NOW() - INTERVAL '1 day' WHERE id = ?", $id); libminion-perl-10.14+dfsg/t/pg.t-1217- $minion->repair; ############################################## libminion-perl-10.14+dfsg/t/pg.t-1223- is $job->id, $id, 'right id'; libminion-perl-10.14+dfsg/t/pg.t:1224: $pg->db->query("UPDATE minion_jobs SET expires = NOW() - INTERVAL '1 day' WHERE id = ?", $id); libminion-perl-10.14+dfsg/t/pg.t-1225- $minion->repair; ############################################## libminion-perl-10.14+dfsg/t/pg.t-1232- ok !$worker->dequeue(0, {id => $id2}), 'parent is still inactive'; libminion-perl-10.14+dfsg/t/pg.t:1233: $pg->db->query("UPDATE minion_jobs SET expires = NOW() - INTERVAL '1 day' WHERE id = ?", $id); libminion-perl-10.14+dfsg/t/pg.t-1234- ok $job = $worker->dequeue(0, {id => $id2}), 'parent has expired'; ############################################## libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-14- return !!$self->pg->db->query( libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm:15: q{UPDATE minion_workers SET inbox = inbox || $1::JSONB WHERE (id = ANY ($2) OR $2 = '{}')}, libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-16- {json => [[$command, @$args]]}, $ids)->rows; ############################################## libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-84- FROM minion_jobs AS j libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm:85: WHERE (id < $1 OR $1 IS NULL) AND (id = ANY ($2) OR $2 IS NULL) AND (notes \? ANY ($3) OR $3 IS NULL) libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-86- AND (queue = ANY ($4) OR $4 IS null) AND (state = ANY ($5) OR $5 IS NULL) AND (task = ANY ($6) OR $6 IS NULL) ############################################## libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-99- 'SELECT name, EXTRACT(EPOCH FROM expires) AS expires, COUNT(*) OVER() AS total FROM minion_locks libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm:100: WHERE expires > NOW() AND (name = ANY ($1) OR $1 IS NULL) libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-101- ORDER BY id DESC LIMIT $2 OFFSET $3', $options->{names}, $limit, $offset ############################################## libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-114- FROM minion_workers libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm:115: WHERE (id < \$1 OR \$1 IS NULL) AND (id = ANY (\$2) OR \$2 IS NULL) libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-116- ORDER BY id DESC LIMIT \$3 OFFSET \$4", @$options{qw(before ids)}, $limit, $offset ############################################## libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-169- return !!$self->pg->db->query( libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm:170: "DELETE FROM minion_jobs WHERE id = ? AND state IN ('inactive', 'failed', 'finished') RETURNING 1", $id)->rows; libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-171-} ############################################## libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-198- q{UPDATE minion_jobs SET state = 'failed', result = '"Job appears stuck in queue"' libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm:199: WHERE state = 'inactive' AND delayed + ? * INTERVAL '1 second' < NOW()}, $minion->stuck_after libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-200- ); ############################################## libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-217- queue = COALESCE($7, queue), retried = NOW(), retries = retries + 1, state = 'inactive' libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm:218: WHERE id = $8 AND retries = $9 libminion-perl-10.14+dfsg/lib/Minion/Backend/Pg.pm-219- RETURNING 1}, $options->{attempts}, $options->{delay} // 0, $options->{expire}, ############################################## libminion-perl-10.14+dfsg/lib/Minion/Backend/resources/migrations/pg.sql-61- DELETE FROM minion_locks WHERE expires < NOW(); libminion-perl-10.14+dfsg/lib/Minion/Backend/resources/migrations/pg.sql:62: IF (SELECT COUNT(*) >= $3 FROM minion_locks WHERE NAME = $1) THEN libminion-perl-10.14+dfsg/lib/Minion/Backend/resources/migrations/pg.sql-63- RETURN false;