Query finished successfully, but its still running #6606
Description
Hi
Lately, pgadmin has started to do a lot of problems in the output section...
sometimes it fails to run and shows errors related to string size (although the second run works with no problem, errors like: ERROR: message contents do not agree with length in message type "N" ),
but in this case, I see a bizarre behavior,
I run plpgsql and I have RAISE INFO in it, it's working as expected, and after 16 minutes I get the same message twice and then a message that the query finished successfully and it stopped running:
but if I look at the sessions running on the pg, I actually see that it's still running! and that it's active...
just to make sure I ran the query to count how many rows my code needs to update and I see a decrease: 67555130
running it for a second time and I see another decrease: 67385113
and after those type of error occurs, if I don't open a new session window, it wont work anymore, everytime I'll run code in that session I'll get Query Finished Successfully without any error message or without the actual results
so something very strange is going over pgadmin...
I cannot replicate it, its kinda random...
I don't see anything in the log file that is related to this issue...