Bug 677680 – dev-perl/DBD-SQLite-1.580.0 : [TEST] # Failed test correct database is not created for uri

• Product: Gentoo Linux
• Status: RESOLVED FIXED

[Description Toralf Förster 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 2019-02-10 20:55:24 UTC]

Created attachment 564604 [details]
emerge-info.txt

[Comment 2 Toralf Förster 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 2019-02-10 20:55:30 UTC]

Created attachment 564608 [details]
emerge-history.txt

[Comment 4 Toralf Förster 2019-02-10 20:55:32 UTC]

Created attachment 564610 [details]
environment

[Comment 5 Toralf Förster 2019-02-10 20:55:35 UTC]

Created attachment 564612 [details]
etc.portage.tbz2

[Comment 6 Toralf Förster 2019-02-10 20:55:38 UTC]

Created attachment 564614 [details]
temp.tbz2

[Comment 7 Toralf Förster 2019-02-10 20:55:41 UTC]

Created attachment 564616 [details]
tests.tbz2

[Comment 8 Kent Fredric (IRC: kent\n) (RETIRED) 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) (RETIRED) 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 <[e-mail]>
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 <[e-mail]>

Please retest and confirm fixed.

[Comment 10 Larry the Git Cow 2021-05-01 15:29:34 UTC]

The bug has been closed via the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=2bc794850d57f994586939754866b45fb7917eaf

commit 2bc794850d57f994586939754866b45fb7917eaf
Author:     Andreas K. Hüttel <[e-mail]>
AuthorDate: 2021-05-01 14:41:14 +0000
Commit:     Andreas K. Hüttel <[e-mail]>
CommitDate: 2021-05-01 15:29:19 +0000

    dev-perl/DBD-SQLite: Remove old
    
    Closes: https://bugs.gentoo.org/677680
    Closes: https://bugs.gentoo.org/649408
    Package-Manager: Portage-3.0.18, Repoman-3.0.2
    Signed-off-by: Andreas K. Hüttel <[e-mail]>

 dev-perl/DBD-SQLite/DBD-SQLite-1.560.0.ebuild | 48 ---------------------------
 dev-perl/DBD-SQLite/DBD-SQLite-1.580.0.ebuild | 48 ---------------------------
 dev-perl/DBD-SQLite/Manifest                  |  2 --
 3 files changed, 98 deletions(-)