Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error persisting events for service hive

Error persisting events for service hive

New Contributor



Cloudera 5.12.1

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
        at com.mysql.jdbc.SQLError.createSQLException(
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(
        at com.mysql.jdbc.MysqlIO.sendCommand(
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
        at com.mysql.jdbc.ConnectionImpl.execSQL(
        at com.mysql.jdbc.PreparedStatement.executeInternal(
        at com.mysql.jdbc.PreparedStatement.executeUpdate(
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(
        ... 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.


Re: Error persisting events for service hive




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

Re: Error persisting events for service hive

New Contributor

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' ?



Re: Error persisting events for service hive


echo "use navigator;" >> alter_audit_tables.sql
mysql -h [hostname] -u root -p -e "use navigator;SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('OPERATION_TEXT') AND TABLE_SCHEMA='navigator';" | grep 'AUDIT_EVENTS' | awk '{print "ALTER TABLE " $1 " modify column OPERATION_TEXT longtext CHARACTER SET utf8;"}' >> alter_audit_tables.sql
cat alter_audit_tables.sql | mysql -h [hostname] -u root -p
echo "commit;" >> alter_audit_tables.sql

This fixed the issue for me and subsequently got rid of the Audit Pipeline test failures