(dlrn-venv)[stack@rhev-i8c-03 DLRN]$ sqlite3 commits.sqlite
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
commits projects
sqlite> select from commits;
sqlite> select from projects;
sqlite>
You can also see this error via jenkins:
fatal: [rhev-i8c-03.mpc.lab.eng.bos.redhat.com]: FAILED! => {"changed": true, "cmd": "source /home/stack/dlrn-venv/bin/activate; while true; do\n dlrn --config-file projects.ini --head-only --package-name openstack-nova --local --info-repo rdoinfo --dev || /bin/true;\n STATUS=$(echo \"select status from commits where project_name == 'openstack-nova' order by id desc limit 1;\" | sqlite3 commits.sqlite);\n if [ \"$STATUS\" == \"FAILED\" ] ; then\n exit 1;\n elif [ \"$STATUS\" == \"SUCCESS\" ] ; then\n break;\n elif [ \"$STATUS\" == \"RETRY\" ] ; then\n continue;\n fi;\n exit 1;\n done;", "delta": "0:03:53.932012", "end": "2016-11-21 14:26:51.557860", "failed": true, "rc": 1, "start": "2016-11-21 14:22:57.625848", "stderr": "2016-11-21 14:22:58,852 INFO:dlrn-repositories:Getting https://github.com/rdo-packages/nova-distgit.git to ./data/openstack-nova_distro (rpm-master)\n2016-11-21 14:23:01,000 INFO:dlrn-repositories:Getting git://git.openstack.org/openstack/nova to ./data/openstack-nova (master)\n2016-11-21 14:23:01,319 INFO:dlrn-build:Processing openstack-nova 11d8dde452b3ce52f77a637e1d6c98080bbd7fa2\n2016-11-21 14:26:49,026 INFO:dlrn:240 packages not built correctly: not updating the consistent symlink", "stdout": "", "stdout_lines": [], "warnings": []}
19:24:37
weshayutin
commented
5 years ago
https://github.com/openstack-packages/DLRN/blame/master/dlrn/shell.py#L490-L491
This change has broken how the tripleo-gate role determines the status of the build https://github.com/redhat-openstack/ansible-role-tripleo-gate/blob/master/tasks/dlrn-build.yml#L36-L52
http://paste.openstack.org/show/589960/ select * from commits in the commits sqlite3 db returns nothing.
(dlrn-venv)[stack@rhev-i8c-03 DLRN]$ sqlite3 commits.sqlite SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables commits projects sqlite> select from commits; sqlite> select from projects; sqlite>
You can also see this error via jenkins: fatal: [rhev-i8c-03.mpc.lab.eng.bos.redhat.com]: FAILED! => {"changed": true, "cmd": "source /home/stack/dlrn-venv/bin/activate; while true; do\n dlrn --config-file projects.ini --head-only --package-name openstack-nova --local --info-repo rdoinfo --dev || /bin/true;\n STATUS=$(echo \"select status from commits where project_name == 'openstack-nova' order by id desc limit 1;\" | sqlite3 commits.sqlite);\n if [ \"$STATUS\" == \"FAILED\" ] ; then\n exit 1;\n elif [ \"$STATUS\" == \"SUCCESS\" ] ; then\n break;\n elif [ \"$STATUS\" == \"RETRY\" ] ; then\n continue;\n fi;\n exit 1;\n done;", "delta": "0:03:53.932012", "end": "2016-11-21 14:26:51.557860", "failed": true, "rc": 1, "start": "2016-11-21 14:22:57.625848", "stderr": "2016-11-21 14:22:58,852 INFO:dlrn-repositories:Getting https://github.com/rdo-packages/nova-distgit.git to ./data/openstack-nova_distro (rpm-master)\n2016-11-21 14:23:01,000 INFO:dlrn-repositories:Getting git://git.openstack.org/openstack/nova to ./data/openstack-nova (master)\n2016-11-21 14:23:01,319 INFO:dlrn-build:Processing openstack-nova 11d8dde452b3ce52f77a637e1d6c98080bbd7fa2\n2016-11-21 14:26:49,026 INFO:dlrn:240 packages not built correctly: not updating the consistent symlink", "stdout": "", "stdout_lines": [], "warnings": []} 19:24:37