Project

General

Profile

Actions
Copy link

action #20840

closed

DBI Exception: DBD::SQLite::db prepare_cached failed: too many SQL variables

Added by michalnowak over 7 years ago. Updated over 7 years ago.

Status:
Rejected
Priority:
High
Assignee:
-
Category:
Regressions/Crashes
Target version:
-
Start date:
2017-07-27
Due date:
% Done:

0%

Estimated time:

Description

Updated openQA to openQA-4.4.1501145513.0636c129-99.1.noarch and openQA stopped working (even after restart):

Jul 27 22:06:14 assam-openqa openqa[974]: Uncaught exception from user code:
Jul 27 22:06:14 assam-openqa openqa[974]: failed to run Perl in /usr/share/openqa/script/../dbicdh/_common/upgrade/56-57/001-migrate-jobs.pl: DBIx::Class::Storage::DBI::_prepare_sth(): DBI Exception: DBD::SQLite::db prepare_cached failed: too many SQL variables [for Statement "SELECT me.job_id, me.result, COUNT( id ) FROM job_modules me WHERE ( job_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
...

rest is attached.

Files

journal-openqa.txt (47.7 KB) journal-openqa.txt michalnowak, 2017-07-27 20:38

Related issues 1 (0 open — 1 closed)

Is duplicate of openQA Project - action #12950: sqlite database implementation does not support more than 5000 jobs in the database (was: on webui: startup: SQL error "prepare_cached failed")Rejected2016-07-31

Actions
Actions
Copy link
 #1

Updated by coolo over 7 years ago

  • Is duplicate of action #12950: sqlite database implementation does not support more than 5000 jobs in the database (was: on webui: startup: SQL error "prepare_cached failed") added
Actions
Copy link
 #2

Updated by coolo over 7 years ago

  • Status changed from New to Rejected

this is not high prio. What does have prio is resetting your instance - and while you are at it: setup postgresql properly

Actions
Copy link

Also available in: Atom PDF