gistfile1.txt

+ python3 -c 'import os; import middlewared; print(os.path.dirname(middlewared.__spec__.origin))'
+ cd /usr/local/lib/python3.9/site-packages/middlewared
+ alembic upgrade head
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> c6be4fe10acc, Fix references
INFO  [alembic.runtime.migration] Running upgrade c6be4fe10acc -> e49fadd7285d, Fix booleans
INFO  [alembic.runtime.migration] Running upgrade e49fadd7285d -> 0d545b21e189, Drop Django tables
INFO  [alembic.runtime.migration] Running upgrade 0d545b21e189 -> a3423860aea0, Drop nfs_share_path MtM
INFO  [alembic.runtime.migration] Running upgrade a3423860aea0 -> d38e9cc6174c, Fix lacking foreign keys
INFO  [alembic.runtime.migration] Running upgrade d38e9cc6174c -> 74cf6ec20dcd, Failover master node
INFO  [alembic.runtime.migration] Running upgrade 74cf6ec20dcd -> ed69a9a6fab1, Rename indexes
INFO  [alembic.runtime.migration] Running upgrade ed69a9a6fab1 -> 6d65fd64e91c, Pool ON DELETE CASCADE
INFO  [alembic.runtime.migration] Running upgrade 6d65fd64e91c -> a87f7ecc4e88, Migrate legacy replication
INFO  [alembic.runtime.migration] Running upgrade a87f7ecc4e88 -> 7f8be1364037, Remove legacy UI field
INFO  [alembic.runtime.migration] Running upgrade 7f8be1364037 -> 7e8f7f07153e, Encrypted dataset model
INFO  [alembic.runtime.migration] Running upgrade 7e8f7f07153e -> 8b5d36242d44, Complete filesystem replicate option
INFO  [alembic.runtime.migration] Running upgrade 8b5d36242d44 -> 115caec86b91, OpenVPN client and server
INFO  [alembic.runtime.migration] Running upgrade 115caec86b91 -> 514ce6934952, NFSv4 domain
INFO  [alembic.runtime.migration] Running upgrade 514ce6934952 -> f2e8d8e7fd57, Two-Factor auth
INFO  [alembic.runtime.migration] Running upgrade f2e8d8e7fd57 -> d20ab6a17489, Certificates revocation
INFO  [alembic.runtime.migration] Running upgrade d20ab6a17489 -> 987305d75e3a, Graphite SeparateInstances
INFO  [alembic.runtime.migration] Running upgrade 987305d75e3a -> ef898631896b, HTTPs protocols
INFO  [alembic.runtime.migration] Running upgrade ef898631896b -> 350a31cb0769, Move syslog to advanced settings
INFO  [alembic.runtime.migration] Running upgrade 350a31cb0769 -> bbedeabf94c7, Init/Shutdown script text and comment
INFO  [alembic.runtime.migration] Running upgrade bbedeabf94c7 -> aa9810be100c, Normalize VM models
INFO  [alembic.runtime.migration] Running upgrade aa9810be100c -> dcf5c178714b, Add disk HDD Standby force option
INFO  [alembic.runtime.migration] Running upgrade dcf5c178714b -> 17fe2353a0de, Fix idmap foreign keys
INFO  [alembic.runtime.migration] Running upgrade 17fe2353a0de -> f4e2434ad7f1, Alert last_occurrence
INFO  [alembic.runtime.migration] Running upgrade f4e2434ad7f1 -> c0f121844b00, KMIP Support
INFO  [alembic.runtime.migration] Running upgrade c0f121844b00 -> 133f2d9049d2, empty message
INFO  [alembic.runtime.migration] Running upgrade 133f2d9049d2 -> 39a133a04496, empty message
INFO  [alembic.runtime.migration] Running upgrade 39a133a04496 -> f3875acb8d76, Fix user shell choices
INFO  [alembic.runtime.migration] Running upgrade f3875acb8d76 -> 536cbfca20e6, Drop iSCSI initiator tag column
INFO  [alembic.runtime.migration] Running upgrade 536cbfca20e6 -> bc290fddc888, Simplify SMB shares
INFO  [alembic.runtime.migration] Running upgrade bc290fddc888 -> f6a18dec20fa, Simplify and clean up idmap backends
INFO  [alembic.runtime.migration] Running upgrade f6a18dec20fa -> 4abbf75347b2, Add SMB flag to users and groups
INFO  [alembic.runtime.migration] Running upgrade 4abbf75347b2 -> 06bfbd354deb, SSH weak ciphers
INFO  [alembic.runtime.migration] Running upgrade 06bfbd354deb -> b5cac06345ea, webdav_enable
INFO  [alembic.runtime.migration] Running upgrade b5cac06345ea -> 8f874e6e40bc, Replication readonly
INFO  [alembic.runtime.migration] Running upgrade 8f874e6e40bc -> 32f55c715352, Add ad_restrict_pam key
INFO  [alembic.runtime.migration] Running upgrade 32f55c715352 -> a06b1946f6a3, empty message
INFO  [alembic.runtime.migration] Running upgrade a06b1946f6a3 -> 6602857581db, API Key
INFO  [alembic.runtime.migration] Running upgrade 6602857581db -> 38773ca83199, API Key created_at
INFO  [alembic.runtime.migration] Running upgrade 38773ca83199 -> 29e866803c47, Overprovision
INFO  [alembic.runtime.migration] Running upgrade 29e866803c47 -> 171f5b91c36e, Fix replication foreign keys
INFO  [alembic.runtime.migration] Running upgrade 171f5b91c36e -> 58339783792c, TrueCommand Service Model
INFO  [alembic.runtime.migration] Running upgrade 58339783792c -> 83dae64197f3, Remove asigra table
INFO  [alembic.runtime.migration] Running upgrade 83dae64197f3 -> 2ab85192c49f, Encrypt SSH and certificates private keys
INFO  [alembic.runtime.migration] Running upgrade 2ab85192c49f -> 43779dce3a07, Convert SMB bindip not null
INFO  [alembic.runtime.migration] Running upgrade 43779dce3a07 -> 22230265ab30, iSCSI Vendor configuration
INFO  [alembic.runtime.migration] Running upgrade 22230265ab30 -> 434ea5397cd3, encrypt smbhash
INFO  [alembic.runtime.migration] Running upgrade 434ea5397cd3 -> 730c995cbd37, remove nmbclusters sysctl
INFO  [alembic.runtime.migration] Running upgrade 730c995cbd37 -> e9e611d7c5a7, make netatalk logging configurable
INFO  [alembic.runtime.migration] Running upgrade e9e611d7c5a7 -> a3ac49efb063, birthday
INFO  [alembic.runtime.migration] Running upgrade a3ac49efb063 -> b694f05c1169, Run data migration on install / factory reset
INFO  [alembic.runtime.migration] Running upgrade b694f05c1169 -> 1432b666093e, Remove replication dedup
INFO  [alembic.runtime.migration] Running upgrade 1432b666093e -> ffcd02f6af9f, Remove alerts unique index
INFO  [alembic.runtime.migration] Running upgrade ffcd02f6af9f -> 85346ccd33c0, Remove legacy freenas sysctls
INFO  [alembic.runtime.migration] Running upgrade 85346ccd33c0 -> 5a365c7248da, Add next_rid column to services_cifs
INFO  [alembic.runtime.migration] Running upgrade 5a365c7248da -> 8ac8158773c4, storage_disk primary key
INFO  [alembic.runtime.migration] Running upgrade 8ac8158773c4 -> c01e9d77922e, Add SMB secrets
INFO  [alembic.runtime.migration] Running upgrade c01e9d77922e -> 71a8d1e504a7, Add Rsyncmod enabled field
INFO  [alembic.runtime.migration] Running upgrade 71a8d1e504a7 -> 25962b409a1e, cleanup AD parameters
INFO  [alembic.runtime.migration] Running upgrade 25962b409a1e -> 6d3efdc7ba5b, Fix migrations state
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 719, in do_execute
    cursor.execute(statement, parameters)
sqlite3.IntegrityError: NOT NULL constraint failed: _alembic_tmp_services_rsyncmod.rsyncmod_enabled

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

Traceback (most recent call last):
  File "/usr/local/bin/alembic", line 33, in <module>
    sys.exit(load_entry_point('alembic==1.7.5', 'console_scripts', 'alembic')())
  File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 588, in main
    CommandLine(prog=prog).main(argv=argv)
  File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 582, in main
    self.run_cmd(cfg, options)
  File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 559, in run_cmd
    fn(
  File "/usr/local/lib/python3.9/site-packages/alembic/command.py", line 320, in upgrade
    script.run_env()
  File "/usr/local/lib/python3.9/site-packages/alembic/script/base.py", line 563, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/usr/local/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 92, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/local/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 108, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
  File "<frozen importlib._bootstrap_external>", line 850, in exec_module
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "alembic/env.py", line 161, in <module>
    run_migrations_online()
  File "alembic/env.py", line 155, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/usr/local/lib/python3.9/site-packages/alembic/runtime/environment.py", line 851, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/usr/local/lib/python3.9/site-packages/alembic/runtime/migration.py", line 620, in run_migrations
    step.migration_fn(**kw)
  File "/usr/local/lib/python3.9/site-packages/middlewared/alembic/versions/12.0/2020-07-21_13-53_fix_migrations_state.py", line 22, in upgrade
    batch_op.alter_column('rsyncmod_enabled',
  File "/usr/local/lib/python3.9/contextlib.py", line 126, in __exit__
    next(self.gen)
  File "/usr/local/lib/python3.9/site-packages/alembic/operations/base.py", line 374, in batch_alter_table
    impl.flush()
  File "/usr/local/lib/python3.9/site-packages/alembic/operations/batch.py", line 140, in flush
    batch_impl._create(self.impl)
  File "/usr/local/lib/python3.9/site-packages/alembic/operations/batch.py", line 414, in _create
    op_impl._exec(
  File "/usr/local/lib/python3.9/site-packages/alembic/ddl/impl.py", line 197, in _exec
    return conn.execute(construct, multiparams)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1289, in execute
    return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1481, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1845, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2026, in _handle_dbapi_exception
    util.raise_(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 719, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: _alembic_tmp_services_rsyncmod.rsyncmod_enabled
[SQL: INSERT INTO _alembic_tmp_services_rsyncmod (rsyncmod_mode, rsyncmod_maxconn, rsyncmod_hostsallow, rsyncmod_path, rsyncmod_hostsdeny, rsyncmod_user, rsyncmod_auxiliary, rsyncmod_group, rsyncmod_name, rsyncmod_comment, id, rsyncmod_enabled) SELECT services_rsyncmod.rsyncmod_mode, services_rsyncmod.rsyncmod_maxconn, services_rsyncmod.rsyncmod_hostsallow, services_rsyncmod.rsyncmod_path, services_rsyncmod.rsyncmod_hostsdeny, services_rsyncmod.rsyncmod_user, services_rsyncmod.rsyncmod_auxiliary, services_rsyncmod.rsyncmod_group, services_rsyncmod.rsyncmod_name, services_rsyncmod.rsyncmod_comment, services_rsyncmod.id, services_rsyncmod.rsyncmod_enabled
FROM services_rsyncmod]
(Background on this error at: https://sqlalche.me/e/14/gkpj)