Comments (2)
Thanks for the fix!
This still fails:
postgres=# begin;
BEGIN
postgres=*# declare foocur CURSOR FOR SELECT * from foo;
DECLARE CURSOR
postgres=*# move forward 100 foocur;
MOVE 100
postgres=*# close foocur;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
TRAP: failed Assert("nested_level <= max_nested_level"), File: "src/pg_tracing.c", Line: 620, PID: 560011
postgres: heikki postgres ::1(57476) CLOSE CURSOR(ExceptionalCondition+0xaf)[0x55900b67551f]
/home/heikki/pgsql.master/lib/pg_tracing.so(+0x7272)[0x7f045eeab272]
/home/heikki/pgsql.master/lib/pg_tracing.so(+0x4cc2)[0x7f045eea8cc2]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(ExecutorFinish+0x27)[0x55900b1572d7]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(PortalCleanup+0xdd)[0x55900b0b71dd]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(PortalDrop+0x187)[0x55900b6c4e77]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(PerformPortalClose+0x156)[0x55900b0b70f6]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(standard_ProcessUtility+0x4ff)[0x55900b457b0f]
/home/heikki/pgsql.master/lib/pg_tracing.so(+0x5396)[0x7f045eea9396]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(ProcessUtility+0x132)[0x55900b4575d2]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(+0x721c7a)[0x55900b456c7a]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(+0x720e56)[0x55900b455e56]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(PortalRun+0x330)[0x55900b455410]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(+0x71b727)[0x55900b450727]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(PostgresMain+0x922)[0x55900b44f992]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(+0x713063)[0x55900b448063]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(postmaster_child_launch+0xe7)[0x55900b348867]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(+0x61a6fa)[0x55900b34f6fa]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(+0x617b99)[0x55900b34cb99]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(PostmasterMain+0x18e7)[0x55900b34bd87]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(+0x4bd7dd)[0x55900b1f27dd]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f045e24824a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f045e248305]
postgres: heikki postgres ::1(57476) CLOSE CURSOR(_start+0x21)[0x55900ae0fb21]
2024-05-07 15:28:08.445 EEST [556193] LOG: server process (PID 560011) was terminated by signal 6: Aborted
2024-05-07 15:28:08.445 EEST [556193] DETAIL: Failed process was running: close foocur;
2024-05-07 15:28:08.445 EEST [556193] LOG: terminating any other active server processes
from pg_tracing.
Thanks for the report.
I've pushed another fix that handles cursor close.
from pg_tracing.
Related Issues (7)
- Only first statement in multi-statement is traced HOT 3
- Crash on SQL comments on explicit BEGIN HOT 1
- there are memory leak with current_trace_spans. HOT 2
- measuring network time in pg tracing HOT 2
- Question: redundant computation of span_id in TracedPlanstate HOT 1
- Discussion: Supporting OTLP protocol directly HOT 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 pg_tracing.