Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5252

Deb installation issues due to version mismatch between mariadb and ubuntu/debian repositories

Details

    Description

      This is an umbrella report for well-known deb package issues caused by the version mismatch with the official repositories.

      The problem was initially described in MDEV-3882, but later it was fixed after a part related to Wheezy specifics was fixed. However, the main problem still exists, as of 5.5.33a, it's described in the Knowledge base along with workarounds:

      https://mariadb.com/kb/en/installing-mariadb-deb-files/#version-mismatch-between-mariadb-and-ubuntudebian-repositories

      I don't want to reopen MDEV-3882 to keep the history consistent, so I'll link it to this report as a part of it, and will do the same with other ones that carry any new information. The rest will be closed as duplicates.

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            mcoleman Matt Coleman added a comment -

            I've submitted a pull request (https://code.launchpad.net/~mcoleman/maria/maria-fix-bug5190/+merge/194226) in LaunchPad to resolve this issue. The pull request resolves fresh installation of MariaDB; in order to resolve dependency issues with packages that explicitly depend on MySQL, I have created a new source package, maria-compat (https://code.launchpad.net/~mcoleman/maria/maria-compat), which creates libmysqlclient18, mysql-client, and mysql-server packages for a temporary workaround until one of the two permanent solutions (or both) is implemented:
            1. work with the Debian/Ubuntu distribution maintainers and try to come up with a way to manage conflicting database engines, similar to (or maybe integrated into) the update-alternatives system
            2. reach out to the projects that explicitly depend on MySQL packages and request that they update their dependencies for compatibility with MariaDB (ie. changing "Depends: libmysqlclient18" to "Depends: libmariadbclient18 | libmysqlclient18")

            mcoleman Matt Coleman added a comment - I've submitted a pull request ( https://code.launchpad.net/~mcoleman/maria/maria-fix-bug5190/+merge/194226 ) in LaunchPad to resolve this issue. The pull request resolves fresh installation of MariaDB; in order to resolve dependency issues with packages that explicitly depend on MySQL, I have created a new source package, maria-compat ( https://code.launchpad.net/~mcoleman/maria/maria-compat ), which creates libmysqlclient18, mysql-client, and mysql-server packages for a temporary workaround until one of the two permanent solutions (or both) is implemented: 1. work with the Debian/Ubuntu distribution maintainers and try to come up with a way to manage conflicting database engines, similar to (or maybe integrated into) the update-alternatives system 2. reach out to the projects that explicitly depend on MySQL packages and request that they update their dependencies for compatibility with MariaDB (ie. changing "Depends: libmysqlclient18" to "Depends: libmariadbclient18 | libmysqlclient18")
            mcoleman Matt Coleman made changes -
            Comment [ I've submitted a pull request (https://code.launchpad.net/~mcoleman/maria/maria-fix-bug5190/+merge/194226) that will resolve this. It depends on a new package that I've build, maria-compat (https://code.launchpad.net/~mcoleman/maria/maria-compat) that will need to be build and added to the MariaDB .deb repositories in order to fully resolve dependency issues for fresh installation of MariaDB as well as any packages that depend on libmysqlclient18, mysql-client, or mysql-server.

            I view this as a temporary solution. Please see the description on the merge request for two suggestions for a permanent fix (both, unfortunately, will require significant cooperation from the rest of the Debian/Ubuntu community). ]
            elenst Elena Stepanova made changes -
            tmarble Tom Marble added a comment -

            I will look into this issue.. thank you very much for reporting it!

            Obviously we want the user experience to be great on Debian and Ubuntu.

            tmarble Tom Marble added a comment - I will look into this issue.. thank you very much for reporting it! Obviously we want the user experience to be great on Debian and Ubuntu.
            serg Sergei Golubchik made changes -
            Assignee Tom Marble [ tmarble ]
            serg Sergei Golubchik made changes -
            Fix Version/s 5.5.34 [ 13700 ]
            elenst Elena Stepanova made changes -
            mcoleman Matt Coleman made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -

            Re-assigned to Otto

            ratzpo Rasmus Johansson (Inactive) added a comment - Re-assigned to Otto
            ratzpo Rasmus Johansson (Inactive) made changes -
            Assignee Tom Marble [ tmarble ] Otto Kekäläinen [ otto ]
            elenst Elena Stepanova made changes -

            its a pretty serious issue and make me not want to use mariadb's repo in a production environment with replication. Its to much downtime if an apt-get upgrade would uninstall the master mysql server.

            stefane Stefan Eriksson added a comment - its a pretty serious issue and make me not want to use mariadb's repo in a production environment with replication. Its to much downtime if an apt-get upgrade would uninstall the master mysql server.
            otto Otto Kekäläinen added a comment - - edited

            mcoleman and stefane : Work is in progress to make official Debian packages. There are lots of changes regarding the packaging and I expect that the issues here will be also solved as original libmysqlclient18 and new libmariadbclient18 will co-exsist properly in Debian main. Instead of update-alternatives we are using virtual package Provides "virtual-mysql".

            Please take a look at https://wiki.debian.org/Teams/MySQL/MariaDBPlan

            If you can help with testing, that would be great! Reports about official packaging can be sent to pkg-mysql-maint@lists.alioth.debian.org

            I will close this issue once the packages hit Debian proper and/or the new contents of debian/* is merged to replace current bzr:mariadb-5.5/debian/*

            otto Otto Kekäläinen added a comment - - edited mcoleman and stefane : Work is in progress to make official Debian packages. There are lots of changes regarding the packaging and I expect that the issues here will be also solved as original libmysqlclient18 and new libmariadbclient18 will co-exsist properly in Debian main. Instead of update-alternatives we are using virtual package Provides "virtual-mysql". Please take a look at https://wiki.debian.org/Teams/MySQL/MariaDBPlan If you can help with testing, that would be great! Reports about official packaging can be sent to pkg-mysql-maint@lists.alioth.debian.org I will close this issue once the packages hit Debian proper and/or the new contents of debian/* is merged to replace current bzr:mariadb-5.5/debian/*
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 29625 ] MariaDB v2 [ 43590 ]
            otto Otto Kekäläinen made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 43590 ] MariaDB v3 [ 62726 ]

            The bug report is actually quite vague on what the actual problem is, how to reproduce it etc. Unless somebody points out a concrete scenario that fails (hopefully along with copy-pasted "screenshot" of the terminal) I will close this issue soon.

            otto Otto Kekäläinen added a comment - The bug report is actually quite vague on what the actual problem is, how to reproduce it etc. Unless somebody points out a concrete scenario that fails (hopefully along with copy-pasted "screenshot" of the terminal) I will close this issue soon.

            It's not a bug in itself (not big enough for epic, but it should be a task, I'll move it now), that's why it has no description of the problem. It was created because it some point the number of various flavors of installation problems started getting out of hand, we needed some way to link them together and see them as a whole.

            It can be closed when the linked issues are closed, see the section "Issue Links". Or, if you so prefer, you can close it now, there aren't so many left, so they can be tracked individually if they're still relevant, which is unlikely.

            elenst Elena Stepanova added a comment - It's not a bug in itself (not big enough for epic, but it should be a task, I'll move it now), that's why it has no description of the problem. It was created because it some point the number of various flavors of installation problems started getting out of hand, we needed some way to link them together and see them as a whole. It can be closed when the linked issues are closed, see the section "Issue Links". Or, if you so prefer, you can close it now, there aren't so many left, so they can be tracked individually if they're still relevant, which is unlikely.
            elenst Elena Stepanova made changes -
            Affects Version/s 5.5.33a [ 13500 ]
            Issue Type Bug [ 1 ] Task [ 3 ]

            All of the subtasks have been closed, and upstreaming packaging changes is progressing and tracked in other issues eg

            https://jira.mariadb.org/browse/MDEV-6284
            https://jira.mariadb.org/browse/MDEV-8375
            https://jira.mariadb.org/browse/MDEV-14900

            otto Otto Kekäläinen added a comment - All of the subtasks have been closed, and upstreaming packaging changes is progressing and tracked in other issues eg https://jira.mariadb.org/browse/MDEV-6284 https://jira.mariadb.org/browse/MDEV-8375 https://jira.mariadb.org/browse/MDEV-14900
            otto Otto Kekäläinen made changes -
            Component/s Packaging [ 10700 ]
            Component/s Platform Debian [ 10136 ]
            Fix Version/s N/A [ 14700 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 62726 ] MariaDB v4 [ 132218 ]

            People

              otto Otto Kekäläinen
              elenst Elena Stepanova
              Votes:
              4 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.