Skip to content

ошибки в bootstrap новой версии 3.0 #162

Closed
@sgrinko

Description

@sgrinko

Добрый день,

  1. Если выполнить развертывание bootstrap в БД, то в новой схеме mamonsu нет функции: mamonsu.buffer_cache()
[INFO] 2021-08-26 10:40:42,652 - PGSQL-(host=localhost db=mamonsu user=mamonsu port=5432)       -       connected
[ERROR] 2021-08-26 10:40:42,653 - PGBUFFERCACHE -       catch error: {'S': 'ERROR', 'V': 'ERROR', 'C': '42883', 'M': 'function mamonsu.buffer_cache() does not exist', 'H': 'No function matches the
 given name and argument types. You might need to add explicit type casts.', 'P': '37', 'F': 'parse_func.c', 'L': '627', 'R': 'ParseFuncOrColumn'}
[INFO] 2021-08-26 10:40:42,653 - PGBUFFERCACHE  -       hint: enable debug level to full exception trace

изображение

  1. Попробовал ключ -x новой версии и если расширения уже есть в БД, то проверок в коде нет, что приводит к появлению следующих ошибок:
$ mamonsu bootstrap -M mamonsu -x -U postgres -d mamonsu --port=5432
Bootstrap failed to create pg_buffercache extension.
Error: {'S': 'ERROR', 'V': 'ERROR', 'C': '42710', 'M': 'extension "pg_buffercache" already exists', 'F': 'extension.c', 'L': '1713', 'R': 'CreateExtension'}
Please install pg_buffercache extension and rerun bootstrap if you want to get metrics from pg_buffercache view.
Bootstrap failed to create the function which required pg_buffercache extension.
Error: {'S': 'ERROR', 'V': 'ERROR', 'C': '42P01', 'M': 'relation "mamonsu.pg_buffercache" does not exist', 'P': '362', 'F': 'parse_relation.c', 'L': '1355', 'R': 'parserOpenTable'}
Please install pg_buffercache extension and rerun bootstrap if you want to get metrics from pg_buffercache view.
Bootstrap failed to grant execution permission to the function which required pg_buffercache extension.
Error:
 {'S': 'ERROR', 'V': 'ERROR', 'C': '42883', 'M': 'function mamonsu.buffer_cache() does not exist', 'F': 'parse_func.c', 'L': '2322', 'R': 'LookupFuncWithArgs'}
Bootstrap successfully completed

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions