Re^2: Mysql handle not in asynchronous mode

[ff]

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. :-)

[tultalk]

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