Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Upgrade SQLAlchemy version #4055

Closed
bari12 opened this issue Oct 2, 2020 · 0 comments
Closed

Upgrade SQLAlchemy version #4055

bari12 opened this issue Oct 2, 2020 · 0 comments
Assignees
@mlassnig @bari12
Labels
Database feature
Projects
Rucio 1.24 "Aqua Donkey"
Milestone
1.24.0

Comments

@bari12
Copy link
Member

bari12 commented Oct 2, 2020

Motivation

Upgrade to the newer version of SQLAlchemy. This will probably require some changes in the code.
@bari12 bari12 added this to the 1.24.0 "Aquadonkey" milestone Oct 2, 2020
@mlassnig mlassnig moved this from To do to In progress in Rucio 1.24 "Aqua Donkey" Oct 22, 2020
mlassnig added a commit to mlassnig/rucio that referenced this issue Nov 16, 2020
@mlassnig
Upgrade SQLAlchemy from 1.3.7 to 1.3.20; Fix rucio#4055
bf91d97 
1.3.8 had a conceptual change in the ENUM handling on PostgreSQL.
mlassnig added a commit to mlassnig/rucio that referenced this issue Nov 23, 2020
@mlassnig
Upgrade SQLAlchemy from 1.3.7 to 1.3.20; Fix rucio#4055
464f276 
1.3.8 had a conceptual change in the ENUM handling on PostgreSQL.
mlassnig added a commit to mlassnig/rucio that referenced this issue Nov 23, 2020
@mlassnig
Upgrade SQLAlchemy from 1.3.7 to 1.3.20; Fix rucio#4055
ff919d5 
1.3.8 had a conceptual change in the ENUM handling on PostgreSQL.
mlassnig added a commit to mlassnig/rucio that referenced this issue Nov 24, 2020
@mlassnig
Upgrade SQLAlchemy from 1.3.7 to 1.3.20; Fix rucio#4055
a7d090f 
1.3.8 had a conceptual change in the ENUM handling on PostgreSQL.
mlassnig added a commit to mlassnig/rucio that referenced this issue Nov 25, 2020
@mlassnig
Upgrade SQLAlchemy from 1.3.7 to 1.3.20; Fix rucio#4055
644f738 
1.3.8 had a conceptual change in the ENUM handling on PostgreSQL.
mlassnig added a commit to mlassnig/rucio that referenced this issue Nov 26, 2020
@mlassnig
Upgrade SQLAlchemy from 1.3.7 to 1.3.20; Fix rucio#4055
253807d 
1.3.8 had a conceptual change in the ENUM handling on PostgreSQL.
mlassnig added a commit to mlassnig/rucio that referenced this issue Nov 28, 2020
@mlassnig
Upgrade SQLAlchemy from 1.3.7 to 1.3.17; Fix rucio#4055
5cc5020 
1.3.8 had a conceptual change in the ENUM handling on PostgreSQL.
@bari12 bari12 closed this as completed Dec 1, 2020
Rucio 1.24 "Aqua Donkey" automation moved this from In progress to Done Dec 1, 2020
bari12 added a commit that referenced this issue Dec 1, 2020
@bari12
Merge pull request #4133 from mlassnig/feature-4055-core__upgrade_SQL…
a8343c2 
…Alchemy

Upgrade SQLAlchemy from 1.3.7 to 1.3.17; Fix #4055
maany pushed a commit to maany/rucio that referenced this issue Jan 21, 2021
@mlassnig @maany
Upgrade SQLAlchemy from 1.3.7 to 1.3.17; Fix rucio#4055
4aed884 
1.3.8 had a conceptual change in the ENUM handling on PostgreSQL.
bari12 pushed a commit that referenced this issue Jun 22, 2021
@bziemons
Database: Update SQLAlchemy to 1.4 (#4694)
f67f1dc 
#4055 
* Core & Internals: Fix record_counter usages on db errors

* Database: Fix oracle hint for list_replicas_for_files

The hint was on a field and the query was compiled without selecting the
dialect. Scanning through the code base, this seems to be the only
occurrance with these problems.

* Database: Update SQLAlchemy to 1.4

* Replace query_bunches with Result.partitions

https://docs.sqlalchemy.org/en/14/core/connections.html?highlight=partition#sqlalchemy.engine.Result.partitions

* Query the table instead of a column when deleting/updating

* Add synchronize_session to nested update queries

* Add try_drop_constraint for oracle

* Fix deprecation warning from empty 'or'

* Fix delete_qos_policy

* Stop leaking database objects from core

* Fix redirect_auth_oidc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mlassnig mlassnig

@bari12 bari12

Labels
Database feature
Projects
No open projects
Rucio 1.24 "Aqua Donkey"
Done
Milestone
1.24.0
Development

No branches or pull requests
2 participants
@mlassnig @bari12