Cool. Thanks Lucas!

Josh

On 04/15/2014 06:48 PM, Lucas Meneghel Rodrigues wrote:
Tomorrow I'll talk to Cleber and we'll see if we can get a reasonable
solution for this issue.


On Tue, Apr 15, 2014 at 8:15 PM, Josh Hunt <[email protected]
<mailto:[email protected]>> wrote:

    Looking around some more I found that only 3 files refer to this table:

    database_legacy/schema_068.sql
    frontend/client/src/autotest/__public/EmbeddedTkoClientTest.__html
    frontend/client/src/autotest/__tko/MetricsPlotFrontend.java

    The schema file does:

    DROP TABLE IF EXISTS `tko_perf_view_2`;

    which if that was run I guess explains why I don't see it anymore :)

    The EmbeddedTkoClientTest.html file looks outdated, and the
    MetricsPlotFrontend.java file must be what I was hitting when I
    encountered this error originally.

    It looks like this commit is what makes the change:

    commit 1e9dff1e08c1e41ec1c7bc1ce49639__ab8bac4032
    Author: Cleber Rosa <[email protected] <mailto:[email protected]>>
    Date:   Wed Jan 23 09:54:36 2013 -0300

         database: get rid of the tko migration files

    there's also some things going with this commit as well:

    commit 27159e932a91485b69eac638f420ab__c68c41064f
    Author: Cleber Rosa <[email protected] <mailto:[email protected]>>
    Date:   Tue Jan 22 19:05:40 2013 -0300

         database: renamed database dir to database_legacy

    I don't know enough about the db and setup here to venture a guess
    though.

    Josh



    On 04/15/2014 05:46 PM, geoffrey papilion wrote:

        I believe it was due to the update of the migrations scripts in
        0.15?
        I filed an issue about it on github.

        I'll send the stuff over to you, when I'm done with some meetings.

        //geoff

        On Tue, Apr 15, 2014 at 3:33 PM, Josh Hunt <[email protected]
        <mailto:[email protected]>> wrote:

            Geoff

            That would be great if you could send me what you have.

            Do you know why the table is missing? Was it deleted on
            accident/purpose as
            part of some cleanup? Or did I miss some steps during
            setup/install?

            Thanks
            Josh


            On 04/15/2014 05:02 PM, geoffrey papilion wrote:


                I've had issues with this in the past, and have
                recreated the tables.
                I was working on south migrations but haven't pushed
                them up. I can
                send you the raw SQL if you'd like.

                //geoff

                On Tue, Apr 15, 2014 at 2:52 PM, Josh Hunt
                <[email protected] <mailto:[email protected]>> wrote:


                    I'm interested in being able to compare performance
                    results in autotest
                    and
                    was trying to use the preconfigured "kernel_compare"
                    results, but it is
                    returning an error:

                    ProgrammingError: (1146, "Table
                    'autotest_web.tko_perf_view_2' doesn't
                    exist")

                    This is on the "graphing" page of the results db. I
                    select
                    "kernel_compare"
                    from the Preconfigured dropdown box, and then hit
                    graph and I get the
                    above
                    error.

                       From the cmdline I checked my mysqldb and see
                    that there is no table
                    named
                    tko_perf_view_2 in there.

                    I'm running autotest 0.15.1. This machine is running
                    Ubuntu 12.04.3 LTS
                    and
                    was installed using the autotest setup script.

                    If this is not a known issue resolved in a later
                    release, please let me
                    know
                    what information you'd like me to provide to debug
                    this. We can also
                    discuss
                    further @ #autotest.

                    In addition to the above error I'm more generally
                    interested in being
                    able
                    to compare performance results b/t benchmarks run in
                    autotest. However, I
                    do
                    not see the perf keyvals being added to the
                    tko_iteration_result table
                    like
                    I was expecting. I realize this is a separate
                    issue/question.

                    Thanks
                    Josh



                    _________________________________________________
                    Autotest-kernel mailing list
                    [email protected]
                    <mailto:[email protected]>
                    https://www.redhat.com/__mailman/listinfo/autotest-__kernel
                    <https://www.redhat.com/mailman/listinfo/autotest-kernel>


    _________________________________________________
    Autotest-kernel mailing list
    [email protected] <mailto:[email protected]>
    https://www.redhat.com/__mailman/listinfo/autotest-__kernel
    <https://www.redhat.com/mailman/listinfo/autotest-kernel>




--
Lucas

_______________________________________________
Autotest-kernel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/autotest-kernel

Reply via email to