‘AIRFLOW’ COMMAND NOT FOUND AND SQLITE C LIBRARY TOO OLD ERROR (Alexis One-Click Anomaly Detection)

Problem statement: The ‘airflow’ command is not recognized. Getting sqlite c library too old error after running this command: airflow db init

Error:

  1. ./install.sh: line 19: airflow: command not found
  2. ./install.sh: line 17: airflow: command not found
  3. f"error: sqlite C library version too old (< {min_sqlite_version}). "

airflow.exceptions.AirflowConfigException: error: sqlite C library version too old (< 3.15.0). See https://airflow.apache.org/docs/apache-airflow/2.1.2/howto/set-up-database.rst#setting-up-a-sqlite-database

 

Solution:

  1. Steps to solve “airflow” command not found error
    1. Check if the airflow executable binary path is in environment variable $PATH. Use this command: echo $PATH
    2. If your airflow executable binary path which is “/usr/local/bin” does not exist in the “echo $PATH” output then add that path to the $PATH. Use this command: export PATH=$PATH:/usr/local/bin
    3. To check if the “airflow” command is working by using this command: airflow version
  2. Regarding the “error: sqlite C library version too old (< 3.15.0)”:
    1. Please follow the steps in Point number 3 in the “Airflow Installation and Configuration on Linux” section of ALEXIS Airflow Installation and configuration for the ALEXIS Customer guide.