Pessoal,
Eu coloco um comando pra rodar 1 só vez, só que ele aparece no log várias
vezes . Qual o motivo disso?
...
2017-02-13 22:06:58 BRT [41505]: [7-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 STATEMENT: delete from jbpm_variableinstance va1
where id_ in
(
select va.id_ from jbpm_variableinstance va inner join
jbpm_processinstance pi on pi.id_ = va.processinstance_
where pi.end_ is not null and va.name_ <> 'processo'
);
2017-02-13 22:07:00 BRT [41505]: [8-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 LOG: temporary file: path
"base/pgsql_tmp/pgsql_tmp41505.3", size 205767540
2017-02-13 22:07:00 BRT [41505]: [9-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 STATEMENT: delete from jbpm_variableinstance va1
where id_ in
(
select va.id_ from jbpm_variableinstance va inner join
jbpm_processinstance pi on pi.id_ = va.processinstance_
where pi.end_ is not null and va.name_ <> 'processo'
);
2017-02-13 22:07:00 BRT [41505]: [10-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 LOG: temporary file: path
"base/pgsql_tmp/pgsql_tmp41505.1", size 50221908
2017-02-13 22:07:00 BRT [41505]: [11-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 STATEMENT: delete from jbpm_variableinstance va1
where id_ in
(
select va.id_ from jbpm_variableinstance va inner join
jbpm_processinstance pi on pi.id_ = va.processinstance_
where pi.end_ is not null and va.name_ <> 'processo'
);
2017-02-13 22:07:02 BRT [41505]: [12-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 LOG: temporary file: path
"base/pgsql_tmp/pgsql_tmp41505.5", size 205596600
2017-02-13 22:07:02 BRT [41505]: [13-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 STATEMENT: delete from jbpm_variableinstance va1
where id_ in
(
select va.id_ from jbpm_variableinstance va inner join
jbpm_processinstance pi on pi.id_ = va.processinstance_
where pi.end_ is not null and va.name_ <> 'processo'
);
2017-02-13 22:07:02 BRT [41505]: [14-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 LOG: temporary file: path
"base/pgsql_tmp/pgsql_tmp41505.0", size 50315436
2017-02-13 22:07:02 BRT [41505]: [15-1] db=pje_jud1g_p,user=postgres@[local]
473469910:19/1064611 STATEMENT: delete from jbpm_variableinstance va1
where id_ in
(
select va.id_ from jbpm_variableinstance va inner join
jbpm_processinstance pi on pi.id_ = va.processinstance_
where pi.end_ is not null and va.name_ <> 'processo'
);
...
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
