```[MainThread][WARNING][2019-12-19 17:22:57,581] ...
# announcements
k
```[MainThread][WARNING][2019-12-19 172257,581] after_install hook 'after_install' has failed: (sqlite3.OperationalError) no such table: plugin_settings [SQL: 'SELECT plugin_settings.label AS plugin_settings_label, plugin_settings.description AS plugin_settings_description, plugin_settings.name AS plugin_settings_name, plugin_settings.namespace AS plugin_settings_namespace, plugin_settings.value AS plugin_settings_value, plugin_settings.enabled AS plugin_settings_enabled \nFROM plugin_settings \nWHERE plugin_settings.namespace = ? AND plugin_settings.name = ? AND plugin_settings.enabled = 1'] [parameters: ('orchestrators.airflow', 'core.dags_folder')] (Background on this error at: http://sqlalche.me/e/e3q8) Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context context) File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such table: plugin_settings The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/bin/meltano", line 8, in <module> sys.exit(main()) File "/usr/local/lib/python3.6/site-packages/meltano/cli/__init__.py", line 22, in main cli(obj={"project": None}) File "/usr/local/lib/python3.6/site-packages/click/core.py", line 764, in call return self.main(*args, **kwargs) File "/usr/local/lib/python3.6/site-packages/click/core.py", line 717, in main rv = self.invoke(ctx) File "/usr/local/lib/python3.6/site-packages/click/core.py", line 1137, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python3.6/site-packages/click/core.py", line 956, in invoke return ctx.invoke(self.callback, **ctx.params) File "/usr/local/lib/python3.6/site-packages/click/core.py", line 555, in invoke return callback(*args, **kwargs) File "/usr/local/lib/python3.6/site-packages/meltano/cli/params.py", line 24, in decorate return func(engine_uri, *args, **kwargs) File "/usr/local/lib/python3.6/site-packages/meltano/cli/params.py", line 55, in decorate func(project, *args, **kwargs) File "/usr/local/lib/python3.6/site-packages/meltano/cli/install.py", line 32, in install install_status = install_service.install_all_plugins(install_status_update) File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin_install_service.py", line 41, in install_all_plugins self.install_plugin(plugin) File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin_install_service.py", line 70, in install_plugin namespace=plugin.type, name=plugin.name, pip_url=plugin.pip_url File "/usr/local/lib/python3.6/contextlib.py", line 88, in exit next(self.gen) File "/usr/local/lib/python3.6/site-packages/meltano/core/behavior/hookable.py", line 61, in trigger_hooks self.class.trigger(self, f"after_{hook_name}", *args, **kwargs) File "/usr/local/lib/python3.6/site-packages/meltano/core/behavior/hookable.py", line 80, in trigger raise err File "/usr/local/lib/python3.6/site-packages/meltano/core/behavior/hookable.py", line 74, in trigger hook_func(target, *args, **kwargs) File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin/airflow.py", line 69, in after_install plugin_config_service=plugin_config_service, File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin_invoker.py", line 27, in invoker_factory invoker.prepare(prepare_with_session) File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin_invoker.py", line 108, in prepare self.load_plugin_config(session) File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin_invoker.py", line 104, in load_plugin_config session, self.plugin File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin/settings_service.py", line 66, in as_confi…
m
Hi, by default meltano stores its system database in the
.meltano
folder.
Looking at our CLI,
meltano install
doesn't run the migration, hence the issue you see here.
I'll create an issue to fix this, but in the meantime, running
meltano upgrade
should do the trick and re-create your system database.
k
thank you! that worked