Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 649408

Summary: dev-perl/DBD-SQLite-1.500.0[system-sqlite] fails tests
Product: Gentoo Linux Reporter: Mart Raudsepp <leio>
Component: Current packagesAssignee: Gentoo Perl team <perl>
Status: CONFIRMED ---    
Severity: normal CC: kentnl
Priority: Normal Keywords: TESTFAILURE
Version: unspecified   
Hardware: All   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---
Bug Depends on:    
Bug Blocks: 300119    

Description Mart Raudsepp gentoo-dev 2018-03-02 21:36:27 UTC
dev-perl/DBD-SQLite-1.500.0 fails tests with USE=system-sqlite against sqlite-3.21.0 (which 1.500.0 is meant to work with, with earlier versions requiring an older sqlite). Tests appear to pass with bundled sqlite.

Test Summary Report
-------------------
t/43_fts3.t                                         (Wstat: 65280 Tests: 2 Failed: 1)
  Failed test:  2
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 35 tests but ran 2.
t/virtual_table/rt_99748.t                          (Wstat: 512 Tests: 24 Failed: 1)
  Failed test:  24
  Non-zero exit status: 2
  Parse errors: Bad plan.  You planned 52 tests but ran 24.
Files=103, Tests=3500,  5 wallclock secs ( 2.10 usr  0.34 sys + 25.63 cusr  4.04 csys = 32.11 CPU)
Result: FAIL
Failed 2/103 test programs. 2/3500 subtests failed.
Makefile:1063: recipe for target 'test_dynamic' failed
Comment 1 Mart Raudsepp gentoo-dev 2018-03-02 21:38:44 UTC
sigh, I had a typo in package.keywords and thought I was testing 1.540.0-r1. Though it seems like a missing <sqlite dep then.
Comment 2 Mart Raudsepp gentoo-dev 2018-03-02 21:45:51 UTC
I can't test 1.540.0-r1 due to system-sqlite requring an older sqlite. 1.560.0 tests pass with USE=system-sqlite against sqlite-5.21.0.
Feel free to close INVALID if not deciding to tweak the sqlite dep in old 1.500.0.

Note that 1.560.0 needs stabling or 1.540-r1 USE=system-sqlite existence reconsidered due to bug 641108
Comment 3 Larry the Git Cow gentoo-dev 2018-03-03 01:58:48 UTC
The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=1e3aadf18792bd10d5577b971994641467258458

commit 1e3aadf18792bd10d5577b971994641467258458
Author:     Kent Fredric <kentnl@gentoo.org>
AuthorDate: 2018-03-03 01:53:25 +0000
Commit:     Kent Fredric <kentnl@gentoo.org>
CommitDate: 2018-03-03 01:57:33 +0000

    profiles: package.use.stable.mask dev-perl/DBD-SQLite[system-sqlite]
    
    - Using versions of system sqlite other than the one DBD-SQLite ships
     with causes regular issues that challenge the ability for tis package
     to have a meaning stability status
    - Restricting system sqlite versions to solve the above problem causes
     significant impediments to stabilizing sqlite. ( DBD-SQLites release
     cycle is somewhat behind that of SQLites )
    
    Bug: https://bugs.gentoo.org/641108
    Bug: https://bugs.gentoo.org/649408
    Bug: https://bugs.gentoo.org/640724

 profiles/base/package.use.stable.mask | 6 ++++++
 1 file changed, 6 insertions(+)}
Comment 4 Kent Fredric (IRC: kent\n) gentoo-dev 2019-07-10 09:49:02 UTC
@leio 

Are the mitigations presented here adequate for you? ( that is, blocking the use of this flag on systems that expect stability )

This flag exists only for people who want control, but we cannot guarantee at all that this control will give them something that works.
Comment 5 Kent Fredric (IRC: kent\n) gentoo-dev 2020-07-09 03:10:08 UTC
USE=system-sqlite seems to currently work with the latest 1.640.0

And tested with the oldest version currently in tree, 3.31.1

Please retest.

commit 5aa87584945e5ae652c70e9504273ed6de9baa2f
Author: Kent Fredric <kentnl@gentoo.org>
Date:   2020-07-09 13:59:37 +1200

    dev-perl/DBD-SQLite: Bump to version 1.640.0
    
    - EAPI7
    - Increase Min SQLITE for system-sqlite to 3.29
    - Simplify system-sqlite patching/pruning
    - Isolate config-only stuff to src_configure
    - Ensure CFLAGS passed to make/compiler
    
    Upstream:
    - Upgrade bundled SQLite to 3.29.0 for
      * security fixes
      * ALTER TABLE ... RENAME COLUMN
      * UPSERT
    - Add ::GetInfo
    - Fix to use a PV value as a virtual table column value where
      appropriate
    - Add deferability to foreign_key_info
    - Added ability to configure SQLITE_MAX_LENGTH via ENV
    - Add $dbh->sqlite_limit to change runtime limits
    - Update constants
    - Add sqlite_backup_{from_dbh,to_dbh} methods
    - Add $dbh->sqlite_prefer_numeric_type to prefer arrays of ints instead
      of arrays of strings in TYPE statemetns
    - Add sqlite_db_config method and related constants
    - Add sqlite_defensive option to prohibit dangerous SQLite features
    - Expose some hidden extended result codes
    - Ensure an internal HV is initialized
    - Handle 'unknown' op in DBD::SQLite::VirtualTable::PerlData
    - Avoid segmentation fault on big-endian 32bit
      https://github.com/DBD-SQLite/DBD-SQLite/issues/45
    - Fix ->quote($blob, SQL_BLOB) to quote correctly (injection risk)
      https://github.com/DBD-SQLite/DBD-SQLite/issues/51
    - Add sqlite_get_autocommit private query method
    
    Package-Manager: Portage-2.3.100, Repoman-2.3.22
    Signed-off-by: Kent Fredric <kentnl@gentoo.org>