Comment 1 for bug 1510181

Revision history for this message
Zhenzan Zhou (zhenzan-zhou) wrote :

ptas@devstack02:~$ watcher audit-template-create -d desc 012345678901234567890123456789012345678901234567890123456789 DUMMY
+----------------+--------------------------------------------------------------+
| Property | Value |
+----------------+--------------------------------------------------------------+
| goal | DUMMY |
| extra | {} |
| description | desc |
| name | 012345678901234567890123456789012345678901234567890123456789 |
| host_aggregate | None |
| uuid | 9232893d-083e-439d-94bb-2234d5c02ea0 |
+----------------+--------------------------------------------------------------+
ptas@devstack02:~$ watcher audit-template-create -d desc 012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789 DUMMY
Internal Server Error (HTTP 500)

============== watcher-api log =====================

2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters [req-53f851f9-4853-4081-9aa2-a40b1092c562 watcher admin - - -] DBAPIError exception wrapped from (DataError) (1406, "Data too long for column 'name' at row 1") 'INSERT INTO audit_templates (created_at, updated_at, deleted_at, deleted, uuid, name, description, host_aggregate, goal, extra, version) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (datetime.datetime(2015, 12, 7, 0, 2, 23, 821978), None, None, 0, '3dcd71aa-0743-4d4b-a672-41a23f9636b2', '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789', 'desc', None, 'DUMMY', '{}', None)
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1063, in _execute_context
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters context)
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 442, in do_execute
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters self.errorhandler(self, exc, value)
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass, errorvalue
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters DataError: (1406, "Data too long for column 'name' at row 1")
2015-12-07 00:02:23.830 64559 ERROR oslo_db.sqlalchemy.exc_filters
2015-12-07 00:02:23.895 64559 ERROR wsme.api [req-53f851f9-4853-4081-9aa2-a40b1092c562 watcher admin - - -] Server-side error: "(DataError) (1406, "Data too long for column 'name' at row 1") 'INSERT INTO audit_templates (created_at, updated_at, deleted_at, deleted, uuid, name, description, host_aggregate, goal, extra, version) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (datetime.datetime(2015, 12, 7, 0, 2, 23, 821978), None, None, 0, '3dcd71aa-0743-4d4b-a672-41a23f9636b2', '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789', 'desc', None, 'DUMMY', '{}', None)".