Open Stack

On Tue, May 18, 2021 at 16:10, Herve Beraud <hberaud at redhat.com> wrote:
> Hello,
> 
> SQLAlchemy 1.4 requested some adaptations in various places (oslo.db, 
> nova, cinder etc).
> 
> Without digging into your issue, oslo.db 8.6.0 at least is required 
> to support this version of SQLAlchemy [1].
> 
> Also you should notice that various patches are required on Nova and 
> other services too [2][3][4][5]. I think that the services 
> deliverables (nova, cinder, etc) should be released to propagate 
> their fixes more widely and surely fix your context.
> 
> For further reading please have a look to [6].
> 
> [1] https://review.opendev.org/c/openstack/releases/+/788488
> [2] https://review.opendev.org/c/openstack/nova/+/788471
> [3] https://review.opendev.org/c/openstack/placement/+/789921
> [4] https://review.opendev.org/c/openstack/masakari/+/790216
> [5] https://review.opendev.org/c/openstack/cinder/+/790797
> [6] https://review.opendev.org/c/openstack/requirements/+/788339
> 
> Le mar. 18 mai 2021 à 13:57, tjoen <tjoen at dds.nl> a écrit :
>> Python-3.9.4
>>  nova-23.0.1
>>  oslo.db-8.5.0
>>  SQLAlchemy-1.4.15
>> 

Please note that Nova on stable/wallaby does not officially support 
SQLAlchemy 1.4 as per the global upper constraint in requirements 
https://github.com/openstack/requirements/blob/stable/wallaby/upper-constraints.txt#L150

Cheers,
gibi

>> 
>> docs.openstack.org/install-guide/launch-instance-provider.html
>>  $ openstack server list
>>  Status is SHUTDOWN
>>  $ openstack server start provider-instance
>>  results in
>>  site-packages/oslo_db/sqlalchemy/update_match.py", line 489, in
>>     _update_context.statement.froms[0]
>>  ERROR nova.api.openstack.wsgi AttributeError: 'QueryContext' object
>>            has no attribute 'statement'
>> 
>>  site-packages/oslo_db/sqlalchemy/update_match.py  line 488 and 489:
>>       context = query._compile_context()
>>       primary_table = context.statement.froms[0]
>> 
>>  site-packages/sqlalchemy/orm/query.py
>>       def _compile_context(self, for_statement=False):
>>           compile_state = 
>> self._compile_state(for_statement=for_statement)
>>           context = QueryContext(
>>           context = QueryContext(
>>               compile_state,
>>               compile_state.statement,
>>               self._params,
>>               self.session,
>>               self.load_options,
>>           )
>>           return context
>> 
>>  nova, oslo.db or SQLAlchemy bug?
>> 
> 
> 
> --
> Hervé Beraud
> Senior Software Engineer at Red Hat
> irc: hberaud
> https://github.com/4383/
> https://twitter.com/4383hberaud
> -----BEGIN PGP SIGNATURE-----
> 
> wsFcBAABCAAQBQJb4AwCCRAHwXRBNkGNegAALSkQAHrotwCiL3VMwDR0vcja10Q+
> Kf31yCutl5bAlS7tOKpPQ9XN4oC0ZSThyNNFVrg8ail0SczHXsC4rOrsPblgGRN+
> RQLoCm2eO1AkB0ubCYLaq0XqSaO+Uk81QxAPkyPCEGT6SRxXr2lhADK0T86kBnMP
> F8RvGolu3EFjlqCVgeOZaR51PqwUlEhZXZuuNKrWZXg/oRiY4811GmnvzmUhgK5G
> 5+f8mUg74hfjDbR2VhjTeaLKp0PhskjOIKY3vqHXofLuaqFDD+WrAy/NgDGvN22g
> glGfj472T3xyHnUzM8ILgAGSghfzZF5Skj2qEeci9cB6K3Hm3osj+PbvfsXE/7Kw
> m/xtm+FjnaywZEv54uCmVIzQsRIm1qJscu20Qw6Q0UiPpDFqD7O6tWSRKdX11UTZ
> hwVQTMh9AKQDBEh2W9nnFi9kzSSNu4OQ1dRMcYHWfd9BEkccezxHwUM4Xyov5Fe0
> qnbfzTB1tYkjU78loMWFaLa00ftSxP/DtQ//iYVyfVNfcCwfDszXLOqlkvGmY1/Y
> F1ON0ONekDZkGJsDoS6QdiUSn8RZ2mHArGEWMV00EV5DCIbCXRvywXV43ckx8Z+3
> B8qUJhBqJ8RS2F+vTs3DTaXqcktgJ4UkhYC2c1gImcPRyGrK9VY0sCT+1iA+wp/O
> v6rDpkeNksZ9fFSyoY2o
> =ECSj
> -----END PGP SIGNATURE-----
>