Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB table cached_heartbeats not found #132

Open
justinvasel opened this issue Nov 19, 2024 · 0 comments · May be fixed by #130
Open

DB table cached_heartbeats not found #132

justinvasel opened this issue Nov 19, 2024 · 0 comments · May be fixed by #130
Assignees
Labels
bug Something isn't working

Comments

@justinvasel
Copy link
Contributor

Invoked by run_feedback function

Traceback (most recent call last):
  File "/scif/apps/snews_cs/snewscoinc-venv/bin/snews_cs", line 8, in <module>
    sys.exit(main())
             ^^^^^^
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/snews_cs/__main__.py", line 65, in run_feedback
    feedback()
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/snews_cs/heartbeat_feedbacks.py", line 62, in __call__
    df = self.read_database() # Received times are already parsed
         ^^^^^^^^^^^^^^^^^^^^
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/snews_cs/heartbeat_feedbacks.py", line 77, in read_database
    cache_df = pd.read_sql_table('cached_heartbeats', cache_engine,
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/scif/apps/snews_cs/snewscoinc-venv/lib/python3.11/site-packages/pandas/io/sql.py", line 386, in read_sql_table
    raise ValueError(f"Table {table_name} not found")
ValueError: Table cached_heartbeats not found
INFO:    Cleaning up image...
snewsdev@avogadro:~/apps/snews_cs$ sqlite3 ../../data/snews_cs/db/snews_db.sqlite
SQLite version 3.37.2 2022-01-06 13:25:41
Enter ".help" for usage hints.
sqlite> .tables
all_mgs                   coincidence_tier_archive  time_tier_archive
coincidence_tier_alerts   sig_tier_archive
@justinvasel justinvasel added the bug Something isn't working label Nov 19, 2024
@justinvasel justinvasel self-assigned this Nov 19, 2024
@justinvasel justinvasel linked a pull request Nov 19, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant