#6009: Curious about python-sqlalchemy on epel7 --------------------+------------------------ Reporter: pingou | Owner: rel-eng@… Type: defect | Status: new Milestone: | Component: epel Keywords: | Blocked By: Blocking: | --------------------+------------------------ According to datagrepper python-sqlalchemy was branched for epel7 9 months ago:
https://apps.fedoraproject.org/datagrepper/id?id=2013-b8045ad9-1985-416a- 92ff-3c6630f17642&is_raw=true&size=extra-large
Since then, I can find ACL approved/dropped but no orphan nor retirement.
Same thing in pkgdb2's logs: https://admin.fedoraproject.org/pkgdb/admin/log/?package=python-sqlalchemy
Nothing special in git: http://pkgs.fedoraproject.org/cgit/python- sqlalchemy.git/log/?h=epel7
So, what happened with this branch? How has it end-up being blocked in koji and marked as retired in pkgdb w/o pkgdb or datagrepper knowing about it.
#6009: Curious about python-sqlalchemy on epel7 ---------------------+----------------------- Reporter: pingou | Owner: rel-eng@… Type: defect | Status: new Milestone: | Component: epel Resolution: | Keywords: Blocked By: | Blocking: ---------------------+-----------------------
Comment (by pingou):
Note: I did find that the el6 branch has been retired because the package exists in rhel6: https://fedorahosted.org/rel-eng/ticket/4815
But, I'm still curious of what happened wrt pkgdb.
#6009: Curious about python-sqlalchemy on epel7 ---------------------+----------------------- Reporter: pingou | Owner: rel-eng@… Type: defect | Status: new Milestone: | Component: epel Resolution: | Keywords: Blocked By: | Blocking: ---------------------+-----------------------
Comment (by pingou):
Some more investigation.
This is what I found in pkgdb1 {{{ pkgdb=# SELECT * FROM package WHERE name = 'python-sqlalchemy'; id | name | summary | description | reviewurl | statuscode | shouldopen | upstreamurl ------+-------------------+---------------------------------------------+---------------------------------------------------------------------------------+-----------+------------+------------+------------- 2996 | python-sqlalchemy | Modular and flexible ORM library for python | SQLAlchemy is an Object Relational Mappper (ORM) that provides a flexible, | | 3 | t | : high-level interface to SQL databases. Database and domain concepts are : decoupled, allowing both sides maximum flexibility and power. SQLAlchemy : provides a powerful mapping layer that can work as automatically or as manually : as you choose, determining relationships based on foreign keys or letting you : define the join conditions explicitly, to bridge the gap between database and : domain. (1 row)
pkgdb=# SELECT * FROM packagelisting where packageid=2996; id | packageid | collectionid | owner | qacontact | statuscode | statuschange | specfile | critpath --------+-----------+--------------+--------+-----------+------------+-------------------------------+----------+---------- 191701 | 2996 | 33 | orphan | | 20 | 2013-12-19 13:43:35.320173+00 | | f 186196 | 2996 | 31 | toshio | | 3 | 2013-08-20 21:08:26.487876+00 | | f 168038 | 2996 | 30 | toshio | | 3 | 2013-03-12 02:55:37.326894+00 | | f 150836 | 2996 | 29 | toshio | | 3 | 2012-08-07 23:43:59.390787+00 | | f 135194 | 2996 | 28 | toshio | | 3 | 2012-02-07 20:43:00.883643+00 | | f 120868 | 2996 | 27 | toshio | | 3 | 2011-07-26 08:13:27.082943+00 | | f 36982 | 2996 | 12 | toshio | | 3 | 2008-07-22 17:12:54.972471+00 | | f 35278 | 2996 | 15 | toshio | | 3 | 2008-07-22 17:12:54.972471+00 | | f 13616 | 2996 | 3 | toshio | | 3 | 2008-07-22 17:12:54.972471+00 | | f 24156 | 2996 | 14 | toshio | | 3 | 2008-07-22 17:12:54.972471+00 | | f 13615 | 2996 | 13 | toshio | | 3 | 2008-07-22 17:12:54.972471+00 | | f 78617 | 2996 | 23 | toshio | | 3 | 2010-02-16 18:23:21.198254+00 | | f 112296 | 2996 | 24 | orphan | | 20 | 2011-07-13 07:50:35.555734+00 | | f 13614 | 2996 | 8 | toshio | | 3 | 2008-07-22 17:12:54.972471+00 | | f 93793 | 2996 | 25 | toshio | | 3 | 2010-07-29 00:27:25.456345+00 | | f 46148 | 2996 | 19 | toshio | | 3 | 2008-11-07 01:48:49.679529+00 | | f 55677 | 2996 | 21 | toshio | | 3 | 2009-04-14 19:26:24.217449+00 | | f 13617 | 2996 | 2 | orphan | | 14 | 2008-09-17 00:11:22.416299+00 | | f 13619 | 2996 | 4 | orphan | | 14 | 2008-09-17 00:11:27.170511+00 | | f 13618 | 2996 | 1 | orphan | | 14 | 2008-09-17 00:11:24.673727+00 | | f 66934 | 2996 | 22 | toshio | | 3 | 2009-09-28 22:41:42.845063+00 | | f 107856 | 2996 | 26 | toshio | | 3 | 2011-02-10 18:35:20.669136+00 | | f (22 rows)
pkgdb=# SELECT * FROM statuscodetranslation WHERE statuscodeid IN (1, 3, 20, 14); statuscodeid | language | statusname | description --------------+----------+------------+------------- 1 | C | Active | 3 | C | Approved | 14 | C | Orphaned | 20 | C | Deprecated | (4 rows)
pkgdb=# SELECT * FROM collection WHERE id in (33, 24, 1, 2, 4); id | name | version | statuscode | owner | publishurltemplate | pendingurltemplate | summary | description | koji_name ----+-------------+---------+------------+----------+--------------------+--------------------+---------+-------------+-------------- 24 | Fedora EPEL | 6 | 1 | ausil | | | | | dist-6E-epel 33 | Fedora EPEL | 7 | 1 | ausil | | | | | epel7 2 | Fedora | 4 | 9 | jkeating | | | | | 1 | Fedora | 5 | 9 | jkeating | | | | | 4 | Fedora | 6 | 9 | jkeating | | | | | dist-fc6 (5 rows)
}}}
So apparently, python-sqlalchemy was already Retired in pkgdb1, however:
{{{ pkgdb=# SELECT * FROM log WHERE description LIKE 'Package python- sqlalchemy%' ORDER BY changetime DESC; id | username | changetime | description ---------+----------+----------------------------+---------------------------------------------------------------------------------------------- 1565310 | pbrady | 2012-08-08 10:08:46.123423 | Package python- sqlalchemy0.7 in Fedora 18 has been retired by pbrady 1565309 | pbrady | 2012-08-08 10:08:46.123423 | Package python- sqlalchemy0.7 in Fedora 18 was orphaned by pbrady 1565307 | pbrady | 2012-08-08 10:06:56.880354 | Package python- sqlalchemy0.7 in Fedora devel was orphaned by pbrady 1565308 | pbrady | 2012-08-08 10:06:56.880354 | Package python- sqlalchemy0.7 in Fedora devel has been retired by pbrady 1081642 | toshio | 2011-07-13 07:50:35.555734 | Package python- sqlalchemy in Fedora EPEL 6 was orphaned by toshio 1081643 | toshio | 2011-07-13 07:50:35.555734 | Package python- sqlalchemy in Fedora EPEL 6 has been retired by toshio 1080882 | limb | 2011-07-12 12:38:13.621112 | Package python- sqlalchemy in Fedora EPEL 6 is now owned by sundaram 919144 | mbacovsk | 2010-11-23 19:14:03.205684 | Package python- sqlalchemy0.5 in Fedora devel is now owned by mbacovsk 919143 | toshio | 2010-11-23 19:11:00.446143 | Package python- sqlalchemy0.5 in Fedora EPEL 6 has been retired by toshio 919142 | toshio | 2010-11-23 19:11:00.446143 | Package python- sqlalchemy0.5 in Fedora EPEL 6 was orphaned by toshio 919139 | toshio | 2010-11-23 19:00:52.64848 | Package python- sqlalchemy0.5 in Fedora devel has been unretired by toshio and is now orphan. 209837 | shahms | 2008-09-17 00:11:27.205743 | Package python- sqlalchemy in Fedora 6 was orphaned by shahms 209836 | shahms | 2008-09-17 00:11:24.693886 | Package python- sqlalchemy in Fedora 5 was orphaned by shahms 209835 | shahms | 2008-09-17 00:11:22.452323 | Package python- sqlalchemy in Fedora 4 was orphaned by shahms (14 rows) }}}
We can see clearly the el6 branch being retired, but nothing about the epel7 one.
And finally: {{{ pkgdb=# SELECT * FROM log WHERE description LIKE '%sqlalchemy%' ORDER BY changetime DESC; id | username | changetime | description
---------+--------------+----------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- 2018907 | ausil | 2013-12-19 13:55:24.191012 | ausil added a Branch(33, u'epel7', u'.el7', None, u'Fedora EPEL', u'7', 1, u'ausil', publishurltemplate=None, pendingurltemplate=None, summary=None, description=None, gitbranchname=u'epel7') to python-zope-sqlalchemy }}}
The 33 is the collection: epel7, the 1 is the status: Active
In conclusion:
* python-sqlalchemy epel7 branch was created as Active * At some point in time, the branch was retired (I don't know how) * The retired status was imported from pkgdb1 to pkgdb2 when we switched * The branch was retired in pkgdb, but not blocked in koji * Till blocked the package in koji last friday (Sept 26, 2014) by running a script asking for all retired packages in pkgdb and blocking them in koji
#6009: Curious about python-sqlalchemy on epel7 ---------------------+----------------------- Reporter: pingou | Owner: rel-eng@… Type: defect | Status: closed Milestone: | Component: epel Resolution: fixed | Keywords: Blocked By: | Blocking: ---------------------+----------------------- Changes (by kevin):
* resolution: => fixed * status: new => closed
Comment:
I'm not sure there's much more we can do here... it's been unblocked/brought back. We may never know what happened to retire it. ;(
rel-eng@lists.fedoraproject.org