Comments (3)
elprans
commented on June 2, 2024
Do you get an error? It's not clear from the description what the actual issue is.
from asyncpg.
0ralo
commented on June 2, 2024
Do you get an error? It's not clear from the description what the actual issue is.
I got infinite loading when I execute this query. It does not even in .fetchall() but in session.execute(text()) line. Also asyncpg in python terminal with no sqlalchemy does not process query either it just stops. No logs no errors
from asyncpg.
0ralo
commented on June 2, 2024
Upd:
I cannot(?) get result even when i put query into view. Select * from view_name also stops in text() block in slqalchemy.
Upd2. I can get result, but it took long time that i was not wait before. (approximately 9 min instead of 0,269 secs in DBeaver for 35 lines)
logs:
2024-04-03 10:11:43,328 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2024-04-03 10:11:43,328 INFO sqlalchemy.engine.Engine select * from nd.get_events_15
2024-04-03 10:11:43,328 INFO sqlalchemy.engine.Engine [generated in 0.00011s] ()
2024-04-03 10:20:01,330 INFO sqlalchemy.engine.Engine ROLLBACK
query took 8m18.12 s
from asyncpg.
Related Issues (20)
- Support typed prepared statements
- issue with connection pooling when using QueuePool (via sqlalchemy) HOT 2
- Not using transactions but receiving errors with: Resetting connection with an active transaction
- Feature request: Make transaction state public
- no attribute `_aborted` on `Connection.__del__` HOT 1
- `inspect.iscoroutinefunction` returns false on pool -> connection -> execute HOT 1
- connect through socks5 proxy HOT 2
- Error: there is no unique or exclusion constraint matching the ON CONFLICT specification HOT 2
- Introspection TYPE_BY_OID running for long time HOT 3
- invalid input for query argument (can't subtract offset-naive and offset-aware datetimes)
- Feature request: Support for asynchronous command processing
- Asyncpg (asyncio/asyncpg.py, line 62, in get_query) get_query throws index error.
- no binary format encoder for type jsonb
- Whenever i create a table with a `real` column and read the value i get something different then what i saved
- insufficient data in buffer
- GCP CloudSQL Connector with asyncpg Pool
- cursor prefetch with bounded lag
- asyncpg.connect: ValueError: invalid literal for int() with base 10 HOT 1
- Connection secrets displayed in clear text in logs
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 asyncpg.