<div dir="ltr">Hi,<div><br></div><div>I don't think pyc is problem, is it same file but byte compiled.</div><div><br></div><div><ol style="margin:0px 0px 1.1em 30px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-variant-alternates:inherit;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe UI Adjusted","Segoe UI","Liberation Sans",sans-serif;font-kerning:inherit;font-feature-settings:inherit;font-size:15px;vertical-align:baseline;list-style-position:initial;box-sizing:inherit;color:rgb(35,38,41)"><li style="margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;font-kerning:inherit;font-feature-settings:inherit;vertical-align:baseline;box-sizing:inherit"><code style="margin:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-kerning:inherit;font-feature-settings:inherit;vertical-align:baseline;box-sizing:inherit;white-space:pre-wrap">.py</code>: This is normally the input source code that you've written.</li><li style="margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;font-kerning:inherit;font-feature-settings:inherit;vertical-align:baseline;box-sizing:inherit"><code style="margin:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-kerning:inherit;font-feature-settings:inherit;vertical-align:baseline;box-sizing:inherit;white-space:pre-wrap">.pyc</code>: This is the compiled bytecode. If you import a module, python will build a <code style="margin:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-kerning:inherit;font-feature-settings:inherit;vertical-align:baseline;box-sizing:inherit;white-space:pre-wrap">*.pyc</code> file that contains the bytecode to make importing it again later easier (and faster).</li></ol><div><font color="#232629" face="-apple-system, BlinkMacSystemFont, Segoe UI Adjusted, Segoe UI, Liberation Sans, sans-serif"><span style="font-size:15px"><br></span></font></div><div>Two matches in the same layer of the same Docker volume:<br>/usr/lib/python3/dist-packages/neutron/db/migration/alembic_migrations/versions/wallaby/expand/__pycache__/6135a7bd4425_add_rbac_support_for_address_group.cpython-38.pyc<br>/usr/lib/python3/dist-packages/neutron/db/migration/alembic_migrations/versions/wallaby/expand/6135a7bd4425_add_rbac_support_for_address_group.py<font color="#232629" face="-apple-system, BlinkMacSystemFont, Segoe UI Adjusted, Segoe UI, Liberation Sans, sans-serif"><span style="font-size:15px"><br></span></font></div><div><br></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div style="margin:0px;padding:0px 0px 20px;width:1503px;color:rgb(34,34,34);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:medium"><div style="margin:8px 0px 0px;padding:0px"><div dir="ltr"><span><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:small"><span style="color:rgb(136,136,136);vertical-align:top;line-height:18px;font-size:11pt;font-family:Arial,Helvetica,Geneva;font-weight:bold">Michal Arbet<br></span><span style="color:rgb(136,136,136);font-size:10pt;vertical-align:top;line-height:18px;font-family:Arial,Helvetica,Geneva">Openstack Engineer<br><img src="https://www.google.com/a/ultimum.io/images/logo.gif" width="200" height="81"><br>Ultimum Technologies a.s.<br>Na Poříčí 1047/26, 11000 Praha 1<br>Czech Republic<br><br><a value="+420608314961" style="color:rgb(17,85,204)">+420 604 228 897</a> <br><a href="mailto:michal.arbet@ultimum.io" style="color:rgb(17,85,204)" target="_blank">michal.arbet@ultimum.io</a><br></span><font color="#1155cc" face="Arial, Helvetica, Geneva" style="font-size:12.8px"><span style="font-size:13.3333px;line-height:18px"><u><a href="https://ultimum.io/" style="color:rgb(17,85,204)" target="_blank">https://ultimum.io</a></u></span></font><br></div><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:small"><font color="#1155cc" face="Arial, Helvetica, Geneva" style="font-size:12.8px"><span style="font-size:13.3333px;line-height:18px"><br></span></font></div><div style="font-family:Arial,Helvetica,sans-serif;font-size:small"><font color="#666666"><a href="https://www.linkedin.com/company/ultimum-technologies" style="color:rgb(17,85,204)" target="_blank">LinkedIn</a> | <a href="https://twitter.com/ultimumtech" style="color:rgb(17,85,204)" target="_blank">Twitter</a> | <a href="https://www.facebook.com/ultimumtechnologies/timeline" style="color:rgb(17,85,204)" target="_blank">Facebook</a></font></div></div></div></div></div></div></div></div></span></div></div><div><div></div><div><div></div></div></div><div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">po 17. 4. 2023 v 8:04 odesílatel Gregory Orange <<a href="mailto:gregory.orange@pawsey.org.au">gregory.orange@pawsey.org.au</a>> napsal:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Solution: Manually revert the database schema changes.<br>
<br>
We found that `neutron-db-manage downgrade` has been unsupported for <br>
quite some time, so that avenue was closed to us. So, we restored <br>
backups of before and after to some temporary mariadb servers, to look <br>
at and compare the data. In the end this is how we reverted it (mysql < <br>
revert_wallaby_schema.sql):<br>
<br>
use neutron<br>
<br>
alter table address_scopes alter column shared drop default;<br>
alter table meteringlabelrules drop column source_ip_prefix;<br>
alter table meteringlabelrules drop column destination_ip_prefix;<br>
alter table ml2_vlan_allocations drop constraint <br>
check_ml2_vlan_allocations0vlan_id;<br>
alter table networkdhcpagentbindings drop index <br>
uniq_network_dhcp_agent_binding0network_id0binding_index0;<br>
alter table networkdhcpagentbindings drop column binding_index;<br>
alter table networks modify mtu int(11) null default null;<br>
alter table portforwardings drop constraint portforwardings_ibfk_3;<br>
alter table portforwardings drop index <br>
uniq_portforwardings0standard_attr_id;<br>
alter table portforwardings drop column standard_attr_id;<br>
alter table portuplinkstatuspropagation alter column <br>
propagate_uplink_status set default 0;<br>
alter table quotas drop index uniq_quotas0project_id0resource;<br>
alter table securitygroups drop constraint CONSTRAINT_1;<br>
alter table securitygroups drop column stateful;<br>
alter table securitygrouprules drop constraint securitygrouprules_ibfk_4;<br>
alter table securitygrouprules drop column remote_address_group_id;<br>
alter table subnetpools alter column shared drop default;<br>
alter table subnets drop constraint CONSTRAINT_1;<br>
alter table subnets drop column in_use;<br>
<br>
update alembic_version set version_num='c613d0b82681' where <br>
version_num='6135a7bd4425';<br>
<br>
drop table address_associations;<br>
drop table addressgrouprbacs;<br>
drop table address_groups;<br>
drop table addressscoperbacs;<br>
drop table dvr_fip_gateway_port_network;<br>
drop table network_subnet_lock;<br>
drop table ovn_hash_ring;<br>
drop table ovn_revision_numbers;<br>
drop table portdeviceprofiles;<br>
drop table portnumaaffinitypolicies;<br>
drop table subnet_dns_publish_fixed_ips;<br>
drop table subnetpoolrbacs;<br>
<br>
<br>
And everything is fine again.<br>
<br>
Greg.<br>
<br>
</blockquote></div>