11-14-2017 04:21 AM
mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper
We are getting a lot of error message in the /var/log/cloudera-scm-navigator/mgmt-cmf-mgmt-NAVIGATOR-node03.domain.log.out:
Caused by: java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBD\xC3\xB3r...' for column 'OPERATION_TEXT' at row 1
... 36 more
This column seems to be the navigator.hive_audit_events.operation_text (or the corresponding partition).
Does anyone have a clue how I can resolve this? I've tried changing the column's character set to 'utf8' but no joy. I'd be OK if I could just flush out the un-processed events. My guess is that there's some strange character in the SQL from Hive and the Audit server is failing to log it in this table.
11-14-2017 08:06 AM
1. Login to MySQL as root
2. Show databases
3. Use navigator
4. select operation_text from hive_audit_events , to see anything strange in this column and for how many rows...
Some customers will use their Navigator data for audit but some just keep this service but do not use this data... if you are NOT using this data for audit 'and' the impact is for very few rows then take a backup and try to manage the impacted data
11-14-2017 08:58 AM
sorry, I should have mentioned: the table is empty. But there are loads and loads of hive_audit_events_YYYY_MM_DD tables, e.g. hive_audit_events_2017_11_14 - which is also empty.
The process that loads the data in to the table seems to be failing with that error message.
Hive is also in status: BAD as the audit_pipeline_test fails. I don't know how to see exactly what that test does, but I suspect it's related to this error as well.
I'm thinking either there's a) some funky data that the navigator is trying to insert or b) there's something wrong with the table itself or c) the jdbc/java code doing the insert is 'buggy' ?