API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
73
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.53 KB | None | 0 0
raw download clone embed print report
  1. [root@testing pg_log]# cat postgresql-2017-07-21_000000.log |more
  2. < 2017-07-21 00:05:38.632 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  3. < 2017-07-21 00:05:38.632 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  4. < 2017-07-21 00:06:38.290 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  5. < 2017-07-21 00:06:38.290 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  6. < 2017-07-21 00:17:38.697 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  7. < 2017-07-21 00:17:38.697 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  8. < 2017-07-21 00:18:38.717 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  9. < 2017-07-21 00:18:38.717 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  10. < 2017-07-21 00:29:38.260 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  11. < 2017-07-21 00:29:38.260 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  12. < 2017-07-21 00:30:38.865 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  13. < 2017-07-21 00:30:38.865 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  14. < 2017-07-21 00:41:38.432 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  15. < 2017-07-21 00:41:38.432 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  16. < 2017-07-21 00:42:38.565 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  17. < 2017-07-21 00:42:38.565 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  18. < 2017-07-21 00:53:38.589 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  19. < 2017-07-21 00:53:38.589 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  20. < 2017-07-21 00:54:39.052 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  21. < 2017-07-21 00:54:39.052 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  22. < 2017-07-21 01:05:39.101 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  23. < 2017-07-21 01:05:39.101 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  24. < 2017-07-21 01:06:39.171 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  25. < 2017-07-21 01:06:39.171 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  26. < 2017-07-21 01:17:39.073 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  27. < 2017-07-21 01:17:39.073 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  28. < 2017-07-21 01:18:39.392 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  29. < 2017-07-21 01:18:39.392 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  30. < 2017-07-21 01:29:40.061 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  31. < 2017-07-21 01:29:40.061 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  32. < 2017-07-21 01:30:40.358 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  33. < 2017-07-21 01:30:40.358 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  34. < 2017-07-21 01:41:39.763 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  35. < 2017-07-21 01:41:39.763 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  36. < 2017-07-21 01:42:39.786 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  37. < 2017-07-21 01:42:39.786 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  38. < 2017-07-21 01:53:39.722 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  39. < 2017-07-21 01:53:39.722 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  40. < 2017-07-21 01:54:39.136 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  41. < 2017-07-21 01:54:39.136 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  42. < 2017-07-21 02:05:39.814 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  43. < 2017-07-21 02:05:39.814 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  44. < 2017-07-21 02:06:39.998 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  45. < 2017-07-21 02:06:39.998 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  46. < 2017-07-21 02:17:40.124 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  47. < 2017-07-21 02:17:40.124 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  48. < 2017-07-21 02:18:40.155 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  49. < 2017-07-21 02:18:40.155 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  50. < 2017-07-21 02:29:39.438 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  51. < 2017-07-21 02:29:39.438 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  52. < 2017-07-21 02:30:39.710 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  53. < 2017-07-21 02:30:39.710 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  54. < 2017-07-21 02:41:39.493 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  55. < 2017-07-21 02:41:39.493 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  56. < 2017-07-21 02:42:39.484 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  57. < 2017-07-21 02:42:39.484 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  58. < 2017-07-21 02:53:39.448 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  59. < 2017-07-21 02:53:39.448 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  60. < 2017-07-21 02:54:39.774 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  61. < 2017-07-21 02:54:39.774 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  62. < 2017-07-21 03:05:40.578 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  63. < 2017-07-21 03:05:40.578 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  64. < 2017-07-21 03:06:40.630 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  65. < 2017-07-21 03:06:40.630 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  66. < 2017-07-21 03:17:41.033 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  67. < 2017-07-21 03:17:41.033 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  68. < 2017-07-21 03:18:41.116 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  69. < 2017-07-21 03:18:41.116 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  70. < 2017-07-21 03:29:40.871 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  71. < 2017-07-21 03:29:40.871 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  72. < 2017-07-21 03:30:40.235 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  73. < 2017-07-21 03:30:40.235 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  74. < 2017-07-21 03:33:01.605 GMT >ERROR: INSERT has more expressions than target columns at character 36
  75. < 2017-07-21 03:33:01.605 GMT >QUERY: insert into resource_record select OLD.*,EXTRACT(EPOCH from current_timestamp(0)),'B'
  76. < 2017-07-21 03:33:01.605 GMT >CONTEXT: PL/pgSQL function class4_trigfun_record_resource() line 8 at SQL statement
  77. < 2017-07-21 03:33:01.605 GMT >STATEMENT: UPDATE "resource" SET "resource_id" = '304', "name" = NULL, "ingress" = TRUE, "egress" = FALSE, "active" = TRUE, "rfc_2833" = FALSE,
  78. "t38" = TRUE, "alias" = 'did_vendor1', "res_strategy" = NULL, "cps_limit" = NULL, "capacity" = DEFAULT, "lnp" = FALSE, "lrn_block" = FALSE, "client_id" = '251', "tdm" = TRUE,
  79. "rate_table_id" = '248', "transnexus" = NULL, "route_strategy_id" = '3', "media_type" = '2', "pass_through" = NULL, "profit_margin" = '0', "enough_balance" = TRUE, "egress_bi
  80. ll_after_action" = TRUE, "proto" = '1', "dnis_only" = TRUE, "ring_timeout" = '60', "ignore_ring" = FALSE, "ignore_early_media" = FALSE, "disable_by_alert" = FALSE, "priority"
  81. = '0', "last_priority" = '0', "create_time" = '2017-07-17 15:02:31+00', "update_time" = '2017-07-17 15:02:31+00', "status" = '1', "wait_ringtime180" = '6000', "profit_type" =
  82. '1', "lnp_dipping" = FALSE, "lnp_dipping_rate" = NULL, "update_at" = '2017-07-17 15:02:31+00', "update_by" = NULL, "cli_type" = NULL, "auth_type" = '0', "delay_bye_second" = N
  83. ULL, "delay_bye_limit" = NULL, "max_duration" = NULL, "marketplace" = '0', "rating_type" = '0', "billing_type" = NULL, "trunk_type" = NULL, "switch_profile_id" = NULL, "transa
  84. ction_fee_id" = NULL, "service_type" = '0', "product_id" = NULL, "rpid" = NULL, "paid" = NULL, "oli" = NULL, "pci" = NULL, "priv" = NULL, "div" = NULL, "trunk_type2" = '1', "a
  85. ccount_id" = NULL, "billing_method" = NULL, "amount_per_port" = NULL, "billing_rule" = NULL, "ignore_early_nosdp" = NULL, "media_timeout" = NULL, "private" = '0', "agent_type"
  86. = NULL, "bill_by" = '4', "rate_profile" = '0', "us_route" = '0', "intl_route" = '0', "canada_route" = '0', "rate_decimal" = '6', "rate_rounding" = '0', "us_other" = '0', "can
  87. ada_other" = '0', "redirect" = '0', "lrn_prefix" = '1', "pass_response_code" = '0', "is_del" = '0', "dtmf_type" = '3', "dtmf_detect" = '0', "rpid_screen" = '0', "rpid_party" =
  88. '0', "display_name" = NULL, "rpid_id_type" = '0', "rpid_privacy" = '0', "counter_time" = NULL, "number" = NULL, "block_time" = NULL, "re_invite" = NULL, "re_invite_interval"
  89. = NULL, "info" = NULL, "rfc2833" = NULL, "inband" = NULL, "dummy_trunk" = FALSE, "random_table_id" = NULL, "is_virtual" = FALSE, "rfc_r833_payload" = NULL, "resource_template_
  90. id" = NULL, "rate_use_rpid" = FALSE, "group_id" = NULL, "resource_block_group_id" = NULL, "block_404_number_time" = NULL, "price_per_actual_channel" = NULL, "price_per_max_cha
  91. nnel" = NULL, "enfource_cid" = FALSE, "ani_cps_limit" = NULL, "ani_cap_limit" = NULL, "dnis_cps_limit" = NULL, "dnis_cap_limit" = NULL WHERE "resource"."resource_id" = '304'
  92. < 2017-07-21 03:33:49.943 GMT >ERROR: INSERT has more expressions than target columns at character 36
  93. < 2017-07-21 03:33:49.943 GMT >QUERY: insert into resource_record select OLD.*,EXTRACT(EPOCH from current_timestamp(0)),'B'
  94. < 2017-07-21 03:33:49.943 GMT >CONTEXT: PL/pgSQL function class4_trigfun_record_resource() line 8 at SQL statement
  95. < 2017-07-21 03:33:49.943 GMT >STATEMENT: UPDATE "resource" SET "resource_id" = '304', "name" = NULL, "ingress" = TRUE, "egress" = FALSE, "active" = TRUE, "rfc_2833" = FALSE,
  96. "t38" = TRUE, "alias" = 'did_vendor1', "res_strategy" = NULL, "cps_limit" = NULL, "capacity" = DEFAULT, "lnp" = FALSE, "lrn_block" = FALSE, "client_id" = '251', "tdm" = TRUE,
  97. "rate_table_id" = '248', "transnexus" = NULL, "route_strategy_id" = '3', "media_type" = '2', "pass_through" = NULL, "profit_margin" = '0', "enough_balance" = TRUE, "egress_bi
  98. ll_after_action" = TRUE, "proto" = '1', "dnis_only" = TRUE, "ring_timeout" = '60', "ignore_ring" = FALSE, "ignore_early_media" = FALSE, "disable_by_alert" = FALSE, "priority"
  99. = '0', "last_priority" = '0', "create_time" = '2017-07-17 15:02:31+00', "update_time" = '2017-07-17 15:02:31+00', "status" = '1', "wait_ringtime180" = '6000', "profit_type" =
  100. '1', "lnp_dipping" = FALSE, "lnp_dipping_rate" = NULL, "update_at" = '2017-07-17 15:02:31+00', "update_by" = NULL, "cli_type" = NULL, "auth_type" = '0', "delay_bye_second" = N
  101. ULL, "delay_bye_limit" = NULL, "max_duration" = NULL, "marketplace" = '0', "rating_type" = '0', "billing_type" = NULL, "trunk_type" = NULL, "switch_profile_id" = NULL, "transa
  102. ction_fee_id" = NULL, "service_type" = '0', "product_id" = NULL, "rpid" = NULL, "paid" = NULL, "oli" = NULL, "pci" = NULL, "priv" = NULL, "div" = NULL, "trunk_type2" = '1', "a
  103. ccount_id" = NULL, "billing_method" = NULL, "amount_per_port" = NULL, "billing_rule" = NULL, "ignore_early_nosdp" = NULL, "media_timeout" = NULL, "private" = '0', "agent_type"
  104. = NULL, "bill_by" = '4', "rate_profile" = '0', "us_route" = '0', "intl_route" = '0', "canada_route" = '0', "rate_decimal" = '6', "rate_rounding" = '0', "us_other" = '0', "can
  105. ada_other" = '0', "redirect" = '0', "lrn_prefix" = '1', "pass_response_code" = '0', "is_del" = '0', "dtmf_type" = '3', "dtmf_detect" = '0', "rpid_screen" = '0', "rpid_party" =
  106. '0', "display_name" = NULL, "rpid_id_type" = '0', "rpid_privacy" = '0', "counter_time" = NULL, "number" = NULL, "block_time" = NULL, "re_invite" = NULL, "re_invite_interval"
  107. = NULL, "info" = NULL, "rfc2833" = NULL, "inband" = NULL, "dummy_trunk" = FALSE, "random_table_id" = NULL, "is_virtual" = FALSE, "rfc_r833_payload" = NULL, "resource_template_
  108. id" = NULL, "rate_use_rpid" = FALSE, "group_id" = NULL, "resource_block_group_id" = NULL, "block_404_number_time" = NULL, "price_per_actual_channel" = NULL, "price_per_max_cha
  109. nnel" = NULL, "enfource_cid" = FALSE, "ani_cps_limit" = NULL, "ani_cap_limit" = NULL, "dnis_cps_limit" = NULL, "dnis_cap_limit" = NULL WHERE "resource"."resource_id" = '304'
  110. < 2017-07-21 03:34:34.599 GMT >ERROR: INSERT has more expressions than target columns at character 36
  111. < 2017-07-21 03:34:34.599 GMT >QUERY: insert into resource_record select OLD.*,EXTRACT(EPOCH from current_timestamp(0)),'B'
  112. < 2017-07-21 03:34:34.599 GMT >CONTEXT: PL/pgSQL function class4_trigfun_record_resource() line 8 at SQL statement
  113. < 2017-07-21 03:34:34.599 GMT >STATEMENT: UPDATE "resource" SET "resource_id" = '304', "name" = NULL, "ingress" = TRUE, "egress" = FALSE, "active" = TRUE, "rfc_2833" = FALSE,
  114. "t38" = TRUE, "alias" = 'did_vendor1', "res_strategy" = NULL, "cps_limit" = NULL, "capacity" = DEFAULT, "lnp" = FALSE, "lrn_block" = FALSE, "client_id" = '251', "tdm" = TRUE,
  115. "rate_table_id" = '248', "transnexus" = NULL, "route_strategy_id" = '3', "media_type" = '2', "pass_through" = NULL, "profit_margin" = '0', "enough_balance" = TRUE, "egress_bi
  116. ll_after_action" = TRUE, "proto" = '1', "dnis_only" = TRUE, "ring_timeout" = '60', "ignore_ring" = FALSE, "ignore_early_media" = FALSE, "disable_by_alert" = FALSE, "priority"
  117. = '0', "last_priority" = '0', "create_time" = '2017-07-17 15:02:31+00', "update_time" = '2017-07-17 15:02:31+00', "status" = '1', "wait_ringtime180" = '6000', "profit_type" =
  118. '1', "lnp_dipping" = FALSE, "lnp_dipping_rate" = NULL, "update_at" = '2017-07-17 15:02:31+00', "update_by" = NULL, "cli_type" = NULL, "auth_type" = '0', "delay_bye_second" = N
  119. ULL, "delay_bye_limit" = NULL, "max_duration" = NULL, "marketplace" = '0', "rating_type" = '0', "billing_type" = NULL, "trunk_type" = NULL, "switch_profile_id" = NULL, "transa
  120. ction_fee_id" = NULL, "service_type" = '0', "product_id" = NULL, "rpid" = NULL, "paid" = NULL, "oli" = NULL, "pci" = NULL, "priv" = NULL, "div" = NULL, "trunk_type2" = '1', "a
  121. ccount_id" = NULL, "billing_method" = NULL, "amount_per_port" = NULL, "billing_rule" = NULL, "ignore_early_nosdp" = NULL, "media_timeout" = NULL, "private" = '0', "agent_type"
  122. = NULL, "bill_by" = '4', "rate_profile" = '0', "us_route" = '0', "intl_route" = '0', "canada_route" = '0', "rate_decimal" = '6', "rate_rounding" = '0', "us_other" = '0', "can
  123. ada_other" = '0', "redirect" = '0', "lrn_prefix" = '1', "pass_response_code" = '0', "is_del" = '0', "dtmf_type" = '3', "dtmf_detect" = '0', "rpid_screen" = '0', "rpid_party" =
  124. '0', "display_name" = NULL, "rpid_id_type" = '0', "rpid_privacy" = '0', "counter_time" = NULL, "number" = NULL, "block_time" = NULL, "re_invite" = NULL, "re_invite_interval"
  125. = NULL, "info" = NULL, "rfc2833" = NULL, "inband" = NULL, "dummy_trunk" = FALSE, "random_table_id" = NULL, "is_virtual" = FALSE, "rfc_r833_payload" = NULL, "resource_template_
  126. id" = NULL, "rate_use_rpid" = FALSE, "group_id" = NULL, "resource_block_group_id" = NULL, "block_404_number_time" = NULL, "price_per_actual_channel" = NULL, "price_per_max_cha
  127. nnel" = NULL, "enfource_cid" = FALSE, "ani_cps_limit" = NULL, "ani_cap_limit" = NULL, "dnis_cps_limit" = NULL, "dnis_cap_limit" = NULL WHERE "resource"."resource_id" = '304'
  128. < 2017-07-21 03:41:40.993 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  129. < 2017-07-21 03:41:40.993 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  130. < 2017-07-21 03:42:40.990 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  131. < 2017-07-21 03:42:40.990 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  132. < 2017-07-21 03:46:54.753 GMT >ERROR: INSERT has more expressions than target columns at character 36
  133. < 2017-07-21 03:46:54.753 GMT >QUERY: insert into resource_record select NEW.*,EXTRACT(EPOCH from current_timestamp(0)),'I'
  134. < 2017-07-21 03:46:54.753 GMT >CONTEXT: PL/pgSQL function class4_trigfun_record_resource() line 4 at SQL statement
  135. < 2017-07-21 03:46:54.753 GMT >STATEMENT: INSERT INTO "resource" ("ingress", "egress", "alias", "client_id", "media_type", "media_timeout", "profit_margin", "profit_type", "c
  136. apacity", "cps_limit", "active", "t38", "wait_ringtime180", "res_strategy", "lnp_dipping", "delay_bye_second", "max_duration", "rate_table_id", "ring_timeout", "rate_use_rpid"
  137. , "enfource_cid", "rpid", "block_404_number_time", "ignore_ring", "ignore_early_media", "update_at", "update_by", "rate_decimal") VALUES (FALSE, TRUE, 'test-test', '257', '2',
  138. DEFAULT, '0', '1', NULL, NULL, TRUE, TRUE, '6000', '1', FALSE, DEFAULT, '3600', DEFAULT, '60', FALSE, FALSE, '1', '0', FALSE, FALSE, '2017-07-21 03:46:54', 'admin', '6')
  139. < 2017-07-21 03:53:41.990 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  140. < 2017-07-21 03:53:41.990 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  141. < 2017-07-21 03:54:28.992 GMT >ERROR: syntax error at or near "," at character 114
  142. < 2017-07-21 03:54:28.992 GMT >STATEMENT: UPDATE client SET is_daily_balance_notification = true,
  143. enable_payment_alert = ,
  144. low_balance_notice = false, notify_client_balance = NULL,
  145. zero_balance_notice = false,
  146. zero_balance_notice_time = 0,
  147. daily_balance_notification = NULL,
  148. daily_balance_recipient = 0, is_auto_summary = true,
  149. auto_send_zone = '+00:00', low_balance_number = NULL WHERE client_id = 265
  150. < 2017-07-21 03:54:41.202 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  151. < 2017-07-21 03:54:41.202 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  152. < 2017-07-21 04:05:38.636 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  153. < 2017-07-21 04:05:38.636 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  154. < 2017-07-21 04:06:38.934 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  155. < 2017-07-21 04:06:38.934 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  156. < 2017-07-21 04:17:39.300 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  157. < 2017-07-21 04:17:39.300 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  158. < 2017-07-21 04:18:39.419 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  159. < 2017-07-21 04:18:39.419 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  160. < 2017-07-21 04:20:39.020 GMT >ERROR: syntax error at or near "," at character 114
  161. < 2017-07-21 04:20:39.020 GMT >STATEMENT: UPDATE client SET is_daily_balance_notification = true,
  162. enable_payment_alert = ,
  163. low_balance_notice = false, notify_client_balance = NULL,
  164. zero_balance_notice = false,
  165. zero_balance_notice_time = 0,
  166. daily_balance_notification = NULL,
  167. daily_balance_recipient = 0, is_auto_summary = true,
  168. auto_send_zone = '+00:00', low_balance_number = NULL WHERE client_id = 266
  169. < 2017-07-21 04:29:39.713 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  170. < 2017-07-21 04:29:39.713 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  171. < 2017-07-21 04:30:39.460 GMT >ERROR: pg_stat_statements must be loaded via shared_preload_libraries
  172. < 2017-07-21 04:30:39.460 GMT >STATEMENT: select round((sum(total_time) / sum(calls))::numeric,2) from pg_stat_statements
  173. [root@testing pg_log]#
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!