[OpenSIPS-Users] Opensips 3.0 | opensips-cli -x database create -> Index column size too large. The maximum column size is 767 bytes.
Bogdan-Andrei Iancu
bogdan at opensips.org
Thu Sep 12 11:21:24 EDT 2019
Hi Adrian,
How did you install the OpenSIPS 3.0 ? from sources or from packages ?
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
OpenSIPS Summit 2019
https://www.opensips.org/events/Summit-2019Amsterdam/
On 8/28/19 10:50 PM, Adrian Fretwell wrote:
> 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 <mailto: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 <mailto:root at sip4-master>:~#
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20190912/a61f661c/attachment-0001.html>
More information about the Users
mailing list