*** dviroel is now known as dviroel|out | 00:17 | |
*** ysandeep|out is now known as ysandeep | 06:17 | |
gokhani | good 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 lock | 06:58 |
---|---|---|
gokhani | RECORD 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 gap | 06:59 |
gokhani | full logs are https://paste.opendev.org/show/b34hYQughpepL4I2qcZI/ | 06:59 |
noonedeadpunk | gokhani: is it on all nodes or only the one that was out of sync? | 07:53 |
noonedeadpunk | I 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 members | 07:56 |
gokhani | noonedeadpunk, this happened only on one node, other 2 nodes are sync | 08:00 |
noonedeadpunk | Well, I think I'd go with just full re-sync of this one then | 08:02 |
gokhani | noonedeadpunk, ok you mean delete files under the /var/lib/mysql and restart mariadb on this node? | 08:03 |
noonedeadpunk | um, 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 it | 08:05 |
noonedeadpunk | but yeah, better make full db backup before messing up with it just in case | 08:05 |
gokhani | noonedeadpunk, thanks I will try it | 08:19 |
*** ysandeep is now known as ysandeep|lunch | 08:50 | |
*** ysandeep|lunch is now known as ysandeep | 10:23 | |
opendevreview | Marc GariƩpy proposed openstack/openstack-ansible-os_neutron master: [WIP] add ovn ssl config https://review.opendev.org/c/openstack/openstack-ansible-os_neutron/+/862403 | 11:21 |
*** dviroel_ is now known as dviroel | 11:36 | |
derekokeeffe85 | Hi 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|afk | 12:02 | |
* noonedeadpunk has no idea what EMC SAN is | 12:17 | |
noonedeadpunk | If you have any integration docs for manual install I can tell if that is possible with OSA | 12:17 |
noonedeadpunk | I'd say that it should be given some number of oerrides | 12:18 |
noonedeadpunk | *overrides | 12:18 |
mgariepy | derekokeeffe85, 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 |
jamesdenton | o/ | 12:53 |
mgariepy | morning jamesdenton | 12:55 |
jamesdenton | mornin' | 12:56 |
derekokeeffe85 | noonedeadpunk 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 out | 12:57 |
mgariepy | derekokeeffe85, https://docs.openstack.org/openstack-ansible/latest/reference/configuration/using-overrides.html | 12:58 |
noonedeadpunk | that document reminds me nvidia lol | 12:59 |
noonedeadpunk | why 2.3.3 and 2.3.4 contain same paste? | 12:59 |
noonedeadpunk | sorry, 2.3.4 and 2.3.5 | 13:00 |
noonedeadpunk | they provide devstack conf as cinder.conf.... | 13:00 |
noonedeadpunk | I kind of wonder about extra modules/pip that should be installed | 13:00 |
noonedeadpunk | But it looks quite doable as it's indeed iscsi | 13:01 |
mgariepy | maybe it's easier to parse the openstack directly ;) https://docs.openstack.org/cinder/zed/configuration/block-storage/drivers/dell-storagecenter-driver.html | 13:04 |
noonedeadpunk | it totally is hehe | 13:08 |
noonedeadpunk | and seems we install scsi packages unconditionally | 13:08 |
noonedeadpunk | (and nfs) | 13:09 |
noonedeadpunk | *iscsi | 13:09 |
noonedeadpunk | so yeah, should work jsut by defining cinder_cinder_conf_overrides (and nova) | 13:09 |
spatel | morning folks! | 13:12 |
noonedeadpunk | \o/ | 13:13 |
spatel | sorry 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 |
jamesdenton | sounds like good things afoot | 13:17 |
*** ysandeep|afk is now known as ysandeep|out | 13:22 | |
jrosser | derekokeeffe85: 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 setup | 13:23 |
jrosser | derekokeeffe85: 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 exist | 13:24 |
jamesdenton | does 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 |
derekokeeffe85 | Sorry 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 all | 14:10 |
mgariepy | derekokeeffe85, if you need help you can always come back and ask questions we are very helpful usually ;) | 14:15 |
derekokeeffe85 | Thanks 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|lunch | 15:26 | |
*** dviroel|lunch is now known as dviroel | 16:43 | |
opendevreview | James Denton proposed openstack/openstack-ansible master: Update container_networks address for is_metal containers https://review.opendev.org/c/openstack/openstack-ansible/+/863554 | 17:23 |
jrosser | jamesdenton: ^ this runs on the deploy host? | 17:27 |
jamesdenton | yes? | 17:33 |
jamesdenton | well, one sec | 17:33 |
jamesdenton | TBH i hadn't tested in multinode and it's quite possible it drops the same ip everywhere, which is not desired obviously | 17:34 |
jamesdenton | jrosser just ignore that patch. let's not talk about it again. thanks. :D | 18:06 |
*** dviroel is now known as dviroel|out | 19:52 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!