API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 8th, 2017
73
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.92 KB | None | 0 0
raw download clone embed print report
  1. 2017-05-08 15:40:54,810 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
  2. 2017-05-08 15:40:54,810 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  3. FROM playbooks
  4. 2017-05-08 15:40:54,810 INFO sqlalchemy.engine.base.Engine ()
  5. 2017-05-08 15:40:54,812 INFO sqlalchemy.engine.base.Engine SELECT playbooks.id AS playbooks_id, playbooks.path AS playbooks_path, playbooks.ansible_version AS playbooks_ansible_version, playbooks.options AS playbooks_options, playbooks.time_start AS playbooks_time_start, playbooks.time_end AS playbooks_time_end, playbooks.complete AS playbooks_complete
  6. FROM playbooks ORDER BY playbooks.time_start DESC
  7. LIMIT ? OFFSET ?
  8. 2017-05-08 15:40:54,812 INFO sqlalchemy.engine.base.Engine (10, 10)
  9. 2017-05-08 15:40:54,815 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  10. FROM (SELECT playbooks.id AS playbooks_id, playbooks.path AS playbooks_path, playbooks.ansible_version AS playbooks_ansible_version, playbooks.options AS playbooks_options, playbooks.time_start AS playbooks_time_start, playbooks.time_end AS playbooks_time_end, playbooks.complete AS playbooks_complete
  11. FROM playbooks) AS anon_1
  12. 2017-05-08 15:40:54,815 INFO sqlalchemy.engine.base.Engine ()
  13. 2017-05-08 15:40:54,816 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  14. FROM stats
  15. WHERE stats.playbook_id = ?
  16. 2017-05-08 15:40:54,816 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  17. 2017-05-08 15:40:54,818 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  18. FROM stats
  19. WHERE stats.playbook_id = ?
  20. 2017-05-08 15:40:54,818 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  21. 2017-05-08 15:40:54,819 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  22. FROM stats
  23. WHERE stats.playbook_id = ?
  24. 2017-05-08 15:40:54,819 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  25. 2017-05-08 15:40:54,820 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  26. FROM stats
  27. WHERE stats.playbook_id = ?
  28. 2017-05-08 15:40:54,820 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  29. 2017-05-08 15:40:54,860 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  30. FROM stats
  31. WHERE stats.playbook_id = ?
  32. 2017-05-08 15:40:54,860 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  33. 2017-05-08 15:40:54,861 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  34. FROM stats
  35. WHERE stats.playbook_id = ?
  36. 2017-05-08 15:40:54,862 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  37. 2017-05-08 15:40:54,863 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  38. FROM stats
  39. WHERE stats.playbook_id = ?
  40. 2017-05-08 15:40:54,863 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  41. 2017-05-08 15:40:54,864 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  42. FROM stats
  43. WHERE stats.playbook_id = ?
  44. 2017-05-08 15:40:54,864 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  45. 2017-05-08 15:40:54,865 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  46. FROM stats
  47. WHERE stats.playbook_id = ?
  48. 2017-05-08 15:40:54,865 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  49. 2017-05-08 15:40:54,866 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  50. FROM stats
  51. WHERE stats.playbook_id = ?
  52. 2017-05-08 15:40:54,866 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  53. 2017-05-08 15:40:54,867 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  54. FROM stats
  55. WHERE stats.playbook_id = ?
  56. 2017-05-08 15:40:54,867 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  57. 2017-05-08 15:40:54,868 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  58. FROM stats
  59. WHERE stats.playbook_id = ?
  60. 2017-05-08 15:40:54,868 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  61. 2017-05-08 15:40:54,869 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  62. FROM stats
  63. WHERE stats.playbook_id = ?
  64. 2017-05-08 15:40:54,869 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  65. 2017-05-08 15:40:54,870 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  66. FROM stats
  67. WHERE stats.playbook_id = ?
  68. 2017-05-08 15:40:54,870 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  69. 2017-05-08 15:40:54,871 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  70. FROM stats
  71. WHERE stats.playbook_id = ?
  72. 2017-05-08 15:40:54,871 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  73. 2017-05-08 15:40:54,872 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  74. FROM stats
  75. WHERE stats.playbook_id = ?
  76. 2017-05-08 15:40:54,872 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  77. 2017-05-08 15:40:54,874 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  78. FROM stats
  79. WHERE stats.playbook_id = ?
  80. 2017-05-08 15:40:54,874 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  81. 2017-05-08 15:40:54,875 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  82. FROM stats
  83. WHERE stats.playbook_id = ?
  84. 2017-05-08 15:40:54,875 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  85. 2017-05-08 15:40:54,876 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  86. FROM stats
  87. WHERE stats.playbook_id = ?
  88. 2017-05-08 15:40:54,876 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  89. 2017-05-08 15:40:54,877 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  90. FROM stats
  91. WHERE stats.playbook_id = ?
  92. 2017-05-08 15:40:54,877 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  93. 2017-05-08 15:40:54,878 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  94. FROM stats
  95. WHERE stats.playbook_id = ?
  96. 2017-05-08 15:40:54,878 INFO sqlalchemy.engine.base.Engine (u'a7581126-5de3-4ec7-bcce-9802378291e8',)
  97. 2017-05-08 15:40:54,879 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  98. FROM stats
  99. WHERE stats.playbook_id = ?
  100. 2017-05-08 15:40:54,879 INFO sqlalchemy.engine.base.Engine (u'a7581126-5de3-4ec7-bcce-9802378291e8',)
  101. 2017-05-08 15:40:54,880 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  102. FROM stats
  103. WHERE stats.playbook_id = ?
  104. 2017-05-08 15:40:54,880 INFO sqlalchemy.engine.base.Engine (u'a7581126-5de3-4ec7-bcce-9802378291e8',)
  105. 2017-05-08 15:40:54,881 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  106. FROM stats
  107. WHERE stats.playbook_id = ?
  108. 2017-05-08 15:40:54,881 INFO sqlalchemy.engine.base.Engine (u'a7581126-5de3-4ec7-bcce-9802378291e8',)
  109. 2017-05-08 15:40:54,882 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  110. FROM stats
  111. WHERE stats.playbook_id = ?
  112. 2017-05-08 15:40:54,882 INFO sqlalchemy.engine.base.Engine (u'a7581126-5de3-4ec7-bcce-9802378291e8',)
  113. 2017-05-08 15:40:54,883 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  114. FROM stats
  115. WHERE stats.playbook_id = ?
  116. 2017-05-08 15:40:54,884 INFO sqlalchemy.engine.base.Engine (u'cbc5b65c-5442-44c5-8086-e0ada27f524d',)
  117. 2017-05-08 15:40:54,885 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  118. FROM stats
  119. WHERE stats.playbook_id = ?
  120. 2017-05-08 15:40:54,885 INFO sqlalchemy.engine.base.Engine (u'cbc5b65c-5442-44c5-8086-e0ada27f524d',)
  121. 2017-05-08 15:40:54,886 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  122. FROM stats
  123. WHERE stats.playbook_id = ?
  124. 2017-05-08 15:40:54,886 INFO sqlalchemy.engine.base.Engine (u'cbc5b65c-5442-44c5-8086-e0ada27f524d',)
  125. 2017-05-08 15:40:54,887 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  126. FROM stats
  127. WHERE stats.playbook_id = ?
  128. 2017-05-08 15:40:54,887 INFO sqlalchemy.engine.base.Engine (u'cbc5b65c-5442-44c5-8086-e0ada27f524d',)
  129. 2017-05-08 15:40:54,888 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  130. FROM stats
  131. WHERE stats.playbook_id = ?
  132. 2017-05-08 15:40:54,888 INFO sqlalchemy.engine.base.Engine (u'cbc5b65c-5442-44c5-8086-e0ada27f524d',)
  133. 2017-05-08 15:40:54,889 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  134. FROM stats
  135. WHERE stats.playbook_id = ?
  136. 2017-05-08 15:40:54,889 INFO sqlalchemy.engine.base.Engine (u'3e1bc96e-8532-4d3b-87ac-b08512460301',)
  137. 2017-05-08 15:40:54,890 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  138. FROM stats
  139. WHERE stats.playbook_id = ?
  140. 2017-05-08 15:40:54,890 INFO sqlalchemy.engine.base.Engine (u'3e1bc96e-8532-4d3b-87ac-b08512460301',)
  141. 2017-05-08 15:40:54,891 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  142. FROM stats
  143. WHERE stats.playbook_id = ?
  144. 2017-05-08 15:40:54,891 INFO sqlalchemy.engine.base.Engine (u'3e1bc96e-8532-4d3b-87ac-b08512460301',)
  145. 2017-05-08 15:40:54,892 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  146. FROM stats
  147. WHERE stats.playbook_id = ?
  148. 2017-05-08 15:40:54,892 INFO sqlalchemy.engine.base.Engine (u'3e1bc96e-8532-4d3b-87ac-b08512460301',)
  149. 2017-05-08 15:40:54,893 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  150. FROM stats
  151. WHERE stats.playbook_id = ?
  152. 2017-05-08 15:40:54,893 INFO sqlalchemy.engine.base.Engine (u'3e1bc96e-8532-4d3b-87ac-b08512460301',)
  153. 2017-05-08 15:40:54,895 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  154. FROM stats
  155. WHERE stats.playbook_id = ?
  156. 2017-05-08 15:40:54,895 INFO sqlalchemy.engine.base.Engine (u'94327ec2-87c7-43e0-84d0-10297f76b9d6',)
  157. 2017-05-08 15:40:54,896 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  158. FROM stats
  159. WHERE stats.playbook_id = ?
  160. 2017-05-08 15:40:54,896 INFO sqlalchemy.engine.base.Engine (u'94327ec2-87c7-43e0-84d0-10297f76b9d6',)
  161. 2017-05-08 15:40:54,897 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  162. FROM stats
  163. WHERE stats.playbook_id = ?
  164. 2017-05-08 15:40:54,897 INFO sqlalchemy.engine.base.Engine (u'94327ec2-87c7-43e0-84d0-10297f76b9d6',)
  165. 2017-05-08 15:40:54,898 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  166. FROM stats
  167. WHERE stats.playbook_id = ?
  168. 2017-05-08 15:40:54,898 INFO sqlalchemy.engine.base.Engine (u'94327ec2-87c7-43e0-84d0-10297f76b9d6',)
  169. 2017-05-08 15:40:54,899 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  170. FROM stats
  171. WHERE stats.playbook_id = ?
  172. 2017-05-08 15:40:54,899 INFO sqlalchemy.engine.base.Engine (u'94327ec2-87c7-43e0-84d0-10297f76b9d6',)
  173. 2017-05-08 15:40:54,900 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  174. FROM stats
  175. WHERE stats.playbook_id = ?
  176. 2017-05-08 15:40:54,900 INFO sqlalchemy.engine.base.Engine (u'5fa0687e-37fe-4883-a199-3b294cf766fd',)
  177. 2017-05-08 15:40:54,902 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  178. FROM stats
  179. WHERE stats.playbook_id = ?
  180. 2017-05-08 15:40:54,902 INFO sqlalchemy.engine.base.Engine (u'5fa0687e-37fe-4883-a199-3b294cf766fd',)
  181. 2017-05-08 15:40:54,902 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  182. FROM stats
  183. WHERE stats.playbook_id = ?
  184. 2017-05-08 15:40:54,903 INFO sqlalchemy.engine.base.Engine (u'5fa0687e-37fe-4883-a199-3b294cf766fd',)
  185. 2017-05-08 15:40:54,903 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  186. FROM stats
  187. WHERE stats.playbook_id = ?
  188. 2017-05-08 15:40:54,904 INFO sqlalchemy.engine.base.Engine (u'5fa0687e-37fe-4883-a199-3b294cf766fd',)
  189. 2017-05-08 15:40:54,904 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  190. FROM stats
  191. WHERE stats.playbook_id = ?
  192. 2017-05-08 15:40:54,904 INFO sqlalchemy.engine.base.Engine (u'5fa0687e-37fe-4883-a199-3b294cf766fd',)
  193. 2017-05-08 15:40:54,907 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  194. FROM stats
  195. WHERE stats.playbook_id = ?
  196. 2017-05-08 15:40:54,907 INFO sqlalchemy.engine.base.Engine (u'46650b9d-6a37-4f6b-bc4b-45a4eaf23051',)
  197. 2017-05-08 15:40:54,908 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  198. FROM stats
  199. WHERE stats.playbook_id = ?
  200. 2017-05-08 15:40:54,908 INFO sqlalchemy.engine.base.Engine (u'46650b9d-6a37-4f6b-bc4b-45a4eaf23051',)
  201. 2017-05-08 15:40:54,909 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  202. FROM stats
  203. WHERE stats.playbook_id = ?
  204. 2017-05-08 15:40:54,909 INFO sqlalchemy.engine.base.Engine (u'46650b9d-6a37-4f6b-bc4b-45a4eaf23051',)
  205. 2017-05-08 15:40:54,909 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  206. FROM stats
  207. WHERE stats.playbook_id = ?
  208. 2017-05-08 15:40:54,910 INFO sqlalchemy.engine.base.Engine (u'46650b9d-6a37-4f6b-bc4b-45a4eaf23051',)
  209. 2017-05-08 15:40:54,910 INFO sqlalchemy.engine.base.Engine SELECT stats.id AS stats_id, stats.playbook_id AS stats_playbook_id, stats.host_id AS stats_host_id, stats.changed AS stats_changed, stats.failed AS stats_failed, stats.ok AS stats_ok, stats.skipped AS stats_skipped, stats.unreachable AS stats_unreachable
  210. FROM stats
  211. WHERE stats.playbook_id = ?
  212. 2017-05-08 15:40:54,910 INFO sqlalchemy.engine.base.Engine (u'46650b9d-6a37-4f6b-bc4b-45a4eaf23051',)
  213. 2017-05-08 15:40:54,915 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  214. FROM hosts
  215. WHERE ? = hosts.playbook_id
  216. 2017-05-08 15:40:54,915 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  217. 2017-05-08 15:40:54,916 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  218. FROM plays
  219. WHERE ? = plays.playbook_id
  220. 2017-05-08 15:40:54,916 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  221. 2017-05-08 15:40:54,919 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  222. FROM files
  223. WHERE ? = files.playbook_id
  224. 2017-05-08 15:40:54,919 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  225. 2017-05-08 15:40:54,921 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  226. FROM tasks
  227. WHERE ? = tasks.playbook_id
  228. 2017-05-08 15:40:54,921 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  229. 2017-05-08 15:40:54,924 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  230. FROM data
  231. WHERE ? = data.playbook_id
  232. 2017-05-08 15:40:54,924 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  233. 2017-05-08 15:40:54,926 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  234. FROM stats
  235. WHERE ? = stats.playbook_id
  236. 2017-05-08 15:40:54,926 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  237. 2017-05-08 15:40:54,927 INFO sqlalchemy.engine.base.Engine SELECT files.id AS files_id, files.playbook_id AS files_playbook_id, files.path AS files_path, files.content_id AS files_content_id, files.is_playbook AS files_is_playbook
  238. FROM files
  239. WHERE ? = files.playbook_id AND files.playbook_id = ? AND files.is_playbook = 1
  240. 2017-05-08 15:40:54,927 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f', u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f')
  241. 2017-05-08 15:40:54,931 INFO sqlalchemy.engine.base.Engine SELECT files.id AS files_id, files.playbook_id AS files_playbook_id, files.path AS files_path, files.content_id AS files_content_id, files.is_playbook AS files_is_playbook
  242. FROM files
  243. WHERE files.playbook_id IN (?)
  244. 2017-05-08 15:40:54,931 INFO sqlalchemy.engine.base.Engine (u'a442ed6a-e9ac-4a83-b71c-23513d14ce0f',)
  245. 2017-05-08 15:40:54,935 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  246. FROM hosts
  247. WHERE ? = hosts.playbook_id
  248. 2017-05-08 15:40:54,935 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  249. 2017-05-08 15:40:54,937 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  250. FROM plays
  251. WHERE ? = plays.playbook_id
  252. 2017-05-08 15:40:54,937 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  253. 2017-05-08 15:40:54,938 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  254. FROM files
  255. WHERE ? = files.playbook_id
  256. 2017-05-08 15:40:54,938 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  257. 2017-05-08 15:40:54,941 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  258. FROM tasks
  259. WHERE ? = tasks.playbook_id
  260. 2017-05-08 15:40:54,942 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  261. 2017-05-08 15:40:54,945 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  262. FROM data
  263. WHERE ? = data.playbook_id
  264. 2017-05-08 15:40:54,945 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  265. 2017-05-08 15:40:54,947 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  266. FROM stats
  267. WHERE ? = stats.playbook_id
  268. 2017-05-08 15:40:54,948 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  269. 2017-05-08 15:40:54,950 INFO sqlalchemy.engine.base.Engine SELECT files.id AS files_id, files.playbook_id AS files_playbook_id, files.path AS files_path, files.content_id AS files_content_id, files.is_playbook AS files_is_playbook
  270. FROM files
  271. WHERE ? = files.playbook_id AND files.playbook_id = ? AND files.is_playbook = 1
  272. 2017-05-08 15:40:54,951 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5', u'16c56d0b-c935-4581-9882-adc9ceaa03f5')
  273. 2017-05-08 15:40:54,954 INFO sqlalchemy.engine.base.Engine SELECT files.id AS files_id, files.playbook_id AS files_playbook_id, files.path AS files_path, files.content_id AS files_content_id, files.is_playbook AS files_is_playbook
  274. FROM files
  275. WHERE files.playbook_id IN (?)
  276. 2017-05-08 15:40:54,954 INFO sqlalchemy.engine.base.Engine (u'16c56d0b-c935-4581-9882-adc9ceaa03f5',)
  277. 2017-05-08 15:40:54,958 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  278. FROM hosts
  279. WHERE ? = hosts.playbook_id
  280. 2017-05-08 15:40:54,958 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  281. 2017-05-08 15:40:54,959 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  282. FROM plays
  283. WHERE ? = plays.playbook_id
  284. 2017-05-08 15:40:54,959 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  285. 2017-05-08 15:40:54,961 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  286. FROM files
  287. WHERE ? = files.playbook_id
  288. 2017-05-08 15:40:54,961 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  289. 2017-05-08 15:40:54,963 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  290. FROM tasks
  291. WHERE ? = tasks.playbook_id
  292. 2017-05-08 15:40:54,963 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  293. 2017-05-08 15:40:54,965 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  294. FROM data
  295. WHERE ? = data.playbook_id
  296. 2017-05-08 15:40:54,966 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  297. 2017-05-08 15:40:54,968 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  298. FROM stats
  299. WHERE ? = stats.playbook_id
  300. 2017-05-08 15:40:54,968 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  301. 2017-05-08 15:40:54,969 INFO sqlalchemy.engine.base.Engine SELECT files.id AS files_id, files.playbook_id AS files_playbook_id, files.path AS files_path, files.content_id AS files_content_id, files.is_playbook AS files_is_playbook
  302. FROM files
  303. WHERE ? = files.playbook_id AND files.playbook_id = ? AND files.is_playbook = 1
  304. 2017-05-08 15:40:54,970 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53', u'99a2d9ee-c183-43af-8e36-9bc2100d6b53')
  305. 2017-05-08 15:40:54,972 INFO sqlalchemy.engine.base.Engine SELECT files.id AS files_id, files.playbook_id AS files_playbook_id, files.path AS files_path, files.content_id AS files_content_id, files.is_playbook AS files_is_playbook
  306. FROM files
  307. WHERE files.playbook_id IN (?)
  308. 2017-05-08 15:40:54,973 INFO sqlalchemy.engine.base.Engine (u'99a2d9ee-c183-43af-8e36-9bc2100d6b53',)
  309. 2017-05-08 15:40:54,978 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  310. FROM hosts
  311. WHERE ? = hosts.playbook_id
  312. 2017-05-08 15:40:54,978 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  313. 2017-05-08 15:40:54,980 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  314. FROM plays
  315. WHERE ? = plays.playbook_id
  316. 2017-05-08 15:40:54,980 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  317. 2017-05-08 15:40:54,983 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  318. FROM files
  319. WHERE ? = files.playbook_id
  320. 2017-05-08 15:40:54,983 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  321. 2017-05-08 15:40:54,986 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  322. FROM tasks
  323. WHERE ? = tasks.playbook_id
  324. 2017-05-08 15:40:54,986 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  325. 2017-05-08 15:40:54,990 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  326. FROM data
  327. WHERE ? = data.playbook_id
  328. 2017-05-08 15:40:54,990 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  329. 2017-05-08 15:40:54,993 INFO sqlalchemy.engine.base.Engine SELECT count(*) AS count_1
  330. FROM stats
  331. WHERE ? = stats.playbook_id
  332. 2017-05-08 15:40:54,993 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4',)
  333. 2017-05-08 15:40:54,996 INFO sqlalchemy.engine.base.Engine SELECT files.id AS files_id, files.playbook_id AS files_playbook_id, files.path AS files_path, files.content_id AS files_content_id, files.is_playbook AS files_is_playbook
  334. FROM files
  335. WHERE ? = files.playbook_id AND files.playbook_id = ? AND files.is_playbook = 1
  336. 2017-05-08 15:40:54,996 INFO sqlalchemy.engine.base.Engine (u'f41a7f55-1d31-4db8-b43d-1a60838392c4', u'f41a7f55-1d31-4db8-b43d-1a60838392c4')
  337. [2017-05-08 15:40:54,998] ERROR in app: Exception on /reports/list/2.html [GET]
  338. Traceback (most recent call last):
  339. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/flask/app.py", line 1988, in wsgi_app
  340. response = self.full_dispatch_request()
  341. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/flask/app.py", line 1641, in full_dispatch_request
  342. rv = self.handle_user_exception(e)
  343. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/flask/app.py", line 1544, in handle_user_exception
  344. reraise(exc_type, exc_value, tb)
  345. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/flask/app.py", line 1639, in full_dispatch_request
  346. rv = self.dispatch_request()
  347. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/flask/app.py", line 1625, in dispatch_request
  348. return self.view_functions[rule.endpoint](**req.view_args)
  349. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/ara/views/reports.py", line 66, in report_list
  350. stats=stats)
  351. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/flask/templating.py", line 134, in render_template
  352. context, ctx.app)
  353. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/flask/templating.py", line 116, in _render
  354. rv = template.render(context)
  355. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/jinja2/environment.py", line 1008, in render
  356. return self.environment.handle_exception(exc_info, True)
  357. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/jinja2/environment.py", line 780, in handle_exception
  358. reraise(exc_type, exc_value, tb)
  359. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/ara/templates/report_list.html", line 1, in top-level template code
  360. {% extends "layout.html" %}
  361. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/ara/templates/layout.html", line 6, in top-level template code
  362. {% block content -%}
  363. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/ara/templates/report_list.html", line 10, in block "content"
  364. {% include "report.html" -%}
  365. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/ara/templates/report.html", line 22, in top-level template code
  366. <a href="#" data-toggle="modal" data-target="#file_modal" data-load="{{ playbook.file.id }}/" title="{{ playbook.path }}">{{ playbook.path | basename }}</a>
  367. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/jinja2/environment.py", line 430, in getattr
  368. return getattr(obj, attribute)
  369. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/ara/models.py", line 195, in file
  370. .filter(File.is_playbook)).one()
  371. File "/home/ur/Envs/ansible23/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2820, in one
  372. raise orm_exc.NoResultFound("No row was found for one()")
  373. NoResultFound: No row was found for one()
  374. 2017-05-08 15:40:54,999 INFO sqlalchemy.engine.base.Engine ROLLBACK
  375. 57.20.4.138 - - [08/May/2017 15:40:55] "GET /reports/list/2.html HTTP/1.1" 500 -
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!