#1759 koji-sweep-db using misnamed build_reservations column
Closed: Fixed by tkopecek. Opened by jforaker.

[root@koji ~]# /usr/sbin/koji-sweep-db --no-vacuum
No handlers could be found for logger "koji.db"
Traceback (most recent call last):
  File "/usr/sbin/koji-sweep-db", line 88, in <module>
    clean_reservations(cursor, options.vacuum)
  File "/usr/sbin/koji-sweep-db", line 29, in clean_reservations
    cursor.execute("DELETE " + q)
  File "/usr/lib/python2.7/site-packages/koji/db.py", line 136, in execute
    ret = self.cursor.execute(operation, parameters)
psycopg2.ProgrammingError: column "create_time" does not exist
LINE 1: DELETE  FROM build_reservations WHERE create_time < now() - ...
                                              ^

It looks like the correct column name is 'created'.


:-( It was renamed meanwhile.

Metadata Update from @tkopecek:
- Custom field Size adjusted to small
- Issue priority set to: Low (was: Normal)
- Issue set to the milestone: 1.20
- Issue tagged with: easyfix

PR #1760

Commit f15ee777 fixes this issue

Commit 6d72bba3 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/1759

Please continue any further discussion there.

Metadata
Related Pull Requests