Mysql DBD t/50commit.........FAILED test 24

am 23.02.2003 23:10:28 von Paul Synnott

------=_NextPart_000_001D_01C2DB88.5F4E08E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
I am using redhat 8 on an i386. Mysql 4 is installed and the perl DBI =
is installed.

While running perl -MCPAN -e 'install Bundle::DBD::mysql' I get:

==================== =====3D=
=3D

[root@ps550rh8 inms]# perl -MCPAN -e 'force install Bundle::DBD::mysql'
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Sun, 23 Feb 2003 14:55:13 GMT
DBI is up to date.
Data::ShowTable is up to date.
Mysql is up to date.
Running install for module DBD::mysql
Running make for J/JW/JWIED/DBD-mysql-2.1025.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for =
/root/.cpan/sources/authors/id/J/JW/JWIED/DBD-mysql-2.1025.t ar.gz ok
Scanning cache /root/.cpan/build for sizes
DBD-mysql-2.1025/
DBD-mysql-2.1025/t/
DBD-mysql-2.1025/t/mysql2.t
DBD-mysql-2.1025/t/akmisc.t
DBD-mysql-2.1025/t/60leaks.t
DBD-mysql-2.1025/t/10dsnlist.t
DBD-mysql-2.1025/t/ak-dbd.t
DBD-mysql-2.1025/t/50chopblanks.t
DBD-mysql-2.1025/t/mysql.t
DBD-mysql-2.1025/t/lib.pl
DBD-mysql-2.1025/t/40blobs.t
DBD-mysql-2.1025/t/40nulls.t
DBD-mysql-2.1025/t/insertid.t
DBD-mysql-2.1025/t/40listfields.t
DBD-mysql-2.1025/t/40bindparam.t
DBD-mysql-2.1025/t/mysql.dbtest
DBD-mysql-2.1025/t/dbdadmin.t
DBD-mysql-2.1025/t/20createdrop.t
DBD-mysql-2.1025/t/00base.t
DBD-mysql-2.1025/t/30insertfetch.t
DBD-mysql-2.1025/t/40numrows.t
DBD-mysql-2.1025/t/50commit.t
DBD-mysql-2.1025/t/mysql.mtest
DBD-mysql-2.1025/MANIFEST
DBD-mysql-2.1025/myld
DBD-mysql-2.1025/dbdimp.c
DBD-mysql-2.1025/dbdimp.h
DBD-mysql-2.1025/mysql.xs
DBD-mysql-2.1025/MANIFEST.SKIP
DBD-mysql-2.1025/README
DBD-mysql-2.1025/INSTALL.html
DBD-mysql-2.1025/lib/
DBD-mysql-2.1025/lib/Mysql/
DBD-mysql-2.1025/lib/Mysql/Statement.pm
DBD-mysql-2.1025/lib/DBD/
DBD-mysql-2.1025/lib/DBD/mysql/
DBD-mysql-2.1025/lib/DBD/mysql/INSTALL.pod
DBD-mysql-2.1025/lib/DBD/mysql.pm
DBD-mysql-2.1025/lib/DBD/mysql.pod
DBD-mysql-2.1025/lib/Bundle/
DBD-mysql-2.1025/lib/Bundle/DBD/
DBD-mysql-2.1025/lib/Bundle/DBD/mysql.pm
DBD-mysql-2.1025/lib/Mysql.pm
DBD-mysql-2.1025/Makefile.PL
DBD-mysql-2.1025/ChangeLog
DBD-mysql-2.1025/constants.h
Removing previously used /root/.cpan/build/DBD-mysql-2.1025

CPAN.pm: Going to build J/JW/JWIED/DBD-mysql-2.1025.tar.gz

I will use the following settings for compiling and testing:

cflags (mysql_config) =3D -I'/opt/mysql4/include/mysql'
libs (mysql_config) =3D -L/opt/mysql4/lib/mysql -lmysqlclient =
-lz -lcrypt -lnsl -lm
nocatchstderr (default ) =3D 0
ssl (guessed ) =3D 0
testdb (default ) =3D test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.32 installed in =
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBI
Writing Makefile for DBD::mysql
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/DBD/mysql.pod blib/lib/DBD/mysql.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c =
-I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/aut o/DBI =
-I'/opt/mysql4/include/mysql' -D_REENTRANT -D_GNU_SOURCE =
-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 =
-I/usr/include/gdbm -O2 -march=3Di386 -mcpu=3Di686 =
-DVERSION=3D\"2.1025\" -DXS_VERSION=3D\"2.1025\" -fpic =
"-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" < =
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBI/Driver.xs=
t > mysql.xsi
/usr/bin/perl /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap =
/usr/lib/perl5/5.8.0/ExtUtils/typemap mysql.xs > mysql.xsc && mv =
mysql.xsc mysql.c
Warning: duplicate function definition 'rows' detected in mysql.xs, line =
289
gcc -c =
-I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/aut o/DBI =
-I'/opt/mysql4/include/mysql' -D_REENTRANT -D_GNU_SOURCE =
-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 =
-I/usr/include/gdbm -O2 -march=3Di386 -mcpu=3Di686 =
-DVERSION=3D\"2.1025\" -DXS_VERSION=3D\"2.1025\" -fpic =
"-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH=3D"/opt/mysql4/lib/mysql:/usr/lib:/lib" /usr/bin/perl myld =
gcc -shared -L/usr/local/lib dbdimp.o mysql.o -o =
blib/arch/auto/DBD/mysql/mysql.so -L/opt/mysql4/lib/mysql =
-lmysqlclient -lz -lcrypt -lnsl -lm =20
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/Mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=3D1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" =
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok =
=20
t/10dsnlist........ok =
=20
t/20createdrop.....ok =
=20
t/30insertfetch....ok =
=20
t/40bindparam......ok =
=20
t/40blobs..........ok =
=20
t/40listfields.....ok =
=20
t/40nulls..........ok =
=20
t/40numrows........ok =
=20
t/50chopblanks.....ok =
=20
t/50commit.........FAILED test 24 =
=20
Failed 1/30 tests, 96.67% okay (less 14 skipped tests: 15 okay, =
50.00%)
t/60leaks..........skipped
all skipped: no reason given
t/ak-dbd...........ok =
=20
t/akmisc...........ok =
=20
t/dbdadmin.........ok =
=20
t/insertid.........ok =
=20
t/mysql............ok =
=20
t/mysql2...........ok =
=20
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------=
------
t/50commit.t 30 1 3.33% 24
1 test and 14 subtests skipped.
Failed 1/18 test scripts, 94.44% okay. 1/765 subtests failed, 99.87% =
okay.
make: *** [test_dynamic] Error 29
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force
Bundle summary: The following items in bundle Bundle::DBD::mysql had
installation problems:
DBD::mysql=20
==================== =====3D=
=======3D

As you can see, the force option doesnt seem to affect the output. What =
should I do?

Many thanks,

Paul

==================== =====3D=
==================== =====3D=
==============
Please note that messages sent to madko.ws from HOTMAIL may NOT be =
received.
Use your ISP mail account to mail us.
==================== =====3D=
==================== =====3D=
==============

------=_NextPart_000_001D_01C2DB88.5F4E08E0--

Red Hat 8, MySQL 4.0.10, DBI 1.32

am 25.02.2003 22:17:47 von Christopher Hicks

On Sun, 23 Feb 2003, Paul Synnott wrote:
> I am using redhat 8 on an i386. Mysql 4 is installed and the perl DBI is installed.
> Failed Test Stat Wstat Total Fail Failed List of Failed
> ------------------------------------------------------------ -------------------
> t/50commit.t 30 1 3.33% 24

I'm having problems with a similar setup, but interestingly entirely
different errors are being tripped:

t/00base...........ok
t/10dsnlist........ok
t/20createdrop.....ok
t/30insertfetch....ok
t/40bindparam......ok
t/40blobs..........ok
t/40listfields.....ok
t/40nulls..........ok
t/40numrows........ok
t/50chopblanks.....ok
t/50commit.........ok
14/30 skipped: No transactions
t/60leaks..........skipped
all skipped: no reason given
t/ak-dbd...........ok
t/akmisc...........FAILED test 44
Failed 1/351 tests, 99.72% okay
t/dbdadmin.........NOK 7New DB not in DSN list
t/dbdadmin.........NOK 11DSN testab not in DSN list.
t/dbdadmin.........NOK 15DSN testac not in DSN list.
t/dbdadmin.........FAILED tests 7, 11, 15
Failed 3/21 tests, 85.71% okay
t/insertid.........ok
t/mysql............FAILED test 23
Failed 1/68 tests, 98.53% okay
t/mysql2...........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t/akmisc.t 351 1 0.28% 44
t/dbdadmin.t 21 3 14.29% 7 11 15
t/mysql.t 68 1 1.47% 23
1 test and 14 subtests skipped.
Failed 3/18 test scripts, 83.33% okay. 5/765 subtests failed, 99.35% okay.

As I stated above I'm running Red Hat 8.0, MySQL 4.0.10 (from tcx's rpms),
DBD-mysql 2.1025 and DBI 1.32. I went into the build directory and told
it to install it anyway and none of my scripts are failing in any way so
I'm assuming the tests are just having trouble. I'd love to have some
clue as to which test failed, but other than the dbdadmin problems the
error messages seem basically useless, at least to the uninitiated. Any
suggestions on how to dig into this further would be greatly appreciated.

--

"Never offend people with style when you can offend them with substance."
- Sam Brown

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2044@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Red Hat 8, MySQL 4.0.10, DBI 1.32

am 25.02.2003 22:17:47 von Christopher Hicks

Re: Mysql DBD t/50commit.........FAILED test 24

am 03.03.2003 01:43:08 von Jochen Wiedmann

Quoting Paul Synnott :

> t/50commit.........FAILED test 24
>
> Failed 1/30 tests, 96.67% okay (less 14 skipped tests: 15 okay,
> 50.00%)

Could you please run

make test TEST_VERBOSE=1 TEST_FILES=t/50commit.t

> As you can see, the force option doesnt seem to affect the output. What
> should I do?

You do not need "force install", but just "force".

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2059@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: Mysql DBD t/50commit.........FAILED test 24

am 03.03.2003 01:43:08 von Jochen Wiedmann

Re: MySQL

am 19.09.2003 09:15:42 von Jochen Wiedmann

Steve Schein wrote:

> Thank you for your efforts regarding API development for MySQL
> databases. I am currently using MySQL 4.0x on a Linux system and Perl
> v5.8. At the moment I'm using a generic DBI module (v1.38) and having
> trouble threads. The database won't connect on a new thread and
> generates:
>
> "thread failed to start: DBD::mysql::dr connect failed: handle 1 is
> owned by thread 8454df8 not current thread 86bc3d0 (handles can't be
> shared between threads and your driver may need a CLONE method added) at
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.p m line 585,
> <$client> line 1."
>
> The program runs fine unthreaded. Please let me know if you have a
> MySQL interface module that is thread safe.

I do not know, what you are specifying as "thread safe". The CLONE method,
which is required to share a handle between threads was added in DBD::mysql
2.1019, one year ago. I never tried whether it actually works, but I have no
reports that it doesn't, except yours.

DBI handles are not thread safe in the sense that they are reentrant. They
will never be, because they are typically related to network connections.
You cannot send 5 bytes of one request over the network, followed by then
bytes of a second request and 5 bytes of the next request. In other words:
You may share a handle between threads, but they must synchronize each other.

If your problem is reproducible, please be so kind to reduce it to a small
example script and post that to perl@lists.mysql.com.

Jochen

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org