On Mon, Aug 17, 2009 at 11:36 AM, Glyn Astill<[email protected]> wrote:
> ----- Original Message ----
>
>> From: Jaime Casanova <[email protected]>
>> To: [email protected]
>> Sent: Monday, 17 August, 2009 16:35:01
>> Subject: [slony1-general] switch from sl_log_1 to sl_log_2 never ends
>>
>> Hi,
>>
>> For some reason the switch from sl_log_1 to sl_log_2 never ends, if i
>> execute logswitch_finish() i get this "NOTICE: Slony-I: log switch to
>> sl_log_1 still in progress - sl_log_2 not truncated" and it returns -1
>> and if i execute logswitch_start() it says "ERROR: Previous logswitch
>> still in progress"
>>
>> right now the sl_log_* tables have grown a lot
>> relname | n_live_tup
>> -------------+--------------------
>> sl_log_1 | 392275506
>> sl_log_2 | 59708331
>>
>> this is a situation that has been like that for several days now. this
>> is slony 1.2.15...
>>
>
>
> Sorry to state the obvious, but have you checked for any open transactions
> that it might be waiting on?
>
i forgot to mention it no rows in "select * from pg_stat_activity
where waiting;"
and this query shows (as expected) different results every time i
execute it, but one of those results just a minute ago was 0 rows, so
there is nothing stronger than AccessShareLock hanging in there...
"""
SELECT client_addr as "ip cliente",
pg_stat_activity.datname as "base datos",
case pg_class.relkind when 'r' then 'Tabla' when 'i' then
'Indice' when 'S' then 'Secuencia' end as "tipo relacion",
pg_class.relname as relacion,
pg_locks.mode as "modo bloqueo",
pg_locks.granted as "bloqueo concedido",
pg_stat_activity.usename as usuario,
pg_stat_activity.current_query as "consulta origen",
to_char(pg_stat_activity.query_start,'HH24:MI:SS') as "inicio
consulta",
to_char(age(now(), pg_stat_activity.query_start),'HH24:MI:SS')
as "edad consulta",
pg_stat_activity.procpid as "id proceso"
FROM pg_stat_activity,pg_locks LEFT OUTER JOIN pg_class ON
(pg_locks.relation = pg_class.oid)
WHERE pg_locks.pid=pg_stat_activity.procpid and
pg_stat_activity.procpid <> pg_backend_pid()
and pg_locks.mode <> 'AccessShareLock'
ORDER BY 5, 10 desc;
"""
ideas?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
