Re: Why is selectrow_hashref complaining about a fetch without execute?
"David E. Wheeler" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase.devel |
|---|---|
| Message-ID | <[email protected]> |
On Jul 14, 2015, at 3:24 AM, Tim Bunce <[email protected]> wrote: > I can't see anything obvious from this trace. Come back with a level 4 > trace and hopefully that'll shed sufficient light. Here we go. > $ DBI_TRACE=4 sqitch status > DBI 1.630-ithread default trace level set to 0x0/4 (pid 10670 pi 2603010) at DBI.pm line 288 via DBIEngine.pm line 7 > # On database sqitch_testing > -> DBI->connect(dbi:mysql:database=sqitch, root, ****, HASH(0x4231ae8)) > -> DBI->install_driver(mysql) for linux perl=5.018002 pid=10670 ruid=1000 euid=1000 > install_driver: DBD::mysql version 4.031 loaded from /usr/local/lib/perl/5.18.2/DBD/mysql.pm > <- install_driver= DBI::dr=HASH(0x3341728) > !! The warn '0' was CLEARED by call to connect method > -> connect for DBD::mysql::dr (DBI::dr=HASH(0x3341728)~0x33417e8 'database=sqitch' 'root' **** HASH(0x3f68f70)) thr#2603010 > imp_dbh->connect: dsn = database=sqitch, uid = root, pwd = root > imp_dbh->my_login : dbname = sqitch, uid = root, pwd = root,host = NULL, port = NULL > imp_dbh->mysql_dr_connect: host = |NULL|, port = 0, uid = root, pwd = root > imp_dbh->use_mysql_use_result: 0 > imp_dbh->bind_type_guessing: 0 > imp_dbh->use_server_side_prepare: 0 > mysql_options: MYSQL_SET_CHARSET_NAME=utf8 > imp_dbh->mysql_dr_connect: client_flags = 2 > imp_dbh->mysql_dr_connect: <- <- connect= ( DBI::db=HASH(0x42cfc78) ) [1 items] at /usr/lib/perl5/DBI.pm line 671 via at (eval 231) line 58 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'RaiseError' 0) thr#2603010 > STORE DBI::db=HASH(0x42cfc00) 'RaiseError' => 0 > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 723 via at (eval 231) line 58 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'PrintError' 0) thr#2603010 > STORE DBI::db=HASH(0x42cfc00) 'PrintError' => 0 > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 723 via at (eval 231) line 58 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'AutoCommit' 1) thr#2603010 > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 723 via at (eval 231) line 58 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'mysql_auto_reconnect' 0) thr#2603010 > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 726 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'Username' 'root') thr#2603010 > STORE DBI::db=HASH(0x42cfc00) 'Username' => 'root' > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 726 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'HandleError' CODE(0x3ebbb10)) thr#2603010 > STORE DBI::db=HASH(0x42cfc00) 'HandleError' => CODE(0x3ebbb10) > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 726 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'mysql_enable_utf8' 1) thr#2603010 > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 726 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'Callbacks' HASH(0x421a780)) thr#2603010 > STORE DBI::db=HASH(0x42cfc00) 'Callbacks' => HASH(0x421a780) > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 726 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'mysql_use_result' 0) thr#2603010 > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 726 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > {{ connected callback CODE(0x3ebbd08) being invoked > 1 -> do for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'SET SESSION character_set_client = 'utf8'') thr#2603010 > mysql.xs do() use_server_side_prepare 0, async 0 > mysql_st_internal_execute MYSQL_VERSION_ID 50543 > >parse_params statement SET SESSION character_set_client = 'utf8' > 1 <- do= ( '0E0' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 75 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > 1 -> do for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'SET SESSION character_set_server = 'utf8'') thr#2603010 > mysql.xs do() use_server_side_prepare 0, async 0 > mysql_st_internal_execute MYSQL_VERSION_ID 50543 > >parse_params statement SET SESSION character_set_server = 'utf8' > 1 <- do= ( '0E0' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 75 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > 1 -> do for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'SET SESSION time_zone = '+00:00'') thr#2603010 > mysql.xs do() use_server_side_prepare 0, async 0 > mysql_st_internal_execute MYSQL_VERSION_ID 50543 > >parse_params statement SET SESSION time_zone = '+00:00' > 1 <- do= ( '0E0' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 75 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > 1 -> do for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'SET SESSION group_concat_max_len = 32768') thr#2603010 > mysql.xs do() use_server_side_prepare 0, async 0 > mysql_st_internal_execute MYSQL_VERSION_ID 50543 > >parse_params statement SET SESSION group_concat_max_len = 32768 > 1 <- do= ( '0E0' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 75 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > 1 -> do for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'SET SESSION sql_mode = 'ansi,strict_trans_tables,no_auto_value_on_zero,no_zero_date,no_zero_in_date,only_full_group_by,error_for_division_by_zero'') thr#2603010 > mysql.xs do() use_server_side_prepare 0, async 0 > mysql_st_internal_execute MYSQL_VERSION_ID 50543 > >parse_params statement SET SESSION sql_mode = 'ansi,strict_trans_tables,no_auto_value_on_zero,no_zero_date,no_zero_in_date,only_full_group_by,error_for_division_by_zero' > 1 <- do= ( '0E0' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 75 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > 1 -> do for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'SET SESSION default_storage_engine = 'InnoDB'') thr#2603010 > mysql.xs do() use_server_side_prepare 0, async 0 > mysql_st_internal_execute MYSQL_VERSION_ID 50543 > >parse_params statement SET SESSION default_storage_engine = 'InnoDB' > 1 <- do= ( '0E0' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 95 via at /usr/local/share/perl/5.18.2/Try/Tiny.pm line 81 > 1 -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER) thr#2603010 > 1 <- err= ( undef ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 98 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > }} connected callback CODE(0x3ebbd08) returned > -> connected in DBD::_::db for DBD::mysql::db (DBI::db=HASH(0x42cfc78)~0x42cfc00 'dbi:mysql:database=sqitch' 'root' **** HASH(0x4231ae8)) thr#2603010 > <- connected= ( undef ) [1 items] at /usr/lib/perl5/DBI.pm line 733 via at (eval 231) line 58 > <- connect= DBI::db=HASH(0x42cfc78) > -> STORE for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'dbi_connect_closure' CODE(0x3341950)) thr#2603010 > STORE DBI::db=HASH(0x42cfc00) 'dbi_connect_closure' => CODE(0x3341950) > <- STORE= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 742 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 103 > -> FETCH for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'mysql_serverinfo') thr#2603010 > <- FETCH= ( '5.6.17-0ubuntu0.14.04.1-log' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 106 via at (eval 231) line 58 > -> FETCH for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER 'mysql_serverversion') thr#2603010 > <- FETCH= ( '50617' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 109 via at (eval 231) line 58 > -> selectrow_hashref in DBD::_::db for DBD::mysql::db (DBI::db=HASH(0x42cfc78)~0x42cfc00 ' > SELECT c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , date_format(c.committed_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS committed_at > , c.planner_name > , c.planner_email > , date_format(c.planned_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS planned_at > , group_concat(t.tag SEPARATOR ' ') AS tags > FROM changes c > LEFT JOIN tags t ON c.change_id = t.change_id > WHERE c.project = ? > GROUP BY c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , c.committed_at > , c.planner_name > , c.planner_email > , c.planned_a...' undef "*************") thr#2603010 > 1 -> prepare for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER ' > SELECT c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , date_format(c.committed_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS committed_at > , c.planner_name > , c.planner_email > , date_format(c.planned_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS planned_at > , group_concat(t.tag SEPARATOR ' ') AS tags > FROM changes c > LEFT JOIN tags t ON c.change_id = t.change_id > WHERE c.project = ? > GROUP BY c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , c.committed_at > , c.planner_name > , c.planner_email > , c.planned_a...' undef) thr#2603010 > 2 -> _async_check for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER) thr#2603010 > 2 <- _async_check= ( 1 ) [1 items] at /usr/local/lib/perl/5.18.2/DBD/mysql.pm line 238 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 116 > -> dbd_st_prepare MYSQL_VERSION_ID 50543, SQL statement: > SELECT c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , date_format(c.committed_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS committed_at > , c.planner_name > , c.planner_email > , date_format(c.planned_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS planned_at > , group_concat(t.tag SEPARATOR ' ') AS tags > FROM changes c > LEFT JOIN tags t ON c.change_id = t.change_id > WHERE c.project = ? > GROUP BY c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , c.committed_at > , c.planner_name > , c.planner_email > , c.planned_at > ORDER BY c.committed_at DESC > LIMIT 1 > > >- dbd_st_free_result_sets > <- dbd_st_free_result_sets RC -1 > <- dbd_st_free_result_sets > >count_params statement > SELECT c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , date_format(c.committed_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS committed_at > , c.planner_name > , c.planner_email > , date_format(c.planned_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS planned_at > , group_concat(t.tag SEPARATOR ' ') AS tags > FROM changes c > LEFT JOIN tags t ON c.change_id = t.change_id > WHERE c.project = ? > GROUP BY c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , c.committed_at > , c.planner_name > , c.planner_email > , c.planned_at > ORDER BY c.committed_at DESC > LIMIT 1 > > <- dbd_st_prepare > 1 <- prepare= ( DBI::st=HASH(0x42cfcc0) ) [1 items] at /usr/lib/perl5/DBI.pm line 1630 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 149 > -> execute for DBD::mysql::st (DBI::st=HASH(0x42cfcc0)~0x4231cf8 "*************") thr#2603010 > Called: dbd_bind_ph > -> dbd_st_execute for 03fdf4e0 > >- dbd_st_free_result_sets > <- dbd_st_free_result_sets RC -1 > <- dbd_st_free_result_sets > mysql_st_internal_execute MYSQL_VERSION_ID 50543 > >parse_params statement > SELECT c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , date_format(c.committed_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS committed_at > , c.planner_name > , c.planner_email > , date_format(c.planned_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS planned_at > , group_concat(t.tag SEPARATOR ' ') AS tags > FROM changes c > LEFT JOIN tags t ON c.change_id = t.change_id > WHERE c.project = ? > GROUP BY c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , c.committed_at > , c.planner_name > , c.planner_email > , c.planned_at > ORDER BY c.committed_at DESC > LIMIT 1 > > Binding parameters: SELECT c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , date_format(c.committed_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS committed_at > , c.planner_name > , c.planner_email > , date_format(c.planned_at, 'year:%Y:month:%m:day:%d:hour:%H:minute:%i:second:%S:time_zone:UTC') AS planned_at > , group_concat(t.tag SEPARATOR ' ') AS tags > FROM changes c > LEFT JOIN tags t ON c.change_id = t.change_id > WHERE c.project = '*************' > GROUP BY c.change_id > , c.script_hash > , c.change > , c.project > , c.note > , c.committer_name > , c.committer_email > , c.committed_at > , c.planner_name > , c.planner_email > , c.planned_at > ORDER BY c.committed_at DESC > LIMIT 1 > > --> do_error > Out of sort memory, consider increasing server sort buffer size error 1038 recorded: Out of sort memory, consider increasing server sort buffer size > <-- do_error > <- dbd_st_execute returning imp_sth->row_num 18446744073709551615 > !! ERROR: 1038 'Out of sort memory, consider increasing server sort buffer size' (err#0) > <- execute= ( -1 ) [1 items] at /usr/lib/perl5/DBI.pm line 1632 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 149 > !! The ERROR '1038' was CLEARED by call to fetchrow_hashref method > -> fetchrow_hashref for DBD::mysql::st (DBI::st=HASH(0x42cfcc0)~0x4231cf8) thr#2603010 > 1 -> mysql_async_ready for DBD::mysql::st (DBI::st=HASH(0x4231cf8)~INNER) thr#2603010 > --> do_error > Handle is not in asynchronous mode error 2000 recorded: Handle is not in asynchronous mode > <-- do_error > !! ERROR: 2000 'Handle is not in asynchronous mode' (err#0) > 1 <- mysql_async_ready= ( undef ) [1 items] at /usr/local/lib/perl/5.18.2/DBD/mysql.pm line 864 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 116 > 1 -> FETCH for DBD::mysql::st (DBI::st=HASH(0x4231cf8)~INNER 'NAME') thr#2603010 > -> dbd_st_FETCH_attrib for 03fdf4e0, key NAME > --> do_error > statement contains no result error 4 recorded: statement contains no result > <-- do_error > !! ERROR: 4 'statement contains no result' (err#0) > 1 <- FETCH= ( undef ) [1 items] at /usr/local/lib/perl/5.18.2/DBD/mysql.pm line 867 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 116 > !! The ERROR '4' was CLEARED by call to fetch method > 1 -> fetch for DBD::mysql::st (DBI::st=HASH(0x4231cf8)~INNER) thr#2603010 > -> dbd_st_fetch > dbd_st_fetch for 04243568, chopblanks 0 > --> do_error > fetch() without execute() error 19 recorded: fetch() without execute() > <-- do_error > !! ERROR: 19 'fetch() without execute()' (err#0) > 1 <- fetch= ( undef ) [1 items] row-1 at /usr/local/lib/perl/5.18.2/DBD/mysql.pm line 867 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 116 > !! ERROR: 19 'fetch() without execute()' (err#0) > <- fetchrow_hashref= ( undef ) [1 items] row-1 at /usr/lib/perl5/DBI.pm line 1634 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 149 > <> DESTROY(DBI::st=HASH(0x42cfcc0)) ignored for outer handle (inner DBI::st=HASH(0x4231cf8) has ref cnt 1) > -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x4231cf8)~INNER) thr#2603010 > Freeing 1 parameters, bind 0 fbind 0 > ERROR: 19 'fetch() without execute()' (err#0) > <- DESTROY= ( undef ) [1 items] at /usr/lib/perl5/DBI.pm line 1639 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 149 > dbih_clearcom 0x4231cf8 (com 0x42ed460, type 3) done. > > !! ERROR: 19 'fetch() without execute()' (err#0) > <- selectrow_hashref= ( undef ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 116 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 149 > -> HandleError on DBI::db=HASH(0x42cfc00) via CODE(0x3ebbb10) (undef) > 1 -> state in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0x42cfc78)~0x42cfc00) thr#2603010 > ERROR: 19 'fetch() without execute()' (err#0) > 1 <- state= ( 'S1000' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 69 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 116 > 1 -> errstr in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0x42cfc78)~0x42cfc00) thr#2603010 > ERROR: 19 'fetch() without execute()' (err#0) > 1 <- errstr= ( 'fetch() without execute()' ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 69 via at /usr/local/share/perl/5.18.2/App/Sqitch/Role/DBIEngine.pm line 116 > -> $DBI::state (") FETCH from lasth=HASH > <- $DBI::state= 'S1000' > -> $DBI::state (") FETCH from lasth=HASH > <- $DBI::state= 'S1000' > -> $DBI::state (") FETCH from lasth=HASH > <- $DBI::state= 'S1000' > -> $DBI::state (") FETCH from lasth=HASH > <- $DBI::state= 'S1000' > -> $DBI::state (") FETCH from lasth=HASH > <- $DBI::state= 'S1000' > !! The ERROR '19' was CLEARED by call to selectcol_arrayref method > -> selectcol_arrayref in DBD::_::db for DBD::mysql::db (DBI::db=HASH(0x42cfc78)~0x42cfc00 ' > SELECT COUNT(*) > FROM information_schema.tables > WHERE table_schema = ? > AND table_name = ? > ' undef 'sqitch' 'changes') thr#2603010 > 1 -> prepare for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER ' > SELECT COUNT(*) > FROM information_schema.tables > WHERE table_schema = ? > AND table_name = ? > ' undef) thr#2603010 > 2 -> _async_check for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER) thr#2603010 > 2 <- _async_check= ( 1 ) [1 items] at /usr/local/lib/perl/5.18.2/DBD/mysql.pm line 238 via at /usr/local/share/perl/5.18.2/App/Sqitch/Command/status.pm line 125 > -> dbd_st_prepare MYSQL_VERSION_ID 50543, SQL statement: > SELECT COUNT(*) > FROM information_schema.tables > WHERE table_schema = ? > AND table_name = ? > > >- dbd_st_free_result_sets > <- dbd_st_free_result_sets RC -1 > <- dbd_st_free_result_sets > >count_params statement > SELECT COUNT(*) > FROM information_schema.tables > WHERE table_schema = ? > AND table_name = ? > > <- dbd_st_prepare > 1 <- prepare= ( DBI::st=HASH(0x3f1f130) ) [1 items] at /usr/lib/perl5/DBI.pm line 1678 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 218 > -> execute for DBD::mysql::st (DBI::st=HASH(0x3f1f130)~0x3d73e10 'sqitch' 'changes') thr#2603010 > Called: dbd_bind_ph > Called: dbd_bind_ph > -> dbd_st_execute for 042d0638 > >- dbd_st_free_result_sets > <- dbd_st_free_result_sets RC -1 > <- dbd_st_free_result_sets > mysql_st_internal_execute MYSQL_VERSION_ID 50543 > >parse_params statement > SELECT COUNT(*) > FROM information_schema.tables > WHERE table_schema = ? > AND table_name = ? > > Binding parameters: SELECT COUNT(*) > FROM information_schema.tables > WHERE table_schema = 'sqitch' > AND table_name = 'changes' > > <- dbd_st_execute returning imp_sth->row_num 1 > <- execute= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 1680 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 218 > -> bind_col for DBD::mysql::st (DBI::st=HASH(0x3f1f130)~0x3d73e10 1 SCALAR(0x421a4f8)) thr#2603010 > 1 -> _async_check for DBD::mysql::st (DBI::st=HASH(0x3d73e10)~INNER) thr#2603010 > 1 <- _async_check= ( 1 ) [1 items] at /usr/local/lib/perl/5.18.2/DBD/mysql.pm line 877 via at /usr/local/share/perl/5.18.2/App/Sqitch/Command/status.pm line 125 > <- bind_col= ( 1 ) [1 items] at /usr/lib/perl5/DBI.pm line 1685 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 218 > -> fetch for DBD::mysql::st (DBI::st=HASH(0x3f1f130)~0x3d73e10) thr#2603010 > -> dbd_st_fetch > dbd_st_fetch for 042d0638, chopblanks 0 > dbd_st_fetch result set details > imp_sth->result=02c7cad0 > mysql_num_fields=1 > mysql_num_rows=1 > mysql_affected_rows=1 > dbd_st_fetch for 042d0638, currow= 1 > <- dbd_st_fetch, 1 cols > <- fetch= ( [ '1' ] ) [1 items] row1 at /usr/lib/perl5/DBI.pm line 1692 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 218 > -> fetch for DBD::mysql::st (DBI::st=HASH(0x3f1f130)~0x3d73e10) thr#2603010 > -> dbd_st_fetch > dbd_st_fetch for 042d0638, chopblanks 0 > dbd_st_fetch result set details > imp_sth->result=02c7cad0 > mysql_num_fields=1 > mysql_num_rows=1 > mysql_affected_rows=1 > dbd_st_fetch for 042d0638, currow= 2 > dbd_st_fetch, no more rows to fetch > --> dbd_st_finish > >- dbd_st_free_result_sets > <- dbd_st_free_result_sets RC -1 > <- dbd_st_free_result_sets > > <-- dbd_st_finish > <- fetch= ( undef ) [1 items] row1 at /usr/lib/perl5/DBI.pm line 1692 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 218 > <> DESTROY(DBI::st=HASH(0x3f1f130)) ignored for outer handle (inner DBI::st=HASH(0x3d73e10) has ref cnt 1) > -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x3d73e10)~INNER) thr#2603010 > Freeing 2 parameters, bind 0 fbind 0 > <- DESTROY= ( undef ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 218 via at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 218 > dbih_clearcom 0x3d73e10 (com 0x4207a10, type 3) done. > > <- selectcol_arrayref= ( [ '1' ] ) [1 items] at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 218 via at /usr/local/share/perl/5.18.2/App/Sqitch/Command/status.pm line 125 > <> DESTROY(DBI::db=HASH(0x42cfc78)) ignored for outer handle (inner DBI::db=HASH(0x42cfc00) has ref cnt 1) > -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x42cfc00)~INNER) thr#2603010 > imp_dbh->pmysql: 42d0e80 > <- DESTROY= ( undef ) [1 items] at /usr/local/share/perl/5.18.2/Try/Tiny.pm line 88 via at /usr/local/share/perl/5.18.2/Try/Tiny.pm line 88 > dbih_clearcom 0x42cfc00 (com 0x42d0c40, type 2) done. > > fetch() without execute() > -- DBI::END ($@: , $!: ) > -> disconnect_all for DBD::mysql::dr (DBI::dr=HASH(0x3341728)~0x33417e8) thr#2603010 > <- disconnect_all= ( ) [0 items] (not implemented) at /usr/lib/perl5/DBI.pm line 750 via at /usr/local/bin/sqitch line 17 > ! <> DESTROY(DBI::dr=HASH(0x3341728)) ignored for outer handle (inner DBI::dr=HASH(0x33417e8) has ref cnt 1) > ! -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0x33417e8)~INNER) thr#2603010 > ! <- DESTROY= ( undef ) [1 items] during global destruction > dbih_clearcom 0x33417e8 (com 0x42b8f20, type 1) done. Odd that there are so many “fetch() without execute()” errors. Most of them appear to be from calls to selectrow_hashref(), such as this one: https://github.com/theory/sqitch/blob/master/lib/App/Sqitch/Role/DBIEngine.pm#L116 Best, David
smime.p7s
(application/pkcs7-signature, 4 KB) - not displayed