Use of uninitialized value in numeric lt in mysql.pm

$ sqitch status
# On database sqitch_testing
Use of uninitialized value in numeric lt (<) at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 75.
fetch() without execute()

When I try to follow the MySQL tutorial I end up getting the error above.
$ mysql --version
mysql  Ver 14.14 Distrib 5.6.17, for debian-linux-gnu (x86_64) using  EditLine wrapper

Running Ubuntu 14.04.1 LTS.
[core]
        engine = mysql
        top_dir = dev/database
[target "sqitch_testing"]
        uri = db:mysql://root@/sqitch_testing
[engine "mysql"]
        target = sqitch_testing

Some more information,
$ perl --version
This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux-gnu-thread-multi
(with 41 registered patches, see perl -V for more detail)

I managed to get sqitch installed with the following:
sudo apt-get install libmysqlclient-dev
sudo cpan Class::XSAccessor
sudo cpan Type::Tiny::XS
sudo cpan DBD::mysql
sudo cpan App::Sqitch

Hrm. Can you tell me the output from this command?
perl -MDBI -E 'say DBI->connect("dbi:mysql:database=sqitch_testing", "root", "")->{mysql_serverversion}'

Here's the output: 50617

Huh. Are you still getting that error?

Yeah, what other information can I provide? I dug into that file (mysql.pm) but couldn't get much out of it. It's running inside a virtual machine by the way (with vagrant).

Well, I think the error is coming from this line:
                    ($dbh->{mysql_serverversion} < 50500 ? () : (q{default_storage_engine = 'InnoDB'})),

So, maybe mysql_serverversion isn't set yet? What does this output?
 perl -MDBI -E 'DBI->connect("dbi:mysql:database=sqitch_testing", "root", "", { Callbacks => { connected => sub { say shift->{mysql_serverversion} } } })'

I ran,
perl -MDBI -E 'DBI->connect("dbi:mysql:database=sqitch_testing", "root", "", { Callbacks => { connected => sub { say shift->{mysql_serverversion}; } } })'

Which resulted in,
Callback for connected returned 1 values but must not return any (temporary restriction in current version) at /usr/lib/perl5/DBI.pm line 733.

I changed the command to (added return;),
perl -MDBI -E 'DBI->connect("dbi:mysql:database=sqitch_testing", "root", "", { Callbacks => { connected => sub { say shift->{mysql_serverversion}; return; } } })'

Then it didn't print any text out (just line break).

Hrm. I wonder if this is a Maria thing, because for me:
 perl -MDBI -E 'DBI->connect("dbi:mysql:database=test", "root", "", { Callbacks => { connected => sub { say shift->{mysql_serverversion}; return; } } })'
50542

What version of DBD::mysql do you have installed? If you don't know, just run this command:
perl -MDBD::mysql -E 'print DBD::mysql->VERSION, "\n"'

This is what I got,
$ perl -MDBD::mysql -E 'print DBD::mysql->VERSION, "\n"'
4.031

Same as what I have. So it must be a MariaDB issue. I think Maria has always supported InnoDB, so let's see if we can detect that. What does this output?
perl -MDBI -E 'DBI->connect("dbi:mysql:database=test", "root", "", { Callbacks => { connected => sub { say shift->{mysql_serverinfo}; return; } } })'

perl -MDBI -E 'DBI->connect("dbi:mysql:database=sqitch_testing", "root", "", { Callbacks => { connected => sub { say shift->{mysql_serverversion}; return; } } })'

That command doesn't print anything for me. It just prints a line break.

Well that's annoying. Maybe we can just assume that InnoDB is supported if there is no version? Like this:
--- a/lib/App/Sqitch/Engine/mysql.pm
+++ b/lib/App/Sqitch/Engine/mysql.pm
@@ -75,7 +75,11 @@ has dbh => (
                     $dbh->do("SET SESSION $_") for (
                         q{character_set_client   = 'utf8'},
                         q{character_set_server   = 'utf8'},
-                        ($dbh->{mysql_serverversion} < 50500 ? () : (q{default_storage_engine = 'InnoDB'})),
+                        (
+                            $dbh->{mysql_serverversion} && $dbh->{mysql_serverversion} < 50500
+                            ? ()
+                            : (q{default_storage_engine = 'InnoDB'})
+                        ),
                         q{time_zone              = '+00:00'},
                         q{group_concat_max_len   = 32768},
                         q{sql_mode = '} . join(',', qw(

Wait, what version of the DBI do you have?
perl -MDBI -E 'print DBI->version, "\n"'

If you have a version prior to 1.631, this problem might be fixed by upgrading to 1.631 or later.

Ouch, this is what I got,
$ perl -MDBI -E 'print DBI->version, "\n"'
Can't locate object method "version" via package "DBI" at -e line 1.

Does the way I installed Sqitch on Ubuntu seem right? (commands included in second comment)

Sorry, version needs to be in all caps:
perl -MDBI -E 'print DBI->VERSION, "\n"'

Yes, those commands look fine. Might be easier to use apt, but totally fine to get everything from CPAN the way you have, too.

Thanks, yep I've got 1.63,
$ perl -MDBI -E 'print DBI->VERSION, "\n"'
1.63

Any suggestions on the right way to upgrade?

Ah-hah. That helps. I can work around that, I think. but you can upgrade easily enough with sudo cpan DBI.

Okay, pretty sure that ec8d051 fixes the issue even with older versions of DBI. Thanks so much for reporting this and helping me to diagnose it!

Awesome, thanks!
Can you comment on what's the best way for me to go about installing ec8d0511442f25936d5c879b3ef955d21c764779?
I assume at this point I have to download the source from Github and install from source? I'd like to find a reliable way of getting Sqitch to work on Ubuntu 14.04.01 LTS with MySQL.

Do you know how to apply a patch? Run perldoc -l App::Sqitch::Engine::mysql and it will show you where the file is that needs patching.

Applying a patch in general yes, if you mean something perl-specific no. What I'm trying to do is to bake in the Sqitch installation into a virtual machine provisioning process so I'm looking for the suggested or best series of commands that results in a smoothly working installation of Sqitch.
I don't even have a preference for CPAN, it just happened to be the commands I ran initially to get something going. So that's why now I wonder if there's potentially better way to get all dependencies pulled in correctly, etc...
This is for a development environment base image so I hope to find a as-stable-as-possible way.

Well, to get it working properly, you just need to update DBI. Run cpan DBI to get the latest. That should address it.
If you were able to patch the file before upgrading DBI, that would help me to verify that the fix is correct. It's a pretty straight-forward patch if you're accustomed to applying patches; It just adds a few lines to the file.

Hmm .. I applied the patch but it's still giving the same error.
$ sqitch status
# On database sqitch_testing
Use of uninitialized value in numeric lt (<) at /usr/local/share/perl/5.18.2/App/Sqitch/Engine/mysql.pm line 75.
fetch() without execute()

Perhaps line 78 needs to be changed there?
So that it doesn't end up doing the lt comparison if $dbh->{mysql_serverversion} is not set?
($dbh->{mysql_serverversion} < 50500 ? () : (q{default_storage_engine = 'InnoDB'})),

Ack, yes, sorry, I got sloppy. It needs a || 0.
--- a/lib/App/Sqitch/Engine/mysql.pm
+++ b/lib/App/Sqitch/Engine/mysql.pm
@@ -75,7 +75,7 @@ has dbh => (
                     $dbh->do("SET SESSION $_") for (
                         q{character_set_client   = 'utf8'},
                         q{character_set_server   = 'utf8'},
-                        ($dbh->{mysql_serverversion} < 50500 ? () : (q{default_storage_engine = 'InnoDB'})),
+                        ($dbh->{mysql_serverversion} || 0 < 50500 ? () : (q{default_storage_engine = 'InnoDB'})),
                         q{time_zone              = '+00:00'},
                         q{group_concat_max_len   = 32768},
                         q{sql_mode = '} . join(',', qw(

Thanks, that fixed it. However when I run sqitch status or sqitch deploy it still says fetch() without execute(). I don't know if that's completely unrelated or not.
$ sqitch status
# On database sqitch_testing
fetch() without execute()

Hrm. Would you paste the output of
DBI_TRACE=1 sqitch status

?

Here it is,
$ DBI_TRACE=1 sqitch status
    DBI 1.630-ithread default trace level set to 0x0/1 (pid 3381 pi ed2010) at DBI.pm line 288 via DBIEngine.pm line 7
# On database sqitch_testing
    -> DBI->connect(dbi:mysql:database=sqitch, root, ****, HASH(0x2b00a28))
    -> DBI->install_driver(mysql) for linux perl=5.018002 pid=3381 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(0x1c118e8)
    !! The warn '0' was CLEARED by call to connect method
    <- connect('database=sqitch', 'root', ...)= ( DBI::db=HASH(0x2b9eac0) ) [1 items] at DBI.pm line 671
    <- STORE('RaiseError', 0)= ( 1 ) [1 items] at DBI.pm line 723
    <- STORE('PrintError', 0)= ( 1 ) [1 items] at DBI.pm line 723
    <- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 723
    <- STORE('HandleError', CODE(0x278aa80))= ( 1 ) [1 items] at DBI.pm line 726
    <- STORE('mysql_auto_reconnect', 0)= ( 1 ) [1 items] at DBI.pm line 726
    <- STORE('Callbacks', HASH(0x2ae94d0))= ( 1 ) [1 items] at DBI.pm line 726
    <- STORE('mysql_enable_utf8', 1)= ( 1 ) [1 items] at DBI.pm line 726
    <- STORE('mysql_use_result', 0)= ( 1 ) [1 items] at DBI.pm line 726
    <- STORE('Username', 'root')= ( 1 ) [1 items] at DBI.pm line 726
    {{ connected callback CODE(0x278ac78) being invoked
    }} connected callback CODE(0x278ac78) returned
    <- connected('dbi:mysql:database=sqitch', 'root', ...)= ( undef ) [1 items] at DBI.pm line 733
    <- connect= DBI::db=HASH(0x2b9eac0)
    <- STORE('dbi_connect_closure', CODE(0x1c11b10))= ( 1 ) [1 items] at DBI.pm line 742
    <- FETCH('mysql_serverinfo')= ( '5.6.17-0ubuntu<IP_ADDRESS>-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.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, ...)= ( 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

Not enough information, alas. Would you try a trace level 4, please?
DBI_TRACE=4 sqitch status

Here it is,
$ 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-0ubuntu<IP_ADDRESS>-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 "ManageFlitter") 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 "ManageFlitter") 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 = 'ManageFlitter'
         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<PHONE_NUMBER>3709551615
    !! 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.

Here it is,
$ 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-0ubuntu<IP_ADDRESS>-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<PHONE_NUMBER>3709551615
    !! 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.

Hi @melon-babak. Please paste here the output of perl -V for the perl that you're using. I'd like to check something. Thanks.

@timbunce here it is,
$ perl -V
Summary of my perl5 (revision 5 version 18 subversion 2) configuration:

  Platform:
    osname=linux, osvers=3.2.0-58-generic, archname=x86_64-linux-gnu-thread-multi
    uname='linux brownie 3.2.0-58-generic #88-ubuntu smp tue dec 3 17:37:58 utc 2013 x86_64 x86_64 x86_64 gnulinux '
    config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN -D_FORTIFY_SOURCE=2 -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -Dldflags= -Wl,-Bsymbolic-functions -Wl,-z,relro -Dlddlflags=-shared -Wl,-Bsymbolic-functions -Wl,-z,relro -Dcccdlflags=-fPIC -Darchname=x86_64-linux-gnu -Dprefix=/usr -Dprivlib=/usr/share/perl/5.18 -Darchlib=/usr/lib/perl/5.18 -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.18.2 -Dsitearch=/usr/local/lib/perl/5.18.2 -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 -Dsiteman3dir=/usr/local/man/man3 -Duse64bitint -Dman1ext=1 -Dman3ext=3perl -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm -Ui_libutil -Uversiononly -DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib -Dlibperl=libperl.so.5.18.2 -des'
    hint=recommended, useposix=true, d_sigaction=define
    useithreads=define, usemultiplicity=define
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
    use64bitint=define, use64bitall=define, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
    optimize='-O2 -g',
    cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include'
    ccversion='', gccversion='4.8.2', gccosandvers=''
    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -fstack-protector -L/usr/local/lib'
    libpth=/usr/local/lib /lib/x86_64-linux-gnu /lib/../lib /usr/lib/x86_64-linux-gnu /usr/lib/../lib /lib /usr/lib
    libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
    perllibs=-ldl -lm -lpthread -lc -lcrypt
    libc=, so=so, useshrplib=true, libperl=libperl.so.5.18.2
    gnulibc_version='2.19'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
    cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib -fstack-protector'

Characteristics of this binary (from libperl):
  Compile-time options: HAS_TIMES MULTIPLICITY PERLIO_LAYERS
                        PERL_DONT_CREATE_GVSV
                        PERL_HASH_FUNC_ONE_AT_A_TIME_HARD
                        PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
                        PERL_PRESERVE_IVUV PERL_SAWAMPERSAND USE_64_BIT_ALL
                        USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
                        USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE
                        USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF
                        USE_REENTRANT_API
  Locally applied patches:
	DEBPKG:debian/cpan_definstalldirs - Provide a sensible INSTALLDIRS default for modules installed from CPAN.
	DEBPKG:debian/db_file_ver - http://bugs.debian.org/340047 Remove overly restrictive DB_File version check.
	DEBPKG:debian/doc_info - Replace generic man(1) instructions with Debian-specific information.
	DEBPKG:debian/enc2xs_inc - http://bugs.debian.org/290336 Tweak enc2xs to follow symlinks and ignore missing @INC directories.
	DEBPKG:debian/errno_ver - http://bugs.debian.org/343351 Remove Errno version check due to upgrade problems with long-running processes.
	DEBPKG:debian/libperl_embed_doc - http://bugs.debian.org/186778 Note that libperl-dev package is required for embedded linking
	DEBPKG:fixes/respect_umask - Respect umask during installation
	DEBPKG:debian/writable_site_dirs - Set umask approproately for site install directories
	DEBPKG:debian/extutils_set_libperl_path - EU:MM: Set location of libperl.a to /usr/lib
	DEBPKG:debian/no_packlist_perllocal - Don't install .packlist or perllocal.pod for perl or vendor
	DEBPKG:debian/prefix_changes - Fiddle with *PREFIX and variables written to the makefile
	DEBPKG:debian/fakeroot - Postpone LD_LIBRARY_PATH evaluation to the binary targets.
	DEBPKG:debian/instmodsh_doc - Debian policy doesn't install .packlist files for core or vendor.
	DEBPKG:debian/ld_run_path - Remove standard libs from LD_RUN_PATH as per Debian policy.
	DEBPKG:debian/libnet_config_path - Set location of libnet.cfg to /etc/perl/Net as /usr may not be writable.
	DEBPKG:debian/mod_paths - Tweak @INC ordering for Debian
	DEBPKG:debian/module_build_man_extensions - http://bugs.debian.org/479460 Adjust Module::Build manual page extensions for the Debian Perl policy
	DEBPKG:debian/prune_libs - http://bugs.debian.org/128355 Prune the list of libraries wanted to what we actually need.
	DEBPKG:fixes/net_smtp_docs - [rt.cpan.org #36038] http://bugs.debian.org/100195 Document the Net::SMTP 'Port' option
	DEBPKG:debian/perlivp - http://bugs.debian.org/510895 Make perlivp skip include directories in /usr/local
	DEBPKG:debian/cpanplus_definstalldirs - http://bugs.debian.org/533707 Configure CPANPLUS to use the site directories by default.
	DEBPKG:debian/cpanplus_config_path - Save local versions of CPANPLUS::Config::System into /etc/perl.
	DEBPKG:debian/deprecate-with-apt - http://bugs.debian.org/702096 Point users to Debian packages of deprecated core modules
	DEBPKG:debian/squelch-locale-warnings - http://bugs.debian.org/508764 Squelch locale warnings in Debian package maintainer scripts
	DEBPKG:debian/skip-upstream-git-tests - Skip tests specific to the upstream Git repository
	DEBPKG:debian/patchlevel - http://bugs.debian.org/567489 List packaged patches for 5.18.2-2ubuntu1 in patchlevel.h
	DEBPKG:debian/skip-kfreebsd-crash - http://bugs.debian.org/628493 [perl #96272] Skip a crashing test case in t/op/threads.t on GNU/kFreeBSD
	DEBPKG:fixes/document_makemaker_ccflags - http://bugs.debian.org/628522 [rt.cpan.org #68613] Document that CCFLAGS should include $Config{ccflags}
	DEBPKG:debian/find_html2text - http://bugs.debian.org/640479 Configure CPAN::Distribution with correct name of html2text
	DEBPKG:debian/hurd_test_skip_stack - http://bugs.debian.org/650175 Disable failing GNU/Hurd tests dist/threads/t/stack.t
	DEBPKG:fixes/manpage_name_Test-Harness - http://bugs.debian.org/650451 [rt.cpan.org #73399] cpan/Test-Harness: add NAME headings in modules with POD
	DEBPKG:debian/makemaker-pasthru - http://bugs.debian.org/660195 [rt.cpan.org #28632] Make EU::MM pass LD through to recursive Makefile.PL invocations
	DEBPKG:debian/perl5db-x-terminal-emulator.patch - http://bugs.debian.org/668490 Invoke x-terminal-emulator rather than xterm in perl5db.pl
	DEBPKG:debian/cpan-missing-site-dirs - http://bugs.debian.org/688842 Fix CPAN::FirstTime defaults with nonexisting site dirs if a parent is writable
	DEBPKG:fixes/memoize_storable_nstore - [rt.cpan.org #77790] http://bugs.debian.org/587650 Memoize::Storable: respect 'nstore' option not respected
	DEBPKG:fixes/net_ftp_failed_command - [rt.cpan.org #37700] http://bugs.debian.org/491062 Net::FTP: cope gracefully with a failed command
	DEBPKG:fixes/perlbug-patchlist - [3541c11] http://bugs.debian.org/710842 [perl #118433] Make perlbug look up the list of local patches at run time
	DEBPKG:fixes/module_metadata_security_doc - [68cdd4b] CVE-2013-1437 documentation fix
	DEBPKG:fixes/module_metadata_taint_fix - [bff978f] http://bugs.debian.org/722210 [rt.cpan.org #88576] untaint version, if needed, in Module::Metadata
	DEBPKG:fixes/IPC-SysV-spelling - http://bugs.debian.org/730558 [rt.cpan.org #86736] Fix spelling of IPC_CREAT in IPC-SysV documentation
	DEBPKG:fixes/fix-undef-source -
  Built under linux
  Compiled at Mar 27 2014 18:30:28
  @INC:
    /etc/perl
    /usr/local/lib/perl/5.18.2
    /usr/local/share/perl/5.18.2
    /usr/lib/perl5
    /usr/share/perl5
    /usr/lib/perl/5.18
    /usr/share/perl/5.18
    /usr/local/lib/site_perl
    .

Turns out this is an issue with DBD::mysql, the MySQL database driver for the Perl DBI. You can see detailed discussion with @timbunce and others<EMAIL_ADDRESS>and here, if you're so inclined.  Your traces were very helpful, @melon-babak! At this point, though, I'm not at all sure what I could do to work around the issue, and have no idea when/if it will be fixed by the DBD::mysql maintainers -- especially since they seem to have a number of extant bugs for this issue already. :-(

Thanks for following up and investigating it. It's a bummer, we were excited to use Sqitch in our development workflow, does this mean the way things are now Sqitch and MySQL just can't be used together?

I don't think so; quite a few other folks have used it with MySQL. I'm not clear on why you run into this problem. Your Perl is 64 bit, so that's not the issue. I just don't understand why you've run into this problem and no one else has. Once DBD::mysql fixes the bug it should be all good, though.

Not sure if there's a sqitch users mailing list or something similar. It would be great if we could somehow reach other people who have used Sqitch with MySQL to see what their setup is like.

Mail list right here.
(Need to find someone to make a nice site for sqitch.org where that sort of thing is easier find!)


Update supervised-contrastive-learning.ipynb

Add code block for installing tensorflow-addons

We prefer not to inline the code and instead provide a snippet that users can run themselves. This keeps the file runnable as a standalone Python script.


fix: add link to install released version

Fixes #232
What does this PR do?
Update README to install extension with a simple click
Screenshot / video of UI
N/A
What issues does this PR fix or reference?
#232
How to test this PR?
N/A

@vrothberg can you review it ?

@jeffmaury can you squash the commits or sign the last one to pass the DCO check?


LVM tests should not do as much in the test for specifying your own pool name

currently almost all the lvm tests are run twice, once for the default pool name and once for specifying a user pool name.
since the tests are so slow on @stgraber's laptop, we should trim it down a bit

fixed in https://github.com/lxc/lxd/pull/1011


Entity factory to clean up replacement

Right now entity replacement is a mess, which also generally only works for when entities are saved and loaded, but does not handle direct instantiation.
Replacing all calls to new to make a new entity with a call to a factory to instantiate the entity would allow addons to register entity replacement mappings for use whenever the factory is invoked.

Whoops, duplicate issue.


ghc: revert "compile with DWARF support by default"

This reverts commits<PHONE_NUMBER>790d2c733eb1fa9c2034826996b176 and
f4316473d94e0e5eff2736bd24dc802e09752771 from PR #68362.
Fixes https://github.com/NixOS/nixpkgs/issues/69023.
I'm running tests builds right now to verify that this change actually fixes the issue.

For people looking for follow-ups, see https://github.com/NixOS/nixpkgs/pull/68362#issuecomment-612232099.


Quaterniond coeff ordering inconsistency

It looks like according to eigen the Quaternion coeff ordering should be wxyz, in which case the identity should be 1,0,0,0 as follows:
 Quaternion (const Scalar &w, const Scalar &x, const Scalar &y, const Scalar &z)

I assume the coefficients would print in this same order but this seems like it might not be the case:
$ q = e.Quaterniond()
$ q.setIdentity()
$ print(np.array(q.coeffs()))
[[ 0.]
 [ 0.]
 [ 0.]
 [ 1.]]
# w, x, y, z should also be identity for q2
$ q2 = e.Quaterniond(1,0,0,0)
$ qcoeffs = np.array(q.coeffs())
$ q2 = e.Quaterniond(qcoeffs[0,0],qcoeffs[1,0],qcoeffs[2,0],qcoeffs[3,0])
$ print(np.array(q2.coeffs()))
[[ 0.]
 [ 0.]
 [ 1.]
 [ 0.]]
# the angular distance between two identity quaternions should be zero
$ q.angularDistance(q2)
3.141592653589793
# The above doesn't seem right, it should be 0...
$ q2 = e.Quaterniond(1,0,0,0)
$ print(np.array(q2.coeffs()))
[[ 0.]
 [ 0.]
 [ 0.]
 [ 1.]]
# shouldn't this be 1, 0, 0, 0?
$ q.angularDistance(q2)
0.0
# this is what I expected
$ q.w()
1.0
$ q.x()
0.0
$ q.y()
0.0
$ q.z()
0.0
$ vq2 = e.Vector4d(np.array([1,0,0,0]))
$ q2 = e.Quaterniond(vq2)
$ np.array(q2.coeffs())
array([[ 1.],
       [ 0.],
       [ 0.],
       [ 0.]])
$ q.angularDistance(q2)
3.141592653589793

Hi Andrew,
It can be a bit confusing indeed :)
coeffs() returns a Vector4d so that the vector coefficients are (x, y, z, w) (see doc)
The constructor also handles a Vector4d and 4 scalars very differently.
This means that:
v = eigen.Vector4d(0, 0, 0, 1) # (x, y, z, w)
q = eigen.Quaterniond(v) # q is Identity, q.coeffs() == v
q = eigen.Quaterniond(v(0), v(1), v(2), v(3)) # q is (0, 0, 1, 0)

which is why in your example: q2 = e.Quaterniond(qcoeffs[0,0],qcoeffs[1,0],qcoeffs[2,0],qcoeffs[3,0]) is not what you expected.

oh wow that's actually how it is done in eigen... I feel like the eigen authors had more consistent options available. :-/
I hadn't actually used coeffs directly in eigen before, how surprising. I'm going to add my session above to the docs so people can reference it.

question is resolved, code is in the readme


Searchbars & School Page Complete

WHAT DOES THIS PR DO?

Changes styles of search bars and input fields in multiple places
Changes styles of search bars in dark mode
Updates search format in school page
Updates courses in school page based on search
Change course card info to make it simpler
Adds mobile responsiveness for school page
Adds search icons to search bars
Adds 3 layer filtering to the courses

WHAT ISSUES ARE RELATED TO THIS PR?

#4
#141
#108
#61
#107

HOW DO I TEST OUT THIS PR?

Make sure the local server is running using python3 manage.py runserver in the api directory. Head over to the web directory and run npm i and npm run dev to run the frontend. You can test the filtering by searching a school (UNLV) and typing in some course name. This filters by first the subject, then the catalogue number, then the course title.

Codecov Report
All modified and coverable lines are covered by tests :white_check_mark:

Comparison is base (4bb2ace) 91.56% compared to head (d5837a5) 91.56%.
Report is 5 commits behind head on main.

:exclamation: Your organization needs to install the Codecov GitHub app to enable full functionality.
Additional details and impacted files
@@           Coverage Diff           @@
##             main     #154   +/-   ##
=======================================
  Coverage   91.56%   91.56%
=======================================
  Files          29       29
  Lines         830      830
  Branches        6        6
=======================================
  Hits          760      760
  Misses         70       70

Flag
Coverage Δ

web
100.00% <ø> (ø)

Flags with carried forward coverage won't be shown. Click here to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.


Move io3d.ui to io3d.utils.ui and io3d.auth to io3d.utils.auth

i suggest to have only official products being placed in main namespace io3d to keep things clean.
moving io3d.ui and io3d.auth to utils would keep things more consistent with our product definition.
@AVGP @frederic-schwarz what do you think?

i will move the methods to io3d.utilsand keep the old ones as aliases so that we have a grace period to adapt all apps depending on it

agreed to move to utils


select list only displays selected item if items are wrapped in  tags, fails to raise selected event and fails to show mouse-over effect, doesn't support disabled items

me thinks the  'li' items should be able to be just text.
Issues this causes:
The line items take on the styles for an 'a' tag (as you would expect) but I don't want this.
There is no mouse-over effect and no events
There is no support for a "disabled" line item
Also, there is an undocumented attribute "data-resize" used in the demos with no mention of possible values anywhere on the doco page. (other than "auto" - which still has no description)
Also, the selectlist supports both "click" and "changed" events. However the "click" event fires for both opening the control and clicking on an item. It can not detect a change although it fires on "text" only items. The "click" event is not documented...
btw - adding "fuelux" class to a container makes no difference. Is it only for certain components?

Philosophically, I agree.
*The selectlist uses a because the basic Bootstrap dropdown uses a tags

Our library is declarative, you should be able to style the control as needed.
I'll create and issue to document the data-resize.

None of the styles should take effect without a container "fuelux" class.

We will be addressing this in an upcoming release. Thank you!


TagBot trigger issue

This issue is used to trigger TagBot; feel free to unsubscribe.
If you haven't already, you should update your TagBot.yml to include issue comment triggers.
Please see this post on Discourse for instructions and more details.
If you'd like for me to do this for you, comment TagBot fix on this issue.
I'll open a PR within a few hours, please be patient!

Triggering TagBot for merged registry pull request: https://github.com/JuliaRegistries/General/pull/105073

Triggering TagBot for merged registry pull request: https://github.com/JuliaRegistries/General/pull/105541

Triggering TagBot for merged registry pull request: https://github.com/JuliaRegistries/General/pull/109903


Modal breaks SSR

Hello,
Using Modal with SSR specifically using next.js breaks SSR for some reason. Any ideas why that might be? I am not sure if it is specific to semantic or next.js
Steps
git clone https://github.com/kolpav/semantic-ui-ssr-bug
cd semantic-ui-ssr-bug
yarn
yarn dev

Expected Result
Should not break SSR
Actual Result
Breaks SSR
Warning: React attempted to reuse markup in a container but the checksum was invalid. This generally means that you are using server rendering and the markup generated on the server was not what the client was expecting. React injected new markup to compensate which works but you have lost many of the benefits of server rendering. Instead, figure out why the markup being generated is different on the client or server:
 (client) v data-reactid="2"><span data-reactid="3
 (server) v data-reactid="2"><!-- react-empty: 3 -

Version
0.67.2
Testcase
https://github.com/kolpav/semantic-ui-ssr-bug

Thanks for the repro case, we'll check on this as soon as we can.  If you are debugging, this is probably related to the Portal.  The Portal renders a new subtree into the document body in order to achieve the necessary markup for Modals.
I don't know next.js, but you might google around for other users' issues with the portal pattern for now.

For now it is possible to avoid breaking SSR by using react-no-ssr like this

+1

+1

Hey folks, thanks for showing support.  It would be most helpful if you could use the react button opposed to posting a comment.  Comments trigger emails and notifications for us.

The reactions are also a little more clear as to what you are giving a thumbs up to.

Any update on this. Experiencing exactly the same issue on version 0.75.1

Please post a new issue against the latest release 0.77.0.


Avoid Ruby 2.2 warning

Under Ruby 2.2:
msworddoc-extractor-0.1.0/lib/msworddoc/extractor.rb:308: warning: duplicated key at line 311 ignored: "\r"
The key/value pair "\x0d" => "\n" is duplicated in CHARMAP – this pull request removes the second occurrence.

Thanks! :bow:


Unable to ineract with table row widgets (regression)

Unable to interact with table row widgets
I tested with 0.26.2 and also latest master as of (14/02/2024).
0.26 introduced a regression to the  TableBuilder / Table behavior.
TableBuilder::new(ui).sense(Sense::click(())
Previous: Rows are clickable. Inner widgets can be interacted with (for example a checkbox)
Current: Rows are clickable. Inner widgets can't be interacted with.
You need to remove .sense(Sense::click()) to have the inner widgets be interactable.
Reproduce
You can reproduce this behavior using the web demo.

Enable "Table Demo" on the right side
Enable "Clickable rows"
Rows are clickable
Try to use the "Click me" checkbox, it doesn't work.
Disable "Clickable rows"
Rows aren't clickable
Try to use the "Click me" checkbox, it works

The problem is that StripLayout::add does the cell interaction on top of the contents, but it needs to be done below it (before adding contents). 🤔

I closed this by accident. I have a rough plan for this, and will hopefully find time to work on in the coming week


Update axios version to 0.18.1 or later

Update axios version to 0.18.1 or later for security. https://github.com/StackStorm/st2client.js/network/alerts

As @armab noted, we're going to have to bisect our axios dependency version to find the first version that breaks st2client.js.
Since we aren't going to have the time to do that in the foreseeable future, I'm closing this PR. We can reopen it (or open a new one) in the future when we have more time to bisect properly.


Use actual local interfaces in the mirror candidates.

Windows does not allow physical interfaces to send to loopback.
Fixes https://github.com/uProxy/uproxy/issues/1740

The restructuring looks good, methods are doing things that more closely correspond to their description.
Just a couple of requests for comments to explain some call ordering constraints. Trusting you to add those. Then big fat LGTM :+1: as I'm very happy to see this land and fix windows! :)

Reviewed 2 of 2 files at r1.
Review status: all files reviewed at latest revision, 4 unresolved discussions, some commit checks failed.

src/churn-pipe/churn-pipe.ts, line 313 [r1] (raw file):
So not part of this pull request, but rather close to it... the type of "promises" doesn't seem to be used, so it should be Object instead of "any"...

src/churn-pipe/churn-pipe.ts, line 380 [r1] (raw file):
So it seems that bindLocal_ is required to have been called before this method, this should be written in a comment for the method. Also, I don't quite see how/why this is enforced. Maybe add that as a comment too?

src/churn/churn.ts, line 173 [r1] (raw file):
Should this comment be a line lower down?

src/churn/churn.ts, line 196 [r1] (raw file):
Seems like a slightly random place for this comment?

Comments from the review on Reviewable.io

(assigned to me as @trevj is out until tomorrow)

Review status: 0 of 2 files reviewed at latest revision, 4 unresolved discussions, some commit checks pending.

src/churn-pipe/churn-pipe.ts, line 313 [r1] (raw file):
Done.

src/churn-pipe/churn-pipe.ts, line 380 [r1] (raw file):
Done.

src/churn/churn.ts, line 173 [r1] (raw file):
Done.

src/churn/churn.ts, line 196 [r1] (raw file):
Moved.

Comments from the review on Reviewable.io

:+1:

Review status: 0 of 2 files reviewed at latest revision, all discussions resolved, some commit checks pending.

Comments from the review on Reviewable.io


Also add c14n method to the reference transforms in XML metadata.

This fixes parsing of our generated XML with some remote entities, notably ADFS. This was present in the old metadata (pre-twig) and is also present in e.g. the signed Responses we send and in metadata generated by other products.
XML before:
<ds:Reference URI="#EB...">
    <ds:Transforms>
        <ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/>
    </ds:Transforms>
    <ds:DigestMethod Algorithm="http://www.w3.org/2001/04/xmlenc#sha256"/>
    <ds:DigestValue>...</ds:DigestValue>
</ds:Reference>

XML after:
<ds:Reference URI="#EB...">
    <ds:Transforms>
        <ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/>
        <ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/>
    </ds:Transforms>
    <ds:DigestMethod Algorithm="http://www.w3.org/2001/04/xmlenc#sha256"/>
    <ds:DigestValue>...</ds:DigestValue>
</ds:Reference>

Other users do the same, see e.g. https://github.com/simplesamlphp/simplesamlphp/blob/d6d30c87235c3dc3c9690753d7da487b02613972/lib/SimpleSAML/Metadata/Signer.php#L284
Thanks @tvdijen for finding an analyzing the issue.

Looks good! We could further cover this in test by adding some assertions to the Metadata.feature acceptance test. But seeing this verified in the unit test should be sufficient test coverage.


Item scores

Add last_item.score to item pickup as a % confidence. Suspect this will be useful for support, helping users decide on threshold, etc.

Nice


feat: add option to assume-role in route53

What this PR does / why we need it:
This PR adds the field role to the route53 dns provider. It allows users to specify a role per route53 provider which lets them manage zones in other accounts. see discussion at #1274
Which issue this PR fixes: fixes #1274
Special notes for your reviewer:
There is bunch of documentation missing regarding route53 (see #1750). This PR will add a minimum-viable documentation only for this specific field.
The assume-role logic itself is trivial but i really wanted a way to test the behavior (hence the indirection using type sessionProvider).
Release note:
None

@moolen I see this hasn't been assigned yet. Where are you in the development? Hoping to get this merged as this is a feature that I require.
Thanks

I'm waiting for feedback. I missed the part with /assigning someone :sweat_smile:
/assign @kragniz

I'm waiting for feedback. I missed the part with /assigning someone 😅
/assign @kragniz

No problem. That is why I pinged you. I missed that in my PR as well.
I am going to build your branch and test.

@moolen
Test successfully.

thanks for your effort! <3

Thanks for testing @cyrus-mc 😄
I'm going to take a look over the implementation for this today. I'm personally not so well versed in AWS APIs, so I'm going to defer API review to someone else who is.. 🙄.
/cc @simonswine
/cc @JoshVanL
/ok-to-test

/test pull-cert-manager-e2e-v1-13 (could not resolve host github.com)

@simonswine & @munnerz i added docs for auth, policies, api spec and changed the DefaultSessionDuration. PTAL.

/test pull-cert-manager-e2e-v1-13

ping @simonswine @munnerz

Thanks for this 😄
/lgtm
/approve

Would you mind also editing your original comment and adding a short (one-line) release note for this change?

Can you run bazel run //hack:update-crds and commit the changes? 😄
/lgtm cancel

i rebased, updated the CRDs and squashed the commits. that should do it :crossed_fingers:

/lgtm


Mistake in 191 line if is_speculative=True generate.py ?

Am I right that here is a mistake?
In 191 line generate.py
Because for batch>1 cur_token will have more than 1 element so next_token.view(()) will give an error.
if is_speculative:
        input_pos = input_pos.item()  # for speculative decoding easier to keep on host
        while input_pos < T_new - 1:
            cur_token = next_token.view(())

            next_tokens = speculative_decode(
                model, draft_model, cur_token, input_pos, speculate_k, **sampling_kwargs
            )

@malfet Could you help, please?


Replaced string concatenation with template literals for better readability

This changes the formatting of the outputted warning.
Previously only certain parts are yellow with this change everything is.

I think this was intentionally left with string concats, as achiving the same with templates string is hard and not easier to read

Thanks for the insight and sorry for the oversight. I am a complete
beginner in the open source field. I first talked about this on the Slack
group https://owasp.slack.com/archives/C255XSY04 but did not receive any
response. Can you guide me as to what is the correct procedure if I am
planning to work on the issue. For example: The next issue while waiting
for the reply I was planning to work upon was to improve the debug
statements. Can you please share your thoughts on this?
On Thu, Sep 5, 2024 at 12:13 AM Jannik Hollenbach @.***>
wrote:

This changes the formatting of the outputted warning.
Previously only certain parts are yellow, with this change everything is.
Screenshot.2024-09-04.at.20.40.25.png (view on web)
https://github.com/user-attachments/assets/9e952fc3-8d93-427f-95a1-c7cdd891045d
I think this was intentionally left with string concats, as achiving the
same with templates string is hard and not easier to read
—
Reply to this email directly, view it on GitHub
https://github.com/juice-shop/juice-shop-ctf/pull/144#issuecomment-2329743550,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/A2NX44JL46RYG2QML2G3AW3ZU5ID7AVCNFSM6AAAAABNU4QVWKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMRZG42DGNJVGA
.
You are receiving this because you authored the thread.Message ID:
@.***>

See comment in #146


Can Blockchain improve Machine Learning privacy?

Proposed title of article
Your title should be descriptive of the article/tutorial. Be Specific. Use keyword research to gain your article higher ranking.
Can Blockchain improve Machine Learning privacy?
Introduction paragraph (2-3 paragraphs):
Machine Learning algorithms have thrived in the era of big data. But to use that data safely and effectively, we have to take privacy into account when developing Machine Learning systems. This is especially the case when it comes to using sensitive data such as protected health records.
There has been previous attempts to solve this problem using Federated Learning and Differential Privacy but it turns out that these systems have a flaw which we'll discuss in the article. And that Blockchain technology might help us solve it.
Key takeaways:
What are the 3-5 most important things the reader should understand or be able to do after reading this article? Use this area to get your ideas down on the bulk of your article or tutorial.
By the end of this tutorial, a reader should be able to:

Understand the flaws associated with Federated Learning
Understanding the flaws associated with Differential Privacy
Understand how Blockchain technology can help solve this issue and improve ML privacy.

References:
Please list links to any published content/research that you intend to use to support/guide this article.

Machine Learning in/for Blockchain: Future and Challenges
Efficient Privacy-Preserving Machine Learning for Blockchain Network
AI and Blockchain: A Disruptive Integration
Secured Deep Learning in Remote Devices

Templates to use as guides

How To Guide Template
Software Review Template
Tutorial Template

This has been covered widely in eng-Ed and the net in general. We prefer articles that cover something new. A problem that you faced and how you solved it, or a project you worked on. I encourage you to cover a unique project covering MlPs... For example, analysing various data types using MLPs and the code implementation.
@hectorkambow

@lalith1403 Thank you for the insight. Let me research on that.
How about this new topic suggestion. I've edited the issue. I believe it should be a good one. What are your thoughts on subject?

This is an interesting topic. Good to explain all the concepts under federated learning, differential privacy and then talk about the setbacks. Once enough information has been given, then you may talk about how Blockchain will help solve the problem. Be as detailed and specific with the explanations.
Best of luck.
Cc: @hectorkambow

@wilkistermumbi
Sounds like a very helpful topic - lets please be sure it add value beyond what is in the official docs and what is covered in other blog sites.
Please be sure to double check that it does not overlap with any existing EngEd articles or incoming topic suggestions (if you haven't already) to avoid any potential article closure, please reference any relevant EngEd articles in yours. - Approved


multidate not working when using setDate

i am unable to select multiple date when using setDate along with multidate.
for example:
var dateAdded = ["2015-07-15","2015-07-17"];
     var dates = [];
                $.each(dateAdded, function(i, dateStr){
                    var d = new Date();
                    var dateArray = dateStr.split("-");
                    d.setFullYear(parseInt(dateArray[0]));
                    d.setMonth(parseInt(dateArray[1])-1);
                    d.setDate(parseInt(dateArray[2]));
                    dates.push(d);
                });

$(element).datepicker("setDates",dates);
above code will setDates ,when trying to select other dates the above dates will get unselected and the multiselect will not work ,you can just select one date at a time.

my bad the option multidate was only sent on attrs.$observe but not when loading the angular directive,i just added the option when loading the directive.


[Bug] [SHELL] unable to change directory to /home/default

Search before asking

[X] I had searched in the issues and found no similar issues.

What happened
DS deployed by kubernetes(EKS).I get an error when I create a shell task:
[WI-6][TI-6] - [INFO] 2024-03-04 02:17:27.982 +0000 o.a.d.p.t.a.s.BaseLinuxShellInterceptorBuilder:[68] - ****************************** Script Content *****************************************************************
[WI-6][TI-6] - [INFO] 2024-03-04 02:17:27.983 +0000 o.a.d.p.t.a.s.BaseShellInterceptor:[46] - Executing shell command : sudo -u default -i /tmp/dolphinscheduler/exec/process/default/12778447812128/12778570250784_7/6/6/6_6.sh
[WI-6][TI-6] - [INFO] 2024-03-04 02:17:27.987 +0000 o.a.d.p.t.a.AbstractCommandExecutor:[154] - process start, process id is: 110
[WI-0][TI-6] - [INFO] 2024-03-04 02:17:28.776 +0000 o.a.d.s.w.r.l.TaskInstanceExecutionRunningEventAckListenFunction:[44] - Receive TaskInstanceExecutionRunningEventAck: TaskInstanceExecutionRunningEventAck(taskInstanceId=6, success=true)
[WI-0][TI-6] - [INFO] 2024-03-04 02:17:28.786 +0000 o.a.d.s.w.r.l.TaskInstanceExecutionInfoEventAckListenFunction:[45] - Receive TaskInstanceExecutionInfoEventAck: TaskInstanceExecutionInfoEventAck(success=true, taskInstanceId=6)
[WI-0][TI-0] - [INFO] 2024-03-04 02:17:28.986 +0000 o.a.d.p.t.a.AbstractTask:[169] -  ->
	sudo: unable to change directory to /home/default: No such file or directory
	###############################################

and my Dockerfile:
FROM dolphinscheduler.docker.scarf.sh/apache/dolphinscheduler-worker:3.2.1

COPY mysql-connector-j-8.0.32.jar /opt/dolphinscheduler/libs

values.yaml where modify:
zookeeper
  image:
    registry: docker.io
    repository: bitnami/zookeeper
    tag: 3.7.2-debian-11-r6
    pullPolicy: IfNotPresent
    debug: false

What you expected to happen
I dont know
How to reproduce
just deploy by kubernetes and use arm64 image  and modify zookeeper image
Anything else
No response
Version
3.2.x
Are you willing to submit PR?

[ ] Yes I am willing to submit a PR!

Code of Conduct

[X] I agree to follow this project's Code of Conduct

Tenant default does not exists in your Linux system. You should create it first or choose an exists tenant. @ahululu

root cause: #15669


feat: add switching by cells with arrows on the keyboard

key LEFT and RIGHT
the corresponding click moves the focus to the left or right

@bulhiCzar Heavy load work, can you test v2.1.3 for this? Maybe a little bit buggy.

good its worked

@bulhiCzar Can you help me test v2.1.4?  I enabled the tab Shift + Tab keys as the arrow keys as well


Can you support DNS-over-QUIC?

Related protocol documents：
DNS-over-QUIC

That would require a QUIC implementation, I guess, which would add an additional dependency (outside the standard library).
I don't see myself working on it, TBH.