koji

#2423 1.22.0 sql update leaves some builds unreachable
Closed: Fixed by tkopecek. Opened by kevin.

Closed: Fixed
Reopen Issue

After running the 1.21.0-1.22.0 upgrade sql, we have some builds we can't see from the web interface anymore at least:

https://koji.fedoraproject.org/koji/buildinfo?buildID=1573795

Looking at:

https://koji.fedoraproject.org/koji/packageinfo?packageID=4013

you can see some of them have finished at times like "2020-07-31 22:53:47+00:00" but some have "2020-07-31 19:23:55"

The ones with +00.00 don't load correctly.

I think those are container builds. Perhaps something additional is needed to convert everything?

Metadata Update from @tkopecek:
- Custom field Size adjusted to None
- Issue set to the milestone: 1.22.1
- Issue tagged with: bug

PR #2424

I can replicate this running a local web instance. The full traceback is:

Traceback (most recent call last):
  File "/home/mikem/Devel/koji/koji/www/kojiweb/wsgi_publisher.py", line 371, in handle_request
    result = func(environ, **data)
  File "/home/mikem/Devel/koji/koji/www/kojiweb/index.py", line 1295, in buildinfo
    return _genHTML(environ, 'buildinfo.chtml')
  File "/home/mikem/Devel/koji/koji/www/lib/kojiweb/util.py", line 158, in _genHTML
    return tmpl_inst.respond()
  File "buildinfo_chtml.py", line 226, in respond
  File "/home/mikem/Devel/koji/koji/koji/__init__.py", line 3282, in formatTimeLong
    localtime = time.mktime(time.strptime(formatTime(value), '%Y-%m-%d %H:%M:%S'))
  File "/usr/lib64/python3.7/_strptime.py", line 571, in _strptime_time
    tt = _strptime(data_string, format)[0]
  File "/usr/lib64/python3.7/_strptime.py", line 362, in _strptime
    data_string[found.end():])
ValueError: unconverted data remains: +00:00

Also, the cli can manifest the same problem:

[mikem@localhost koji]$ koji buildinfo transmission-master-3220200731182523.1
2020-08-11 10:06:20,528 [DEBUG] koji: Opening new requests session
BUILD: transmission-master-3220200731182523.1 [1573795]
State: COMPLETE
Built by: kalev
Source: https://src.fedoraproject.org/flatpaks/transmission.git#0b732d2448f595f1d49ba3ff18e9ca5fa66bf966
Volume: DEFAULT
Task: none
Traceback (most recent call last):
  File "/home/mikem/Devel/koji/koji/cli/koji", line 337, in <module>
    rv = locals()[command].__call__(options, session, args)
  File "/home/mikem/Devel/koji/koji/cli/koji_cli/commands.py", line 3228, in anon_handle_buildinfo
    print("Finished: %s" % koji.formatTimeLong(info['completion_time']))
  File "/home/mikem/Devel/koji/koji/koji/__init__.py", line 3282, in formatTimeLong
    localtime = time.mktime(time.strptime(formatTime(value), '%Y-%m-%d %H:%M:%S'))
  File "/usr/lib64/python3.7/_strptime.py", line 571, in _strptime_time
    tt = _strptime(data_string, format)[0]
  File "/usr/lib64/python3.7/_strptime.py", line 362, in _strptime
    data_string[found.end():])
ValueError: unconverted data remains: +00:00

Metadata Update from @jcupova:
- Issue tagged with: testing-ready

Metadata Update from @jcupova:
- Issue tagged with: testing-done

Metadata Update from @jcupova:
- Issue untagged with: testing-done

Commit b104e7a1 fixes this issue

Commit b0efed5e fixes this issue

Metadata Update from @jcupova:
- Issue tagged with: testing-done

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/2423

Please continue any further discussion there.
Metadata
None

bug testing-done testing-ready

None
None
Low
None
Related Pull Requests
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.