{"action":"created","issue":{"url":"https://api.github.com/repos/open-mpi/mtt/issues/656","repository_url":"https://api.github.com/repos/open-mpi/mtt","labels_url":"https://api.github.com/repos/open-mpi/mtt/issues/656/labels{/name}","comments_url":"https://api.github.com/repos/open-mpi/mtt/issues/656/comments","events_url":"https://api.github.com/repos/open-mpi/mtt/issues/656/events","html_url":"https://github.com/open-mpi/mtt/issues/656","id":330291129,"node_id":"MDU6SXNzdWUzMzAyOTExMjk=","number":656,"title":"Perl client cannot send results to the DB","user":{"login":"gvallee","id":419592,"node_id":"MDQ6VXNlcjQxOTU5Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/419592?v=4","gravatar_id":"","url":"https://api.github.com/users/gvallee","html_url":"https://github.com/gvallee","followers_url":"https://api.github.com/users/gvallee/followers","following_url":"https://api.github.com/users/gvallee/following{/other_user}","gists_url":"https://api.github.com/users/gvallee/gists{/gist_id}","starred_url":"https://api.github.com/users/gvallee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gvallee/subscriptions","organizations_url":"https://api.github.com/users/gvallee/orgs","repos_url":"https://api.github.com/users/gvallee/repos","events_url":"https://api.github.com/users/gvallee/events{/privacy}","received_events_url":"https://api.github.com/users/gvallee/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-07T14:12:43Z","updated_at":"2018-06-07T16:47:55Z","closed_at":null,"author_association":"NONE","body":"Since I upgraded my MTT Perl client to a90aac4, I am getting the following error that prevents me from sending the results back to the Open MPI MTT server (I did not closely look at it yet):\r\n```\r\nSQL ERROR: ERROR:  insert or update on table \"test_run\" violates\r\n    foreign key constraint \"test_run_clck_id_fkey\"\r\n    DETAIL:  Key (clck_id)=(-38) is not present in table \"cluster_checker\".\r\n    SQL ERROR:\r\n    <br />\r\n    <font size='1'><table class='xdebug-error xe-warning' dir='ltr'\r\n    border='1' cellspacing='0' cellpadding='1'>\r\n    <tr><th align='left' bgcolor='#f57900' colspan=\"5\"><span\r\n    style='background-color: #cc0000; color: #fce94f; font-size:\r\n    x-large;'>( ! )</span> Warning:\r\n    error_log(/mnt/data/mtt.open-mpi.org/log/mtt-php-errors.log): failed to\r\n    open stream: No such file or directory in\r\n    /opt/app-root/src/database.inc on line <i>179</i></th></tr>\r\n    <tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>\r\n    <tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left'\r\n    bgcolor='#eeeeec'>Time</th><th align='left'\r\n    bgcolor='#eeeeec'>Memory</th><th align='left'\r\n    bgcolor='#eeeeec'>Function</th><th align='left'\r\n    bgcolor='#eeeeec'>Location</th></tr>\r\n    <tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec'\r\n    align='center'>0.0001</td><td bgcolor='#eeeeec'\r\n    align='right'>256432</td><td bgcolor='#eeeeec'>{main}(  )</td><td\r\n    title='/opt/app-root/src/submit/index.php'\r\n    bgcolor='#eeeeec'>../index.php<b>:</b>0</td></tr>\r\n    <tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec'\r\n    align='center'>0.0518</td><td bgcolor='#eeeeec'\r\n    align='right'>345784</td><td bgcolor='#eeeeec'>process_phase(\r\n    )</td><td title='/opt/app-root/src/submit/index.php'\r\n    bgcolor='#eeeeec'>../index.php<b>:</b>135</td></tr>\r\n    <tr><td bgcolor='#eeeeec' align='center'>3</td><td bgcolor='#eeeeec'\r\n    align='center'>0.0565</td><td bgcolor='#eeeeec'\r\n    align='right'>347824</td><td bgcolor='#eeeeec'>process_phase_test_run(\r\n    )</td><td title='/opt/app-root/src/submit/index.php'\r\n    bgcolor='#eeeeec'>../index.php<b>:</b>190</td></tr>\r\n    <tr><td bgcolor='#eeeeec' align='center'>4</td><td bgcolor='#eeeeec'\r\n    align='center'>1.3825</td><td bgcolor='#eeeeec'\r\n    align='right'>384232</td><td bgcolor='#eeeeec'>select_insert(\r\n    )</td><td title='/opt/app-root/src/submit/index.php'\r\n    bgcolor='#eeeeec'>../index.php<b>:</b>480</td></tr>\r\n    <tr><td bgcolor='#eeeeec' align='center'>5</td><td bgcolor='#eeeeec'\r\n    align='center'>1.3836</td><td bgcolor='#eeeeec'\r\n    align='right'>388472</td><td bgcolor='#eeeeec'>do_pg_query(  )</td><td\r\n    title='/opt/app-root/src/submit/index.php'\r\n    bgcolor='#eeeeec'>../index.php<b>:</b>1420</td></tr>\r\n    <tr><td bgcolor='#eeeeec' align='center'>6</td><td bgcolor='#eeeeec'\r\n    align='center'>1.3895</td><td bgcolor='#eeeeec'\r\n    align='right'>395424</td><td bgcolor='#eeeeec'><a\r\n    href='http://www.php.net/function.error-log'\r\n    target='_new'>error_log</a>\r\n    (  )</td><td title='/opt/app-root/src/database.inc'\r\n    bgcolor='#eeeeec'>../database.inc<b>:</b>179</td></tr>\r\n    </table></font>   \r\n    MTTDatabase server error:\r\n    SQL QUERY: INSERT INTO test_run\r\n            (test_run_id, submit_id, compute_cluster_id,\r\n    mpi_install_compiler_id, mpi_get_id, mpi_install_configure_id,\r\n    mpi_install_id, test_suite_id, test_build_compiler_id, test_build_id,\r\n    test_name_id, performance_id, test_run_command_id, np, full_command,\r\n    description_id, start_timestamp, test_result, trial, submit_timestamp,\r\n    duration, environment_id, result_stdout, result_stderr,\r\n    result_message_id, merge_stdout_stderr, exit_value, exit_signal,\r\n    client_serial) VALUES\r\n            ('27708', '1', '2', '1', '29', '1', '222', '1', '1', '479',\r\n    '6', '0', '2', '40', 'cat <<EOTT > ./mtt.batch\r\n```"},"comment":{"url":"https://api.github.com/repos/open-mpi/mtt/issues/comments/395489431","html_url":"https://github.com/open-mpi/mtt/issues/656#issuecomment-395489431","issue_url":"https://api.github.com/repos/open-mpi/mtt/issues/656","id":395489431,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NTQ4OTQzMQ==","user":{"login":"jsquyres","id":617316,"node_id":"MDQ6VXNlcjYxNzMxNg==","avatar_url":"https://avatars2.githubusercontent.com/u/617316?v=4","gravatar_id":"","url":"https://api.github.com/users/jsquyres","html_url":"https://github.com/jsquyres","followers_url":"https://api.github.com/users/jsquyres/followers","following_url":"https://api.github.com/users/jsquyres/following{/other_user}","gists_url":"https://api.github.com/users/jsquyres/gists{/gist_id}","starred_url":"https://api.github.com/users/jsquyres/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsquyres/subscriptions","organizations_url":"https://api.github.com/users/jsquyres/orgs","repos_url":"https://api.github.com/users/jsquyres/repos","events_url":"https://api.github.com/users/jsquyres/events{/privacy}","received_events_url":"https://api.github.com/users/jsquyres/received_events","type":"User","site_admin":false},"created_at":"2018-06-07T16:47:55Z","updated_at":"2018-06-07T16:47:55Z","author_association":"MEMBER","body":"This usually means that you are submitting a test run without a corresponding mpi install."}}
{"actor":{"display_login":"jsquyres"}}