sqlite_aclk.h 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. // SPDX-License-Identifier: GPL-3.0-or-later
  2. #ifndef NETDATA_SQLITE_ACLK_H
  3. #define NETDATA_SQLITE_ACLK_H
  4. #include "sqlite3.h"
  5. #ifndef ACLK_MAX_CHART_BATCH
  6. #define ACLK_MAX_CHART_BATCH (200)
  7. #endif
  8. #ifndef ACLK_MAX_CHART_BATCH_COUNT
  9. #define ACLK_MAX_CHART_BATCH_COUNT (10)
  10. #endif
  11. #define ACLK_MAX_ALERT_UPDATES (5)
  12. #define ACLK_DATABASE_CLEANUP_FIRST (1200)
  13. #define ACLK_DATABASE_CLEANUP_INTERVAL (3600)
  14. #define ACLK_DELETE_ACK_ALERTS_INTERNAL (86400)
  15. #define ACLK_SYNC_QUERY_SIZE 512
  16. static inline void uuid_unparse_lower_fix(uuid_t *uuid, char *out)
  17. {
  18. uuid_unparse_lower(*uuid, out);
  19. out[8] = '_';
  20. out[13] = '_';
  21. out[18] = '_';
  22. out[23] = '_';
  23. }
  24. static inline int uuid_parse_fix(char *in, uuid_t uuid)
  25. {
  26. in[8] = '-';
  27. in[13] = '-';
  28. in[18] = '-';
  29. in[23] = '-';
  30. return uuid_parse(in, uuid);
  31. }
  32. static inline int claimed()
  33. {
  34. return localhost->aclk_state.claimed_id != NULL;
  35. }
  36. #define TABLE_ACLK_ALERT "CREATE TABLE IF NOT EXISTS aclk_alert_%s (sequence_id INTEGER PRIMARY KEY, " \
  37. "alert_unique_id, date_created, date_submitted, date_cloud_ack, filtered_alert_unique_id NOT NULL, " \
  38. "unique(alert_unique_id));"
  39. #define INDEX_ACLK_ALERT "CREATE INDEX IF NOT EXISTS aclk_alert_index_%s ON aclk_alert_%s (alert_unique_id);"
  40. #define INDEX_ACLK_ALERT1 "CREATE INDEX IF NOT EXISTS aclk_alert_index1_%s ON aclk_alert_%s (filtered_alert_unique_id);"
  41. #define INDEX_ACLK_ALERT2 "CREATE INDEX IF NOT EXISTS aclk_alert_index2_%s ON aclk_alert_%s (date_submitted);"
  42. enum aclk_database_opcode {
  43. ACLK_DATABASE_NOOP = 0,
  44. ACLK_DATABASE_CLEANUP,
  45. ACLK_DATABASE_DELETE_HOST,
  46. ACLK_DATABASE_NODE_STATE,
  47. ACLK_DATABASE_PUSH_ALERT,
  48. ACLK_DATABASE_PUSH_ALERT_CONFIG,
  49. ACLK_DATABASE_PUSH_ALERT_SNAPSHOT,
  50. ACLK_DATABASE_PUSH_ALERT_CHECKPOINT,
  51. ACLK_DATABASE_QUEUE_REMOVED_ALERTS,
  52. ACLK_DATABASE_TIMER,
  53. // leave this last
  54. // we need it to check for worker utilization
  55. ACLK_MAX_ENUMERATIONS_DEFINED
  56. };
  57. struct aclk_database_cmd {
  58. enum aclk_database_opcode opcode;
  59. void *param[2];
  60. struct completion *completion;
  61. };
  62. #define ACLK_DATABASE_CMD_Q_MAX_SIZE (1024)
  63. struct aclk_database_cmdqueue {
  64. unsigned head, tail;
  65. struct aclk_database_cmd cmd_array[ACLK_DATABASE_CMD_Q_MAX_SIZE];
  66. };
  67. struct aclk_sync_host_config {
  68. RRDHOST *host;
  69. int alert_updates;
  70. int alert_checkpoint_req;
  71. int alert_queue_removed;
  72. time_t node_info_send_time;
  73. time_t node_collectors_send;
  74. char uuid_str[UUID_STR_LEN];
  75. char node_id[UUID_STR_LEN];
  76. char *alerts_snapshot_uuid; // will contain the snapshot_uuid value if snapshot was requested
  77. uint64_t alerts_log_first_sequence_id;
  78. uint64_t alerts_log_last_sequence_id;
  79. };
  80. extern sqlite3 *db_meta;
  81. int aclk_database_enq_cmd_noblock(struct aclk_database_cmd *cmd);
  82. void sql_create_aclk_table(RRDHOST *host, uuid_t *host_uuid, uuid_t *node_id);
  83. void sql_aclk_sync_init(void);
  84. void aclk_push_alert_config(const char *node_id, const char *config_hash);
  85. void aclk_push_node_alert_snapshot(const char *node_id);
  86. void aclk_push_node_health_log(const char *node_id);
  87. void aclk_push_node_removed_alerts(const char *node_id);
  88. void schedule_node_info_update(RRDHOST *host);
  89. #endif //NETDATA_SQLITE_ACLK_H