Skip Menu |

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 71555
Status: resolved
Priority: 0/
Queue: DBD-mysql

Owner: Nobody in particular
Requestors: ms [...]

Bug Information
Severity: Critical
Broken in: 4.019
Fixed in: (no value)

Subject: ->err ->errstr not set RaiseError does not work
Download (untitled) / with headers
text/plain 2.7k
->err, ->errstr not set on error in many cases (for database and statement handles) RaiseError does not work in many cases Strange ERROR 2000 when trace(1) ---------- use strict; use DBI; my $dbh; $dbh = DBI->connect("dbi:mysql:dbname=mydatabase", "user", "password", { RaiseError => 1 } ) or die "cannot connect".$dbh->errstr; my $hr = $dbh->selectall_hashref('completelly screwed SQL statement', 'anything'); # never dies ! print "hello, I shoulld be dead! [".$dbh->err."] - [".$dbh->errstr."]"; # prints: hello, I shoulld be dead! [] - [] print "hello, I shoulld be dead! [".$DBI::err."] - [".$DBI::errstr."]"; # also prints: hello, I shoulld be dead! [] - [] # also without RaiseError => 1 no errors are reported # the same behavior for all select*_* functions # for selectrow_arrayref there is no way to distinguish error from empty set ---------- In above example (no matter whch select*_* function we use), if proper query is submmited and results are returned successfuly you may notice strange errors on trace(1) DBI::db=HASH(0x25a2994) trace level set to 0x0/1 (DBI @ 0x0/0) in DBI 1.616-ithread (pid 8264) !! ERROR: 2000 CLEARED by call to bind_columns method <- selectall_hashref('select * from bookformat', 'Name')= ( HASH(0x259f94c)1keys ) [1 items] at line 9 <- DESTROY(DBI::db=HASH(0x25a2994))= ( undef ) [1 items] at line 13 and even stranger on trace(2) <- dbd_st_execute returning imp_sth->row_num 1 --> do_error Async support was not built into this version of DBD::mysql error 2000 recorded: Async support was not built into this v ersion of DBD::mysql <-- do_error -> dbd_st_FETCH_attrib for 02553d5c, key NAME_hash -> dbd_st_FETCH_attrib for 0254caa4, key NAME -> dbd_st_FETCH_attrib for 02553d5c, key NUM_OF_FIELDS -> dbd_st_FETCH_attrib for 02553d5c, key NAME !! ERROR: 2000 CLEARED by call to bind_columns method Notice - I do not try to use { async => 1 } in my code - what you see above is exact code I used to reproduce bugs. Tried to set { async => 0 } manually but it did not help ------------------------------ No ->errstr or DBI::errstr is set when do() fails; undef is returned fortunately. ------------------------------ There is no way in configuration I use to detect / report / raise errors other then detecting undef, which may be expected output from some functions (does not always mean error) ------------------------------ DBI 1.616 DBD-Mysql 4.019 (last available via ppm from activestate, but I see probably the same bug reported from version 4.020) Active State perl5.14.1 MSWin32-x86-multi-thread (standard installer) build 294969 Windows 7 Professional 64 (ver 6.1 build 7601, service pack 1)
Download (untitled) / with headers
text/plain 234b
This is a duplicate of and has been merged into DBD::mysql code here: we'll have a new release with the fix out this week, Pat promised.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to