Project

General

Profile

Bug #546

Greyhole can't postpone tasks

Added by gboudreau almost 12 years ago. Updated almost 12 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
cpg
Category:
setup-storage
Target version:
-
Start date:
06/09/2010
Due date:
% Done:

100%

Description

When all drives are full (that's just one example), the current tasks that GH was working on will be postponed, to be retried later.

The SQL that creates the new postponed task doesn't seem to work in SQLite.

This is the SQL that returns an error:
INSERT INTO tasks (action, share, full_path, additional_info, complete) (SELECT action, share, full_path, additional_info, '%s' FROM tasks WHERE id = %d)

The following appears in the log file: "Error inserting postponed task: near "(": syntax error"
My guess is a SQLite doesn't do that kind of INSERT-as-SELECT, or uses another syntax for those.

Ref: http://forums.amahi.org/viewtopic.php?f=4&t=1461

History

#1 Updated by gboudreau almost 12 years ago

  • Category set to setup-storage
  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Fix provided by Carlos and committed in Greyhole SVN as r149: http://code.google.com/p/greyhole/source/detail?r=149

Will be included in next versions of Greyhole (0.6.12+)

Also available in: Atom