LinuxMCE Forums

General => Developers => Topic started by: l3mce on September 26, 2012, 05:17:59 am

Title: PnpQueue... it disturbs me. Please run a couple of commands.
Post 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.
Title: Re: Upnp... it disturbs me. Please run a couple of commands.
Post by: phenigma on September 26, 2012, 05:39:59 am
Install has been running for months and months.

http://pastebin.com/25m89ZR6

J.
Title: Re: Upnp... it disturbs me. Please run a couple of commands.
Post by: l3mce on September 26, 2012, 05:49:31 am
Ugh... thanks.

We need to fix this. Badly.
Title: Re: Upnp... it disturbs me. Please run a couple of commands.
Post by: davegravy on September 26, 2012, 06:02:12 am
http://pastebin.com/ktAMwn0H

2-3 week old install
Title: Re: Upnp... it disturbs me. Please run a couple of commands.
Post by: bushtech on September 26, 2012, 09:01:10 am
http://pastebin.com/3jBDfNV7

Also 2 to 3 week old working install
Title: Re: Upnp... it disturbs me. Please run a couple of commands.
Post by: Armor Gnome on September 26, 2012, 12:07:05 pm
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.
Title: Re: Upnp... it disturbs me. Please run a couple of commands.
Post by: Marie.O on September 26, 2012, 01:36:12 pm
Just a note: The PnP tables have nothing to do with UPnP...
Title: Re: PnpQueue... it disturbs me. Please run a couple of commands.
Post by: l3mce on September 26, 2012, 03:11:24 pm
/me facepalms


Yes... I see that now. I just sort of assumed... and the whatnot.
Title: Re: PnpQueue... it disturbs me. Please run a couple of commands.
Post by: Marie.O on September 26, 2012, 06:41:44 pm
:)
Title: Re: PnpQueue... it disturbs me. Please run a couple of commands.
Post by: tschak909 on September 26, 2012, 09:18:57 pm
Tell 'em you's gonna rawk their PnpQueue table, them womerns lahks that. --Unknown Hinson
Title: Re: PnpQueue... it disturbs me. Please run a couple of commands.
Post by: Techstyle on September 30, 2012, 10:52:34 pm
http://pastebin.com/RNvZWmKE

my install is 8 wks old
Title: Re: PnpQueue... it disturbs me. Please run a couple of commands.
Post by: l3mce on October 01, 2012, 03:14:46 am
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:
Code: [Select]
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:
Code: [Select]
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:
Code: [Select]
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.
Title: Re: PnpQueue... it disturbs me. Please run a couple of commands.
Post by: bushtech on October 01, 2012, 12:20:42 pm
 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
Title: Re: PnpQueue... it disturbs me. Please run a couple of commands.
Post by: Techstyle on October 01, 2012, 01:10:47 pm
The same as yours until rd890 then it says:

Pci to pic bridge (external gfx0 port B) [1002:5a14] (rev 02)
Title: Re: PnpQueue... it disturbs me. Please run a couple of commands.
Post by: phenigma on October 03, 2012, 11:21:02 pm

Code: [Select]
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.