Skip to content

config.example: add pg_stat_kcache to shared_preload_libraries (required for observation)

Vitaliy Kukharik requested to merge pg-stat-kcache into master

Description

The observation component requires the “pg_stat_kcache” extension for the preparation of artifacts.

This MR fix the error:

2022/05/05 17:53:41 logging.go:16: [INFO]   ->  POST /observation/start
2022/05/05 17:53:41 observation.go:45: [DEBUG]  Start Observation session {c8cic40rn5fmbqu0olo0 c9q0u8grn5fi2vo578ug 2022-05-05 17:53:41 UTC {1 1 600} map[branch:main branch_link:https://github.com/postgres-a
i/dblab-ci-test-flyway/tree/main data_state_at:2022-05-05T17:32:56Z diff_link:https://github.com/postgres-ai/dblab-ci-test-flyway/compare/55b9a9ebf153...1fb92fc02c68 dle_version:v3.1.0-25-g355992c-20220504-21
45 launched_by:vitabaks request_link: revision:1fb92fc02c68c96b15fe90e9fd04b086c9650b3a revision_link:https://github.com/postgres-ai/dblab-ci-test-flyway/commit/1fb92fc02c68c96b15fe90e9fd04b086c9650b3a userna
me_full:Vitaliy Kukharik username_link:https://github.com/vitabaks]}
2022/05/05 17:53:41 observation.go:57: [DEBUG]  Start observation response {{   } 386}
2022/05/05 17:53:41 observing_clone.go:172: [DEBUG]  Init observation for SessionID:  386
2022/05/05 17:53:41 observing_clone.go:281: [DEBUG]  Artifacts path /var/lib/dblab/dblab_pool/clones/dblab_clone_6004/data/observer/c9q0u8grn5fi2vo578ug/386/artifacts
2022/05/05 17:53:41 errors.go:21: [ERROR]  [ERROR] - POST /observation/start - failed to init observing session: failed to reset clone statistics: failed to create the pg_stat_kcache extension: ERROR: This mo
dule can only be loaded via shared_preload_libraries (SQLSTATE XX000)
2022/05/05 17:53:41 util.go:31: [DEBUG]  Response: ERROR: This module can only be loaded via shared_preload_libraries (SQLSTATE XX000)

Related issue

Examples

Checklist

  • MR description has been reviewed
  • MR changes are functionally tested
  • MR does NOT have text changes OR there are text changes and they have been reviewed
  • MR does NOT have API/CLI changes OR there are API/CLI changes and they have been reviewed
  • MR does NOT have UI changes OR there are UI changes and they have been reviewed

Merge request reports