[Toaster] [Report]erro message in build mode

Bian, Naimeng biannm at cn.fujitsu.com
Mon Aug 24 17:35:55 PDT 2015


Thank you for telling me that.

Yes, I’m using Mysql, and I think it’s the same bug with 7932.

Thanks
Bian

From: Smith, Elliot [mailto:elliot.smith at intel.com]
Sent: Monday, August 24, 2015 4:52 PM
Cc: toaster at yoctoproject.org
Subject: Re: [Toaster] [Report]erro message in build mode

Hello Bian.

On 24 August 2015 at 04:16, Bian, Naimeng <biannm at cn.fujitsu.com<mailto:biannm at cn.fujitsu.com>> wrote:
I tried to setup toaster in Build Mode according to toaster-munal located in
http://www.yoctoproject.org/docs/1.9/toaster-manual/toaster-manual.html

But I got the following message while starting Toaster, any suggestion!

It looks like you've come across this bug:
https://bugzilla.yoctoproject.org/show_bug.cgi?id=7932

My assumption is that you're using MySQL, which is what causes this bug to appear for me.

I'm currently working on a solution.

Elliot


> orm:0021_auto__chg_field_build_project__chg_field_project_bitbake_version__chg_
Traceback (most recent call last):
  File "./bitbake/bin/../lib/toaster/manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/lib/python2.7/dist-packages/django/core/management/__init__.py", line 399, in execute_from_command_line
    utility.execute()
  File "/usr/lib/python2.7/dist-packages/django/core/management/__init__.py", line 392, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/python2.7/dist-packages/django/core/management/base.py", line 242, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/usr/lib/python2.7/dist-packages/django/core/management/base.py", line 285, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python2.7/dist-packages/south/management/commands/migrate.py", line 111, in handle
    ignore_ghosts = ignore_ghosts,
  File "/usr/local/lib/python2.7/dist-packages/south/migration/__init__.py", line 220, in migrate_app
    success = migrator.migrate_many(target, workplan, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 254, in migrate_many
    result = migrator.__class__.migrate_many(migrator, target, migrations, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 329, in migrate_many
    result = self.migrate(migration, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 133, in migrate
    result = self.run(migration, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 114, in run
    return self.run_migration(migration, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 93, in run_migration
    print(self.run_migration_error(migration))
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 323, in run_migration_error
    (self.format_backwards(migration), extra_info))
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 310, in format_backwards
    self.backwards(migration)()
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 60, in <lambda>
    return (lambda: direction(orm))
  File "/poky/bitbake/lib/toaster/orm/migrations/0021_auto__chg_field_build_project__chg_field_project_bitbake_version__chg_.py", line 33, in backwards
    raise RuntimeError("Cannot reverse this migration. 'Project.bitbake_version' and its values cannot be restored.")
RuntimeError: Cannot reverse this migration. 'Project.bitbake_version' and its values cannot be restored.

Error on migration, trying to recover...
Running migrations for orm:
 - Migrating backwards to just after 0001_initial.
 < orm:0020_auto__add_field_layer_version_local_path__add_field_recipe_pathflags__
   (faked)
 < orm:0019_auto__add_buildartifact
   (faked)
 < orm:0018_auto__add_field_layer_version_project
   (faked)
 < orm:0017_auto__del_toastersettingdefaultlayer__add_releaselayersourcepriority__
   (faked)
 < orm:0016_auto__add_field_release_helptext__chg_field_release_branch__add_index_
   (faked)
 < orm:0015_auto__add_field_layer_vcs_web_url__add_field_layer_vcs_web_tree_base_u
   (faked)
 < orm:0014_auto__chg_field_package_summary__chg_field_layer_summary__chg_field_re
   (faked)
 < orm:0013_auto__add_release__add_layerversiondependency__add_unique_layerversion
   (faked)
 < orm:0012_auto__add_field_projectlayer_optional__add_field_projecttarget_task
   (faked)
 < orm:0011_auto__add_field_projectlayer_dirpath
   (faked)
 < orm:0010_auto__add_field_project_branch__add_field_project_short_description__a
   (faked)
 < orm:0009_auto__add_projectvariable__add_projectlayer__add_projecttarget__add_pr
   (faked)
 < orm:0008_auto__chg_field_variablehistory_operation__chg_field_recipe_descriptio
   (faked)
 < orm:0007_auto__add_helptext
   (faked)
 < orm:0006_auto__add_field_target_image_size__add_field_target_license_manifest_p
   (faked)
 < orm:0005_auto__add_target_image_file__add_target_file__add_field_variablehistor
   (faked)
 < orm:0004_auto__add_field_package_installed_name
   (faked)
 < orm:0003_timespent
   (faked)
 < orm:0002_auto__add_field_build_timespent
   (faked)
Running migrations for orm:
 - Migrating forwards to 0024_auto__add_field_recipe_is_image.
 > orm:0002_auto__add_field_build_timespent
FATAL ERROR - The following SQL query failed: ALTER TABLE `orm_build` ADD COLUMN `timespent` integer NOT NULL DEFAULT 0;
The error was: (1060, "Duplicate column name 'timespent'")
 ! Error found during real run of migration! Aborting.

 ! Since you have a database that does not support running
 ! schema-altering statements in transactions, we have had
 ! to leave it in an interim state between migrations.

! You *might* be able to recover with:   - no dry run output for delete_foreign_key() due to dynamic DDL, sorry
   = ALTER TABLE `orm_build` DROP COLUMN `timespent` CASCADE; []

 ! The South developers regret this has happened, and would
 ! like to gently persuade you to consider a slightly
 ! easier-to-deal-with DBMS (one that supports DDL transactions)
 ! NOTE: The error which caused the migration to fail is further up.
Error in migration: orm:0002_auto__add_field_build_timespent
Traceback (most recent call last):
  File "./bitbake/bin/../lib/toaster/manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/lib/python2.7/dist-packages/django/core/management/__init__.py", line 399, in execute_from_command_line
    utility.execute()
  File "/usr/lib/python2.7/dist-packages/django/core/management/__init__.py", line 392, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/python2.7/dist-packages/django/core/management/base.py", line 242, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/usr/lib/python2.7/dist-packages/django/core/management/base.py", line 285, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python2.7/dist-packages/south/management/commands/migrate.py", line 111, in handle
    ignore_ghosts = ignore_ghosts,
  File "/usr/local/lib/python2.7/dist-packages/south/migration/__init__.py", line 220, in migrate_app
    success = migrator.migrate_many(target, workplan, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 254, in migrate_many
    result = migrator.__class__.migrate_many(migrator, target, migrations, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 329, in migrate_many
    result = self.migrate(migration, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 133, in migrate
    result = self.run(migration, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 114, in run
    return self.run_migration(migration, database)
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 84, in run_migration
    migration_function()
  File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 60, in <lambda>
    return (lambda: direction(orm))
  File "/poky/bitbake/lib/toaster/orm/migrations/0002_auto__add_field_build_timespent.py", line 14, in forwards
    keep_default=False)
  File "/usr/local/lib/python2.7/dist-packages/south/db/generic.py", line 47, in _cache_clear
    return func(self, table, *args, **opts)
  File "/usr/local/lib/python2.7/dist-packages/south/db/generic.py", line 418, in add_column
    self.execute(sql)
  File "/usr/local/lib/python2.7/dist-packages/south/db/generic.py", line 282, in execute
    cursor.execute(sql, params)
  File "/usr/lib/python2.7/dist-packages/django/db/backends/util.py", line 69, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/usr/lib/python2.7/dist-packages/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)
  File "/usr/lib/python2.7/dist-packages/django/db/utils.py", line 99, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/lib/python2.7/dist-packages/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)
  File "/usr/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 124, in execute
    return self.cursor.execute(query, args)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
django.db.utils.OperationalError: (1060, "Duplicate column name 'timespent'")


Thanks
 Bian
--
_______________________________________________
toaster mailing list
toaster at yoctoproject.org<mailto:toaster at yoctoproject.org>
https://lists.yoctoproject.org/listinfo/toaster



--
Elliot Smith
Software Engineer
Intel Open Source Technology Centre
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.yoctoproject.org/pipermail/toaster/attachments/20150825/f5b2dddc/attachment-0001.html>


More information about the toaster mailing list