Skip Menu |

This queue is for tickets about the Test-Database CPAN distribution.

Report information
The Basics
Id: 56463
Status: open
Priority: 0/
Queue: Test-Database

People
Owner: Nobody in particular
Requestors: daxim [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: 1.09
Fixed in: (no value)



Subject: DBD::DBM failure
Show quoted text
> prove -bv t/25-sql.t
t/25-sql.t .. 1..54 ok 1 - The object isa Test::Database::Driver # Testing driver CSV 0.72, DBD::CSV 0.28 ok 2 - CSV tdd_csv_daxim_1 isa Test::Database::Handle ok 3 - The object isa DBI::db ok 4 - CSV(tdd_csv_daxim_1): CREATE TABLE users (id INTEGER, name VARCHAR(64)) ok 5 - CSV(tdd_csv_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book') ok 6 - CSV(tdd_csv_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo') ok 7 - CSV(tdd_csv_daxim_1): SELECT id, name FROM users ok 8 - CSV(tdd_csv_daxim_1): DROP TABLE users ok 9 - CSV tdd_csv_daxim_1 isa Test::Database::Handle ok 10 - Got db tdd_csv_daxim_1 again ok 11 - The object isa DBI::db ok 12 - CSV(tdd_csv_daxim_1): CREATE TABLE users (id INTEGER, name VARCHAR(64)) ok 13 - CSV(tdd_csv_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book') ok 14 - CSV(tdd_csv_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo') ok 15 - CSV(tdd_csv_daxim_1): SELECT id, name FROM users ok 16 - CSV(tdd_csv_daxim_1): DROP TABLE users ok 17 - Database tdd_csv_daxim_1 still there ok 18 - Database tdd_csv_daxim_1 was dropped # Testing driver DBM 0.03, DBD::DBM 0.03 ok 19 - The object isa Test::Database::Driver ok 20 - DBM tdd_dbm_daxim_1 isa Test::Database::Handle ok 21 - The object isa DBI::db DBD::DBM::db do failed: Execution ERROR: Table 'users' already exists.. [for Statement "CREATE TABLE users (id INTEGER, name VARCHAR(64))"] at t/25-sql.t line 56. not ok 22 - DBM(tdd_dbm_daxim_1): CREATE TABLE users (id INTEGER, name VARCHAR(64)) # Failed test 'DBM(tdd_dbm_daxim_1): CREATE TABLE users (id INTEGER, name VARCHAR(64))' # at t/25-sql.t line 56. DBD::DBM::db do failed: Use of uninitialized value in array element at /home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement.pm line 297. [for Statement "INSERT INTO users (id, name) VALUES (1, 'book')"] at t/25-sql.t line 56. not ok 23 - DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book') # Failed test 'DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book')' # at t/25-sql.t line 56. DBD::DBM::db do failed: Use of uninitialized value in array element at /home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement.pm line 297. [for Statement "INSERT INTO users (id, name) VALUES (2, 'echo')"] at t/25-sql.t line 56. not ok 24 - DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo') # Failed test 'DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo')' # at t/25-sql.t line 56. DBD::DBM::db selectall_arrayref failed: Can't call method "column" on an undefined value at /home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement/Term.pm line 190. [for Statement "SELECT id, name FROM users"] at t/25-sql.t line 59. not ok 25 - DBM(tdd_dbm_daxim_1): SELECT id, name FROM users # Failed test 'DBM(tdd_dbm_daxim_1): SELECT id, name FROM users' # at t/25-sql.t line 60. # Structures begin differing at: # $got = undef # $expected = ARRAY(0x1549400) ok 26 - DBM(tdd_dbm_daxim_1): DROP TABLE users ok 27 - DBM tdd_dbm_daxim_1 isa Test::Database::Handle ok 28 - Got db tdd_dbm_daxim_1 again ok 29 - The object isa DBI::db DBD::DBM::db do failed: Execution ERROR: Table 'users' already exists.. [for Statement "CREATE TABLE users (id INTEGER, name VARCHAR(64))"] at t/25-sql.t line 56. not ok 30 - DBM(tdd_dbm_daxim_1): CREATE TABLE users (id INTEGER, name VARCHAR(64)) # Failed test 'DBM(tdd_dbm_daxim_1): CREATE TABLE users (id INTEGER, name VARCHAR(64))' # at t/25-sql.t line 56. DBD::DBM::db do failed: Use of uninitialized value in array element at /home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement.pm line 297. [for Statement "INSERT INTO users (id, name) VALUES (1, 'book')"] at t/25-sql.t line 56. not ok 31 - DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book') # Failed test 'DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book')' # at t/25-sql.t line 56. DBD::DBM::db do failed: Use of uninitialized value in array element at /home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement.pm line 297. [for Statement "INSERT INTO users (id, name) VALUES (2, 'echo')"] at t/25-sql.t line 56. not ok 32 - DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo') # Failed test 'DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo')' # at t/25-sql.t line 56. DBD::DBM::db selectall_arrayref failed: Can't call method "column" on an undefined value at /home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement/Term.pm line 190. [for Statement "SELECT id, name FROM users"] at t/25-sql.t line 59. not ok 33 - DBM(tdd_dbm_daxim_1): SELECT id, name FROM users # Failed test 'DBM(tdd_dbm_daxim_1): SELECT id, name FROM users' # at t/25-sql.t line 60. # Structures begin differing at: # $got = undef # $expected = ARRAY(0x1529f88) ok 34 - DBM(tdd_dbm_daxim_1): DROP TABLE users ok 35 - Database tdd_dbm_daxim_1 still there ok 36 - Database tdd_dbm_daxim_1 was dropped # Testing driver SQLite 3.6.22, DBD::SQLite 1.29 ok 37 - The object isa Test::Database::Driver ok 38 - SQLite tdd_sqlite_daxim_1 isa Test::Database::Handle ok 39 - The object isa DBI::db ok 40 - SQLite(tdd_sqlite_daxim_1): CREATE TABLE users (id INTEGER, name VARCHAR(64)) ok 41 - SQLite(tdd_sqlite_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book') ok 42 - SQLite(tdd_sqlite_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo') ok 43 - SQLite(tdd_sqlite_daxim_1): SELECT id, name FROM users ok 44 - SQLite(tdd_sqlite_daxim_1): DROP TABLE users ok 45 - SQLite tdd_sqlite_daxim_1 isa Test::Database::Handle ok 46 - Got db tdd_sqlite_daxim_1 again ok 47 - The object isa DBI::db ok 48 - SQLite(tdd_sqlite_daxim_1): CREATE TABLE users (id INTEGER, name VARCHAR(64)) ok 49 - SQLite(tdd_sqlite_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book') ok 50 - SQLite(tdd_sqlite_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo') ok 51 - SQLite(tdd_sqlite_daxim_1): SELECT id, name FROM users ok 52 - SQLite(tdd_sqlite_daxim_1): DROP TABLE users ok 53 - Database tdd_sqlite_daxim_1 still there ok 54 - Database tdd_sqlite_daxim_1 was dropped # Looks like you failed 8 tests of 54. Dubious, test returned 8 (wstat 2048, 0x800) Failed 8/54 subtests Test Summary Report ------------------- t/25-sql.t (Wstat: 2048 Tests: 54 Failed: 8) Failed tests: 22-25, 30-33 Non-zero exit status: 8 Files=1, Tests=54, 1 wallclock secs ( 0.10 usr 0.01 sys + 0.42 cusr 0.07 csys = 0.60 CPU) Result: FAIL Show quoted text
> perl -V
Summary of my perl5 (revision 5 version 10 subversion 1) configuration: Platform: osname=linux, osvers=2.6.27.29-0.1-default, archname=x86_64-linux-thread-multi-ld uname='linux galahad 2.6.27.29-0.1-default #1 smp 2009-08-15 17:53:59 +0200 x86_64 x86_64 x86_64 gnulinux ' config_args='-Accflags=-fPIC -DDEBUGGING -DPERL_USE_SAFE_PUTENV -Dcf_email=daxim@cpan.org -Dhtml1dir=/home/daxim/local/share/doc/perl5 -Dhtml3dir=/home/daxim/local/share/doc/perl5 -Dnoextensions=ODBM_File -Dman1dir=/home/daxim/local/share/man/man1 -Dman3dir=/home/daxim/local/share/man/man3 -Dperladmin=daxim@cpan.org -Dprefix=/home/daxim/local -Dusemorebits -Dusethreads -des' hint=recommended, useposix=true, d_sigaction=define useithreads=define, usemultiplicity=define useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=define, use64bitall=define, uselongdouble=define usemymalloc=n, bincompat5005=undef Compiler: cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fPIC -DDEBUGGING -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 -fPIC -DDEBUGGING -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include' ccversion='', gccversion='4.3.2 [gcc-4_3-branch revision 141291]', 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 /lib /usr/lib /lib64 /usr/lib64 /usr/local/lib64 libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc -lgdbm_compat perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc libc=/lib/libc-2.9.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='2.9' 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: DEBUGGING MULTIPLICITY PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP PERL_TRACK_MEMPOOL USE_64_BIT_ALL USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES USE_LONG_DOUBLE USE_PERLIO USE_REENTRANT_API Built under linux Compiled at Oct 16 2009 18:50:04 %ENV: PERL_EXTUTILS_AUTOINSTALL="--default-deps" @INC: /home/daxim/local/lib/perl5/5.10.1/x86_64-linux-thread-multi-ld /home/daxim/local/lib/perl5/5.10.1 /home/daxim/local/lib/perl5/site_perl/5.10.1/x86_64-linux-thread-multi-ld /home/daxim/local/lib/perl5/site_perl/5.10.1 .
This works for me on "master" branch with DBD::DBM 0.08. I think this ticket can be closed.