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