Open MPI logo

MTT Devel Mailing List Archives

  |   Home   |   Support   |   FAQ   |   all MTT Users mailing list

From: Tim Prins (tprins_at_[hidden])
Date: 2007-07-01 21:37:17


Hi Folks,

For a while now we have been getting errors when MTT tries to submit its test
results to the database. The weird thing is that it only happens on our 1.2
runs, not our trunk runs.

Here is the first few lines of the error output:
*** WARNING: MTTDatabase server notice: fields is not in mtt3 database.
    MTTDatabase server notice: test_build_section_name is not in mtt3
    database.
    MTTDatabase server notice: mpi_install_section_name is not in mtt3
    database.
    MTTDatabase server notice: mtt_version_minor is not in mtt3 database.
    MTTDatabase server notice: stop_timestamp is not in mtt3 database.
    MTTDatabase server notice: mtt_version_major is not in mtt3 database.
    MTTDatabase server notice: number_of_results is not in mtt3 database.
    MTTDatabase server notice: test_run_section_name is not in mtt3
    database.

    MTT submission for test run
    MTTDatabase server error:
    SQL QUERY:
             INSERT INTO speedy_test_run
             (np,
            variant,
            test_build_id,
            command,
            test_name,
            test_run_id)
             VALUES
             ('8',
            '1',
            '20809',
            'mpirun -mca pml ob1 -mca btl_tcp_if_include eth0 -mca btl
    tcp,sm,self -np 8 --prefix
    /san/homedirs/mpiteam/mtt-runs/thor/20070630-Nightly/pb_0/installs/k1mL
    /install collective/allgather ',
            'allgather',
            '14517807')

    SQL ERROR: ERROR: insert or update on table "speedy_test_run" violates
    foreign key constraint "$1"
    DETAIL: Key (test_build_id)=(20809) is not present in table
    "speedy_test_build".

Another strange thing is that the output says that the build information and
some test results have been submitted, but I do not see them in the reporter.
Any ideas?

Thanks,

Tim