R
Railway•5mo ago
Will Scott-Rodriguez

Error on trying to fix a crashed table

Hi I am trying to migrate my db but I'm getting an error saying I've got an corrupted table. I've tried fixing it by running REPAIR TABLE but it seems to crash railway when I do it through the UI (see screenshot). I've now tried through DB-Gate and it's saying I need to get access to the runtime somehow. Is there anything I'm missing or can I get some help with this? Cheers Will
No description
3 Replies
Percy
Percy•5mo ago
Project ID: 335d6d75-dfec-41c3-bd85-0e083f966495
Will Scott-Rodriguez
Will Scott-Rodriguez•5mo ago
335d6d75-dfec-41c3-bd85-0e083f966495 I've just ended up dropping the table and recreating it to complete the migration. Not sure if the bug with the client-side crash is worth looking at but is a reproducible bug when the query to repair a table fails.
Brody
Brody•5mo ago
the query that the UI would allow you to run on the legacy database is ran with the same permissions as the query you would run in dbgate, if it doesn't work in dbgate it won't work in the UI the client crash is definitely a bug but since the query UI doesn't exist anymore with v2 databases, I don't think it's worth looking into
Want results from more Discord servers?
Add your server
More Posts
next.js dockerfileSo i use a dockerfile for my nextjs app, and it works and complete with success. But as soon i try ttimeline on enabling static IPs?Is there a timeline for this? I saw that it was on the roadmap. Looking to white list my deploymentsPossible to use `turbo-ignore` to decide what to build instead of `watchPatterns`?Docs for the command are here: https://turbo.build/repo/docs/core-concepts/monorepos/skipping-tasks Issues connecting to Postgres Database after redeploying serviceHi, as part of performing the required database-migration, I've redeployed my service for the first SSL certificate still issuingHello, on my project `64ff2818-2045-4c7d-8806-9a9a560f41f4` I've added a custom domain to the servicDB Migrate not showing on my dashboard.Hello, i saw the post regarding the database migration. However, from my dashboard i can't see the mmongoDB upgrade issueThe total data volume of mongoDB is about 50G. which is stuck at Migrate Data. Then mongoDB crashed Is Railway down? Build doesn't start, stuck in initializingHi, I'm suddenly facing this strange issue where when I try to deploy a new commit, it just gets stI am getting postgres 16 Issue#8 30.90 error: collision between `/nix/store/cpmgrq24rjqf415q3m4a5mlg9fw5x9r0-postgresql-16.0/lib/lMysql Database migration - Did not move the database/data to the new Mysql InstanceAfter run the automatic migration - I ran this on my Test environment firstly and the new mysql inst