Comments (7)
The cache lookup failed
error is definitely familiar to me, as we occasionally see it during some of our nightly maintenance tasks where we're recreating views.
Maybe these queries shouldn't be reflecting the entire schema at all, and we should limit them to looking only at individual tables if the current broad approach can cause errors and isn't actually allowing us to reuse the reflection cache for multiple tables.
from sqlalchemy-redshift.
I think it is allowing reuse of the results of the reflection query, as discussed in #101. However, yes, it is sometimes causing errors. We think that restricting the queries to the correct schema will resolve our issue, but there may be cases where even that isn't enough.
from sqlalchemy-redshift.
We've also had this issue. Any idea on merge timing for the above PR?
from sqlalchemy-redshift.
Looks like there were some lingering issues in #105 that never got resolved. Do you have any thoughts on how those could be addressed?
from sqlalchemy-redshift.
Still seeing error 1 in 2018/almost 2019. The problem goes away when a background job that drops tables is completed.
@jklukas any update on PR #105 it looks like it was never merged?
from sqlalchemy-redshift.
I haven't been working with Redshift much in the past year, so it's difficult for me to jump back in and spin up the context to understand whether #105 is safe to merge or not. It's probably worth starting from scratch at this point.
It looks like we'll be merging #147 imminently, which is a simpler change to reflection which may or may not help with this issue. I'd be very open to someone evaluating whether #147 has a bearing here and if needed opening a fresh PR that absorbs the proposal and discussion in #105.
from sqlalchemy-redshift.
Still seeing this in 0.7.9 .... Any idea of a workaround in the meantime ? Those issues have been opened for years now
from sqlalchemy-redshift.
Related Issues (20)
- Log handler added in v0.8.13 produces duplicate logs in application
- Regression in v0.8.13: table reflection broken for non-superusers HOT 2
- Do not run integration tests with dbuser having elevated permissions HOT 1
- Migration error: 'Relation "alembic_version" already exists'
- Alembic migration issue: alter table
- Alembic migrations use RETURNING on update
- Performance degradation and memory peaks when updating from 0.8.12
- Class method needs updating HOT 1
- Table Reflection Slowness
- Temp Table Reflection
- Programming Error with percentile_cont HOT 1
- statements save OIDs unless commited
- Proposal: Remove pkg_resources from the fast path
- Any way to support sqlalchemy >= 2.0? HOT 3
- util.text_type issue HOT 1
- attach query group while running redshift queries
- Reflection does not populate primary key column if its name requres to be enclosed in double quotes
- sqlalchemy-redshift installing older SQLAlchemy version HOT 2
- get_table_oid results in an error for external tables
- Please update this library to support sqlalchemy 2.*
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlalchemy-redshift.