Y25-034 - [BUG] Exception (ActiveRecord::StatementInvalid) "Mysql2::Error: Table 'sequencescape_snapshot.labware' doesn't exist

[BenTopping]

Describe the bug

[Psd-exceptions] [Sequencescape Training]  (ActiveRecord::StatementInvalid) "Mysql2::Error: Table 'sequencescape_snapshot.labware' doesn't

An ActiveRecord::StatementInvalid occurred in background at 2025-01-18 12:00:10 +0000 :

  Mysql2::Error: Table 'sequencescape_snapshot.labware' doesn't exist
  /var/www/sequencescape/shared/vendor/bundle/ruby/3.2.0/gems/mysql2-0.5.6/lib/mysql2/client.rb:151:in `_query'

Acceptance Criteria

• Review if the Fluidigm Data Cron is still current and necessary.
• Finding and applying a solution
• Document progress + summary in the issue comments

To Reproduce
Steps to reproduce the behaviour:

1. Error occurs weekly during database reset

Expected behaviour
An error is not thrown

Additional context
Error message contains the below
data: {:message=>"Import Fluidigm Data Cron Failed"}

It is likely that the cron running every hour fails during the weekly training database dump as the tables may temporarily not exist.

[stevieing]

This has been happening for 8 years. You are correct that it is caused by the training database being recreated.