[EAGLE-301] Tables omitted for using mysql

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v0.3.1
• Fix Version/s: v0.4.0
• Assignee: Michael Wu
• Reporter: Michael Wu
• Created: 17/May/16 06:06
• Updated: 15/Jun/16 15:26
• Resolved: 07/Jun/16 07:35

Description

To reproduce the issue:
1. install eagle (based on dev branch) to sandbox and ssh into sandbox, making sure eagle's required components are started up.

2. execute command to enter mysql console: mysql -r root -p (default passcode of ambari's mysql is blank).

3. create mysql user "eagle", setting a preferred passcode, and granting all privileges to the user.

4. relogin mysql as user "eagle", and create database "eagle".

5. modify eagle/conf/eagle-service.conf according to https://github.com/apache/incubator-eagle/blob/dev/eagle-webservice/src/main/resources/application-mysql.conf

6. execute eagle/bin/eagle-service.sh start

7. by either monitoring eagle/logs/eagle-service.out or query tables in mysql, we can find that 12 tables are omitted as below:
Omitted tables are:
alertstreamschema_alertstreamschema
alertdetail_hadoop
alertdef_alertdef
eagle_metadata_topologyoperation
alertstream_alertstream
unittest_testtsentity
alertexecutor_alertexecutor
aggregatedef_aggregatedef
eagle_metadata_topologyexecution
mlmodel_mlmodel
serviceaudit_serviceaudit
eagle_metric

Issue Links

• links to: GitHub Pull Request #221