W3C home > Mailing lists > Public > public-annotea-dev@w3.org > January to March 2004

Re: iggy server semi-functional

From: Eric Prud'hommeaux <eric@w3.org>
Date: Tue, 16 Mar 2004 20:39:42 -0500
To: public-annotation-dev@w3.org
Message-ID: <20040317013942.GE31175@w3.org>

On Tue, Mar 16, 2004 at 08:13:11PM -0500, Eric Prud'hommeaux wrote:
> 
> still cound't sleep
> 
> On Tue, Mar 16, 2004 at 05:22:52PM -0500, Eric Prud'hommeaux wrote:
> > 
> > i haven't checked out the reply queries.

hmm, there seems to be something locking up the server when i do
this on a server with lots of triples (i wrote some queries to 
import all the old annotations into the new tables).
best not try replying for now. if you do, and the server stops
responding, log into iggy and do
  mysqladmin processlist

You should see the one using up all the resources, ala:
# mysqladmin processlist
+-----+------+-----------+------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
| Id  | User | Host      | db   | Command | Time  | State        | Info                                                                                                 |
+-----+------+-----------+------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
| 157 | root | localhost | iggy | Sleep   | 27390 |              |                                                                                                      |
| 409 | root | localhost | iggy | Sleep   | 15645 |              |                                                                                                      |
| 850 | root | localhost | iggy | Query   | 7     | Sending data | SELECT STRAIGHT_JOIN count(*)
FROM __Holds__ AS __Holds___0
     INNER JOIN __Nodes__ AS __Nodes___0 |
| 862 | root | localhost |      | Query   | 0     |              | show processlist                                                                                     |
+-----+------+-----------+------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
# mysqladmin kill 850


> > haven't formulated the DC1.0/1.1 flexible queries.
> 
> done
> 
> > attribution queries fail.
> > the program is actually just a small brick with a bow and wrapping paper.
> > 
> > apart from that, all set!
> > -- 
> > -eric
> > 
> > office: +81.466.49.1170 W3C, Keio Research Institute at SFC,
> >                         Shonan Fujisawa Campus, Keio University,
> >                         5322 Endo, Fujisawa, Kanagawa 252-8520
> >                         JAPAN
> >         +1.617.258.5741 NE43-344, MIT, Cambridge, MA 02144 USA
> > cell:   +1.857.222.5741 (does not work in Asia)
> > 
> > (eric@w3.org)
> > Feel free to forward this message to any list for any purpose other than
> > email address distribution.
> 
> -- 
> -eric
> 
> office: +81.466.49.1170 W3C, Keio Research Institute at SFC,
>                         Shonan Fujisawa Campus, Keio University,
>                         5322 Endo, Fujisawa, Kanagawa 252-8520
>                         JAPAN
>         +1.617.258.5741 NE43-344, MIT, Cambridge, MA 02144 USA
> cell:   +1.857.222.5741 (does not work in Asia)
> 
> (eric@w3.org)
> Feel free to forward this message to any list for any purpose other than
> email address distribution.

-- 
-eric

office: +81.466.49.1170 W3C, Keio Research Institute at SFC,
                        Shonan Fujisawa Campus, Keio University,
                        5322 Endo, Fujisawa, Kanagawa 252-8520
                        JAPAN
        +1.617.258.5741 NE43-344, MIT, Cambridge, MA 02144 USA
cell:   +1.857.222.5741 (does not work in Asia)

(eric@w3.org)
Feel free to forward this message to any list for any purpose other than
email address distribution.
Received on Tuesday, 16 March 2004 20:40:05 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Monday, 6 April 2009 12:36:55 GMT