Skip to content
This repository has been archived by the owner on Jul 16, 2024. It is now read-only.

Session connection changes for a same db object #200

Open
ruxuez opened this issue Jun 19, 2023 · 0 comments
Open

Session connection changes for a same db object #200

ruxuez opened this issue Jun 19, 2023 · 0 comments

Comments

@ruxuez
Copy link
Contributor

ruxuez commented Jun 19, 2023

When running multiple notebooks at the same time using GreenplumPython, the backend pid of the session has changed while the db object id remains the same. I add that there is no session disconnection happend between the changes.

Session of the starting current notebook:

BACKEND SESSION PID:  [RealDictRow([('pg_backend_pid', 11777)])]
DB OBJECT ID:  140420733129040
CREATE FUNCTION "pg_temp"."func_f8e86dfce7934fb98e098e9cc0eb75d6" (date "text") RETURNS "text" AS $$

After running several cells, the session pid has changed, which refers to another notebook's session:

BACKEND SESSION PID:  [RealDictRow([('pg_backend_pid', 11780)])]
DB OBJECT ID:  140420733129040
function pg_temp.func_f8e86dfce7934fb98e098e9cc0eb75d6(text) does not exist
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant