[OpenSIPS-Users] Opensips 3.0 | opensips-cli -x database create -> Index column size too large. The maximum column size is 767 bytes.
Adrian Fretwell
adrian.fretwell at topgreen.co.uk
Wed Aug 28 15:50:47 EDT 2019
Hello All,
Just migrating to Opensips 3.0 and I am using opensip-cli for the first
time.
When I issue a opensips-cli -x database create command some of the
operations fail with:
Error: (1709, 'Index column size too large. The maximum column size is
767 bytes.')
I will paste the full error below. I am aware of this limitation with
10.1.38-MariaDB-0+deb9u1 but have added the following to my mysql
config file:
innodb_file_format=barracuda
innodb_file_format_max=barracuda
innodb_file_per_table=on
innodb_large_prefix=on
I believe the last part of the work around is to specify the row format
as DYNAMIC thus enabling the index key prefix length limit to be raised
to 3072 bytes for InnoDB tables with this format.
The problem is that I can't work out how to specify the row format
DYNAMIC to the opensips-cli program, can anyone help?
Kind regards,
Adrian Fretwell
Full error printout for one table operation:
root at sip4-master:~# opensips-cli -x database create
SQLAlchemy version: 1.3.3
Please provide the URL of the SQL database: mysql://root@localhost
Create [a]ll tables or just the [c]urrently configured ones? (Default
value is a):
Creating all tables ...
Running standard-create.sql...
Running group-create.sql...
Running b2b-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
Running acc-create.sql...
Running clusterer-create.sql...
Running tracer-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
Running closeddial-create.sql...
Running registrant-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
Running call_center-create.sql...
Running dialog-create.sql...
Running load_balancer-create.sql...
Running tls_mgm-create.sql...
Running domain-create.sql...
Running msilo-create.sql...
Running avpops-create.sql...
Running dispatcher-create.sql...
Running rtpengine-create.sql...
Running usrloc-create.sql...
Running fraud_detection-create.sql...
Running emergency-create.sql...
Running rls-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
Running auth_db-create.sql...
Running presence-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
Running cpl-create.sql...
Running dialplan-create.sql...
Running freeswitch_scripting-create.sql...
Running rtpproxy-create.sql...
Running permissions-create.sql...
Running b2b_sca-create.sql...
Running drouting-create.sql...
Running alias_db-create.sql...
Running cachedb_sql-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
Running domainpolicy-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
Running speeddial-create.sql...
Running userblacklist-create.sql...
Running imc-create.sql...
Running carrierroute-create.sql...
Running smpp-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-
linux-x86_64.egg/sqlalchemy/engine/base.py", line 1333, in
_safe_close_cursor
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 85, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-
py3.5-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in nextset
nr = db.next_result()
_mysql_exceptions.OperationalError: (1709, 'Index column size too
large. The maximum column size is 767 bytes.')
root at sip4-master:~#
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20190828/eca75679/attachment-0001.html>
More information about the Users
mailing list