Your message dated Mon, 25 Apr 2011 20:29:45 +0100
with message-id <[email protected]>
and subject line Someone needs to try and reproduce this
has caused the Debian Bug report #608184,
regarding selectall_arrayref eats errors, returns nonsensical one
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
608184: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=608184
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Looks to me as if this is a portability issue:
http://forums.mysql.com/read.php?41,22262,22300
The user should probably either try to find some more portable SQL or
the mysql speciifc equivalent. However I don;t see that there is
anything for Debian or upstream here.
--
Nicholas Bamber | http://www.periapt.co.uk/
PGP key 3BFFE73C from pgp.mit.edu
--- End Message ---
