integrity error when setting up iSCI for ZVol

P

Phalanxguard

Cadet
Joined
Dec 23, 2020
Messages
1
Hi, has anyone encountered the following error when setting a ZVol ISCI through the latest stable TrueNAS? Any solutions? The configured pass for it is 12 alphanumeric characters. Works fine when CHAPS is not enabled.

Code:
integrityError (sqlite3.IntegrityError) NOT NULL constraint failed: services_iscsitargetauthcredential.iscsi_target_auth_peersecret [SQL: INSERT INTO services_iscsitargetauthcredential (iscsi_target_auth_tag, iscsi_target_auth_user, iscsi_target_auth_secret, iscsi_target_auth_peeruser) VALUES (?, ?, ?, ?)] [parameters: (2, 'Druv', '3aMu6YvBB1Nvh4CgWxFtHP7bcEt4mTp2S/1g27z7YG9wt8AaCyKuEx==', '')] (Background on this error at: http://sqlalche.me/e/gkpj)


Code:
Error: Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute
    cursor.execute(statement, parameters)
sqlite3.IntegrityError: NOT NULL constraint failed: services_iscsitargetauthcredential.iscsi_target_auth_peersecret

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

Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 137, in call_method
    result = await self.middleware._call(message['method'], serviceobj, methodobj, params, app=self,
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/local/lib/python3.8/site-packages/middlewared/service.py", line 455, in create
    rv = await self.middleware._call(
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/local/lib/python3.8/site-packages/middlewared/schema.py", line 973, in nf
    return await f(*args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/iscsi.py", line 333, in do_create
    data['id'] = await self.middleware.call(
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1238, in call
    return await self._call(
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/local/lib/python3.8/site-packages/middlewared/schema.py", line 973, in nf
    return await f(*args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/write.py", line 31, in insert
    await self.middleware.call('datastore.execute_write', table.insert().values(**insert))
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1238, in call
    return await self._call(
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/connection.py", line 65, in execute_write
    return await self.middleware.run_in_executor(self.thread_pool, self._execute_write, sql, binds)
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1110, in run_in_executor
    return await loop.run_in_executor(pool, functools.partial(method, *args, **kwargs))
  File "/usr/local/lib/python3.8/concurrent/futures/thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/connection.py", line 68, in _execute_write
    result = self.connection.execute(sql, binds)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 976, in execute
    return self._execute_text(object_, multiparams, params)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1145, in _execute_text
    ret = self._execute_context(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1287, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1481, in _handle_dbapi_exception
    util.raise_(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
    raise exception
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: services_iscsitargetauthcredential.iscsi_target_auth_peersecret
[SQL: INSERT INTO services_iscsitargetauthcredential (iscsi_target_auth_tag, iscsi_target_auth_user, iscsi_target_auth_secret, iscsi_target_auth_peeruser) VALUES (?, ?, ?, ?)]
[parameters: (2, 'Stephen', '3aMut1RcB1Nvh4CgWjLLqP7bcEt4mTp2S/1g27z7YG9wt8AaCyQkXg==', '')]
(Background on this error at: http://sqlalche.me/e/gkpj)
 
M

MDPD

Cadet
Joined
Jan 7, 2021
Messages
1
Yes, the same problem, SCALE-20.12-ALPHA

(sqlite3.IntegrityError) NOT NULL constraint failed: services_iscsitargetauthcredential.iscsi_target_auth_peersecret [SQL: INSERT INTO services_iscsitargetauthcredential (iscsi_target_auth_tag, iscsi_target_auth_user, iscsi_target_auth_secret, iscsi_target_auth_peeruser) VALUES (?, ?, ?, ?)] [parameters: (1, 'mdpd', 'tAO+ckO24UKYnAZiwwT0GwxGFIluRSI4g1RlhcKwwTkmnNrWbskdEg==', '')] (Background on this error at: http://sqlalche.me/e/13/gkpj)
 
H

habouji

Cadet
Joined
Jan 16, 2021
Messages
9
Same here with TrueNAS-12.0-U1.

Code:
Error: Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute
    cursor.execute(statement, parameters)
sqlite3.IntegrityError: NOT NULL constraint failed: services_iscsitargetauthcredential.iscsi_target_auth_peersecret

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

Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 137, in call_method
    result = await self.middleware._call(message['method'], serviceobj, methodobj, params, app=self,
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/local/lib/python3.8/site-packages/middlewared/service.py", line 455, in create
    rv = await self.middleware._call(
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/local/lib/python3.8/site-packages/middlewared/schema.py", line 973, in nf
    return await f(*args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/iscsi.py", line 333, in do_create
    data['id'] = await self.middleware.call(
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1238, in call
    return await self._call(
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/local/lib/python3.8/site-packages/middlewared/schema.py", line 973, in nf
    return await f(*args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/write.py", line 31, in insert
    await self.middleware.call('datastore.execute_write', table.insert().values(**insert))
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1238, in call
    return await self._call(
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1195, in _call
    return await methodobj(*prepared_call.args)
  File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/connection.py", line 65, in execute_write
    return await self.middleware.run_in_executor(self.thread_pool, self._execute_write, sql, binds)
  File "/usr/local/lib/python3.8/site-packages/middlewared/main.py", line 1110, in run_in_executor
    return await loop.run_in_executor(pool, functools.partial(method, *args, **kwargs))
  File "/usr/local/lib/python3.8/concurrent/futures/thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/local/lib/python3.8/site-packages/middlewared/plugins/datastore/connection.py", line 68, in _execute_write
    result = self.connection.execute(sql, binds)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 976, in execute
    return self._execute_text(object_, multiparams, params)
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1145, in _execute_text
    ret = self._execute_context(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1287, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1481, in _handle_dbapi_exception
    util.raise_(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
    raise exception
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: services_iscsitargetauthcredential.iscsi_target_auth_peersecret
[SQL: INSERT INTO services_iscsitargetauthcredential (iscsi_target_auth_tag, iscsi_target_auth_user, iscsi_target_auth_secret, iscsi_target_auth_peeruser) VALUES (?, ?, ?, ?)]
[parameters: (1, 'testuser', 'gT9mjhKc/1ObfZMC7l5aydcnCbechhPkotqF1JNPDyXELVzkjpir1Q==', '')]
(Background on this error at: http://sqlalche.me/e/gkpj)
 
S

smcclos

Dabbler
Joined
Jan 22, 2021
Messages
43
I too am seeing this with TrueNAS-12.0-U1, using no CHAP at this time as a workaround.
 
G

gheppy

Cadet
Joined
Jun 1, 2020
Messages
3
The workaround that I found is to create a user with Peer User to, after which you re-edit it and delete the Peer User part if you do not use it.
The script checks also the Peer User field and it cannot be null. This is the bug.
 
You must log in or register to reply here.

Similar threads

L
Cannot create NFS share (sqlite3.OperationalError)
Replies
1
Views
1K
lpwevers
L
Scampicfx
Bug TrueNAS-12.0-U1.1: Adding "Authorized Access iSCSI User" fails
Replies
5
Views
1K
Scampicfx
Scampicfx
Z
Help please! Error decrypting pool Freenas 11_3 beta
2
Replies
28
Views
8K
theyost
T
P
NextCloud suddenly stopped working...Runtime error???
Replies
2
Views
876
Pctravel
P
I
Pool unlock fails with geli.key
Replies
13
Views
3K
PhiloEpisteme
PhiloEpisteme
Top