hi all, experiencing similar to <@U059UGE5HJ7> iss...
# community-support
a
hi all, experiencing similar to @Shay Misgav issue. i’m getting error (see in thread) from running command. note, this error started yesterday only - i was able to run the below successfully until then.
edr send-report --google-service-account-path service-keyfile.json --gcs-bucket-name gcs-bucket-name  --bucket-file-path data-health-report.html --update-bucket-website true
dbt packages/modules info running on python 3.8.13
Copy code
dbt-core==1.7.0
elementary-data[bigquery]==0.14.1

  - package: dbt-labs/dbt_utils
    version: 1.1.1
  - package: elementary-data/elementary
    version: 0.14.0
unfortunately, i’m unable to reproduce this error locally - only fails when running via cloud run job (GCP service). any pointers will be much appreciated - thanks!
🙌 1
Copy code
— ERROR — Could not generate the report - Error: Failed to run dbt command.
Copy code
Traceback (most recent call last):
  File "/home/dbtuser/venv/lib/python3.8/site-packages/elementary/clients/dbt/dbt_runner.py", line 88, in _run_command
    result = subprocess.run(
  File "/usr/local/lib/python3.8/subprocess.py", line 516, in run
    raise CalledProcessError(retcode, process.args,
subprocess.CalledProcessError: Command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_test_results", "macro_args": {"days_back": 7, "invocations_per_test": 720, "disable_passed_test_metrics": false}}', '--project-dir', '/home/dbtuser/venv/lib/python3.8/site-packages/elementary/monitor/dbt_project']' died with <Signals.SIGKILL: 9>.
Copy code
Traceback (most recent call last):
  File "/home/dbtuser/venv/lib/python3.8/site-packages/elementary/monitor/api/report/report.py", line 50, in get_report_data
    tests_api = TestsAPI(
  File "/home/dbtuser/venv/lib/python3.8/site-packages/elementary/monitor/api/tests/tests.py", line 39, in __init__
    self.test_results_db_rows = self._get_test_results_db_rows(
  File "/home/dbtuser/venv/lib/python3.8/site-packages/elementary/monitor/api/tests/tests.py", line 51, in _get_test_results_db_rows
    return self.tests_fetcher.get_all_test_results_db_rows(
  File "/home/dbtuser/venv/lib/python3.8/site-packages/elementary/monitor/fetchers/tests/tests.py", line 22, in get_all_test_results_db_rows
    run_operation_response = self.dbt_runner.run_operation(
  File "/home/dbtuser/venv/lib/python3.8/site-packages/elementary/clients/dbt/dbt_runner.py", line 160, in run_operation
    success, command_output = self._run_command(
  File "/home/dbtuser/venv/lib/python3.8/site-packages/elementary/clients/dbt/dbt_runner.py", line 99, in _run_command
    raise DbtCommandError(err, command_args, logs=logs)
elementary.exceptions.exceptions.DbtCommandError: Failed to run dbt command.
n
Hey @Amir Brohi 👋🏼 I looked for the error you got:
died with <Signals.SIGKILL: 9>.
and it looks like the most common cause is out of memory issue. Is it possible that your machine runs out of memory?
a
ah, i see - i’ll look into the worker’s memory/storage and let you know. thanks @Noy Arie!
👍🏼 1