cancelled migration query running for too long plus task_add piling up...
ActivePublic
Actions

Authored by ardumont on Jan 12 2022, 1:47 PM.

Tags

None

Subscribers

None

	insert into new_task(id, type, arguments, next_run, current_interval, status, policy,
	retries_left, priority)
	select id, type, arguments, next_run, current_interval, status, policy,
	retries_left, priority
	from task
	where (
	policy='recurring' and (type = 'load-nixguix' or
	type like 'list-%' or
	type like 'index-%')
	) or (
	policy = 'oneshot' and next_run > now() - interval '2 months'
	);
	INSERT 0 2929609
	Time: 742707.838 ms (12:22.708)
	insert into new_task_run
	select id, task, backend_id, scheduled, started, ended, metadata, status
	from task_run where task in (
	select distinct id from new_task
	);
	INSERT 0 613863
	Time: 242376.477 ms (04:02.376)

	select last_value from task_run_id_seq;
	last_value
	------------
	1424372613
	(1 row)

	Time: 0.206 ms
	alter table task rename to archive_task;
	^CCancel request sent
	psql:33.sql:64: ERROR: canceling statement due to user request
	Time: 3397101.882 ms (56:37.102)

ardumont edited the content of this paste. (Show Details)

cancelled migration query running for too long plus task_add piling up...ActivePublicActions