cannot create repo; but can create repo group

Thu Nov 21 01:08:53 UTC 2024

Ed Wong wrote:
> As an addendum, I found the only mention of "kallitheavhost"
> and that was with my celery line in the configuration.
> 
> celery.broker_url = redis://<usr>:<pwd>@<host>:<ip>/kallitheavhost
> 
> I'm wondering if I actually got this url string correct.
> 

Sorry for the noise,  looks like it's a PEBCAK again. ;/

The redis url is actually:

redis://<host>:<port>/0

But even after reading the celery doc from
https://docs.celeryq.dev/en/stable/getting-started/backends-and-brokers/redis.html,
I'm unsure if this is even right as when I set that,
I get a 'better' response:

2024-11-21 09:13:48.762 INFO  [sqlalchemy.engine.base.Engine] (9, 2)
2024-11-21 09:13:48.762 DEBUG [sqlalchemy.engine.base.Engine] Col
('user_followings_user_following_id', 'user_followings_user_id',
'user_followings_follows_repository_id',
'user_followings_follows_user_id', 'user_followings_follows_from')
2024-11-21 09:13:48.762 DEBUG [sqlalchemy.engine.base.Engine] Row (8, 2,
9, None, '2024-11-21 09:13:48.275526')
2024-11-21 09:13:48.763 DEBUG [kallithea.lib.auth] Checking access for
user <AuthUser 2: 'ewong'> @ SummaryController:index
2024-11-21 09:13:48.763 INFO  [kallithea.lib.auth] user <AuthUser 2:
'ewong'> authenticated with regular auth @ SummaryController:index
2024-11-21 09:13:48.763 DEBUG [kallithea.lib.auth] checking
HasRepoPermissionLevelDecorator permissions (['read'],) for
<kallithea.controllers.summary.SummaryController object at 0xb11c48c8>
<AuthUser 2: 'ewong'>
2024-11-21 09:13:48.763 DEBUG [kallithea.lib.auth] Getting repository
permissions for <AuthUser 2: 'ewong'>
2024-11-21 09:13:48.767 INFO  [sqlalchemy.engine.base.Engine] SELECT
repo_to_perm.repo_to_perm_id AS repo_to_perm_repo_to_perm_id,
repo_to_perm.user_id AS repo_to_perm_user_id, repo_to_perm.permission_id
AS repo_to_perm_permission_id, repo_to_perm.repository_id AS
repo_to_perm_repository_id, repositories_1.user_id AS
repositories_1_user_id, repositories_1.statistics AS
repositories_1_statistics, repositories_1.downloads AS
repositories_1_downloads, repositories_1.landing_revision AS
repositories_1_landing_revision, repositories_1.changeset_cache AS
repositories_1_changeset_cache, repositories_1.repo_id AS
repositories_1_repo_id, repositories_1.repo_name AS
repositories_1_repo_name, repositories_1.repo_state AS
repositories_1_repo_state, repositories_1.clone_uri AS
repositories_1_clone_uri, repositories_1.repo_type AS
repositories_1_repo_type, repositories_1.private AS
repositories_1_private, repositories_1.description AS
repositories_1_description, repositories_1.created_on AS
repositories_1_created_on, repositories_1.updated_on AS
repositories_1_updated_on, repositories_1.fork_id AS
repositories_1_fork_id, repositories_1.group_id AS
repositories_1_group_id, permissions_1.permission_id AS
permissions_1_permission_id, permissions_1.permission_name AS
permissions_1_permission_name
FROM repo_to_perm LEFT OUTER JOIN repositories AS repositories_1 ON
repositories_1.repo_id = repo_to_perm.repository_id LEFT OUTER JOIN
permissions AS permissions_1 ON permissions_1.permission_id =
repo_to_perm.permission_id
WHERE repo_to_perm.user_id = ?
2024-11-21 09:13:48.767 INFO  [sqlalchemy.engine.base.Engine] (1,)
2024-11-21 09:13:48.767 DEBUG [sqlalchemy.engine.base.Engine] Col
('repo_to_perm_repo_to_perm_id', 'repo_to_perm_user_id',
'repo_to_perm_permission_id', 'repo_to_perm_repository_id',
'repositories_1_user_id', 'repositories_1_statistics',
'repositories_1_downloads', 'repositories_1_landing_revision',
'repositories_1_changeset_cache', 'repositories_1_repo_id',
'repositories_1_repo_name', 'repositories_1_repo_state',
'repositories_1_clone_uri', 'repositories_1_repo_type',
'repositories_1_private', 'repositories_1_description',
'repositories_1_created_on', 'repositories_1_updated_on',
'repositories_1_fork_id', 'repositories_1_group_id',
'permissions_1_permission_id', 'permissions_1_permission_name')
2024-11-21 09:13:48.768 DEBUG [sqlalchemy.engine.base.Engine] Row (1, 1,
3, 1, 2, 0, 0, 'rev:tip', b'{"short_id": "49c6cbd0f7a4", "raw_id":
"49c6cbd0f7a4a3d85189c428a0989b3491680cd7", "revision": 15665,
"message": "Bug 1432027 - Update pdf.js to version 2.0.288. r=bdahl",
"date": "2018-01-21T22:46:41", "author": "Ryan VanderMeulen
<ryanvm at gmail.com>"}', 1, 'code/release/mozilla-release',
'repo_state_created',
'https://foss.heptapod.net/seamonkey/mozilla-release', 'hg', 0,
'mozilla-release', '2024-02-29 08:35:22.345017', '2018-01-21
22:46:41.000000', None, 3, 3, 'repository.read')
2024-11-21 09:13:48.768 DEBUG [sqlalchemy.engine.base.Engine] Row (2, 1,
3, 2, 2, 0, 0, 'rev:tip', b'{"short_id": "67dc920d4b4d", "raw_id":
"67dc920d4b4d8428e5edcd7b39d359c763eb2895", "revision": 21760,
"message": "close obsolete gloda-facet branch", "date":
"2022-02-07T06:05:58", "author": "Frank-Rainer Grahl
<frgrahl at gmx.net>"}', 2, 'code/release/comm-release',
'repo_state_created',
'https://foss.heptapod.net/seamonkey/comm-release', 'hg', 0,
'comm-release', '2024-02-29 08:39:35.175544', '2022-02-07
06:05:58.000000', None, 3, 3, 'repository.read')
2024-11-21 09:13:48.768 DEBUG [sqlalchemy.engine.base.Engine] Row (3, 1,
3, 3, 2, 0, 0, 'rev:tip', b'{"short_id": "f80b925f6772", "raw_id":
"f80b925f6772c19f2eb2b0957af71c2a7b5a6c44", "revision": 43112,
"message": "Bug 1928953 - Improve performance  ... (113 characters
truncated) ... erential Revision:
https://phabricator.services.mozilla.com/D227822", "date":
"2024-11-19T13:49:56", "author": "John Bieling
<john at thunderbird.net>"}', 3, 'code/central/comm-central',
'repo_state_created', 'https://hg.mozilla.org/comm-central', 'hg', 0,
'comm-central', '2024-02-29 09:17:07.681246', '2024-11-19
13:49:56.000000', None, 2, 3, 'repository.read')
2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (4, 1,
3, 4, 2, 0, 0, 'rev:tip', b'{"short_id": "c845f3207181", "raw_id":
"c845f32071817c81069390d3ba4f06b0ee270c20", "revision": 762863,
"message": "Backed out 3 changesets (bug 1928 ... (136 characters
truncated) ... bug 1928734)\\nBacked out changeset a9f66c1d560d (bug
1928734)", "date": "2024-11-19T07:49:22", "author": "Butkovits Atila
<abutkovits at mozilla.com>"}', 4, 'code/central/mozilla-central',
'repo_state_created', 'https://hg.mozilla.org/mozilla-central', 'hg', 0,
'mozilla-central', '2024-02-29 09:19:57.337581', '2024-11-19
07:49:22.000000', None, 2, 3, 'repository.read')
2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (5, 1,
3, 5, 2, 0, 0, 'rev:tip', b'{"short_id": "55b82abe7eeb", "raw_id":
"55b82abe7eeb77fb5d847d45f4c7532559f9980e", "revision": 3911, "message":
"remove leading / from dirs\\n", "date": "2024-11-13T08:57:47",
"author": "Edmund Wong <ewong at pw-wspx.org>"}', 5,
'infrastructure/tools', 'repo_state_created', '', 'git', 0, 'tools',
'2024-02-29 10:30:20.170808', '2024-11-13 08:57:47.000000', None, 4, 3,
'repository.read')
2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (10,
1, 3, 7, 2, 0, 0, 'rev:tip', None, 7, 'code/central/patches/mcpatches',
'repo_state_created', None, 'hg', 0, 'code/central/patches/mcpatches
repository', '2024-03-01 08:42:47.382856', '2024-03-01 08:42:47.382865',
None, 5, 3, 'repository.read')
2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (11,
1, 3, 8, 2, 0, 0, 'rev:tip', b'{"short_id": "b30147a58521", "raw_id":
"b30147a5852119bb67d99c7713a060b1ffadd8b5", "revision": 0, "message":
"Initial Commit some patches", "date": "2024-03-01T16:32:04", "author":
"Edmund Wong <ewong at pw-wspx.org>"}', 8,
'code/central/patches/ccpatches', 'repo_state_created', None, 'hg', 0,
'code/central/patches/ccpatches repository', '2024-03-01
08:43:26.757363', '2024-03-01 16:32:04.000000', None, 5, 3,
'repository.read')
2024-11-21 09:13:48.769 DEBUG [sqlalchemy.engine.base.Engine] Row (15,
1, 3, 9, 2, 0, 0, 'rev:tip', None, 9, 'patches/ccpatches',
'repo_state_created', '', 'git', 0, 'ccpatches', '2024-11-21
09:13:48.258741', '2024-11-21 09:13:48.258749', None, 6, 3,
'repository.read')
2024-11-21 09:13:48.770 DEBUG [kallithea.lib.auth] Checking if user
'ewong' can 'read' repo 'patches/ccpatches' (None): True (has
'repository.admin')
2024-11-21 09:13:48.770 DEBUG [kallithea.lib.auth] Permission granted
for <kallithea.controllers.summary.SummaryController object at
0xb11c48c8> <AuthUser 2: 'ewong'>
2024-11-21 09:13:48.770 INFO  [kallithea.lib.webutils] Flash warning:
There are no changesets yet
2024-11-21 09:13:48.773 INFO  [sqlalchemy.engine.base.Engine] SELECT
statistics.stat_id AS statistics_stat_id, statistics.repository_id AS
statistics_repository_id, statistics.stat_on_revision AS
statistics_stat_on_revision, statistics.commit_activity AS
statistics_commit_activity, statistics.commit_activity_combined AS
statistics_commit_activity_combined, statistics.languages AS
statistics_languages
FROM statistics
WHERE ? = statistics.repository_id
2024-11-21 09:13:48.773 INFO  [sqlalchemy.engine.base.Engine] (9,)
2024-11-21 09:13:48.773 DEBUG [sqlalchemy.engine.base.Engine] Col
('statistics_stat_id', 'statistics_repository_id',
'statistics_stat_on_revision', 'statistics_commit_activity',
'statistics_commit_activity_combined', 'statistics_languages')

but it repeats without going anywhere.

So I gave up and disabled celery.  Now it's working.

Has anyone here setup Celery + redis?  If so,  was I supposed
to somehow create a DB?  It doesn't mention anything creating
a DB.  using redis-cli,  "INFO keyspace" shows that there
is a db0.  No clue if it defaults to readwrite; but from
what I gather, default is read/write.

Thanks and sorry for the noise.

Edmund