[Bug] test suite test_table_options may cause NPE in FE

[wangbo]

Search before asking

• I had searched in the issues and found no similar issues.

Version

master

Problem

Exception in query_p0/system/test_table_options.groovy(line 184):

            "store_row_column" = "true",
            "row_store_page_size" = "8190"
        );
    """

    qt_select_check_1 """select * from information_schema.table_options where table_schema=\"${dbName}\" order by TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,TABLE_MODEL,TABLE_MODEL_KEY,DISTRIBUTE_KEY,DISTRIBUTE_TYPE,BUCKETS_NUM,PARTITION_NUM; """
    sql """
        drop table test_row_column_page_size2;
    """    
    qt_select_check_2 """select * from information_schema.table_options where table_schema=\"${dbName}\" order by TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,TABLE_MODEL,TABLE_MODEL_KEY,DISTRIBUTE_KEY,DISTRIBUTE_TYPE,BUCKETS_NUM,PARTITION_NUM; """
^^^^^^^^^^^^^^^^^^^^^^^^^^ERROR LINE^^^^^^^^^^^^^^^^^^^^^^^^^^

    def user = "table_options_user"
    sql "DROP USER IF EXISTS ${user}"
    sql "CREATE USER ${user} IDENTIFIED BY '123abc!@#'"
    //cloud-mode
    if (isCloudMode()) {
        def clusters = sql " SHOW CLUSTERS; "
        assertTrue(!clusters.isEmpty())
        def validCluster = clusters[0][0]
        sql """GRANT USAGE_PRIV ON CLUSTER ${validCluster} TO ${user}""";

Exception:
java.sql.SQLException: errCode = 2, detailMessage = (172.16.0.77)[INTERNAL_ERROR]TStatus: Cannot invoke "org.apache.doris.catalog.DatabaseIf.getTables()" because "database" is null
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
  at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321)
  at org.apache.doris.regression.util.JdbcUtils$_executeToStringList_closure3.doCall(JdbcUtils.groovy:95)
  at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:343)
  at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:328)
  at org.codehau

Test test_table_options.groovy failed because of NPE in FE.
catalog.getDbNullable(dbId); may return null when DB is dropped
SchemaTablePropertiesScanner first fetch all DB in BE, then get data from FE by DB one by one, when DB is droppped, then NPE happens, so FE should deal the case that a DB name exits in BE but it's dropped already in FE.

regression test link:
http://43.132.222.7:8111/buildConfiguration/Doris_DorisRegression_P0Regression/506268?expandBuildDeploymentsSection=false&hideTestsFromDependencies=false&hideProblemsFromDependencies=false&expandPull+Request+Details=true&expandBuildTestsSection=true&expandBuildChangesSection=true

Code of Conduct

• I agree to follow this project's Code of Conduct

[Vallishp]

I will check it