Bug 32209 - Mageia App DB needs to be updated for Mageia 9 release
Summary: Mageia App DB needs to be updated for Mageia 9 release
Status: REOPENED
Alias: None
Product: Websites
Classification: Unclassified
Component: madb.mageia.org (show other bugs)
Version: trunk
Hardware: All Linux
Priority: Normal major
Target Milestone: ---
Assignee: Samuel Verschelde
QA Contact:
URL: https://madb.mageia.org/
Whiteboard:
Keywords:
: 32311 32344 (view as bug list)
Depends on:
Blocks:
 
Reported: 2023-08-30 15:12 CEST by Davy Defaud
Modified: 2024-05-10 15:17 CEST (History)
10 users (show)

See Also:
Source RPM:
CVE:
Status comment:


Attachments

Description Davy Defaud 2023-08-30 15:12:59 CEST
Mageia App DB needs to be updated since Mageia 9 is now the current stable version.

Currently, Mageia App DB is reporting Mageia 8 as the latest stable version, and it’s not possible to see the latest packages available for Mageia 9 in updates, backports, testing, etc.
Davy Defaud 2023-08-30 15:18:24 CEST

Summary: Mageia App DB => Mageia App DB needs to be updated for Mageia 9 release

Luděk Janča 2023-09-05 09:04:34 CEST

CC: (none) => joelp

Comment 1 sturmvogel 2023-09-22 17:59:00 CEST
*** Bug 32311 has been marked as a duplicate of this bug. ***

CC: (none) => joselp

Comment 2 sturmvogel 2023-09-29 05:20:12 CEST
*** Bug 32344 has been marked as a duplicate of this bug. ***

CC: (none) => rihoward1

Comment 3 Filip Komar 2023-10-01 17:17:44 CEST
AFAIK this is out of scope for atelier and domain of new great sysadmin team

Assignee: atelier-bugs => sysadmin-bugs
CC: (none) => filip.komar

Comment 4 Marja Van Waes 2023-10-24 15:55:01 CEST
CC'ing stormi and papoteur

CC: (none) => marja11, stormi-mageia, yvesbrungard

Comment 5 Marja Van Waes 2023-10-25 13:50:42 CEST
Reassigning to stormi, because he says in bug 32437 that he should be the default assignee for madb.

Assignee: sysadmin-bugs => stormi-mageia

Comment 6 Morgan Leijström 2023-10-25 23:05:57 CEST
...and now it works to set component to madb :)

CC: (none) => fri
Component: Other => madb.mageia.org

Comment 7 Samuel Verschelde 2023-11-06 13:40:00 CET
In progress!

Status: NEW => ASSIGNED

Comment 8 Marja Van Waes 2023-11-06 22:04:52 CET
(In reply to Samuel Verschelde from comment #7)
> In progress!

Thanks for working on it!
And nice to already see "Latest stable (9)" :-)
Comment 9 Samuel Verschelde 2023-11-07 18:55:17 CET
I think we're good now.

I also updated the "Release blockers for Mga 10", "Intended for Mga 10" and "High priority for Mga 10" pages, but I don't know if anyone uses them. Two of them were two releases late. Only the release blockers one was usable.
Comment 10 Samuel Verschelde 2023-11-07 18:55:38 CET
Fixed

Resolution: (none) => FIXED
Status: ASSIGNED => RESOLVED

Comment 11 Marja Van Waes 2023-11-07 19:06:23 CET
Thanks, Samuel,

You rock :-D
Comment 12 Philippe Didier 2023-11-08 16:11:02 CET
Hi Samuel

A little problem remains :
"Versions comparison" displays something very strange 

all the green lines (added in Cauldron) show old versions
(as an example Cauldron provides Firefox 0.102.9.0 
when Mageia9 provides Firefox 0.115.4.0   ???)

and a strange thing 
in Cauldron opencpn (that I maintain) is said to be version 5.6.2 (which is the Mageia8 version) 
when it is actually 5.8.4 for Mageia9 and Cauldron

CC: (none) => philippedidier

Comment 13 Davy Defaud 2023-11-09 11:23:10 CET
Hi Samuel,

May I suggest a trivial improvement? I think nowadays we should switch the default architecture to x86_64 instead of i586. As a majority of people are searching for x86_64 packages, that would avoid a useless first request with i586 for the Mageia servers and the waste of time for the requester.
Comment 14 Morgan Leijström 2023-11-10 10:39:46 CET
Thank you for fixing it so far

---

I agree with suggested improvement in Comment 13

---

This search not find the packages "samba", "Samba-client", "samba-common" etc:

https://madb.mageia.org/package/list/t_search/samba/application/0/arch/x86_64

Same for Cauldron

But if i change to Mageia 8 or 7, it do.

=> Reopening

Resolution: FIXED => (none)
Status: RESOLVED => REOPENED

Comment 15 papoteur 2023-11-12 20:26:28 CET
The same for gajim:
https://madb.mageia.org/package/list/application/0/release/9/arch/x86_64/t_search/gajim
returns no results.
Comment 16 Samuel Verschelde 2023-11-13 13:41:22 CET
madb gets the RPM information from Sophie. I can't find gajim in Sophie on Mageia 9 either, despite it is present in the distrib-coffee mirror. Same for samba.

Sophie also believes that cauldron provides firefox 102.9.0, and there's a mismatch between the SRC RPMs and the build RPMs it sees.

http://sophie.zarb.org/search?search=firefox&type=byname&deptype=P&distribution=Mageia&release=cauldron&arch=

There are visibly issues with the repo scan of both Mageia 9 and cauldron in Sophie, with packages either missing or outdated.

CCing Nanardon, who maintains Sophie.

CC: (none) => nanardon

Comment 17 Samuel Verschelde 2023-11-13 13:43:18 CET
(In reply to Davy Defaud from comment #13)
> Hi Samuel,
> 
> May I suggest a trivial improvement? I think nowadays we should switch the
> default architecture to x86_64 instead of i586. As a majority of people are
> searching for x86_64 packages, that would avoid a useless first request with
> i586 for the Mageia servers and the waste of time for the requester.

Regarding this, I fully agree, and the change is indeed rather trivial. The only drawback, but I think we can live with it, is that shared links that previously pointed at the i586 version of lists and packages will now point at the x86_64 version.
Comment 18 Philippe Didier 2024-01-09 14:15:46 CET
I have tried to use madb today

"Version comparison" : 
- gives always a strange behaviour comparing Mageia9 and Cauldron
- it works well comparing Mageia8 or Mageia7 to Cauldron !!!

"Packages/Applications"
- in the list for Mageia9 some applications are missing when they are present in Mageia8 or Cauldron
- searching a particular application with "search" can find it in Mageia8 Mageia7 Mageia6 and Cauldron  but not in Mageia9

If madb uses Sophie to get information there's always something wrong inside Sophie which seems having problem to create a correct database of rpms for Mageia9
when it works correctly for Mageia8 (including even the updated rpms) for Cauldron but not for Mageia9

The strangest thing is that Sophie can find for Mageia9/core/release the srpm of this particular application but not the build rpms

There's still a problem inside Sophie but not a bug in madb
Comment 19 Philippe Didier 2024-01-19 13:08:38 CET Comment hidden (obsolete)
Comment 20 Philippe Didier 2024-01-19 13:47:11 CET
Always the same problem as described in comment 12 comment 14 comment 16

I digged a little more inside Sophie
1) for Mageia9

The database of srpms for Mageia9 seems correct
but lots of rpms (whose the srpm is present) are missing in the database of rpms
for example 
one SRPM opencpn-5.4.8-2
no rpm opencpn-5.8.4-2

Strangest
 searching rpms beginning with openc Sophie find all the rpms of plugins for opencpn that are in /core/updates_testing and only them !!!
but can't find them in core/release
Sophie seems not looking for rpms in the right repositories


2) for Cauldron
Strangest : in the database of rpms of Cauldron we can find several rpms of different versions of a same program
when there's only one srpm for this program

As an example
one SRPM of 
opencpn-5.8.4-2 

but three RPMS of 
opencpn-5.6.2-5
opencpn-5.6.2-6
opencpn-5.8.4-2

In the mirrors there's only the last version

NB versions 5.6.2-5, 5.6.2-6, 5.8.4-2 were successively created inside Cauldron before Mageia9 was published but only 5.8.4-2 version of srpm and rpm was present in Cauldron at the end, the last version replacing the previous ones

Sophie seems unable to erase old versions when a new one appears in Cauldron

Hope this comment will help Nanardon to lead Sophie to the right repositories
Comment 21 Philippe Didier 2024-01-19 13:50:32 CET
Sorry for the strange mid-air collision
Comment 19 might not exist it was a draft !!!
Comment 22 Philippe Didier 2024-03-07 18:48:44 CET
Hi
No news from Sophie ?
Lots of rpms are still missing for Mageia9/core/release or Mageia9/core/updates inside Sophie
but they appear in Cauldron/core/release sometimes several times (with their successive versions) with their mga9 suffix !

Besides this the srpms for Mageia9 are all present (inside core/release and core/updates) with their correct mga9 suffix
Besides this the srpms for Cauldron have a correct mga10 suffix

It seems like Sophie is not looking for rpms in the right place for the rpms of Mageia9 and Cauldron

That's the reason why Mageia App DB gives wrong results for versions comparison
between Mageia9 and Cauldron
That's the reason why it fails when browsing for packages or applications inside Mageia9  or Cauldron (for which it finds only mga9 rpms)
Comment 23 Samuel Verschelde 2024-03-08 11:49:04 CET
I have sent an e-mail to Olivier with your findings and a link to the issue.
Comment 24 Philippe Didier 2024-05-10 15:17:07 CEST
Hi

Sophie seems to have been partly corrected :

Sophie now functions correctly when looking for rpms inside Mageia9 
and as a consequence Mageia App Db can list all the versions of rpms present 
in Mageia9 (aka latest release) in core repo and updates repo

That's OK for
http://madb.mageia.org/package/list/application/0/release/9/arch/x86_64


BUT Sophie doesn't look for the content of the actual Cauldron and seems to keep in memory what was Cauldron before Mageia9 is published and this as 2 consequences :

1) Mageia App Db lists an obsolete version of Cauldron rpms
as an exemple : for blender it shows 3 versions 
3.3.3-2.mga9  3.3.4-2.mga9 3.3.6-mga9
http://madb.mageia.org/package/show/application/0/release/cauldron/arch/x86_64/name/blender

When in the actual Cauldron repo it's now 3.6.9-1-mga10

2) Mageia App Db displays a totally wrong comparison between Mageia9 and Cauldron :
Cauldron seems to have older versions than Mageia9
http://madb.mageia.org/package/comparison/release/9/arch/x86_64

Note You need to log in before you can comment on or make changes to this bug.