From perlbugs@msmith.net

Created by perlbugs@msmith.net

Running

mysql-client-5.0.19 multithreaded SQL database (client)
mysql-server-5.0.19 multithreaded SQL database (server)
p5-DBD-mysql-3.0006 MySQL drivers for the Perl DBI

I'm seeing segfaults on connection attempts to a remote
database. Sometimes it works, sometimes it doesn't. The script
is run in a loop - some connections will work, some will core.

coredump backtrace follows

[msfssss3@​recount ~/work/news]gdb /usr/bin/perl
GNU gdb 6.3
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "amd64-unknown-openbsd3.8"...(no debugging symbols found)

(gdb) target perl.core
Undefined target command​: "perl.core". Try "help target".
(gdb) target core perl.core
Core was generated by `perl'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr-lib/libperl.so.10.0...done.
Loaded symbols for /usr/lib/libperl.so.10.0
Reading symbols from /usr-lib/libm.so.2.2...done.
Loaded symbols for /usr/lib/libm.so.2.2
Reading symbols from /usr-lib/libutil.so.11.0...done.
Loaded symbols for /usr/lib/libutil.so.11.0
Reading symbols from /usr-lib/libc.so.38.4...done.
Loaded symbols for /usr/lib/libc.so.38.4
Reading symbols from /usr/libexec/ld.so...done.
Loaded symbols for /usr/libexec/ld.so
Reading symbols from /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBI/DBI.so...done.
bLoaded symbols for /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBI/DBI.so
Reading symbols from /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/List/Util/Util.so...done.
Loaded symbols for /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/List/Util/Util.so
Reading symbols from /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/HTML/Parser/Parser.so...done.
Loaded symbols for /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/HTML/Parser/Parser.so
Reading symbols from /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/mysql/mysql.so...done.
Loaded symbols for /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/mysql/mysql.so
Reading symbols from /usr/local/lib/mysql/libmysqlclient.so.16.0...done.
Loaded symbols for /usr/local/lib/mysql/libmysqlclient.so.16.0
Reading symbols from /usr-lib/libz.so.4.1...done.
Loaded symbols for /usr/lib/libz.so.4.1
Reading symbols from /usr-lib/libssl.so.10.0...done.
Loaded symbols for /usr/lib/libssl.so.10.0
Reading symbols from /usr-lib/libcrypto.so.12.0...tdone.
Loaded symbols for /usr/lib/libcrypto.so.12.0
Reading symbols from /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/IO/IO.so...done.
Loaded symbols for /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/IO/IO.so
Reading symbols from /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/Socket/Socket.so...done.
Loaded symbols for /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/Socket/Socket.so
Reading symbols from /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/Compress/Zlib/Zlib.so...done.
Loaded symbols for /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/Compress/Zlib/Zlib.so
Reading symbols from /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/Fcntl/Fcntl.so...done.
Loaded symbols for /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/Fcntl/Fcntl.so
Reading symbols from /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/Encode/Encode.so...done.
Loaded symbols for /usr/libdata/perl5/amd64-openbsd/5.8.6/auto/Encode/Encode.so
#0 mysql_st_internal_execute (h=0x47213350, statement=0x4e8acd40, attribs=0x43e6d2a0, num_params=0, params=0x0, result=0x7f7ffffc99d0,
  svsock=0x4a98d898, use_mysql_use_result=0) at dbdimp.c​:2346
2346 char *salloc = parse_params(svsock,
(gdb) bt
#0 mysql_st_internal_execute (h=0x47213350, statement=0x4e8acd40, attribs=0x43e6d2a0, num_params=0, params=0x0, result=0x7f7ffffc99d0,
  svsock=0x4a98d898, use_mysql_use_result=0) at dbdimp.c​:2346
#1 0x00000000511e114f in XS_DBD__mysql__db_do (cv=0x47213350) at mysql.xs​:458
#2 0x00000000505b78d2 in XS_DBI_dispatch () from /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBI/DBI.so
#3 0x000000004d1fdc07 in Perl_pp_entersub () from /usr/lib/libperl.so.10.0
#4 0x000000004d26495e in Perl_runops_standard () from /usr/lib/libperl.so.10.0
#5 0x000000004d25342d in S_run_body () from /usr/lib/libperl.so.10.0
#6 0x000000004d253211 in perl_run () from /usr/lib/libperl.so.10.0
#7 0x0000000000401afe in main ()

Flags:
    category=library
    severity=high

Site configuration information for perl v5.8.6:

Configured by root at Thu Jan  1  0:00:00 UTC 1970.

Summary of my perl5 (revision 5 version 8 subversion 6) configuration:
  Platform:
    osname=openbsd, osvers=3.8, archname=amd64-openbsd
    uname='openbsd'
    config_args='-dsE -Dopenbsd_distribution=defined'
    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=define use64bitall=define uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-fno-strict-aliasing -fno-delete-null-pointer-checks -pipe -I/usr/local/include',
    optimize='-O2',
    cppflags='-fno-strict-aliasing -fno-delete-null-pointer-checks -pipe -I/usr/local/include'
    ccversion='', gccversion='3.3.5 (propolice)', gccosandvers='openbsd3.8'
    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='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='cc', ldflags ='-Wl,-E '
    libpth=/usr/lib
    libs=-lm -lutil -lc
    perllibs=-lm -lutil -lc
    libc=/usr/lib/libc.so.38.4, so=so, useshrplib=true, libperl=libperl.so.10.0
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-R/usr/libdata/perl5/amd64-openbsd/5.8.6/CORE'
    cccdlflags='-DPIC -fPIC ', lddlflags='-shared -fPIC '

Locally applied patches:
    SUIDPERLIO1 - fix PERLIO_DEBUG buffer overflow (CAN-2005-0156)


@INC for perl v5.8.6:
    /usr/libdata/perl5/amd64-openbsd/5.8.6
    /usr/local/libdata/perl5/amd64-openbsd/5.8.6
    /usr/libdata/perl5
    /usr/local/libdata/perl5
    /usr/local/libdata/perl5/site_perl/amd64-openbsd
    /usr/libdata/perl5/site_perl/amd64-openbsd
    /usr/local/libdata/perl5/site_perl
    /usr/libdata/perl5/site_perl
    /usr/local/lib/perl5/site_perl
    .


Environment for perl v5.8.6:
    HOME=/home/recount/msfssss3
    LANG (unset)
    LANGUAGE (unset)
    LD_LIBRARY_PATH (unset)
    LOGDIR (unset)
    PATH=/home/recount/msfssss3/bin:/home/recount/msfssss3/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:/usr/local/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/games:/usr/X11R6/bin:/usr/X/bin:/usr/local/bin/X11:/usr/openwin/bin:/usr/local/communicator:/home/cus/bbs/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/games:/usr/X11R6/bin:/usr/X/bin:/usr/local/bin/X11:/usr/openwin/bin:/usr/local/communicator:/home/cus/bbs/bin
    PERL_BADLANG (unset)
    SHELL=/bin/ksh

From maddingue@free.fr

I'm seeing segfaults on connection attempts to a remote
database. Sometimes it works, sometimes it doesn't. The script
is run in a loop - some connections will work, some will core.

Hello,

This problem is in the DBD​::mysql module, which is not part of the
Perl distribution, so you should ask this question on the coresponding
mailing list and/or open a ticket in DBD​::mysql's CPAN RT.
  » http​://lists.cpan.org/showlist.cgi?name=msql-mysql-modules
  » http​://lists.mysql.com/perl

Looking a bit further, it appears there's already a ticket opened with
the same error you have​:
  » http​://rt.cpan.org/Public/Bug/Display.html?id=18884

I forwarded your mail so it is included in this ticket, but given the
number of openend tickets, you may probably also want to ask on the
mailing list or sent a message to the maintainer.

--
Sébastien Aperghis-Tramoni

Close the world, txEn eht nepO.

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

@smpeters - Status changed from 'open' to 'rejected'