chaosblade-box icon indicating copy to clipboard operation
chaosblade-box copied to clipboard

bug quartz related sql table name shuld be t_chaos_m_quartz_[A-Z] not current t_chaos_m_quartz_[a-z]

Open Jovons opened this issue 2 years ago • 1 comments

in file chaosblade-box-ddl.sql, the following table name should be modified as:

rename table t_chaos_m_quartz_locks to t_chaos_m_quartz_LOCKS;
rename table t_chaos_m_quartz_blob_triggers to t_chaos_m_quartz_BLOB_TRIGGERS;
rename table t_chaos_m_quartz_calendars to t_chaos_m_quartz_CALENDARS;
rename table t_chaos_m_quartz_cron_triggers to t_chaos_m_quartz_CRON_TRIGGERS;
rename table t_chaos_m_quartz_fired_triggers to t_chaos_m_quartz_FIRED_TRIGGERS;
rename table t_chaos_m_quartz_job_details to t_chaos_m_quartz_JOB_DETAILS;
rename table t_chaos_m_quartz_job_info to t_chaos_m_quartz_JOB_INFO;
rename table t_chaos_m_quartz_paused_trigger_grps to t_chaos_m_quartz_PAUSED_TRIGGER_GRPS;
rename table t_chaos_m_quartz_scheduler_state to t_chaos_m_quartz_SCHEDULER_STATE;
rename table t_chaos_m_quartz_simple_triggers to t_chaos_m_quartz_SIMPLE_TRIGGERS;
rename table t_chaos_m_quartz_simprop_triggers to t_chaos_m_quartz_SIMPROP_TRIGGERS;
rename table t_chaos_m_quartz_trigger_log to t_chaos_m_quartz_TRIGGER_LOG;
rename table t_chaos_m_quartz_triggers to t_chaos_m_quartz_TRIGGERS;

otherwise, during runtime, it throws exception like t_chaos_m_quartz_TRIGGERS does not exist. The reason that causes this error is MySQL server has readonly variable lower_case_table_names 0, thereafter it treats table name case sensitive. and property org.quartz.jobStore.tablePrefix=t_chaos_m_quartz_ adds prefix to quartz table, but not affect the core table name to be in capital.

Jovons avatar Oct 19 '22 02:10 Jovons