Re^2: Mysql handle not in asynchronous mode

I was having issues with mysql. I was saving individual hashrefs into an array and my script wasn't providing any results. I started running via:

$ DBI_TRACE=2 perl get_data.pl

and saw messages such as:

Handle is not in asynchronous mode error 2000 recorded: Handle is not in asynchronous mode

A post in this thread: https://www.nntp.perl.org/group/perl.dbi.dev/2015/07/msg7950.html suggested increasing the trace level to 4 for more insight. (It also seemed to think DBD::mysql was buggy.)

I tried DBI_TRACE with 4 and didn't see anything new. However, changing to using fetchrow_arrayref started showing data again. :-)

Comment on Re^2: Mysql handle not in asynchronous mode Select or Download Code

Replies are listed 'Best First'.
Re^3: Mysql handle not in asynchronous mode by tultalk (Monk) on Mar 31, 2018 at 12:10 UTC
My code does same but seems to clear itself and fetch the data. level 3 trace -> dbd_st_FETCH_attrib for 1f5e150, key NAME ERROR: 2000 'Handle is not in asynchronous mode' (err#0) 1 <- FETCH= [ 'id' 'user_id' 'username' 'password' 'pin' 'position' +'forename' 'lastname' 'business' 'address1' 'address2' 'city' 'state' + 'zip' 'email' 'phone_home' 'phone_cell' 'comments' 'MJ' 'MD' 'DD' 'D +P' ] at mysql.pm line 869 via at update_tables.cgi line 412 !! The ERROR '2000' was CLEARED by call to fetch method -> dbd_st_fetch dbd_st_fetch for 1da3a00, chopblanks 0 dbd_st_fetch result set details imp_sth->result=1f5f780 mysql_num_fields=22 mysql_num_rows=1 mysql_affected_rows=1 dbd_st_fetch for 1da3a00, currow= 1 [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: Mysql handle not in asynchronous mode
by tultalk (Monk) on Mar 31, 2018 at 12:10 UTC

My code does same but seems to clear itself and fetch the data. level 3 trace

-> dbd_st_FETCH_attrib for 1f5e150, key NAME
       ERROR: 2000 'Handle is not in asynchronous mode' (err#0)
1   <- FETCH= [ 'id' 'user_id' 'username' 'password' 'pin' 'position' 
+'forename' 'lastname' 'business' 'address1' 'address2' 'city' 'state'
+ 'zip' 'email' 'phone_home' 'phone_cell' 'comments' 'MJ' 'MD' 'DD' 'D
+P' ] at mysql.pm line 869 via  at update_tables.cgi line 412
    !! The ERROR '2000' was CLEARED by call to fetch method
    -> dbd_st_fetch
        dbd_st_fetch for 1da3a00, chopblanks 0
    dbd_st_fetch result set details
    imp_sth->result=1f5f780
    mysql_num_fields=22
    mysql_num_rows=1
    mysql_affected_rows=1
    dbd_st_fetch for 1da3a00, currow= 1
[download]

[reply]
[d/l]