Bug 1579500 - DBError: (pymysql.err.InternalError) (1118, u'The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size.
Summary: DBError: (pymysql.err.InternalError) (1118, u'The size of BLOB/TEXT data inse...
Keywords:
Status: CLOSED DUPLICATE of bug 1573496
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-common
Version: 13.0 (Queens)
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: James Slagle
QA Contact: Alexander Chuzhoy
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-05-17 19:39 UTC by James Slagle
Modified: 2018-05-29 11:40 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-05-17 19:43:43 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1768913 0 None None None 2018-05-17 19:40:34 UTC
OpenStack gerrit 566884 0 None MERGED Add a 'trash_output' flag to ansible playbook action 2020-03-30 18:57:38 UTC

Description James Slagle 2018-05-17 19:39:20 UTC
The following error is seen during deployment:
DBError: (pymysql.err.InternalError) (1118, u'The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.') [SQL: u'UPDATE action_executions_v2 SET updated_at=%(updated_at)s, state=%(state)s, accepted=%(accepted)s, output=%(output)s WHERE action_executions_v2.id = %(action_executions_v2_id)s'] [parameters: {'output': '{"result": {"returncode": 0, "stderr": "", "stdout": "Using /var/lib/mistral/43fa4af8-89c8-4946-a9ae-17ce3a2f0b83/ansible.cfg as config file\\n[DEPRE ... (14957164 characters truncated) ... te-1 : ok=123 changed=38 unreachable=0 failed=0 \\nundercloud : ok=21 changed=10 unreachable=0 failed=0 \\n\\n"}}', 'state': 'SUCCESS', 'accepted': 1, 'updated_at': datetime.datetime(2018, 5, 3, 14, 39, 18), 'action_executions_v2_id': u'72955202-c0e6-4e5f-addf-c57fda732f64'}] (Background on this error at: http://sqlalche.me/e/2j85)

This causes the openstack overcloud deployment command to hang at the end of the deployment. The issue here is with storing ansible logs into sql. A workaround for this is to bump this sql config:
innodb_log_file_size=256M

https://stackoverflow.com/questions/25277452/how-to-configure-mysql-5-6-longblob-for-large-binary-data

I think the real solution should be to not store the ansible log output in sql.

Comment 1 James Slagle 2018-05-17 19:43:43 UTC

*** This bug has been marked as a duplicate of bug 1573496 ***


Note You need to log in before you can comment on or make changes to this bug.