kae/musicmuster
1
0
Fork 0
Code Issues 28 Pull Requests Projects Releases 1 Activity

Deleted tracks not handled well in cron job #114

New Issue
Closed
opened 2022-04-25 07:59:25 +01:00 by kae · 0 comments
kae commented 2022-04-25 07:59:25 +01:00
Owner
Copy Link
[03:03:02] D: Using musicmuster_prod database
[03:03:02] D: Updating database
[03:03:02] D: Session acquired, file='/home/kae/mm/app/musicmuster.py', function='<module>', lineno=1093, Session=<sqlalchemy.orm.scoping.scoped_session object at 0x7fe8c772bb50>
[03:03:05] D: Invalid path='/home/kae/music/Singles/Man of Mystery - signoff.mp3' in database
[03:03:05] D: Tracks.get_track_from_path(path='/home/kae/music/Singles/Man of Mystery - signoff.mp3')
[03:03:05] D: Tracks.remove_path(path='/home/kae/music/Singles/Man of Mystery - signoff.mp3')
[03:03:05] E: Can't remove track with path='/home/kae/music/Singles/Man of Mystery - signoff.mp3' (exception=IntegrityError("(MySQLdb._exceptions.IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`musicmuster_prod`.`playlisttracks`, CONSTRAINT `playlisttracks_ibfk_2` FOREIGN KEY (`track_id`) REFERENCES `tracks` (`id`))')"))
[03:03:05] D:  Session released
Messages
Remove from database: path='/home/kae/music/Singles/Man of Mystery - signoff.mp3' track=<Track(id=6242, title=Man of Mystery - signoff, artist=The Shadows, path=/home/kae/music/Singles/Man of Mystery - signoff.mp3>
``` [03:03:02] D: Using musicmuster_prod database [03:03:02] D: Updating database [03:03:02] D: Session acquired, file='/home/kae/mm/app/musicmuster.py', function='<module>', lineno=1093, Session=<sqlalchemy.orm.scoping.scoped_session object at 0x7fe8c772bb50> [03:03:05] D: Invalid path='/home/kae/music/Singles/Man of Mystery - signoff.mp3' in database [03:03:05] D: Tracks.get_track_from_path(path='/home/kae/music/Singles/Man of Mystery - signoff.mp3') [03:03:05] D: Tracks.remove_path(path='/home/kae/music/Singles/Man of Mystery - signoff.mp3') [03:03:05] E: Can't remove track with path='/home/kae/music/Singles/Man of Mystery - signoff.mp3' (exception=IntegrityError("(MySQLdb._exceptions.IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`musicmuster_prod`.`playlisttracks`, CONSTRAINT `playlisttracks_ibfk_2` FOREIGN KEY (`track_id`) REFERENCES `tracks` (`id`))')")) [03:03:05] D: Session released Messages Remove from database: path='/home/kae/music/Singles/Man of Mystery - signoff.mp3' track=<Track(id=6242, title=Man of Mystery - signoff, artist=The Shadows, path=/home/kae/music/Singles/Man of Mystery - signoff.mp3> ```
kae added the
bug
 label 2022-04-25 07:59:42 +01:00
kae referenced this issue from a commit 2022-06-05 15:19:35 +01:00
Fix cron job
kae closed this issue 2022-06-05 15:19:35 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
bug

Something is not working

  
duplicate

This issue or pull request already exists

  
enhancement

New feature

  
help wanted

Need some help

  
invalid

Something is wrong

  
Priority

Work on soon

  
question

More information is needed

  
V5

   
wontfix

This won't be fixed

No Label
bug
duplicate
enhancement
help wanted
invalid
Priority
question
V5
wontfix
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: kae/musicmuster#114
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?