I just noticed that the queue table is blowing out, 200MB / 71,599 records where most of these are records for feeds_source_import.

Is it safe just to delete these? Or a conditional delete?

Root cause is likely to be bugs in domain access & filefield path modules that appear to throw constant errors when the imported nodes, but we never have investigated further.

Thanks in advance.

Comments

megachriz’s picture

megachriz
Primary language Dutch
commented
Title: Is it safe to tuncate the queue table? » Is it safe to truncate the queue table?
Issue summary: View changes
Status: Active » Fixed

It depends. Truncating the queue table means that you cancel tasks that have not be completed yet. The feeds_source_import queue is used for importing data that takes more than one cron run to complete. Deleting items from this queue effectively means that you terminate the import task. The importer will then remain in a locked state.

But you can always unlock the importer and restart the import, so it doesn't have to be a problem. If you configured an unique target in your mapping (and have "Skip hash check" unchecked on the processor settings), Feeds will skip already imported items, so restarting an import won't lead to duplicate items in this case.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.