Doris 4.0.1 installation whoes

[infinity202]

Doris 4.0 installation is quite dramatic and following the written instructions leads to the first of many errors.

• ln -s <doris_meta_created> <doris_meta_original> unnecessary and wrong as the <doris_meta_original> is already available from the tar.gz. So you can't symlink it. For unknown reasons, the fe daemon will not start with doris_meta inside its own directory.
  meta_dir = /opt/meta-doris or similar should be set inside fe.conf.
• JAVA_OPTS="-Xmx16384m -XX:+UseMembar -XX:SurvivorRatio=8 -XX:MaxTenuringThreshold=7 -XX:+PrintGCDateStamps -XX:+PrintGCDetails -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled -XX:-CMSParallelRemarkEnabled -XX:CMSInitiatingOccupancyFraction=80 -XX:SoftRefLRUPolicyMSPerMB=0 -Xloggc:$DORIS_HOME/log/fe.gc.log.$DATE" fully outdated and leads to nowhere. Correct JAVA_OPTS are already in fe.conf . JAVA_OPTS is in reality neglected as you need JAVA_OPTS_FOR_JDK_17
• System MUST use JDK17 and no higher versions can be used. openJDK17 is hard or not to find to find/install in newer OS versions.
• Circumventing the version check in start_fe.sh and using OpenJDK 21 results in java errors
• fe daemon starts, but fails to create "stats database"
  (STATS_FETCH-0|194) [StatisticsUtil.statsTblAvailable():489] stat table does not exist, db_name: __internal_schema, table_name: column_statistics
• webserver is available, To access the FE node with a MySQL client (install separately, like mariadb-client) you must not use port 9010 but 9030 (the query port)

SQL query "problems"

• added a table with MySQL like instruction for a column with these specs: unitprice DOUBLE NOT NULL DEFAULT '0',. This column throws errors when you try to add a value of 0 (Zero) to the column.
• created a new database via the GUI, this table can be seen with the mysql client, but crashes HeidiSQL completly

[Nj-kol]

Adding to this woe is the inability to add Azure Vault

F20251118 10:19:04.645164 209 s3_util.cpp:255] BE is not compiled with azure support, export BUILD_AZURE=ON before building
I20251118 10:19:05.449136 209 daemon.cpp:231] sys physical memory 3.00 GB. process memory used 1.11 GB(= 1.11 GB[vm/rss] + 0[reserved] + 0B[waiting_refresh]), limit 2.70 GB, soft limit 2.43 GB. sys available memory 2.16 GB(= 2.16 GB[proc/available] - 0[reserved] - 0B[waiting_refresh]), low water mark 153.60 MB,