I have follow error:
Traceback mostrecentcalllast:
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 222, in run_from_argv
self.execute*args, **options.__dict__
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 255, in execute
output = self.handle∗args,∗∗options
File "/home/vinger4/Projects/a360/router/management/commands/places_update.py", line 428, in handle
airport.save
File "/home/vinger4/Projects/a360/content/models.py", line 545, in save
superAirport,self.save∗args,∗∗kwargs
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 546, in save
force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 626, in save_base
rows = manager.usingusing.filterpk=pkval._updatevalues
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 605, in _update
return query.get_compilerself.db.execute_sqlNone
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 1020, in execute_sql
cursor = superSQLUpdateCompiler,self.execute_sqlresulttype
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 846, in execute_sql
cursor.executesql,params
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 128, in execute
six.reraiseutils.DatabaseError,utils.DatabaseError(∗tuple(e.args), sys.exc_info2)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 120, in execute
return self.cursor.executequery,args
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandlerself,exc,value
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
DatabaseError: 1118,′Rowsizetoolarge(>8126. Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.')
Set ROW_FORMAT=COMPRESSED for my_table:
mysql> SET GLOBAL innodb_file_format=Barracuda; SET GLOBAL innodb_file_per_table=ON; ALTER TABLE my_table ROW_FORMAT=COMPRESSED;
Query OK, 0 rows affected 0.00sec
Query OK, 0 rows affected 0.00sec
Query OK, 258 rows affected 0.35sec
Records: 258 Duplicates: 0 Warnings: 0
mysql>
Комментариев нет:
Отправить комментарий