I thought it was time to upgrade my server that had 9.10.1-U4 but after reboot i got this message in the console:
and there is an "update.failed" file:
SMB service refuse to start and when I go to the "services" menu I get this info:
Can anyone tell me what to do to fix this?
Code:
freenas uwsgi: [freeadmin.navtree:252] Failed to generate navtree for app freenasUI.system: no such table: system_consulalerts
and there is an "update.failed" file:
Code:
=== update.failed begins ===
/usr/local/lib/migrate93/freenasUI/jails/migrations/0019_templates_to_9_2_1_6.py:9: DeprecationWarning: invalid escape sequence \.
version_regex = re.compile('9.2.[0-9\.]+')
/usr/local/lib/migrate93/freenasUI/jails/migrations/0019_templates_to_9_2_1_6.py:12: DeprecationWarning: invalid escape sequence \.
'(9.2[0-9\.]+?/RELEASE/(x86|x64)/jails/).+', jt.jt_url)
/usr/local/lib/migrate93/freenasUI/jails/migrations/0019_templates_to_9_2_1_6.py:19: DeprecationWarning: invalid escape sequence \.
version_regex = re.compile('9.2.[0-9\.]+')
/usr/local/lib/migrate93/freenasUI/directoryservice/migrations/0047_migrate_kerberos_keytabs_to_principals.py:22: DeprecationWarning: invalid escape sequence \d
'^(\d+)\s+([\w-]+(\s+\(\d+\))?)\s+([^\s]+)\s+([\d+\-]+)(\s+)?$'
/usr/local/lib/migrate93/freenasUI/contrib/IPAddressField.py:11: DeprecationWarning: invalid escape sequence \.
["^freenasUI\.contrib\.IPAddressField\.IPAddressField"])
/usr/local/lib/migrate93/freenasUI/contrib/IPAddressField.py:13: DeprecationWarning: invalid escape sequence \.
["^freenasUI\.contrib\.IPAddressField\.IP4AddressField"])
/usr/local/lib/migrate93/freenasUI/contrib/IPAddressField.py:15: DeprecationWarning: invalid escape sequence \.
["^freenasUI\.contrib\.IPAddressField\.IP6AddressField"])
/usr/local/lib/python3.6/site-packages/south/modelsinspector.py:164: DeprecationWarning: invalid escape sequence \.
"^django\.db",
/usr/local/lib/python3.6/site-packages/south/modelsinspector.py:165: DeprecationWarning: invalid escape sequence \.
"^django\.contrib\.contenttypes\.generic",
/usr/local/lib/python3.6/site-packages/south/modelsinspector.py:166: DeprecationWarning: invalid escape sequence \.
"^django\.contrib\.localflavor",
/usr/local/lib/python3.6/site-packages/south/modelsinspector.py:167: DeprecationWarning: invalid escape sequence \w
"^django_localflavor_\w\w",
/usr/local/lib/python3.6/site-packages/south/modelsinspector.py:172: DeprecationWarning: invalid escape sequence \.
"^django\.contrib\.contenttypes\.generic\.GenericRelation",
/usr/local/lib/python3.6/site-packages/south/modelsinspector.py:173: DeprecationWarning: invalid escape sequence \.
"^django\.contrib\.contenttypes\.generic\.GenericForeignKey",
/usr/local/lib/python3.6/site-packages/south/introspection_plugins/geodjango.py:45: DeprecationWarning: invalid escape sequence \.
add_introspection_rules(rules, ["^django\.contrib\.gis"])
/usr/local/lib/python3.6/site-packages/south/introspection_plugins/django_audit_log.py:27: DeprecationWarning: invalid escape sequence \.
['^audit_log\.models\.fields\.LastUserField'],
/usr/local/lib/python3.6/site-packages/south/introspection_plugins/django_tagging.py:20: DeprecationWarning: invalid escape sequence \.
add_introspection_rules(rules, ["^tagging\.fields",])
/usr/local/lib/python3.6/site-packages/south/introspection_plugins/django_tagging.py:23: DeprecationWarning: invalid escape sequence \.
add_introspection_rules([], ["^tagging_autocomplete\.models\.TagAutocompleteField"])
/usr/local/lib/python3.6/site-packages/south/introspection_plugins/django_taggit.py:14: DeprecationWarning: invalid escape sequence \.
add_ignored_fields(["^taggit\.managers"])
/usr/local/lib/python3.6/site-packages/south/introspection_plugins/django_objectpermissions.py:14: DeprecationWarning: invalid escape sequence \.
add_ignored_fields(["^objectpermissions\.models\.UserPermissionRelation",
/usr/local/lib/python3.6/site-packages/south/introspection_plugins/django_objectpermissions.py:15: DeprecationWarning: invalid escape sequence \.
"^objectpermissions\.models\.GroupPermissionRelation"])
/usr/local/lib/python3.6/site-packages/south/introspection_plugins/annoying_autoonetoone.py:11: DeprecationWarning: invalid escape sequence \.
add_introspection_rules([], ["^annoying\.fields\.AutoOneToOneField"])
/usr/local/lib/python3.6/site-packages/lxml/_elementpath.py:63: DeprecationWarning: invalid escape sequence \.
"\.\.|"
/usr/local/lib/python3.6/site-packages/lxml/_elementpath.py:64: DeprecationWarning: invalid escape sequence \(
"\(\)|"
/usr/local/lib/python3.6/site-packages/lxml/_elementpath.py:65: DeprecationWarning: invalid escape sequence \[
"[/.*:\[\]\(\)@=])|"
/usr/local/lib/python3.6/site-packages/lxml/_elementpath.py:66: DeprecationWarning: invalid escape sequence \{
"((?:\{[^}]+\})?[^/\[\]\(\)@=\s]+)|"
/usr/local/lib/python3.6/site-packages/lxml/_elementpath.py:67: DeprecationWarning: invalid escape sequence \s
"\s+"
/usr/local/lib/python3.6/site-packages/lxml/_elementpath.py:160: DeprecationWarning: invalid escape sequence \d
if signature == "-" and not re.match("-?\d+$", predicate[0]):
/usr/local/lib/python3.6/site-packages/lxml/_elementpath.py:169: DeprecationWarning: invalid escape sequence \d
if signature == "-='" and not re.match("-?\d+$", predicate[0]):
/usr/local/lib/migrate93/freenasUI/sharing/migrations/0034_fix_wizard_cifs_vfsobjects.py:16: DeprecationWarning: invalid escape sequence \s
vfsobject = re.sub("\s+|\[|\]|'", '', vfsobject)
/usr/local/lib/migrate93/freenasUI/storage/migrations/0027_zpool_guid.py:25: DeprecationWarning: invalid escape sequence \s
vol.vol_guid = re.sub('\s+', ' ', line).split(' ')[2]
/usr/local/lib/migrate93/freenasUI/system/migrations/0029_ntpservers.py:7: DeprecationWarning: invalid escape sequence \s
entry = re.sub('\s+', ' ', entry).strip()
/usr/local/lib/migrate93/freenasUI/freeadmin/models/fields.py:37: DeprecationWarning: invalid escape sequence \.
add_introspection_rules([], ["^(freenasUI\.)?freeadmin\.models\.fields\..*"])
/usr/local/lib/migrate93/freenasUI/freeadmin/models/fields.py:136: DeprecationWarning: invalid escape sequence \g
return re.sub(r'(?P<du>[0-9A-F]{2})(?!$)', '\g<du>:', value)
FATAL ERROR - The following SQL query failed: CREATE TABLE "system_cloudcredentials" ("id" integer NOT NULL PRIMARY KEY, "name" varchar(100) NOT NULL, "provider" varchar(50) NOT NULL, "attributes" text NOT NULL)
The error was: table "system_cloudcredentials" already exists
Syncing...
Creating tables ...
Creating table auth_user_groups
Creating table auth_user_user_permissions
Creating table auth_user
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)
Migrating...
Running migrations for account:
- Nothing to migrate.
- Loading initial data for account.
Installed 0 object(s) from 0 fixture(s)
Running migrations for api:
- Nothing to migrate.
- Loading initial data for api.
Installed 0 object(s) from 0 fixture(s)
Running migrations for jails:
- Migrating forwards to 0038_retroactively_change_duplicate_mac_addresses.
> jails:0037_nuke_virtualbox_from_orbit
- Migration 'jails:0037_nuke_virtualbox_from_orbit' is marked for no-dry-run.
> jails:0038_retroactively_change_duplicate_mac_addresses
- Migration 'jails:0038_retroactively_change_duplicate_mac_addresses' is marked for no-dry-run.
- 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 support:
- Nothing to migrate.
- Loading initial data for support.
Installed 0 object(s) from 0 fixture(s)
Running migrations for directoryservice:
- Migrating forwards to 0063_auto__add_field_activedirectory_ad_monitor_frequency__add_field_active.
> directoryservice:0061_auto__add_field_activedirectory_ad_userdn__add_field_activedirectory_a
> directoryservice:0062_create_kerberossettings
- Migration 'directoryservice:0062_create_kerberossettings' is marked for no-dry-run.
> directoryservice:0063_auto__add_field_activedirectory_ad_monitor_frequency__add_field_active
- Loading initial data for directoryservice.
Installed 0 object(s) from 0 fixture(s)
Running migrations for network:
- Nothing to migrate.
- Loading initial data for network.
Installed 0 object(s) from 0 fixture(s)
Running migrations for services:
! Migration services:0198_iscsi_expunge_lun_auto should not have been applied before services:0197_add_field_AFP_afp_srv_map_acls but was.
! Migration services:0198_iscsi_expunge_lun_auto should not have been applied before services:0197_add_field_AFP_afp_srv_map_acls but was.
! Migration services:0198_iscsi_expunge_lun_auto should not have been applied before services:0197_add_field_AFP_afp_srv_map_acls but was.
- Migrating forwards to 0200_remove_obsolete_services.
> services:0195_auto__add_field_nfs_nfs_srv_mountd_log__add_field_nfs_nfs_srv_statd_lo
> services:0196_auto__add_field_services_ups_ups_shutdowncmd
> services:0197_add_field_AFP_afp_srv_map_acls
> services:0199_auto__add_field_iscsitargetglobalconfiguration_iscsi_alua
> services:0200_remove_obsolete_services
- Migration 'services:0200_remove_obsolete_services' is marked for no-dry-run.
- Loading initial data for services.
Installed 0 object(s) from 0 fixture(s)
Running migrations for sharing:
- Migrating forwards to 0035_auto__add_field_afp_share_afp_auxparams.
> sharing:0035_auto__add_field_afp_share_afp_auxparams
- Loading initial data for sharing.
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 system:
- Migrating forwards to 0112_systemdataset_rrd_disable.
> system:0103_auto__add_cloudcredentials
! 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_cloudcredentials"; []
! 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:0103_auto__add_cloudcredentials
Traceback (most recent call last):
File "/usr/local/lib/migrate93/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/migrate93/django/db/backends/sqlite3/base.py", line 452, in execute
return Database.Cursor.execute(self, query, params)
sqlite3.OperationalError: table "system_cloudcredentials" already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/migrate93/src/main.py", line 30, in <module>
run_syncdb()
File "/usr/local/lib/migrate93/src/utils.py", line 46, in run_syncdb
call_command('syncdb', interactive=False, merge=True, delete_ghosts=True, migrate=True)
File "/usr/local/lib/migrate93/django/core/management/__init__.py", line 159, in call_command
return klass.execute(*args, **defaults)
File "/usr/local/lib/migrate93/django/core/management/base.py", line 285, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/migrate93/django/core/management/base.py", line 415, in handle
return self.handle_noargs(**options)
File "/usr/local/lib/python3.6/site-packages/south/management/commands/syncdb.py", line 103, in handle_noargs
management.call_command('migrate', **options)
File "/usr/local/lib/migrate93/django/core/management/__init__.py", line 159, in call_command
return klass.execute(*args, **defaults)
File "/usr/local/lib/migrate93/django/core/management/base.py", line 285, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python3.6/site-packages/south/management/commands/migrate.py", line 111, in handle
ignore_ghosts = ignore_ghosts,
File "/usr/local/lib/python3.6/site-packages/south/migration/__init__.py", line 220, in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/usr/local/lib/python3.6/site-packages/south/migration/migrators.py", line 256, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations, database)
File "/usr/local/lib/python3.6/site-packages/south/migration/migrators.py", line 331, in migrate_many
result = self.migrate(migration, database)
File "/usr/local/lib/python3.6/site-packages/south/migration/migrators.py", line 133, in migrate
result = self.run(migration, database)
File "/usr/local/lib/python3.6/site-packages/south/migration/migrators.py", line 114, in run
return self.run_migration(migration, database)
File "/usr/local/lib/python3.6/site-packages/south/migration/migrators.py", line 84, in run_migration
migration_function()
File "/usr/local/lib/python3.6/site-packages/south/migration/migrators.py", line 60, in <lambda>
return (lambda: direction(orm))
File "/usr/local/lib/migrate93/freenasUI/system/migrations/0103_auto__add_cloudcredentials.py", line 14, in forwards
('attributes', self.gf('freenasUI.freeadmin.models.fields.DictField')()),
File "/usr/local/lib/python3.6/site-packages/south/db/generic.py", line 47, in _cache_clear
return func(self, table, *args, **opts)
File "/usr/local/lib/python3.6/site-packages/south/db/generic.py", line 361, in create_table
"columns": ', '.join([col for col in columns if col]),
File "/usr/local/lib/python3.6/site-packages/south/db/generic.py", line 282, in execute
cursor.execute(sql, params)
File "/usr/local/lib/migrate93/django/db/backends/util.py", line 69, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/migrate93/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/migrate93/django/db/utils.py", line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/migrate93/django/utils/six.py", line 658, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/migrate93/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/migrate93/django/db/backends/sqlite3/base.py", line 452, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: table "system_cloudcredentials" already exists
=== update.failed ends ===
SMB service refuse to start and when I go to the "services" menu I get this info:
Code:
=== text begins ===
Environment:
Software Version: FreeNAS-11.0-U2 (e417d8aa5)
Request Method: GET
Request URL: http://192.168.10.10/services/core/?dojo.preventCache=1502556331147
Traceback:
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
64. return self.cursor.execute(sql, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in execute
457. execute = self.locked_retry(Database.Cursor.execute, query, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
434. rv = method(self, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
39. response = get_response(request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _legacy_get_response
249. response = self._get_response(request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
178. response = middleware_method(request, callback, callback_args, callback_kwargs)
File "./freenasUI/freeadmin/middleware.py" in process_view
162. return login_required(view_func)(request, *view_args, **view_kwargs)
File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
23. return view_func(request, *args, **kwargs)
File "./freenasUI/services/views.py" in core
78. afp = models.AFP.objects.order_by("-id")[0]
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __getitem__
295. return list(qs)[0]
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __iter__
256. self._fetch_all()
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in _fetch_all
1087. self._result_cache = list(self.iterator())
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __iter__
54. results = compiler.execute_sql()
File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
835. cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
64. return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-packages/django/db/utils.py" in __exit__
94. six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python3.6/site-packages/django/utils/six.py" in reraise
685. raise value.with_traceback(tb)
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
64. return self.cursor.execute(sql, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in execute
457. execute = self.locked_retry(Database.Cursor.execute, query, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
434. rv = method(self, *args, **kwargs)
Exception Type: OperationalError at /services/core/
Exception Value: no such column: services_afp.afp_srv_chmod_request
=== text ends ===
Can anyone tell me what to do to fix this?
