clocking is empty

[ikegami4]

clocking is empty

[ndwarshuis]

I can't reproduce; running org-sql-user-reset and org-sql-user-update gives me one entry in the clocking table as expected. What is the value of org-clock-into-drawer for you (mine is t)?

[ikegami4]

Thank you for the response. (org-clock-into-drawer) returned "LOGBOOK" . Then, I add (setq org-clock-into-drawer t) and (org-clock-into-drawer) still returns "LOGBOOK" I am using spacemacs and I guess you are using emacs. I wonder it can be a cause. I do not want to waste your time and let us give up now.

[brunoro]

@ikegami4 I had the same issue and fixed it by setting org-clock-into-drawer to t. Note that you have to run org-sql-user-reset or make some change to your org file before trying again, as org-sql checks if files were modified since last run by comparing checksums.

[ikegami4]

@brunoro Thank you for your message. I tried it again. I think the problem is how to set org-clock-into-drawer to t on spacemacs rather than org-sql. Should I close this issue?

[ndwarshuis]

@ikegami4 please keep it open since this might be an issue with running org-sql on spacemacs. Even if it is just a simple settings issue then at the very least the documentation should be changed to alert spacemacs users to any caveats like this.

Since I'm still not sure what the problem is, do you have more precise information as to what you have tried thus far? Is there a reason (setq org-clock-into-drawer t) doesn't work on spacemacs?

[ikegami4]

@ndwarshuis sorry for my late reply. I use org layer on spacemacs https://github.com/syl20bnr/spacemacs/tree/develop/layers/+emacs/org I did not find anything which may affect org-clock-into-drawer there. I tried adding (org :variables org-clock-into-drawer t) in dotspacemacs-configuration-layers '( ) on .spacemacs. Instead, I tried adding (setq org-clock-into-drawer t) in (defun dotspacemacs/user-config ()) on .spacemacs. To check whether either of these two gives me t for org-clock-into-drawer, I wrote (org-clock-into-drawer) on *scratch* buffer, and M-x eval-defun and it returned "LOGBOOK" instead of t.

[ndwarshuis]

@ikegami4 what does M-x org-version return?

[ikegami4]

@ndwarshuis M-x org-version returns org mode version 9.3.2 9.3.2-24-g5c72d6-elpaplus @ /home/username/.emacs.d./elpa/26.3/develop/org-puls-contrib-20200203/

[ndwarshuis]

@ikegami4 ok that's one possible issue, I've only tested this with the org version that came with emacs 26.3 (which is 9.1.9). I realize I say that it was tested with 9,x but this might not be specific enough.

Before I conclude that though, one thing I don't know yet is if this affects clocking or all logbook entries. What is the output when you run org-sql-dump-update-transactions with this:

* DONE foo
:LOGBOOK:
- State "DONE"       from "TODO"       [2020-06-17 Wed 09:13]
:END:

This will put all the SQL transactions in a buffer, and there should be one to insert the DONE/TODO change into a table called 'state_changes'.

[ikegami4]

@ndwarshuis sorry I tried but I could not eval org-sql-dump-update-transactions M-x says no match and eval-defun says symbol's function defiition is void. I added your 4 lines above to .org file and M-x org-sql-user-update. It changes headlines and timestamp tables but state_changes table is empty.

[ndwarshuis]

@ikegami4 ok in that case this is no longer just about clocking since it isn't picking up on other logbook entries either. Several things:

1. what are the values of org-sql-included-logbook-types, org-sql-store-clocks, and org-sql-store-clock-notes? Unless you changed the defaults these shouldn't be the problem but we should check first.
2. what is the value of org-log-note-headings?
3. please run org-sql-user-reset before org-sql-dump-update-transactions again and paste the output here (it should be in a buffer called "SQL: Org-update-dump")

[ikegami4]

@ndwarshuis sorry for my late reply.
1.
org-sql-included-logbook-types : (done state note reschedule delschedule redeadline deldeadline refile)
org-sql-store-clocks : t
org-sql-store-clock-notes : t
The following is my setting for org-sql on .spacemacs :
(use-package org-sql :ensure t :config (setq org-sql-files '("~/Dropbox/org/test_org_sql.org")) )
2.
org-log-note-headings :
((done . "CLOSING NOTE %t") (state . "State %-12s from %-12S %t") (note . "Note taken on %t") (reschedule . "Rescheduled from %S on %t") (delschedule . "Not scheduled, was %S on %t") (redeadline . "New deadline from %S on %t") (deldeadline . "Removed deadline, was %S on %t") (refile . "Refiled on %t") (clock-out . ""))
3.
I did M-x org-sql-user-reset. M-x org-sql-dump-update-transactions still says no match.

[ndwarshuis]

@ikegami4
1 and 2 look fine. Please run (toggle-debug-on-error) and (org-sql-dump-update-transactions) non-interactively and then paste the exact error here.

[ikegami4]

@ndwarshuis
I did
M-: (toggle-debug-on-error) Enter
M-: (org-sql-dump-update-transactions) Enter
and the following is on *Backtrace* buffer:
Debugger entered--Lisp error: (void-function org-sql-dump-update-transactions) (org-sql-dump-update-transactions) eval((org-sql-dump-update-transactions) nil) eval-expression((org-sql-dump-update-transactions) nil nil 127) funcall-interactively(eval-expression (org-sql-dump-update-transactions) nil nil 127) call-interactively(eval-expression nil nil) command-execute(eval-expression)

[ndwarshuis]

@ikegami4 my bad, try that with the 'develop' branch. I forgot I only put org-sql-dump-update-transactions in there for now

[ikegami4]

@ndwarshuis sorry for my late reply... I did the followings:
clone develop branch
M-: (toggle-debug-on-error) Enter
M-: (org-sql-dump-update-transactions) Enter
and the following is on Backtrace buffer:
Debugger entered--Lisp error: (wrong-number-of-arguments (0 . 0) 1) org-sql-get-transactions(t) (-partition 2 (org-sql-get-transactions t)) (mapcar (function (lambda (it) (let ((header (car it))) (let ((header (symbol-name header))) (let ((header ...)) (format "### %s ###\n\n%s" header (car ...))))))) (-partition 2 (org-sql-get-transactions t))) (reverse (mapcar (function (lambda (it) (let ((header (car it))) (let ((header ...)) (let (...) (format "### %s ###\n\n%s" header ...)))))) (-partition 2 (org-sql-get-transactions t)))) (let ((out (reverse (mapcar (function (lambda (it) (let ... ...))) (-partition 2 (org-sql-get-transactions t)))))) (switch-to-buffer "SQL: Org-update-dump") (insert (string-join out "\n\n"))) org-sql-dump-update-transactions() eval((org-sql-dump-update-transactions) nil) eval-expression((org-sql-dump-update-transactions)) eval((eval-expression (car-safe (read-from-string #("(org-sql-dump-update-transactions)" 0 1 (ex-index 1) 1 2 (ex-index 2) 2 3 (ex-index 3) 3 4 (ex-index 4) 4 5 (ex-index 5) 5 6 (ex-index 6) 6 7 (ex-index 7) 7 8 (ex-index 8) 8 9 (ex-index 9) 9 10 (ex-index 10) 10 11 (ex-index 11) 11 12 (ex-index 12) 12 13 (ex-index 13) 13 14 (ex-index 14) 14 15 (ex-index 15) 15 16 (ex-index 16) 16 17 (ex-index 17) 17 18 (ex-index 18) 18 19 (ex-index 19) 19 20 (ex-index 20) 20 21 (ex-index 21) 21 22 (ex-index 22) 22 23 (ex-index 23) 23 24 (ex-index 24) 24 25 (ex-index 25) 25 26 (ex-index 26) 26 27 (ex-index 27) 27 28 (ex-index 28) 28 29 (ex-index 29) 29 30 (ex-index 30) 30 31 (ex-index 31) 31 32 (ex-index 32) 32 33 (ex-index 33) 33 34 (ex-index 34)))))) evil-ex-execute(#("(org-sql-dump-update-transactions)" 0 1 (ex-index 1) 1 2 (ex-index 2) 2 3 (ex-index 3) 3 4 (ex-index 4) 4 5 (ex-index 5) 5 6 (ex-index 6) 6 7 (ex-index 7) 7 8 (ex-index 8) 8 9 (ex-index 9) 9 10 (ex-index 10) 10 11 (ex-index 11) 11 12 (ex-index 12) 12 13 (ex-index 13) 13 14 (ex-index 14) 14 15 (ex-index 15) 15 16 (ex-index 16) 16 17 (ex-index 17) 17 18 (ex-index 18) 18 19 (ex-index 19) 19 20 (ex-index 20) 20 21 (ex-index 21) 21 22 (ex-index 22) 22 23 (ex-index 23) 23 24 (ex-index 24) 24 25 (ex-index 25) 25 26 (ex-index 26) 26 27 (ex-index 27) 27 28 (ex-index 28) 28 29 (ex-index 29) 29 30 (ex-index 30) 30 31 (ex-index 31) 31 32 (ex-index 32) 32 33 (ex-index 33) 33 34 (ex-index 34))) evil-ex(nil) funcall-interactively(evil-ex nil) call-interactively(evil-ex nil nil) command-execute(evil-ex)

[ndwarshuis]

@ikegami4 I can't reproduce this. Did you fully restart emacs after cloning the develop branch? That error is telling you that org-sql-get-transactions was called with one argument but expecting 0; in the develop branch it expects 1 optional argument but in the master it expects 0 arguments.

[ikegami4]

@ndwarshuis sorry I should have commented out (use-package org-sql :ensure t :config (setq org-sql-files '("~/Dropbox/org/test_org_sql.org"))
on .spacemacs. my current revised setting is
(add-to-list 'load-path "~/org_sql/") (require 'org-sql) (setq org-sql-files '("~/Dropbox/org/test_org_sql.org"))
Then I did
M-: (toggle-debug-on-error) Enter
M-: (org-sql-dump-update-transactions) Enter
and the results:
Org-update-dump.txt

[ndwarshuis]

@ikegami4 which org file did you use when you ran the dump? The output shows many more timestamps and headlines than the file in the OP.

[ikegami4]

@ndwarshuis the attached .org.txt file below. I needed to add .txt to attach.
test_org_sql.org.txt

[ikegami4]

@ndwarshuis Let me redo with the simple .org you gave on June 18 above
Then I did
M-x org-sql-user-reset
M-x org-sql-dump-update-transactions
and the results:

sql_org_update_dump_1.txt

and I can see the correct 3 entries in timestamp table but clocking table is empty

[ndwarshuis]

@ikegami4 I'm actually more interested in the larger org file vs the one in the OP. If I run that on my system I get the following:

### DELETE ###

nil

### UPDATE ###

nil

### INSERT ###

pragma defer_foreign_keys=on;
begin transaction;
insert into state_changes (file_path,entry_offset,state_old,state_new) values ('~/Org/org-sql-test.org',1424,'TODO','DONE');
insert into logbook (file_path,headline_offset,entry_offset,entry_type,time_logged,header,note) values ('~/Org/org-sql-test.org',1342,1424,'state',1592399580,'State "DONE"       from "TODO"       [2020-06-17 Wed 09:13]','');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',65,121,1590760200,1590760800,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',206,263,1590817500,1590817740,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',338,394,1590817800,1590818040,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',470,521,1590815400,1590819000,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',594,650,1591622820,1591623000,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',725,781,1591623900,1591624200,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',857,908,1591624500,1591624680,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',981,1037,1591624200,1591624740,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',1112,1201,1591625820,1591625820,'');
insert into clocking (file_path,headline_offset,clock_offset,time_start,time_end,clock_note) values ('~/Org/org-sql-test.org',1112,1267,1591625400,1591625580,'');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',65,91,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1590724800,'day',NULL,NULL,'<2020-05-29 Fri>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',206,233,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1590811200,'day',NULL,NULL,'<2020-05-30 Sat>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',338,364,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1590811200,'day',NULL,NULL,'<2020-05-30 Sat>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',470,492,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1590811200,'day',NULL,NULL,'<2020-05-30 Sat>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',594,620,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591588800,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',725,751,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591588800,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',857,879,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591588800,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',981,1007,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591588800,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',1112,1138,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591588800,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',1342,1363,'inactive','closed',NULL,NULL,NULL,NULL,NULL,NULL,1592588760,'minute',NULL,NULL,'[2020-06-19 Fri 13:46]');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Org/org-sql-test.org',1342,1397,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1592539200,'day',NULL,NULL,'<2020-06-19 Fri>');
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',35,NULL,'test 1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',44,'/test 1','test 1.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',56,NULL,'test 2',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',65,'/test 2','test 2.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',196,NULL,'test 3',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',206,'/test 3','test 3.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',338,'/test 3','test 3.2',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',470,NULL,'test 4',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',594,'/test 4','test 4.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',725,'/test 4','test 4.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',857,NULL,'test 5',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',981,'/test 5','test 5.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',1112,'/test 5','test 5.2',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Org/org-sql-test.org',1342,NULL,'foo','DONE',NULL,NULL,0,0,NULL);
insert into files (file_path,md5,size) values ('~/Org/org-sql-test.org','6223a81d76eb46bca6d181f1bc27726a',1491);
commit;

This shows it's more than just a problem of not recognizing clocks; your last headline has a TODO -> DONE state change that is in the logbook and should have two transactions (see the first two in the output above) that aren't in yours.

Is it possible for you to try this with org-9.1.9?

[ikegami4]

@ndwarshuis I tried to redo with org-9.1.9
I followed
https://emacs.stackexchange.com/questions/54314/roll-back-org-mode-version
for downgrading org-mode (but could not follow 100% due to spacemacs instead of emacs...)
the results is

### DELETE ###

nil

### UPDATE ###

nil

### INSERT ###

pragma defer_foreign_keys=on;
begin transaction;
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',65,91,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1590678000,'day',NULL,NULL,'<2020-05-29 Fri>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',206,233,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1590764400,'day',NULL,NULL,'<2020-05-30 Sat>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',338,364,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1590764400,'day',NULL,NULL,'<2020-05-30 Sat>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',470,492,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1590764400,'day',NULL,NULL,'<2020-05-30 Sat>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',594,620,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591542000,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',725,751,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591542000,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',857,879,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591542000,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',981,1007,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591542000,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',1112,1138,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1591542000,'day',NULL,NULL,'<2020-06-08 Mon>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',1342,1463,'inactive',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1592352780,'minute',NULL,NULL,'[2020-06-17 Wed 09:13]');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',1342,1397,'active','scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1592492400,'day',NULL,NULL,'<2020-06-19 Fri>');
insert into timestamp (file_path,headline_offset,timestamp_offset,type,planning_type,warning_type,warning_value,warning_unit,repeat_type,repeat_value,repeat_unit,time,resolution,time_end,resolution_end,raw_value) values ('~/Dropbox/org/org_sql/test_org_sql.org',1342,1363,'inactive','closed',NULL,NULL,NULL,NULL,NULL,NULL,1592541960,'minute',NULL,NULL,'[2020-06-19 Fri 13:46]');
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',35,NULL,'test 1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',44,'/test 1','test 1.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',56,NULL,'test 2',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',65,'/test 2','test 2.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',196,NULL,'test 3',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',206,'/test 3','test 3.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',338,'/test 3','test 3.2',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',470,NULL,'test 4',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',594,'/test 4','test 4.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',725,'/test 4','test 4.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',857,NULL,'test 5',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',981,'/test 5','test 5.1',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',1112,'/test 5','test 5.2',NULL,NULL,NULL,0,0,NULL);
insert into headlines (file_path,headline_offset,tree_path,headline_text,keyword,effort,priority,archived,commented,content) values ('~/Dropbox/org/org_sql/test_org_sql.org',1342,NULL,'foo','DONE',NULL,NULL,0,0,NULL);
insert into files (file_path,md5,size) values ('~/Dropbox/org/org_sql/test_org_sql.org','8289fcac2cb69169c799ee20bbd19f77',1602);
commit;

[ndwarshuis]

@ikegami4 that's weird, did you confirm with org-version that this is actually on 9.1.9?

[ikegami4]

@ndwarshuis sorry for my late reply. I confirmed my trial above did not downgrade org-version to 9.1.9. I tried to downgrade org-version to 9.1.9 in several other ways but no success. I am afraid this task is beyond my knowledge on spacemacs etc. Could I give up and close this issue?

[ndwarshuis]

@ikegami4 no worries. Please keep it open because this seems like a real bug that we just haven't solved yet.

FYI, I'm going to start revamping the backend of this which should make the package more reliable and might inadvertently solve this issue. I don't have an ETA yet but if you check back later (probably a month or two) there should be some progress.