WattsUp314
Cadet
- Joined
- Jan 24, 2019
- Messages
- 1
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
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)