Thanks for the pointers. So in essence we're trying to setup a production server which as mentioned is working fine for gatesgarth based builds. Now we need to move our builds forward and trying to use kirkstone/langdale however this too is causing problems when we try to run the 'migrate' step. Here are the full logs:
> > toaster@elitebook:~/poky$ pip3 install --user --force-reinstall -r > ./bitbake/toaster-requirements.txt > Collecting Django<3.3,>3.2 > Using cached Django-3.2.25-py3-none-any.whl (7.9 MB) > Collecting beautifulsoup4>=4.4.0 > Using cached beautifulsoup4-4.12.3-py3-none-any.whl (147 kB) > Collecting pytz > Using cached pytz-2024.2-py2.py3-none-any.whl (508 kB) > Collecting sqlparse>=0.2.2 > Using cached sqlparse-0.5.1-py3-none-any.whl (44 kB) > Collecting asgiref<4,>=3.3.2 > Using cached asgiref-3.8.1-py3-none-any.whl (23 kB) > Collecting soupsieve>1.2 > Using cached soupsieve-2.6-py3-none-any.whl (36 kB) > Collecting typing-extensions>=4 > Using cached typing_extensions-4.12.2-py3-none-any.whl (37 kB) > Installing collected packages: pytz, typing-extensions, sqlparse, > soupsieve, beautifulsoup4, asgiref, Django > WARNING: The script sqlformat is installed in > '/var/www/toaster/.local/bin' which is not on PATH. > Consider adding this directory to PATH or, if you prefer to suppress this > warning, use --no-warn-script-location. > WARNING: The script django-admin is installed in > '/var/www/toaster/.local/bin' which is not on PATH. > Consider adding this directory to PATH or, if you prefer to suppress this > warning, use --no-warn-script-location. > Successfully installed Django-3.2.25 asgiref-3.8.1 beautifulsoup4-4.12.3 > pytz-2024.2 soupsieve-2.6 sqlparse-0.5.1 typing-extensions-4.12.2 > toaster@elitebook:~/poky$ > toaster@elitebook:~/poky$ pip3 install --user mysqlclient > Collecting mysqlclient > Using cached mysqlclient-2.2.5.tar.gz (90 kB) > Installing build dependencies ... done > Getting requirements to build wheel ... done > Installing backend dependencies ... done > Preparing metadata (pyproject.toml) ... done > WARNING: Generating metadata for package mysqlclient produced metadata for > project name unknown. Fix your #egg=mysqlclient fragments. > Discarding > https://files.pythonhosted.org/packages/be/95/1af2ee813d4f0b607082c18bb82aa05c98a95a402a1d2d5808999317cb16/mysqlclient-2.2.5.tar.gz#sha256=add8643c32f738014d252d2bdebb478623b04802e8396d5903905db36474d3ff > (from https://pypi.org/simple/mysqlclient/) (requires-python:>=3.8): > Requested unknown from > https://files.pythonhosted.org/packages/be/95/1af2ee813d4f0b607082c18bb82aa05c98a95a402a1d2d5808999317cb16/mysqlclient-2.2.5.tar.gz#sha256=add8643c32f738014d252d2bdebb478623b04802e8396d5903905db36474d3ff > has inconsistent name: filename has 'mysqlclient', but metadata has > 'unknown' > Using cached mysqlclient-2.2.4.tar.gz (90 kB) > Installing build dependencies ... done > Getting requirements to build wheel ... done > Installing backend dependencies ... done > Preparing metadata (pyproject.toml) ... done > WARNING: Generating metadata for package mysqlclient produced metadata for > project name unknown. Fix your #egg=mysqlclient fragments. > Discarding > https://files.pythonhosted.org/packages/79/33/996dc0ba3f03e2399adc91a7de1f61cb14b57ebdb4cc6eca8a78723043cb/mysqlclient-2.2.4.tar.gz#sha256=33bc9fb3464e7d7c10b1eaf7336c5ff8f2a3d3b88bab432116ad2490beb3bf41 > (from https://pypi.org/simple/mysqlclient/) (requires-python:>=3.8): > Requested unknown from > https://files.pythonhosted.org/packages/79/33/996dc0ba3f03e2399adc91a7de1f61cb14b57ebdb4cc6eca8a78723043cb/mysqlclient-2.2.4.tar.gz#sha256=33bc9fb3464e7d7c10b1eaf7336c5ff8f2a3d3b88bab432116ad2490beb3bf41 > has inconsistent name: filename has 'mysqlclient', but metadata has > 'unknown' > Using cached mysqlclient-2.2.3.tar.gz (90 kB) > Installing build dependencies ... done > Getting requirements to build wheel ... done > Installing backend dependencies ... done > Preparing metadata (pyproject.toml) ... done > WARNING: Generating metadata for package mysqlclient produced metadata for > project name unknown. Fix your #egg=mysqlclient fragments. > Discarding > https://files.pythonhosted.org/packages/10/2c/589fe3e9e045e0a9d86fc4e060de32d6df0fb9e1d48f2092c1f1abb26ffa/mysqlclient-2.2.3.tar.gz#sha256=ee51656e36fc5a92920b807ee8b9e373e3b0e267c89cdc95d73b1dbe46863631 > (from https://pypi.org/simple/mysqlclient/) (requires-python:>=3.8): > Requested unknown from > https://files.pythonhosted.org/packages/10/2c/589fe3e9e045e0a9d86fc4e060de32d6df0fb9e1d48f2092c1f1abb26ffa/mysqlclient-2.2.3.tar.gz#sha256=ee51656e36fc5a92920b807ee8b9e373e3b0e267c89cdc95d73b1dbe46863631 > has inconsistent name: filename has 'mysqlclient', but metadata has > 'unknown' > Using cached mysqlclient-2.2.2.tar.gz (90 kB) > Installing build dependencies ... done > Getting requirements to build wheel ... done > Installing backend dependencies ... done > Preparing metadata (pyproject.toml) ... done > WARNING: Generating metadata for package mysqlclient produced metadata for > project name unknown. Fix your #egg=mysqlclient fragments. > Discarding > https://files.pythonhosted.org/packages/6c/37/aeefb97b20c08774ac57a27b0a0d19e9a2a9ec53c0802ee20920d98560f4/mysqlclient-2.2.2.tar.gz#sha256=6f57715fb08c80ab80d34febe0aa8ef8810e52d527ad7da2da76e8ce25e2f2e9 > (from https://pypi.org/simple/mysqlclient/) (requires-python:>=3.8): > Requested unknown from > https://files.pythonhosted.org/packages/6c/37/aeefb97b20c08774ac57a27b0a0d19e9a2a9ec53c0802ee20920d98560f4/mysqlclient-2.2.2.tar.gz#sha256=6f57715fb08c80ab80d34febe0aa8ef8810e52d527ad7da2da76e8ce25e2f2e9 > has inconsistent name: filename has 'mysqlclient', but metadata has > 'unknown' > Using cached mysqlclient-2.2.1.tar.gz (89 kB) > Installing build dependencies ... done > Getting requirements to build wheel ... done > Installing backend dependencies ... done > Preparing metadata (pyproject.toml) ... done > WARNING: Generating metadata for package mysqlclient produced metadata for > project name unknown. Fix your #egg=mysqlclient fragments. > Discarding > https://files.pythonhosted.org/packages/37/fb/d9a8f763c84f1e789c027af0ffc7dbf94c9a38db961484f253f0552cbb47/mysqlclient-2.2.1.tar.gz#sha256=2c7ad15b87293b12fd44b47c46879ec95ec647f4567e866ccd70b8337584e9b2 > (from https://pypi.org/simple/mysqlclient/) (requires-python:>=3.8): > Requested unknown from > https://files.pythonhosted.org/packages/37/fb/d9a8f763c84f1e789c027af0ffc7dbf94c9a38db961484f253f0552cbb47/mysqlclient-2.2.1.tar.gz#sha256=2c7ad15b87293b12fd44b47c46879ec95ec647f4567e866ccd70b8337584e9b2 > has inconsistent name: filename has 'mysqlclient', but metadata has > 'unknown' > Using cached mysqlclient-2.2.0.tar.gz (89 kB) > Installing build dependencies ... done > Getting requirements to build wheel ... done > Installing backend dependencies ... done > Preparing metadata (pyproject.toml) ... done > WARNING: Generating metadata for package mysqlclient produced metadata for > project name unknown. Fix your #egg=mysqlclient fragments. > Discarding > https://files.pythonhosted.org/packages/de/9c/b176826e8994551ce826404dab97e305a4bb76c8b0a4e016fabda2901c71/mysqlclient-2.2.0.tar.gz#sha256=04368445f9c487d8abb7a878e3d23e923e6072c04a6c320f9e0dc8a82efba14e > (from https://pypi.org/simple/mysqlclient/) (requires-python:>=3.8): > Requested unknown from > https://files.pythonhosted.org/packages/de/9c/b176826e8994551ce826404dab97e305a4bb76c8b0a4e016fabda2901c71/mysqlclient-2.2.0.tar.gz#sha256=04368445f9c487d8abb7a878e3d23e923e6072c04a6c320f9e0dc8a82efba14e > has inconsistent name: filename has 'mysqlclient', but metadata has > 'unknown' > Using cached mysqlclient-2.1.1-cp310-cp310-linux_x86_64.whl > Installing collected packages: mysqlclient > Successfully installed mysqlclient-2.1.1 > toaster@elitebook:~/poky$ > toaster@elitebook:~/poky$ ./bitbake/lib/toaster/manage.py migrate > Operations to perform: > Apply all migrations: admin, auth, bldcontrol, contenttypes, orm, sessions > > Running migrations: > Applying contenttypes.0001_initial... OK > Applying auth.0001_initial... OK > Applying admin.0001_initial... OK > Applying admin.0002_logentry_remove_auto_add... OK > Applying admin.0003_logentry_add_action_flag_choices... OK > Applying contenttypes.0002_remove_content_type_name... OK > Applying auth.0002_alter_permission_name_max_length... OK > Applying auth.0003_alter_user_email_max_length... OK > Applying auth.0004_alter_user_username_opts... OK > Applying auth.0005_alter_user_last_login_null... OK > Applying auth.0006_require_contenttypes_0002... OK > Applying auth.0007_alter_validators_add_error_messages... OK > Applying auth.0008_alter_user_username_max_length... OK > Applying auth.0009_alter_user_last_name_max_length... OK > Applying auth.0010_alter_group_name_max_length... OK > Applying auth.0011_update_proxy_permissions... OK > Applying auth.0012_alter_user_first_name_max_length... OK > Applying orm.0001_initial... OK > Applying bldcontrol.0001_initial... OK > Applying bldcontrol.0002_auto_20160120_1250... OK > Applying bldcontrol.0003_add_cancelling_state... OK > Applying bldcontrol.0004_auto_20160523_1446... OK > Applying bldcontrol.0005_reorder_buildrequest_states... OK > Applying bldcontrol.0006_brlayer_local_source_dir... OK > Applying bldcontrol.0007_brlayers_optional_gitinfo... OK > Applying bldcontrol.0008_models_bigautofield... OK > Applying orm.0002_customimagerecipe... OK > Applying orm.0003_customimagepackage... OK > Applying orm.0004_provides... OK > Applying orm.0005_task_field_separation... OK > Applying orm.0006_add_cancelled_state... OK > Applying orm.0007_auto_20160523_1446... OK > Applying orm.0008_refactor_artifact_models... OK > Applying orm.0009_target_package_manifest_path... OK > Applying orm.0010_delete_layer_source_references... OK > Applying orm.0011_delete_layersource... OK > Applying orm.0012_use_release_instead_of_up_branch...Converting all layer > version up_branches to releases > OK > Applying orm.0013_recipe_parse_progress_fields... OK > Applying orm.0014_allow_empty_buildname... OK > Applying orm.0015_layer_local_source_dir... OK > Applying orm.0016_clone_progress... OK > Applying orm.0017_distro_clone... OK > Applying orm.0018_project_specific... OK > Applying orm.0019_django_2_2... OK > Applying orm.0020_models_bigautofield...Traceback (most recent call last): > > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/utils.py", > line 84, in _execute > return self.cursor.execute(sql, params) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/mysql/base.py", > line 73, in execute > return self.cursor.execute(query, args) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/MySQLdb/cursors.py", > line 206, in execute > res = self._query(query) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/MySQLdb/cursors.py", > line 319, in _query > db.query(q) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/MySQLdb/connections.py", > line 254, in query > _mysql.connection.query(self, query) > MySQLdb.OperationalError: (3780, "Referencing column > 'customimagepackage_id' and referenced column 'package_ptr_id' in foreign > key constraint > 'orm_customimagepacka_customimagepackage_i_b48c5573_fk_orm_custo' are > incompatible.") > The above exception was the direct cause of the following exception: > Traceback (most recent call last): > File "/var/www/toaster/poky/./bitbake/lib/toaster/manage.py", line 16, in > <module> > execute_from_command_line(sys.argv) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/core/management/__init__.py", > line 419, in execute_from_command_line > utility.execute() > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/core/management/__init__.py", > line 413, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/core/management/base.py", > line 354, in run_from_argv > self.execute(*args, **cmd_options) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/core/management/base.py", > line 398, in execute > output = self.handle(*args, **options) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/core/management/base.py", > line 89, in wrapped > res = handle_func(*args, **kwargs) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", > line 244, in handle > post_migrate_state = executor.migrate( > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/migrations/executor.py", > line 117, in migrate > state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, > fake_initial=fake_initial) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/migrations/executor.py", > line 147, in _migrate_all_forwards > state = self.apply_migration(state, migration, fake=fake, > fake_initial=fake_initial) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/migrations/executor.py", > line 227, in apply_migration > state = migration.apply(state, schema_editor) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/migrations/migration.py", > line 126, in apply > operation.database_forwards(self.app_label, schema_editor, old_state, > project_state) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/migrations/operations/fields.py", > line 244, in database_forwards > schema_editor.alter_field(from_model, from_field, to_field) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/base/schema.py", > line 608, in alter_field > self._alter_field(model, old_field, new_field, old_type, new_type, > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/base/schema.py", > line 830, in _alter_field > self.execute( > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/base/schema.py", > line 145, in execute > cursor.execute(sql, params) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/utils.py", > line 98, in execute > return super().execute(sql, params) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/utils.py", > line 66, in execute > return self._execute_with_wrappers(sql, params, many=False, > executor=self._execute) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/utils.py", > line 75, in _execute_with_wrappers > return executor(sql, params, many, context) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/utils.py", > line 79, in _execute > with self.db.wrap_database_errors: > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/utils.py", > line 90, in __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/utils.py", > line 84, in _execute > return self.cursor.execute(sql, params) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/django/db/backends/mysql/base.py", > line 73, in execute > return self.cursor.execute(query, args) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/MySQLdb/cursors.py", > line 206, in execute > res = self._query(query) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/MySQLdb/cursors.py", > line 319, in _query > db.query(q) > File > "/var/www/toaster/.local/lib/python3.10/site-packages/MySQLdb/connections.py", > line 254, in query > _mysql.connection.query(self, query) > django.db.utils.OperationalError: (3780, "Referencing column > 'customimagepackage_id' and referenced column 'package_ptr_id' in foreign > key constraint > 'orm_customimagepacka_customimagepackage_i_b48c5573_fk_orm_custo' are > incompatible.") > > I tried the same with scarthgap and that sets up without issues. The main idea is to run a production toaster server from poky (scarthgap or kirkstone ideally) and then run command line builds from different poky versions and collect them on the toaster web interface. Is that possible? the question is mainly around mixing up different poky versions for main toaster server and then command line builds.
-=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#6169): https://lists.yoctoproject.org/g/toaster/message/6169 Mute This Topic: https://lists.yoctoproject.org/mt/109134636/21656 Group Owner: [email protected] Unsubscribe: https://lists.yoctoproject.org/g/toaster/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
