table is full" error with my MySQL database
frankmedia
HOBBYOP

3 months ago

Hello Railway Support Team,

I'm experiencing a "table is full" error with my MySQL database despite having an 8GB plan with plenty of available space. The error occurs when trying to perform operations on my b_questions table.

Issue Details:

  • Error Message: "Create table/tablespace 'b_questions' failed, as disk is full"

  • Current Database Size: 174.08 MB (well within 8GB limit)

  • Problematic Table: b_questions (only 0.56 MB)

  • InnoDB Configuration: ibdata1:12M:autoextend

  • InnoDB Buffer Pool: 1GB

What I've Tried:

  1. Verified database size is only 174 MB out of 8GB available

  1. Checked table sizes - all are reasonable

  1. Ran OPTIMIZE TABLE b_questions - failed with same error

  1. Confirmed InnoDB data file should auto-extend but appears to be stuck

The InnoDB data file should auto-extend beyond the initial 12MB as needed, but it seems to be hitting a limit despite having 8GB of available space.

Could you please check the InnoDB configuration and ensure the data file can properly extend? This appears to be a configuration issue rather than an actual space limitation.

Thank you for your assistance.

Best regards,

Frank

$10 Bounty

2 Replies

Railway
BOT

3 months ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!


frankmedia
HOBBYOP

3 months ago

any news?


brody
EMPLOYEE

3 months ago

This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.

Status changed to Open brody 3 months ago


Loading...