2023-07-14T11:19:59.775528Z [debug ] tail consumer completed first 2023-07-14T11:19:59.841440Z [debug ] Deleted configuration at /project/project/.meltano/run/tap-hubspot-contacts/tap.a6329f81-cb01-4dd9-96a9-a7e7992a1fdd.config.json 2023-07-14T11:19:59.842694Z [debug ] Deleted configuration at /project/project/.meltano/run/target-s3/target.58734698-c1bd-4421-9256-293ea7a4486c.config.json 2023-07-14T11:19:59.856649Z [error ] Loader failed 2023-07-14T11:19:59.857180Z [error ] Block run completed. block_type=ExtractLoadBlocks err=RunnerError('Loader failed') exit_codes={: -9} set_number=0 success=False 2023-07-14T11:20:01.415899Z [debug ] Need help fixing this problem? Visit http://melta.no/ for troubleshooting steps, or to join our friendly Slack community. Run invocation could not be completed as block failed: Loader failed ╭───────────────────── Traceback (most recent call last) ──────────────────────╮ │ /venv/lib/python3.9/site-packages/meltano/cli/run.py:172 in _run_blocks │ │ │ │ 169 │ │ │ continue │ │ 170 │ │ │ │ 171 │ │ try: │ │ ❱ 172 │ │ │ await blk.run() │ │ 173 │ │ except RunnerError as err: │ │ 174 │ │ │ logger.error( │ │ 175 │ │ │ │ "Block run completed.", │ │ │ │ /venv/lib/python3.9/site-packages/meltano/core/block/extract_load.py:444 in │ │ run │ │ │ │ 441 │ │ │ # TODO: legacy `meltano elt` style logging should be depre │ │ 442 │ │ │ legacy_log_handler = self.output_logger.out("meltano", log │ │ 443 │ │ │ with legacy_log_handler.redirect_logging(): │ │ ❱ 444 │ │ │ │ await self.run_with_job() │ │ 445 │ │ │ │ return │ │ 446 │ │ else: │ │ 447 │ │ │ logger.warning( │ │ │ │ /venv/lib/python3.9/site-packages/meltano/core/block/extract_load.py:474 in │ │ run_with_job │ │ │ │ 471 │ │ │ │ 472 │ │ with closing(self.context.session) as session: │ │ 473 │ │ │ async with job.run(session): │ │ ❱ 474 │ │ │ │ await self.execute() │ │ 475 │ │ │ 476 │ async def terminate(self, graceful: bool = False) -> None: │ │ 477 │ │ """Terminate an in flight ExtractLoad execution, potentially d │ │ │ │ /venv/lib/python3.9/site-packages/meltano/core/block/extract_load.py:436 in │ │ execute │ │ │ │ 433 │ │ async with self._start_blocks(): │ │ 434 │ │ │ await self._link_io() │ │ 435 │ │ │ manager = ELBExecutionManager(self) │ │ ❱ 436 │ │ │ await manager.run() │ │ 437 │ │ │ 438 │ async def run(self) -> None: │ │ 439 │ │ """Run the ELT task.""" │ │ │ │ /venv/lib/python3.9/site-packages/meltano/core/block/extract_load.py:640 in │ │ run │ │ │ │ 637 │ │ any of the blocks exit with a non 0 exit code. │ │ 638 │ │ """ │ │ 639 │ │ await self._wait_for_process_completion(self.elb.head) │ │ ❱ 640 │ │ _check_exit_codes( │ │ 641 │ │ │ self._producer_code, │ │ 642 │ │ │ self._consumer_code, │ │ 643 │ │ │ self._intermediate_codes, │ │ │ │ /venv/lib/python3.9/site-packages/meltano/core/block/extract_load.py:809 in │ │ _check_exit_codes │ │ │ │ 806 │ │ raise RunnerError("Extractor failed", {PluginType.EXTRACTORS: │ │ 807 │ │ │ 808 │ if consumer_code: │ │ ❱ 809 │ │ raise RunnerError("Loader failed", {PluginType.LOADERS: consum │ │ 810 │ │ │ 811 │ failed_mappers = [ │ │ 812 │ │ {mapper_id: exit_code} │ ╰──────────────────────────────────────────────────────────────────────────────╯ RunnerError: Loader failed The above exception was the direct cause of the following exception: ╭───────────────────── Traceback (most recent call last) ──────────────────────╮ │ /venv/lib/python3.9/site-packages/meltano/cli/__init__.py:105 in _run_cli │ │ │ │ 102 │ """ │ │ 103 │ try: │ │ 104 │ │ try: # noqa: WPS225, WPS505 │ │ ❱ 105 │ │ │ cli(obj={"project": None}) │ │ 106 │ │ except ProjectReadonly as err: │ │ 107 │ │ │ raise CliError( │ │ 108 │ │ │ │ f"The requested action could not be completed: {err}", │ │ │ │ /venv/lib/python3.9/site-packages/click/core.py:1130 in __call__ │ │ │ │ 1127 │ │ │ 1128 │ def __call__(self, *args: t.Any, **kwargs: t.Any) -> t.Any: │ │ 1129 │ │ """Alias for :meth:`main`.""" │ │ ❱ 1130 │ │ return self.main(*args, **kwargs) │ │ 1131 │ │ 1132 │ │ 1133 class Command(BaseCommand): │ │ │ │ /venv/lib/python3.9/site-packages/meltano/cli/cli.py:43 in main │ │ │ │ 40 │ │ │ args: Positional arguments for the Click group. │ │ 41 │ │ │ kwargs: Keyword arguments for the Click group. │ │ 42 │ │ """ │ │ ❱ 43 │ │ return super().main(*args, windows_expand_args=False, **kwargs │ │ 44 │ │ 45 │ │ 46 @click.group( │ │ │ │ /venv/lib/python3.9/site-packages/click/core.py:1055 in main │ │ │ │ 1052 │ │ try: │ │ 1053 │ │ │ try: │ │ 1054 │ │ │ │ with self.make_context(prog_name, args, **extra) as c │ │ ❱ 1055 │ │ │ │ │ rv = self.invoke(ctx) │ │ 1056 │ │ │ │ │ if not standalone_mode: │ │ 1057 │ │ │ │ │ │ return rv │ │ 1058 │ │ │ │ │ # it's not safe to `ctx.exit(rv)` here! │ │ │ │ /venv/lib/python3.9/site-packages/meltano/cli/utils.py:612 in invoke │ │ │ │ 609 │ │ enact_environment_behavior(self.environment_behavior, ctx) │ │ 610 │ │ if ctx.obj.get("tracker"): │ │ 611 │ │ │ ctx.obj["tracker"].add_contexts(CliContext.from_click_cont │ │ ❱ 612 │ │ super().invoke(ctx) │ │ 613 │ │ 614 │ │ 615 class InstrumentedDefaultGroup(InstrumentedGroupMixin, DefaultGroup): │ │ │ │ /venv/lib/python3.9/site-packages/click/core.py:1657 in invoke │ │ │ │ 1654 │ │ │ │ super().invoke(ctx) │ │ 1655 │ │ │ │ sub_ctx = cmd.make_context(cmd_name, args, parent=ctx │ │ 1656 │ │ │ │ with sub_ctx: │ │ ❱ 1657 │ │ │ │ │ return _process_result(sub_ctx.command.invoke(sub │ │ 1658 │ │ │ │ 1659 │ │ # In chain mode we create the contexts step by step, but afte │ │ 1660 │ │ # base command has been invoked. Because at that point we do │ │ │ │ /venv/lib/python3.9/site-packages/meltano/cli/utils.py:661 in invoke │ │ │ │ 658 │ │ if ctx.obj.get("tracker"): │ │ 659 │ │ │ ctx.obj["tracker"].add_contexts(CliContext.from_click_cont │ │ 660 │ │ │ ctx.obj["tracker"].track_command_event(CliEvent.started) │ │ ❱ 661 │ │ super().invoke(ctx) │ │ 662 │ │ │ │ /venv/lib/python3.9/site-packages/click/core.py:1404 in invoke │ │ │ │ 1401 │ │ │ echo(style(message, fg="red"), err=True) │ │ 1402 │ │ │ │ 1403 │ │ if self.callback is not None: │ │ ❱ 1404 │ │ │ return ctx.invoke(self.callback, **ctx.params) │ │ 1405 │ │ │ 1406 │ def shell_complete(self, ctx: Context, incomplete: str) -> t.List │ │ 1407 │ │ """Return a list of completions for the incomplete value. Loo │ │ │ │ /venv/lib/python3.9/site-packages/click/core.py:760 in invoke │ │ │ │ 757 │ │ │ │ 758 │ │ with augment_usage_errors(__self): │ │ 759 │ │ │ with ctx: │ │ ❱ 760 │ │ │ │ return __callback(*args, **kwargs) │ │ 761 │ │ │ 762 │ def forward( │ │ 763 │ │ __self, __cmd: "Command", *args: t.Any, **kwargs: t.Any # no │ │ │ │ /venv/lib/python3.9/site-packages/meltano/cli/params.py:27 in decorate │ │ │ │ 24 │ │ if database_uri: │ │ 25 │ │ │ ProjectSettingsService.config_override["database_uri"] = da │ │ 26 │ │ │ │ ❱ 27 │ │ return func(*args, **kwargs) │ │ 28 │ │ │ 29 │ return functools.update_wrapper(decorate, func) │ │ 30 │ │ │ │ /venv/lib/python3.9/site-packages/meltano/cli/params.py:76 in decorate │ │ │ │ 73 │ │ │ │ except MigrationError as err: │ │ 74 │ │ │ │ │ raise CliError(str(err)) from err │ │ 75 │ │ │ │ │ ❱ 76 │ │ │ func(project, *args, **kwargs) │ │ 77 │ │ │ │ 78 │ │ return functools.update_wrapper(decorate, func) │ │ 79 │ │ │ │ /venv/lib/python3.9/site-packages/click/decorators.py:26 in new_func │ │ │ │ 23 │ """ │ │ 24 │ │ │ 25 │ def new_func(*args, **kwargs): # type: ignore │ │ ❱ 26 │ │ return f(get_current_context(), *args, **kwargs) │ │ 27 │ │ │ 28 │ return update_wrapper(t.cast(F, new_func), f) │ │ 29 │ │ │ │ /venv/lib/python3.9/site-packages/meltano/core/utils/__init__.py:79 in │ │ wrapper │ │ │ │ 76 │ │ │ 77 │ @functools.wraps(func) │ │ 78 │ def wrapper(*args, **kwargs): # noqa: WPS430 │ │ ❱ 79 │ │ return asyncio.run(func(*args, **kwargs)) │ │ 80 │ │ │ 81 │ return wrapper │ │ 82 │ │ │ │ /usr/local/lib/python3.9/asyncio/runners.py:44 in run │ │ │ │ 41 │ │ events.set_event_loop(loop) │ │ 42 │ │ if debug is not None: │ │ 43 │ │ │ loop.set_debug(debug) │ │ ❱ 44 │ │ return loop.run_until_complete(main) │ │ 45 │ finally: │ │ 46 │ │ try: │ │ 47 │ │ │ _cancel_all_tasks(loop) │ │ │ │ /usr/local/lib/python3.9/asyncio/base_events.py:647 in run_until_complete │ │ │ │ 644 │ │ if not future.done(): │ │ 645 │ │ │ raise RuntimeError('Event loop stopped before Future comp │ │ 646 │ │ │ │ ❱ 647 │ │ return future.result() │ │ 648 │ │ │ 649 │ def stop(self): │ │ 650 │ │ """Stop running the event loop. │ │ │ │ /venv/lib/python3.9/site-packages/meltano/cli/run.py:141 in run │ │ │ │ 138 │ │ await _run_blocks(tracker, parsed_blocks, dry_run=dry_run) │ │ 139 │ except Exception as err: │ │ 140 │ │ tracker.track_command_event(CliEvent.failed) │ │ ❱ 141 │ │ raise err │ │ 142 │ tracker.track_command_event(CliEvent.completed) │ │ 143 │ │ 144 │ │ │ │ /venv/lib/python3.9/site-packages/meltano/cli/run.py:138 in run │ │ │ │ 135 │ │ tracker.track_command_event(CliEvent.aborted) │ │ 136 │ │ raise CliError("Some ExtractLoadBlocks set failed validation." │ │ 137 │ try: │ │ ❱ 138 │ │ await _run_blocks(tracker, parsed_blocks, dry_run=dry_run) │ │ 139 │ except Exception as err: │ │ 140 │ │ tracker.track_command_event(CliEvent.failed) │ │ 141 │ │ raise err │ │ │ │ /venv/lib/python3.9/site-packages/meltano/cli/run.py:184 in _run_blocks │ │ │ │ 181 │ │ │ ) │ │ 182 │ │ │ with tracker.with_contexts(tracking_ctx): │ │ 183 │ │ │ │ tracker.track_block_event(blk_name, BlockEvents.failed │ │ ❱ 184 │ │ │ raise CliError( │ │ 185 │ │ │ │ f"Run invocation could not be completed as block faile │ │ 186 │ │ │ ) from err │ │ 187 │ │ except Exception as bare_err: │ ╰──────────────────────────────────────────────────────────────────────────────╯ CliError: Run invocation could not be completed as block failed: Loader failed The above exception was the direct cause of the following exception: ╭───────────────────── Traceback (most recent call last) ──────────────────────╮ │ /venv/lib/python3.9/site-packages/meltano/cli/__init__.py:115 in _run_cli │ │ │ │ 112 │ │ except MeltanoError as err: │ │ 113 │ │ │ handle_meltano_error(err) │ │ 114 │ │ except Exception as err: │ "│ ❱ 115 │ │ │ raise CliError(f"{troubleshooting_message} {err}") from e │" │ 116 │ except CliError as cli_error: │ │ 117 │ │ cli_error.print() │ │ 118 │ │ sys.exit(1) │ ╰──────────────────────────────────────────────────────────────────────────────╯ CliError: Need help fixing this problem? Visit http://melta.no/ for troubleshooting steps, or to join our friendly Slack community. Run invocation could not be completed as block failed: Loader failed Need help fixing this problem? Visit http://melta.no/ for troubleshooting steps, or to join our friendly Slack community. Run invocation could not be completed as block failed: Loader failed