Bug 1854637
| Summary: | bifrost fails when running ironic-dbsync create_schema | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Iury Gregory Melo Ferreira <imelofer> |
| Component: | mariadb | Assignee: | Michal Schorm <mschorm> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 32 | CC: | damien.ciabrini, dtantsur, hhorak, janders, jjanco, jstanek, ljavorsk, mbayer, mkocka, mmuzila, mschorm, rpittau, SpikeFedora |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2020-09-11 03:48:07 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Description
Iury Gregory Melo Ferreira
2020-07-07 19:45:35 UTC
I can see that this error occurs since version update from mariadb-10.3.22 to mariadb-10.4.13 (It passes on Fedora 31) There were some changes in behavior, which should be properly documented, which may cause the error: https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104/ Please look at them, if you find something that may affect the bifrost tool. If not, I think the right thing here is to pass this error directly to the upstream's jira because, it looks like something deeper than maintaining error and they will have better insight then we do. Hi, This seems to pass on F32 with mariadb 10.4.12, so the issue is between micro versions .12 and .13 Downgrading the packages before running the bifrost installer works as intended. $ cat /etc/fedora-release Fedora release 32 (Thirty Two) $ rpm -qa | grep -i mariadb mariadb-connector-c-3.1.8-1.fc32.x86_64 mariadb-server-utils-10.4.12-3.fc32.x86_64 mariadb-backup-10.4.12-3.fc32.x86_64 mariadb-connector-c-config-3.1.8-1.fc32.noarch mariadb-cracklib-password-check-10.4.12-3.fc32.x86_64 mariadb-10.4.12-3.fc32.x86_64 mariadb-common-10.4.12-3.fc32.x86_64 mariadb-gssapi-server-10.4.12-3.fc32.x86_64 mariadb-errmsg-10.4.12-3.fc32.x86_64 mariadb-server-10.4.12-3.fc32.x86_64 I've just tried to downgrade it to 10.4.12-3 but it fails too. The failure is different tho. The error message is here (formatting is really ugly, but I just copy pasted it): http://paste.openstack.org/show/795693/ This is ironic-dbsync.log from previous comment: http://paste.openstack.org/show/795694/ Hi Lukas, I will try locally using version 10.4.12 to see how it goes for me. Hi Iury, Any update? Hi Lukas, I asked Jacob to do the test since I got busy with other things, he will report shortly the test using 10.4.12-3. Thanks! Hi Lukas, I've been helping Iury out with this so let me provide an update on his behalf. First, I reproduced the issue: http://paste.openstack.org/show/795991/ Then I dropped the ironic and inspector DBs, downgraded MariaDB packages to the following versions: http://paste.openstack.org/show/795988/ and re-ran bifrost install. It passed the DB tasks without issues. Downgrading packages to 10.4.12-3.fc32 seems to fix the issue for me. Please let us know if we can assist any further. Thanks, cheers, Jacob Okay I see it, this bug has occurred since rebase from mariadb-10.4.12-3 to mariadb-10.4.13-2 I will create jira issue and communicate it with upstream, if they have some clue what could cause the problem. Thanks for helping. Jira issue is created: https://jira.mariadb.org/browse/MDEV-23193 You can watch it and maybe add some additional info to it According to this comment https://jira.mariadb.org/browse/MDEV-23193?focusedCommentId=161972&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-161972 , the issue should be fixed in upcoming version (10.4.14). After the release and our rebase, I will give an update if it's fixing the issue The 10.4.14 updates are now in Fedora testing repository. Please try them and let us know, it they fix the issue for you. https://bodhi.fedoraproject.org/updates/?search=mariadb-10.4.14-2 Hi Lukas and Michal,
I am happy to confirm that with the current FC32 version of MariaDB I was able to install bifrost without issues:
(bifrost) [stack@fedoravm bifrost]$ export OS_CLOUD=bifrost
(bifrost) [stack@fedoravm bifrost]$ ./bifrost-cli install --testenv
Using release master detected from the checkout
PLAY [Install Ironic on the target host.] ****************************************************************************************************************************************************************************************************
TASK [Gathering Facts] ***********************************************************************************************************************************************************************************************************************
ok: [127.0.0.1]
TASK [bifrost-prep-for-install : ensure installation root folder exists] *********************************************************************************************************************************************************************
[WARNING]: The value 0 (type int) in a string field was converted to '0' (type string). If this does not look like what you expect, quote the entire value to ensure it does not change.
ok: [127.0.0.1]
(...)
TASK [bifrost-create-dib-image : Restore proper context on created data for http_boot] *******************************************************************************************************************************************************
skipping: [127.0.0.1]
PLAY RECAP ***********************************************************************************************************************************************************************************************************************************
127.0.0.1 : ok=134 changed=90 unreachable=0 failed=0 skipped=257 rescued=0 ignored=0
Ironic is installed and running, try it yourself:
$ source /opt/stack/bifrost/bin/activate
$ export OS_CLOUD=bifrost
$ baremetal driver list
See documentation for next steps
(bifrost) [stack@fedoravm bifrost]$ echo $?
0
(bifrost) [stack@fedoravm bifrost]$
[stack@fedoravm ~]$ sudo rpm -qa | grep maria
mariadb-connector-c-3.1.9-5.fc32.x86_64
mariadb-server-utils-10.4.14-2.fc32.x86_64
mariadb-connector-c-config-3.1.9-5.fc32.noarch
mariadb-cracklib-password-check-10.4.14-2.fc32.x86_64
mariadb-backup-10.4.14-2.fc32.x86_64
mariadb-server-10.4.14-2.fc32.x86_64
mariadb-errmsg-10.4.14-2.fc32.x86_64
mariadb-common-10.4.14-2.fc32.x86_64
mariadb-gssapi-server-10.4.14-2.fc32.x86_64
mariadb-10.4.14-2.fc32.x86_64
[stack@fedoravm ~]$ sudo su -
Last login: Fri Sep 11 01:27:21 UTC 2020 on tty1
[root@fedoravm ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 19
Server version: 10.4.14-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| inspector |
| ironic |
| mysql |
| performance_schema |
+--------------------+
5 rows in set (0.001 sec)
MariaDB [(none)]>
As far as I am concerned this is fixed & fix confirmed. This BZ can be closed.
Thank you for your assistance.
Thank you for confirming it works for you well. If the issue would appear again, feel free to open a new BZ and link this one to it. |