Koji Community Meeting Notes - Mar 7
by Yuli Wang
*Meeting Purpose: * Improve the communication with upstream(community)
*Attendees: *ngomp, dgregor, sly, jdisnard, tkopecek, yzhu, Jana, Egor,
Brendan,mikem, yulwang
*Meeting Summary:*3 koji stakeholders besides Brew team joined our 2nd koji
community meeting. we mainly talked last meeting actions and Koji recent
update and get the feedback from community.
detail please check our meeting docs:
https://public.etherpad-mozilla.org/p/KojiMarch2018
*Meeting Notes:*
1.Review last action items
- "office hours" proposal - Every Tue/Thurs 10:00 - 11:00AM US/ET
(welcome your feedback in the meeting notes)
- koji-devel could be there
- which channel? #koji ? #fedora-releng (larger)
- Let's use #koji
- won't be active all the time, but when we have koji conversations
let's have them in #koji
- AI: Send an announcement to koji-devel@
- Research on how do external users use the Message bus plugins:
- https://pagure.io/koji/issue/736
- Question from mikem: who might use it?
- AI: mark as deprecated in 1.16 and send out an announcement to speak
up if it's still needed(release note+ separate notification)
2.Koji update:
- Koji 1.15 released on Dec 2017
https://docs.pagure.org/koji/release_notes_1.15/
- Fedora in process of upgrading to 1.15
- Koji 1.16 planning: Mar 28, 2018
https://pagure.io/koji/roadmap?status=all&milestone=1.16
- Koji 1.17 planning
3. Community feedback / input
- Mageia
- bootstrap chroot is very important to Mageia. One challenge for koji
is that the repo used to bootstrap is likely different than the repo for
building
- Maybe use the same repos for both? We already do this for SRPM -> RPM
build chroots. Mock's current bootstrap feature works that way.
- issues around auto-generating the SRPM changelog. Questions around
how to integrate this prebuild script
- https://gitlab.com/mdklinux/mgapkg-koji
- Variety of issues related to installing koji. messagebus plugin isn't
compiling. Some other things... (Neal, can you fill in?)
- Opportunity to use Mageia as a way of making installation easier, or
at least documenting it better
- Let's move this to office hours.
- Fedora Releng - Sly
- Schedule: https://fedoraproject.org/wiki/Releases/28/Schedule
- Beta Freeze was March 6
- In the middle of Fedora 28
- Currently no issues with koji
- Have not started Fedora 29 planning yet
Thanks,
Yuli
5 years, 2 months
Koji 'Office Hour' Announcement
by Yuli Wang
Dear, all
In the 1st Koji Community Meeting, we raised and agreed Koji '*office hour*'
to improve the communication on Koji issues.
We agreed to make the 'office hours' happen on *every Tue/Thurs 10:00 -
11:00AM US/ET*
- Attendees: who is in koji-devel@
- which channel? #koji
- Effective Date: Mar 13, 2018
- Note: This time may not be good for APAC teammates, feel free to let
us know if you are from APAC and interested in Koji discussion.
Welcome your feedback.
---
Thanks,
Yuli
5 years, 3 months
Build never finishes
by Viacheslav Dubrovskyi
Hi
I made new setup koji-1.15.0-6.el7
Scratch build working fine. But real build not.
$ koji build maintenance-2.6 gd-last-2.1.1-1.el7.centos.src.rpm
Uploading srpm: gd-last-2.1.1-1.el7.centos.src.rpm
[====================================] 100% 00:00:00 1.96 MiB 34.95
MiB/sec
Created task: 48
Task info: https://koji.oro.cloud/koji/taskinfo?taskID=48
Watching tasks (this may be safely interrupted)...
48 build (maintenance-2.6, gd-last-2.1.1-1.el7.centos.src.rpm): free
48 build (maintenance-2.6, gd-last-2.1.1-1.el7.centos.src.rpm): free ->
open (koji.oro.cloud)
49 buildArch (gd-last-2.1.1-1.el7.centos.src.rpm, x86_64): free
49 buildArch (gd-last-2.1.1-1.el7.centos.src.rpm, x86_64): free ->
open (koji.oro.cloud)
49 buildArch (gd-last-2.1.1-1.el7.centos.src.rpm, x86_64): open
(koji.oro.cloud) -> closed
0 free 1 open 1 done 0 failed
48 build (maintenance-2.6, gd-last-2.1.1-1.el7.centos.src.rpm): open
(koji.oro.cloud) -> FAILED: Fault: <Fault 1: 'Traceback (most recent
call last):\n File "/usr/lib/python2.7/site-packages/koji/db.py", line
135, in execute\n ret = self.cursor.execute(operation,
parameters)\nKeyError: \'users_usertype\'\nLocals by frame, innermost
last\nFrame application in /usr/share/koji-hub/kojixmlrpc.py at line
725\n start_response = <built-in method start_response of
mod_wsgi.Adapter object at 0x55a48d3c4be8>\n h =
<_mod_wsgi_df1c13776110deb1e020020636703560.ModXMLRPCRequestHandler
object at 0x55a48d3c5e50>\n memory_usage_at_start =
19708\n environ = {\'mod_wsgi.listener_port\': \'443\',
\'CONTEXT_DOCUMENT_ROOT\': \'/usr/share/koji-hub/kojixmlrpc.py\',
\'SERVER_SOFTWARE\': \'Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips
mod_auth_gssapi/1.5.1 mod_wsgi/3.4 Python/2.7.5\', \'SCRIPT_NAME\':
\'/kojihub\', \'mod_wsgi.enable_sendfile\': \'0\',
\'mod_wsgi.handler_script\': \'\', \'SERVER_SIGNATURE\': \'\',
\'REQUEST_METHOD\': \'POST\', \'PATH_INFO\': \'\', \'SERVER_PROTOCOL\':
\'HTTP/1.1\', \'QUERY_STRING\':
\'session-id=138&session-key=5-AkzpjdJPCTuAL6S7Wnd&callnum=14\',
\'SSL_TLS_SNI\': \'koji.oro.cloud\', \'CONTENT_LENGTH\': \'199\',
\'HTTP_USER_AGENT\': \'koji/1\', \'HTTP_CONNECTION\': \'keep-alive\',
\'SERVER_NAME\': \'koji.oro.cloud\', \'REMOTE_ADDR\': \'35.192.190.50\',
\'mod_wsgi.queue_start\': \'1519916764342413\',
\'mod_wsgi.request_handler\': \'wsgi-script\', \'wsgi.url_scheme\':
\'https\', \'mod_wsgi.callable_object\': \'application\',
\'SERVER_PORT\': \'443\', \'wsgi.multiprocess\': True,
\'mod_wsgi.input_chunked\': \'0\', \'SERVER_ADDR\': \'10.100.4.3\',
\'DOCUMENT_ROOT\': \'/var/www/html\', \'mod_wsgi.process_group\': \'\',
\'SCRIPT_FILENAME\': \'/usr/share/koji-hub/kojixmlrpc.py\',
\'SERVER_ADMIN\': \'root@localhost\', \'wsgi.input\': <mod_wsgi.Input
object at 0x7fab36baa5b0>, \'HTTP_HOST\': \'koji.oro.cloud\',
\'CONTEXT_PREFIX\': \'/kojihub\', \'wsgi.multithread\': False,
\'REQUEST_URI\':
\'/kojihub?session-id=138&session-key=5-AkzpjdJPCTuAS7Wnd&callnum=14\',
\'HTTP_ACCEPT\': \'*/*\', \'wsgi.version\': (1, 0),
\'GATEWAY_INTERFACE\': \'CGI/1.1\', \'wsgi.run_once\': False,
\'wsgi.errors\': <mod_wsgi.Log object at 0x55a48d3ce170>,
\'REMOTE_PORT\': \'50954\', \'mod_wsgi.listener_host\': \'\',
\'REQUEST_SCHEME\': \'https\', \'mod_wsgi.version\': (3, 4),
\'CONTENT_TYPE\': \'text/xml\', \'mod_wsgi.application_group\': \'\',
\'mod_wsgi.script_reloading\': \'1\', \'wsgi.file_wrapper\': <built-in
method file_wrapper of mod_wsgi.Adapter object at 0x55a48d3c4be8>,
\'HTTP_ACCEPT_ENCODING\': \'gzip, deflate\', \'UNIQUE_ID\':
\'WpgW3GEYNMfxj1NderqpEAAAAAQ\'}\n start =
1519916764.34\nFrame _wrap_handler in /usr/share/koji-hub/kojixmlrpc.py
at line 254\n e =
\'users_usertype\'\n self =
<_mod_wsgi_df1c13776110deb1e020020636703560.ModXMLRPCRequestHandler
object at 0x55a48d3c5e50>\n e_class = <type
\'exceptions.KeyError\'>\n faultCode = 1\n
handler = <bound method ModXMLRPCRequestHandler.handle_rpc of
<_mod_wsgi_df1c13776110deb1e020020636703560.ModXMLRPCRequestHandler
object at 0x55a48d3c5e50>>\n environ =
{\'mod_wsgi.listener_port\': \'443\', \'CONTEXT_DOCUMENT_ROOT\':
\'/usr/share/koji-hub/kojixmlrpc.py\', \'SERVER_SOFTWARE\':
\'Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_auth_gssapi/1.5.1
mod_wsgi/3.4 Python/2.7.5\', \'SCRIPT_NAME\': \'/kojihub\',
\'mod_wsgi.enable_sendfile\': \'0\', \'mod_wsgi.handler_script\': \'\',
\'SERVER_SIGNATURE\': \'\', \'REQUEST_METHOD\': \'POST\', \'PATH_INFO\':
\'\', \'SERVER_PROTOCOL\': \'HTTP/1.1\', \'QUERY_STRING\':
\'session-id=138&session-key=5-AkzpjdJPCTuAL6S7Wnd&callnum=14\',
\'SSL_TLS_SNI\': \'koji.oro.cloud\', \'CONTENT_LENGTH\': \'199\',
\'HTTP_USER_AGENT\': \'koji/1\', \'HTTP_CONNECTION\': \'keep-alive\',
\'SERVER_NAME\': \'koji.oro.cloud\', \'REMOTE_ADDR\': \'35.192.190.50\',
\'mod_wsgi.queue_start\': \'1519916764342413\',
\'mod_wsgi.request_handler\': \'wsgi-script\', \'wsgi.url_scheme\':
\'https\', \'mod_wsgi.callable_object\': \'application\',
\'SERVER_PORT\': \'443\', \'wsgi.multiprocess\': True,
\'mod_wsgi.input_chunked\': \'0\', \'SERVER_ADDR\': \'10.100.4.3\',
\'DOCUMENT_ROOT\': \'/var/www/html\', \'mod_wsgi.process_group\': \'\',
\'SCRIPT_FILENAME\': \'/usr/share/koji-hub/kojixmlrpc.py\',
\'SERVER_ADMIN\': \'root@localhost\', \'wsgi.input\': <mod_wsgi.Input
object at 0x7fab36baa5b0>, \'HTTP_HOST\': \'koji.oro.cloud\',
\'CONTEXT_PREFIX\': \'/kojihub\', \'wsgi.multithread\': False,
\'REQUEST_URI\':
\'/kojihub?session-id=138&session-key=5-AkzpjdJPCTuAL6S7Wnd&callnum=14\',
\'HTTP_ACCEPT\': \'*/*\', \'wsgi.version\': (1, 0),
\'GATEWAY_INTERFACE\': \'CGI/1.1\', \'wsgi.run_once\': False,
\'wsgi.errors\': <mod_wsgi.Log object at 0x55a48d3ce170>,
\'REMOTE_PORT\': \'50954\', \'mod_wsgi.listener_host\': \'\',
\'REQUEST_SCHEME\': \'https\', \'mod_wsgi.version\': (3, 4),
\'CONTENT_TYPE\': \'text/xml\', \'mod_wsgi.application_group\': \'\',
\'mod_wsgi.script_reloading\': \'1\', \'wsgi.file_wrapper\': <built-in
method file_wrapper of mod_wsgi.Adapter object at 0x55a48d3c4be8>,
\'HTTP_ACCEPT_ENCODING\': \'gzip, deflate\', \'UNIQUE_ID\':
\'WpgW3GEYNMfxj1NderqpEAAAAAQ\'}\n tb_str = Traceback
(most recent call last):\n File "/usr/share/koji-hub/kojixmlrpc.py",
line 228, in _wrap_handler\n response = handler(environ)\n File
"/usr/share/koji-hub/kojixmlrpc.py", line 271, in handle_rpc\n return
self._dispatch(method, params)\n File
"/usr/share/koji-hub/kojixmlrpc.py", line 308, in _dispatch\n ret =
koji.util.call_with_argcheck(func, params, opts)\n File
"/usr/lib/python2.7/site-packages/koji/util.py", line 209, in
call_with_argcheck\n return func(*args, **kwargs)\n File
"/usr/share/koji-hub/kojihub.py", line 12232, in failBuild\n
build_notification(task_id, build_id)\n File
"/usr/share/koji-hub/kojihub.py", line 7390, in build_notification\n
recipients = get_notification_recipients(build, dest_tag,
build[\'state\'])\n File "/usr/share/koji-hub/kojihub.py", line 7324,
in get_notification_recipients\n emails = [result[0] for result in
query.execute()]\n File "/usr/share/koji-hub/kojihub.py", line 7889, in
execute\n return _fetchMulti(query, self.values)\n File
"/usr/share/koji-hub/kojihub.py", line 4412, in _fetchMulti\n
c.execute(query, values)\n File
"/usr/lib/python2.7/site-packages/koji/db.py", line 135, in execute\n
ret = self.cursor.execute(operation, parameters)\nKeyError:
\'users_usertype\'\n\n tb_type = extended\nFrame
handle_rpc in /usr/share/koji-hub/kojixmlrpc.py at line
271\n environ = {\'mod_wsgi.listener_port\': \'443\',
\'CONTEXT_DOCUMENT_ROOT\': \'/usr/share/koji-hub/kojixmlrpc.py\',
\'SERVER_SOFTWARE\': \'Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips
mod_auth_gssapi/1.5.1 mod_wsgi/3.4 Python/2.7.5\', \'SCRIPT_NAME\':
\'/kojihub\', \'mod_wsgi.enable_sendfile\': \'0\',
\'mod_wsgi.handler_script\': \'\', \'SERVER_SIGNATURE\': \'\',
\'REQUEST_METHOD\': \'POST\', \'PATH_INFO\': \'\', \'SERVER_PROTOCOL\':
\'HTTP/1.1\', \'QUERY_STRING\':
\'session-id=138&session-key=5-AkzpjdJPCTuAL6S7Wnd&callnum=14\',
\'SSL_TLS_SNI\': \'koji.oro.cloud\', \'CONTENT_LENGTH\': \'199\',
\'HTTP_USER_AGENT\': \'koji/1\', \'HTTP_CONNECTION\': \'keep-alive\',
\'SERVER_NAME\': \'koji.oro.cloud\', \'REMOTE_ADDR\': \'35.192.190.50\',
\'mod_wsgi.queue_start\': \'1519916764342413\',
\'mod_wsgi.request_handler\': \'wsgi-script\', \'wsgi.url_scheme\':
\'https\', \'mod_wsgi.callable_object\': \'application\',
\'SERVER_PORT\': \'443\', \'wsgi.multiprocess\': True,
\'mod_wsgi.input_chunked\': \'0\', \'SERVER_ADDR\': \'10.100.4.3\',
\'DOCUMENT_ROOT\': \'/var/www/html\', \'mod_wsgi.process_group\': \'\',
\'SCRIPT_FILENAME\': \'/usr/share/koji-hub/kojixmlrpc.py\',
\'SERVER_ADMIN\': \'root@localhost\', \'wsgi.input\': <mod_wsgi.Input
object at 0x7fab36baa5b0>, \'HTTP_HOST\': \'koji.oro.cloud\',
\'CONTEXT_PREFIX\': \'/kojihub\', \'wsgi.multithread\': False,
\'REQUEST_URI\':
\'/kojihub?session-id=138&session-key=5-AkzpjdJPCTuAL6S7Wnd&callnum=14\',
\'HTTP_ACCEPT\': \'*/*\', \'wsgi.version\': (1, 0),
\'GATEWAY_INTERFACE\': \'CGI/1.1\', \'wsgi.run_once\': False,
\'wsgi.errors\': <mod_wsgi.Log object at 0x55a48d3ce170>,
\'REMOTE_PORT\': \'50954\', \'mod_wsgi.listener_host\': \'\',
\'REQUEST_SCHEME\': \'https\', \'mod_wsgi.version\': (3, 4),
\'CONTENT_TYPE\': \'text/xml\', \'mod_wsgi.application_group\': \'\',
\'mod_wsgi.script_reloading\': \'1\', \'wsgi.file_wrapper\': <built-in
method file_wrapper of mod_wsgi.Adapter object at 0x55a48d3c4be8>,
\'HTTP_ACCEPT_ENCODING\': \'gzip, deflate\', \'UNIQUE_ID\':
\'WpgW3GEYNMfxj1NderqpEAAAAAQ\'}\n self =
<_mod_wsgi_df1c13776110deb1e020020636703560.ModXMLRPCRequestHandler
object at 0x55a48d3c5e50>\n params = <ERROR WHILE
PRINTING VALUE>\n method = host.failBuild\nFrame
_dispatch in /usr/share/koji-hub/kojixmlrpc.py at line
308\n self =
<_mod_wsgi_df1c13776110deb1e020020636703560.ModXMLRPCRequestHandler
object at 0x55a48d3c5e50>\n start =
1519916764.35\n params = <ERROR WHILE PRINTING
VALUE>\n func = <bound method HostExports.failBuild of
<kojihub.HostExports object at 0x55a48d4796d0>>\n method
= host.failBuild\n opts = {}\nFrame call_with_argcheck
in /usr/lib/python2.7/site-packages/koji/util.py at line
216\n args = <ERROR WHILE PRINTING
VALUE>\n func = <bound method HostExports.failBuild of
<kojihub.HostExports object at 0x55a48d4796d0>>\n kwargs
= {}\nFrame failBuild in /usr/share/koji-hub/kojihub.py at line
12232\n build_id = 9\n task =
<kojihub.Task object at 0x55a48d3c5d10>\n task_id =
48\n st_failed = 3\n self =
<kojihub.HostExports object at 0x55a48d4796d0>\n update =
UPDATE build\n SET state = %(st_failed)i,\n
completion_time = NOW()\n WHERE id =
%(build_id)i\n host = <kojihub.Host object at
0x55a48d3c5e10>\n result = {\'completion_time\': None,
\'state\': 0}\n query = SELECT state,
completion_time\n FROM build\n WHERE id =
%(build_id)i\n FOR UPDATE\n buildinfo =
{\'package_name\': \'gd-last\', \'extra\': None, \'creation_time\':
datetime.datetime(2018, 3, 1, 15, 3, 1, 912663), \'completion_time\':
None, \'package_id\': 1, \'id\': 9, \'build_id\': 9, \'epoch\': None,
\'source\': None, \'state\': 0, \'version\': \'2.1.1\',
\'completion_ts\': None, \'owner_id\': 4, \'owner_name\':
\'vdubrovskyi\', \'nvr\': \'gd-last-2.1.1-1.el7.centos\',
\'start_time\': datetime.datetime(2018, 3, 1, 15, 3, 1, 912663),
\'creation_event_id\': 95, \'start_ts\': 1519916581.91266,
\'volume_id\': 0, \'creation_ts\': 1519916581.91266, \'name\':
\'gd-last\', \'task_id\': 48, \'volume_name\': \'DEFAULT\', \'release\':
\'1.el7.centos\'}\nFrame build_notification in
/usr/share/koji-hub/kojihub.py at line 7390\n build_id =
9\n dest_tag = 1\n task_id =
48\n web_url =
http://koji.oro.cloud/koji\n build = {\'package_name\':
\'gd-last\', \'extra\': None, \'creation_time\': datetime.datetime(2018,
3, 1, 15, 3, 1, 912663), \'completion_time\': datetime.datetime(2018, 3,
1, 15, 6, 4, 347763), \'package_id\': 1, \'id\': 9, \'build_id\': 9,
\'epoch\': None, \'source\': None, \'state\': 3, \'version\': \'2.1.1\',
\'completion_ts\': 1519916764.34776, \'owner_id\': 4, \'owner_name\':
\'vdubrovskyi\', \'nvr\': \'gd-last-2.1.1-1.el7.centos\',
\'start_time\': datetime.datetime(2018, 3, 1, 15, 3, 1, 912663),
\'creation_event_id\': 95, \'start_ts\': 1519916581.91266,
\'volume_id\': 0, \'creation_ts\': 1519916581.91266, \'name\':
\'gd-last\', \'task_id\': 48, \'volume_name\': \'DEFAULT\', \'release\':
\'1.el7.centos\'}\n target = {\'name\':
\'maintenance-2.6\', \'build_tag\': 2, \'build_tag_name\':
\'maintenance-2.6-build\', \'dest_tag_name\': \'maintenance-2.6\',
\'id\': 1, \'dest_tag\': 1}\nFrame get_notification_recipients in
/usr/share/koji-hub/kojihub.py at line 7324\n users_usertypes =
[0, 2]\n state = 3\n tag_id =
1\n users_status = 0\n package_id =
1\n build = {\'package_name\': \'gd-last\', \'extra\':
None, \'creation_time\': datetime.datetime(2018, 3, 1, 15, 3, 1,
912663), \'completion_time\': datetime.datetime(2018, 3, 1, 15, 6, 4,
347763), \'package_id\': 1, \'id\': 9, \'build_id\': 9, \'epoch\': None,
\'source\': None, \'state\': 3, \'version\': \'2.1.1\',
\'completion_ts\': 1519916764.34776, \'owner_id\': 4, \'owner_name\':
\'vdubrovskyi\', \'nvr\': \'gd-last-2.1.1-1.el7.centos\',
\'start_time\': datetime.datetime(2018, 3, 1, 15, 3, 1, 912663),
\'creation_event_id\': 95, \'start_ts\': 1519916581.91266,
\'volume_id\': 0, \'creation_ts\': 1519916581.91266, \'name\':
\'gd-last\', \'task_id\': 48, \'volume_name\': \'DEFAULT\', \'release\':
\'1.el7.centos\'}\n joins = [\'JOIN users ON
build_notifications.user_id = users.id\']\n query =
\nSELECT email\n FROM build_notifications\n JOIN users ON
build_notifications.user_id = users.id\n WHERE (status =
%(users_status)i)\n AND (usertype IN %(users_usertype)s)\n AND
(package_id = %(package_id)i OR package_id IS NULL)\n AND (tag_id =
%(tag_id)i OR tag_id IS NULL)\n AND (success_only = FALSE)\n \n\n
\n\n clauses = [\'status = %(users_status)i\', \'usertype
IN %(users_usertype)s\', \'package_id = %(package_id)i OR package_id IS
NULL\', \'tag_id = %(tag_id)i OR tag_id IS NULL\', \'success_only =
FALSE\']\nFrame execute in /usr/share/koji-hub/kojihub.py at line
7889\n query = \nSELECT email\n FROM
build_notifications\n JOIN users ON build_notifications.user_id =
users.id\n WHERE (status = %(users_status)i)\n AND (usertype IN
%(users_usertype)s)\n AND (package_id = %(package_id)i OR package_id
IS NULL)\n AND (tag_id = %(tag_id)i OR tag_id IS NULL)\n AND
(success_only = FALSE)\n \n\n \n\n self = \nSELECT
email\n FROM build_notifications\n JOIN users ON
build_notifications.user_id = users.id\n WHERE (status =
%(users_status)i)\n AND (usertype IN %(users_usertype)s)\n AND
(package_id = %(package_id)i OR package_id IS NULL)\n AND (tag_id =
%(tag_id)i OR tag_id IS NULL)\n AND (success_only = FALSE)\n \n\n
\n\nFrame _fetchMulti in /usr/share/koji-hub/kojihub.py at line
4412\n query = \nSELECT email\n FROM
build_notifications\n JOIN users ON build_notifications.user_id =
users.id\n WHERE (status = %(users_status)i)\n AND (usertype IN
%(users_usertype)s)\n AND (package_id = %(package_id)i OR package_id
IS NULL)\n AND (tag_id = %(tag_id)i OR tag_id IS NULL)\n AND
(success_only = FALSE)\n \n\n \n\n c = <cursor
object at 0x55a48d4d6bf0; closed: 0>\n values =
{\'users_usertypes\': [0, 2], \'state\': 3, \'tag_id\': 1,
\'users_status\': 0, \'package_id\': 1, \'build\': {\'package_name\':
\'gd-last\', \'extra\': None, \'creation_time\': datetime.datetime(2018,
3, 1, 15, 3, 1, 912663), \'completion_time\': datetime.datetime(2018, 3,
1, 15, 6, 4, 347763), \'package_id\': 1, \'id\': 9, \'build_id\': 9,
\'epoch\': None, \'source\': None, \'state\': 3, \'version\': \'2.1.1\',
\'completion_ts\': 1519916764.34776, \'owner_id\': 4, \'owner_name\':
\'vdubrovskyi\', \'nvr\': \'gd-last-2.1.1-1.el7.centos\',
\'start_time\': datetime.datetime(2018, 3, 1, 15, 3, 1, 912663),
\'creation_event_id\': 95, \'start_ts\': 1519916581.91266,
\'volume_id\': 0, \'creation_ts\': 1519916581.91266, \'name\':
\'gd-last\', \'task_id\': 48, \'volume_name\': \'DEFAULT\', \'release\':
\'1.el7.centos\'}, \'joins\': [\'JOIN users ON
build_notifications.user_id = users.id\'], \'query\': <QueryProcessor:
columns=(\'email\',), aliases=None, tables=[\'build_notifications\'],
joins=[\'JOIN users ON build_notifications.user_id = users.id\'],
clauses=[\'status = %(users_status)i\', \'usertype IN
%(users_usertype)s\', \'package_id = %(package_id)i OR package_id IS
NULL\', \'tag_id = %(tag_id)i OR tag_id IS NULL\', \'success_only =
FALSE\'], values={...}, opts={\'asList\': True}>, \'clauses\': [\'status
= %(users_status)i\', \'usertype IN %(users_usertype)s\', \'package_id =
%(package_id)i OR package_id IS NULL\', \'tag_id = %(tag_id)i OR tag_id
IS NULL\', \'success_only = FALSE\']}\nFrame execute in
/usr/lib/python2.7/site-packages/koji/db.py at line
138\n debug = True\n start =
1519916764.36\n operation = \nSELECT email\n FROM
build_notifications\n JOIN users ON build_notifications.user_id =
users.id\n WHERE (status = %(users_status)s)\n AND (usertype IN
%(users_usertype)s)\n AND (package_id = %(package_id)s OR package_id
IS NULL)\n AND (tag_id = %(tag_id)s OR tag_id IS NULL)\n AND
(success_only = FALSE)\n \n\n \n\n self = <cursor
object at 0x55a48d4d6bf0; closed: 0>\n parameters =
{\'users_usertypes\': [0, 2], \'state\': 3, \'tag_id\': 1,
\'users_status\': 0, \'package_id\': 1, \'build\': {\'package_name\':
\'gd-last\', \'extra\': None, \'creation_time\': datetime.datetime(2018,
3, 1, 15, 3, 1, 912663), \'completion_time\': datetime.datetime(2018, 3,
1, 15, 6, 4, 347763), \'package_id\': 1, \'id\': 9, \'build_id\': 9,
\'epoch\': None, \'source\': None, \'state\': 3, \'version\': \'2.1.1\',
\'completion_ts\': 1519916764.34776, \'owner_id\': 4, \'owner_name\':
\'vdubrovskyi\', \'nvr\': \'gd-last-2.1.1-1.el7.centos\',
\'start_time\': datetime.datetime(2018, 3, 1, 15, 3, 1, 912663),
\'creation_event_id\': 95, \'start_ts\': 1519916581.91266,
\'volume_id\': 0, \'creation_ts\': 1519916581.91266, \'name\':
\'gd-last\', \'task_id\': 48, \'volume_name\': \'DEFAULT\', \'release\':
\'1.el7.centos\'}, \'joins\': [\'JOIN users ON
build_notifications.user_id = users.id\'], \'query\': <QueryProcessor:
columns=(\'email\',), aliases=None, tables=[\'build_notifications\'],
joins=[\'JOIN users ON build_notifications.user_id = users.id\'],
clauses=[\'status = %(users_status)i\', \'usertype IN
%(users_usertype)s\', \'package_id = %(package_id)i OR package_id IS
NULL\', \'tag_id = %(tag_id)i OR tag_id IS NULL\', \'success_only =
FALSE\'], values={...}, opts={\'asList\': True}>, \'clauses\': [\'status
= %(users_status)i\', \'usertype IN %(users_usertype)s\', \'package_id =
%(package_id)i OR package_id IS NULL\', \'tag_id = %(tag_id)i OR tag_id
IS NULL\', \'success_only = FALSE\']}\n'>
0 free 0 open 1 done 1 failed
48 build (maintenance-2.6, gd-last-2.1.1-1.el7.centos.src.rpm) failed
And then necessary remove build manually from DB directly, because it
never finish.
Help me please.
Thank you.
--
WBR,
Viacheslav Dubrovskyi
5 years, 3 months