On Jul 14, 2015, at 3:24 AM, Tim Bunce <tim.bu...@pobox.com> 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
Description: S/MIME cryptographic signature
