thanks @fredrikekre for the solution via Slack
The problem is active project only exists in the second DEPOT_PATH, fix it by making a Project.toml at the correct version environment in the first DEPOT_PATH:
[jiling]~% julia --startup-file=no -e 'Base.active_project() |> println'
/cvmfs/sft.cern.ch/lcg/views/LCG_101/x86_64-centos7-gcc8-opt/share/julia/environments/v1.6/Project.toml
[jiling]~% mkdir -p /home/jiling/.julia/environments/v1.6/
[jiling]~% touch /home/jiling/.julia/environments/v1.6/Project.toml
[jiling]~% julia --startup-file=no -e 'Base.active_project() |> println'
/home/jiling/.julia/environments/v1.6/Project.toml