OperationalError: (1366, "Incorrect string value: '\\xE2\\x89\\xA5 10...' for column 'description' at row 1")

[terenced]

How to Reproduce

While doing a POST operation on /ticket/4597, Trac issued an internal error.

Request parameters:

{u'__FORM_TOKEN': u'5ebf7c5b22ace08d4f363941',
 u'action': u'save',
 u'comment': u'',
 u'field_activity_type': u'',
 u'field_configuration': u'',
 u'field_description': u'This test outlines the steps required to discharge the RBAT-2 installed on the VSTB. \r\n\r\n RBAT2 Discharge Test\r\n\r\n== Setup\r\nEquipment Required:\r\n* \u2265 100W Power Resistor (Approx. 10 Ohms)\r\n* 44 Socket HD D-sub BOB Cable ST12024-3S for BCB2 P2 (See BOB Cable Configuration)\r\n* Volt Meter\r\n* Amp Meter\r\n* Set of hard wire with banana plugs and clips for resistor\r\n\r\nSteps: \r\n* Demate BCB2_J2 connector from the RPA\r\n* Install BOB cable at BCB2_P2 (Harness Side of W0104)\r\n* Install fluke amp meter in series into the battery circuit to measure the current discharging from battery.\r\n* Attach Hi side wires to RED SiDE of Pins 1, 2, 3 on BOB-1. Other ends of these wires to an empty Pin 1 on BOB-2. \r\n* Attach Lo Side wires to RED SIDE Pins 12, 13, 14 on BOB-1. Other ends of these wires to an empty Pin 2 on BOB-2. \r\n\r\n== Test Steps\r\n* Measure the voltage across Pin 1 and Pin 12 on RED SIDE of BOB-1\r\n* Install Power Resistor across Pin 1 and Pin 2 of BOB-2. Monitor current draw on amp meter\r\n* Take Voltage measurements and Current Measurements every 10 seconds \r\n* After 1 min discharging, remove the power resistor from BOB-2.\r\n* Measure the voltage across Pin 1 and Pin 12 on BOB-1\r\n',
 u'field_equipment': u'',
 u'field_fsw_version': u'',
 u'field_gds_sw_version': u'',
 u'field_need_by_date': u'',
 u'field_people': u'',
 u'field_ram_sandbox_location': u'',
 u'field_reporter': u'terenced',
 u'field_sse_sw_version': u'',
 u'field_summary': u'VSTB RBAT2 Discharge Test',
 u'field_venue': u'',
 'id': u'4597',
 u'replyto': u'',
 u'start_time': u'1604369535853270',
 u'submit': u'Submit Changes',
 u'view_time': u'1604369535853270'}

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.2 Safari/605.1.15

System Information

Trac	1.2
Genshi	0.7.3 (with speedups)
mod_wsgi	3.4 (WSGIProcessGroup WSGIApplicationGroup m20stbwebapps.jpl.nasa.gov|/trac/str)
MySQL	server: "5.7.20", client: "5.5.64-MariaDB", thread-safe: 1
MySQLdb	1.2.5
Python	2.7.5 (default, Aug 7 2019, 00:51:29) [GCC 4.8.5 20150623 (Red Hat 4.8.5-39)]
setuptools	44.0.0
jQuery	1.11.3
jQuery UI	1.11.4
jQuery Timepicker	1.5.5

Enabled Plugins

AutoLink	0.1
BlackMagicTicketTweaks	0.12.2
EVR	N/A
NavAdd	0.4
SharedCookieAuth	0.1.6.dev0
trac-WorkflowNotificationPlugin	0.5
TracCustomFieldAdmin	0.2.13
TracDragDrop	0.12.0.13
TracDynamicFields	2.2.0.dev0
TracTicketFieldsLayoutPlugin	0.12.0.5
TracWysiwyg	0.12.0.7

Interface Customization

shared-htdocs
shared-templates
site-htdocs	common, css, js, m2020.png
site-templates	site.html

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/Trac-1.2-py2.7.egg/trac/web/main.py", line 613, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.7/site-packages/Trac-1.2-py2.7.egg/trac/web/main.py", line 253, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.7/site-packages/Trac-1.2-py2.7.egg/trac/ticket/web_ui.py", line 177, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.7/site-packages/Trac-1.2-py2.7.egg/trac/ticket/web_ui.py", line 665, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/usr/lib/python2.7/site-packages/Trac-1.2-py2.7.egg/trac/ticket/web_ui.py", line 1442, in _do_save
    replyto=req.args.get('replyto'))
  File "/usr/lib/python2.7/site-packages/Trac-1.2-py2.7.egg/trac/ticket/model.py", line 378, in save_changes
    % name, (db_values.get(name), self.id))
  File "/usr/lib/python2.7/site-packages/Trac-1.2-py2.7.egg/trac/db/util.py", line 128, in execute
    cursor.execute(query, params if params is not None else [])
  File "/usr/lib/python2.7/site-packages/Trac-1.2-py2.7.egg/trac/db/util.py", line 72, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1366, "Incorrect string value: '\\xE2\\x89\\xA5 10...' for column 'description' at row 1")

[Ryan J Ollos]

The greater than or equal \u2265 is \xE2\x89\xA5 in UTF-8 encoding. I suspect your database may not have the proper character set and/or collation type. See MySqlDb#MySQL and please check character_set_database and collation_database as described on that page.

[Jun Omae]

Closing since no feedback.