| Subject: | Failed test: ttschema-producer and tt-table-producer |
The attachment contains the output I got from install SQL::Traslator in
CPAN.pm (only the tests part).
HTH.
| Subject: | uname-a.txt |
serverlinux ~ # uname -a
Linux serverlinux 2.6.16-gentoo-r9 #3 SMP Fri Mar 23 12:55:22 CET 2007 i686 Intel(R) Pentium(R) 4 CPU 2.60GHz GenuineIntel GNU/Linux
| Subject: | perl-V.txt |
serverlinux ~ # perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=linux, osvers=2.6.16-gentoo-r9, archname=i686-linux
uname='linux serverlinux 2.6.16-gentoo-r9 #2 smp fri jul 7 09:44:09 cest 2006 i686 intel(r) pentium(r) 4 cpu 2.60ghz genuineintel gnulinux '
config_args='-des -Darchname=i686-linux -Dcccdlflags=-fPIC -Dccdlflags=-rdynamic -Dcc=i686-pc-linux-gnu-gcc -Dprefix=/usr -Dvendorprefix=/usr -Dsiteprefix=/usr -Dlocincpth= -Doptimize=-O2 -march=i686 -pipe -Duselargefiles -Dd_semctl_semun -Dscriptdir=/usr/bin -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dinstallman1dir=/usr/share/man/man1 -Dinstallman3dir=/usr/share/man/man3 -Dman1ext=1 -Dman3ext=3pm -Dinc_version_list=5.8.0 5.8.0/i686-linux 5.8.2 5.8.2/i686-linux 5.8.4 5.8.4/i686-linux 5.8.5 5.8.5/i686-linux 5.8.6 5.8.6/i686-linux 5.8.7 5.8.7/i686-linux -Dcf_by=Gentoo -Ud_csh -Dusenm -Di_ndbm -Di_gdbm -Di_db'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='i686-pc-linux-gnu-gcc', ccflags ='-fno-strict-aliasing -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
optimize='-O2 -march=i686 -pipe',
cppflags='-fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/include/gdbm'
ccversion='', gccversion='3.4.4 (Gentoo 3.4.4-r1, ssp-3.4.4-1.0, pie-8.7.8)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='i686-pc-linux-gnu-gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lpthread -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc
perllibs=-lpthread -lnsl -ldl -lm -lcrypt -lutil -lc
libc=/lib/libc-2.3.5.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.3.5'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: PERL_MALLOC_WRAP USE_LARGE_FILES USE_PERLIO
Built under linux
Compiled at Jul 7 2006 15:26:05
@INC:
/etc/perl
/usr/lib/perl5/vendor_perl/5.8.8/i686-linux
/usr/lib/perl5/vendor_perl/5.8.8
/usr/lib/perl5/vendor_perl/5.8.7
/usr/lib/perl5/vendor_perl/5.8.7/i686-linux
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/site_perl/5.8.8/i686-linux
/usr/lib/perl5/site_perl/5.8.8
/usr/lib/perl5/site_perl
/usr/lib/perl5/5.8.8/i686-linux
/usr/lib/perl5/5.8.8
/usr/local/lib/site_perl
.
serverlinux ~ #
| Subject: | sql-translator-install-errors.txt |
/usr/bin/perl5.8.8 Build --makefile_env_macros 1 test
t/02mysql-parser...........ok
t/03mysql-to-oracle........ok
t/04file,fh,string.........ok
t/05bgep-re................skipped
all skipped: Missing dependency: XML::Writer
t/06xsv....................skipped
all skipped: Missing dependency: Text::RecordParser
t/07p_args.................ok
t/08postgres-to-mysql......ok
t/09sqlt-diagram...........ok
t/10excel..................skipped
all skipped: Missing dependency: Spreadsheet::ParseExcel
t/11normalize..............ok
t/12header_comment.........ok
t/13schema.................ok
t/14postgres-parser........ok
t/15oracle-parser..........ok
t/16xml-parser.............ok
t/17sqlfxml-producer.......skipped
all skipped: Missing dependencies: XML::Writer, XML::Writer
t/18ttschema-producer......ok 1/6
# Failed test 'Output looks right'
t/18ttschema-producer......NOK 3/6# at t/18ttschema-producer.t line 57.
# +----+-----------------------------------------+----------------------------------------+
# | Ln|Got |Expected |
# +----+-----------------------------------------+----------------------------------------+
# | 147|Constraints |Constraints |
# | 148| ? | ? |
# | 149| type: PRIMARY KEY | type: PRIMARY KEY |
# * 150| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: id\n *
# | 151| expression: | expression: |
# | 152| match_type: | match_type: |
# | 153| reference_fields: | reference_fields: |
# +----+-----------------------------------------+----------------------------------------+
# | 160| | |
# | 161| emailuniqueindex | emailuniqueindex |
# | 162| type: UNIQUE | type: UNIQUE |
# * 163| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: email\n *
# | 164| expression: | expression: |
# | 165| match_type: | match_type: |
# | 166| reference_fields: | reference_fields: |
# +----+-----------------------------------------+----------------------------------------+
# | 173| | |
# | 174| ? | ? |
# | 175| type: FOREIGN KEY | type: FOREIGN KEY |
# * 176| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: another_id\n *
# | 177| expression: | expression: |
# | 178| match_type: | match_type: |
# * 179| reference_fields:\s\n | reference_fields: id\n *
# | 180| reference_table: Another | reference_table: Another |
# | 181| deferrable: 1 | deferrable: 1 |
# | 182| on_delete: | on_delete: |
# +----+-----------------------------------------+----------------------------------------+
# | 208|Constraints |Constraints |
# | 209| ? | ? |
# | 210| type: PRIMARY KEY | type: PRIMARY KEY |
# * 211| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: id\n *
# | 212| expression: | expression: |
# | 213| match_type: | match_type: |
# | 214| reference_fields: | reference_fields: |
# +----+-----------------------------------------+----------------------------------------+
#
t/18ttschema-producer......ok 4/6# Looks like you failed 1 test of 6.
t/18ttschema-producer......dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 3
Failed 1/6 tests, 83.33% okay
t/19sybase-parser..........ok
t/20format_X_name..........ok
t/24yaml...................ok
t/25storable...............ok
t/26sybase.................ok
t/27sqlite-parser..........ok
t/29html...................ok
t/30sqlt-diff..............ok
t/31dumper.................ok
t/32schema-lookups.........ok
t/33tt-table-producer......Creating /tmp/WrLppzHRb7/person.txt.
Creating /tmp/WrLppzHRb7/pet.txt.
t/33tt-table-producer......ok 1/8
# Failed test 'Output looks right'
# at t/33tt-table-producer.t line 62.
# +---+----------------------------------------------------+----------------------------------------------------+
# | Ln|Got |Expected |
# +---+----------------------------------------------------+----------------------------------------------------+
# | 1|Table: person |Table: person |
# * 2| Primary Key:\s\s\n | Primary Key: person_id\n *
# | 3| Foreign Keys: | Foreign Keys: |
# | 4| Data Fields: name, age, weight, iq, description | Data Fields: name, age, weight, iq, description |
# | 5| | |
# | 6|Table: pet |Table: pet |
# | 7| Primary Key: pet_id, person_id | Primary Key: pet_id, person_id |
# | 8| Foreign Keys: | Foreign Keys: |
# | 9| Data Fields: name, age | Data Fields: name, age |
# | 10| | |
# +---+----------------------------------------------------+----------------------------------------------------+
#
t/33tt-table-producer......NOK 3/8
# Failed test 'person.txt looks right'
# at t/33tt-table-producer.t line 71.
# +---+----------------------------------------------------+----------------------------------------------------+
# | Ln|Got |Expected |
# +---+----------------------------------------------------+----------------------------------------------------+
# | 1|Table: person |Table: person |
# * 2| Primary Key:\s\s\n | Primary Key: person_id\n *
# | 3| Foreign Keys: | Foreign Keys: |
# | 4| Data Fields: name, age, weight, iq, description | Data Fields: name, age, weight, iq, description |
# | 5| | |
# +---+----------------------------------------------------+----------------------------------------------------+
#
t/33tt-table-producer......NOK 7/8# Looks like you failed 2 tests of 8.
t/33tt-table-producer......dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 3, 7
Failed 2/8 tests, 75.00% okay
t/34tt-base................ok
t/35-access-parser.........ok
t/36-filters...............ok
t/37-translator-graph......ok
t/38-filter-names..........ok
t/38-mysql-producer........ok
t/40oracle-parser-dbi......ok
t/42shell..................ok
t/43xml-to-db2.............ok
t/44-xml-to-db2-array......ok
t/45db2-producer...........ok
t/46xml-to-pg..............ok
t/47postgres-producer......ok
t/48xml-to-sqlite..........ok
t/49xml-to-pg-samefield....ok
Failed Test Stat Wstat Total Fail List of Failed
-------------------------------------------------------------------------------
t/18ttschema-producer.t 1 256 6 1 3
t/33tt-table-producer.t 2 512 8 2 3 7
4 tests skipped.
Failed 2/43 test scripts. 3/1200 subtests failed.
Files=43, Tests=1200, 99 wallclock secs (96.35 cusr + 2.45 csys = 98.80 CPU)
Failed 2/43 test programs. 3/1200 subtests failed.
make: *** [test] Error 255
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force
Failed during this command:
JROBINSON/SQL-Translator-0.08.tar.gz : make_test NO
cpan> m Template
Fetching with LWP:
ftp://bo.mirror.garr.it/mirrors/CPAN/authors/id/A/AB/ABW/CHECKSUMS
Module id = Template
DESCRIPTION Extensive Toolkit for template processing
CPAN_USERID ABW (Andy Wardley <cpan@wardley.org>)
CPAN_VERSION 2.18
CPAN_FILE A/AB/ABW/Template-Toolkit-2.18.tar.gz
UPLOAD_DATE 2007-02-09
DSLIP_STATUS RdpO? (released,developer,perl,object-oriented,)
MANPAGE Template - Front-end module to the Template Toolkit
INST_FILE /usr/lib/perl5/site_perl/5.8.8/i686-linux/Template.pm
INST_VERSION 2.18
cpan>