https://progress.opensuse.org/https://progress.opensuse.org/themes/openSUSE/favicon/favicon.ico?15829177842019-06-21T11:21:05ZopenSUSE Project Management ToolopenQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=2228572019-06-21T11:21:05Zokurzokurz@suse.com
<ul></ul><p>Muted from monitoring with <a href="https://github.com/os-autoinst/openqa-logwarn/commit/19a0394a6f465a36de3a294c41f08bb47732da8e" class="external">https://github.com/os-autoinst/openqa-logwarn/commit/19a0394a6f465a36de3a294c41f08bb47732da8e</a></p>
openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=2263582019-07-10T14:12:18Zokurzokurz@suse.com
<ul><li><strong>Priority</strong> changed from <i>Normal</i> to <i>High</i></li></ul><p>these messages unfortunately pass the logwarn filter and clog up the o3-admins mailing list input channel because they are so big. Trying to display these emails with my email client kmail is even a challenge. I would appreciate if we can look into this soon.</p>
openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=2263672019-07-10T14:20:40Zokurzokurz@suse.com
<ul></ul><p><code>[2019-07-10T10:58:26.0989 UTC]</code> is the last timestamp I found.</p>
<p>But actually it does not happen that often:</p>
<pre><code># grep 'must be between' /var/log/openqa | grep 2019-0[67]- | cut -c -100
[2019-06-21T09:25:50.0548 UTC] [error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD
[2019-06-25T16:35:55.0844 UTC] [error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD
[2019-06-25T16:36:18.0171 UTC] [error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD
[2019-06-25T16:36:34.0783 UTC] [error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD
[2019-07-10T10:57:13.0747 UTC] [error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD
[2019-07-10T10:58:26.0989 UTC] [error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD
</code></pre>
<p>I wonder if that is an external request triggering it or something from openQA or internal to o3 itself. With this low number of occurences I don't think we can find something easily in apache access logs.</p>
openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=2263732019-07-10T14:31:27Zokurzokurz@suse.com
<ul><li><strong>Priority</strong> changed from <i>High</i> to <i>Normal</i></li></ul><p><a href="https://github.com/os-autoinst/openqa-logwarn/pull/12" class="external">https://github.com/os-autoinst/openqa-logwarn/pull/12</a> created to at least cut the overly long lines in reporting.</p>
openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=2268562019-07-12T10:13:38Zmkittlermarius.kittler@suse.com
<ul><li><strong>Assignee</strong> set to <i>mkittler</i></li></ul><p>One can reproduce this locally with an o3 dump using <code>script/client --host localhost:9526 jobs</code>. We <em>could</em> split the query but returning that much data (the JSON object contains the settings for each job!) makes no sense. So I would simply limit it.</p>
openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=2268772019-07-12T10:53:44Zmkittlermarius.kittler@suse.com
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>In Progress</i></li><li><strong>Target version</strong> set to <i>Current Sprint</i></li></ul><p>PR: <a href="https://github.com/os-autoinst/openQA/pull/2185" class="external">https://github.com/os-autoinst/openQA/pull/2185</a></p>
openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=2272372019-07-15T12:09:17Zmkittlermarius.kittler@suse.com
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Resolved</i></li></ul><p>PR has been merged</p>
openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=2410282019-09-03T16:01:15Zmkittlermarius.kittler@suse.com
<ul><li><strong>Target version</strong> changed from <i>Current Sprint</i> to <i>Done</i></li></ul> openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=7343962023-11-15T13:06:03Ztinitatina.mueller+trick-redmine@suse.com
<ul><li><strong>Status</strong> changed from <i>Resolved</i> to <i>Workable</i></li><li><strong>Target version</strong> deleted (<del><i>Done</i></del>)</li></ul><p>We are still ignoring this error message and reference this tickets:<br>
<a href="https://github.com/os-autoinst/openqa-logwarn/blob/master/logwarn_openqa#L67C8-L67C50" class="external">https://github.com/os-autoinst/openqa-logwarn/blob/master/logwarn_openqa#L67C8-L67C50</a><br>
I would say a ticket shouldn't be resolved when it's still referenced and errors actively ignored.</p>
openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=7343992023-11-15T13:06:19Ztinitatina.mueller+trick-redmine@suse.com
<ul><li><strong>Status</strong> changed from <i>Workable</i> to <i>New</i></li></ul> openQA Project - action #53435: [logwarn] o3: DBI Exception: number of parameters must be between 0 and 65535 in lib/OpenQA/WebAPI/Controller/API/V1/Job.pm line 133https://progress.opensuse.org/issues/53435?journal_id=7344112023-11-15T13:10:13Zokurzokurz@suse.com
<ul><li><strong>Assignee</strong> deleted (<del><i>mkittler</i></del>)</li><li><strong>Target version</strong> set to <i>future</i></li></ul>