Bug #124854 for ORLite: DBD::SQLite::db do failed: unknown database ANALYZE

Wed Mar 21 18:08:48 2018 SREZIC [...] cpan.org - Ticket created

CC:	ishigaki [...] cpan.org
Subject:	DBD::SQLite::db do failed: unknown database ANALYZE

A new failure: ... DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) line 37. END failed--call queue aborted. # Looks like your test exited with 22 just after 2. t/10_cleanup.t ....... Dubious, test returned 22 (wstat 5632, 0x1600) All 2 subtests passed DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) line 124. END failed--call queue aborted. # Looks like your test exited with 22 just after 4. t/11_cleanup.t ....... Dubious, test returned 22 (wstat 5632, 0x1600) All 4 subtests passed ... Statistical analysis suggests that this happens with newer DBD::SQLite: **************************************************************** Regression 'mod:DBD::SQLite' **************************************************************** Name Theta StdErr T-stat [0='const'] 1.0000 0.0000 57022145054851504.00 [1='eq_1.42'] 0.0000 0.0000 18.27 [2='eq_1.44'] 0.0000 0.0000 11.98 [3='eq_1.46'] 0.0000 0.0000 19.77 [4='eq_1.48'] 0.0000 0.0000 20.39 [5='eq_1.50'] 0.0000 0.0000 22.38 [6='eq_1.52'] 0.0000 0.0000 7.91 [7='eq_1.54'] 0.0000 0.0000 24.27 [8='eq_1.56'] -1.0000 0.0000 -46049536371101328.00 R^2= 1.000, N= 251, K= 9 ****************************************************************

Sat May 19 07:50:43 2018 jkeenan [...] cpan.org - Correspondence added

On Wed Mar 21 18:08:48 2018, SREZIC wrote: Show quoted text

> A new failure: > > ... > DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) line 37. > END failed--call queue aborted. > # Looks like your test exited with 22 just after 2. > t/10_cleanup.t ....... > Dubious, test returned 22 (wstat 5632, 0x1600) > All 2 subtests passed > DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) line 124. > END failed--call queue aborted. > # Looks like your test exited with 22 just after 4. > t/11_cleanup.t ....... > Dubious, test returned 22 (wstat 5632, 0x1600) > All 4 subtests passed > ... > > Statistical analysis suggests that this happens with newer DBD::SQLite: > > **************************************************************** > Regression 'mod:DBD::SQLite' > **************************************************************** > Name Theta StdErr T-stat > [0='const'] 1.0000 0.0000 57022145054851504.00 > [1='eq_1.42'] 0.0000 0.0000 18.27 > [2='eq_1.44'] 0.0000 0.0000 11.98 > [3='eq_1.46'] 0.0000 0.0000 19.77 > [4='eq_1.48'] 0.0000 0.0000 20.39 > [5='eq_1.50'] 0.0000 0.0000 22.38 > [6='eq_1.52'] 0.0000 0.0000 7.91 > [7='eq_1.54'] 0.0000 0.0000 24.27 > [8='eq_1.56'] -1.0000 0.0000 -46049536371101328.00 > > R^2= 1.000, N= 251, K= 9 > ****************************************************************

Got similar failures today on FreeBSD-11.1 with perl-5.27.11.

Sat May 19 07:50:44 2018 The RT System itself - Status changed from 'new' to 'open'

Sat May 19 08:21:40 2018 ishigaki [...] cpan.org - Correspondence added

On Sat May 19 20:50:43 2018, JKEENAN wrote: Show quoted text

> On Wed Mar 21 18:08:48 2018, SREZIC wrote:

> > A new failure: > > > > ... > > DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) line 37. > > END failed--call queue aborted. > > # Looks like your test exited with 22 just after 2. > > t/10_cleanup.t ....... > > Dubious, test returned 22 (wstat 5632, 0x1600) > > All 2 subtests passed > > DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) line 124. > > END failed--call queue aborted. > > # Looks like your test exited with 22 just after 4. > > t/11_cleanup.t ....... > > Dubious, test returned 22 (wstat 5632, 0x1600) > > All 4 subtests passed > > ... > > > > Statistical analysis suggests that this happens with newer DBD::SQLite: > > > > **************************************************************** > > Regression 'mod:DBD::SQLite' > > **************************************************************** > > Name Theta StdErr T-stat > > [0='const'] 1.0000 0.0000 57022145054851504.00 > > [1='eq_1.42'] 0.0000 0.0000 18.27 > > [2='eq_1.44'] 0.0000 0.0000 11.98 > > [3='eq_1.46'] 0.0000 0.0000 19.77 > > [4='eq_1.48'] 0.0000 0.0000 20.39 > > [5='eq_1.50'] 0.0000 0.0000 22.38 > > [6='eq_1.52'] 0.0000 0.0000 7.91 > > [7='eq_1.54'] 0.0000 0.0000 24.27 > > [8='eq_1.56'] -1.0000 0.0000 -46049536371101328.00 > > > > R^2= 1.000, N= 251, K= 9 > > ****************************************************************

> > Got similar failures today on FreeBSD-11.1 with perl-5.27.11.

FYI, this issue was a regression (or intentional change without notice) in libsqlite since version 3.15.0 (released 2016-10-14), and got widely visible since DBD::SQLite 1.56 (released 2018-02-28 with libsqlite 3.22.0). It's not a blead/os issue.

Sat May 19 10:45:18 2018 ishigaki [...] cpan.org - Correspondence added

On Sat May 19 21:21:40 2018, ISHIGAKI wrote: Show quoted text

> On Sat May 19 20:50:43 2018, JKEENAN wrote:

> > On Wed Mar 21 18:08:48 2018, SREZIC wrote:

> > > A new failure: > > > > > > ... > > > DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) > > > line 37. > > > END failed--call queue aborted. > > > # Looks like your test exited with 22 just after 2. > > > t/10_cleanup.t ....... > > > Dubious, test returned 22 (wstat 5632, 0x1600) > > > All 2 subtests passed > > > DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) > > > line 124. > > > END failed--call queue aborted. > > > # Looks like your test exited with 22 just after 4. > > > t/11_cleanup.t ....... > > > Dubious, test returned 22 (wstat 5632, 0x1600) > > > All 4 subtests passed > > > ... > > > > > > Statistical analysis suggests that this happens with newer > > > DBD::SQLite: > > > > > > **************************************************************** > > > Regression 'mod:DBD::SQLite' > > > **************************************************************** > > > Name Theta StdErr T-stat > > > [0='const'] 1.0000 0.0000 > > > 57022145054851504.00 > > > [1='eq_1.42'] 0.0000 0.0000 18.27 > > > [2='eq_1.44'] 0.0000 0.0000 11.98 > > > [3='eq_1.46'] 0.0000 0.0000 19.77 > > > [4='eq_1.48'] 0.0000 0.0000 20.39 > > > [5='eq_1.50'] 0.0000 0.0000 22.38 > > > [6='eq_1.52'] 0.0000 0.0000 7.91 > > > [7='eq_1.54'] 0.0000 0.0000 24.27 > > > [8='eq_1.56'] -1.0000 0.0000 > > > -46049536371101328.00 > > > > > > R^2= 1.000, N= 251, K= 9 > > > ****************************************************************

> > > > Got similar failures today on FreeBSD-11.1 with perl-5.27.11.

> > > FYI, this issue was a regression (or intentional change without > notice) in libsqlite since version 3.15.0 (released 2016-10-14), and > got widely visible since DBD::SQLite 1.56 (released 2018-02-28 with > libsqlite 3.22.0). It's not a blead/os issue.

And got a response that this was a bug fixed by the upstream, not a regression. So we should fix the broken tests and the pod here.

Thu Jul 11 18:41:25 2019 jkeenan [...] cpan.org - Correspondence added

On Sat May 19 10:45:18 2018, ISHIGAKI wrote: Show quoted text

> On Sat May 19 21:21:40 2018, ISHIGAKI wrote:

> > On Sat May 19 20:50:43 2018, JKEENAN wrote:

> > > On Wed Mar 21 18:08:48 2018, SREZIC wrote:

> > > > A new failure: > > > > > > > > ... > > > > DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) > > > > line 37. > > > > END failed--call queue aborted. > > > > # Looks like your test exited with 22 just after 2. > > > > t/10_cleanup.t ....... > > > > Dubious, test returned 22 (wstat 5632, 0x1600) > > > > All 2 subtests passed > > > > DBD::SQLite::db do failed: unknown database ANALYZE at (eval 26) > > > > line 124. > > > > END failed--call queue aborted. > > > > # Looks like your test exited with 22 just after 4. > > > > t/11_cleanup.t ....... > > > > Dubious, test returned 22 (wstat 5632, 0x1600) > > > > All 4 subtests passed > > > > ... > > > > > > > > Statistical analysis suggests that this happens with newer > > > > DBD::SQLite: > > > > > > > > **************************************************************** > > > > Regression 'mod:DBD::SQLite' > > > > **************************************************************** > > > > Name Theta StdErr T-stat > > > > [0='const'] 1.0000 0.0000 > > > > 57022145054851504.00 > > > > [1='eq_1.42'] 0.0000 0.0000 18.27 > > > > [2='eq_1.44'] 0.0000 0.0000 11.98 > > > > [3='eq_1.46'] 0.0000 0.0000 19.77 > > > > [4='eq_1.48'] 0.0000 0.0000 20.39 > > > > [5='eq_1.50'] 0.0000 0.0000 22.38 > > > > [6='eq_1.52'] 0.0000 0.0000 7.91 > > > > [7='eq_1.54'] 0.0000 0.0000 24.27 > > > > [8='eq_1.56'] -1.0000 0.0000 > > > > -46049536371101328.00 > > > > > > > > R^2= 1.000, N= 251, K= 9 > > > > ****************************************************************

> > > > > > Got similar failures today on FreeBSD-11.1 with perl-5.27.11.

> > > > > > FYI, this issue was a regression (or intentional change without > > notice) in libsqlite since version 3.15.0 (released 2016-10-14), and > > got widely visible since DBD::SQLite 1.56 (released 2018-02-28 with > > libsqlite 3.22.0). It's not a blead/os issue.

> > And got a response that this was a bug fixed by the upstream, not a > regression. So we should fix the broken tests and the pod here.

Problem still evident when attempting to install against perl-5.31.0 on FreeBSD-12 today. ##### "t/09_badfile.t ....... ok", "DBD::SQLite::db do failed: unknown database ANALYZE at (eval 82) line 37.", "END failed--call queue aborted.", "# Looks like your test exited with 22 just after 2.", "t/10_cleanup.t ....... ", "Dubious, test returned 22 (wstat 5632, 0x1600)", "All 2 subtests passed ", "DBD::SQLite::db do failed: unknown database ANALYZE at (eval 82) line 124.", "END failed--call queue aborted.", "# Looks like your test exited with 22 just after 4.", "t/11_cleanup.t ....... ", "Dubious, test returned 22 (wstat 5632, 0x1600)", "All 4 subtests passed ", "t/12_xs.t ............ ok", #####

Thu Dec 26 16:59:46 2019 SREZIC [...] cpan.org - Correspondence added

On 2019-07-11 18:41:25, JKEENAN wrote: Show quoted text

> On Sat May 19 10:45:18 2018, ISHIGAKI wrote:

> > On Sat May 19 21:21:40 2018, ISHIGAKI wrote:

> > > On Sat May 19 20:50:43 2018, JKEENAN wrote:

> > > > On Wed Mar 21 18:08:48 2018, SREZIC wrote:

> > > > > A new failure: > > > > > > > > > > ... > > > > > DBD::SQLite::db do failed: unknown database ANALYZE at (eval > > > > > 26) > > > > > line 37. > > > > > END failed--call queue aborted. > > > > > # Looks like your test exited with 22 just after 2. > > > > > t/10_cleanup.t ....... > > > > > Dubious, test returned 22 (wstat 5632, 0x1600) > > > > > All 2 subtests passed > > > > > DBD::SQLite::db do failed: unknown database ANALYZE at (eval > > > > > 26) > > > > > line 124. > > > > > END failed--call queue aborted. > > > > > # Looks like your test exited with 22 just after 4. > > > > > t/11_cleanup.t ....... > > > > > Dubious, test returned 22 (wstat 5632, 0x1600) > > > > > All 4 subtests passed > > > > > ... > > > > > > > > > > Statistical analysis suggests that this happens with newer > > > > > DBD::SQLite: > > > > > > > > > > **************************************************************** > > > > > Regression 'mod:DBD::SQLite' > > > > > **************************************************************** > > > > > Name Theta StdErr T-stat > > > > > [0='const'] 1.0000 0.0000 > > > > > 57022145054851504.00 > > > > > [1='eq_1.42'] 0.0000 0.0000 18.27 > > > > > [2='eq_1.44'] 0.0000 0.0000 11.98 > > > > > [3='eq_1.46'] 0.0000 0.0000 19.77 > > > > > [4='eq_1.48'] 0.0000 0.0000 20.39 > > > > > [5='eq_1.50'] 0.0000 0.0000 22.38 > > > > > [6='eq_1.52'] 0.0000 0.0000 7.91 > > > > > [7='eq_1.54'] 0.0000 0.0000 24.27 > > > > > [8='eq_1.56'] -1.0000 0.0000 > > > > > -46049536371101328.00 > > > > > > > > > > R^2= 1.000, N= 251, K= 9 > > > > > ****************************************************************

> > > > > > > > Got similar failures today on FreeBSD-11.1 with perl-5.27.11.

> > > > > > > > > FYI, this issue was a regression (or intentional change without > > > notice) in libsqlite since version 3.15.0 (released 2016-10-14), > > > and > > > got widely visible since DBD::SQLite 1.56 (released 2018-02-28 with > > > libsqlite 3.22.0). It's not a blead/os issue.

> > > > And got a response that this was a bug fixed by the upstream, not a > > regression. So we should fix the broken tests and the pod here.

> > Problem still evident when attempting to install against perl-5.31.0 > on FreeBSD-12 today. > > ##### > "t/09_badfile.t ....... ok", > "DBD::SQLite::db do failed: unknown database ANALYZE at (eval 82) line > 37.", > "END failed--call queue aborted.", > "# Looks like your test exited with 22 just after 2.", > "t/10_cleanup.t ....... ", > "Dubious, test returned 22 (wstat 5632, 0x1600)", > "All 2 subtests passed ", > "DBD::SQLite::db do failed: unknown database ANALYZE at (eval 82) line > 124.", > "END failed--call queue aborted.", > "# Looks like your test exited with 22 just after 4.", > "t/11_cleanup.t ....... ", > "Dubious, test returned 22 (wstat 5632, 0x1600)", > "All 4 subtests passed ", > "t/12_xs.t ............ ok", > #####

The patch for the problem is available in https://rt.cpan.org/Ticket/Display.html?id=118460 (probably that issue and this one are the same and may be merged). CPAN.pm users may use the distroprefs file https://github.com/eserte/srezic-cpan-distroprefs/blob/master/ORLite.yml for automatic patching.

Thu Dec 26 17:00:41 2019 SREZIC [...] cpan.org - Reference to ticket #118460 added