brisimmons105

I can't view the UI anymore out of nowhere. Not sure what is going on, this error appears in my logs. Anyone know what is going on? 2024-02-22 14:37:34 - ERROR :: MainThread : Tautulli Database :: Database error: ambiguous column name: on_pause 2024-02-22 14:37:34 - ERROR :: MainThread : Uncaught exception: Traceback (most recent call last): File "/app/tautulli/Tautulli.py", line 324, in <module> main() File "/app/tautulli/Tautulli.py", line 247, in main plexpy.start() File "/app/tautulli/plexpy/__init__.py", line 572, in start notifiers.check_browser_enabled() File "/app/tautulli/plexpy/notifiers.py", line 4484, in check_browser_enabled for n in get_notifiers(): ^^^^^^^^^^^^^^^ File "/app/tautulli/plexpy/notifiers.py", line 510, in get_notifiers result = db.select( ^^^^^^^^^^ File "/app/tautulli/plexpy/database.py", line 455, in select sql_results = self.action(query, args).fetchall() ^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/tautulli/plexpy/database.py", line 433, in action sql_result = c.execute(query, args) ^^^^^^^^^^^^^^^^^^^^^^ sqlite3.OperationalError: ambiguous column name: on_pause Traceback (most recent call last): File "/app/tautulli/Tautulli.py", line 324, in <module> main() File "/app/tautulli/Tautulli.py", line 247, in main plexpy.start() File "/app/tautulli/plexpy/__init__.py", line 572, in start notifiers.check_browser_enabled() File "/app/tautulli/plexpy/notifiers.py", line 4484, in check_browser_enabled for n in get_notifiers(): ^^^^^^^^^^^^^^^ File "/app/tautulli/plexpy/notifiers.py", line 510, in get_notifiers result = db.select( ^^^^^^^^^^ File "/app/tautulli/plexpy/database.py", line 455, in select sql_results = self.action(query, args).fetchall() ^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/tautulli/plexpy/database.py", line 433, in action sql_result = c.execute(query, args) ^^^^^^^^^^^^^^^^^^^^^^ sqlite3.OperationalError: ambiguous column name: on_pause

Thanks, I'm actually moving from Disk 2 (very full) to Disk 5 (almost Empty). No smarty warnings on any drives.

I'm moving files between two disks and my krusader speeds are all over the place. Sometimes it's transferring at 175MBs then it slows down to a crawl, occasionally stalling then starting back up again. Any ideas what could be happening? I've attached my diagnostics if that helps. tower-diagnostics-20191205-1824.zip

I've got a stupid question...I've recently added a few new disks to my array and I'm trying to move some files from my full disk 1 to my empty disk 2. When using Krusader I just want to move the data from /mnt/disk1 to /mnt/disk2 correct? I don't want to mess with the user share directories at all, right?

Thanks! Any idea if this type will work?

Thanks testdasi. They are 3.5" HDD. Any particular brands for the MOLEX to SATA?

I purchased a new power supply a few years back that came with 6 SATA power cables, which are now used up. I want to add a few new drives, so I was wondering what the best way to do that would be. I have 3 molex cables from the power supply that I can get a SATA connector for, or should I buy a splitter for the SATA cables and extend them that way? The PS is 500 Watts which should have no issues handling the load, I'm just out of cables. Thanks!

Thanks for the advice. Looks like I'm back in action now.

Hate to be a nuisance, but is anyone able to take a look at this? Thanks!

I recently updated my SAB docker after a few weeks of ignoring it and now the webUI won't load. I've attached my log file, anyone have any ideas? log.txt

Wow. I had this spiderweb of incorrect docker setups that actually made everything work. Sonarr was never setup to see the SAB downloads properly, but because SAB was applying categories to everything sonarr pushed into it (from the indexers), SAB moved it into a place sonarr could find it, completely on accident, and then sonarr was renaming and moving it. Thanks for the clarification! I have seen the light.

Thanks jonathanm. So forgive me if I'm missing something, but Host Path 2 for radar is "container path: /downloads" and that's where it should look for the completed downloads. In the sonarr config (according to the config overview), the "/data" folder is where it should look for the downloads folder. Both the "container path: /downloads" and the "/data" folders are pointing to the same path "/mnt/cache/Media/" What's even weirder is that "/mnt/cache/Dockers/SAB/Downloads/complete" is where SAB actually puts the completed downloads...Somehow sonarr is still able to pickup the files and move them though even though that directory is not mapped.

So, I’m getting the “No files found are eligible for import in /config/Downloads/complete/“ message for everything Radarr is trying to rename & move from SAB. I’m sure its my hosts and paths but I can’t seem to figure it out.. What’s funny is that Sonarr is setup the exact same way and it works fine. Here are screen shots of my setup for Radarr, SAB, and Sonarr, does anyone mind taking a look? Thanks!

Somehow the preferences file got corrupt. Just deleted it and recreated anew one on startup and all is well. Thanks for all your help.

Thanks I'll try that...its asking if I want to remove the image also, is that a no? Sorry I don't remember getting asked that last time I did this...

Ugh. Thanks - also, I seem to have messed something else up. While troubleshooting, I checked the privileged box to see if that would fix it (it didn't), and then I unchecked it. Now that I unchecked it, my server won't even show up. Browser and devices won't pull it up at all. Any clue as to what may have happened?

Here are screenshots. The one just called 'plex' is the new linuxserver.io version.

I just migrated from the 'official' lime tech plex docker to this one and flex is now having trouble playing/finding my media. I copied my old plex application support folder to the new instance and it pulled all my metadata and settings over, which is great, but when I try to play a movie its telling me the media is not available. My docker setting are: PUID 99 PGID 100 VERSION: public media: /mnt/user/Media/ (Same as before) Any idea why its not working?

Just ran pre-clear via the plugin on a new seagate 2TB...everything look okay here? ================================================================== 1.15 = unRAID server Pre-Clear disk /dev/sdg = cycle 1 of 1, partition start on sector 64 = Disk Pre-Clear-Read completed DONE = Step 1 of 10 - Copying zeros to first 2048k bytes DONE = Step 2 of 10 - Copying zeros to remainder of disk to clear it DONE = Step 3 of 10 - Disk is now cleared from MBR onward. DONE = Step 4 of 10 - Clearing MBR bytes for partition 2,3 & 4 DONE = Step 5 of 10 - Clearing MBR code area DONE = Step 6 of 10 - Setting MBR signature bytes DONE = Step 7 of 10 - Setting partition 1 to precleared state DONE = Step 8 of 10 - Notifying kernel we changed the partitioning DONE = Step 9 of 10 - Creating the /dev/disk/by* entries DONE = Step 10 of 10 - Verifying if the MBR is cleared. DONE = Disk Post-Clear-Read completed DONE Disk Temperature: 35C, Elapsed Time: 16:15:26 ========================================================================1.15 == ST2000DM001-1ER164 Z5601NS2 == Disk /dev/sdg has been successfully precleared == with a starting sector of 64 ============================================================================ ** Changed attributes in files: /tmp/smart_start_sdg /tmp/smart_finish_sdg ATTRIBUTE NEW_VAL OLD_VAL FAILURE_THRESHOLD STATUS RAW_VALUE Raw_Read_Error_Rate = 117 100 6 ok 154923144 Spin_Retry_Count = 100 100 97 near_thresh 0 End-to-End_Error = 100 100 99 near_thresh 0 Airflow_Temperature_Cel = 65 76 45 near_thresh 35 Temperature_Celsius = 35 24 0 ok 35 No SMART attributes are FAILING_NOW 0 sectors were pending re-allocation before the start of the preclear. 0 sectors were pending re-allocation after pre-read in cycle 1 of 1. 0 sectors were pending re-allocation after zero of disk in cycle 1 of 1. 0 sectors are pending re-allocation at the end of the preclear, the number of sectors pending re-allocation did not change. 0 sectors had been re-allocated before the start of the preclear. 0 sectors are re-allocated at the end of the preclear, the number of sectors re-allocated did not change. root@Tower:/usr/local/emhttp#

Just wanted to make sure these results are okay. Nothing popped out at me so I'm hoping everything is good. I did 2 cycles using the plugin. ================================================================== 1.15 = unRAID server Pre-Clear disk /dev/sdf = cycle 2 of 2, partition start on sector 64 = = Step 1 of 10 - Copying zeros to first 2048k bytes DONE = Step 2 of 10 - Copying zeros to remainder of disk to clear it DONE = Step 3 of 10 - Disk is now cleared from MBR onward. DONE = Step 4 of 10 - Clearing MBR bytes for partition 2,3 & 4 DONE = Step 5 of 10 - Clearing MBR code area DONE = Step 6 of 10 - Setting MBR signature bytes DONE = Step 7 of 10 - Setting partition 1 to precleared state DONE = Step 8 of 10 - Notifying kernel we changed the partitioning DONE = Step 9 of 10 - Creating the /dev/disk/by* entries DONE = Step 10 of 10 - Verifying if the MBR is cleared. DONE = Disk Post-Clear-Read completed DONE Disk Temperature: 38C, Elapsed Time: 26:58:16 ========================================================================1.15 == ST2000DM001-1ER164 Z4Z3MYP1 == Disk /dev/sdf has been successfully precleared == with a starting sector of 64 ============================================================================ ** Changed attributes in files: /tmp/smart_start_sdf /tmp/smart_finish_sdf ATTRIBUTE NEW_VAL OLD_VAL FAILURE_THRESHOLD STATUS RAW_VALUE Raw_Read_Error_Rate = 119 100 6 ok 208315656 Spin_Retry_Count = 100 100 97 near_thresh 0 End-to-End_Error = 100 100 99 near_thresh 0 High_Fly_Writes = 99 100 0 ok 1 Airflow_Temperature_Cel = 62 65 45 near_thresh 38 Temperature_Celsius = 38 35 0 ok 38 No SMART attributes are FAILING_NOW 0 sectors were pending re-allocation before the start of the preclear. 0 sectors were pending re-allocation after pre-read in cycle 1 of 2. 0 sectors were pending re-allocation after zero of disk in cycle 1 of 2. 0 sectors were pending re-allocation after post-read in cycle 1 of 2. 0 sectors were pending re-allocation after zero of disk in cycle 2 of 2. 0 sectors are pending re-allocation at the end of the preclear, the number of sectors pending re-allocation did not change. 0 sectors had been re-allocated before the start of the preclear. 0 sectors are re-allocated at the end of the preclear, the number of sectors re-allocated did not change. root@Tower:/usr/local/emhttp#

I am in the middle of formatting my 4th disk (to use as a cache) and when I started the preclear, I think I got a different response form the other three. Here is what it said: Do I need to do something different? Its a 1TB Lacie... Pre-Clear unRAID Disk /dev/sda ################################################################## 1.14 smartctl may not be able to run on /dev/sda with the -d ata option. however this should not affect the clearing of a disk. smartctl exit status = 2 smartctl 6.2 2013-07-26 r3841 [i686-linux-3.9.11p-unRAID] (local build) Copyright © 2002-13, Bruce Allen, Christian Franke, www.smartmontools.org Read Device Identity failed: Invalid argument A mandatory SMART command failed: exiting. To continue, add one or more '-T permissive' options.$ Do you wish to continue? (Answer Yes to continue. Capital 'Y', lower case 'es'): Yes WARNING: GPT (GUID Partition Table) detected on '/dev/sda'! The util fdisk doesn't support GPT. Use GNU Parted. Disk /dev/sda: 1000.2 GB, 1000204886016 bytes 255 heads, 63 sectors/track, 121601 cylinders, total 1953525168 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000 Device Boot Start End Blocks Id System /dev/sda1 1 1953525167 976762583+ ee GPT ######################################################################## invoked as ./preclear_disk.sh /dev/sda ######################################################################## (partition starting on sector 63) (it will not be 4k-aligned) Are you absolutely sure you want to clear this drive? (Answer Yes to continue. Capital 'Y', lower case 'es'): Yes