Unable to restart after crash
  • Hello

    The Server which hosts my virtual appliances has crashed. 
    After restarting it, I'm unable to restart Airtime.
    It sounds it's a PostgreSQL level there is an issue.

    ┌─( root@dover ) - ( 2.6.32-26-pve ) - ( ~ )
    └─> airtime-check-system
    AIRTIME_STATUS_URL = http://dover.cqfd.net:80/api/status/format/json/api_key/%%api_key%%
    AIRTIME_SERVER_RESPONDING = OK
    KERNEL_VERSION = UNKNOWN
    MACHINE_ARCHITECTURE = UNKNOWN
    TOTAL_MEMORY_MBYTES = UNKNOWN
    TOTAL_SWAP_MBYTES = UNKNOWN
    AIRTIME_VERSION = UNKNOWN
    OS = Ubuntu 13.10 x86_64
    CPU = Intel(R) Core(TM) i3-2130 CPU @ 3.40GHz
    WEB_SERVER = Apache/2.4.6 (Ubuntu) PHP/5.5.3-1ubuntu2.3
    PLAYOUT_ENGINE_PROCESS_ID = FAILED
    PLAYOUT_ENGINE_RUNNING_SECONDS = 0
    PLAYOUT_ENGINE_MEM_PERC = 0%
    PLAYOUT_ENGINE_CPU_PERC = 0%
    -- Displaying log file /var/log/airtime/pypo/pypo.log
    -- 2014-05-01 06:15:42,386 INFO - [api_client.py : is_server_compatible() : line 220] - Unable to get Airtime version number.
    --
    -- 2014-05-01 06:15:47,390 DEBUG - [api_client.py : __call__() : line 134] - http://dover.cqfd.net:80/api/version/api_key/5UYGSK6HC76CCOZCFFDT
    -- 2014-05-01 06:15:47,393 INFO - [api_client.py : is_server_compatible() : line 220] - Unable to get Airtime version number.
    --
    --
    --
    LIQUIDSOAP_PROCESS_ID = FAILED
    LIQUIDSOAP_RUNNING_SECONDS = 0
    LIQUIDSOAP_MEM_PERC = 0%
    LIQUIDSOAP_CPU_PERC = 0%
    tail: cannot open ‘/var/log/airtime/pypo-liquidsoap/ls_script.log’ for reading: No such file or directory
    -- Displaying log file /var/log/airtime/pypo-liquidsoap/ls_script.log
    --
    --
    MEDIA_MONITOR_PROCESS_ID = FAILED
    MEDIA_MONITOR_RUNNING_SECONDS = 0
    MEDIA_MONITOR_MEM_PERC = 0%
    MEDIA_MONITOR_CPU_PERC = 0%
    -- Displaying log file /var/log/airtime/media-monitor/media-monitor.log
    -- 2014-05-01 06:15:29,273 INFO - [Thread-1] [watchersyncer.py : __init__()] : LINE 19 - Created timeout thread...
    -- 2014-05-01 06:15:29,273 INFO - [Thread-1] [airtime.py : init_rabbit_mq()] : LINE 36 - Initializing RabbitMQ message consumer...
    -- 2014-05-01 06:15:29,277 INFO - [Thread-1] [airtime.py : init_rabbit_mq()] : LINE 48 - Initialized RabbitMQ consumer.
    -- 2014-05-01 06:15:29,277 DEBUG - [Thread-1] [api_client.py : __call__()] : LINE 134 - http://dover.cqfd.net:80/api/media-monitor-setup/format/json/api_key/5UYGSK6HC76CCOZCFFDT
    -- 2014-05-01 06:15:29,281 INFO - [Thread-1] [syncdb.py : reload_directories()] : LINE 49 - HTTP Error 503: Service Unavailable
    --
    --
    -- There appears to be a problem with your Airtime installation.
    -- Please visit http://wiki.sourcefabric.org/x/HABQ


    In the log, the only relevant thing I found is 

    in /var/log/airtime/zendphp.log
    2014-05-01T03:41:58-04:00 INFO (6): [Preference.php : getValue() : line 183] - Could not connect to database: Unable to open PDO connection [wrapped: SQLSTATE[08006] [7] could not connect to server: Connection refused
            Is the server running on host "localhost" (::1) and accepting
            TCP/IP connections on port 5432?


    and when trying to start postgresql service I have

     service postgresql start
     * No PostgreSQL clusters exist; see "man pg_createcluster"

    Please help me...
  • 5 Comments sorted by
  • Vote Up0Vote Down Cliff WangCliff Wang
    Posts: 339Member, Sourcefabric Team
    Check if posgresql's running. Then check if db airtime is mount.
    Cloud Radio -> http://airtime.pro
  • Hello

    It is not running. 
    And when I start it, I have the error I wrote

    service postgresql start
     * No PostgreSQL clusters exist; see "man pg_createcluster"
    Post edited by Paulin Halenria at 2014-05-01 14:45:42
  • Vote Up0Vote Down Cliff WangCliff Wang
    Posts: 339Member, Sourcefabric Team
    Seems like your database was destroyed by something, better try to re-install airtime.
    Cloud Radio -> http://airtime.pro
  • As airtime is installed using apt-get package, how to reinstall it without losing my library of mp3 ?

    apt-get remove airtime && apt-get install airtime ? 

    Or any other way ?
  • Vote Up0Vote Down Cliff WangCliff Wang
    Posts: 339Member, Sourcefabric Team
    Backup /srv/airtime/stor/, then you can purge all stuff (Airtime, postgresql). Your tracks should be under /srv/airtime/stor/imported/. To resume them just copy all tracks to /srv/airtime/stor/organize, media-monitor will re-imported them.
    Cloud Radio -> http://airtime.pro