postgresql - How to get current query inside a transaction -

-

i tried current query pg_stats_activity didn't work expected.

outside transaction works:

pagetest=# select query pg_stat_activity pid = pg_backend_pid() , 1 not null;                                        query                                         ------------------------------------------------------------------------------------  select query pg_stat_activity pid = pg_backend_pid() , 1 not null; (1 row)  pagetest=# select query pg_stat_activity pid = pg_backend_pid() , 2 not null;                                        query                                         ------------------------------------------------------------------------------------  select query pg_stat_activity pid = pg_backend_pid() , 2 not null; (1 row)  pagetest=# select query pg_stat_activity pid = pg_backend_pid() , 3 not null;                                        query                                         ------------------------------------------------------------------------------------  select query pg_stat_activity pid = pg_backend_pid() , 3 not null; (1 row)

but inside transaction wrong result:

pagetest=# begin; begin pagetest=# select query pg_stat_activity pid = pg_backend_pid() , 1 not null;                                        query                                         ------------------------------------------------------------------------------------  select query pg_stat_activity pid = pg_backend_pid() , 1 not null; (1 row)  pagetest=# select query pg_stat_activity pid = pg_backend_pid() , 2 not null;                                        query                                         ------------------------------------------------------------------------------------  select query pg_stat_activity pid = pg_backend_pid() , 1 not null; (1 row)  pagetest=# select query pg_stat_activity pid = pg_backend_pid() , 3 not null;                                        query                                         ------------------------------------------------------------------------------------  select query pg_stat_activity pid = pg_backend_pid() , 1 not null; (1 row)  pagetest=# rollback pagetest-# ; rollback

it looks there strange visibility rules on stat collector views. there reasonable way around this?

try :

  begin;     select 1,current_query();     select 2,current_query();    rollback;

Comments

Post a Comment

Popular posts from this blog

ios - Is 'init' forbidden as *part* of a variable name? -

-
i spent 3 hours debugging error , in end narrowed down (i think) variable name. i using initmonths (initial months) caused unpredicatable errors when changed imonths worked! i can understand preventing use of init on it's own surprised if prevented part of variable name. bug or feature? it's not bug if it's related name being overlap. there's part of arc used know when retain counts should updated, , may running that. similar rules apply use new @ start of names (for same reason). it's easy , wise steer clear of using init @ start of names unless it's init function. i can imagine issue related arc getting involved shouldn't , takes while called shouldn't, weird. i expect issue else , name change had other effect. worst case means have memory issue , changing name has changed memory footprint of code you've moved bug somewhere else (or along lines).
Read more

javascript - Why Selenium can't find an element that is graphically visible -

-
i'm using selenium test appllication running on firefox browser, when want click on button selenium, don't find it. find strange since can see element eye. have tried multiple method worked other exemple : wait.until(expectedconditions.visibilityofelementlocated(by)) wait.until(expectedconditions.presenceofelementlocated(by)); (i use xpath in path variable, , i'm sure correct) setting implictlywait on driver putting thread.sleep(1000) then again, post here because don't understand why selenium not see element diplayed on browser. important information maybe giving me proper answer html dom dynamically generate websocket triggered javascript event. edit 1: <button type="button" class="btn btn-xs btn-block btn-stroke" id="252_button"> delete </button> the element i'm trying access. use xpath it. it's not in iframe element. to access element did method supposed find , click on giving xpath in para...
Read more

qt - Microsoft FTP Service 451 The parameter is incorrect -

-
i'm trying write ftp client. have 2 ftp servers. first server standard ftp server microsoft. second server written in organization work. program second server works well. program first server receives error: "451 parameter incorrect". can wrong? use qt 4.8.4, windows 7. ... switch(cod) { case 220: user=sett.value("userftp",qstring("anonymous")).tostring(); logmessage(codec1->tounicode("Авторизация пользователя ")+user); buf = qbytearray::fromrawdata("user ",5) + "\n"; sock->write(buf); logmessage(buf); break; ... i have found bug. used ascii. had use latin 1.
Read more