Thursday, 2019-08-29

*** itlinux has joined #openstack-kolla00:48
*** keper7 has quit IRC01:11
*** dpawlik has joined #openstack-kolla01:39
*** dpawlik has quit IRC01:43
*** itlinux is now known as itlinux-away01:45
*** openstackgerrit has quit IRC02:37
*** k_mouza has joined #openstack-kolla02:46
*** k_mouza has quit IRC02:50
*** dpawlik has joined #openstack-kolla03:40
*** dpawlik has quit IRC03:44
*** gkadam has joined #openstack-kolla03:50
*** gkadam has quit IRC03:50
*** dave-mccowan has quit IRC04:41
*** skramaja has joined #openstack-kolla04:49
*** Luzi has joined #openstack-kolla05:05
*** shyamb has joined #openstack-kolla05:11
*** shyamb has quit IRC05:30
*** openstackgerrit has joined #openstack-kolla05:34
openstackgerritMichal Nasiadka proposed openstack/kolla master: Change fluentd to td-agent on CentOS  https://review.opendev.org/67561405:34
*** itlinux has joined #openstack-kolla05:35
*** factor has joined #openstack-kolla05:51
*** shyamb has joined #openstack-kolla05:52
*** dpawlik has joined #openstack-kolla06:00
*** dr_feelgood has joined #openstack-kolla06:11
openstackgerritMichal Nasiadka proposed openstack/kolla-ansible master: WIP: Ceph-Ansible CI  https://review.opendev.org/67637606:13
*** itlinux is now known as itlinux-away06:15
*** hamdyk has joined #openstack-kolla06:18
yoctozeptomorning channel06:31
yoctozeptomgoddard, mnasiadka, hrw: I have an announcement to make - I will be (much) less available tomorrow and during the upcoming week due to being assigned the role of a co-moderator of a big data conference/workshop in Turkey. This is very recent news because I learned only yesterday's late evening that I'm traveling tomorrow ;-) (hail the bureaucracy :-) )06:39
*** sm806 has quit IRC06:41
*** shyamb has quit IRC06:43
*** gfidente has joined #openstack-kolla06:45
*** shyamb has joined #openstack-kolla06:47
*** dougsz has joined #openstack-kolla06:48
*** dr_feelgood has quit IRC06:49
openstackgerritDoug Szumski proposed openstack/kolla-ansible master: Minimal support for deploying multiple instances of MariaDB  https://review.opendev.org/61975606:50
openstackgerritDoug Szumski proposed openstack/kolla-ansible master: Copy Nova role as a basis for the Nova cell role  https://review.opendev.org/67565806:50
openstackgerritDoug Szumski proposed openstack/kolla-ansible master: [WIP] Factor out nova-cell role  https://review.opendev.org/67565906:50
mnasiadkayoctozepto: have fun :) Turkey? Huh06:50
*** dr_feelgood has joined #openstack-kolla06:51
*** dr_feelgood has quit IRC06:53
*** dr_feelgood has joined #openstack-kolla06:56
openstackgerritDoug Szumski proposed openstack/kolla-ansible master: [WIP] Factor out nova-cell role  https://review.opendev.org/67565907:02
yoctozeptomnasiadka: yup, Istanbul to be exact ;-)07:09
*** shyamb has quit IRC07:13
*** shyamb has joined #openstack-kolla07:20
*** ivve has joined #openstack-kolla07:22
mnasiadkayoctozepto: what is irritatingly funny - I'm hitting the neutron bug only on ubuntu-source :)07:27
*** jbadiapa has joined #openstack-kolla07:28
*** dr_feelgood has quit IRC07:31
openstackgerritRadosław Piliszek proposed openstack/kolla-ansible master: Modernize a way of configuring Docker daemon  https://review.opendev.org/67270007:32
yoctozeptomnasiadka: yeah, this is odd07:32
yoctozeptoboth images are rebuilt07:32
*** dr_feelgood has joined #openstack-kolla07:32
yoctozeptoas if the difference in mysql version was the culprit07:32
yoctozeptoi.e. neutron doing nothing bad, only mariadb being broken07:33
mnasiadkawell, 10.1 in ubuntu vs 10.3 on centos07:35
yoctozeptoyup but they did not update recently07:36
yoctozeptoso might be neutron did something incompatible with 10.107:36
yoctozeptomnasiadka: I see you there on #neutron07:37
yoctozeptomaybe tell them what we have found07:37
mnasiadkaI'll talk with a fellow core :)07:37
yoctozeptomnasiadka: ok, who's that?07:37
mnasiadkayoctozepto: another polish guy :)07:38
yoctozeptomnasiadka: PL FTW :D07:38
mnasiadkayoctozepto: well, we have 3 polish cores here :)07:38
yoctozeptoPL can into cloud07:38
yoctozepto;D07:38
*** dougsz has quit IRC07:40
mnasiadkasee? doug got offended ;)07:42
yoctozeptomnasiadka: hmm? where?07:43
mnasiadkahe quit ;)07:43
yoctozeptoah07:43
yoctozeptoI have these filtered out07:43
openstackgerritRadosław Piliszek proposed openstack/kolla-ansible master: DNM: Test Zun now  https://review.opendev.org/67919507:43
*** dougsz has joined #openstack-kolla07:43
mnasiadkayoctozepto: https://review.opendev.org/#/c/677221/07:49
mnasiadkayoctozepto: this is the change that introduced that db migration, but all checks passed on postgres and mysql 5.x07:49
mnasiadkaso it looks like a mariadb bug in 10.1...07:49
mnasiadkaI don't like that we have a core service with very old version (but still old-stable-ish) :D07:50
mnasiadkalet's wait for mgoddard - he was doing a lot of stuff with mariadb :)07:52
*** dr_feelgood has quit IRC07:52
*** shyamb has quit IRC07:53
*** dr_feelgood has joined #openstack-kolla07:53
*** dougsz has quit IRC07:53
*** priteau has joined #openstack-kolla07:54
yoctozeptomnasiadka: yeah, let's put it on him ;-)08:04
yoctozeptooh well, we might want to use upstream mariadb then :-)08:08
yoctozeptomgoddard gonna love it08:08
mgoddardmorning08:13
mgoddardnew proposal: deprecate mariadb08:16
openstackgerritRadosław Piliszek proposed openstack/kolla-ansible master: Modernize the way of configuring Docker daemon  https://review.opendev.org/67270008:16
mgoddardcan we not just treat this as a neutron bug?08:16
yoctozeptomgoddard: well, neutrinos seem happy about what they did :D\08:17
yoctozeptoand it works on centos and some old mysql08:18
yoctozeptolooks like regresion in the one shipped with ubuntu08:18
yoctozepto;/08:18
mgoddard19.04 has 10.308:18
yoctozeptoubuntu bionic* 18.0408:19
mgoddardyeah, just saying08:19
yoctozeptook08:19
mgoddardwe normally just test LTS08:19
yoctozeptobecause we want sanity08:19
mgoddardwhere possible08:20
mnasiadkamgoddard: so it seems devstack uses mysql 5.7 instead of mariadb08:21
mnasiadkamgoddard: and probably that's the main issue :)08:21
mgoddardyeah08:21
mnasiadkamgoddard: but I asked Slawek Kaplonski (a neutron core) to try to change it together with the QA team08:21
mgoddardisn't he PTL?08:22
mnasiadkaAt least not yet :)08:22
mgoddardsounds like a way to start a long discussion on the ML08:22
mgoddardbut not change it :)08:22
mgoddardunless we could find a majority of deployment tools are using mariadb08:23
mgoddardis there a bug for this issue?08:23
mgoddardwe could create in k-a and neutron08:24
yoctozeptomgoddard: mariadb mostly took over mysql08:27
yoctozeptobut testing on 10.3 would bring no insight08:27
yoctozeptoas only 10.1 on ubuntu is affected so far08:27
yoctozeptocould even be by some misapplied ubuntu team patch08:27
yoctozeptowho knows08:27
yoctozeptoor well, it could be alembic which improperly translates the migration into sql08:29
yoctozeptonot detecting that mariadb 10.1 needs another approach08:30
yoctozeptomany questions, few answers08:30
mgoddardindeed08:34
mgoddardultimately we'r surely not the only users running mariadb on bionic, so I think this falls to the neutron team08:37
yoctozeptomgoddard: mhm, let's make the train release most unfortunate for ubuntu users and keep our CI broken08:38
yoctozeptoubuntu unvote?08:38
yoctozeptomnasiadka, mgoddard08:38
mgoddardfine by me :p08:38
mnasiadkaother option is to use mariadb repo on ubuntu....08:39
mgoddardI wonder if there's some manual SQL we could fudge in there08:39
mnasiadkamaking ubuntu unvoting will make as break it even more in other departments than neutron :)08:40
mgoddardI guess this breaks kolla and kolla-ansible?08:41
mnasiadkayeah08:42
yoctozepto<mnasiadka> other option is to use mariadb repo on ubuntu....08:44
yoctozeptoplease propose08:44
yoctozeptowe could test that08:44
mnasiadkayeah, will do08:45
yoctozeptothanks mnasiadka08:45
mnasiadkado we want to match version with CentOS?08:45
mnasiadkathe latest stable is 10.4, 10.3 is called old-stable :D08:45
mgoddardjust asking in OSA08:45
mgoddardlooks like they also use mariadb on ubuntu08:45
yoctozeptomgoddard: ok, what did you write (logs are not there yet and I was late?)08:46
yoctozeptoah, you only began08:46
yoctozeptomnasiadka: no need I believe08:46
yoctozeptowe could just turn our heads to upstream08:47
mgoddardyoctozepto: are you hit by a CI failure during neutron DB migration? We're seeing it in kolla08:47
yoctozeptomgoddard: thanks08:47
yoctozeptoso they freeze08:48
mgoddardwe seem to flip between distro and upstream packages :)08:48
yoctozeptomgoddard: yeah, noticed that ;-)08:48
yoctozeptoso we wait two weeks till osa broken08:48
yoctozeptothen neutron fixes it08:48
yoctozeptome gusta08:49
*** shyamb has joined #openstack-kolla08:49
mgoddardwe could freeze :)08:50
mgoddardbetter solution than non-voting08:50
mnasiadkamgoddard: seems they use mariadb repo and 10.3 - https://github.com/openstack/openstack-ansible-galera_server/blob/master/defaults/main.yml#L4408:51
mnasiadkaand on 10.3 it works08:51
yoctozeptohaha, so neutron never gonna fix it08:51
yoctozeptowe alone08:51
mnasiadkawell, it's us and tripleo08:51
mnasiadka:)08:52
yoctozeptomnasiadka: they are centos08:52
mnasiadkaah08:52
mnasiadkaso they are fine08:52
yoctozepto;-)08:52
mnasiadkaso it's again our own hellhole08:52
yoctozepto:D08:52
mnasiadkaok, so I'll try to add the mariadb repo to ubuntu and let's see08:52
mgoddardhere's the error: Cannot change column 'network_id': used in a foreign key constraint 'subnets_ibfk_1'08:52
mnasiadkamgoddard: https://review.opendev.org/#/c/677221/08:52
mnasiadkahere is the change that introduced this08:53
mnasiadkahappily tested on postgres and mysql 5.7 :)08:53
yoctozeptothey are revmoving nullability08:53
yoctozeptoshould work just fine08:53
yoctozeptofor the fk08:53
yoctozeptounless the sql does something awry08:53
mnasiadkaworks fine on mariadb 10.3 :)08:53
yoctozeptoor rbdms broke ;p08:53
yoctozeptoyeah, but see alembic translates it based on target server08:54
mgoddardwell I expect OSA will hit it eventually08:54
mgoddardwhat if we temporarily remove the foreign key constraint during the migration?08:54
mgoddardthat could be the workaround in neutron08:54
yoctozeptomgoddard: they use 10.308:54
yoctozeptothey will not hit it ;-)08:54
yoctozeptomnasiadka linked https://github.com/openstack/openstack-ansible-galera_server/blob/master/defaults/main.yml#L4408:55
mgoddardyeah, looks like they're using upstream08:56
yoctozeptoso not affected by ubuntu masters08:57
*** gfidente has quit IRC08:57
yoctozeptoand using higher ver08:57
yoctozeptoso we ARE alone08:57
yoctozeptoalign with osa then?08:58
yoctozeptomgoddard, mnasiadka ^08:58
yoctozeptomnasiadka: preparing patch already? ;D08:58
mnasiadkayeah, started doing the change...08:58
yoctozeptofcuk yeah08:58
mgoddardmore mariadb upgrades :(08:59
openstackgerritRadosław Piliszek proposed openstack/kolla-ansible master: Modernize the way of configuring Docker daemon  https://review.opendev.org/67270008:59
yoctozeptoxD08:59
mgoddardbefore we charge into this, we're not the only people in the world using ubuntu's distro mariadb09:00
mgoddardI think neutron needs to handle it09:00
yoctozeptoor ubuntu09:00
yoctozeptoor alembic09:00
mgoddardwhat are they going to say in the bug report?09:00
yoctozeptoor mariadb09:00
yoctozepto"it works for me"09:00
mgoddardoh, you need to upgrade your database09:00
mgoddardit doesn't work for me if you follow the steps to reproduce09:01
mgoddardyou can't say it works for me if you do something different!09:01
mgoddardI'll create a bug report09:04
mgoddardand pin neutron09:04
*** k_mouza has joined #openstack-kolla09:04
openstackgerritMichal Nasiadka proposed openstack/kolla master: Move to MariaDB upstream repo on Ubuntu  https://review.opendev.org/67920909:07
mnasiadkamgoddard: I think it's a bigger issue, if all devstack are using postgres or mysql 5.709:07
mnasiadkaand mariadb 10.1 is let's say the most non-compatible with mysql 5.7 (10.3 is more compatible)09:08
mnasiadkamost non-compatible from stable branches :)09:08
yoctozeptowell, neutrinos did nothing inherently wrong in that change09:10
yoctozeptoI identified 3 vectors of fault so far09:10
yoctozeptocould be more09:10
yoctozeptowhat would you do in their place ;p09:11
mnasiadkaso maybe it's an sqlalchemy bug? :D09:11
yoctozeptomnasiadka: that's alembic I mentioned ;-)09:11
yoctozeptoubuntu/alembic/mariadb fault09:12
yoctozeptosomeone needs to handle it for sure09:12
mgoddardpresumably we have the same version of alembic on ubuntu and centos in source images?09:14
yoctozeptomgoddard: but it could produce bad sql (not checked, only guessing) for 10.1 specifically09:16
mnasiadkathe only way to verify it is to downgrade MariaDB on CentOS to 10.1 :D09:17
yoctozeptomnasiadka: then you have either mariadb or alembic fault09:18
mnasiadkawell again we get shot in the head by using different versions of core packages :)09:19
yoctozeptoDROP CONSTRAINT for UNIQUE and FOREIGN KEY constraints was introduced in MariaDB 10.2.22 and MariaDB 10.3.13.09:21
yoctozeptowell, that is late09:21
yoctozeptoit could be alembic can't handle lack of lifting the constraint for example09:22
mnasiadkauhh09:23
yoctozeptobut if train is meant to be tested on mysql 5.7+09:23
yoctozeptothen bionic is outdated09:23
yoctozeptomnasiadka, mgoddard: guys, I really think we should follow in the steps of osa and upstreamify mariadb09:24
yoctozeptomaybe it makes upgrades easier/more consistent09:25
yoctozeptoas well09:25
mnasiadkayeah, at least we should fail everywhere :)09:25
mnasiadka(if we fail)09:25
yoctozepto(not the first one though ;p)09:25
yoctozeptomnasiadka: and be coordinated with osa ;p09:25
mgoddardwell we go back and forth on this. Upstream packages don't always work as well as distro packages09:26
mgoddardand remember how much time we ploughed into the last upgrade09:27
mgoddardso let's not rush into that09:27
mgoddardhttps://bugs.launchpad.net/kolla/+bug/184190709:28
openstackLaunchpad bug 1841907 in kolla-ansible train "Neutron bootstrap failing on Ubuntu bionic with Cannot change column 'network_id" [Critical,New]09:28
openstackgerritMark Goddard proposed openstack/kolla master: Workaround: Pin neutron source to avoid migration issue  https://review.opendev.org/67921309:31
mgoddardtrying that ^09:34
mnasiadkayeah, that might be the fastest workaround09:35
mgoddarduntil binary packages get updated :)09:36
mnasiadkayeah...09:36
yoctozeptobinaries are nonvoting09:38
yoctozeptono tears shed ;-)09:38
*** gfidente has joined #openstack-kolla09:39
*** shyamb has quit IRC09:40
openstackgerritMichal Nasiadka proposed openstack/kolla-ansible master: WIP: Ceph-Ansible CI  https://review.opendev.org/67637609:40
openstackgerritWill Szumski proposed openstack/kolla-ansible master: Set my_ip in ironic.conf  https://review.opendev.org/67921509:41
yoctozeptoso in centos rdo bumps up mariadb09:43
yoctozeptoseems we are not getting the same comfort in ubuntu09:44
*** ivve has quit IRC09:44
*** ivve has joined #openstack-kolla09:45
mgoddardRDO: for your comfort09:46
*** shyamb has joined #openstack-kolla09:47
yoctozeptoand sanity09:49
yoctozepto(most of the time)09:49
mnasiadkaand insanity when they release and bump up ceph09:51
mnasiadka:)09:51
yoctozeptomnasiadka: deprecate ceph-nfs = profit09:53
*** shyamb has quit IRC10:03
mnasiadkabumping up MariaDB to 10.3 on Ubuntu helped...10:04
mgoddardit passed the migration?10:04
mnasiadkaah sorry, it was the build job, the k-a job is still deploying (but not failed yet)10:06
openstackgerritWill Szumski proposed openstack/kolla-ansible master: Use secure websocket for nova serial console proxy when TLS enabled  https://review.opendev.org/67922210:06
*** radeks has joined #openstack-kolla10:09
*** shyamb has joined #openstack-kolla10:11
openstackgerritPierre Riteau proposed openstack/kolla-ansible master: Remove Heat environment file disabling deprecated plugins  https://review.opendev.org/67486710:13
*** radeks_ has joined #openstack-kolla10:14
*** radeks has quit IRC10:16
*** dpawlik has quit IRC10:19
mnasiadkahttps://www.irccloud.com/pastebin/lKNfaCrW/10:19
mnasiadkamgoddard: ring any bell?10:20
mnasiadkayou were doing the move to mariabackup for SST?10:20
mgoddardmnasiadka: reminds me of a month of staring at those logs10:20
mgoddardis it a fatal error?10:21
mgoddardunrecoverable suggests yes10:21
mgoddardwhich job is it from?10:22
mgoddarddeploy or upgrade?10:22
mnasiadkadeploy10:22
mgoddardhmm10:22
mnasiadkahmm, we don't install mariadb-backup10:22
mgoddardnothing comes to mind10:22
mgoddardis xtrabackup installed?10:23
mgoddardcould be 10.1 was using that?10:23
mgoddardlooks like k-a always uses mariabackup now10:23
mnasiadkayeah, let me add mariadb-backup package to the list and let's see10:25
openstackgerritMichal Nasiadka proposed openstack/kolla master: Move to MariaDB upstream repo on Ubuntu  https://review.opendev.org/67920910:25
mnasiadka(at least mariadb.org suggests installing it)10:25
*** dpawlik has joined #openstack-kolla10:29
mgoddardyou could check the mariadb logs from 10.110:33
*** andrein has joined #openstack-kolla10:34
*** shyamb has quit IRC10:42
*** shyamb has joined #openstack-kolla10:43
*** radeks_ has quit IRC10:51
openstackgerritMark Goddard proposed openstack/kolla master: DNM: Try updating alembic and SQLAlchemy in neutron-server  https://review.opendev.org/67922810:53
*** radeks has joined #openstack-kolla10:53
*** radeks has quit IRC10:58
*** shyamb has quit IRC11:02
*** shyamb has joined #openstack-kolla11:02
*** shyamb has quit IRC11:06
*** k_mouza has quit IRC11:10
openstackgerritMichal Nasiadka proposed openstack/kolla-ansible master: WIP: Ceph-Ansible CI  https://review.opendev.org/67637611:14
*** radeks has joined #openstack-kolla11:17
*** dave-mccowan has joined #openstack-kolla11:18
*** kplant has joined #openstack-kolla11:20
openstackgerritMerged x/kayobe stable/stein: Set provisioning and cleaning networks as non-shared  https://review.opendev.org/67912911:27
*** k_mouza has joined #openstack-kolla11:31
mnasiadkamgoddard: seems adding mariadb-backup package made it work11:35
mnasiadkabut I think debian should be broken due to my change, but we don't have a debian CI11:36
*** k_mouza has quit IRC11:37
mnasiadkamgoddard: but still I don't like this: 2019-08-29 10:59:14 2 [ERROR] WSREP: Process completed with error: /usr/local/bin/wsrep-notify.sh --status Joiner --uuid fc8c3eb9-ca4b-11e9-8746-86b9735ff44b --primary yes --index 1 --members11:39
mnasiadka051e82c5-ca4c-11e9-9ef6-8e61bd0d8fc7/primary/10.176.128.68:3306,0974c821-ca4c-11e9-b033-4f5cb82afe51/secondary1/10.176.128.79:3306,fc8bb98f-ca4b-11e9-9382-2bbcd1845ccb/secondary2/10.176.128.120:3306: 1 (Operation not permitted)11:39
mnasiadkabut it works11:40
mnasiadka;)11:40
*** nathharp has joined #openstack-kolla11:41
*** k_mouza has joined #openstack-kolla11:49
*** shyamb has joined #openstack-kolla11:49
openstackgerritOndrej Duchon proposed openstack/kolla-ansible master: Corrected notificaions for auditing.  https://review.opendev.org/67854411:51
mgoddardmnasiadka: yes, we see that always IIRC11:54
mnasiadkamgoddard: then I'm calm :)11:54
mgoddardI think it calls wsrep-notify at some point when the DB isn't ready so it fails. It should call it again later though11:55
openstackgerritMark Goddard proposed openstack/kolla master: Workaround: Pin neutron source to avoid migration issue  https://review.opendev.org/67921311:57
*** andrein has quit IRC11:58
*** andrein has joined #openstack-kolla11:59
*** k_mouza has quit IRC12:05
*** k_mouza_ has joined #openstack-kolla12:05
*** scottsol has joined #openstack-kolla12:12
*** k_mouza_ has quit IRC12:16
mnasiadkamgoddard: although I'm starting to think about adding the same repo to CentOS - if it's the way we want to go...12:18
*** k_mouza has joined #openstack-kolla12:21
*** k_mouza has quit IRC12:21
openstackgerritMichal Nasiadka proposed openstack/kolla-ansible master: WIP: Ceph-Ansible CI  https://review.opendev.org/67637612:22
*** k_mouza has joined #openstack-kolla12:22
*** k_mouza has quit IRC12:25
*** keper7 has joined #openstack-kolla12:33
*** shyamb has quit IRC12:38
*** shyamb has joined #openstack-kolla12:38
*** andrein has quit IRC12:42
*** Luzi has quit IRC12:44
mgoddardbumping alembic and sqlalchemy versions didn't work.12:49
mnasiadkaso bumping up mariadb in ubuntu did work12:54
mnasiadkahttps://review.opendev.org/#/c/679209/12:54
mnasiadkaare we going that path?12:54
*** keper7 has quit IRC12:55
openstackgerritOndrej Duchon proposed openstack/kolla-ansible master: Corrected notificaions for auditing.  https://review.opendev.org/67854412:56
mnasiadkamgoddard, yoctozepto: ^^12:56
mgoddardI'm concerned about it. 10.3 upgrade in centos was a pain12:59
mgoddardat least this time we don't have the xtrabackup/mariabackup headache that caused us to shutdown the cluster during upgrade12:59
mgoddardbut still, the problems weren't immediately obvious13:00
mgoddardand didn't show up every time13:00
yoctozeptomgoddard, mnasiadka: recheck a few times :-)13:01
mnasiadkamgoddard: well, either way we'll have to go this path, for example when Ubuntu upgrades their packages13:02
mgoddardyes, but the more we flip back and forth the more we headaches we have13:03
mnasiadkaand we might end up in a situation in November when we will need to do it last minute13:03
yoctozepto<mgoddard> bumping alembic and sqlalchemy versions didn't work.13:03
mgoddardwhy?13:03
yoctozeptocould be not fixed13:03
yoctozepto<mgoddard> I think it calls wsrep-notify at some point when the DB isn't ready so it fails. It should call it again later though13:03
mgoddard?13:03
yoctozeptoso I thought13:03
mnasiadkayeah, it might be that neutron/alembic/sqlalchemy won't fix it, and we'll need to fix it on our side13:04
yoctozeptoI'm ok with mgoddard workaround now13:04
mnasiadkawe can pin neutron for now, but I doubt they will flip it back13:04
mnasiadka:)13:04
yoctozeptoand having ubuntu patch ready :-)13:04
yoctozeptosame here13:04
mgoddardthey might be persuaded to make it work13:05
yoctozeptoI see, you can blackmail them? ;D13:05
mnasiadkamgoddard: well, I still think it's not Neutron's fault13:05
mgoddardno it's not, but that doesn't mean they don't need to make it work13:06
yoctozeptoit's not their fault in the sense that I doing it would not think I did something bad either13:06
mgoddardit's not our fault either, but it is our problem13:06
yoctozeptothe "we don't support latest ubuntu lts" is a bad label13:06
mnasiadkawell, it's rather a bad label for Ubuntu guys13:07
mnasiadkathey should deliver 10.3 as part of UCA and everybody would be happy13:07
yoctozeptowho would know 10.1 (or their patches or alembic - we are not sure about that) - would be that faulty13:07
mgoddardsoftware has bugs, new software will still have bugs13:07
yoctozeptoindeed mgoddard13:07
*** dougsz has joined #openstack-kolla13:07
yoctozeptothe question is who to rely on13:08
mgoddarda lot of software dev is about coping with that13:08
yoctozeptoosa decided to rely on upstream mariadb13:08
*** zbr has quit IRC13:08
yoctozeptofor either distro afaik13:08
*** andrein has joined #openstack-kolla13:08
yoctozeptothat way at least our mariadb issues are synchronized xD13:09
yoctozeptoand mariadb upstream might be more inclined to support painless upgrades13:09
yoctozeptolts are more like 'use this oldie, use this oldie, then start anew'13:10
yoctozeptowell, at least until new lts is all ready and shining13:10
yoctozepto;p13:10
yoctozeptoI must say the 14.04->16.04->18.04 path was quite nice (simple app+db server)13:11
yoctozeptoanyone following my great monologue? ;p13:12
yoctozeptomgoddard, mnasiadka: please share your thoughts ^13:15
mnasiadkawell, maybe I have suicidal thoughts, but I'm really nervous about major differences in critical services versions between distros13:17
*** zbr has joined #openstack-kolla13:17
mnasiadkaand I would go for upstream repo for Ubuntu at least, if not for all distros (but then tripleo will be unhappy and they will need to override it)13:17
*** shyamb has quit IRC13:18
yoctozeptomnasiadka: it's really easy to override, we can make an image for them, ubuntu folks don't use us this way13:19
yoctozepto;-)13:19
yoctozeptowe gate together (or will) and they remove our repos so it should be piece of cake ;-)13:20
yoctozeptoif we turn to upstream mariadb, we would be obliged to ensure they can use the rdo one13:21
yoctozeptothough I like the rdo approach, they are helpful13:21
yoctozeptomaybe just for ubuntu and somehow manage to sync version with rdo?13:21
yoctozeptowe don't need the latest greatest stuff13:21
yoctozeptothough upstream seems to care about last two versions only?13:22
yoctozeptohttps://downloads.mariadb.org/mariadb/+releases/13:23
yoctozeptonah, they care about all relevant currently13:23
yoctozeptomy heart goes upstream13:23
yoctozeptomnasiadka, mgoddard13:23
*** keper7 has joined #openstack-kolla13:23
yoctozeptofor ubuntu13:23
yoctozeptoand sync version with rdo13:23
yoctozepto(minor, not patch of course)13:24
yoctozeptowould be nice to convince devstack to deploy mariadb instead of mysql in the first place too13:24
yoctozepto;p13:24
mnasiadkaprobably this makes sense, we just need to make sure it works :)13:24
*** gfidente has quit IRC13:27
*** gfidente has joined #openstack-kolla13:27
mgoddardare we sure we're not just making work for ourselves here?13:28
mgoddardmnasiadka: have you asked your neutron friend about whether they're likely to fix it?13:28
mnasiadkamgoddard: all tests finished successfully, what's there to fix? :)13:29
mgoddardthat's what we said last time!13:29
mgoddardwe always have troubles when upgrading an infra component like this - db or mq13:30
mnasiadkayeah, well - I guess we'll start seeing more of these issues if devstack continues to be tested on MySQL 5.7 - which has a lot of incompatibilities with MariaDB 10.113:34
*** priteau has quit IRC13:35
mnasiadkaI'm not saying it's not adding us work13:37
mnasiadkabut there are no more deployment projects using MariaDB 10.1 that we know of :)13:38
ChaserjimHi Michael ! < jim bagwell here (just sayin hey)13:38
mnasiadkaHi Chaserjim13:38
*** hongbin has joined #openstack-kolla13:48
*** gfidente has quit IRC13:52
*** dave-mccowan has quit IRC13:54
*** signed8bit has quit IRC13:54
*** gfidente has joined #openstack-kolla13:54
*** dave-mccowan has joined #openstack-kolla13:55
*** jovial[m] has quit IRC13:55
*** bjolo has quit IRC13:57
*** dougsz has quit IRC13:57
*** roukoswarf has quit IRC14:05
*** dougsz has joined #openstack-kolla14:15
*** dougsz has quit IRC14:22
*** dpawlik has quit IRC14:23
yoctozeptomgoddard, mnasiadka: https://etherpad.openstack.org/p/mariadb-upstream-yes-or-no14:23
yoctozeptoassemble your thoughts14:24
openstackgerritPierre Riteau proposed x/kayobe stable/queens: Allocate IPs separately from configuring network  https://review.opendev.org/67926914:26
yoctozeptomgoddard:     UCA provides newer mongodb, yet not mariadb: http://ubuntu-cloud.archive.canonical.com/ubuntu/pool/main/m/14:30
yoctozeptodeprecate mariadb14:30
yoctozepto+1014:30
yoctozeptonoSQL in kolla14:31
yoctozepto(note for those not in the subject: I am joking)14:32
*** hamdyk has quit IRC14:33
*** dougsz has joined #openstack-kolla14:35
yoctozeptook, the poor man's mind map is ready from my side14:39
mgoddardif bionic does not support train, should we use disco?14:40
yoctozeptomgoddard: according to their notes, they are planning to support up to U on bionic14:41
yoctozeptojust they lag with that mariadb...14:41
mgoddardeven so, should we just use disco for our ubuntu containers?14:41
yoctozeptomgoddard: does uca build for non-lts?14:42
mgoddardpass14:42
yoctozeptofor non-lts we are tied to their openstack release14:43
yoctozeptothough it would fix mariadb ;p14:43
yoctozeptoargh14:43
openstackgerritMark Goddard proposed openstack/kolla master: DNM: Update ubuntu image to 19.04  https://review.opendev.org/67927714:43
mgoddard^ don't know till you try14:44
yoctozeptomgoddard: let's see if ubunters did not break mariadb on purpose, sure!14:45
yoctozeptoI have another idea to test as well14:45
*** jbadiapa has quit IRC14:47
*** also_stingrayza has joined #openstack-kolla14:49
openstackgerritRadosław Piliszek proposed openstack/kolla master: DNM: upstream mariadb 10.1 on Ubuntu  https://review.opendev.org/67928214:49
yoctozepto^ because why not14:49
yoctozeptoand we still need to grab some time to migrate percona xtrabackup to mariabackup14:51
yoctozepto10.3 is not supported with percona14:51
yoctozeptoso centos already affected14:51
yoctozeptoand ubuntu in plans14:51
openstackgerritOndrej Duchon proposed openstack/kolla-ansible master: Corrected notificaions for auditing.  https://review.opendev.org/67854414:55
*** dougsz has quit IRC14:58
*** jbadiapa has joined #openstack-kolla15:00
*** Chaserjim has quit IRC15:02
*** cally725 has joined #openstack-kolla15:05
mnasiadkamgoddard, yoctozepto: so how many versions of the solution we now have? :D15:07
*** itlinux has joined #openstack-kolla15:08
*** also_stingrayza has quit IRC15:09
cally725Hi is there a way to set the mtu to 9000 in the kola instances15:10
yoctozeptomnasiadka: 10.1 is for pure fun15:11
yoctozeptoif it magically passes, then ubuntu folks are to blame -> immediate report to their bugzilla15:12
yoctozeptocally725: what do you mean? you might want to configure neutron for higher mtu for the tenant (tunneled) networks15:13
*** scottsol has quit IRC15:14
mnasiadkamgoddard: non-lts is probably also not the way, because we'll need to change ships often :)15:14
yoctozeptomgoddard, mnasiadka: update on kolla data plane ipv615:14
mnasiadkamgoddard: but we could install mariadb 10.3 from non-lts :D15:14
yoctozeptoso far it seems that15:14
*** scottsol has joined #openstack-kolla15:14
yoctozepto1) ipv6 link-local pings do not work (maybe by design?)15:15
yoctozepto2) ipv6 slaac does not seem to work15:15
cally725Yes I set global_physnet_mtu = 9000 in the neutron.conf and the path_mtu = 9000 in the ml2.ini15:15
yoctozepto3) manually assigning delegated ipv6 address results in pingable network15:15
yoctozeptoso not that bad15:16
yoctozeptothough not good either15:16
yoctozeptomnasiadka: non-lts is bad because uca is for lts15:16
yoctozeptoinstalling non-lts on lts is equally bad15:16
yoctozeptoas there is not a single entity willing to support us in that15:17
mnasiadkayoctozepto: so there's only one normal solution, and it seems OSA does the same ;)15:17
yoctozeptoI agree, it makes sense since UCA does not update mariadb15:17
yoctozeptoeh15:17
yoctozeptohave you checked the mind map?15:17
cally725yoctozepto I see the ovs yoctozepto set to 9000 but br-int and br-tun still at 150015:17
cally725yoctozepto kola rocky15:18
yoctozeptocally725: standard questions - have you confirmed that the new config files are deployed on hosts and that the services were restarted since?15:18
cally725yoctozepto yes I logged on one of the controller and I see the new config values in the neutron and ml2 files15:19
cally725yoctozepto and I think that the kola-ansible redeployed restarted the neutron dockers15:20
yoctozeptoyou can confirm that with docker ps15:21
cally725this is I am doing but they all show 40 hours up15:21
cally725yoctozepto so I am not 100% sure then15:22
yoctozeptocally725: it should have restarted them if you used reconfigure with kolla-ansible15:23
yoctozeptobut you can restart the relevant ones manually15:23
cally725yoctozepto this is what I did indeed15:23
yoctozeptoI see15:23
yoctozeptodid you try rebooting? might be neutron is not recreating those interfaces now15:23
*** dpawlik has joined #openstack-kolla15:23
cally725yoctozepto no I can try rebooting the 3 servers (2 controllers and on compute)15:24
yoctozeptoall right, please note even number for controllers is bad due to lack of quorum15:25
yoctozepto(1/2 never forms a quorum, better use 3 so that you can have 2/3 quorum)15:25
cally725yoctozepto oups ok so I would be better with 1 than 2 ?15:25
cally725yoctozepto this is probably why I have restart problems sometime with mariadb15:26
yoctozeptocally725: not exactly always, it only means that having 2 does not really make you have proper HA15:26
yoctozeptomariadb elects a master15:27
yoctozeptoso it has problems when you have both servers down at the same time15:27
cally725yes15:27
yoctozeptorabbitmq is more of an issue here15:27
yoctozeptoyou should down one at a time15:27
yoctozepto(even with 3 controllers)15:27
cally725ok15:28
cally725noted15:28
*** dpawlik has quit IRC15:28
*** jbadiapa has quit IRC15:30
cally725yoctozepto so the procedure I followed to set the mtu is good then ?15:31
yoctozeptocally725: afaik yes, the two options should make it happen15:32
cally725yoctozepto ok should all ovs br-xxx be set to 9000 after the modif ?15:34
yoctozeptomgoddard: ubuntu 1904 failing all over the place ;-)15:34
mgoddardit was a long shot15:34
yoctozeptomgoddard: indeed15:35
cally725yoctozepto what about ubuntu 1804 ?15:35
yoctozeptocally725: I think so, but I am not a neutron expert, probably better to ask in their channel15:35
cally725yoctozepto can you propose me a channel if you can ?15:35
yoctozeptocally725: don't worry about our internal chat, we are solving some mariadb issue for train on bionic15:36
yoctozeptocally725: #openstack-neutron15:36
cally725yoctozepto thanks I will check with them15:36
yoctozeptothough for help you can also try the mailing list and/or ask.openstack.org15:36
yoctozeptoyw15:36
cally725yoctozepto sorry I am new here which mailing list ?15:39
*** skramaja has quit IRC15:39
yoctozeptocally725: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-discuss15:51
openstackgerritRadosław Piliszek proposed openstack/kolla master: DNM: upstream mariadb 10.1 on Ubuntu  https://review.opendev.org/67928215:55
*** hongbin has quit IRC15:58
*** dpawlik has joined #openstack-kolla16:01
*** gfidente has quit IRC16:04
*** dpawlik has quit IRC16:06
*** dougsz has joined #openstack-kolla16:14
*** ivve has quit IRC16:24
*** scottsol has quit IRC16:35
yoctozepto<yoctozepto> 1) ipv6 link-local pings do not work (maybe by design?)16:41
yoctozeptoby design indeed16:41
yoctozeptoseems they are filtered out explicitly16:41
*** nathharp has quit IRC16:42
*** igordc has joined #openstack-kolla16:44
*** andrein has quit IRC16:47
*** dougsz has quit IRC16:56
*** itlinux is now known as itlinux-away17:01
*** itlinux-away has quit IRC17:01
*** jbadiapa has joined #openstack-kolla17:07
yoctozeptoubuntu honor restored - upstream 10.1 has the same issue: https://storage.bhs1.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/logs_82/679282/2/check/kolla-ansible-ubuntu-source/b95eff9/primary/logs/ansible/deploy17:09
yoctozepto(latest, more recent than ubuntu and uncustomized)17:09
yoctozeptosecurity patches aligned with 10.2 and 10.317:10
yoctozeptoso it's indeed a thing of mysql incompat17:10
yoctozeptoanother + for upstream is support for debian17:12
yoctozeptowhich otherwise becomes another branch ;/17:12
*** ivve has joined #openstack-kolla17:31
*** tonythomas has quit IRC17:31
*** andrein has joined #openstack-kolla17:32
*** dr_feelgood has quit IRC17:45
*** andrein has quit IRC17:57
*** radeks has quit IRC18:15
*** signed8bit has joined #openstack-kolla18:15
*** dpawlik has joined #openstack-kolla18:17
*** dpawlik has quit IRC18:22
*** dr_feelgood has joined #openstack-kolla18:23
*** dr_feelgood has quit IRC18:27
*** jonaspaulo has joined #openstack-kolla18:30
*** andrein has joined #openstack-kolla18:34
*** JamesBenson has joined #openstack-kolla18:47
*** kplant has quit IRC18:50
*** hongbin has joined #openstack-kolla18:58
*** hongbin has quit IRC19:03
*** scottsol has joined #openstack-kolla19:06
*** spsurya has quit IRC19:07
*** KeithMnemonic has quit IRC19:09
*** scottsol has quit IRC19:22
*** tonythomas has joined #openstack-kolla19:26
*** Chaserjim has joined #openstack-kolla19:27
*** dpawlik has joined #openstack-kolla20:18
*** itlinux has joined #openstack-kolla20:23
JamesBensonHey all, I'm back from vacation, and working on getting Xen to work again...20:23
*** dpawlik has quit IRC20:23
*** scottsol has joined #openstack-kolla20:35
*** factor has quit IRC20:42
*** factor has joined #openstack-kolla20:42
*** watersj has joined #openstack-kolla20:43
watersjwhat is proper kolla way to start mariadb, kolla-ansible deploy --tags mariadb ?20:44
JamesBenson@watersj start or deploy?  That's the correct code for deploying.20:47
watersjsry I didn't give enough info, if host goes down (dmin trips power cord) from an already deployed environment. What is proper kolla way to restart db?20:49
openstackgerritPierre Riteau proposed x/kayobe stable/queens: Allocate IPs separately from configuring network  https://review.opendev.org/67926920:50
JamesBensonI think the proper way is using the recovery.... but not 100% sure.20:51
*** icarusfactor has joined #openstack-kolla20:53
*** scottsol has quit IRC20:54
*** factor has quit IRC20:54
noxoidif mariadb wont start on its own then yea mariadb_recovery would be the best choice21:05
*** brtknr has quit IRC21:22
*** brtknr has joined #openstack-kolla21:23
*** JamesBenson has quit IRC21:41
*** JamesBenson has joined #openstack-kolla21:43
*** JamesBen_ has joined #openstack-kolla21:44
*** luksky has joined #openstack-kolla21:46
*** JamesBenson has quit IRC21:47
*** JamesBen_ has quit IRC21:49
*** brtknr has quit IRC22:11
*** jonaspaulo has quit IRC22:13
*** ivve has quit IRC22:25
*** Chaserjim has quit IRC22:34
*** luksky has quit IRC22:38
*** Chaserjim has joined #openstack-kolla22:39
*** JamesBenson has joined #openstack-kolla23:39
*** itlinux is now known as itlinux-away23:40
*** andrein has quit IRC23:41
*** JamesBenson has quit IRC23:43
*** tonythomas has quit IRC23:51
*** hjensas has quit IRC23:52
*** hjensas has joined #openstack-kolla23:56
*** hongbin has joined #openstack-kolla23:59

Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!