Middleware Fails to Start, Synchronizing Plugins Account Groups - 22.02-RC.1

[WattsUp314]

After a sudden power loss (wind storm induced) my server fails to boot up. It lets me drop into the shell physically, network interfaces are down. It cites middleware failing to start. Below is the log output, this message repeats every 6 seconds for the entire log. Any ideas why? Or should I just reinstall and reupload the configuration file?

middlewared.log

Code:

[2021/11/16 17:22:05] (INFO) middlewared.__init__():851 - Starting TrueNAS-SCALE-22.02-MASTER-20211111-192922 middleware
[2021/11/16 17:22:13] (DEBUG) middlewared.setup():1895 - Timezone set to America/Los_Angeles
[2021/11/16 17:22:13] (INFO) UserService.sync_builtin():111 - Creating new group 'minio'
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    cursor.execute(statement, parameters)
sqlite3.IntegrityError: UNIQUE constraint failed: account_bsdgroups.bsdgrp_group

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/bin/middlewared", line 12, in <module>
    sys.exit(main())
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1749, in main
    Middleware(
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1576, in run
    self.loop.run_until_complete(self.__initialize())
  File "/usr/lib/python3.9/asyncio/base_events.py", line 642, in run_until_complete
    return future.result()
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1641, in __initialize
    await self.__plugins_setup(setup_funcs)
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 968, in __plugins_setup
    await call
  File "/usr/lib/python3/dist-packages/middlewared/plugins/account.py", line 1581, in setup
    await middleware.call('user.sync_builtin')
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1310, in call
    return await self._call(
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1278, in _call
    return await self.run_in_executor(prepared_call.executor, methodobj, *prepared_call.args)
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1180, in run_in_executor
    return await loop.run_in_executor(exc, functools.partial(method, *args, **kwargs))
  File "/usr/lib/python3.9/concurrent/futures/thread.py", line 52, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/lib/python3/dist-packages/middlewared/plugins/account_/sync_builtin.py", line 121, in sync_builtin
    existing_group["id"] = self.middleware.call_sync(
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1326, in call_sync
    return self.run_coroutine(methodobj(*prepared_call.args))
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1366, in run_coroutine
    return fut.result()
  File "/usr/lib/python3.9/concurrent/futures/_base.py", line 433, in result
    return self.__get_result()
  File "/usr/lib/python3.9/concurrent/futures/_base.py", line 389, in __get_result
    raise self._exception
  File "/usr/lib/python3/dist-packages/middlewared/schema.py", line 1269, in nf
    return await func(*args, **kwargs)
  File "/usr/lib/python3/dist-packages/middlewared/plugins/datastore/write.py", line 41, in insert
    result = await self.middleware.call(
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1310, in call
    return await self._call(
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1267, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/lib/python3/dist-packages/middlewared/plugins/datastore/connection.py", line 70, in execute_write
    return await self.middleware.run_in_executor(self.thread_pool, self._execute_write, sql, binds, options)
  File "/usr/lib/python3/dist-packages/middlewared/main.py", line 1182, in run_in_executor
    return await loop.run_in_executor(pool, functools.partial(method, *args, **kwargs))
  File "/usr/lib/python3.9/concurrent/futures/thread.py", line 52, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/lib/python3/dist-packages/middlewared/plugins/datastore/connection.py", line 73, in _execute_write
    result = self.connection.execute(sql, binds)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1003, in execute
    return self._execute_text(object_, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1172, in _execute_text
    ret = self._execute_context(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: account_bsdgroups.bsdgrp_group
[SQL: INSERT INTO account_bsdgroups (bsdgrp_gid, bsdgrp_group, bsdgrp_builtin, bsdgrp_sudo, bsdgrp_sudo_nopasswd, bsdgrp_sudo_commands, bsdgrp_smb) VALUES (?, ?, ?, ?, ?, ?, ?)]
[parameters: (473, 'minio', 1, 0, 0, '[]', 0)]
(Background on this error at: http://sqlalche.me/e/13/gkpj)

 

[Samuel Tai]

Code:

sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: account_bsdgroups.bsdgrp_group
[SQL: INSERT INTO account_bsdgroups (bsdgrp_gid, bsdgrp_group, bsdgrp_builtin, bsdgrp_sudo, bsdgrp_sudo_nopasswd, bsdgrp_sudo_commands, bsdgrp_smb) VALUES (?, ?, ?, ?, ?, ?, ?)]
[parameters: (473, 'minio', 1, 0, 0, '[]', 0)]
(Background on this error at: http://sqlalche.me/e/13/gkpj)

The configuration database has been corrupted. You'll have to reinstall and upload your configuration.