Floppy
commented
3 months ago Argh. Sorry, will fix immediately.
Closed egg82 closed 3 months ago
Floppy
commented
3 months ago Argh. Sorry, will fix immediately.
Floppy
commented
3 months ago I think this will be fixed in the edge image, and I'll push a v0.75.1 release shortly.
lukasbasedow
commented
3 months ago manyfold-6bd688dcff-wbx7g_manyfold.log Hey, i strangly still get the error with 0.75.1 and MariaDB:10.5. I hope the log helps.
Floppy
commented
3 months ago @lukasbasedow interesting, that's a different error; I wonder if you have a half-completed migration, somehow.
I'll post some commands you could try to run a bit later on, I'm AFK right now.
Floppy
commented
3 months ago Try docker exec -it manyfold /usr/src/app/bin/rails db:migrate:status:with_data to see what Rails thinks it's done, and then do you have any way to easily see the tables in your MariaDB server?
lukasbasedow
commented
3 months ago It's a relatively new deployment (installed with 74.2). So maybe something did not work out with the new MySQL implementation.
@Floppy I've run the command.
database: manyfold
up schema 20210130201037 Create libraries up schema 20210130203243 Create models up schema 20210205230918 Create parts up schema 20210210153744 Add fields to parts up schema 20210212143001 Acts as taggable on migration.acts as taggable on engine up schema 20210212143002 Add missing unique indices.acts as taggable on engine up schema 20210212143003 Add taggings counter cache to tags.acts as taggable on engine up schema 20210212143004 Add missing taggable index.acts as taggable on engine up schema 20210212143005 Change collation for tag names.acts as taggable on engine up schema 20210212143006 Add missing indexes on taggings.acts as taggable on engine up schema 20210220204055 Add preview part to model up schema 20210225232756 Create creators up schema 20210225232841 Add creator to models up schema 20210301230017 Create links up schema 20210302161202 Drop link fields from creators up schema 20210314185822 Remove fk constraint from model preview part up schema 20210318202638 Add y up to parts up schema 20210321164508 Create images up schema 20210330215825 Create delayed jobs up schema 20220105233138 Rename parts to model files up schema 20220106220519 Remove images table up schema 20220612220115 Add service name to active storage blobs.active storage up schema 20220612220116 Create active storage variant records.active storage up schema 20220612220117 Remove not null on active storage blobs checksum.active storage up schema 20220614210023 Devise create users up schema 20220614211256 Add username to users up schema 20220614213902 Add admin to users up schema 20220617122809 Add pagination settings to user up schema 20220619174307 Create settings up schema 20220626152444 Add scale factor to models up schema 20220702202932 Add digest to model files up schema 20221128165903 Add renderer settings to users up schema 20221210001132 Create problems up data 20221214230757 Add new defaults to renderer settings up schema 20221219204414 Acts as favoritor migration up data 20221220223040 Move printed to favorites up schema 20221220223340 Drop printed from model files up schema 20230202210000 Add notes excerpt to models up schema 20230202210001 Add notes excerpt to creators up schema 20230203150000 Add notes excerpt to model files up data 20230221174212 Move scale factor into note up schema 20230221180921 Remove scale factor from models up schema 20230222155910 Rename excerpt to caption up schema 20230303150029 Add notes name caption to library up schema 20230305180823 Add tagregex to library up schema 20230307215826 Add icon to library up schema 20230308004237 Create collection up schema 20230308005021 Add collection to models up data 20230308006000 Move collection tag into object up schema 20230313000000 Rename collection excerpt to caption up schema 20230313000001 Change pagination settings on user up schema 20230316184012 Add tag cloud settings to user up schema 20230324000000 Add collection to collections up data 20230612080306 Remove destination exists problems up data 20230613134254 Remove leading separators from model filenames up schema 20230615135601 Add slugs up data 20230617222353 Generate slugs up data 20230628194944 Make names unique up schema 20230628195018 Add unique constraint to names and slugs up schema 20230707082403 Add size to model files up schema 20230710102250 Change file size to big int up schema 20230711111009 Add note to problems up schema 20240122114207 Add problem settings to user up schema 20240127143358 Add license to model up schema 20240131134832 Add ignored to problems up schema 20240208143319 Add presupported version to model files up schema 20240209125409 Add file list settings to user up schema 20240228130246 Add missing unique indexes up schema 20240306095646 Create flipper tables up schema 20240319155251 Rolify create roles up data 20240319155526 Convert admin flag to role up schema 20240319155903 Remove admin from users up schema 20240322143621 Add reset password token to users up data 20240322150022 Set admin password reset token up schema 20240410221112 Add rememberable to users up schema 20240410222922 Add reset password sent at to users up schema 20240418112821 Drop delayed jobs up schema 20240423102250 Add interface language to users up schema 20240610120318 Add lockable to users up schema 20240614085913 Add attachment data to model files up data 20240615085913 Move file data into shrine up schema 20240701142651 Add storage service to libraries up schema 20240703103707 Add s3 fields to library up schema 20240703160732 Change index on library path down schema 20240727113215 Create federails actors.federails down schema 20240727113216 Create federails followings.federails down schema 20240727113217 Create federails activities.federails down schema 20240731165646 Change actor entity rel to polymorphic.federails down data 20240731165647 Create federails actors down data 20240802094448 Create more federails actors down data 20240805111500 Backfill activities
I've got access to the MySQL container, so I can just run SQL commands and print the tables. What exactly should I look into?
Floppy
commented
3 months ago Ok - rails thinks it hasn't run the federails migrations. If there are federails_* tables in the database, that's the problem. I think if you remove them (they should be empty) then it should be able to recover.
lukasbasedow
commented
3 months ago @Floppy ok, i dropped the federails_actors table, the only one with federails
| Tables_in_manyfold | +----------------------+ | ar_internal_metadata | | collections | | creators | | data_migrations | | favorites | | federails_actors | | flipper_features | | flipper_gates | | libraries | | links | | model_files | | models | | problems | | roles | | schema_migrations | | settings | | taggings | | tags | | users | | users_roles |
After restarting the application Container the federrails_actors table was created again and the error started anew. manyfold-6bd688dcff-b89ct_manyfold.log
lukasbasedow
commented
3 months ago it looks like the first thing that errors is Mysql2::Error: Cannot drop index 'index_federails_actors_on_user_id': needed in a foreign key constraint
tryed to drop the index, but that didnt fixed it ether
Floppy
commented
3 months ago Oh that's strange; I'll have to dig in to see what might be happening...
lukasbasedow
commented
3 months ago let me know, if i can somehow help! thank you so much for your time and efford <3
Floppy
commented
3 months ago I've created the issue #2515 for this as it's a different problem, so will carry on over there.
Describe the bug Docker deployment of 0.75.0 (coming from 0.74.2) causing the following database migration issues w/ postgresql 15.
To Reproduce Steps to reproduce the behavior:
Expected behavior Database migration to complee successfully and the app to continue onward.
Screenshots N/A
Desktop (please complete the following information): N/A
Smartphone (please complete the following information): N/A
Additional context N/A