Losing Playlists And Content In Playlists
  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    Good Evening:

    We've had list happen a couple times before and it just happened today wiping out a majority of our play lists

    Running 2.0.3 with the content stored on an NAS and the playlist content will just disappear

    The content is still on the NAS but not in the play lists

    The playlists that survived we created using content stored locally on an internal hard drive

    Is there any way to recover these lists?

    Help
    Post edited by Andrey Podshivalov at 2012-04-26 03:34:19
  • 17 Comments sorted by
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    try to restart media-monitor service: sudo service airtime-media-monitor restart
  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    I've tried that in the past and tried it again and all is still lost

    The playlists that referenced content stored on the NAS are empty

    The total files listed (total entries) at the bottom of the playlist creator is the same as it was before

    One thing I noted was a notification on the playlist creator page above the search box saying "importing"

    I've seen that in the past when the database is updating after we added files

    We did not add any files but there was an "import" going on and perhaps that's what borked the database
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    Hi Bob,

    Unfortunately this was bad design decision in Airtime 2.0, when the network goes down, we don't differentiate between files being offline temporarily, and files being deleted (both cases are treated as deleted and this affects your playlists). This issue is now handled gracefull in Airtime 2.1.
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    Excellent. I've installed beta 5 and have a quick question

    Can I initiate a media folder scan?

    I upgraded from beta 4 to beta 5 and restored the database (took a chance they were the same) and need to rescan the watched folders

    Thanks!
  • Vote Up0Vote Down James MoonJames Moon
    Posts: 197Member
    You can remove Watched folder and add it again. :)
  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    Hopefully this time that won't nuke any playlists ;)

    Tried it and it works... yea

    Beta 5 ROCKS by comparison !

    Thank you
  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    I'd like to begin and say thank you to the developers at sourcefabric

    They have been very helpful in trying to resolve the various issues with  Airtime

    Having said that, we are still having import problems running the dev version of Airtime

    From a fresh install we added a single watch folder associated with a NAS folder containing the source files

    The import began and all was working in terms of the import quantity increasing

    At some point the import process stopped and now we are back to the "processing" window error

    We can no longer view any of the imported files nor view an empty playlist we created

    Thanks


    screen_capture080.png
    858 x 366 - 17K
  • Vote Up0Vote Down James MoonJames Moon
    Posts: 197Member
    Hi Bob,

    Do you see any errors in apache2 log? or anything?
    Thank you!
  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    Looks like the same error about every second in the log file

    [Tue May 01 00:54:28 2012] [error] [client 127.0.0.1] PHP Fatal error:  Call to a member function getId() on a non-object in /usr/share/airtime/application/controllers/ApiController.php on line 663

    Also these

    [Tue May 01 06:59:19 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/controllers/LibraryController.php on line 157, referer: http://localhost/Playlist
    [Tue May 01 06:59:36 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: totalDisplayRows in /usr/share/airtime/application/models/Datatables.php on line 99, referer: http://localhost/Playlist
    [Tue May 01 06:59:36 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: totalRows in /usr/share/airtime/application/models/Datatables.php on line 100, referer: http://localhost/Playlist
    [Tue May 01 06:59:36 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: results in /usr/share/airtime/application/models/Datatables.php on line 102, referer: http://localhost/Playlist
    [Tue May 01 06:59:36 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/models/StoredFile.php on line 662, referer: http://localhost/Playlist
    [Tue May 01 06:59:36 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/controllers/LibraryController.php on line 157, referer: http://localhost/Playlist
    [Tue May 01 06:59:52 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: results in /usr/share/airtime/application/models/Datatables.php on line 102, referer: http://localhost/Playlist
    [Tue May 01 06:59:52 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/models/StoredFile.php on line 662, referer: http://localhost/Playlist
    [Tue May 01 06:59:52 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/controllers/LibraryController.php on line 157, referer: http://localhost/Playlist
    [Tue May 01 07:00:05 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: results in /usr/share/airtime/application/models/Datatables.php on line 102, referer: http://localhost/Playlist
    [Tue May 01 07:00:05 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/models/StoredFile.php on line 662, referer: http://localhost/Playlist
    [Tue May 01 07:00:05 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/controllers/LibraryController.php on line 157, referer: http://localhost/Playlist
    [Tue May 01 07:00:29 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: totalDisplayRows in /usr/share/airtime/application/models/Datatables.php on line 99, referer: http://localhost/Playlist
    [Tue May 01 07:00:29 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: totalRows in /usr/share/airtime/application/models/Datatables.php on line 100, referer: http://localhost/Playlist
    [Tue May 01 07:00:29 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: results in /usr/share/airtime/application/models/Datatables.php on line 102, referer: http://localhost/Playlist
    [Tue May 01 07:00:29 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/models/StoredFile.php on line 662, referer: http://localhost/Playlist
    [Tue May 01 07:00:29 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() in /usr/share/airtime/application/controllers/LibraryController.php on line 157, referer: http://localhost/Playlist
    [Tue May 01 07:01:57 2012] [notice] caught SIGTERM, shutting down
    [Tue May 01 07:03:48 2012] [notice] Apache/2.2.17 (Ubuntu) PHP/5.3.5-1ubuntu7.7 with Suhosin-Patch configured -- resuming normal operations

    I did a reboot of the computer, mounted the NAS and did a restart of the media manager and now the files are there

  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    Just did a refresh of the browser and the import process has begun again and the files do not display

    Did another refresh and the import process has stopped and back to the "processing" screen

    Here are the subsequent logs

    [Tue May 01 07:01:57 2012] [notice] caught SIGTERM, shutting down
    [Tue May 01 07:03:48 2012] [notice] Apache/2.2.17 (Ubuntu) PHP/5.3.5-1ubuntu7.7 with Suhosin-Patch configured$
    [Tue May 01 07:17:58 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: totalDisplayRows in /u$
    [Tue May 01 07:17:58 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: totalRows in /usr/shar$
    [Tue May 01 07:17:58 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: results in /usr/share/$
    [Tue May 01 07:17:58 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() i$
    [Tue May 01 07:17:58 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() i$
    [Tue May 01 07:20:13 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: totalDisplayRows in /u$
    [Tue May 01 07:20:13 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: totalRows in /usr/shar$
    [Tue May 01 07:20:13 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined variable: results in /usr/share/$
    [Tue May 01 07:20:13 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() i$
    [Tue May 01 07:20:13 2012] [error] [client 127.0.0.1] PHP Warning:  Invalid argument supplied for foreach() i$



  • Vote Up0Vote Down James MoonJames Moon
    Posts: 197Member
    Hi Bob,

    Can you please post /var/log/airtime/media-monitor/media-monitor.log?
    Thank you.
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    This is a pretty serious issue. Will try to find cause + fix this week. Please provide us all the logs under /var/log/airtime in a tar ball.


    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    Here's a repeated process

    2012-05-01 07:46:26,412 WARNING - [Thread #2] [workerprocess.py : process_file_events()] : LINE 19 - Liquidsoap integrity check for file at /mp3/Folder 100/02-22-03 training$
    2012-05-01 07:46:26,904 INFO - [Thread #3] [airtimenotifier.py : update_airtime()] : LINE 139 - updating filepath: /mp3/6-File Name - 0000 1001.mp3
    2012-05-01 07:46:26,906 INFO - [Thread #3] [airtimemetadata.py : get_md_from_file()] : LINE 120 - getting info from filepath /mp3/6-File Name - 0000 1001.mp3
    2012-05-01 07:46:26,951 INFO - [MainThread] [airtimeprocessevent.py : process_IN_CLOSE_WRITE()] : LINE 117 - event: <Event dir=False mask=0x8 maskname=IN_CLOSE_WRITE name=6-File Name - 0000$
    2012-05-01 07:46:26,953 INFO - [MainThread] [airtimeprocessevent.py : process_IN_CLOSE_WRITE()] : LINE 118 - create_dict: {}

  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    We are back to beta 5 instead of dev
    When will the issues with beta 5 be addressed?
    Will the database be the same?

    That would be nice so we don't lose playlists etc...
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    This issue is now resolved in the latest devel branch. It will be included in beta6.
    Airtime Pro Hosting: http://airtime.pro
  • Vote Up0Vote Down Bob ZurunclεBob Zurunclε
    Posts: 113Member
    We are using it (Dev)  and seems to work fairly well

    Thanks!
  • Vote Up0Vote Down Martin KonecnyMartin Konecny
    Posts: 1,860Member
    @Bob, we will have an RC this week, and that will be the last time you need to reinstall the database. Usually you want the database changes to be finished much earlier, however these changes are unrelated to the core functionality of Airtime and instead are for storing data of users who opt-in to sending statistics about how they use Airtime :) 
    Airtime Pro Hosting: http://airtime.pro
Add a Comment