Friday, 2022-11-04

*** dviroel is now known as dviroel|out00:17
*** ysandeep|out is now known as ysandeep06:17
gokhanigood morning folks, because of network outage, there was a conflict lock in my one node of galera and I can't restart mariadb. How can we solve conflict locks, do you have any experince ? Error log is [ERROR] InnoDB: Conflicting lock on table: `neutron`.`networkdhcpagentbindings` index: uniq_network_dhcp_agent_binding0network_id0binding_index0 that has lock06:58
gokhaniRECORD LOCKS space id 548 page no 5 n bits 112 index uniq_network_dhcp_agent_binding0network_id0binding_index0 of table `neutron`.`networkdhcpagentbindings` trx id 348584008 lock_mode X locks rec but not gap06:59
gokhanifull logs are https://paste.opendev.org/show/b34hYQughpepL4I2qcZI/06:59
noonedeadpunkgokhani: is it on all nodes or only the one that was out of sync?07:53
noonedeadpunkI guess one way would be to start-up in innodb recovery mode and releasing locks. Another could be jsut to drop/move /var/lib/mysql, re-init miariadb to force full re-sync (sst) from other cluster members07:56
gokhaninoonedeadpunk, this happened only on one node, other 2 nodes are sync08:00
noonedeadpunkWell, I think I'd go with just full re-sync of this one then08:02
gokhaninoonedeadpunk, ok you mean delete files under the /var/lib/mysql and restart mariadb on this node? 08:03
noonedeadpunkum, almost :) 1. ensure mariadb stopped. 2. move /var/lib/mysql somewhere (like `mv /var/lib/mysql{,_locks_failure}`) 3. run mysql_install_db 4. start mairadb - it should join the cluster and sync from it08:05
noonedeadpunkbut yeah, better make full db backup before messing up with it just in case08:05
gokhaninoonedeadpunk, thanks I will try it 08:19
*** ysandeep is now known as ysandeep|lunch08:50
*** ysandeep|lunch is now known as ysandeep10:23
opendevreviewMarc GariĆ©py proposed openstack/openstack-ansible-os_neutron master: [WIP] add ovn ssl config  https://review.opendev.org/c/openstack/openstack-ansible-os_neutron/+/86240311:21
*** dviroel_ is now known as dviroel11:36
derekokeeffe85Hi all, me again. Just having a chat with one of my seniors about the volume storage and I showed him the examples in the documentation. He used cinder on an old manual install of openstack a few years ago backed on to an EMC SAN. He was wondering if this is still possible in OSA and if so are there any examples of the configuration for EMC SAN and OSA. 11:53
*** ysandeep is now known as ysandeep|afk12:02
* noonedeadpunk has no idea what EMC SAN is12:17
noonedeadpunkIf you have any integration docs for manual install I can tell if that is possible with OSA12:17
noonedeadpunkI'd say that it should be given some number of oerrides12:18
noonedeadpunk*overrides12:18
mgariepyderekokeeffe85, yep it's possible to overrides any part of the cinder config with osa so you should be able to specify the correct config as long as cinder has support for it.12:24
jamesdentono/12:53
mgariepymorning jamesdenton 12:55
jamesdentonmornin'12:56
derekokeeffe85noonedeadpunk it's an iscsi backend, here is the manual doc https://www.delltechnologies.com/asset/en-us/products/storage/industry-market/sc-series-with-openstack-cinder-dell-emc-cml.pdf mgariepy thanks, it's obviously not straightforward so (as in done before with examples) it'll take us some figuring out12:57
mgariepyderekokeeffe85, https://docs.openstack.org/openstack-ansible/latest/reference/configuration/using-overrides.html12:58
noonedeadpunkthat document reminds me nvidia lol12:59
noonedeadpunkwhy 2.3.3 and 2.3.4 contain same paste?12:59
noonedeadpunksorry, 2.3.4 and 2.3.513:00
noonedeadpunkthey provide devstack conf as cinder.conf....13:00
noonedeadpunkI kind of wonder about extra modules/pip that should be installed13:00
noonedeadpunkBut it looks quite doable as it's indeed iscsi13:01
mgariepymaybe it's easier to parse the openstack directly ;) https://docs.openstack.org/cinder/zed/configuration/block-storage/drivers/dell-storagecenter-driver.html13:04
noonedeadpunkit totally is hehe13:08
noonedeadpunkand seems we install scsi packages unconditionally13:08
noonedeadpunk(and nfs)13:09
noonedeadpunk*iscsi13:09
noonedeadpunkso yeah, should work jsut by defining cinder_cinder_conf_overrides (and nova)13:09
spatelmorning folks!13:12
noonedeadpunk\o/13:13
spatelsorry folks not able to keep up because lots of stuff going on.. building new datacenter and openstack in order to retire older cloud.. 13:14
jamesdentonsounds like good things afoot13:17
*** ysandeep|afk is now known as ysandeep|out13:22
jrosserderekokeeffe85: does the discussion of OSA config overrides make sense? rather than look for an example of your dell integration in OSA you should use the cinder/dell docs to construct the right config override variables so that OSA writes the appropriate config files for your setup13:23
jrosserderekokeeffe85: OSA provides a generic means to put any config you want into any file, rather than try to explicitly enumerate and support all the possible  integrations that may exist13:24
jamesdentondoes anyone have a second to look at a compute node and verify their local_ip address in lxb or openvswitch agent ini file is actually their br-vxlan/vtep addr and not their mgmt ip?14:04
derekokeeffe85Sorry all, was away for lunch. To be honest it sounds like a lot to get my head around so not sure I'll b successful, I will however take all the advice you've all given and try to read up as much as I can about overrides etc.. Thanks for the advice, have a good weekend all14:10
mgariepyderekokeeffe85, if you need help you can always come back and ask questions we are very helpful usually ;)14:15
derekokeeffe85Thanks mgariepy, I wouldn't have gotten as far as I have without being here so thanks for all your help already 14:21
*** dviroel is now known as dviroel|lunch15:26
*** dviroel|lunch is now known as dviroel16:43
opendevreviewJames Denton proposed openstack/openstack-ansible master: Update container_networks address for is_metal containers  https://review.opendev.org/c/openstack/openstack-ansible/+/86355417:23
jrosserjamesdenton: ^ this runs on the deploy host?17:27
jamesdentonyes?17:33
jamesdentonwell, one sec17:33
jamesdentonTBH i hadn't tested in multinode and it's quite possible it drops the same ip everywhere, which is not desired obviously17:34
jamesdentonjrosser just ignore that patch. let's not talk about it again. thanks. :D18:06
*** dviroel is now known as dviroel|out19:52

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!