Support Questions
Find answers, ask questions, and share your expertise

oozie Mysql error / HortonWorks 2.5,oozie mysql error / HortonWorks 2.5

New Contributor

17:01:18,205 ERROR SchemaCheckXCommand:517 - SERVER[bas-namenode-vm.isdomain.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Found [1] extra indexes for columns in table [WF_ACTIONS]: [wf_id] 2016-09-19 17:01:18,230 ERROR SchemaCheckXCommand:517 - SERVER[bas-namenode-vm.isdomain.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Database schema is BAD! Check previous error log messages for details

,

7:01:18,205 ERROR SchemaCheckXCommand:517 - SERVER[bas-namenode-vm.isdomain.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Found [1] extra indexes for columns in table [WF_ACTIONS]: [wf_id] 2016-09-19 17:01:18,230 ERROR SchemaCheckXCommand:517 - SERVER[bas-namenode-vm.isdomain.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] Database schema is BAD! Check previous error log messages for details

1 REPLY 1

Re: oozie Mysql error / HortonWorks 2.5,oozie mysql error / HortonWorks 2.5

Explorer

You can ignore this error. It will not have any functionality impact for the application. Currently Oozie ignores the 'wf_id' while comparing the index columns. Further If you want to ignore the extra (unused) tables, columns and indexes to be incorrect, set below in the oozie-site.xml.

oozie.service.SchemaCheckerService.ignore.extras=false