Can't get mysql to start
csuzw
PROOP

20 days ago

This was running fine. I changed the start command today from --innodb-buffer-pool-size=1G to --innodb-buffer-pool-size=128M. Now it crashes after startup - I've tried restarting and redeploying with no luck. I also tried reverting the change and it still crashes. I did this in another environment (which sees more traffic) and it's fine. The error I'm seeing in the logs doesn't look like it's related but I could be wrong:


2026-05-18T07:54:47.827950Z 1 [Warning] [MY-015652] [Server] Error MY-001305 occurred while checking table-definitions: FUNCTION mysql.md5 does not exist

2026-05-18T07:54:47.827997Z 1 [Warning] [MY-015652] [Server] Error MY-001033 occurred while checking table-definitions: Incorrect information in file: './railway/pulse_aggregates.frm'

2026-05-18T07:54:47.828002Z 1 [ERROR] [MY-013135] [Server] Incorrect information in file: './railway/pulse_aggregates.frm'

2026-05-18T07:54:47.828012Z 1 [Warning] [MY-014078] [Server] Can not open table `railway`.`pulse_aggregates`; functions in constraints, partitions, or virtual columns may have failed.

2026-05-18T07:54:47.828035Z 1 [Warning] [MY-014079] [Server] TABLE `railway`.`pulse_aggregates` = { GCOL = {{ index: "pulse_aggregates_bucket_period_type_aggregate_key_hash_unique", name: "key_hash", virtual: 1, clause: "unhex(md5(`key`))" }}; ENGINE = "InnoDB"; };

2026-05-18T07:54:47.828509Z 1 [Warning] [MY-015652] [Server] Error MY-001305 occurred while checking table-definitions: FUNCTION mysql.md5 does not exist

2026-05-18T07:54:47.828525Z 1 [Warning] [MY-015652] [Server] Error MY-001033 occurred while checking table-definitions: Incorrect information in file: './railway/pulse_entries.frm'

2026-05-18T07:54:47.828529Z 1 [ERROR] [MY-013135] [Server] Incorrect information in file: './railway/pulse_entries.frm'

2026-05-18T07:54:47.828535Z 1 [Warning] [MY-014078] [Server] Can not open table `railway`.`pulse_entries`; functions in constraints, partitions, or virtual columns may have failed.

2026-05-18T07:54:47.828547Z 1 [Warning] [MY-014079] [Server] TABLE `railway`.`pulse_entries` = { GCOL = {{ index: "pulse_entries_key_hash_index", index: "pulse_entries_timestamp_type_key_hash_value_index", name: "key_hash", virtual: 1, clause: "unhex(md5(`key`))" }}; ENGINE = "InnoDB"; };

2026-05-18T07:54:47.828906Z 1 [Warning] [MY-015652] [Server] Error MY-001305 occurred while checking table-definitions: FUNCTION mysql.md5 does not exist

2026-05-18T07:54:47.828915Z 1 [Warning] [MY-015652] [Server] Error MY-001033 occurred while checking table-definitions: Incorrect information in file: './railway/pulse_values.frm'

2026-05-18T07:54:47.828918Z 1 [ERROR] [MY-013135] [Server] Incorrect information in file: './railway/pulse_values.frm'

2026-05-18T07:54:47.828923Z 1 [Warning] [MY-014078] [Server] Can not open table `railway`.`pulse_values`; functions in constraints, partitions, or virtual columns may have failed.

2026-05-18T07:54:47.828931Z 1 [Warning] [MY-014079] [Server] TABLE `railway`.`pulse_values` = { GCOL = {{ index: "pulse_values_type_key_hash_unique", name: "key_hash", virtual: 1, clause: "unhex(md5(`key`))" }}; ENGINE = "InnoDB"; };

2026-05-18T07:54:47.840253Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2026-05-18T07:54:47.840374Z 0 [ERROR] [MY-010119] [Server] Aborting

2026-05-18T07:54:48.674645Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.7.0)  MySQL Community Server - GPL.

2026-05-18T07:54:48.674661Z 0 [System] [MY-015016] [Server] MySQL Server - end.
Solved$20 Bounty

2 Replies

Status changed to Open Railway 20 days ago


ankitgelda8
HOBBY

20 days ago

Are you upgrading the version of mysql ? if yes , try using the same version of mysql which you are using before , this issue occurred to me when I upgraded as it is without proper migration


csuzw
PROOP

20 days ago

I did upgrade but I thought it had completed successfully before I made the config change so I didn't mention it. There was deployment problems at the time so I guess it hadn't happened. Reverted to previous version and it looks like it's ok. Thanks.


Status changed to Solved chandrika 19 days ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...