Unstuck running save code now origins
The origins whose status is running (and scheduled a long time ago) may be stuck, we need to reschedule their associated task id:
11:36:59 swh-web@belvedere:5432=> select request_date, origin_url, status, loading_task_status, loading_task_id from save_origin_request where loading_task_status='running' and request_date < now() - interval '1 month';
select request_date, origin_url, status, loading_task_status, loading_task_id from save_origin_request where loading_task_status='running' and request_date < now() - interval '1 month';
+-------------------------------+--------------------------------------------------------------+----------+---------------------+-----------------+
| request_date | origin_url | status | loading_task_status | loading_task_id |
+-------------------------------+--------------------------------------------------------------+----------+---------------------+-----------------+
| 2021-03-22 07:03:38.046+00 | https://github.com/kusl/wgeteveryday | accepted | running | 378218248 |
| 2021-04-01 16:57:50.205+00 | https://scm.gforge.inria.fr/anonscm/git/simty/simty.git | accepted | running | 379069991 |
| 2021-04-20 08:52:13.105092+00 | https://github.com/coreutils/gnulib | accepted | running | 380606658 |
| 2021-04-20 11:40:21.612664+00 | https://github.com/unitystation/unitystation | accepted | running | 380617630 |
| 2021-09-26 15:25:37.040968+00 | http://svn.code.sf.net/p/sauerbraten/code | accepted | running | 400154016 |
| 2021-10-19 11:43:55.370658+00 | https://gitlab.com/inkscape/inkscape | accepted | running | 401116302 |
| 2021-07-17 22:43:29.870783+00 | https://github.com/keybase/client | accepted | running | 396435047 |
| 2021-05-15 06:09:05.96959+00 | https://git.libreoffice.org/translations/ | accepted | running | 381569600 |
| 2021-05-23 12:18:02.213604+00 | https://git.savannah.gnu.org/git/gnulib.git | accepted | running | 381570771 |
| 2021-07-26 12:59:50.038714+00 | https://svn.r-project.org/R-dev-web/trunk/ | accepted | running | 396985198 |
| 2021-07-26 12:54:25.784339+00 | svn://svn.code.sf.net/p/codeblocks/code/trunk | accepted | running | 396984987 |
| 2021-08-10 09:31:51.290321+00 | https://github.com/CocoaPods/Specs | accepted | running | 397492293 |
| 2021-08-21 08:06:47.263554+00 | https://github.com/404-not-find/client | accepted | running | 398036169 |
| 2021-10-22 13:32:29.289308+00 | http://floppsie.comp.glam.ac.uk/gm2 | accepted | running | 401265256 |
| 2021-06-24 18:56:00.441183+00 | https://anonhg.netbsd.org/pkgsrc-public/ | accepted | running | 381575556 |
| 2021-06-24 18:55:55.386673+00 | https://anonhg.netbsd.org/pkgsrc-draft/ | accepted | running | 381575557 |
| 2021-06-24 18:55:51.53746+00 | https://anonhg.netbsd.org/pkgsrc/ | accepted | running | 381575558 |
| 2021-06-24 18:55:41.589663+00 | https://anonhg.netbsd.org/src-public/ | accepted | running | 381575560 |
| 2021-06-24 18:55:35.63743+00 | https://anonhg.netbsd.org/src-draft/ | accepted | running | 381575561 |
| 2021-06-24 16:53:31.099868+00 | git://git.archlinux.org/svntogit/community.git | accepted | running | 381575242 |
| 2021-06-22 21:56:29.522544+00 | https://github.com/jlippold/tweakCompatible | accepted | running | 381575019 |
| 2021-06-29 17:08:37.262648+00 | git://git.archlinux.org/svntogit/packages.git | accepted | running | 381575775 |
| 2021-09-09 20:13:05.170087+00 | https://source.puri.sm/Librem5/linux-next.git | accepted | running | 399230899 |
| 2020-01-24 00:29:45.32+00 | https://github.com/CambridgeSemiticsLab/BH_time_collocations | accepted | running | 269843604 |
| 2021-11-10 21:02:01.294182+00 | https://git.texlive.info/texlive | accepted | running | 402275446 |
| 2021-12-10 14:02:24.992009+00 | https://github.com/godotengine/godot | accepted | running | 403530429 |
+-------------------------------+--------------------------------------------------------------+----------+---------------------+-----------------+
(26 rows)
Time: 255.180 msMigrated from T3846 (view on Phabricator)
Edited by Phabricator Migration user