Bug#608184: selectall_arrayref eats errors, returns nonsensical one
Anthony DeRobertis
anthony at derobert.net
Tue Dec 28 13:07:02 UTC 2010
Package: libdbd-mysql-perl
Version: 4.016-1
Severity: normal
I have DBI running in raise error mode. Got this die:
DBD::mysql::db selectall_arrayref failed: fetch() without execute() [for Statement "SELECT
r.rid AS rid,
r.channel AS channel,
sequence.nextval('crm.mp3-taper.comment') AS com_num,
...
"] at ./bin/mp3-taper line 784.
Line 784 is a call to selectall_arrayref. So this error is nonsense; I'm
not calling prepare/execute/fetch, and surely selectall should know to
call execute before fetch.
To find out what went wrong, I had to fire up wireshark:
#42000execute command denied to user 'mp3t_user'@'zia.metrics.net' for routine 'sequence.nextval'.
That's a fair bit more useful, to say the least.
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (500, 'testing'), (200, 'unstable'), (100, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.36-trunk-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages libdbd-mysql-perl depends on:
ii libc6 2.11.2-7 Embedded GNU C Library: Shared lib
ii libdbi-perl [perl-dbdabi-94] 1.612-1 Perl Database Interface (DBI)
ii libmysqlclient16 5.1.49-3 MySQL database client library
ii perl 5.10.1-16 Larry Wall's Practical Extraction
ii perl-base [perlapi-5.10.1] 5.10.1-16 minimal Perl system
libdbd-mysql-perl recommends no packages.
libdbd-mysql-perl suggests no packages.
-- no debconf information
More information about the pkg-perl-maintainers
mailing list