automatic-ripping-machine icon indicating copy to clipboard operation
automatic-ripping-machine copied to clipboard

πŸ› Failed to update database with associated drive

Open neolith100 opened this issue 2 years ago β€’ 28 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

I have checked the wiki

  • [X] I have searched the wiki for this problem

Does this issue exist in the latest version?

  • [X] I'm using the latest release

Describe the bug?

Inserted two DVDs at the same time and one began correctly the other failed with the error, "Failed to update the database with the associated drive" log file copy pasta'ed. This will hang the drive and is no longer able to rip.

To Reproduce

  1. Insert two DVDs at the same time
  2. First will begin ripping
  3. Second disc will fail/hang
  4. Attempting to "Abandon Job" will fail
  5. Navigate to "Database"
  6. Select "Delete Job"
  7. proceed with ripping/attempt ripping same DVD

What OS are you seeing the problem on?

Other (please state in Anything else? section)

ARM Release Version or Git hash (You can find this in the arm settings page)

From "Arm Settings", "General Info" Python version: 3.8.10 A.R.M version: 2.6.40 Current git version: 06e4fb1790c8fd698e2257a87b18668d4d7616c6

Expected behavior?

Both should start ripping at the same time.

Relevant log output

[07-05-2023 23:16:29] DEBUG ARM: utils.check_db_version Head is: 2e0dc31fcb2e
[07-05-2023 23:16:29] DEBUG ARM: utils.check_db_version Database version is: 2e0dc31fcb2e
[07-05-2023 23:16:29] INFO ARM: utils.check_db_version Database is up to date
[07-05-2023 23:16:30] DEBUG ARM: utils.database_adder Trying to add User
[07-05-2023 23:16:30] DEBUG ARM: utils.database_adder successfully written User to the database
[07-05-2023 23:16:30] INFO ARM: main.<module> ************* Starting ARM processing at 2023-07-05 23:16:30.123783 *************
[07-05-2023 23:16:30] DEBUG ARM: utils.database_adder Trying to add Job
[07-05-2023 23:16:30] DEBUG ARM: utils.database_adder successfully written Job to the database
[07-05-2023 23:16:31] DEBUG ARM: DriveUtils.update_drive_job Updating drive [/dev/sr0] current job, with id [27]
[07-05-2023 23:16:36] ERROR ARM: DriveUtils.update_drive_job Failed to update the database with the associated drive. (sqlite3.OperationalError) database is locked
[SQL: UPDATE system_drives SET job_id_current=? WHERE system_drives.drive_id = ?]
[parameters: (27, 1)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

Anything else?

Using the docker container version of ARM

Code of Conduct

  • [X] I agree to follow this project's Code of Conduct

neolith100 avatar Jul 05 '23 23:07 neolith100

If youre having issues, please remember to read the wiki and follow the instructions carefully

github-actions[bot] avatar Jul 05 '23 23:07 github-actions[bot]

This issue is the same as #500, seems to have come up again

microtechno9000 avatar Jul 06 '23 22:07 microtechno9000

Looks like this is causing this issue

https://github.com/automatic-ripping-machine/automatic-ripping-machine/blob/09443809d329deda0265f86df725cbe954714b68/arm/ui/settings/DriveUtils.py#L154

Anywhere there is a hard commit without checking/timing, it will cause issues.

1337-server avatar Jul 09 '23 04:07 1337-server

Would someone be able to test this > https://github.com/automatic-ripping-machine/automatic-ripping-machine/commit/9e26ed88b08823e169e7e8052499e971e80e73f3 < commit ? And see if this resolves the issue ?

Thanks

1337-server avatar Jul 15 '23 00:07 1337-server

I'm running the unraid version and would love to test it because it happens multiple times per day. I just started using this software and I love it but this makes me want to stop using it. Do I just run an update like normal in Unraid / Docker?

dbooher2011 avatar Jul 15 '23 03:07 dbooher2011

This would have to be done with a test image, the tag you would need for the test image would be this

automaticrippingmachine/automatic-ripping-machine:fix-for-500-and-880

instead of

automaticrippingmachine/automatic-ripping-machine:latest

1337-server avatar Jul 15 '23 03:07 1337-server

Thank you so much. It's pulling now and I have some movies to go through. If I get it quickly, I'll let you know but I do want to go through a couple of tv shows before giving my feedback.

dbooher2011 avatar Jul 15 '23 03:07 dbooher2011

No change, I updated and swapped 3 disc at the same time and only 1 survived the db without getting the lock error. Any way to restart a job without having to go down to my server and ejecting?

dbooher2011 avatar Jul 15 '23 04:07 dbooher2011

Can you share the logs ?

You should be able to eject/insert via the settings page

1337-server avatar Jul 15 '23 04:07 1337-server

Here is one. Would you like both? Also, the eject does not work, I'm not sure if it's because of it running it docker, my drives or what but they do not open and close.

`[07-15-2023 04:00:00] INFO ARM: ARM version: fix-for-500-and-880 [07-15-2023 04:00:00] INFO ARM: Python version: 3.8.10 (default, May 26 2023, 14:05:08) [GCC 9.4.0] [07-15-2023 04:00:00] INFO ARM: User is: arm [07-15-2023 04:00:00] INFO ARM: Alembic head is: 2e0dc31fcb2e [07-15-2023 04:00:00] INFO ARM: Database version is: 2e0dc31fcb2e [07-15-2023 04:00:00] INFO ARM: ************* Starting ARM processing at 2023-07-15 04:00:00.713486 ************* [07-15-2023 04:00:04] INFO ARM: Looking for log files older than 1 days old. [07-15-2023 04:00:04] INFO ARM: Checking path /home/arm/logs/ for old log files... [07-15-2023 04:00:04] INFO ARM: Checking path /home/arm/logs/progress for old log files... [07-15-2023 04:00:04] INFO ARM: Job: PARKS_AND_RECREATION [07-15-2023 04:00:04] INFO ARM: Job #1 with PID 338 is currently running. [07-15-2023 04:00:04] INFO ARM: Starting Disc identification [07-15-2023 04:00:04] INFO ARM: Mounting disc to: /mnt/dev/sr1 [07-15-2023 04:00:04] INFO ARM: Mounting disc was successful [07-15-2023 04:00:04] INFO ARM: Disc identified as video [07-15-2023 04:00:04] INFO ARM: DVD CRC64 hash is: d4fddd0fec05d752 [07-15-2023 04:00:05] INFO ARM: Disc title Post ident - title:Parks-and-Recreation year:2009–2015 video_type:series disctype: dvd [07-15-2023 04:00:06] INFO ARM: We have no previous rips/jobs matching this label [07-15-2023 04:00:08] INFO ARM: Waiting 60 seconds for manual override. [07-15-2023 04:00:20] ERROR ARM: (sqlite3.OperationalError) database is locked [SQL: SELECT job.job_id, job.arm_version, job.crc_id, job.logfile, job.start_time, job.stop_time, job.job_length, job.status, job.stage, job.no_of_titles, job.title, job.title_auto, job.title_manual, job.year, job.year_auto, job.year_manual, job.video_type, job.video_type_auto, job.video_type_manual, job.imdb_id, job.imdb_id_auto, job.imdb_id_manual, job.poster_url, job.poster_url_auto, job.poster_url_manual, job.devpath, job.mountpoint, job.hasnicetitle, job.errors, job.disctype, job.label, job.path, job.ejected, job.updated, job.pid, job.pid_hash FROM job WHERE job.job_id = ?] [parameters: (1,)] (Background on this error at: https://sqlalche.me/e/20/e3q8) Traceback (most recent call last): File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 921, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/opt/arm/arm/ripper/main.py", line 202, in main(log_file, job, args.protection) File "/opt/arm/arm/ripper/main.py", line 101, in main utils.check_for_wait(job) File "/opt/arm/arm/ripper/utils.py", line 788, in check_for_wait db.session.refresh(job) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/scoping.py", line 1672, in refresh return self._proxied.refresh( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 3026, in refresh loading.load_on_ident( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/loading.py", line 481, in load_on_ident return load_on_pk_identity( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/loading.py", line 666, in load_on_pk_identity session.execute( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2246, in execute return self._execute_internal( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2141, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/context.py", line 293, in orm_execute_statement result = conn.execute( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1412, in execute return meth( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1635, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1844, in _execute_context return self._exec_single_context( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1984, in _exec_single_context self._handle_dbapi_exception( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2339, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 921, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked [SQL: SELECT job.job_id, job.arm_version, job.crc_id, job.logfile, job.start_time, job.stop_time, job.job_length, job.status, job.stage, job.no_of_titles, job.title, job.title_auto, job.title_manual, job.year, job.year_auto, job.year_manual, job.video_type, job.video_type_auto, job.video_type_manual, job.imdb_id, job.imdb_id_auto, job.imdb_id_manual, job.poster_url, job.poster_url_auto, job.poster_url_manual, job.devpath, job.mountpoint, job.hasnicetitle, job.errors, job.disctype, job.label, job.path, job.ejected, job.updated, job.pid, job.pid_hash FROM job WHERE job.job_id = ?] [parameters: (1,)] (Background on this error at: https://sqlalche.me/e/20/e3q8) [07-15-2023 04:00:21] ERROR ARM: A fatal error has occurred and ARM is exiting. See traceback below for details.`

dbooher2011 avatar Jul 15 '23 04:07 dbooher2011

Sorry, can you run them in debug mode ? Info mode is not great for debugging.

1337-server avatar Jul 15 '23 04:07 1337-server

Also, does the problem get better or worse with MANUAL_WAIT: false

1337-server avatar Jul 15 '23 04:07 1337-server

So I made no changes to "MANUAL_WAIT" mine is still set as "true". I can change that if you would like. All I did was install the test build and kept all my settings the same. Also, where do I set the "debugging" mode?

dbooher2011 avatar Jul 15 '23 04:07 dbooher2011

It would be great if you could change the manual wait, as that may be the last hold out.

Changing LOGLEVEL to DEBUG will enable enhanced logging.

Thanks again!

1337-server avatar Jul 15 '23 05:07 1337-server

Debug is on and "MANUAL_WAIT" was set to "false". I switched all 3 disc and two passed but one failed with the following log file:

`Loading log: PARKS_AND_RECREATION_168939928797.log... [07-15-2023 05:34:47] INFO ARM: ARMInfo.get_values ARM version: fix-for-500-and-880 [07-15-2023 05:34:47] INFO ARM: ARMInfo.get_values Python version: 3.8.10 (default, May 26 2023, 14:05:08) [GCC 9.4.0] [07-15-2023 05:34:47] INFO ARM: ARMInfo.get_values User is: arm [07-15-2023 05:34:47] INFO ARM: ARMInfo.get_values Alembic head is: 2e0dc31fcb2e [07-15-2023 05:34:47] INFO ARM: ARMInfo.get_values Database version is: 2e0dc31fcb2e [07-15-2023 05:34:47] INFO ARM: main. ************* Starting ARM processing at 2023-07-15 05:34:47.986559 ************* [07-15-2023 05:34:47] DEBUG ARM: utils.database_adder Trying to add Job [07-15-2023 05:34:48] DEBUG ARM: utils.database_adder successfully written Job to the database [07-15-2023 05:34:49] DEBUG ARM: DriveUtils.update_drive_job Updating drive [/dev/sr2] current job, with id [3] [07-15-2023 05:34:49] DEBUG ARM: DriveUtils.update_drive_job Database update with new Job ID to associated drive [07-15-2023 05:34:49] DEBUG ARM: utils.database_adder Trying to add Config [07-15-2023 05:34:50] DEBUG ARM: utils.database_adder successfully written Config to the database [07-15-2023 05:34:50] INFO ARM: logger.clean_up_logs Looking for log files older than 1 days old. [07-15-2023 05:34:50] INFO ARM: logger.clean_up_logs Checking path /home/arm/logs/ for old log files... [07-15-2023 05:34:50] INFO ARM: logger.clean_up_logs Checking path /home/arm/logs/progress for old log files... [07-15-2023 05:34:50] INFO ARM: main. Job: PARKS_AND_RECREATION [07-15-2023 05:34:50] INFO ARM: utils.clean_old_jobs Job #1 with PID 6541 is currently running. [07-15-2023 05:34:50] INFO ARM: utils.clean_old_jobs Job #2 with PID 6591 is currently running. [07-15-2023 05:34:50] INFO ARM: utils.clean_old_jobs Job #3 with PID 6652 is currently running. [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ******************* Logging udev attributes ******************* [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params DEVLINKS:/dev/dvdrw /dev/disk/by-path/pci-0000:01:00.1-ata-6 /dev/cdrw /dev/disk/by-id/ata-HL-DT-ST_BD-RE_WH16NS40_KLZL4IE3315 /dev/disk/by-label/PARKS_AND_RECREATION /dev/disk/by-uuid/40e6bc8900000000 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params DEVNAME:/dev/sr2 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params DEVPATH:/devices/pci0000:00/0000:00:01.3/0000:01:00.1/ata6/host6/target6:0:0/6:0:0:0/block/sr2 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params DEVTYPE:disk [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_ATA:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_ATA_SATA:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_ATA_SATA_SIGNAL_RATE_GEN1:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_BUS:ata [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_BD:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_BD_R:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_BD_RE:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_CD:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_CD_R:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_CD_RW:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_DVD:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_PLUS_R:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_PLUS_RW:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_PLUS_R_DL:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_R:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_RAM:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_RW:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_DVD:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_SESSION_COUNT:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_STATE:complete [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_TRACK_COUNT:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_TRACK_COUNT_DATA:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_MRW:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_CDROM_MRW_W:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_FOR_SEAT:block-pci-0000_01_00_1-ata-6 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_FS_LABEL:PARKS_AND_RECREATION [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_FS_LABEL_ENC:PARKS_AND_RECREATION [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_FS_TYPE:udf [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_FS_USAGE:filesystem [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_FS_UUID:40e6bc8900000000 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_FS_UUID_ENC:40e6bc8900000000 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_FS_VERSION:1.02 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_MODEL:HL-DT-ST_BD-RE_WH16NS40 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_MODEL_ENC:HL-DT-ST\x20BD-RE\x20\x20WH16NS40\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_PATH:pci-0000:01:00.1-ata-6 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_PATH_TAG:pci-0000_01_00_1-ata-6 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_REVISION:1.05 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_SERIAL:HL-DT-ST_BD-RE_WH16NS40_KLZL4IE3315 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_SERIAL_SHORT:KLZL4IE3315 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ID_TYPE:cd [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params MAJOR:11 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params MINOR:2 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params SUBSYSTEM:block [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params SYSTEMD_MOUNT_DEVICE_BOUND:1 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params TAGS::systemd:uaccess:seat: [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params USEC_INITIALIZED:30948146223 [07-15-2023 05:34:50] DEBUG ARM: main.log_udev_params ******************* End udev attributes ******************* [07-15-2023 05:34:50] INFO ARM: main.main Starting Disc identification [07-15-2023 05:34:50] DEBUG ARM: identify.identify Identify Entry point --- job ---- [07-15-2023 05:34:50] INFO ARM: identify.identify Mounting disc to: /mnt/dev/sr2 [07-15-2023 05:34:50] INFO ARM: identify.check_if_mounted Mounting disc was successful [07-15-2023 05:34:50] DEBUG ARM: models.get_disc_type Found: /mnt/dev/sr2/VIDEO_TS [07-15-2023 05:34:50] INFO ARM: identify.identify Disc identified as video [07-15-2023 05:34:50] DEBUG ARM: identify.identify_dvd

+--------------------+--------------------------------------------------------------+ | Config | Value | +--------------------+--------------------------------------------------------------+ | _sa_instance_state | <sqlalchemy.orm.state.InstanceState object at | | | 0x147d7c4914c0> | | poster_url | None | | label | PARKS_AND_RECREATION | | year_manual | None | | status | active | | arm_version | fix-for-500-and-880 | | job_id | 3 | | poster_url_auto | None | | stage | 168939928797 | | video_type | unknown | | path | None | | no_of_titles | None | | ejected | False | | video_type_auto | None | | crc_id | None | | poster_url_manual | None | | video_type_manual | None | | devpath | /dev/sr2 | | logfile | PARKS_AND_RECREATION_168939928797.log | | updated | False | | title | None | | pid | 6652 | | mountpoint | /mnt/dev/sr2 | | title_auto | None | | start_time | 2023-07-15 05:34:47.986745 | | imdb_id | None | | stop_time | None | | pid_hash | 4814584724199946579 | | imdb_id_auto | None | | hasnicetitle | False | | title_manual | None | | year | None | | job_length | None | | imdb_id_manual | None | | errors | None | | year_auto | None | | disctype | dvd | +--------------------+--------------------------------------------------------------+ [07-15-2023 05:34:50] INFO ARM: identify.identify_dvd DVD CRC64 hash is: 22561dbff737ca4f [07-15-2023 05:34:50] DEBUG ARM: identify.identify_dvd https://1337server.pythonanywhere.com/api/v1/?mode=s&crc64=22561dbff737ca4f [07-15-2023 05:34:50] DEBUG ARM: identify.identify_dvd dvd xml - {'mode': 'search', 'results': {}, 'success': False} [07-15-2023 05:34:50] DEBUG ARM: identify.identify_dvd results = {} [07-15-2023 05:34:50] DEBUG ARM: identify.identify_dvd dvd_title_label: PARKS_AND_RECREATION_22561dbff737ca4f [07-15-2023 05:34:50] DEBUG ARM: identify.identify_dvd dvd_title ^a-z _-: PARKS_AND_RECREATION [07-15-2023 05:34:50] DEBUG ARM: identify.identify_dvd dvd_title SKU$: PARKS_AND_RECREATION [07-15-2023 05:34:50] DEBUG ARM: identify.metadata_selector provider omdb [07-15-2023 05:34:50] DEBUG ARM: metadata.call_omdb_api omdb - {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 05:34:50] DEBUG ARM: metadata.call_omdb_api omdb - call was successful [07-15-2023 05:34:50] DEBUG ARM: identify.update_job Webservice successful. New title is Parks-and-Recreation. New Year is: 2009–2015 [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater year_auto=2009–2015:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater year=2009–2015:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater title_auto=Parks-and-Recreation:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater title=Parks-and-Recreation:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater video_type_auto=series:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater video_type=series:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater imdb_id_auto=tt1266020:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater imdb_id=tt1266020:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater poster_url_auto=https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater poster_url=https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg:<class 'str'> [07-15-2023 05:34:50] DEBUG ARM: utils.database_updater hasnicetitle=True:<class 'bool'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 05:34:53] DEBUG ARM: identify.identify_dvd DVD_INFO_XML: {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 05:34:53] DEBUG ARM: identify.identify_loop Response = {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 05:34:53] DEBUG ARM: identify.get_video_details Title = Parks-and-Recreation [07-15-2023 05:34:53] DEBUG ARM: identify.get_video_details Title: Parks-and-Recreation | Year: 20092015 [07-15-2023 05:34:53] DEBUG ARM: identify.get_video_details Calling webservice with title: Parks-and-Recreation and year: 20092015 [07-15-2023 05:34:53] DEBUG ARM: identify.identify_loop Response = None [07-15-2023 05:34:53] DEBUG ARM: identify.metadata_selector provider omdb [07-15-2023 05:34:53] DEBUG ARM: metadata.call_omdb_api omdb - {'Response': 'False', 'Error': 'Movie not found!', 'background_url': None} [07-15-2023 05:34:53] DEBUG ARM: metadata.call_omdb_api omdb - call was successful [07-15-2023 05:34:53] DEBUG ARM: identify.try_with_year response: None [07-15-2023 05:34:53] DEBUG ARM: identify.try_with_year Subtracting 1 year... [07-15-2023 05:34:53] DEBUG ARM: identify.metadata_selector provider omdb [07-15-2023 05:34:53] DEBUG ARM: metadata.call_omdb_api omdb - {'Response': 'False', 'Error': 'Movie not found!', 'background_url': None} [07-15-2023 05:34:53] DEBUG ARM: metadata.call_omdb_api omdb - call was successful [07-15-2023 05:34:53] DEBUG ARM: identify.try_without_year Removing year... [07-15-2023 05:34:53] DEBUG ARM: identify.metadata_selector provider omdb [07-15-2023 05:34:53] DEBUG ARM: metadata.call_omdb_api omdb - {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 05:34:53] DEBUG ARM: metadata.call_omdb_api omdb - call was successful [07-15-2023 05:34:53] DEBUG ARM: identify.update_job Webservice successful. New title is Parks-and-Recreation. New Year is: 2009–2015 [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater year_auto=2009–2015:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater year=2009–2015:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater title_auto=Parks-and-Recreation:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater title=Parks-and-Recreation:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater video_type_auto=series:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater video_type=series:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater imdb_id_auto=tt1266020:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater imdb_id=tt1266020:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater poster_url_auto=https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater poster_url=https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg:<class 'str'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater hasnicetitle=True:<class 'bool'> [07-15-2023 05:34:53] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 05:34:53] DEBUG ARM: identify.try_without_year response: {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 05:34:53] INFO ARM: identify.identify Disc title Post ident - title:Parks-and-Recreation year:2009–2015 video_type:series disctype: dvd [07-15-2023 05:34:53] DEBUG ARM: identify.identify identify.job.end ----

+--------------------+--------------------------------------------------------------+ | Config | Value | +--------------------+--------------------------------------------------------------+ | _sa_instance_state | <sqlalchemy.orm.state.InstanceState object at | | | 0x147d7c4914c0> | | poster_url | https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00 | | | MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1 | | | _SX300.jpg | | label | PARKS_AND_RECREATION | | year_manual | None | | status | active | | arm_version | fix-for-500-and-880 | | job_id | 3 | | poster_url_auto | https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00 | | | MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1 | | | _SX300.jpg | | stage | 168939928797 | | video_type | series | | path | None | | no_of_titles | None | | ejected | False | | video_type_auto | series | | crc_id | 22561dbff737ca4f | | poster_url_manual | None | | video_type_manual | None | | devpath | /dev/sr2 | | logfile | PARKS_AND_RECREATION_168939928797.log | | updated | False | | title | Parks-and-Recreation | | pid | 6652 | | mountpoint | /mnt/dev/sr2 | | title_auto | Parks-and-Recreation | | start_time | 2023-07-15 05:34:47.986745 | | imdb_id | tt1266020 | | stop_time | None | | pid_hash | 4814584724199946579 | | imdb_id_auto | tt1266020 | | hasnicetitle | True | | title_manual | None | | year | 2009–2015 | | job_length | None | | imdb_id_manual | None | | errors | None | | year_auto | 2009–2015 | | disctype | dvd | +--------------------+--------------------------------------------------------------+ [07-15-2023 05:34:53] DEBUG ARM: utils.job_dupe_check Trying to find jobs with matching Label=PARKS_AND_RECREATION [07-15-2023 05:34:53] INFO ARM: utils.job_dupe_check We have no previous rips/jobs matching this label [07-15-2023 05:34:53] DEBUG ARM: main.main Value of have_dupes: False [07-15-2023 05:34:53] DEBUG ARM: utils.database_adder Trying to add Notifications [07-15-2023 05:34:53] DEBUG ARM: utils.database_adder successfully written Notifications to the database [07-15-2023 05:34:53] DEBUG ARM: utils.database_adder Trying to add Notifications [07-15-2023 05:34:54] DEBUG ARM: utils.database_adder successfully written Notifications to the database [07-15-2023 05:34:54] INFO ARM: main.log_arm_params ******************* Logging ARM variables ******************* [07-15-2023 05:34:54] INFO ARM: main.log_arm_params devpath: /dev/sr2 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params mountpoint: /mnt/dev/sr2 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params title: Parks-and-Recreation [07-15-2023 05:34:54] INFO ARM: main.log_arm_params year: 2009–2015 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params video_type: series [07-15-2023 05:34:54] INFO ARM: main.log_arm_params hasnicetitle: True [07-15-2023 05:34:54] INFO ARM: main.log_arm_params label: PARKS_AND_RECREATION [07-15-2023 05:34:54] INFO ARM: main.log_arm_params disctype: dvd [07-15-2023 05:34:54] INFO ARM: main.log_arm_params ******************* End of ARM variables ******************* [07-15-2023 05:34:54] INFO ARM: main.log_arm_params ******************* Logging config parameters ******************* [07-15-2023 05:34:54] INFO ARM: main.log_arm_params skip_transcode: False [07-15-2023 05:34:54] INFO ARM: main.log_arm_params mainfeature: 1 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params minlength: 1200 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params maxlength: 99999 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params videotype: auto [07-15-2023 05:34:54] INFO ARM: main.log_arm_params manual_wait: False [07-15-2023 05:34:54] INFO ARM: main.log_arm_params manual_wait_time: 60 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params ripmethod: mkv [07-15-2023 05:34:54] INFO ARM: main.log_arm_params mkv_args: [07-15-2023 05:34:54] INFO ARM: main.log_arm_params delrawfiles: True [07-15-2023 05:34:54] INFO ARM: main.log_arm_params hb_preset_dvd: HQ 720p30 Surround [07-15-2023 05:34:54] INFO ARM: main.log_arm_params hb_preset_bd: H.265 NVENC 1080p [07-15-2023 05:34:54] INFO ARM: main.log_arm_params hb_args_dvd: --subtitle scan -F [07-15-2023 05:34:54] INFO ARM: main.log_arm_params hb_args_bd: --subtitle scan -F --subtitle-burned --audio-lang-list eng --all-audio [07-15-2023 05:34:54] INFO ARM: main.log_arm_params raw_path: /home/arm/media/raw/ [07-15-2023 05:34:54] INFO ARM: main.log_arm_params transcode_path: /home/arm/media/transcode/ [07-15-2023 05:34:54] INFO ARM: main.log_arm_params completed_path: /home/arm/media/completed/ [07-15-2023 05:34:54] INFO ARM: main.log_arm_params extras_sub: extras [07-15-2023 05:34:54] INFO ARM: main.log_arm_params emby_refresh: False [07-15-2023 05:34:54] INFO ARM: main.log_arm_params emby_server: [07-15-2023 05:34:54] INFO ARM: main.log_arm_params emby_port: 8096 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params notify_rip: True [07-15-2023 05:34:54] INFO ARM: main.log_arm_params notify_transcode: True [07-15-2023 05:34:54] INFO ARM: main.log_arm_params max_concurrent_transcodes: 0 [07-15-2023 05:34:54] INFO ARM: main.log_arm_params ******************* End of config parameters ******************* [07-15-2023 05:34:54] INFO ARM: main.check_fstab Checking for fstab entry. [07-15-2023 05:34:54] INFO ARM: main.check_fstab fstab entry is: /dev/sr2 /mnt/dev/sr2 udf,iso9660 users,noauto,exec,utf8,ro 0 0 [07-15-2023 05:34:54] INFO ARM: utils.check_for_dupe_folder Output directory "/home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015)" already exists. [07-15-2023 05:34:54] DEBUG ARM: utils.check_for_dupe_folder Value of ALLOW_DUPLICATES: True [07-15-2023 05:34:54] DEBUG ARM: utils.check_for_dupe_folder Value of have_dupes: False [07-15-2023 05:34:54] DEBUG ARM: utils.make_dir Creating directory: /home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015)_168939928797 [07-15-2023 05:34:54] INFO ARM: utils.check_for_dupe_folder Final Output directory "/home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015)_168939928797" [07-15-2023 05:34:54] INFO ARM: utils.check_for_dupe_folder Output directory "/home/arm/media/completed/tv/Parks-and-Recreation (2009–2015)" already exists. [07-15-2023 05:34:54] DEBUG ARM: utils.check_for_dupe_folder Value of ALLOW_DUPLICATES: True [07-15-2023 05:34:54] DEBUG ARM: utils.check_for_dupe_folder Value of have_dupes: False [07-15-2023 05:34:54] DEBUG ARM: utils.make_dir Creating directory: /home/arm/media/completed/tv/Parks-and-Recreation (2009–2015)_168939928797 [07-15-2023 05:34:54] INFO ARM: utils.check_for_dupe_folder Final Output directory "/home/arm/media/completed/tv/Parks-and-Recreation (2009–2015)_168939928797" [07-15-2023 05:34:54] DEBUG ARM: utils.database_updater path=/home/arm/media/completed/tv/Parks-and-Recreation (2009–2015)_168939928797:<class 'str'> [07-15-2023 05:34:54] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 05:34:54] INFO ARM: arm_ripper.rip_visual_media Processing files to: /home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015)_168939928797 [07-15-2023 05:34:54] DEBUG ARM: utils.database_updater status=transcoding:<class 'str'> [07-15-2023 05:34:55] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 05:34:55] INFO ARM: arm_ripper.start_transcode ************* Starting Transcode With HandBrake ************* [07-15-2023 05:34:55] DEBUG ARM: arm_ripper.start_transcode handbrake_all: /dev/sr2, /home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015)168939928797, /home/arm/logs/PARKS_AND_RECREATION_168939928797.log [07-15-2023 05:34:55] DEBUG ARM: utils.database_updater status=waiting_transcode:<class 'str'> [07-15-2023 05:34:55] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 05:34:55] INFO ARM: utils.sleep_check_process Transcode limit is disabled [07-15-2023 05:34:55] DEBUG ARM: utils.database_updater status=transcoding:<class 'str'> [07-15-2023 05:34:55] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 05:34:55] INFO ARM: handbrake.handbrake_all Starting BluRay/DVD transcoding - All titles [07-15-2023 05:34:55] INFO ARM: handbrake.get_track_info Using HandBrake to get information on all the tracks on the disc. This will take a few minutes... [07-15-2023 05:34:55] DEBUG ARM: handbrake.get_track_info Sending command: HandBrakeCLI -i /dev/sr2 -t 0 --scan [07-15-2023 05:35:30] DEBUG ARM: handbrake.get_track_info Line found is: Scanning title 1 of 1, 0.00 %[05:34:57] scan: DVD has 26 title(s) [07-15-2023 05:35:30] INFO ARM: handbrake.get_track_info Found 26 titles [07-15-2023 05:35:30] DEBUG ARM: utils.database_updater no_of_titles=26:<class 'str'> [07-15-2023 05:35:36] DEBUG ARM: utils.database_updater database is locked - try 0/90 [07-15-2023 05:35:37] DEBUG ARM: utils.database_updater database is locked - try 1/90 [07-15-2023 05:35:38] DEBUG ARM: utils.database_updater database is locked - try 2/90 [07-15-2023 05:35:39] DEBUG ARM: utils.database_updater database is locked - try 3/90 [07-15-2023 05:35:40] DEBUG ARM: utils.database_updater database is locked - try 4/90 [07-15-2023 05:35:41] DEBUG ARM: utils.database_updater database is locked - try 5/90 [07-15-2023 05:35:42] DEBUG ARM: utils.database_updater database is locked - try 6/90 [07-15-2023 05:35:43] DEBUG ARM: utils.database_updater database is locked - try 7/90 [07-15-2023 05:35:44] DEBUG ARM: utils.database_updater database is locked - try 8/90 [07-15-2023 05:35:45] DEBUG ARM: utils.database_updater database is locked - try 9/90 [07-15-2023 05:35:46] DEBUG ARM: utils.database_updater database is locked - try 10/90 [07-15-2023 05:35:47] DEBUG ARM: utils.database_updater database is locked - try 11/90 [07-15-2023 05:35:48] DEBUG ARM: utils.database_updater database is locked - try 12/90 [07-15-2023 05:35:49] DEBUG ARM: utils.database_updater database is locked - try 13/90 [07-15-2023 05:35:50] DEBUG ARM: utils.database_updater database is locked - try 14/90 [07-15-2023 05:35:51] DEBUG ARM: utils.database_updater database is locked - try 15/90 [07-15-2023 05:35:52] DEBUG ARM: utils.database_updater database is locked - try 16/90 [07-15-2023 05:35:53] DEBUG ARM: utils.database_updater database is locked - try 17/90 [07-15-2023 05:35:54] DEBUG ARM: utils.database_updater database is locked - try 18/90 [07-15-2023 05:35:55] DEBUG ARM: utils.database_updater database is locked - try 19/90 [07-15-2023 05:35:56] DEBUG ARM: utils.database_updater database is locked - try 20/90 [07-15-2023 05:35:57] DEBUG ARM: utils.database_updater database is locked - try 21/90 [07-15-2023 05:35:58] DEBUG ARM: utils.database_updater database is locked - try 22/90 [07-15-2023 05:35:59] DEBUG ARM: utils.database_updater database is locked - try 23/90 [07-15-2023 05:36:00] DEBUG ARM: utils.database_updater database is locked - try 24/90 [07-15-2023 05:36:01] DEBUG ARM: utils.database_updater database is locked - try 25/90 [07-15-2023 05:36:02] DEBUG ARM: utils.database_updater database is locked - try 26/90 [07-15-2023 05:36:03] DEBUG ARM: utils.database_updater database is locked - try 27/90 [07-15-2023 05:36:04] DEBUG ARM: utils.database_updater database is locked - try 28/90 [07-15-2023 05:36:05] DEBUG ARM: utils.database_updater database is locked - try 29/90 [07-15-2023 05:36:06] DEBUG ARM: utils.database_updater database is locked - try 30/90 [07-15-2023 05:36:07] DEBUG ARM: utils.database_updater database is locked - try 31/90 [07-15-2023 05:36:08] DEBUG ARM: utils.database_updater database is locked - try 32/90 [07-15-2023 05:36:09] DEBUG ARM: utils.database_updater database is locked - try 33/90 [07-15-2023 05:36:10] DEBUG ARM: utils.database_updater database is locked - try 34/90 [07-15-2023 05:36:11] DEBUG ARM: utils.database_updater database is locked - try 35/90 [07-15-2023 05:36:12] DEBUG ARM: utils.database_updater database is locked - try 36/90 [07-15-2023 05:36:13] DEBUG ARM: utils.database_updater database is locked - try 37/90 [07-15-2023 05:36:14] DEBUG ARM: utils.database_updater database is locked - try 38/90 [07-15-2023 05:36:15] DEBUG ARM: utils.database_updater database is locked - try 39/90 [07-15-2023 05:36:16] DEBUG ARM: utils.database_updater database is locked - try 40/90 [07-15-2023 05:36:17] DEBUG ARM: utils.database_updater database is locked - try 41/90 [07-15-2023 05:36:18] DEBUG ARM: utils.database_updater database is locked - try 42/90 [07-15-2023 05:36:19] DEBUG ARM: utils.database_updater database is locked - try 43/90 [07-15-2023 05:36:20] DEBUG ARM: utils.database_updater database is locked - try 44/90 [07-15-2023 05:36:21] DEBUG ARM: utils.database_updater database is locked - try 45/90 [07-15-2023 05:36:22] DEBUG ARM: utils.database_updater database is locked - try 46/90 [07-15-2023 05:36:23] DEBUG ARM: utils.database_updater database is locked - try 47/90 [07-15-2023 05:36:24] DEBUG ARM: utils.database_updater database is locked - try 48/90 [07-15-2023 05:36:25] DEBUG ARM: utils.database_updater database is locked - try 49/90 [07-15-2023 05:36:26] DEBUG ARM: utils.database_updater database is locked - try 50/90 [07-15-2023 05:36:27] DEBUG ARM: utils.database_updater database is locked - try 51/90 [07-15-2023 05:36:28] DEBUG ARM: utils.database_updater database is locked - try 52/90 [07-15-2023 05:36:29] DEBUG ARM: utils.database_updater database is locked - try 53/90 [07-15-2023 05:36:30] DEBUG ARM: utils.database_updater database is locked - try 54/90 [07-15-2023 05:36:31] DEBUG ARM: utils.database_updater database is locked - try 55/90 [07-15-2023 05:36:32] DEBUG ARM: utils.database_updater database is locked - try 56/90 [07-15-2023 05:36:33] DEBUG ARM: utils.database_updater database is locked - try 57/90 [07-15-2023 05:36:34] DEBUG ARM: utils.database_updater database is locked - try 58/90 [07-15-2023 05:36:35] DEBUG ARM: utils.database_updater database is locked - try 59/90 [07-15-2023 05:36:36] DEBUG ARM: utils.database_updater database is locked - try 60/90 [07-15-2023 05:36:37] DEBUG ARM: utils.database_updater database is locked - try 61/90 [07-15-2023 05:36:38] DEBUG ARM: utils.database_updater database is locked - try 62/90 [07-15-2023 05:36:39] DEBUG ARM: utils.database_updater database is locked - try 63/90 [07-15-2023 05:36:40] DEBUG ARM: utils.database_updater database is locked - try 64/90 [07-15-2023 05:36:41] DEBUG ARM: utils.database_updater database is locked - try 65/90 [07-15-2023 05:36:42] DEBUG ARM: utils.database_updater database is locked - try 66/90 [07-15-2023 05:36:43] DEBUG ARM: utils.database_updater database is locked - try 67/90 [07-15-2023 05:36:44] DEBUG ARM: utils.database_updater database is locked - try 68/90 [07-15-2023 05:36:45] DEBUG ARM: utils.database_updater database is locked - try 69/90 [07-15-2023 05:36:46] DEBUG ARM: utils.database_updater database is locked - try 70/90 [07-15-2023 05:36:47] DEBUG ARM: utils.database_updater database is locked - try 71/90 [07-15-2023 05:36:48] DEBUG ARM: utils.database_updater database is locked - try 72/90 [07-15-2023 05:36:49] DEBUG ARM: utils.database_updater database is locked - try 73/90 [07-15-2023 05:36:50] DEBUG ARM: utils.database_updater database is locked - try 74/90 [07-15-2023 05:36:51] DEBUG ARM: utils.database_updater database is locked - try 75/90 [07-15-2023 05:36:52] DEBUG ARM: utils.database_updater database is locked - try 76/90 [07-15-2023 05:36:53] DEBUG ARM: utils.database_updater database is locked - try 77/90 [07-15-2023 05:36:54] DEBUG ARM: utils.database_updater database is locked - try 78/90 [07-15-2023 05:36:55] DEBUG ARM: utils.database_updater database is locked - try 79/90 [07-15-2023 05:36:56] DEBUG ARM: utils.database_updater database is locked - try 80/90 [07-15-2023 05:36:57] DEBUG ARM: utils.database_updater database is locked - try 81/90 [07-15-2023 05:36:58] DEBUG ARM: utils.database_updater database is locked - try 82/90 [07-15-2023 05:36:59] DEBUG ARM: utils.database_updater database is locked - try 83/90 [07-15-2023 05:37:00] DEBUG ARM: utils.database_updater database is locked - try 84/90 [07-15-2023 05:37:01] DEBUG ARM: utils.database_updater database is locked - try 85/90 [07-15-2023 05:37:02] DEBUG ARM: utils.database_updater database is locked - try 86/90 [07-15-2023 05:37:03] DEBUG ARM: utils.database_updater database is locked - try 87/90 [07-15-2023 05:37:04] DEBUG ARM: utils.database_updater database is locked - try 88/90 [07-15-2023 05:37:05] DEBUG ARM: utils.database_updater database is locked - try 89/90 [07-15-2023 05:37:05] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 05:37:05] DEBUG ARM: utils.put_track Track #02 Length: 25 fps: 23.976 aspect: 1.78 Mainfeature: False Source: HandBrake [07-15-2023 05:37:05] ERROR ARM: main. This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.OperationalError) database is locked [SQL: UPDATE job SET no_of_titles=? WHERE job.job_id = ?] [parameters: ('26', 3)] (Background on this error at: https://sqlalche.me/e/20/e3q8) (Background on this error at: https://sqlalche.me/e/20/7s2a) Traceback (most recent call last): File "/opt/arm/arm/ripper/main.py", line 202, in main(log_file, job, args.protection) File "/opt/arm/arm/ripper/main.py", line 109, in main arm_ripper.rip_visual_media(have_dupes, job, logfile, protection) File "/opt/arm/arm/ripper/arm_ripper.py", line 70, in rip_visual_media start_transcode(job, logfile, hb_in_path, hb_out_path, protection) File "/opt/arm/arm/ripper/arm_ripper.py", line 126, in start_transcode handbrake.handbrake_all(hb_in_path, hb_out_path, logfile, job) File "/opt/arm/arm/ripper/handbrake.py", line 98, in handbrake_all get_track_info(srcpath, job) File "/opt/arm/arm/ripper/handbrake.py", line 275, in get_track_info main_feature, t_no = title_finder(aspect, fps, job, line, main_feature, seconds, t_no, t_pattern) File "/opt/arm/arm/ripper/handbrake.py", line 304, in title_finder utils.put_track(job, t_no, seconds, aspect, fps, main_feature, "HandBrake") File "/opt/arm/arm/ripper/utils.py", line 500, in put_track job_id=job.job_id, File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/attributes.py", line 563, in get return self.impl.get(state, dict) # type: ignore[no-any-return] File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/attributes.py", line 1083, in get value = self._fire_loader_callables(state, key, passive) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/attributes.py", line 1113, in _fire_loader_callables return state._load_expired(state, passive) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/state.py", line 798, in _load_expired self.manager.expired_attribute_loader(self, toload, passive) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/loading.py", line 1617, in load_scalar_attributes result = load_on_ident( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/loading.py", line 481, in load_on_ident return load_on_pk_identity( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/loading.py", line 666, in load_on_pk_identity session.execute( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2246, in execute return self._execute_internal( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2131, in _execute_internal conn = self._connection_for_bind(bind) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1998, in _connection_for_bind return trans._connection_for_bind(engine, execution_options) File "", line 2, in _connection_for_bind File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/state_changes.py", line 103, in _go self._raise_for_prerequisite_state(fn.name, current_state) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 909, in _raise_for_prerequisite_state raise sa_exc.PendingRollbackError( sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.OperationalError) database is locked [SQL: UPDATE job SET no_of_titles=? WHERE job.job_id = ?] [parameters: ('26', 3)] (Background on this error at: https://sqlalche.me/e/20/e3q8) (Background on this error at: https://sqlalche.me/e/20/7s2a) [07-15-2023 05:37:06] ERROR ARM: main. A fatal error has occurred and ARM is exiting. See traceback below for details.`

dbooher2011 avatar Jul 15 '23 05:07 dbooher2011

Also, I get an error message when I try to eject the disc. Should I just hold off on that since I'm on a "test' version for now?

dbooher2011 avatar Jul 15 '23 05:07 dbooher2011

Yeah, I've added some random timers to try and offset the db commits. This may be something that needs a total rethink if the latest version doesn't work.

Re-pulling the same image will update it. If you could try it again, and see if it works, that would be great. It's not really a great solution, but barring a total re-write, it will have to do as a temporary measure.

1337-server avatar Jul 15 '23 07:07 1337-server

I repulled but I have to leave for a little while today. I'll post my results when I get back because 2 disc loaded fine, third disc hit the db lock. As of now, it's on 13/90 attempts and with the increase in time between checks, it's like the little train that could. I'm hoping this is it! Also, I'm willing to do test in the future if you ever need anything.

dbooher2011 avatar Jul 15 '23 14:07 dbooher2011

Failed for disc 3. Here is the log:

`Loading log: PARKS_AND_RECREATION_168943166540.log... [07-15-2023 14:34:25] INFO ARM: ARMInfo.get_values ARM version: fix-for-500-and-880 [07-15-2023 14:34:25] INFO ARM: ARMInfo.get_values Python version: 3.8.10 (default, May 26 2023, 14:05:08) [GCC 9.4.0] [07-15-2023 14:34:25] INFO ARM: ARMInfo.get_values User is: arm [07-15-2023 14:34:25] INFO ARM: ARMInfo.get_values Alembic head is: 2e0dc31fcb2e [07-15-2023 14:34:25] INFO ARM: ARMInfo.get_values Database version is: 2e0dc31fcb2e [07-15-2023 14:34:25] INFO ARM: main. ************* Starting ARM processing at 2023-07-15 14:34:25.493373 ************* [07-15-2023 14:34:25] DEBUG ARM: utils.database_adder Trying to add Job [07-15-2023 14:34:25] DEBUG ARM: utils.database_adder successfully written Job to the database [07-15-2023 14:34:26] DEBUG ARM: DriveUtils.update_drive_job Updating drive [/dev/sr1] current job, with id [1] [07-15-2023 14:34:27] DEBUG ARM: DriveUtils.update_drive_job Database update with new Job ID to associated drive [07-15-2023 14:34:27] DEBUG ARM: utils.database_adder Trying to add Config [07-15-2023 14:34:27] DEBUG ARM: utils.database_adder successfully written Config to the database [07-15-2023 14:34:27] INFO ARM: logger.clean_up_logs Looking for log files older than 1 days old. [07-15-2023 14:34:27] INFO ARM: logger.clean_up_logs Checking path /home/arm/logs/ for old log files... [07-15-2023 14:34:27] INFO ARM: logger.clean_up_logs Checking path /home/arm/logs/progress for old log files... [07-15-2023 14:34:27] INFO ARM: main. Job: PARKS_AND_RECREATION [07-15-2023 14:34:27] INFO ARM: utils.clean_old_jobs Job #1 with PID 383 is currently running. [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ******************* Logging udev attributes ******************* [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params DEVLINKS:/dev/disk/by-path/pci-0000:01:00.1-ata-2 /dev/cdrw /dev/disk/by-uuid/42db990900000000 /dev/disk/by-label/PARKS_AND_RECREATION /dev/disk/by-id/ata-HL-DT-ST_BD-RE_WH16NS40_KLWL4IE1637 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params DEVNAME:/dev/sr1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params DEVPATH:/devices/pci0000:00/0000:00:01.3/0000:01:00.1/ata2/host2/target2:0:0/2:0:0:0/block/sr1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params DEVTYPE:disk [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_ATA:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_ATA_SATA:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_ATA_SATA_SIGNAL_RATE_GEN1:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_BUS:ata [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_BD:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_BD_R:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_BD_RE:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_CD:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_CD_R:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_CD_RW:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_DVD:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_PLUS_R:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_PLUS_RW:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_PLUS_R_DL:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_R:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_RAM:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_DVD_RW:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_DVD:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_SESSION_COUNT:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_STATE:complete [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_TRACK_COUNT:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_MEDIA_TRACK_COUNT_DATA:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_MRW:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_CDROM_MRW_W:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_FOR_SEAT:block-pci-0000_01_00_1-ata-2 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_FS_LABEL:PARKS_AND_RECREATION [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_FS_LABEL_ENC:PARKS_AND_RECREATION [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_FS_TYPE:udf [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_FS_USAGE:filesystem [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_FS_UUID:42db990900000000 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_FS_UUID_ENC:42db990900000000 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_FS_VERSION:1.02 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_MODEL:HL-DT-ST_BD-RE_WH16NS40 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_MODEL_ENC:HL-DT-ST\x20BD-RE\x20\x20WH16NS40\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_PATH:pci-0000:01:00.1-ata-2 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_PATH_TAG:pci-0000_01_00_1-ata-2 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_REVISION:1.05 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_SERIAL:HL-DT-ST_BD-RE_WH16NS40_KLWL4IE1637 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_SERIAL_SHORT:KLWL4IE1637 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ID_TYPE:cd [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params MAJOR:11 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params MINOR:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params SUBSYSTEM:block [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params SYSTEMD_MOUNT_DEVICE_BOUND:1 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params TAGS::seat:uaccess:systemd: [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params USEC_INITIALIZED:64759971323 [07-15-2023 14:34:27] DEBUG ARM: main.log_udev_params ******************* End udev attributes ******************* [07-15-2023 14:34:27] INFO ARM: main.main Starting Disc identification [07-15-2023 14:34:27] DEBUG ARM: identify.identify Identify Entry point --- job ---- [07-15-2023 14:34:27] INFO ARM: identify.identify Mounting disc to: /mnt/dev/sr1 [07-15-2023 14:34:27] INFO ARM: identify.check_if_mounted Mounting disc was successful [07-15-2023 14:34:27] DEBUG ARM: models.get_disc_type Found: /mnt/dev/sr1/VIDEO_TS [07-15-2023 14:34:27] INFO ARM: identify.identify Disc identified as video [07-15-2023 14:34:27] DEBUG ARM: identify.identify_dvd

+--------------------+--------------------------------------------------------------+ | Config | Value | +--------------------+--------------------------------------------------------------+ | _sa_instance_state | <sqlalchemy.orm.state.InstanceState object at | | | 0x1497c16f84c0> | | disctype | dvd | | year_auto | None | | job_length | None | | imdb_id_manual | None | | poster_url | None | | year_manual | None | | label | PARKS_AND_RECREATION | | status | active | | video_type | unknown | | path | None | | stage | 168943166540 | | arm_version | fix-for-500-and-880 | | job_id | 1 | | poster_url_auto | None | | no_of_titles | None | | crc_id | None | | ejected | False | | video_type_auto | None | | poster_url_manual | None | | logfile | PARKS_AND_RECREATION_168943166540.log | | updated | False | | title | None | | video_type_manual | None | | devpath | /dev/sr1 | | mountpoint | /mnt/dev/sr1 | | imdb_id | None | | title_auto | None | | start_time | 2023-07-15 14:34:25.493471 | | pid | 383 | | stop_time | None | | title_manual | None | | imdb_id_auto | None | | hasnicetitle | False | | pid_hash | 6636539405090914840 | | year | None | | errors | None | +--------------------+--------------------------------------------------------------+ [07-15-2023 14:34:28] INFO ARM: identify.identify_dvd DVD CRC64 hash is: c320655838468340 [07-15-2023 14:34:28] DEBUG ARM: identify.identify_dvd https://1337server.pythonanywhere.com/api/v1/?mode=s&crc64=c320655838468340 [07-15-2023 14:34:28] DEBUG ARM: identify.identify_dvd dvd xml - {'mode': 'search', 'results': {}, 'success': False} [07-15-2023 14:34:28] DEBUG ARM: identify.identify_dvd results = {} [07-15-2023 14:34:28] DEBUG ARM: identify.identify_dvd dvd_title_label: PARKS_AND_RECREATION_c320655838468340 [07-15-2023 14:34:28] DEBUG ARM: identify.identify_dvd dvd_title ^a-z _-: PARKS_AND_RECREATION [07-15-2023 14:34:28] DEBUG ARM: identify.identify_dvd dvd_title SKU$: PARKS_AND_RECREATION [07-15-2023 14:34:28] DEBUG ARM: identify.metadata_selector provider omdb [07-15-2023 14:34:28] DEBUG ARM: metadata.call_omdb_api omdb - {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 14:34:28] DEBUG ARM: metadata.call_omdb_api omdb - call was successful [07-15-2023 14:34:28] DEBUG ARM: identify.update_job Webservice successful. New title is Parks-and-Recreation. New Year is: 2009–2015 [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater year_auto=2009–2015:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater year=2009–2015:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater title_auto=Parks-and-Recreation:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater title=Parks-and-Recreation:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater video_type_auto=series:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater video_type=series:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater imdb_id_auto=tt1266020:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater imdb_id=tt1266020:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater poster_url_auto=https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater poster_url=https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg:<class 'str'> [07-15-2023 14:34:28] DEBUG ARM: utils.database_updater hasnicetitle=True:<class 'bool'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 14:34:29] DEBUG ARM: identify.identify_dvd DVD_INFO_XML: {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 14:34:29] DEBUG ARM: identify.identify_loop Response = {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 14:34:29] DEBUG ARM: identify.get_video_details Title = Parks-and-Recreation [07-15-2023 14:34:29] DEBUG ARM: identify.get_video_details Title: Parks-and-Recreation | Year: 20092015 [07-15-2023 14:34:29] DEBUG ARM: identify.get_video_details Calling webservice with title: Parks-and-Recreation and year: 20092015 [07-15-2023 14:34:29] DEBUG ARM: identify.identify_loop Response = None [07-15-2023 14:34:29] DEBUG ARM: identify.metadata_selector provider omdb [07-15-2023 14:34:29] DEBUG ARM: metadata.call_omdb_api omdb - {'Response': 'False', 'Error': 'Movie not found!', 'background_url': None} [07-15-2023 14:34:29] DEBUG ARM: metadata.call_omdb_api omdb - call was successful [07-15-2023 14:34:29] DEBUG ARM: identify.try_with_year response: None [07-15-2023 14:34:29] DEBUG ARM: identify.try_with_year Subtracting 1 year... [07-15-2023 14:34:29] DEBUG ARM: identify.metadata_selector provider omdb [07-15-2023 14:34:29] DEBUG ARM: metadata.call_omdb_api omdb - {'Response': 'False', 'Error': 'Movie not found!', 'background_url': None} [07-15-2023 14:34:29] DEBUG ARM: metadata.call_omdb_api omdb - call was successful [07-15-2023 14:34:29] DEBUG ARM: identify.try_without_year Removing year... [07-15-2023 14:34:29] DEBUG ARM: identify.metadata_selector provider omdb [07-15-2023 14:34:29] DEBUG ARM: metadata.call_omdb_api omdb - {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 14:34:29] DEBUG ARM: metadata.call_omdb_api omdb - call was successful [07-15-2023 14:34:29] DEBUG ARM: identify.update_job Webservice successful. New title is Parks-and-Recreation. New Year is: 2009–2015 [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater year_auto=2009–2015:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater year=2009–2015:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater title_auto=Parks-and-Recreation:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater title=Parks-and-Recreation:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater video_type_auto=series:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater video_type=series:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater imdb_id_auto=tt1266020:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater imdb_id=tt1266020:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater poster_url_auto=https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater poster_url=https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg:<class 'str'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater hasnicetitle=True:<class 'bool'> [07-15-2023 14:34:29] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 14:34:29] DEBUG ARM: identify.try_without_year response: {'Search': [{'Title': 'Parks and Recreation', 'Year': '2009–2015', 'imdbID': 'tt1266020', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1_SX300.jpg'}, {'Title': 'A Parks and Recreation Special', 'Year': '2020', 'imdbID': 'tt12202120', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMzFkYTgzMWQtNjA5NC00YTA5LTg2MjUtOWQ4ZTc3NDY4Yjg3XkEyXkFqcGdeQXVyNjU1OTg4OTM@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Dammit Jerry!', 'Year': '2012', 'imdbID': 'tt2691394', 'Type': 'movie', 'Poster': 'https://m.media-amazon.com/images/M/MV5BMTQzMjE3NTMyOF5BMl5BanBnXkFtZTgwNjE4NzA2MDE@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation: Road Trip', 'Year': '2011', 'imdbID': 'tt2138881', 'Type': 'series', 'Poster': 'https://m.media-amazon.com/images/M/MV5BNDYyNWMwZjAtNWQ4Yi00MDJiLWE5NTktMDJkYmNmNjY5NGVlXkEyXkFqcGdeQXVyMDM0MzU2NA@@._V1_SX300.jpg'}, {'Title': 'Parks and Recreation in Europe', 'Year': '2014', 'imdbID': 'tt4311010', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation Is the Wu-Tang of Comedy', 'Year': '2010', 'imdbID': 'tt1600014', 'Type': 'movie', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation: Behind the Final Season', 'Year': '2015–', 'imdbID': 'tt5057482', 'Type': 'series', 'Poster': 'N/A'}, {'Title': 'Parks and Recreation', 'Year': '2016', 'imdbID': 'tt5440580', 'Type': 'movie', 'Poster': 'N/A'}], 'totalResults': '8', 'Response': 'True', 'background_url': None} [07-15-2023 14:34:29] INFO ARM: identify.identify Disc title Post ident - title:Parks-and-Recreation year:2009–2015 video_type:series disctype: dvd [07-15-2023 14:34:29] DEBUG ARM: identify.identify identify.job.end ----

+--------------------+--------------------------------------------------------------+ | Config | Value | +--------------------+--------------------------------------------------------------+ | _sa_instance_state | <sqlalchemy.orm.state.InstanceState object at | | | 0x1497c16f84c0> | | disctype | dvd | | year_auto | 2009–2015 | | job_length | None | | imdb_id_manual | None | | poster_url | https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00 | | | MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1 | | | _SX300.jpg | | year_manual | None | | label | PARKS_AND_RECREATION | | status | active | | video_type | series | | path | None | | stage | 168943166540 | | arm_version | fix-for-500-and-880 | | job_id | 1 | | poster_url_auto | https://m.media-amazon.com/images/M/MV5BYWNkOTg0OTMtZTcyNy00 | | | MWU1LWJhZDQtYjQzMjU1NjBhYzI2XkEyXkFqcGdeQXVyOTE4NzcwNzI@._V1 | | | SX300.jpg | | no_of_titles | None | | crc_id | c320655838468340 | | ejected | False | | video_type_auto | series | | poster_url_manual | None | | logfile | PARKS_AND_RECREATION_168943166540.log | | updated | False | | title | Parks-and-Recreation | | video_type_manual | None | | devpath | /dev/sr1 | | mountpoint | /mnt/dev/sr1 | | imdb_id | tt1266020 | | title_auto | Parks-and-Recreation | | start_time | 2023-07-15 14:34:25.493471 | | pid | 383 | | stop_time | None | | title_manual | None | | imdb_id_auto | tt1266020 | | hasnicetitle | True | | pid_hash | 6636539405090914840 | | year | 2009–2015 | | errors | None | +--------------------+--------------------------------------------------------------+ [07-15-2023 14:34:29] DEBUG ARM: utils.job_dupe_check Trying to find jobs with matching Label=PARKS_AND_RECREATION [07-15-2023 14:34:29] INFO ARM: utils.job_dupe_check We have no previous rips/jobs matching this label [07-15-2023 14:34:29] DEBUG ARM: main.main Value of have_dupes: False [07-15-2023 14:34:29] DEBUG ARM: utils.database_adder Trying to add Notifications [07-15-2023 14:34:30] DEBUG ARM: utils.database_adder successfully written Notifications to the database [07-15-2023 14:34:30] DEBUG ARM: utils.database_adder Trying to add Notifications [07-15-2023 14:34:30] DEBUG ARM: utils.database_adder successfully written Notifications to the database [07-15-2023 14:34:30] INFO ARM: main.log_arm_params ******************* Logging ARM variables ******************* [07-15-2023 14:34:30] INFO ARM: main.log_arm_params devpath: /dev/sr1 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params mountpoint: /mnt/dev/sr1 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params title: Parks-and-Recreation [07-15-2023 14:34:30] INFO ARM: main.log_arm_params year: 2009–2015 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params video_type: series [07-15-2023 14:34:30] INFO ARM: main.log_arm_params hasnicetitle: True [07-15-2023 14:34:30] INFO ARM: main.log_arm_params label: PARKS_AND_RECREATION [07-15-2023 14:34:30] INFO ARM: main.log_arm_params disctype: dvd [07-15-2023 14:34:30] INFO ARM: main.log_arm_params ******************* End of ARM variables ******************* [07-15-2023 14:34:30] INFO ARM: main.log_arm_params ******************* Logging config parameters ******************* [07-15-2023 14:34:30] INFO ARM: main.log_arm_params skip_transcode: False [07-15-2023 14:34:30] INFO ARM: main.log_arm_params mainfeature: 1 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params minlength: 1200 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params maxlength: 99999 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params videotype: auto [07-15-2023 14:34:30] INFO ARM: main.log_arm_params manual_wait: False [07-15-2023 14:34:30] INFO ARM: main.log_arm_params manual_wait_time: 60 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params ripmethod: mkv [07-15-2023 14:34:30] INFO ARM: main.log_arm_params mkv_args: [07-15-2023 14:34:30] INFO ARM: main.log_arm_params delrawfiles: True [07-15-2023 14:34:30] INFO ARM: main.log_arm_params hb_preset_dvd: HQ 720p30 Surround [07-15-2023 14:34:30] INFO ARM: main.log_arm_params hb_preset_bd: H.265 NVENC 1080p [07-15-2023 14:34:30] INFO ARM: main.log_arm_params hb_args_dvd: --subtitle scan -F [07-15-2023 14:34:30] INFO ARM: main.log_arm_params hb_args_bd: --subtitle scan -F --subtitle-burned --audio-lang-list eng --all-audio [07-15-2023 14:34:30] INFO ARM: main.log_arm_params raw_path: /home/arm/media/raw/ [07-15-2023 14:34:30] INFO ARM: main.log_arm_params transcode_path: /home/arm/media/transcode/ [07-15-2023 14:34:30] INFO ARM: main.log_arm_params completed_path: /home/arm/media/completed/ [07-15-2023 14:34:30] INFO ARM: main.log_arm_params extras_sub: extras [07-15-2023 14:34:30] INFO ARM: main.log_arm_params emby_refresh: False [07-15-2023 14:34:30] INFO ARM: main.log_arm_params emby_server: [07-15-2023 14:34:30] INFO ARM: main.log_arm_params emby_port: 8096 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params notify_rip: True [07-15-2023 14:34:30] INFO ARM: main.log_arm_params notify_transcode: True [07-15-2023 14:34:30] INFO ARM: main.log_arm_params max_concurrent_transcodes: 0 [07-15-2023 14:34:30] INFO ARM: main.log_arm_params ******************* End of config parameters ******************* [07-15-2023 14:34:30] INFO ARM: main.check_fstab Checking for fstab entry. [07-15-2023 14:34:30] INFO ARM: main.check_fstab fstab entry is: /dev/sr1 /mnt/dev/sr1 udf,iso9660 users,noauto,exec,utf8,ro 0 0 [07-15-2023 14:34:30] DEBUG ARM: utils.make_dir Creating directory: /home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015) [07-15-2023 14:34:30] INFO ARM: utils.check_for_dupe_folder Final Output directory "/home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015)" [07-15-2023 14:34:30] DEBUG ARM: utils.make_dir Creating directory: /home/arm/media/completed/tv/Parks-and-Recreation (2009–2015) [07-15-2023 14:34:30] INFO ARM: utils.check_for_dupe_folder Final Output directory "/home/arm/media/completed/tv/Parks-and-Recreation (2009–2015)" [07-15-2023 14:34:30] DEBUG ARM: utils.database_updater path=/home/arm/media/completed/tv/Parks-and-Recreation (2009–2015):<class 'str'> [07-15-2023 14:34:31] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 14:34:31] INFO ARM: arm_ripper.rip_visual_media Processing files to: /home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015) [07-15-2023 14:34:31] DEBUG ARM: utils.database_updater status=transcoding:<class 'str'> [07-15-2023 14:34:31] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 14:34:31] INFO ARM: arm_ripper.start_transcode ************* Starting Transcode With HandBrake ************* [07-15-2023 14:34:31] DEBUG ARM: arm_ripper.start_transcode handbrake_all: /dev/sr1, /home/arm/media/transcode/tv/Parks-and-Recreation (2009–2015), /home/arm/logs/PARKS_AND_RECREATION_168943166540.log [07-15-2023 14:34:31] DEBUG ARM: utils.database_updater status=waiting_transcode:<class 'str'> [07-15-2023 14:34:32] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 14:34:32] INFO ARM: utils.sleep_check_process Transcode limit is disabled [07-15-2023 14:34:32] DEBUG ARM: utils.database_updater status=transcoding:<class 'str'> [07-15-2023 14:34:32] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 14:34:32] INFO ARM: handbrake.handbrake_all Starting BluRay/DVD transcoding - All titles [07-15-2023 14:34:32] INFO ARM: handbrake.get_track_info Using HandBrake to get information on all the tracks on the disc. This will take a few minutes... [07-15-2023 14:34:32] DEBUG ARM: handbrake.get_track_info Sending command: HandBrakeCLI -i /dev/sr1 -t 0 --scan [07-15-2023 14:35:34] DEBUG ARM: handbrake.get_track_info Line found is: Scanning title 1 of 1, 0.00 %[14:34:33] scan: DVD has 48 title(s) [07-15-2023 14:35:34] INFO ARM: handbrake.get_track_info Found 48 titles [07-15-2023 14:35:34] DEBUG ARM: utils.database_updater no_of_titles=48:<class 'str'> [07-15-2023 14:35:42] DEBUG ARM: utils.database_updater database is locked - try 0/90 [07-15-2023 14:35:51] DEBUG ARM: utils.database_updater database is locked - try 1/90 [07-15-2023 14:35:55] DEBUG ARM: utils.database_updater database is locked - try 2/90 [07-15-2023 14:35:56] DEBUG ARM: utils.database_updater database is locked - try 3/90 [07-15-2023 14:35:59] DEBUG ARM: utils.database_updater database is locked - try 4/90 [07-15-2023 14:36:23] DEBUG ARM: utils.database_updater database is locked - try 5/90 [07-15-2023 14:36:45] DEBUG ARM: utils.database_updater database is locked - try 6/90 [07-15-2023 14:37:09] DEBUG ARM: utils.database_updater database is locked - try 7/90 [07-15-2023 14:37:24] DEBUG ARM: utils.database_updater database is locked - try 8/90 [07-15-2023 14:37:32] DEBUG ARM: utils.database_updater database is locked - try 9/90 [07-15-2023 14:37:49] DEBUG ARM: utils.database_updater database is locked - try 10/90 [07-15-2023 14:38:06] DEBUG ARM: utils.database_updater database is locked - try 11/90 [07-15-2023 14:38:18] DEBUG ARM: utils.database_updater database is locked - try 12/90 [07-15-2023 14:38:36] DEBUG ARM: utils.database_updater database is locked - try 13/90 [07-15-2023 14:38:57] DEBUG ARM: utils.database_updater database is locked - try 14/90 [07-15-2023 14:39:01] DEBUG ARM: utils.database_updater database is locked - try 15/90 [07-15-2023 14:39:04] DEBUG ARM: utils.database_updater database is locked - try 16/90 [07-15-2023 14:39:12] DEBUG ARM: utils.database_updater database is locked - try 17/90 [07-15-2023 14:39:15] DEBUG ARM: utils.database_updater database is locked - try 18/90 [07-15-2023 14:39:20] DEBUG ARM: utils.database_updater database is locked - try 19/90 [07-15-2023 14:39:29] DEBUG ARM: utils.database_updater database is locked - try 20/90 [07-15-2023 14:39:35] DEBUG ARM: utils.database_updater database is locked - try 21/90 [07-15-2023 14:39:53] DEBUG ARM: utils.database_updater database is locked - try 22/90 [07-15-2023 14:39:54] DEBUG ARM: utils.database_updater database is locked - try 23/90 [07-15-2023 14:39:57] DEBUG ARM: utils.database_updater database is locked - try 24/90 [07-15-2023 14:40:20] DEBUG ARM: utils.database_updater database is locked - try 25/90 [07-15-2023 14:40:21] DEBUG ARM: utils.database_updater database is locked - try 26/90 [07-15-2023 14:40:32] DEBUG ARM: utils.database_updater database is locked - try 27/90 [07-15-2023 14:40:42] DEBUG ARM: utils.database_updater database is locked - try 28/90 [07-15-2023 14:40:48] DEBUG ARM: utils.database_updater database is locked - try 29/90 [07-15-2023 14:40:56] DEBUG ARM: utils.database_updater database is locked - try 30/90 [07-15-2023 14:41:09] DEBUG ARM: utils.database_updater database is locked - try 31/90 [07-15-2023 14:41:32] DEBUG ARM: utils.database_updater database is locked - try 32/90 [07-15-2023 14:41:46] DEBUG ARM: utils.database_updater database is locked - try 33/90 [07-15-2023 14:42:05] DEBUG ARM: utils.database_updater database is locked - try 34/90 [07-15-2023 14:42:07] DEBUG ARM: utils.database_updater database is locked - try 35/90 [07-15-2023 14:42:24] DEBUG ARM: utils.database_updater database is locked - try 36/90 [07-15-2023 14:42:37] DEBUG ARM: utils.database_updater database is locked - try 37/90 [07-15-2023 14:42:46] DEBUG ARM: utils.database_updater database is locked - try 38/90 [07-15-2023 14:43:08] DEBUG ARM: utils.database_updater database is locked - try 39/90 [07-15-2023 14:43:24] DEBUG ARM: utils.database_updater database is locked - try 40/90 [07-15-2023 14:43:40] DEBUG ARM: utils.database_updater database is locked - try 41/90 [07-15-2023 14:43:54] DEBUG ARM: utils.database_updater database is locked - try 42/90 [07-15-2023 14:44:07] DEBUG ARM: utils.database_updater database is locked - try 43/90 [07-15-2023 14:44:24] DEBUG ARM: utils.database_updater database is locked - try 44/90 [07-15-2023 14:44:39] DEBUG ARM: utils.database_updater database is locked - try 45/90 [07-15-2023 14:45:01] DEBUG ARM: utils.database_updater database is locked - try 46/90 [07-15-2023 14:45:05] DEBUG ARM: utils.database_updater database is locked - try 47/90 [07-15-2023 14:45:08] DEBUG ARM: utils.database_updater database is locked - try 48/90 [07-15-2023 14:45:12] DEBUG ARM: utils.database_updater database is locked - try 49/90 [07-15-2023 14:45:36] DEBUG ARM: utils.database_updater database is locked - try 50/90 [07-15-2023 14:45:38] DEBUG ARM: utils.database_updater database is locked - try 51/90 [07-15-2023 14:45:46] DEBUG ARM: utils.database_updater database is locked - try 52/90 [07-15-2023 14:45:59] DEBUG ARM: utils.database_updater database is locked - try 53/90 [07-15-2023 14:46:20] DEBUG ARM: utils.database_updater database is locked - try 54/90 [07-15-2023 14:46:26] DEBUG ARM: utils.database_updater database is locked - try 55/90 [07-15-2023 14:46:40] DEBUG ARM: utils.database_updater database is locked - try 56/90 [07-15-2023 14:47:02] DEBUG ARM: utils.database_updater database is locked - try 57/90 [07-15-2023 14:47:12] DEBUG ARM: utils.database_updater database is locked - try 58/90 [07-15-2023 14:47:31] DEBUG ARM: utils.database_updater database is locked - try 59/90 [07-15-2023 14:47:55] DEBUG ARM: utils.database_updater database is locked - try 60/90 [07-15-2023 14:48:19] DEBUG ARM: utils.database_updater database is locked - try 61/90 [07-15-2023 14:48:34] DEBUG ARM: utils.database_updater database is locked - try 62/90 [07-15-2023 14:48:45] DEBUG ARM: utils.database_updater database is locked - try 63/90 [07-15-2023 14:48:48] DEBUG ARM: utils.database_updater database is locked - try 64/90 [07-15-2023 14:49:09] DEBUG ARM: utils.database_updater database is locked - try 65/90 [07-15-2023 14:49:25] DEBUG ARM: utils.database_updater database is locked - try 66/90 [07-15-2023 14:49:49] DEBUG ARM: utils.database_updater database is locked - try 67/90 [07-15-2023 14:49:51] DEBUG ARM: utils.database_updater database is locked - try 68/90 [07-15-2023 14:49:53] DEBUG ARM: utils.database_updater database is locked - try 69/90 [07-15-2023 14:50:03] DEBUG ARM: utils.database_updater database is locked - try 70/90 [07-15-2023 14:50:22] DEBUG ARM: utils.database_updater database is locked - try 71/90 [07-15-2023 14:50:34] DEBUG ARM: utils.database_updater database is locked - try 72/90 [07-15-2023 14:50:38] DEBUG ARM: utils.database_updater database is locked - try 73/90 [07-15-2023 14:50:45] DEBUG ARM: utils.database_updater database is locked - try 74/90 [07-15-2023 14:51:06] DEBUG ARM: utils.database_updater database is locked - try 75/90 [07-15-2023 14:51:17] DEBUG ARM: utils.database_updater database is locked - try 76/90 [07-15-2023 14:51:18] DEBUG ARM: utils.database_updater database is locked - try 77/90 [07-15-2023 14:51:20] DEBUG ARM: utils.database_updater database is locked - try 78/90 [07-15-2023 14:51:24] DEBUG ARM: utils.database_updater database is locked - try 79/90 [07-15-2023 14:51:30] DEBUG ARM: utils.database_updater database is locked - try 80/90 [07-15-2023 14:51:45] DEBUG ARM: utils.database_updater database is locked - try 81/90 [07-15-2023 14:51:53] DEBUG ARM: utils.database_updater database is locked - try 82/90 [07-15-2023 14:52:09] DEBUG ARM: utils.database_updater database is locked - try 83/90 [07-15-2023 14:52:16] DEBUG ARM: utils.database_updater database is locked - try 84/90 [07-15-2023 14:52:20] DEBUG ARM: utils.database_updater database is locked - try 85/90 [07-15-2023 14:52:33] DEBUG ARM: utils.database_updater database is locked - try 86/90 [07-15-2023 14:52:56] DEBUG ARM: utils.database_updater database is locked - try 87/90 [07-15-2023 14:53:07] DEBUG ARM: utils.database_updater database is locked - try 88/90 [07-15-2023 14:53:20] DEBUG ARM: utils.database_updater database is locked - try 89/90 [07-15-2023 14:53:20] DEBUG ARM: utils.database_updater successfully written to the database [07-15-2023 14:53:20] DEBUG ARM: utils.put_track Track #02 Length: 26 fps: 23.976 aspect: 1.78 Mainfeature: False Source: HandBrake [07-15-2023 14:53:20] ERROR ARM: main. This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.OperationalError) database is locked [SQL: UPDATE job SET no_of_titles=? WHERE job.job_id = ?] [parameters: ('48', 1)] (Background on this error at: https://sqlalche.me/e/20/e3q8) (Background on this error at: https://sqlalche.me/e/20/7s2a) Traceback (most recent call last): File "/opt/arm/arm/ripper/main.py", line 202, in main(log_file, job, args.protection) File "/opt/arm/arm/ripper/main.py", line 109, in main arm_ripper.rip_visual_media(have_dupes, job, logfile, protection) File "/opt/arm/arm/ripper/arm_ripper.py", line 70, in rip_visual_media start_transcode(job, logfile, hb_in_path, hb_out_path, protection) File "/opt/arm/arm/ripper/arm_ripper.py", line 126, in start_transcode handbrake.handbrake_all(hb_in_path, hb_out_path, logfile, job) File "/opt/arm/arm/ripper/handbrake.py", line 98, in handbrake_all get_track_info(srcpath, job) File "/opt/arm/arm/ripper/handbrake.py", line 275, in get_track_info main_feature, t_no = title_finder(aspect, fps, job, line, main_feature, seconds, t_no, t_pattern) File "/opt/arm/arm/ripper/handbrake.py", line 304, in title_finder utils.put_track(job, t_no, seconds, aspect, fps, main_feature, "HandBrake") File "/opt/arm/arm/ripper/utils.py", line 500, in put_track job_id=job.job_id, File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/attributes.py", line 563, in get return self.impl.get(state, dict) # type: ignore[no-any-return] File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/attributes.py", line 1083, in get value = self._fire_loader_callables(state, key, passive) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/attributes.py", line 1113, in _fire_loader_callables return state._load_expired(state, passive) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/state.py", line 798, in _load_expired self.manager.expired_attribute_loader(self, toload, passive) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/loading.py", line 1617, in load_scalar_attributes result = load_on_ident( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/loading.py", line 481, in load_on_ident return load_on_pk_identity( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/loading.py", line 666, in load_on_pk_identity session.execute( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2246, in execute return self._execute_internal( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2131, in _execute_internal conn = self._connection_for_bind(bind) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1998, in _connection_for_bind return trans._connection_for_bind(engine, execution_options) File "", line 2, in _connection_for_bind File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/state_changes.py", line 103, in _go self._raise_for_prerequisite_state(fn.name, current_state) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 909, in _raise_for_prerequisite_state raise sa_exc.PendingRollbackError( sqlalchemy.exc.PendingRollbackError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (sqlite3.OperationalError) database is locked [SQL: UPDATE job SET no_of_titles=? WHERE job.job_id = ?] [parameters: ('48', 1)] (Background on this error at: https://sqlalche.me/e/20/e3q8) (Background on this error at: https://sqlalche.me/e/20/7s2a) [07-15-2023 14:53:20] ERROR ARM: main. A fatal error has occurred and ARM is exiting. See traceback below for details.`

dbooher2011 avatar Jul 15 '23 17:07 dbooher2011

Thanks, sorry, I thought I responded. I don't really have any other solution right now.

We are working on this, but it will take time to migrate things for everyone to be able to use.

1337-server avatar Jul 23 '23 12:07 1337-server

Hi,

I'm also facing the "database locked" issue and can assist in trying tentative builds if anything. I'm running the same container on unraid, with two drives.

jp1151419 avatar Jul 23 '23 23:07 jp1151419

Ok, I have a test image. But it requires extra work on your end.

The image: automaticrippingmachine/automatic-ripping-machine:Fix_for_issue_500_and_880

For this new image to work, you will need a MySQL database called arm the docker version (https://hub.docker.com/_/mysql) of MySQL works and is what I used to test this.

Once you have the database server up and running, create a new database called arm this is all you need to do, arm should take care of creating the tables and info it requires.

Next when you pull the A.R.M image to create the container it requires 3 new docker environment variables

MYSQL_USER
MYSQL_PASSWORD
MYSQL_IP

Match these with the correct settings for your db details

Once you have created the container, it won't work fully yet. You will need to connect into it and run pip3 install mysql-connector-python

After this has installed, you should now have a full working version with the database locked no longer an issue.

Docker compose with HW transcoding

version: '2'

services:

  db:
    image: mysql
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: example
    ports:
      - 3306:3306
  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080
  ripper:
    image: automaticrippingmachine/automatic-ripping-machine:Fix_for_issue_500_and_880
    restart: always
    environment:
      MYSQL_PASSWORD: example
      MYSQL_IP: "192.168.1.101"
      MYSQL_USER: root
      ARM_UID: 1001
      ARM_GID: 1001
      NVIDIA_DRIVER_CAPABILITIES: all
    ports:
      - 8880:8080
    volumes:
      - /home/arm:/home/arm
      - /home/arm/Music:/home/arm/Music
      - /home/arm/logs:/home/arm/logs
      - /home/arm/media:/home/arm/media
      - /etc/arm/config:/etc/arm/config
    devices:
      - /dev/sr0:/dev/sr0
      - /dev/sg4:/dev/sg4
    deploy:
      resources:
        reservations:
          devices:
            - driver: nvidia
              count: 1
              capabilities: [gpu]

Let me know of any problems, and thanks for testing!

1337-server avatar Jul 24 '23 06:07 1337-server

This docker compose should work above. I tested it and it worked without issue.

1337-server avatar Jul 24 '23 18:07 1337-server

Using this docker-compose.yml:

version: '2'

services:

  db:
    image: mysql
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: example
    ports:
      - 3306:3306
  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080
  ripper:
    image: automaticrippingmachine/automatic-ripping-machine:Fix_for_issue_500_and_880
    restart: always
    environment:
      MYSQL_PASSWORD: example
      MYSQL_IP: "<host ip address>"
      MYSQL_USER: root
    ports:
      - 8880:8080
    volumes:
      - /home/arm:/home/arm
      - /home/arm/Music:/home/arm/Music
      - /home/arm/logs:/home/arm/logs
      - /home/arm/media:/home/arm/media
      - /etc/arm/config:/etc/arm/config
    devices:
      - /dev/sr0:/dev/sr0

I got the following error any time I tried to bring up the app:

Traceback (most recent call last):
2023-07-26T03:17:06.860190877Z   File "/usr/local/lib/python3.8/dist-packages/mysql/connector/connection_cext.py", line 302, in _open_connection
2023-07-26T03:17:06.860199257Z     self._cmysql.connect(**cnx_kwargs)
2023-07-26T03:17:06.860205497Z _mysql_connector.MySQLInterfaceError: Unknown database 'arm'
2023-07-26T03:17:06.860211357Z 
2023-07-26T03:17:06.860216787Z The above exception was the direct cause of the following exception:
2023-07-26T03:17:06.860238798Z 
2023-07-26T03:17:06.860245968Z Traceback (most recent call last):
2023-07-26T03:17:06.860252068Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect
2023-07-26T03:17:06.860258288Z     return fn()
2023-07-26T03:17:06.860264308Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 310, in connect
2023-07-26T03:17:06.860271849Z     return _ConnectionFairy._checkout(self)
2023-07-26T03:17:06.860278209Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 868, in _checkout
2023-07-26T03:17:06.860284159Z     fairy = _ConnectionRecord.checkout(pool)
2023-07-26T03:17:06.860289959Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 476, in checkout
2023-07-26T03:17:06.860295629Z     rec = pool._do_get()
2023-07-26T03:17:06.860302409Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
2023-07-26T03:17:06.860309009Z     self._dec_overflow()
2023-07-26T03:17:06.860314640Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
2023-07-26T03:17:06.860320700Z     compat.raise_(
2023-07-26T03:17:06.860326620Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
2023-07-26T03:17:06.860333090Z     raise exception
2023-07-26T03:17:06.860338970Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
2023-07-26T03:17:06.860345170Z     return self._create_connection()
2023-07-26T03:17:06.860351100Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 256, in _create_connection
2023-07-26T03:17:06.860357550Z     return _ConnectionRecord(self)
2023-07-26T03:17:06.860363271Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 371, in __init__
2023-07-26T03:17:06.860369451Z     self.__connect()
2023-07-26T03:17:06.860375491Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 666, in __connect
2023-07-26T03:17:06.860381711Z     pool.logger.debug("Error on connect(): %s", e)
2023-07-26T03:17:06.860387991Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
2023-07-26T03:17:06.860394211Z     compat.raise_(
2023-07-26T03:17:06.860401331Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
2023-07-26T03:17:06.860408091Z     raise exception
2023-07-26T03:17:06.860413912Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
2023-07-26T03:17:06.860420002Z     self.dbapi_connection = connection = pool._invoke_creator(self)
2023-07-26T03:17:06.860435482Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 590, in connect
2023-07-26T03:17:06.860442732Z     return dialect.connect(*cargs, **cparams)
2023-07-26T03:17:06.860449342Z   File "/home/arm/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 597, in connect
2023-07-26T03:17:06.860455752Z     return self.dbapi.connect(*cargs, **cparams)
2023-07-26T03:17:06.860461703Z   File "/usr/local/lib/python3.8/dist-packages/mysql/connector/pooling.py", line 293, in connect
2023-07-26T03:17:06.860467943Z     return CMySQLConnection(*args, **kwargs)
2023-07-26T03:17:06.860473503Z   File "/usr/local/lib/python3.8/dist-packages/mysql/connector/connection_cext.py", line 128, in __init__
2023-07-26T03:17:06.860479783Z     self.connect(**kwargs)
2023-07-26T03:17:06.860485673Z   File "/usr/local/lib/python3.8/dist-packages/mysql/connector/abstracts.py", line 1217, in connect
2023-07-26T03:17:06.860492493Z     self._open_connection()
2023-07-26T03:17:06.860498373Z   File "/usr/local/lib/python3.8/dist-packages/mysql/connector/connection_cext.py", line 307, in _open_connection
2023-07-26T03:17:06.860505344Z     raise get_mysql_exception(
2023-07-26T03:17:06.860511534Z mysql.connector.errors.ProgrammingError: 1049 (42000): Unknown database 'arm'

shitwolfymakes avatar Jul 26 '23 03:07 shitwolfymakes

exception( 2023-07-26T03:17:06.860511534Z mysql.connector.errors.ProgrammingError: 1049 (42000): Unknown database 'arm'

You need to create the 'arm' database

1337-server avatar Jul 26 '23 05:07 1337-server

I've been working with this a lot but I cannot get it working. I've reset mysql docker and ARM docker to scratch. Any thing I'm missing? When I run the "pip3 install mysql-connector-python" it gives a message about root but it works.

File "", line 3, in add_column File "/usr/local/lib/python3.8/dist-packages/alembic/operations/ops.py", line 2119, in add_column return operations.invoke(op) File "/usr/local/lib/python3.8/dist-packages/alembic/operations/base.py", line 395, in invoke return fn(self, operation) File "/usr/local/lib/python3.8/dist-packages/alembic/operations/toimpl.py", line 154, in add_column operations.impl.add_column(table_name, column, schema=schema, **kw) File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/impl.py", line 322, in add_column self._exec(base.AddColumn(table_name, column, schema=schema)) File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/impl.py", line 193, in _exec return conn.execute( # type: ignore[call-overload] File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1412, in execute return meth( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 181, in _execute_on_connection return connection._execute_ddl( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1521, in _execute_ddl compiled = ddl.compile( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 280, in compile return self._compiler(dialect, **kw) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 69, in _compiler return dialect.ddl_compiler(dialect, self, **kw) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/compiler.py", line 866, in init self.string = self.process(self.statement, **compile_kwargs) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/compiler.py", line 911, in process return obj.compiler_dispatch(self, **kwargs) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/ext/compiler.py", line 493, in lambda *arg, **kw: existing(*arg, **kw), File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/ext/compiler.py", line 546, in call expr = fn(element, compiler, **kw) File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/base.py", line 190, in visit_add_column add_column(compiler, element.column, **kw), File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/base.py", line 324, in add_column text = "ADD COLUMN %s" % compiler.get_column_specification(column, **kw) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/dialects/mysql/base.py", line 1766, in get_column_specification self.dialect.type_compiler_instance.process( File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/compiler.py", line 956, in process return type._compiler_dispatch(self, **kw) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/visitors.py", line 143, in compiler_dispatch return meth(self, **kw) # type: ignore # noqa: E501 File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/compiler.py", line 7062, in visit_string return self.visit_VARCHAR(type, **kw) File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/dialects/mysql/base.py", line 2262, in visit_VARCHAR raise exc.CompileError( sqlalchemy.exc.CompileError: VARCHAR requires a length on dialect mysql

dbooher2011 avatar Jul 26 '23 16:07 dbooher2011

So, I tried it again. I'm running unraid and I figured out how to run composer instead of creating a template from scratch. After going through all steps, I can see in adminer that the database "arm" is getting 5 tables created. It doesn't seem like an issue connect from ARM to mysql. I'm still getting the same message above. I logged into the container for both, ARM and mysql to run the command "pip3 install mysql-connector-python" and get the following warning "WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv". On mysql, it installs but for ARM, it says that the "Requirement already satisficed". Going to the address:8880 will not load ARM. I'm assuming it doesn't load because of the VARCHAR error issue and "Starting web ui" never gets to run.

dbooher2011 avatar Jul 27 '23 04:07 dbooher2011

Still working on this… But ran into issues. Will update when i get it fixed.

1337-server avatar Aug 12 '23 03:08 1337-server