Skip to content

[Bug]: Suspect database issues #612

@rbrowning85

Description

@rbrowning85

Contact Details

No response

What happened?

When I start FastenHealth I get the following errors. I suspect there is are issues with my database, but I am not sure how to troubleshoot them, and I would really prefer not to start from scratch.

 o888o                       o8                          
o888oo ooooooo    oooooooo8 o888oo ooooooooo8 oo oooooo   
 888   ooooo888  888ooooooo  888  888oooooo8   888   888  
 888 888    888          888 888  888          888   888  
o888o 88ooo88 8o 88oooooo88   888o  88oooo888 o888o o888o
github.com/fastenhealth/fasten-onprem         .-1.1.3

Creating event bus instance now.

2025/10/06 23:54:34  SLOW SQL >= 200ms
[78050.260ms] [rows:1469] INSERT INTO `fhir_binary__temp`(`id`,`created_at`,`updated_at`,`deleted_at`,`user_id`,`source_id`,`source_resource_type`,`source_resource_id`,`sort_date`,`sort_title`,`source_uri`,`resource_raw`,`language`,`metaLastUpdated`,`metaProfile`,`metaTag`,`metaVersionId`,`text`,`type`,`note`) SELECT `id`,`created_at`,`updated_at`,`deleted_at`,`user_id`,`source_id`,`source_resource_type`,`source_resource_id`,`sort_date`,`sort_title`,`source_uri`,`resource_raw`,`language`,`metaLastUpdated`,`metaProfile`,`metaTag`,`metaVersionId`,`text`,`type`,`note` FROM `fhir_binary`

2025/10/06 23:54:38  SLOW SQL >= 200ms
[4394.493ms] [rows:1469] DROP TABLE `fhir_binary`

2025/10/06 23:56:06  SLOW SQL >= 200ms
[42207.781ms] [rows:1469] INSERT INTO `fhir_binary__temp`(`id`,`created_at`,`updated_at`,`deleted_at`,`user_id`,`source_id`,`source_resource_type`,`source_resource_id`,`sort_date`,`sort_title`,`source_uri`,`resource_raw`,`language`,`metaLastUpdated`,`metaProfile`,`metaTag`,`metaVersionId`,`text`,`type`,`note`) SELECT `id`,`created_at`,`updated_at`,`deleted_at`,`user_id`,`source_id`,`source_resource_type`,`source_resource_id`,`sort_date`,`sort_title`,`source_uri`,`resource_raw`,`language`,`metaLastUpdated`,`metaProfile`,`metaTag`,`metaVersionId`,`text`,`type`,`note` FROM `fhir_binary`

2025/10/06 23:56:10  SLOW SQL >= 200ms
[3751.315ms] [rows:1469] DROP TABLE `fhir_binary`

Flavor

Docker

Version

No response

Relevant log output

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions