Can't get mysql to start
csuzw
PROOP

4 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 4 days ago


ankitgelda8
HOBBY

4 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

4 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 3 days ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...