Add log for loaded local metadata in dnservice

Approved by: @lni

Approved by: @daviszhen, @aressu1985, @ouyuanning

- Add log for `pkg/hakeeper/checkers/dnservice`

Approved by: @lni

Add more log for schedule command

Approved by: @reusee

fileservice: add GetForETL

Approved by: @nnsgmsone

Use Active status in rollback response, and txn client panic after check the txn status in response

Approved by: @lni, @reusee

frontend: remove InitDB

txnstorage: use tae catalog definitions

Approved by: @daviszhen, @lni, @zhangxu19830126

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

* bugfix: trace collection may Hang(actually deadlock), while buffer.Lock wait buffer.RLook

* fix review: rename dummy struct for test

* fix review: rename struct with dummy key word which define in **_test.go

* fix review: simply Lock() instead of RLock()

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>

add Auto increment column in mo DB

Approved by: @XuPeng-SH, @daviszhen, @ouyuanning, @aunjgr, @nnsgmsone, @fengttt, @aressu1985, @reusee, @iamlinjunhong

Approved by: @ouyuanning, @aressu1985

Replace dlnode to support generic UpdateNode.
1. Replace common.SortedDList with *common.GenericSortedDList
2. Update catalog, db and tables to adapt to new dlnode

Approved by: @XuPeng-SH

mo-service: unify file service initialization in cnservice, dnservice, logservice

Approved by: @zhangxu19830126, @nnsgmsone, @lni

The DDL statement supports the partition by clause. The partition types include:
RANGE Partitioning,
LIST Partitioning,
COLUMNS Partitioning,
RANGE COLUMNS partitioning,
LIST COLUMNS partitioning,
HASH Partitioning,
KEY Partitioning,

The construction of the partition sentence and the semantic check coding have been completed, but the partition information of DDL is not synchronized to the metadata table. Subsequently, the metadata table related to the partition will be added and the partition information will be displayed when show create table is supported, Issue#4749

Approved by: @daviszhen, @zhangxu19830126, @fengttt, @aunjgr, @iamlinjunhong, @ouyuanning, @aressu1985, @nnsgmsone

When drop tbl/db entry, it wait related txn to commit twice. This pr remove the second one.

Approved by: @XuPeng-SH

The current protocol and mysql access code, designed to be confusing, will lead to multiple calls to Quit, here the use of sync.Once also just to solve the problem of multiple closures, the code needs to be refactored

Approved by: @sukki37, @daviszhen

* fix bug. Wrong judgment of statement type

* add bvt

Co-authored-by: bRong Njam <longran1989@gmail.com>
Co-authored-by: fengttt <fengttt@gmail.com>

sql: refactor external table with Process.FileService

init file service on CN and pass to frontend

Co-authored-by: fengttt <fengttt@gmail.com>

* fix some bvt bugs and modify error msg

* log func base 1 should be error

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>

Revise the check failure bug when the mo boots with previous databases and tables.

Approved by: @yingfeng

1. add serialization methods for struct Compile.Scope for pipeline's remote run.
2. add cn-client and cn-service related methods.

Approved by: @daviszhen, @reusee, @zhangxu19830126, @nnsgmsone

Approved by: @reusee

mo-service: refactor file service initialization

Approved by: @zhangxu19830126

1.  Enable multi tenant in default

- add create account statement.
- add create user statement.
- add create role statement.
- with two internal users -- root and dump (both password 111) in sys tenant.
- login format: the '-u' option of mysql client has been extended to "tenant:user:role" or "tenant:user"(public role) or "user"(sys tenant, public role)

2. Already known restrictions in this initial version:

- no privilege check
- no drop/alter statement
- no view
- only tenant isolation
- user can see the whole catalog of the tenant that it is belonged to.
- remove the .store directory when mo boots with multi-tenant verison at first time. Just only once.

3. Remove db-server

Approved by: @reusee, @iamlinjunhong, @aressu1985

fileservice: add Path, ParsePath, ParsePathAtService

Approved by: @zhangxu19830126

In some cases, TxnRequest is supported to retry on the DN to resolve DNShardNotFound errors due to inconsistent message propagation

Approved by: @reusee

Co-authored-by: fengttt <fengttt@gmail.com>

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

* Adapt to the new Load Plan

* change word 'colnum' to 'column'

* Add bvt test

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

* use logutil.Info/Infof replace fmt.Printf/Println

* fix compile

* fix static-check

* fix merge

* revert version output

* revert version missing part

* revert tool goyacc modification

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

Approved by: @aunjgr, @aressu1985, @ouyuanning

Approved by: @XuPeng-SH

vm/engine: add Engine.Hints

Approved by: @nnsgmsone, @XuPeng-SH, @daviszhen

fileservice: make service name case-insensitive

Approved by: @zhangxu19830126

txnengine: add ErrReadOnly

txnstorage: add CatalogHandler; refactor TestMVCC

Approved by: @zhangxu19830126, @lni

    mo-service, cnservice, etc: codes for starting standalone mem engine and distributed TAE (#4700)

mo-service, cnservice, etc: codes for starting standalone mem engine and distributed TAE

Approved by: @zhangxu19830126, @lni, @nnsgmsone

1、fix bug:show create table xx when xx is a view
2、refactor:  move show create table/database from frontend to plan

Approved by: @aunjgr, @XuPeng-SH, @daviszhen, @aressu1985

Approved by: @yingfeng