mysql-router charm shows WEB support 20.04, but 20.04 + 22.04 uploaded to charmstore

[taurus-forever]

Hi,

Based on https://chat.charmhub.io/charmhub/pl/awz34ux3utgz5yowpn6mgysdgw

TL;DR: see the picture:

As you can see 22.04 badge is missing for mysql-router in dpe/edge, but it the charm available for both focal and jammy:

> juju download mysql-router --channel dpe/edge --series jammy
Fetching charm "mysql-router" revision 100 using "dpe/edge" channel and base "amd64/ubuntu/22.04"
Install the "mysql-router" charm with:
    juju deploy ./mysql-router_r100.charm

> juju download mysql-router --channel dpe/edge --series focal
Fetching charm "mysql-router" revision 101 using "dpe/edge" channel and base "amd64/ubuntu/20.04"
Install the "mysql-router" charm with:
    juju deploy ./mysql-router_r101.charm

Can you please share the reason for the current charmhub.io behavior? Tnx!

[taurus-forever]

Just for the history: charmcraft built and published two revisions for series jammy=100 and focal=101 for such configuration.

However, in fact it is the same charm for different series. CharmHub.io shows the last revision only => revision for Jammy is not shown.

CharmHub or Charmcraft should be improved. CC: @sergiusens

[sergiusens]

From all the information shared, this so far looks like a Charmhub issue.

sergiusens@imladris:~/mysql$ cat 102/manifest.yaml | yq .bases
- architectures:
    - amd64
  channel: '22.04'
  name: ubuntu
sergiusens@imladris:~/mysql$ cat 103/manifest.yaml | yq .bases
- architectures:
    - amd64
  channel: '20.04'
  name: ubuntu

@taurus-forever can you provide the output for charmcraft status mysql-router? This sould take the base as an axis.

[taurus-forever]

@sergiusens I cannot: No publisher or collaborator permission for the mysql-router charm package :-( @javacruft is the owner of mysql-router. James, please dump the output of charmcraft status mysql-router (and invite me and @delgod as a collaborator if possible).

Thank you!

[sed-i]

I have a similar issue. I uploaded two revisions, one for 20.04, one for 22.04:

Manually released grafana agent machine charm @dashmage

Revision 19 of 'grafana-agent' created
Revision 20 of 'grafana-agent' created

Track    Base                  Channel    Version    Revision                                                                                                                         
latest   ubuntu 20.04 (amd64)  stable     -          -                                                                                                                                
                               candidate  12         12                                                                                                                               
                               beta       12         12                                                                                                                               
                               edge       19         19                                                                                                                               
         ubuntu 22.04 (amd64)  stable     -          -                                                                                                                                
                               candidate  12         12                                                                                                                               
                               beta       12         12                                                                                                                               
                               edge       20         20

But charmhub has a bug that prevents visualizing this correctly:

This visual bug was also discussed in:

• https://github.com/canonical/charmcraft/issues/1263#issuecomment-1747811709

[taurus-forever]

re: @taurus-forever can you provide the output for charmcraft status mysql-router.

@sergiusens Finally I have perms here:

14:48:09 ✔ taurus:~$ charmcraft status mysql-router
Track    Base                    Channel                Version    Revision    Expires at                                                                                                                                                             
... skipped unrelated OpenStack tracks ...                                                                                                                                                         
dpe      ubuntu 20.04 (amd64)    stable                 -          -                                                                                                                                                                                  
                                 candidate              -          -                                                                                                                                                                                  
                                 beta                   118        118                                                                                                                                                                                
                                 edge                   135        135                                                                                                                                                                                
                                 edge/8.0.35-noupgrade  128        128         2024-03-07T00:00:00Z                                                                                                                                                   
         ubuntu 22.04 (amd64)    stable                 -          -                                                                                                                                                                                  
                                 candidate              -          -                                                                                                                                                                                  
                                 beta                   119        119                                                                                                                                                                                
                                 edge                   136        136                                                                                                                                                                                
                                 edge/8.0.35-noupgrade  129        129         2024-03-07T00:00:00Z