fix(meta): address bugs for mysql backend & enable e2e tests

fix(meta): address bugs for mysql backend & enable e2e tests #43273