Обсуждение: lock problem

Richard

  Sorry for the delay.

  question, the select * from pg_stat_activity
  thows

datid|datname|procpid|usesysid|usename|current_query|query_start
52800|"sume"|30124|1|"postgres"|"<IDLE>"|"2005-09-01
13:30:02.921844-03"
52800|"sume"|30125|1|"postgres"|"<IDLE>"|"2005-09-01
13:37:21.631802-03"
52800|"sume"|30186|1|"postgres"|"SELECT
c.actuacion_car AS c_actuacion, c.comentario1 || ' '
|| c.comentario2 || ' ' || c.comentario3 AS
c_comentario FROM caratult AS c INNER JOIN extractt AS
t1 ON (c.id_extracto_car = t1.id_extracto) INNER JOIN
repartit AS r1 ON (c.id_reparticion_uc =
r"|"2005-09-01 13:35:45.152586-03"

 and the select * from pg_locks

 relation|database|transaction|pid|mode|granted
53046|52800||30186|"AccessShareLock"|t
||159274343|30125|"ExclusiveLock"|t
73744|52800||30186|"AccessShareLock"|t
16759|52800||30125|"AccessShareLock"|t
53094|52800||30186|"AccessShareLock"|t
73770|52800||30186|"AccessShareLock"|t
||159274288|30186|"ExclusiveLock"|t
73824|52800||30186|"AccessShareLock"|t
53054|52800||30186|"AccessShareLock"|t
73726|52800||30186|"AccessShareLock"|t
53074|52800||30186|"AccessShareLock"|t
53049|52800||30186|"AccessShareLock"|t
53127|52800||30186|"AccessShareLock"|t
9567503|52800||30186|"AccessShareLock"|t
74274|52800||30186|"AccessShareLock"|t

this queries show locks into 30816 pid or a'im wrong?
best regards
  MDC

 --- Richard Huxton <dev@archonet.com> escribió:

> marcelo Cortez wrote:
> > Hi Richard , folks
> >
> > the query is:
> >
> >  SELECT c.actuacion_car AS c_actuacion,
> >  c.comentario1 || ' ' || c.comentario2 || ' ' ||
> > c.comentario3 AS c_comentario
> > FROM caratult AS c INNER JOIN extractt AS t1 ON
> ...etc
>
>
> I'm not seeing anything here that should take locks,
> although it's late
> where I am.
>
> > without table definition etc, you see are selects
> > only.
> > during this  query, select * from
> pg_catalog.pg_locks
> > show many rows with exclusive locks , and other
> > activities or user's be freezed,
>
> Are you *sure* that it's this query? Could you show
> some of the rows
> from pg_locks along with corresponding rows from
> pg_stat_activity?
>
> --
>    Richard Huxton
>    Archonet Ltd
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
>

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar

hi Richard ,folks

Question: is normal this locks ?
   which is the reason of this?
 thanks for your time
  best regards
    MDC

 --- Richard Huxton <dev@archonet.com> escribió:

> marcelo Cortez wrote:
> > Richard
> >
> >   Sorry for a delay
> >
> >   question the select * from pg_stat_activity
> >   thows
> >
> >
>
datid|datname|procpid|usesysid|usename|current_query|query_start
> >
> 52800|"sume"|30124|1|"postgres"|"<IDLE>"|"2005-09-01
> > 13:30:02.921844-03"
> >
> 52800|"sume"|30125|1|"postgres"|"<IDLE>"|"2005-09-01
> > 13:37:21.631802-03"
> > 52800|"sume"|30186|1|"postgres"|"SELECT
> > c.actuacion_car AS c_actuacion, c.comentario1 || '
> '
> > || c.comentario2 || ' ' || c.comentario3 AS
> > c_comentario FROM caratult AS c INNER JOIN
> extractt AS
> > t1 ON (c.id_extracto_car = t1.id_extracto) INNER
> JOIN
> > repartit AS r1 ON (c.id_reparticion_uc =
> > r"|"2005-09-01 13:35:45.152586-03"
> >
> >  and the select * from pg_locks
> >  relation|database|transaction|pid|mode|granted
> > 53046|52800||30186|"AccessShareLock"|t
> > ||159274343|30125|"ExclusiveLock"|t
> > 73744|52800||30186|"AccessShareLock"|t
> > 16759|52800||30125|"AccessShareLock"|t
> > 53094|52800||30186|"AccessShareLock"|t
> > 73770|52800||30186|"AccessShareLock"|t
> > ||159274288|30186|"ExclusiveLock"|t
> > 73824|52800||30186|"AccessShareLock"|t
> > 53054|52800||30186|"AccessShareLock"|t
> > 73726|52800||30186|"AccessShareLock"|t
> > 53074|52800||30186|"AccessShareLock"|t
> > 53049|52800||30186|"AccessShareLock"|t
> > 53127|52800||30186|"AccessShareLock"|t
> > 9567503|52800||30186|"AccessShareLock"|t
> > 74274|52800||30186|"AccessShareLock"|t
> >
> > this queries show locks into 30816 pid or a'im
> wrong?
>
> That's right - pid=30816 is the backend running the
> SELECT
> c.actuacion_car... query (see the pg_stat_activity
> output).
>
> The only other locks mentioned are for pid=30125,
> which I think are
> where you're executing "SELECT * FROM pg_locks" -
> bit puzzled as to why
> the relation/database columns are blank though.
>
> In short - I can't see anything blocking your query.
> What error message
> was telling you that locks were causing a problem?
>
> --
>    Richard Huxton
>    Archonet Ltd
>




________________________________________________
¡Llamá y ganá!
Usá Yahoo! Messenger con Voz y participá del sorteo de un pasaje a cualquier lugar del mundo.
Inscribite aquí: http://messenger.yahoo.com/ar/

marcelo Cortez wrote:
> hi Richard ,folks
>
> Question: is normal this locks ?
>    which is the reason of this?

As I said - I don't see any locks that could cause you problems. Can you
provide the error message showing locks timing out?

--
   Richard Huxton
   Archonet Ltd