API tools faq
paste
Advertisement
UHLHosting

Untitled

UHLHosting
Apr 8th, 2022
1,493
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 25.54 KB | None | 0 0
raw download clone embed print report
  1. [root@ns1 ~]# grep -m1 failed=1 -B20 /root/apnscp-bootstrapper.log
  2. 2022-04-08 22:53:10,218 p=17432 u=root n=ansible | TASK [common/acquire-lock : set_fact] ******************************************
  3. 2022-04-08 22:53:10,236 p=17432 u=root n=ansible | ok: [localhost]
  4. 2022-04-08 22:53:10,251 p=17432 u=root n=ansible | TASK [common/acquire-lock : Check if PID /proc//comm present] ******************
  5. 2022-04-08 22:53:10,367 p=17432 u=root n=ansible | ok: [localhost]
  6. 2022-04-08 22:53:10,380 p=17432 u=root n=ansible | TASK [common/acquire-lock : Verify process matches ansible] ********************
  7. 2022-04-08 22:53:10,392 p=17432 u=root n=ansible | skipping: [localhost]
  8. 2022-04-08 22:53:10,406 p=17432 u=root n=ansible | TASK [common/acquire-lock : Save PID in /usr/local/apnscp/storage/run/.ansible.lock] ***
  9. 2022-04-08 22:53:10,785 p=17432 u=root n=ansible | ok: [localhost]
  10. 2022-04-08 22:53:10,799 p=17432 u=root n=ansible | TASK [check-requirements : Force admin lowercase] ******************************
  11. 2022-04-08 22:53:10,811 p=17432 u=root n=ansible | skipping: [localhost]
  12. 2022-04-08 22:53:10,825 p=17432 u=root n=ansible | TASK [check-requirements : Fail if OS is not RHEL/CentOS] **********************
  13. 2022-04-08 22:53:10,835 p=17432 u=root n=ansible | skipping: [localhost]
  14. 2022-04-08 22:53:10,849 p=17432 u=root n=ansible | TASK [check-requirements : Fail if RHEL/CentOS is not sufficient version] ******
  15. 2022-04-08 22:53:11,019 p=17432 u=root n=ansible | ok: [localhost] => (item=/etc/centos-release)
  16. 2022-04-08 22:53:11,032 p=17432 u=root n=ansible | TASK [check-requirements : Fail if memory less than 1 GB] **********************
  17. 2022-04-08 22:53:11,048 p=17432 u=root n=ansible | fatal: [localhost]: FAILED! => changed=false
  18.   msg: |-
  19.     ApisCP requires at least 1 GB memory to run. Total memory detected: 807 MB
  20.     This safety check may be overridden by setting limit_memory_1gb in /root/apnscp-vars-runtime.yml to a value lower than "972".
  21. 2022-04-08 22:53:11,050 p=17432 u=root n=ansible | PLAY RECAP *********************************************************************
  22. 2022-04-08 22:53:11,050 p=17432 u=root n=ansible | localhost                  : ok=7    changed=1    unreachable=0    failed=1    skipped=3    rescued=0    ignored=0  
  23. [root@ns1 ~]# grep failed=1 -B20 /root/apnscp-bootstrapper.log
  24. 2022-04-08 22:53:10,218 p=17432 u=root n=ansible | TASK [common/acquire-lock : set_fact] ******************************************
  25. 2022-04-08 22:53:10,236 p=17432 u=root n=ansible | ok: [localhost]
  26. 2022-04-08 22:53:10,251 p=17432 u=root n=ansible | TASK [common/acquire-lock : Check if PID /proc//comm present] ******************
  27. 2022-04-08 22:53:10,367 p=17432 u=root n=ansible | ok: [localhost]
  28. 2022-04-08 22:53:10,380 p=17432 u=root n=ansible | TASK [common/acquire-lock : Verify process matches ansible] ********************
  29. 2022-04-08 22:53:10,392 p=17432 u=root n=ansible | skipping: [localhost]
  30. 2022-04-08 22:53:10,406 p=17432 u=root n=ansible | TASK [common/acquire-lock : Save PID in /usr/local/apnscp/storage/run/.ansible.lock] ***
  31. 2022-04-08 22:53:10,785 p=17432 u=root n=ansible | ok: [localhost]
  32. 2022-04-08 22:53:10,799 p=17432 u=root n=ansible | TASK [check-requirements : Force admin lowercase] ******************************
  33. 2022-04-08 22:53:10,811 p=17432 u=root n=ansible | skipping: [localhost]
  34. 2022-04-08 22:53:10,825 p=17432 u=root n=ansible | TASK [check-requirements : Fail if OS is not RHEL/CentOS] **********************
  35. 2022-04-08 22:53:10,835 p=17432 u=root n=ansible | skipping: [localhost]
  36. 2022-04-08 22:53:10,849 p=17432 u=root n=ansible | TASK [check-requirements : Fail if RHEL/CentOS is not sufficient version] ******
  37. 2022-04-08 22:53:11,019 p=17432 u=root n=ansible | ok: [localhost] => (item=/etc/centos-release)
  38. 2022-04-08 22:53:11,032 p=17432 u=root n=ansible | TASK [check-requirements : Fail if memory less than 1 GB] **********************
  39. 2022-04-08 22:53:11,048 p=17432 u=root n=ansible | fatal: [localhost]: FAILED! => changed=false
  40.   msg: |-
  41.     ApisCP requires at least 1 GB memory to run. Total memory detected: 807 MB
  42.     This safety check may be overridden by setting limit_memory_1gb in /root/apnscp-vars-runtime.yml to a value lower than "972".
  43. 2022-04-08 22:53:11,050 p=17432 u=root n=ansible | PLAY RECAP *********************************************************************
  44. 2022-04-08 22:53:11,050 p=17432 u=root n=ansible | localhost                  : ok=7    changed=1    unreachable=0    failed=1    skipped=3    rescued=0    ignored=0  
  45. --
  46.   site_id,
  47.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  48.   SUM("in_bytes") AS in_bytes,
  49.   SUM("out_bytes") AS out_bytes,
  50.   SUM("in_bytes"+"out_bytes") AS total
  51. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  52. 2022-04-08 23:19:04,840 p=1355 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  53. 2022-04-08 23:19:04,886 p=1355 u=root n=ansible | ok: [localhost]
  54. 2022-04-08 23:19:04,902 p=1355 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  55. 2022-04-08 23:19:04,988 p=1355 u=root n=ansible | changed: [localhost]
  56. 2022-04-08 23:19:05,002 p=1355 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  57. 2022-04-08 23:19:05,031 p=1355 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  58. 2022-04-08 23:19:05,069 p=1355 u=root n=ansible | changed: [localhost]
  59. 2022-04-08 23:19:05,070 p=1355 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  60. 2022-04-08 23:19:05,633 p=1355 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Warning: The unit file, source configuration file or drop-ins of apnscp.service changed on disk. Run 'systemctl daemon-reload' to reload units.\nJob for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  61. 2022-04-08 23:19:05,634 p=1355 u=root n=ansible | RUNNING HANDLER [common : Reload systemd] **************************************
  62. 2022-04-08 23:19:05,635 p=1355 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  63. 2022-04-08 23:19:05,635 p=1355 u=root n=ansible | RUNNING HANDLER [common : Restart virtualhosting] ******************************
  64. 2022-04-08 23:19:05,635 p=1355 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  65. 2022-04-08 23:19:05,637 p=1355 u=root n=ansible | PLAY RECAP *********************************************************************
  66. 2022-04-08 23:19:05,637 p=1355 u=root n=ansible | localhost                  : ok=629  changed=204  unreachable=0    failed=1    skipped=230  rescued=1    ignored=11  
  67. --
  68.   schedule_interval => INTERVAL '45 m'
  69. ); )
  70. 2022-04-08 23:29:26,823 p=275756 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  71.   site_id,
  72.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  73.   SUM("in_bytes") AS in_bytes,
  74.   SUM("out_bytes") AS out_bytes,
  75.   SUM("in_bytes"+"out_bytes") AS total
  76. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  77. 2022-04-08 23:29:26,838 p=275756 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  78. 2022-04-08 23:29:26,887 p=275756 u=root n=ansible | ok: [localhost]
  79. 2022-04-08 23:29:26,909 p=275756 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  80. 2022-04-08 23:29:26,927 p=275756 u=root n=ansible | skipping: [localhost]
  81. 2022-04-08 23:29:26,941 p=275756 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  82. 2022-04-08 23:29:26,972 p=275756 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  83. 2022-04-08 23:29:27,082 p=275756 u=root n=ansible | ok: [localhost]
  84. 2022-04-08 23:29:27,083 p=275756 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  85. 2022-04-08 23:29:27,667 p=275756 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  86. 2022-04-08 23:29:27,668 p=275756 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  87. 2022-04-08 23:29:27,670 p=275756 u=root n=ansible | PLAY RECAP *********************************************************************
  88. 2022-04-08 23:29:27,671 p=275756 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  89. --
  90.   schedule_interval => INTERVAL '45 m'
  91. ); )
  92. 2022-04-08 23:39:45,642 p=432209 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  93.   site_id,
  94.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  95.   SUM("in_bytes") AS in_bytes,
  96.   SUM("out_bytes") AS out_bytes,
  97.   SUM("in_bytes"+"out_bytes") AS total
  98. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  99. 2022-04-08 23:39:45,658 p=432209 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  100. 2022-04-08 23:39:45,703 p=432209 u=root n=ansible | ok: [localhost]
  101. 2022-04-08 23:39:45,718 p=432209 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  102. 2022-04-08 23:39:45,733 p=432209 u=root n=ansible | skipping: [localhost]
  103. 2022-04-08 23:39:45,747 p=432209 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  104. 2022-04-08 23:39:45,775 p=432209 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  105. 2022-04-08 23:39:45,935 p=432209 u=root n=ansible | ok: [localhost]
  106. 2022-04-08 23:39:45,937 p=432209 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  107. 2022-04-08 23:39:46,542 p=432209 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  108. 2022-04-08 23:39:46,542 p=432209 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  109. 2022-04-08 23:39:46,544 p=432209 u=root n=ansible | PLAY RECAP *********************************************************************
  110. 2022-04-08 23:39:46,545 p=432209 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  111. --
  112.   schedule_interval => INTERVAL '45 m'
  113. ); )
  114. 2022-04-08 23:51:30,862 p=586132 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  115.   site_id,
  116.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  117.   SUM("in_bytes") AS in_bytes,
  118.   SUM("out_bytes") AS out_bytes,
  119.   SUM("in_bytes"+"out_bytes") AS total
  120. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  121. 2022-04-08 23:51:30,877 p=586132 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  122. 2022-04-08 23:51:30,924 p=586132 u=root n=ansible | ok: [localhost]
  123. 2022-04-08 23:51:30,939 p=586132 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  124. 2022-04-08 23:51:30,955 p=586132 u=root n=ansible | skipping: [localhost]
  125. 2022-04-08 23:51:30,969 p=586132 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  126. 2022-04-08 23:51:30,999 p=586132 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  127. 2022-04-08 23:51:31,357 p=586132 u=root n=ansible | ok: [localhost]
  128. 2022-04-08 23:51:31,358 p=586132 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  129. 2022-04-08 23:51:32,414 p=586132 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  130. 2022-04-08 23:51:32,415 p=586132 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  131. 2022-04-08 23:51:32,417 p=586132 u=root n=ansible | PLAY RECAP *********************************************************************
  132. 2022-04-08 23:51:32,418 p=586132 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  133. --
  134.   schedule_interval => INTERVAL '45 m'
  135. ); )
  136. 2022-04-09 00:02:17,189 p=740099 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  137.   site_id,
  138.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  139.   SUM("in_bytes") AS in_bytes,
  140.   SUM("out_bytes") AS out_bytes,
  141.   SUM("in_bytes"+"out_bytes") AS total
  142. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  143. 2022-04-09 00:02:17,206 p=740099 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  144. 2022-04-09 00:02:17,257 p=740099 u=root n=ansible | ok: [localhost]
  145. 2022-04-09 00:02:17,276 p=740099 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  146. 2022-04-09 00:02:17,291 p=740099 u=root n=ansible | skipping: [localhost]
  147. 2022-04-09 00:02:17,306 p=740099 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  148. 2022-04-09 00:02:17,344 p=740099 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  149. 2022-04-09 00:02:17,445 p=740099 u=root n=ansible | ok: [localhost]
  150. 2022-04-09 00:02:17,446 p=740099 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  151. 2022-04-09 00:02:18,034 p=740099 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  152. 2022-04-09 00:02:18,035 p=740099 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  153. 2022-04-09 00:02:18,038 p=740099 u=root n=ansible | PLAY RECAP *********************************************************************
  154. 2022-04-09 00:02:18,038 p=740099 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  155. --
  156.   schedule_interval => INTERVAL '45 m'
  157. ); )
  158. 2022-04-09 00:12:23,610 p=894086 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  159.   site_id,
  160.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  161.   SUM("in_bytes") AS in_bytes,
  162.   SUM("out_bytes") AS out_bytes,
  163.   SUM("in_bytes"+"out_bytes") AS total
  164. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  165. 2022-04-09 00:12:23,628 p=894086 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  166. 2022-04-09 00:12:23,683 p=894086 u=root n=ansible | ok: [localhost]
  167. 2022-04-09 00:12:23,700 p=894086 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  168. 2022-04-09 00:12:23,715 p=894086 u=root n=ansible | skipping: [localhost]
  169. 2022-04-09 00:12:23,732 p=894086 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  170. 2022-04-09 00:12:23,765 p=894086 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  171. 2022-04-09 00:12:23,933 p=894086 u=root n=ansible | ok: [localhost]
  172. 2022-04-09 00:12:23,935 p=894086 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  173. 2022-04-09 00:12:24,524 p=894086 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  174. 2022-04-09 00:12:24,525 p=894086 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  175. 2022-04-09 00:12:24,527 p=894086 u=root n=ansible | PLAY RECAP *********************************************************************
  176. 2022-04-09 00:12:24,528 p=894086 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  177. --
  178.   schedule_interval => INTERVAL '45 m'
  179. ); )
  180. 2022-04-09 00:23:48,770 p=1048001 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  181.   site_id,
  182.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  183.   SUM("in_bytes") AS in_bytes,
  184.   SUM("out_bytes") AS out_bytes,
  185.   SUM("in_bytes"+"out_bytes") AS total
  186. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  187. 2022-04-09 00:23:48,786 p=1048001 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  188. 2022-04-09 00:23:48,838 p=1048001 u=root n=ansible | ok: [localhost]
  189. 2022-04-09 00:23:48,854 p=1048001 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  190. 2022-04-09 00:23:48,872 p=1048001 u=root n=ansible | skipping: [localhost]
  191. 2022-04-09 00:23:48,886 p=1048001 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  192. 2022-04-09 00:23:48,917 p=1048001 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  193. 2022-04-09 00:23:49,385 p=1048001 u=root n=ansible | ok: [localhost]
  194. 2022-04-09 00:23:49,387 p=1048001 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  195. 2022-04-09 00:23:50,641 p=1048001 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  196. 2022-04-09 00:23:50,642 p=1048001 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  197. 2022-04-09 00:23:50,644 p=1048001 u=root n=ansible | PLAY RECAP *********************************************************************
  198. 2022-04-09 00:23:50,645 p=1048001 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  199. --
  200.   schedule_interval => INTERVAL '45 m'
  201. ); )
  202. 2022-04-09 00:34:32,697 p=1201965 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  203.   site_id,
  204.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  205.   SUM("in_bytes") AS in_bytes,
  206.   SUM("out_bytes") AS out_bytes,
  207.   SUM("in_bytes"+"out_bytes") AS total
  208. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  209. 2022-04-09 00:34:32,716 p=1201965 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  210. 2022-04-09 00:34:32,766 p=1201965 u=root n=ansible | ok: [localhost]
  211. 2022-04-09 00:34:32,788 p=1201965 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  212. 2022-04-09 00:34:32,808 p=1201965 u=root n=ansible | skipping: [localhost]
  213. 2022-04-09 00:34:32,826 p=1201965 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  214. 2022-04-09 00:34:32,863 p=1201965 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  215. 2022-04-09 00:34:32,977 p=1201965 u=root n=ansible | ok: [localhost]
  216. 2022-04-09 00:34:32,978 p=1201965 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  217. 2022-04-09 00:34:33,383 p=1201965 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  218. 2022-04-09 00:34:33,384 p=1201965 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  219. 2022-04-09 00:34:33,386 p=1201965 u=root n=ansible | PLAY RECAP *********************************************************************
  220. 2022-04-09 00:34:33,386 p=1201965 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  221. --
  222.   schedule_interval => INTERVAL '45 m'
  223. ); )
  224. 2022-04-09 00:44:44,259 p=1355857 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  225.   site_id,
  226.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  227.   SUM("in_bytes") AS in_bytes,
  228.   SUM("out_bytes") AS out_bytes,
  229.   SUM("in_bytes"+"out_bytes") AS total
  230. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  231. 2022-04-09 00:44:44,276 p=1355857 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  232. 2022-04-09 00:44:44,331 p=1355857 u=root n=ansible | ok: [localhost]
  233. 2022-04-09 00:44:44,350 p=1355857 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  234. 2022-04-09 00:44:44,369 p=1355857 u=root n=ansible | skipping: [localhost]
  235. 2022-04-09 00:44:44,386 p=1355857 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  236. 2022-04-09 00:44:44,421 p=1355857 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  237. 2022-04-09 00:44:44,506 p=1355857 u=root n=ansible | ok: [localhost]
  238. 2022-04-09 00:44:44,507 p=1355857 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  239. 2022-04-09 00:44:44,953 p=1355857 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  240. 2022-04-09 00:44:44,954 p=1355857 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  241. 2022-04-09 00:44:44,956 p=1355857 u=root n=ansible | PLAY RECAP *********************************************************************
  242. 2022-04-09 00:44:44,957 p=1355857 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  243. --
  244.   schedule_interval => INTERVAL '45 m'
  245. ); )
  246. 2022-04-09 00:55:04,940 p=1509706 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  247.   site_id,
  248.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  249.   SUM("in_bytes") AS in_bytes,
  250.   SUM("out_bytes") AS out_bytes,
  251.   SUM("in_bytes"+"out_bytes") AS total
  252. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  253. 2022-04-09 00:55:04,957 p=1509706 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  254. 2022-04-09 00:55:05,008 p=1509706 u=root n=ansible | ok: [localhost]
  255. 2022-04-09 00:55:05,026 p=1509706 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  256. 2022-04-09 00:55:05,042 p=1509706 u=root n=ansible | skipping: [localhost]
  257. 2022-04-09 00:55:05,058 p=1509706 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  258. 2022-04-09 00:55:05,094 p=1509706 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  259. 2022-04-09 00:55:05,237 p=1509706 u=root n=ansible | ok: [localhost]
  260. 2022-04-09 00:55:05,238 p=1509706 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  261. 2022-04-09 00:55:05,782 p=1509706 u=root n=ansible | fatal: [localhost]: FAILED! => {"changed": false, "msg": "Unable to start service apnscp: Job for apnscp.service failed because the service did not take the steps required by its unit configuration.\nSee \"systemctl status apnscp.service\" and \"journalctl -xe\" for details.\n"}
  262. 2022-04-09 00:55:05,783 p=1509706 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  263. 2022-04-09 00:55:05,785 p=1509706 u=root n=ansible | PLAY RECAP *********************************************************************
  264. 2022-04-09 00:55:05,785 p=1509706 u=root n=ansible | localhost                  : ok=525  changed=13   unreachable=0    failed=1    skipped=299  rescued=0    ignored=0  
  265. [root@ns1 ~]#
  266.  
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!