API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 31st, 2013
11
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.27 KB | None | 0 0
raw download clone embed print report
  1. Aug 31 21:46:42 localhost tagsistant[5272]: SQL connection established [@sql.c:289]
  2. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
  3. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:344: [create table if not exists tags (tag_id integer primary key autoincrement not null, tagname varchar(65) unique not null);] [@sql.c:418]
  4. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:345: [create table if not exists objects (inode integer not null primary key autoincrement, objectname text(255) not null, last_autotag timestamp not null default 0, checksum text(40) not null default "", symlink text(1024) not null default "");] [@sql.c:418]
  5. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:346: [create table if not exists tagging (inode integer not null, tag_id integer not null, constraint Tagging_key unique (inode, tag_id));] [@sql.c:418]
  6. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:347: [create table if not exists relations(relation_id integer primary key autoincrement not null, tag1_id integer not null, relation varchar not null, tag2_id integer not null);] [@sql.c:418]
  7. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:349: [create index if not exists relations_index on relations (tag1_id, tag2_id);] [@sql.c:418]
  8. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:350: [create index if not exists objectname_index on objects (objectname);] [@sql.c:418]
  9. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:351: [create index if not exists symlink_index on objects (symlink, inode);] [@sql.c:418]
  10. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:352: [create index if not exists relations_type_index on relations (relation);] [@sql.c:418]
  11. Aug 31 21:46:42 localhost tagsistant[5272]: SQL from sql.c:371: [commit] [@sql.c:418]
  12. Aug 31 21:46:43 localhost tagsistant[5275]: SQL connection established [@sql.c:289]
  13. Aug 31 21:46:45 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".git" limit 1] [@sql.c:418]
  14. Aug 31 21:46:45 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".git" limit 1] [@sql.c:418]
  15. Aug 31 21:46:45 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "objects" limit 1] [@sql.c:418]
  16. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "video" limit 1] [@sql.c:418]
  17. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
  18. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from sql.c:562: [insert into tags(tagname) values("video");] [@sql.c:418]
  19. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from path_resolution.c:1084: [commit] [@sql.c:418]
  20. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "video" limit 1] [@sql.c:418]
  21. Aug 31 21:46:46 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  22. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "work" limit 1] [@sql.c:418]
  23. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
  24. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from sql.c:562: [insert into tags(tagname) values("work");] [@sql.c:418]
  25. Aug 31 21:46:46 localhost tagsistant[5275]: SQL from path_resolution.c:1084: [commit] [@sql.c:418]
  26. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "work" limit 1] [@sql.c:418]
  27. Aug 31 21:46:47 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  28. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "hq" limit 1] [@sql.c:418]
  29. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
  30. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:562: [insert into tags(tagname) values("hq");] [@sql.c:418]
  31. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from path_resolution.c:1084: [commit] [@sql.c:418]
  32. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "hq" limit 1] [@sql.c:418]
  33. Aug 31 21:46:47 localhost tagsistant[5275]: Returning integer: 3 [@sql.c:527]
  34. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "lq" limit 1] [@sql.c:418]
  35. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
  36. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:562: [insert into tags(tagname) values("lq");] [@sql.c:418]
  37. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from path_resolution.c:1084: [commit] [@sql.c:418]
  38. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "lq" limit 1] [@sql.c:418]
  39. Aug 31 21:46:47 localhost tagsistant[5275]: Returning integer: 4 [@sql.c:527]
  40. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "thumbs" limit 1] [@sql.c:418]
  41. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
  42. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:562: [insert into tags(tagname) values("thumbs");] [@sql.c:418]
  43. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from path_resolution.c:1084: [commit] [@sql.c:418]
  44. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "thumbs" limit 1] [@sql.c:418]
  45. Aug 31 21:46:47 localhost tagsistant[5275]: Returning integer: 5 [@sql.c:527]
  46. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".git" limit 1] [@sql.c:418]
  47. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".git" limit 1] [@sql.c:418]
  48. Aug 31 21:46:47 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = "objects" limit 1] [@sql.c:418]
  49. Aug 31 21:46:58 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  50. Aug 31 21:46:58 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".hidden" limit 1] [@sql.c:418]
  51. Aug 31 21:46:59 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  52. Aug 31 21:46:59 localhost tagsistant[5275]: SQL from reasoner.c:167: [select tags2.tagname from relations join tags as tags1 on tags1.tag_id = relations.tag1_id join tags as tags2 on tags2.tag_id = relations.tag2_id where tags1.tagname = "video" union all select tags1.tagname from relations join tags as tags1 on tags1.tag_id = relations.tag1_id join tags as tags2 on tags2.tag_id = relations.tag2_id where tags2.tagname = "video" and relation = "is_equivalent";] [@sql.c:418]
  53. Aug 31 21:46:59 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".hidden" limit 1] [@sql.c:418]
  54. Aug 31 21:47:00 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  55. Aug 31 21:47:00 localhost tagsistant[5275]: SQL from reasoner.c:167: [select tags2.tagname from relations join tags as tags1 on tags1.tag_id = relations.tag1_id join tags as tags2 on tags2.tag_id = relations.tag2_id where tags1.tagname = "hq" union all select tags1.tagname from relations join tags as tags1 on tags1.tag_id = relations.tag1_id join tags as tags2 on tags2.tag_id = relations.tag2_id where tags2.tagname = "hq" and relation = "is_equivalent";] [@sql.c:418]
  56. Aug 31 21:47:00 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".hidden" limit 1] [@sql.c:418]
  57. Aug 31 21:47:01 localhost tagsistant[5275]: SQL from path_resolution.c:1335: [create view tv00007f506c008a80 as select objectname, objects.inode as inode from objects join tagging on tagging.inode = objects.inode join tags on tags.tag_id = tagging.tag_id where tagname in ("video") intersect select objectname, objects.inode as inode from objects join tagging on tagging.inode = objects.inode join tags on tags.tag_id = tagging.tag_id where tagname in ("hq") ] [@sql.c:418]
  58. Aug 31 21:47:01 localhost tagsistant[5275]: SQL from path_resolution.c:1356: [select objectname, inode from tv00007f506c008a80] [@sql.c:418]
  59. Aug 31 21:47:01 localhost tagsistant[5275]: SQL from path_resolution.c:1363: [drop view tv00007f506c008a80] [@sql.c:418]
  60. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = "[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  61. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = "[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  62. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = "[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  63. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = "[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  64. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
  65. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = "[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  66. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = "[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  67. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from utils.c:176: [insert into objects (objectname) values ("[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv")] [@sql.c:418]
  68. Aug 31 21:47:06 localhost tagsistant[5275]: Tagging object 1 as video (1) [@sql.c:686]
  69. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from sql.c:688: [insert into tagging(tag_id, inode) values("1", "1");] [@sql.c:418]
  70. Aug 31 21:47:06 localhost tagsistant[5275]: Tagging object 1 as hq (3) [@sql.c:686]
  71. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from sql.c:688: [insert into tagging(tag_id, inode) values("3", "1");] [@sql.c:418]
  72. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from path_resolution.c:1084: [commit] [@sql.c:418]
  73. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = "[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  74. Aug 31 21:47:06 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  75. Aug 31 21:47:06 localhost tagsistant[5275]: SQL from fuse_operations/open.c:65: [update objects set checksum = "" where inode = 1] [@sql.c:418]
  76. Aug 31 21:47:07 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".hidden" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  77. Aug 31 21:47:07 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".hidden" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  78. Aug 31 21:47:08 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  79. Aug 31 21:47:08 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  80. Aug 31 21:47:08 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  81. Aug 31 21:47:08 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  82. Aug 31 21:47:08 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  83. Aug 31 21:47:08 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  84. Aug 31 21:47:08 localhost tagsistant[5275]: SQL connection established [@sql.c:289]
  85. Aug 31 21:47:08 localhost tagsistant[5275]: SQL connection established [@sql.c:289]
  86. Aug 31 21:47:08 localhost tagsistant[5275]: SQL connection established [@sql.c:289]
  87. Aug 31 21:47:08 localhost tagsistant[5275]: SQL connection established [@sql.c:289]
  88. Aug 31 21:47:08 localhost tagsistant[5275]: SQL connection established [@sql.c:289]
  89. Aug 31 21:47:08 localhost tagsistant[5275]: SQL connection established [@sql.c:289]
  90. Aug 31 21:47:08 localhost tagsistant[5275]: SQL connection established [@sql.c:289]
  91. Aug 31 21:47:08 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  92. Aug 31 21:47:08 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  93. Aug 31 21:47:09 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  94. Aug 31 21:47:09 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  95. Aug 31 21:47:09 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  96. Aug 31 21:47:09 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  97. Aug 31 21:47:09 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  98. Aug 31 21:47:09 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  99. Aug 31 21:47:10 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  100. Aug 31 21:47:10 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  101. Aug 31 21:47:10 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  102. Aug 31 21:47:10 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  103. Aug 31 21:47:10 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  104. Aug 31 21:47:10 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  105. Aug 31 21:47:10 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  106. Aug 31 21:47:10 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  107. Aug 31 21:47:11 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  108. Aug 31 21:47:11 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  109. Aug 31 21:47:11 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  110. Aug 31 21:47:11 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  111. Aug 31 21:47:11 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  112. Aug 31 21:47:11 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  113. Aug 31 21:47:11 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  114. Aug 31 21:47:11 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  115. Aug 31 21:47:12 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  116. Aug 31 21:47:12 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  117. Aug 31 21:47:12 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".hidden" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  118. Aug 31 21:47:12 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".hidden" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  119. Aug 31 21:47:12 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  120. Aug 31 21:47:12 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  121. Aug 31 21:47:12 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  122. Aug 31 21:47:12 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  123. Aug 31 21:47:12 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  124. Aug 31 21:47:12 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  125. Aug 31 21:47:13 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  126. Aug 31 21:47:13 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  127. Aug 31 21:47:13 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  128. Aug 31 21:47:13 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  129. Aug 31 21:47:13 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  130. Aug 31 21:47:13 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  131. Aug 31 21:47:13 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  132. Aug 31 21:47:13 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  133. Aug 31 21:47:14 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  134. Aug 31 21:47:14 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  135. Aug 31 21:47:14 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  136. Aug 31 21:47:14 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  137. Aug 31 21:47:14 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  138. Aug 31 21:47:14 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  139. Aug 31 21:47:14 localhost tagsistant[5275]: SQL from path_resolution.c:1335: [create view tv00007f5044307a90 as select objectname, objects.inode as inode from objects join tagging on tagging.inode = objects.inode join tags on tags.tag_id = tagging.tag_id where tagname in ("video") intersect select objectname, objects.inode as inode from objects join tagging on tagging.inode = objects.inode join tags on tags.tag_id = tagging.tag_id where tagname in ("hq") ] [@sql.c:418]
  140. Aug 31 21:47:14 localhost tagsistant[5275]: SQL from path_resolution.c:1356: [select objectname, inode from tv00007f5044307a90] [@sql.c:418]
  141. Aug 31 21:47:14 localhost tagsistant[5275]: SQL from path_resolution.c:1363: [drop view tv00007f5044307a90] [@sql.c:418]
  142. Aug 31 21:47:27 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  143. Aug 31 21:47:27 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  144. Aug 31 21:47:27 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".hidden" limit 1] [@sql.c:418]
  145. Aug 31 21:47:27 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".hidden" limit 1] [@sql.c:418]
  146. Aug 31 21:47:28 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  147. Aug 31 21:47:28 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  148. Aug 31 21:47:28 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".hidden" limit 1] [@sql.c:418]
  149. Aug 31 21:47:28 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  150. Aug 31 21:47:30 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  151. Aug 31 21:47:30 localhost tagsistant[5275]: SQL from reasoner.c:167: [select tags2.tagname from relations join tags as tags1 on tags1.tag_id = relations.tag1_id join tags as tags2 on tags2.tag_id = relations.tag2_id where tags1.tagname = "work" union all select tags1.tagname from relations join tags as tags1 on tags1.tag_id = relations.tag1_id join tags as tags2 on tags2.tag_id = relations.tag2_id where tags2.tagname = "work" and relation = "is_equivalent";] [@sql.c:418]
  152. Aug 31 21:47:30 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".hidden" limit 1] [@sql.c:418]
  153. Aug 31 21:47:31 localhost tagsistant[5275]: SQL from fuse_operations/readdir.c:145: [select tagname from tags;] [@sql.c:418]
  154. Aug 31 21:47:31 localhost tagsistant[5275]: SQL from sql.c:632: [select tag_id from tags where tagname = ".hidden" limit 1] [@sql.c:418]
  155. Aug 31 21:47:31 localhost tagsistant[5275]: SQL from path_resolution.c:1335: [create view tv00007f505c32dfc0 as select objectname, objects.inode as inode from objects join tagging on tagging.inode = objects.inode join tags on tags.tag_id = tagging.tag_id where tagname in ("work") intersect select objectname, objects.inode as inode from objects join tagging on tagging.inode = objects.inode join tags on tags.tag_id = tagging.tag_id where tagname in ("hq") ] [@sql.c:418]
  156. Aug 31 21:47:31 localhost tagsistant[5275]: SQL from path_resolution.c:1356: [select objectname, inode from tv00007f505c32dfc0] [@sql.c:418]
  157. Aug 31 21:47:31 localhost tagsistant[5275]: SQL from path_resolution.c:1363: [drop view tv00007f505c32dfc0] [@sql.c:418]
  158. Aug 31 21:47:33 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = "[Exiled-Destiny]_To-Love-Ru_Ep01_Subbed_(3FF30C22).mkv" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  159. Aug 31 21:47:33 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  160. Aug 31 21:47:33 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".hidden" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  161. Aug 31 21:47:33 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".hidden" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  162. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from fuse_operations/open.c:65: [update objects set checksum = "" where inode = 1] [@sql.c:418]
  163. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".goutputstream-F7DZ2W" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  164. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".goutputstream-F7DZ2W" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  165. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
  166. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".goutputstream-F7DZ2W" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  167. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".goutputstream-F7DZ2W" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  168. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from utils.c:176: [insert into objects (objectname) values (".goutputstream-F7DZ2W")] [@sql.c:418]
  169. Aug 31 21:47:35 localhost tagsistant[5275]: Tagging object 2 as work (2) [@sql.c:686]
  170. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from sql.c:688: [insert into tagging(tag_id, inode) values("2", "2");] [@sql.c:418]
  171. Aug 31 21:47:35 localhost tagsistant[5275]: Tagging object 2 as hq (3) [@sql.c:686]
  172. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from sql.c:688: [insert into tagging(tag_id, inode) values("3", "2");] [@sql.c:418]
  173. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from path_resolution.c:1084: [commit] [@sql.c:418]
  174. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from path_resolution.c:376: [select objects.inode from objects join tagging on objects.inode = tagging.inode join tags on tagging.tag_id = tags.tag_id where (tags.tagname in ("hq")) and objects.objectname = ".goutputstream-F7DZ2W" group by objects.inode having count(*) >= 1 ] [@sql.c:418]
  175. Aug 31 21:47:35 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  176. Aug 31 21:47:35 localhost tagsistant[5275]: SQL from fuse_operations/open.c:65: [update objects set checksum = "" where inode = 2] [@sql.c:418]
  177. Aug 31 21:47:36 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 1 and checksum = ""] [@sql.c:418]
  178. Aug 31 21:47:36 localhost tagsistant[5275]: Returning integer: 1 [@sql.c:527]
  179. Aug 31 21:47:36 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 2 and checksum = ""] [@sql.c:418]
  180. Aug 31 21:47:36 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  181. Aug 31 21:47:36 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 2 and checksum = ""] [@sql.c:418]
  182. Aug 31 21:47:36 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  183. Aug 31 21:47:37 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 2 and checksum = ""] [@sql.c:418]
  184. Aug 31 21:47:37 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  185. Aug 31 21:47:38 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 2 and checksum = ""] [@sql.c:418]
  186. Aug 31 21:47:38 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  187. Aug 31 21:47:39 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 2 and checksum = ""] [@sql.c:418]
  188. Aug 31 21:47:39 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  189. Aug 31 21:47:40 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 2 and checksum = ""] [@sql.c:418]
  190. Aug 31 21:47:40 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  191. Aug 31 21:47:41 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 2 and checksum = ""] [@sql.c:418]
  192. Aug 31 21:47:41 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  193. Aug 31 21:47:42 localhost tagsistant[5275]: SQL from fuse_operations/flush.c:52: [select inode from objects where inode = 2 and checksum = ""] [@sql.c:418]
  194. Aug 31 21:47:42 localhost tagsistant[5275]: Returning integer: 2 [@sql.c:527]
  195. Aug 31 21:47:43 localhost tagsistant[5275]: SQL from sql.c:302: [begin transaction] [@sql.c:418]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!