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

Bug 677680

Summary: dev-perl/DBD-SQLite-1.580.0 : [TEST] # Failed test correct database is not created for uri
Product: Gentoo Linux Reporter: Toralf Förster <toralf>
Component: Current packagesAssignee: Gentoo Perl team <perl>
Status: CONFIRMED ---    
Severity: normal CC: kentnl
Priority: Normal Keywords: TESTFAILURE
Version: unspecified   
Hardware: All   
OS: Linux   
URL: https://github.com/DBD-SQLite/DBD-SQLite/issues/47
See Also: https://bugs.gentoo.org/show_bug.cgi?id=640724
Whiteboard:
Package list:
Runtime testing required: ---
Bug Depends on:    
Bug Blocks: 300119    
Attachments: emerge-info.txt
dev-perl:DBD-SQLite-1.580.0:20190210-193123.log
emerge-history.txt
environment
etc.portage.tbz2
temp.tbz2
tests.tbz2

Description Toralf Förster gentoo-dev 2019-02-10 20:55:22 UTC
t/57_uri_filename.t ................................... 
t/57_uri_filename.t ................................... 1/17 
#   Failed test 'correct database is not created for uri'
#   at t/57_uri_filename.t line 44.
# Looks like you failed 1 test of 17.


  -------------------------------------------------------------------

  This is an unstable amd64 chroot image at a tinderbox (==build bot)
  name: 17.0-hardened_test_20190209-222026

  -------------------------------------------------------------------

gcc-config -l:
 [1] x86_64-pc-linux-gnu-8.2.0 *

Available Python interpreters, in order of preference:
  [1]   python3.6
  [2]   python2.7 (fallback)

Available Rust versions:
  [1]   rust-1.32.0 *



emerge -qpvO dev-perl/DBD-SQLite
[ebuild  N    ] dev-perl/DBD-SQLite-1.580.0  USE="system-sqlite test"
Comment 1 Toralf Förster gentoo-dev 2019-02-10 20:55:24 UTC
Created attachment 564604 [details]
emerge-info.txt
Comment 2 Toralf Förster gentoo-dev 2019-02-10 20:55:27 UTC
Created attachment 564606 [details]
dev-perl:DBD-SQLite-1.580.0:20190210-193123.log
Comment 3 Toralf Förster gentoo-dev 2019-02-10 20:55:30 UTC
Created attachment 564608 [details]
emerge-history.txt
Comment 4 Toralf Förster gentoo-dev 2019-02-10 20:55:32 UTC
Created attachment 564610 [details]
environment
Comment 5 Toralf Förster gentoo-dev 2019-02-10 20:55:35 UTC
Created attachment 564612 [details]
etc.portage.tbz2
Comment 6 Toralf Förster gentoo-dev 2019-02-10 20:55:38 UTC
Created attachment 564614 [details]
temp.tbz2
Comment 7 Toralf Förster gentoo-dev 2019-02-10 20:55:41 UTC
Created attachment 564616 [details]
tests.tbz2
Comment 8 Kent Fredric (IRC: kent\n) gentoo-dev 2019-02-10 20:59:34 UTC
USE=system-sqlite is mostly unsupported, and use-stable-masked for this reason.

See: https://wiki.gentoo.org/wiki/Project:Perl/maint-notes/dev-perl/DBD-SQLite

Its possibly fixable, but it may require restricting the dependencies to versions of SQLite that no longer exist in tree.


https://bugs.gentoo.org/640724#c10
Comment 9 Kent Fredric (IRC: kent\n) gentoo-dev 2020-07-09 03:06:48 UTC
This should be fixed in the just pushed 1.640.0

Upstream bug: 
- https://github.com/DBD-SQLite/DBD-SQLite/issues/47

Mentioning fix in 1.63_02
- https://metacpan.org/source/ISHIGAKI/DBD-SQLite-1.64/Changes#L24


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>

Please retest and confirm fixed.