On Mon, Jul 13, 2015 at 03:53:43PM -0700, David E. Wheeler wrote: > DBIers, > Got a complaint about a “fetch() without execute()” error. Asked for a > trace, got this. Looks like > it’s coming from selectrow_hashref()? That shouldn’t happen, right? > > $ DBI_TRACE=1 sqitch status
Trace level 1 is handy when you just want a summary of what's going on. If something odd is happening then you'd want at least trace level 2 so you see the method _calls_ as well as the _returns_. For investigating mysterious happenings then higher trace levels, like 4 thru 15, are more appropriate. 4 is usually sufficient. I can't see anything obvious from this trace. Come back with a level 4 trace and hopefully that'll shed sufficient light. Tim. > <- STORE('dbi_connect_closure', CODE(0x1c11b10))= ( 1 ) [1 items] at > DBI.pm line 742 > <- FETCH('mysql_serverinfo')= ( '5.6.17-0ubuntu0.14.04.1-log' ) [1 > items] at mysql.pm line 106 > <- FETCH('mysql_serverversion')= ( '50617' ) [1 items] at mysql.pm line > 109 > !! The ERROR '1038' was CLEARED by call to fetchrow_hashref method > !! The ERROR '4' was CLEARED by call to fetch method > ERROR: 19 'fetch() without execute()' (err#0) > <- DESTROY(DBI::st=HASH(0x2ae9638))= ( undef ) [1 items] at DBI.pm line > 1639 > !! ERROR: 19 'fetch() without execute()' (err#0) > <- selectrow_hashref(' > SELECT c.change_id ... > , c.planned_a...', undef, ...)= ( undef ) [1 items] at > DBIEngine.pm line 116 > -> HandleError on DBI::db=HASH(0x2b9ea48) via CODE(0x278aa80) (undef) > <- $DBI::state= 'S1000' > <- $DBI::state= 'S1000' > <- $DBI::state= 'S1000' > <- $DBI::state= 'S1000' > <- $DBI::state= 'S1000' > !! The ERROR '19' was CLEARED by call to selectcol_arrayref method > <- DESTROY(DBI::st=HASH(0x2ae94b8))= ( undef ) [1 items] at mysql.pm > line 218 > <- selectcol_arrayref(' > SELECT COUNT(*) > FROM information_schema.tables > WHERE table_schema = ? > AND table_name = ? > ', undef, ...)= ( [ '1' ] ) [1 items] at mysql.pm line 218 > <- DESTROY(DBI::db=HASH(0x2b9ea48))= ( undef ) [1 items] at Tiny.pm line > 88 > fetch() without execute() > <- disconnect_all= ( ) [0 items] (not implemented) at DBI.pm line 750 > ! <- DESTROY(DBI::dr=HASH(0x1c119a8))= ( undef ) [1 items] during global > destruction > > Thanks, > David > Reverse link: [1]unknown > > References > > Visible links > 1. https://github.com/theory/sqitch/issues/235#issuecomment-120180277