label-studio: Can't start label-studio after upgrade
Describe the bug
A clear and concise description of what the bug is.
Getting django.db.utils.OperationalError: no such column: project.pinned_at error after updating from 1.5.0post0 to 1.7.0
Similar to https://github.com/heartexlabs/label-studio/issues/3301 but I would like to keep my sqlite db if possible
To Reproduce Steps to reproduce the behavior:
- execute label-studio
- get error
return Database.Cursor.execute(self, query, params) sqlite3.OperationalError: no such column: project.pinned_at
Expected behavior label-studio starts
Screenshots If applicable, add screenshots to help explain your problem.
Environment (please complete the following information):
- OS: Windows 11
- Label Studio Version 1.7.0 running in a Python virtual environment
Additional context Attempting to use manage.py migrate also results in the same error.
showmigrations output: $ python manage.py showmigrations => Static URL is set to: /static/ Starting new HTTPS connection (1): pypi.org:443 https://pypi.org:443 “GET /pypi/label-studio/json HTTP/1.1” 200 54959 Note: NumExpr detected 16 cores but “NUMEXPR_MAX_THREADS” not set, so enforcing safe limit of 8. NumExpr defaulting to 8 threads. [2023-01-15 17:34:07,199] [django::register_actions_from_dir::97] [INFO] No module named ‘data_manager.actions._pycache’ [2023-01-15 17:34:07,199] [django::register_actions_from_dir::97] [INFO] No module named ‘data_manager.actions._pycache’ admin [X] 0001_initial [X] 0002_logentry_remove_auto_add [X] 0003_logentry_add_action_flag_choices auth [X] 0001_initial [X] 0002_alter_permission_name_max_length [X] 0003_alter_user_email_max_length [X] 0004_alter_user_username_opts [X] 0005_alter_user_last_login_null [X] 0006_require_contenttypes_0002 [X] 0007_alter_validators_add_error_messages [X] 0008_alter_user_username_max_length [X] 0009_alter_user_last_name_max_length [X] 0010_alter_group_name_max_length [X] 0011_update_proxy_permissions [X] 0012_alter_user_first_name_max_length authtoken [X] 0001_initial [X] 0002_auto_20160226_1747 [X] 0003_tokenproxy contenttypes [X] 0001_initial [X] 0002_remove_content_type_name core [X] 0001_initial data_export [X] 0001_initial [X] 0002_auto_20210921_0954 [X] 0003_auto_20211004_1416 [X] 0004_auto_20211019_0852 [X] 0005_auto_20211025_1137 data_import [X] 0001_initial [X] 0002_alter_fileupload_file data_manager [X] 0001_squashed_0005_view_user (5 squashed migrations) [X] 0002_remove_annotations_ids [X] 0003_remove_predictions_model_versions [X] 0004_remove_avg_lead_time [X] 0005_remove_updated_by [X] 0006_remove_inner_id [X] 0007_auto_20220708_0832 [ ] 0008_manual_counters_update django_rq [X] 0001_initial io_storages [X] 0001_squashed_0002_auto_20210302_1827 (2 squashed migrations) [X] 0002_auto_20210311_0530 [X] 0003_localfilesimportstorage [X] 0004_gcsstoragemixin_google_application_credentials [X] 0005_s3importstorage_recursive_scan [X] 0006_auto_20210906_1323 [X] 0007_auto_20210928_1252 [X] 0008_auto_20211129_1132 [X] 0009_auto_20220310_0922 [ ] 0010_auto_20221014_1708 labels_manager [X] 0001_initial [X] 0002_auto_20220131_1325 [ ] 0003_auto_20230115_1726 ml [X] 0001_initial [X] 0002_auto_20210308_1559 [X] 0003_auto_20210309_1239 [X] 0004_auto_20210820_1610 [X] 0005_auto_20211010_1344 [ ] 0006_mlbackend_auto_update organizations [X] 0001_squashed_0008_auto_20201005_1552 (8 squashed migrations) [X] 0002_auto_20210310_2044 [X] 0003_auto_20211010_1339 projects [X] 0001_squashed_0065_auto_20210223_2014 (66 squashed migrations) [X] 0002_auto_20210304_1457 [X] 0003_project_color [X] 0004_auto_20210306_0506 [X] 0003_auto_20210305_1008 [X] 0005_merge_20210308_1141 [X] 0006_auto_20210308_1559 [X] 0007_auto_20210309_1304 [X] 0008_auto_20210314_1840 [X] 0009_project_evaluate_predictions_automatically [X] 0010_auto_20210505_2037 [X] 0011_auto_20210517_2101 [X] 0012_auto_20210906_1323 [X] 0013_project_reveal_preannotations_interactively [X] 0014_project_parsed_label_config [X] 0013_project_skip_queue [X] 0015_merge_20220117_0749 [X] 0016_auto_20220211_2218 [ ] 0017_project_pinned_at [ ] 0018_alter_project_control_weights sessions [X] 0001_initial tasks [X] 0001_squashed_0041_taskcompletionhistory_was_cancelled (45 squashed migrations) [X] 0002_auto_20210305_2035 [X] 0002_auto_20210304_1423 [X] 0003_merge_20210308_1141 [X] 0004_auto_20210308_1559 [X] 0005_auto_20210309_1239 [X] 0006_remove_annotation_state [X] 0007_auto_20210618_1653 [X] 0008_auto_20210903_1332 [X] 0009_auto_20210914_0020 [X] 0010_auto_20210914_0032 [X] 0009_auto_20210913_0739 [X] 0011_merge_20210914_1036 [X] 0012_auto_20211010_1339 [X] 0013_task_updated_by [X] 0014_task_inner_id [X] 0015_task_fill_inner_id [X] 0016_auto_20220414_1408 [X] 0017_auto_20220330_1310 [X] 0018_manual_migrate_counters [X] 0017_new_index_anno_result [X] 0019_merge_20220512_2038 [X] 0020_auto_20220515_2332 [X] 0021_auto_20220515_2358 [X] 0020_auto_20220516_0545 [X] 0022_merge_20220517_1128 [ ] 0023_auto_20220620_1007 [ ] 0024_manual_migrate_counters_again [ ] 0025_auto_20220721_0110 [ ] 0026_auto_20220725_1705 [ ] 0027_auto_20220801_1728 [ ] 0028_auto_20220802_2220 [ ] 0029_annotation_project [ ] 0030_auto_20221102_1118 [ ] 0031_alter_task_options [ ] 0032_auto_20230115_1726 users [X] 0001_squashed_0009_auto_20210219_1237 (9 squashed migrations) [X] 0002_auto_20210308_1559 [X] 0003_user_active_organization [X] 0004_auto_20210914_0109 [X] 0005_auto_20211010_1339 [X] 0006_user_allow_newsletters webhooks [X] 0001_initial [X] 0002_auto_20220319_0013 [ ] 0003_alter_webhookaction_action
About this issue
- Original URL
- State: closed
- Created a year ago
- Reactions: 3
- Comments: 15 (7 by maintainers)
@teejK @quantumdot sorry, please try to install
pip install -U label-studio==1.7.1. Now it must work.@teejK @quantumdot could you please check the latest commit from the develop branch? will it migrate correctly?