Advertisement
UHLHosting

Untitled

Apr 8th, 2022
1,182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 6.61 KB | None | 0 0
  1. [root@ns1 playbooks]# grep failed=1 -B20 /root/apnscp-bootstrapper.log
  2.   site_id,
  3.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  4.   SUM("in_bytes") AS in_bytes,
  5.   SUM("out_bytes") AS out_bytes,
  6.   SUM("in_bytes"+"out_bytes") AS total
  7. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  8. 2022-04-09 02:05:28,482 p=1351 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  9. 2022-04-09 02:05:28,527 p=1351 u=root n=ansible | ok: [localhost]
  10. 2022-04-09 02:05:28,543 p=1351 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  11. 2022-04-09 02:05:28,614 p=1351 u=root n=ansible | changed: [localhost]
  12. 2022-04-09 02:05:28,629 p=1351 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  13. 2022-04-09 02:05:28,659 p=1351 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  14. 2022-04-09 02:05:28,693 p=1351 u=root n=ansible | changed: [localhost]
  15. 2022-04-09 02:05:28,694 p=1351 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  16. 2022-04-09 02:05:29,337 p=1351 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"}
  17. 2022-04-09 02:05:29,338 p=1351 u=root n=ansible | RUNNING HANDLER [common : Reload systemd] **************************************
  18. 2022-04-09 02:05:29,338 p=1351 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  19. 2022-04-09 02:05:29,339 p=1351 u=root n=ansible | RUNNING HANDLER [common : Restart virtualhosting] ******************************
  20. 2022-04-09 02:05:29,339 p=1351 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  21. 2022-04-09 02:05:29,341 p=1351 u=root n=ansible | PLAY RECAP *********************************************************************
  22. 2022-04-09 02:05:29,341 p=1351 u=root n=ansible | localhost                  : ok=631  changed=206  unreachable=0    failed=1    skipped=228  rescued=1    ignored=11  
  23. --
  24.   schedule_interval => INTERVAL '45 m'
  25. ); )
  26. 2022-04-09 02:15:13,099 p=275685 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  27.   site_id,
  28.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  29.   SUM("in_bytes") AS in_bytes,
  30.   SUM("out_bytes") AS out_bytes,
  31.   SUM("in_bytes"+"out_bytes") AS total
  32. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  33. 2022-04-09 02:15:13,113 p=275685 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  34. 2022-04-09 02:15:13,159 p=275685 u=root n=ansible | ok: [localhost]
  35. 2022-04-09 02:15:13,176 p=275685 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  36. 2022-04-09 02:15:13,192 p=275685 u=root n=ansible | skipping: [localhost]
  37. 2022-04-09 02:15:13,268 p=275685 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  38. 2022-04-09 02:15:13,298 p=275685 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  39. 2022-04-09 02:15:13,409 p=275685 u=root n=ansible | ok: [localhost]
  40. 2022-04-09 02:15:13,410 p=275685 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  41. 2022-04-09 02:15:14,085 p=275685 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"}
  42. 2022-04-09 02:15:14,086 p=275685 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  43. 2022-04-09 02:15:14,088 p=275685 u=root n=ansible | PLAY RECAP *********************************************************************
  44. 2022-04-09 02:15:14,088 p=275685 u=root n=ansible | localhost                  : ok=527  changed=13   unreachable=0    failed=1    skipped=297  rescued=0    ignored=0  
  45. --
  46.   schedule_interval => INTERVAL '45 m'
  47. ); )
  48. 2022-04-09 02:24:22,713 p=429896 u=root n=ansible | skipping: [localhost] => (item=CREATE MATERIALIZED VIEW IF NOT EXISTS site_totals_daily_view AS SELECT
  49.   site_id,
  50.   DATE_TRUNC('day', ts_bucket::TIMESTAMPTZ) as ts_bucket,
  51.   SUM("in_bytes") AS in_bytes,
  52.   SUM("out_bytes") AS out_bytes,
  53.   SUM("in_bytes"+"out_bytes") AS total
  54. FROM site_totals_hourly_view GROUP BY(DATE_TRUNC('day', ts_bucket), site_id);)
  55. 2022-04-09 02:24:22,727 p=429896 u=root n=ansible | TASK [apnscp/initialize-db : Verify if storage_log is hypertable] **************
  56. 2022-04-09 02:24:22,775 p=429896 u=root n=ansible | ok: [localhost]
  57. 2022-04-09 02:24:22,790 p=429896 u=root n=ansible | TASK [apnscp/initialize-db : Convert storage_log into hypertable] **************
  58. 2022-04-09 02:24:22,806 p=429896 u=root n=ansible | skipping: [localhost]
  59. 2022-04-09 02:24:22,819 p=429896 u=root n=ansible | TASK [apnscp/initialize-db : Apply hypertable queries] *************************
  60. 2022-04-09 02:24:22,851 p=429896 u=root n=ansible | TASK [apnscp/initialize-db : Populate APNSCP_APPLIANCE_DB] *********************
  61. 2022-04-09 02:24:22,981 p=429896 u=root n=ansible | ok: [localhost]
  62. 2022-04-09 02:24:22,983 p=429896 u=root n=ansible | RUNNING HANDLER [common : Restart apnscp] **************************************
  63. 2022-04-09 02:24:23,464 p=429896 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"}
  64. 2022-04-09 02:24:23,464 p=429896 u=root n=ansible | NO MORE HOSTS LEFT *************************************************************
  65. 2022-04-09 02:24:23,467 p=429896 u=root n=ansible | PLAY RECAP *********************************************************************
  66. 2022-04-09 02:24:23,467 p=429896 u=root n=ansible | localhost                  : ok=527  changed=13   unreachable=0    failed=1    skipped=297  rescued=0    ignored=0  
  67. [root@ns1 playbooks]#
  68.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement