From @andk

git bisect

commit 130c5df
Author​: Karl Williamson <khw@​cpan.org>
Date​: Thu Jun 12 13​:26​:24 2014 -0600

  Allow to compile if don't have LC_CTYPE etc defined

also affected

AUDREYT/DBD-SQLite-Amalgamation-3.6.1.2.tar.gz

diagnostics

http​://www.cpantesters.org/cpan/report/e1ce2ccc-f2fb-11e3-a720-689a0a370852

perl -V

Summary of my perl5 (revision 5 version 21 subversion 1) configuration​:
  Commit id​: 412f55b
  Platform​:
  osname=linux, osvers=3.14-1-amd64, archname=x86_64-linux-thread-multi-ld
  uname='linux k83 3.14-1-amd64 #1 smp debian 3.14.5-1 (2014-06-05) x86_64 gnulinux '
  config_args='-Dprefix=/home/sand/src/perl/repoperls/installed-perls/perl/v5.21.0-382-g412f55b/a2da -Dmyhostname=k83 -Dinstallusrbinperl=n -Uversiononly -Dusedevel -des -Ui_db -Duseithreads -Duselongdouble -DDEBUGGING=-g'
  hint=recommended, useposix=true, d_sigaction=define
  useithreads=define, usemultiplicity=define
  use64bitint=define, use64bitall=define, uselongdouble=define
  usemymalloc=n, bincompat5005=undef
  Compiler​:
  cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
  optimize='-O2 -g',
  cppflags='-D_REENTRANT -D_GNU_SOURCE -fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
  ccversion='', gccversion='4.8.3', gccosandvers=''
  intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
  d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
  ivtype='long', ivsize=8, nvtype='long double', nvsize=16, Off_t='off_t', lseeksize=8
  alignbytes=16, prototype=define
  Linker and Libraries​:
  ld='cc', ldflags =' -fstack-protector -L/usr/local/lib'
  libpth=/usr/local/lib /usr/lib/gcc/x86_64-linux-gnu/4.8/include-fixed /usr/include/x86_64-linux-gnu /usr/lib /lib/x86_64-linux-gnu /lib/../lib /usr/lib/x86_64-linux-gnu /usr/lib/../lib /lib
  libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc -lgdbm_compat
  perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
  libc=libc-2.19.so, so=so, useshrplib=false, libperl=libperl.a
  gnulibc_version='2.19'
  Dynamic Linking​:
  dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
  cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib -fstack-protector'

Characteristics of this binary (from libperl)​:
  Compile-time options​: HAS_TIMES MULTIPLICITY PERLIO_LAYERS
  PERL_DONT_CREATE_GVSV
  PERL_HASH_FUNC_ONE_AT_A_TIME_HARD
  PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
  PERL_NEW_COPY_ON_WRITE PERL_PRESERVE_IVUV
  PERL_USE_DEVEL USE_64_BIT_ALL USE_64_BIT_INT
  USE_ITHREADS USE_LARGE_FILES USE_LOCALE
  USE_LOCALE_COLLATE USE_LOCALE_CTYPE
  USE_LOCALE_NUMERIC USE_LONG_DOUBLE USE_PERLIO
  USE_PERL_ATOF USE_REENTRANT_API
  Built under linux
  Compiled at Jun 13 2014 07​:02​:46
  %ENV​:
  PERL5LIB=""
  PERL5OPT=""
  PERL5_CPANPLUS_IS_RUNNING="10875"
  PERL5_CPAN_IS_RUNNING="10875"
  PERL_MM_USE_DEFAULT="1"
  @​INC​:
  /home/sand/src/perl/repoperls/installed-perls/perl/v5.21.0-382-g412f55b/a2da/lib/site_perl/5.21.1/x86_64-linux-thread-multi-ld
  /home/sand/src/perl/repoperls/installed-perls/perl/v5.21.0-382-g412f55b/a2da/lib/site_perl/5.21.1
  /home/sand/src/perl/repoperls/installed-perls/perl/v5.21.0-382-g412f55b/a2da/lib/5.21.1/x86_64-linux-thread-multi-ld
  /home/sand/src/perl/repoperls/installed-perls/perl/v5.21.0-382-g412f55b/a2da/lib/5.21.1
  .

--
andreas

From @khwilliamson

Thanks for finding this. Now fixed by
commit 5778acb
Author​: Karl Williamson <khw@​cpan.org>
Date​: Wed Jun 18 13​:01​:41 2014 -0600

  PATCH​: [perl #122126] BBC DBD​::SQLite
 
  This problem turns out to be a misspelling in two places of a compiler
  definition. Since the definition didn't exist (as it was misspelled),
  the #ifdef failed.
 
  I don't know how really to test this as it is locale collation, which
  varies by locale, and we would be relying on vendor-supplied locales
  which may be inconsistent between platforms. I intend to tackle
  improvements to collaction later this release cycle, and should come up
  with tests at that time. The failing tests in the module were comparing
  the Perl sort results with those of the module, and finding they differ.
--
Karl Williamson

The RT System itself - Status changed from 'new' to 'open'

@khwilliamson - Status changed from 'open' to 'resolved'

From @jkeenan

On Tue Jun 17 23​:11​:53 2014, andreas.koenig.7os6VVqR@​franz.ak.mind.de wrote​:

git bisect
----------
commit 130c5df
Author​: Karl Williamson <khw@​cpan.org>
Date​: Thu Jun 12 13​:26​:24 2014 -0600

Allow to compile if don't have LC_CTYPE etc defined

also affected
-------------
AUDREYT/DBD-SQLite-Amalgamation-3.6.1.2.tar.gz

diagnostics
-----------
http​://www.cpantesters.org/cpan/report/e1ce2ccc-f2fb-11e3-a720-
689a0a370852

On Dromedary, using khwdebug.sh, I was unable to get a test failure for either DBD-SQLite-Amalgamation or DBD-SQLite. See output attached.

Thank you very much.
Jim Keenan

From @jkeenan

##### DBD-SQLite-Amalgamation

[dromedary-001​:DBD-SQLite-Amalgamation-3.6.1.2] 1002 $ /home/jkeenan/testing/blead/bin/perl Makefile.PL
Checking if your kit is complete...
Looks good
Using DBI 1.631 (for perl 5.021002 on x86_64-linux) installed in /home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD​::SQLite
Writing MYMETA.yml and MYMETA.json
[dromedary-001​:DBD-SQLite-Amalgamation-3.6.1.2] 1003 $ make test
cp lib/DBD/SQLite/Amalgamation.pm blib/lib/DBD/SQLite/Amalgamation.pm
cp lib/DBD/SQLite.pm blib/lib/DBD/SQLite.pm
Running Mkbootstrap for DBD​::SQLite ()
chmod 644 SQLite.bs
/home/jkeenan/testing/blead/bin/perl -p -e "s/DRIVER/SQLite/g" /home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI/Driver.xst > SQLite.xsi
/home/jkeenan/testing/blead/bin/perl /home/jkeenan/testing/blead/lib/perl5/5.21.2/ExtUtils/xsubpp -typemap /home/jkeenan/testing/blead/lib/perl5/5.21.2/ExtUtils/typemap SQLite.xs > SQLite.xsc && mv SQLite.xsc SQLite.c
cc -c -I. -I/home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DVERSION=\"1.14001\" -DXS_VERSION=\"1.14001\" -fPIC "-I/home/jkeenan/testing/blead/lib/perl5/5.21.2/x86_64-linux/CORE" -DSQLITE_ENABLE_FTS3=1 -DSQLITE_CORE -DNDEBUG=1 -DSQLITE_PTR_SZ=8 -DHAVE_USLEEP=1 -DTHREADSAFE=0 SQLite.c
cc -c -I. -I/home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DVERSION=\"1.14001\" -DXS_VERSION=\"1.14001\" -fPIC "-I/home/jkeenan/testing/blead/lib/perl5/5.21.2/x86_64-linux/CORE" -DSQLITE_ENABLE_FTS3=1 -DSQLITE_CORE -DNDEBUG=1 -DSQLITE_PTR_SZ=8 -DHAVE_USLEEP=1 -DTHREADSAFE=0 dbdimp.c
cc -c -I. -I/home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DVERSION=\"1.14001\" -DXS_VERSION=\"1.14001\" -fPIC "-I/home/jkeenan/testing/blead/lib/perl5/5.21.2/x86_64-linux/CORE" -DSQLITE_ENABLE_FTS3=1 -DSQLITE_CORE -DNDEBUG=1 -DSQLITE_PTR_SZ=8 -DHAVE_USLEEP=1 -DTHREADSAFE=0 sqlite-amalgamation.c
rm -f blib/arch/auto/DBD/SQLite/SQLite.so
cc -shared -O2 -L/usr/local/lib -fstack-protector SQLite.o dbdimp.o sqlite-amalgamation.o -o blib/arch/auto/DBD/SQLite/SQLite.so \
  \
 
chmod 755 blib/arch/auto/DBD/SQLite/SQLite.so
/home/jkeenan/testing/blead/bin/perl -MExtUtils​::Command​::MM -e 'cp_nonempty' -- SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs 644
PERL_DL_NONLAZY=1 /home/jkeenan/testing/blead/bin/perl "-MExtUtils​::Command​::MM" "-MTest​::Harness" "-e" "undef *Test​::Harness​::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00basic.t ............. ok
t/01logon.t ............. ok
t/02cr_table.t .......... ok
t/03insert.t ............ ok
t/04select.t ............ ok
t/05tran.t .............. ok
t/06error.t ............. ok
t/08create_function.t ... ok
t/09create_aggregate.t .. ok
t/10dsnlist.t ........... ok
t/11unicode.t ........... ok
t/12create_collation.t .. ok
t/13progress_handler.t .. ok
t/20createdrop.t ........ ok
t/30insertfetch.t ....... ok
t/40bindparam.t ......... ok
t/40blobs.t ............. ok
t/40blobtext.t .......... ok
t/40listfields.t ........ ok
t/40nulls.t ............. ok
t/40numrows.t ........... ok
t/40prepcached.t ........ ok
t/50chopblanks.t ........ ok
t/50commit.t ............ ok
t/60metadata.t .......... ok
t/90cppcomments.t ....... ok
t/99cleanup.t ........... ok
t/ak-dbd.t .............. ok
t/column-info.t ......... 1/7 # Testing DBD​::SQLite version '1.14001' on DBI '1.631'
t/column-info.t ......... ok
t/dbdadmin.t ............ ok
All tests successful.
Files=30, Tests=412, 2 wallclock secs ( 0.19 usr 0.04 sys + 1.38 cusr 0.22 csys = 1.83 CPU)
Result​: PASS

##### DBD-SQLite

[dromedary-001​:perl] 1023 $ have_blead_run_cpanm_only.sh
++ PERL5OPT=
++ test_jobs=8
++ dir=/home/jkeenan/testing/blead
++ wget --no-check-certificate -O- -q http​://bit.ly/cpanm
++ /home/jkeenan/testing/blead/bin/perl - -v App​::cpanminus
++ module=DBD​::SQLite
++ /home/jkeenan/testing/blead/bin/cpanm --installdeps DBD​::SQLite
--> Working on DBD​::SQLite
Fetching http​://www.cpan.org/authors/id/I/IS/ISHIGAKI/DBD-SQLite-1.42.tar.gz ... OK
Configuring DBD-SQLite-1.42 ... OK
<== Installed dependencies for DBD​::SQLite. Finishing.
++ set +x
About to cd a work space directory
From there, run '/home/jkeenan/testing/blead/bin/perl Makefile.PL'
And then, probably 'make test'
--> Working on DBD​::SQLite
Fetching http​://www.cpan.org/authors/id/I/IS/ISHIGAKI/DBD-SQLite-1.42.tar.gz ... OK
Entering /home/jkeenan/.cpanm/work/1403347945.12477/DBD-SQLite-1.42 with /bin/bash
[dromedary-001​:DBD-SQLite-1.42] 1001 $ /home/jkeenan/testing/blead/bin/perl Makefile.PL
Checking if your kit is complete...
Looks good
Using DBI 1.631 (for perl 5.021002 on x86_64-linux) installed in /home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD​::SQLite
Writing MYMETA.yml and MYMETA.json
[dromedary-001​:DBD-SQLite-1.42] 1002 $ make test
cp lib/DBD/SQLite/Cookbook.pod blib/lib/DBD/SQLite/Cookbook.pod
cp lib/DBD/SQLite.pm blib/lib/DBD/SQLite.pm
Running Mkbootstrap for DBD​::SQLite ()
chmod 644 SQLite.bs
/home/jkeenan/testing/blead/bin/perl -p -e "s/DRIVER/SQLite/g" /home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI/Driver.xst > SQLite.xsi
/home/jkeenan/testing/blead/bin/perl /home/jkeenan/testing/blead/lib/perl5/5.21.2/ExtUtils/xsubpp -typemap /home/jkeenan/testing/blead/lib/perl5/5.21.2/ExtUtils/typemap -typemap typemap SQLite.xs > SQLite.xsc && mv SQLite.xsc SQLite.c
cc -c -I. -I/home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Wl,-Bsymbolic -O2 -O2 -DVERSION=\"1.42\" -DXS_VERSION=\"1.42\" -fPIC "-I/home/jkeenan/testing/blead/lib/perl5/5.21.2/x86_64-linux/CORE" -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_STAT3 -DNDEBUG=1 -DHAVE_USLEEP=1 -DTHREADSAFE=0 SQLite.c
cc -c -I. -I/home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Wl,-Bsymbolic -O2 -O2 -DVERSION=\"1.42\" -DXS_VERSION=\"1.42\" -fPIC "-I/home/jkeenan/testing/blead/lib/perl5/5.21.2/x86_64-linux/CORE" -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_STAT3 -DNDEBUG=1 -DHAVE_USLEEP=1 -DTHREADSAFE=0 dbdimp.c
cc -c -I. -I/home/jkeenan/testing/blead/lib/perl5/site_perl/5.21.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Wl,-Bsymbolic -O2 -O2 -DVERSION=\"1.42\" -DXS_VERSION=\"1.42\" -fPIC "-I/home/jkeenan/testing/blead/lib/perl5/5.21.2/x86_64-linux/CORE" -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_STAT3 -DNDEBUG=1 -DHAVE_USLEEP=1 -DTHREADSAFE=0 sqlite3.c
rm -f blib/arch/auto/DBD/SQLite/SQLite.so
cc -shared -O2 -L/usr/local/lib -fstack-protector -Wl,-Bsymbolic SQLite.o dbdimp.o sqlite3.o -o blib/arch/auto/DBD/SQLite/SQLite.so \
  \
 
chmod 755 blib/arch/auto/DBD/SQLite/SQLite.so
/home/jkeenan/testing/blead/bin/perl -MExtUtils​::Command​::MM -e 'cp_nonempty' -- SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs 644
PERL_DL_NONLAZY=1 /home/jkeenan/testing/blead/bin/perl "-MExtUtils​::Command​::MM" "-MTest​::Harness" "-e" "undef *Test​::Harness​::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01_compile.t ................................... 1/3 # $DBI​::VERSION=1.631
# Compile Options​:
# ENABLE_COLUMN_METADATA
# ENABLE_FTS3
# ENABLE_FTS3_PARENTHESIS
# ENABLE_FTS4
# ENABLE_RTREE
# ENABLE_STAT3
# SYSTEM_MALLOC
# THREADSAFE=0
t/01_compile.t ................................... ok
t/02_logon.t ..................................... 1/37 # sqlite_version=3.8.4.1
t/02_logon.t ..................................... ok
t/03_create_table.t .............................. ok
t/04_insert.t .................................... ok
t/05_select.t .................................... ok
t/06_tran.t ...................................... ok
t/07_error.t ..................................... ok
t/08_busy.t ...................................... ok
t/09_create_function.t ........................... ok
t/10_create_aggregate.t .......................... ok
t/12_unicode.t ................................... ok
t/13_create_collation.t .......................... ok
t/14_progress_handler.t .......................... ok
t/15_ak_dbd.t .................................... ok
t/16_column_info.t ............................... ok
t/17_createdrop.t ................................ ok
t/18_insertfetch.t ............................... ok
t/19_bindparam.t ................................. ok
t/20_blobs.t ..................................... ok
t/21_blobtext.t .................................. ok
t/22_listfields.t ................................ ok
t/23_nulls.t ..................................... ok
t/24_numrows.t ................................... ok
t/25_chopblanks.t ................................ ok
t/26_commit.t .................................... ok
t/27_metadata.t .................................. ok
t/28_schemachange.t .............................. ok
t/29_cppcomments.t ............................... ok
t/30_auto_rollback.t ............................. ok
t/31_bind_weird_number_param.t ................... ok
t/32_inactive_error.t ............................ ok
t/33_non_latin_path.t ............................ ok
t/34_online_backup.t ............................. ok
t/35_table_info.t ................................ ok
t/36_hooks.t ..................................... ok
t/37_regexp.t .................................... ok
t/38_empty_statement.t ........................... ok
t/39_foreign_keys.t .............................. ok
t/40_multiple_statements.t ....................... ok
t/41_placeholders.t .............................. ok
t/42_primary_key_info.t .......................... ok
t/43_fts3.t ...................................... ok
t/44_rtree.t ..................................... ok
t/45_savepoints.t ................................ ok
t/46_mod_perl.t .................................. skipped​: requires APR​::Table
t/47_execute.t ................................... ok
t/48_bind_param_is_sticky.t ...................... ok
t/49_trace_and_profile.t ......................... ok
t/50_foreign_key_info.t .......................... ok
t/51_table_column_metadata.t ..................... ok
t/52_db_filename.t ............................... ok
t/53_status.t .................................... ok
t/54_literal_txn.t ............................... ok
t/55_statistics_info.t ........................... ok
t/56_open_flags.t ................................ ok
t/57_uri_filename.t .............................. ok
t/58_see_if_its_a_number_and_explicit_binding.t .. ok
t/cookbook_variance.t ............................ ok
t/rt_15186_prepcached.t .......................... ok
t/rt_21406_auto_finish.t ......................... ok
t/rt_25371_asymmetric_unicode.t .................. ok
t/rt_25460_numeric_aggregate.t ................... ok
t/rt_25924_user_defined_func_unicode.t ........... ok
t/rt_26775_distinct.t ............................ ok
t/rt_27553_prepared_cache_and_analyze.t .......... ok
t/rt_29058_group_by.t ............................ ok
t/rt_29629_sqlite_where_length.t ................. ok
t/rt_31324_full_names.t .......................... ok
t/rt_32889_prepare_cached_reexecute.t ............ ok
t/rt_36836_duplicate_key.t ....................... ok
t/rt_36838_unique_and_bus_error.t ................ ok
t/rt_40594_nullable.t ............................ ok
t/rt_48393_debug_panic_with_commit.t ............. skipped​: set $ENV{TEST_DBD_SQLITE_WITH_DEBUGGER} to enable this test
t/rt_50503_fts3.t ................................ ok
t/rt_52573_manual_exclusive_lock.t ............... ok
t/rt_53235_icu_compatibility.t ................... skipped​: requires SQLite ICU plugin to be enabled
t/rt_62370_diconnected_handles_operation.t ....... ok
t/rt_64177_ping_wipes_out_the_errstr.t ........... ok
t/rt_67581_bind_params_mismatch.t ................ ok
t/rt_71311_bind_col_and_unicode.t ................ ok
t/rt_73159_fts_tokenizer_segfault.t .............. ok
t/rt_73787_exponential_buffer_overflow.t ......... ok
t/rt_76395_int_overflow.t ........................ ok
t/rt_77724_primary_key_with_a_whitespace.t ....... ok
t/rt_78833_utf8_flag_for_column_names.t .......... ok
t/rt_81536_multi_column_primary_key_info.t ....... ok
t/rt_88228_sqlite_3_8_0_crash.t .................. ok
All tests successful.
Files=87, Tests=1946, 13 wallclock secs ( 0.54 usr 0.12 sys + 5.05 cusr 0.61 csys = 6.32 CPU)
Result​: PASS

From @andk

On Sat, 21 Jun 2014 03​:57​:43 -0700, "James E Keenan via RT" <perlbug-followup@​perl.org> said​:

  > On Dromedary, using khwdebug.sh, I was unable to get a test failure
  > for either DBD-SQLite-Amalgamation or DBD-SQLite. See output
  > attached.

Confirmed, the fix in v5.21.0-476-g5778acb fixed the issue also for me.

--
andreas