[Bug Report] Improve Initialization of filter rules in vttablet

[earayu]

Overview of the Issue

Background

Upon the initial startup of vttablet, the function reloadRulesFromDatabase in databaseCustomRule is not invoked. Consequently, if SQL queries are received at this point, they will be executed directly due to the absence of loaded filter rules. This situation can lead to potential errors as the filter rules are not yet in place to regulate SQL query execution.

Proposal

To prevent such errors, it is imperative to adjust the initialization process to load the filter rules before the queryEngine starts serving requests. By ensuring the filter rules are loaded beforehand, we can safeguard against unauthorized SQL query execution and maintain data integrity.

Reproduction Steps

1. create a filter
2. shutdown wescale (vtgate & vttablet)
3. start wescale again
4. execute any SQL that should trigger the filter created in step (1). You will see filter is not triggered because filter is not loaded in vttablet's memory.
5. wait for 30s
6. execute the same SQL again, the filter will be triggered.

Binary Version

all versions

Operating System and Environment details

all

Log Fragments