Hi, Did you use POST or GET? In order to kill a connection you should issue a POST HTTP command.
Best Regards, Luca Garulli CEO at Orient Technologies LTD the Company behind OrientDB <http://orientdb.com> On 5 June 2015 at 16:30, James Wang <[email protected]> wrote: > Sir, > > My OrientDB version 2.0.10 and just tried again: > > Command not found: http://myserver:2480/connection/kill/60 > > 60 - my new connectionId > > > http://myserver:2480/connections/kill/60 > > returned > > {"connections":[]} > > > but the slow query still runs > > > Have I done it wrongly please? > > > Thanks a lot > > > > > On Friday, 5 June 2015 15:20:13 UTC+1, l.garulli wrote: >> >> Hi, >> *connection* is the right one, not "connections". >> >> Best Regards, >> >> Luca Garulli >> CEO at Orient Technologies LTD >> the Company behind OrientDB <http://orientdb.com> >> >> On 5 June 2015 at 15:21, James Wang <[email protected]> wrote: >> >>> Found how to kill a slow query: >>> http://orientdb.com/docs/2.0/orientdb.wiki/OrientDB-REST.html >>> >>> There is a typo in the above page: connection should be connections >>> i.e. to kill query id 36, browser >>> http://yourserver:2480/connections/kill/36 >>> >>> Still to find how to timeout automatically >>> >>> Thanks >>> >>> On Friday, 5 June 2015 12:39:50 UTC+1, James Wang wrote: >>>> >>>> Hi All, >>>> >>>> How to kill a slow query from console.sh please? >>>> >>>> Also, is there a setting which automatically timeout a long slow query? >>>> >>>> Thanks a lot in advance >>>> >>>> >>>> On Thursday, 4 June 2015 09:06:28 UTC+1, James Wang wrote: >>>>> >>>>> Hi All, >>>>> >>>>> I am new to OrientDB and like it. >>>>> >>>>> I have two classes: users and userFriends >>>>> users class, with properties like name, email (unique) et al, has 9m >>>>> fake records and userFriends class >>>>> (with properties like name, group et al) has 1m fake records; >>>>> >>>>> For statistic purpose, I need to find out, for example, those who are >>>>> not John (whose @RID #12:0 in userFirends class) friends. The query I >>>>> run: >>>>> select * from users where email not in (select email from (traverse >>>>> in() from #12:0)) limit 10; >>>>> >>>>> "traverse in() from #12:0" has 20000 edges (i.e. John has 20000 >>>>> friends - too many - is it not? - just for testing ideas) >>>>> >>>>> What have I done wrong please? >>>>> >>>>> BTW, if users only has 1m records and John only has only 2000 friend, >>>>> the query "select * from users where email not in (select email from >>>>> (traverse in() from #12:0)) limit 10;" only took 0.2 seconds >>>>> >>>>> Please help >>>>> >>>>> Thanks a lot in advance >>>>> James >>>>> >>>> -- >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "OrientDB" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
