ByteTamer
Dabbler
- Joined
- May 10, 2012
- Messages
- 17
I have been running a Supermicro x9scm mother board (16 gig ECC) with a Xeon e3-1230 v2 for about a year now with no problems. A FreeNAS software update failed a while a go and I had to resort to a CD based installation to get going again. Now I get a Fatal Error every time I run a new update. The system information screen shows that I am running FreeNAS-9.3-STABLE-201505130355. The error message is below:
I am uncertain how I should proceed to eliminate this error.
Code:
FATAL ERROR - The following SQL query failed: CREATE TABLE "system_backup" ("id$ The error was: table "system_backup" already exists Running migrations for api: - Nothing to migrate. - Loading initial data for api. Installed 0 object(s) from 0 fixture(s) Running migrations for freeadmin: - Nothing to migrate. - Loading initial data for freeadmin. Installed 0 object(s) from 0 fixture(s) Running migrations for support: - Nothing to migrate. - Loading initial data for support. Installed 0 object(s) from 0 fixture(s) Running migrations for storage: - Nothing to migrate. - Loading initial data for storage. Installed 0 object(s) from 0 fixture(s) Running migrations for services: - Nothing to migrate. - Loading initial data for services. Installed 0 object(s) from 0 fixture(s) Running migrations for tasks: - Nothing to migrate. - Loading initial data for tasks. Installed 0 object(s) from 0 fixture(s) Running migrations for jails: - Nothing to migrate. - Loading initial data for jails. Installed 0 object(s) from 0 fixture(s) Running migrations for plugins: - Nothing to migrate. - Loading initial data for plugins. Installed 0 object(s) from 0 fixture(s) Running migrations for sharing: - Nothing to migrate. - Loading initial data for sharing. Installed 0 object(s) from 0 fixture(s) Running migrations for system: - Migrating forwards to 0095_auto__add_field_advanced_adv_periodic_notifyuser. > system:0094_add_model_backup ! 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: = DROP TABLE "system_backup"; [] ! 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: system:0094_add_model_backup The following content types are stale and need to be deleted: system | initshutdown system | cronjob system | sysctl system | rsync system | ssl system | smarttest Any objects related to these content types by a foreign key will also be deleted. Are you sure you want to delete these content types? If you're unsure, answer 'no'. Type 'yes' to continue, or 'no' to cancel: Traceback (most recent call last$ File "/usr/local/www/freenasUI/manage.py", line 42, in <module> execute_from_command_line(sys.argv) File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.$ utility.execute() File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.$ self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",$ self.execute(*args, **options.__dict__) File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",$ output = self.handle(*args, **options) File "/usr/local/lib/python2.7/site-packages/south/management/commands/migrat$ ignore_ghosts = ignore_ghosts, File "/usr/local/lib/python2.7/site-packages/south/migration/__init__.py", li$ success = migrator.migrate_many(target, workplan, database) File "/usr/local/lib/python2.7/site-packages/south/migration/migrators.py", l$ result = migrator.__class__.migrate_many(migrator, target, migrations, data$ File "/usr/local/lib/python2.7/site-packages/south/migration/migrators.py", l$ result = self.migrate(migration, database) File "/usr/local/lib/python2.7/site-packages/south/migration/migrators.py", l$ result = self.run(migration, database) File "/usr/local/lib/python2.7/site-packages/south/migration/migrators.py", l$ return self.run_migration(migration, database) File "/usr/local/lib/python2.7/site-packages/south/migration/migrators.py", l$ migration_function() File "/usr/local/lib/python2.7/site-packages/south/migration/migrators.py", l$ return (lambda: direction(orm)) File "/usr/local/www/freenasUI/../freenasUI/system/migrations/0094_add_model_$ ('bak_status', self.gf('django.db.models.fields.CharField')(max_length=1024$ File "/usr/local/lib/python2.7/site-packages/south/db/generic.py", line 47, i$ return func(self, table, *args, **opts) File "/usr/local/lib/python2.7/site-packages/south/db/generic.py", line 361, $ "columns": ', '.join([col for col in columns if col]), File "/usr/local/lib/python2.7/site-packages/south/db/generic.py", line 282, $ cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py", lin$ return self.cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/django/db/utils.py", line 99, in$ six.reraise(dj_exc_type, dj_exc_value, traceback) File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py", lin$ return self.cursor.execute(sql, params) File "/usr/local/www/freenasUI/../freenasUI/freeadmin/sqlite3_ha/base.py", li$ return Database.Cursor.execute(self, query, params) django.db.utils.OperationalError: table "system_backup" already exists
I am uncertain how I should proceed to eliminate this error.