9:35 a.m.
#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
--
Ticket URL: <https://fedorahosted.org/rel-eng/ticket/6009#comment:2>
Fedora Release Engineering <http://fedorahosted.org/rel-eng>
Release Engineering for the Fedora Project