Vallishp opened a new pull request, #39509:
URL: https://github.com/apache/doris/pull/39509
## Proposed changes
Issue Number: close #39457
If database is delete then FE should check and return OK with empty set
to BE, so that BE can continue the scan other database id
Unit testing:
stubbed BE to add a invalid database id in the begin of the dbresult.dbids
and reproduced this issue.
mysql> select * from information_schema.table_options;
ERROR 1105 (HY000): errCode = 2, detailMessage =
(127.0.0.1)[INTERNAL_ERROR]TStatus: Cannot invoke
"org.apache.doris.catalog.DatabaseIf.getTables()" because "database" is null
mysql> select * from information_schema.table_properties;
ERROR 1105 (HY000): errCode = 2, detailMessage =
(127.0.0.1)[INTERNAL_ERROR]TStatus: Cannot invoke
"org.apache.doris.catalog.DatabaseIf.getTables()" because "database" is null
mysql>
After fix in FE both table query success with invalid dbid from BE.
*************************** 776. row ***************************
TABLE_CATALOG: internal
TABLE_SCHEMA: regression_test_tpch_unique_sql_zstd_bucket1_p0
TABLE_NAME: partsupp
TABLE_MODEL: UNI
TABLE_MODEL_KEY: PS_PARTKEY,PS_SUPPKEY
DISTRIBUTE_KEY: PS_PARTKEY
DISTRIBUTE_TYPE: HASH
BUCKETS_NUM: 1
PARTITION_NUM: 1
776 rows in set (0.11 sec)
mysql>
Both table can query even if in the begining there is a invalid dbid in BE
list.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
