LinuxMCE Forums
General => Developers => Topic started by: l3mce on September 26, 2012, 05:17:59 am
-
mysql --user=root pluto_main
mysql> SELECT COUNT(*) FROM PnpQueue;
+----------+
| COUNT(*) |
+----------+
| 43744 |
+----------+
1 row in set (0.13 sec)
mysql> SELECT SerialNumber, COUNT(*) FROM PnpQueue GROUP by Category;
+-----------------------------------------------------------------------------------------------------------+----------+
| SerialNumber | COUNT(*) |
+-----------------------------------------------------------------------------------------------------------+----------+
| /org/freedesktop/Hal/devices/usb_device_10c4_ea60_0001_if0_serial_usb_0 | 159 |
| 67069bc7-70f4-4a6f-9711-fba06d83dbc3 | 26965 |
| /org/freedesktop/Hal/devices/computer_power_supply_ac_adapter_ACAD | 2 |
| /org/freedesktop/Hal/devices/pci_10de_774_sound_card_0_alsa_control__1 | 2849 |
| /org/freedesktop/Hal/devices/computer_power_supply_battery_BAT0 | 2 |
| /org/freedesktop/Hal/devices/storage_model_DVDR___PX_870A | 177 |
| /org/freedesktop/Hal/devices/pci_1106_3344_drm__null__card0 | 177 |
| /org/freedesktop/Hal/devices/pci_18c3_720_dvb | 429 |
| /org/freedesktop/Hal/devices/acpi_FAN | 153 |
| \\192.168.80.5 | 6 |
| \\00:24:a5:00:06:9d\release | 13 |
| /org/freedesktop/Hal/devices/computer_logicaldev_input | 3382 |
| /org/freedesktop/Hal/devices/pci_168c_1c_rfkill_phy0_wlan | 2 |
| /org/freedesktop/Hal/devices/computer_backlight | 2 |
| /org/freedesktop/Hal/devices/leds_mmc0 | 8 |
| /org/freedesktop/Hal/devices/pci_197b_2383_memstick_host | 2 |
| /org/freedesktop/Hal/devices/pci_197b_2382_mmc_host | 2 |
| /org/freedesktop/Hal/devices/net_00_14_bf_57_78_f0 | 650 |
| /org/freedesktop/Hal/devices/net_00_24_2c_57_aa_ed | 2 |
| /org/freedesktop/Hal/devices/net_computer_loopback | 480 |
| /org/freedesktop/Hal/devices/pci_10de_774_sound_card_0_oss_pcm_1 | 1851 |
| /org/freedesktop/Hal/devices/ppdev_parport0 | 318 |
| /org/freedesktop/Hal/devices/usb_device_4f9_21_G4J487953_if0_printer_noserial | 5 |
| /org/freedesktop/Hal/devices/acpi_CPU1 | 812 |
| /org/freedesktop/Hal/devices/usb_device_58f_6362_058F63626376_if0_scsi_host_scsi_device_lun0_scsi_generic | 1250 |
| /org/freedesktop/Hal/devices/usb_device_58f_6362_058F63626376_if0_scsi_host | 3293 |
| /org/freedesktop/Hal/devices/usb_device_403_6001_A9006rTc | 366 |
| /org/freedesktop/Hal/devices/pci_10de_774_sound_card_0 | 339 |
| /org/freedesktop/Hal/devices/usb_device_90c_c371_noserial_if0_video4linux | 2 |
| /org/freedesktop/Hal/devices/volume_uuid_D7E8_0778 | 46 |
+-----------------------------------------------------------------------------------------------------------+----------+
30 rows in set (0.21 sec)
That is a lot of useless crap in an install about a week old...
That UUID, for the record, is a hard drive I have told the system not to use on my core. I have changed StorageDevices_Radar.sh to not keep querying things that exist in Unknown Devices... but... why I have 3k alsa entries in a week... something is very wrong and I would like to fix it.
-
Install has been running for months and months.
http://pastebin.com/25m89ZR6
J.
-
Ugh... thanks.
We need to fix this. Badly.
-
http://pastebin.com/ktAMwn0H
2-3 week old install
-
http://pastebin.com/3jBDfNV7
Also 2 to 3 week old working install
-
Not as critical as the pastebin logs being shared but something I have found non-intuitive is a method for removing incorrect or unwanted metadata from the database. Before I learned my lesson I selected "also apply amazon metadata" when grabbing cover art, or didn't baby-sit ripping of compilation CDs. To correct these tags and get media searches and cover-art displays working as intended I have to spend a lot of time in the files and media sync area. Most of that time is spent scrolling through album/performer lists that want to include the name of the dog who sat outside the recording studio one time for 12 minutes.
I have not and probably will not attempt to change or remove database entries without an automagic button. Give me enough time and I can break my system with UI button presses, letting me get at the heart of the system (sqlCVS , pluto_main, etc) just speeds up the process and leaves me reinstalling instead of growing. If someone capable (not bus shoving here friend just an example) such as L3mce felt the desire to add some clean up scripts I imagine I would not be the only appreciative user.
-
Just a note: The PnP tables have nothing to do with UPnP...
-
/me facepalms
Yes... I see that now. I just sort of assumed... and the whatnot.
-
:)
-
Tell 'em you's gonna rawk their PnpQueue table, them womerns lahks that. --Unknown Hinson
-
http://pastebin.com/RNvZWmKE
my install is 8 wks old
-
http://pastebin.com/RNvZWmKE
my install is 8 wks old
Hmmmm...
I suddenly start to see things I recognize in different syntax...
/org/freedesktop/Hal/devices/pci_10de_774_sound_card_0_alsa_control__1 (mine)
10de is nVidia
/org/freedesktop/Hal/devices/pci_8086_2e20 (bushtech)
8086 is intel
/org/freedesktop/Hal/devices/pci_1002_5957 (phenigma)
/org/freedesktop/Hal/devices/pci_1002_5a14 (techstyle)
1002 is ATI...
Techstyle, can you please lspci -nnk | grep 5a14 and tell me if this reveals something similar to:
00:00.0 Host bridge [0600]: Advanced Micro Devices [AMD] nee ATI RD890 PCI to PCI bridge (external gfx0 port B) [1002:5a14] (rev 02)
Subsystem: ASRock Incorporation Device [1849:5a14]
bushtech... I am expecting you will need to lspci -nnk | grep 2e20 -A1 should say something akin to:
00:00.0 Host bridge [0600]: Intel Corporation 4 Series Chipset DRAM Controller [8086:2e20] (rev 03)
Subsystem: ASUSTeK Computer Inc. Device [1043:82d3]
phenigma... lspci -nnk | grep 5957 -A1 and something like:
00:00.0 Host bridge [0600]: ATI Technologies Inc RX780/RX790 Chipset Host Bridge [1002:5957]
Subsystem: ASUSTeK Computer Inc. Device [1043:8353]
davegravy... I have no effin clue what 5VP9V3VG is. But you seem to have it in spades. I would try grepping your system from root for both -ir 5vp9 and v3vg. Might also change your sql command to:
SELECT IPaddress, COUNT(*) FROM PnpQueue GROUP by Category; and see if that huge number shows up with an IP, though I doubt it.
Thanks guys. Hopefully I can figure out what these things all are, and how they get there, so that things which query the table can do so faster.
-
lspci -nnk | grep 2e20 -A1
00:00.0 Host bridge [0600]: Intel Corporation 4 Series Chipset DRAM Controller [8086:2e20] (rev 03)
Kernel modules: intel-agp
-
The same as yours until rd890 then it says:
Pci to pic bridge (external gfx0 port B) [1002:5a14] (rev 02)
-
00:00.0 Host bridge [0600]: ATI Technologies Inc RX780/RX790 Chipset Host Bridge [1002:5957]
Subsystem: ASUSTeK Computer Inc. Device [1043:8353]
No 'subsystem' quoted in mine.
http://pastebin.com/nL0PZM5f
J.