| *** jamesmcarthur has joined #openstack-publiccloud | 01:36 | |
| *** jamesmcarthur has quit IRC | 01:50 | |
| *** VW has joined #openstack-publiccloud | 02:59 | |
| *** VW has quit IRC | 03:46 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 03:50 | |
| *** jamesmcarthur has quit IRC | 03:54 | |
| *** mma has joined #openstack-publiccloud | 05:35 | |
| *** mma has quit IRC | 05:39 | |
| *** mma has joined #openstack-publiccloud | 06:43 | |
| *** pilgrimstack has joined #openstack-publiccloud | 08:16 | |
| *** pilgrimstack has quit IRC | 08:20 | |
| *** zhipeng has joined #openstack-publiccloud | 10:27 | |
| *** zhipeng has quit IRC | 11:08 | |
| *** zhipeng has joined #openstack-publiccloud | 11:27 | |
| *** zhipeng has quit IRC | 11:34 | |
| *** zhipeng has joined #openstack-publiccloud | 12:48 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 12:51 | |
| tobberydberg | Silly questions to you folks - cleaning up nova instances from old deleted instances (not preferable with too much records prior to cellv2 mapping) - how do you folks do that without leaving any crap in other tables? Manual analysis of the DB before writing magic script, or do you know about any scripts already written that are verified to work? | 13:14 |
|---|---|---|
| tobberydberg | Have read a little about purge-deleted-instances and Simple DB purge, also found some scripts that are worth looking at, but interested in how the rest of you do this | 13:16 |
| tobberydberg | mnaser, pasuder, adriant, bjolo - see that you are around so sending a friendly ping to you folks =) | 13:17 |
| mnaser | there's a way of moving things to shadow table | 13:17 |
| mnaser | tobberydberg: https://docs.openstack.org/nova/queens/cli/nova-manage.html#nova-database | 13:18 |
| mnaser | nova-manage db archive_deleted_rows | 13:18 |
| mnaser | and in rocky there is nova-manage db purge | 13:19 |
| mnaser | https://docs.openstack.org/nova/latest/cli/nova-manage.html#nova-database | 13:19 |
| tobberydberg | Awesome, thanks! | 13:25 |
| tobberydberg | Saw that but rocky as well! | 13:25 |
| tobberydberg | And this one - nova-manage db archive_deleted_rows - you have been running that in production? | 13:26 |
| tobberydberg | Does it take a lot of time mnaser ? :-) | 13:26 |
| mnaser | tobberydberg: we don't run it because we just have massive db servers and they deal with the cope ok | 13:27 |
| mnaser | you can probably watch progress at mysqladmin processlist and see whats happening | 13:27 |
| tobberydberg | ok, thanks | 13:27 |
| tobberydberg | will have a look at the code behind it and see what it does | 13:27 |
| *** germs has joined #openstack-publiccloud | 13:31 | |
| *** germs has quit IRC | 13:31 | |
| *** germs has joined #openstack-publiccloud | 13:31 | |
| *** jamesmcarthur has quit IRC | 13:37 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 13:38 | |
| *** jamesmcarthur has quit IRC | 13:57 | |
| tobberydberg | Some interesting code and interesting approach in there mnaser :-) | 14:25 |
| *** jamesmcarthur has joined #openstack-publiccloud | 14:32 | |
| *** pilgrimstack has joined #openstack-publiccloud | 14:43 | |
| *** VW has joined #openstack-publiccloud | 14:45 | |
| *** pilgrimstack has quit IRC | 14:48 | |
| *** pilgrimstack has joined #openstack-publiccloud | 15:01 | |
| *** zhipeng has quit IRC | 15:19 | |
| *** jamesmcarthur has quit IRC | 16:07 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 16:07 | |
| *** pilgrimstack has quit IRC | 16:09 | |
| *** jamesmcarthur has quit IRC | 16:19 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 16:37 | |
| *** jamesmcarthur has quit IRC | 16:50 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 17:54 | |
| *** blake has joined #openstack-publiccloud | 19:58 | |
| *** blake has quit IRC | 20:20 | |
| *** blake has joined #openstack-publiccloud | 20:52 | |
| *** blake has quit IRC | 20:57 | |
| *** jamesmcarthur has quit IRC | 21:14 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 21:40 | |
| *** jamesmcarthur has quit IRC | 21:42 | |
| *** tobberydberg has quit IRC | 21:43 | |
| *** VW_ has joined #openstack-publiccloud | 21:47 | |
| *** tobberydberg has joined #openstack-publiccloud | 21:51 | |
| *** VW has quit IRC | 21:51 | |
| *** VW_ has quit IRC | 21:53 | |
| *** blake has joined #openstack-publiccloud | 22:21 | |
| *** mma has quit IRC | 22:42 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 22:46 | |
| *** mma has joined #openstack-publiccloud | 22:56 | |
| *** mma has quit IRC | 23:01 | |
| *** jamesmcarthur has quit IRC | 23:12 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 23:17 | |
| *** jamesmcarthur has quit IRC | 23:26 | |
| *** jamesmcarthur has joined #openstack-publiccloud | 23:38 | |
| *** jamesmcarthur has quit IRC | 23:42 | |
| *** mma has joined #openstack-publiccloud | 23:50 | |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!