Author Topic: PnpQueue... it disturbs me. Please run a couple of commands.  (Read 10550 times)

l3mce

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1084
    • View Profile
PnpQueue... it disturbs me. Please run a couple of commands.
« 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.
« Last Edit: September 26, 2012, 03:10:23 pm by l3mce »
I never quit... I just ping out.

phenigma

  • LinuxMCE God
  • ****
  • Posts: 1758
    • View Profile
Re: Upnp... it disturbs me. Please run a couple of commands.
« Reply #1 on: September 26, 2012, 05:39:59 am »
Install has been running for months and months.

http://pastebin.com/25m89ZR6

J.

l3mce

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1084
    • View Profile
Re: Upnp... it disturbs me. Please run a couple of commands.
« Reply #2 on: September 26, 2012, 05:49:31 am »
Ugh... thanks.

We need to fix this. Badly.
I never quit... I just ping out.

davegravy

  • Addicted
  • *
  • Posts: 551
    • View Profile
Re: Upnp... it disturbs me. Please run a couple of commands.
« Reply #3 on: September 26, 2012, 06:02:12 am »
http://pastebin.com/ktAMwn0H

2-3 week old install

bushtech

  • Veteran
  • ***
  • Posts: 98
    • View Profile
Re: Upnp... it disturbs me. Please run a couple of commands.
« Reply #4 on: September 26, 2012, 09:01:10 am »
http://pastebin.com/3jBDfNV7

Also 2 to 3 week old working install
Core:Asus P8H77-V, Intel core i3-3240 LGA155, Inno 3D Nvidia 240 GT (DVI+VGA+HDMI), 4Gb ram, 125Gb SSD
MD: Zotax Zbox ID41

Armor Gnome

  • Guru
  • ****
  • Posts: 309
    • View Profile
Re: Upnp... it disturbs me. Please run a couple of commands.
« Reply #5 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.
I made a wiki!  Click here to check out my system.

Marie.O

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3675
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: Upnp... it disturbs me. Please run a couple of commands.
« Reply #6 on: September 26, 2012, 01:36:12 pm »
Just a note: The PnP tables have nothing to do with UPnP...

l3mce

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1084
    • View Profile
Re: PnpQueue... it disturbs me. Please run a couple of commands.
« Reply #7 on: September 26, 2012, 03:11:24 pm »
* l3mce facepalms


Yes... I see that now. I just sort of assumed... and the whatnot.
I never quit... I just ping out.

Marie.O

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 3675
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: PnpQueue... it disturbs me. Please run a couple of commands.
« Reply #8 on: September 26, 2012, 06:41:44 pm »
:)

tschak909

  • LinuxMCE God
  • ****
  • Posts: 5549
  • DOES work for LinuxMCE.
    • View Profile
Re: PnpQueue... it disturbs me. Please run a couple of commands.
« Reply #9 on: September 26, 2012, 09:18:57 pm »
Tell 'em you's gonna rawk their PnpQueue table, them womerns lahks that. --Unknown Hinson

Techstyle

  • Addicted
  • *
  • Posts: 674
    • View Profile
    • Techstyle UK Ltd.
Re: PnpQueue... it disturbs me. Please run a couple of commands.
« Reply #10 on: September 30, 2012, 10:52:34 pm »
http://pastebin.com/RNvZWmKE

my install is 8 wks old

l3mce

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1084
    • View Profile
Re: PnpQueue... it disturbs me. Please run a couple of commands.
« Reply #11 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.
« Last Edit: October 01, 2012, 04:16:05 am by l3mce »
I never quit... I just ping out.

bushtech

  • Veteran
  • ***
  • Posts: 98
    • View Profile
Re: PnpQueue... it disturbs me. Please run a couple of commands.
« Reply #12 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
Core:Asus P8H77-V, Intel core i3-3240 LGA155, Inno 3D Nvidia 240 GT (DVI+VGA+HDMI), 4Gb ram, 125Gb SSD
MD: Zotax Zbox ID41

Techstyle

  • Addicted
  • *
  • Posts: 674
    • View Profile
    • Techstyle UK Ltd.
Re: PnpQueue... it disturbs me. Please run a couple of commands.
« Reply #13 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)

phenigma

  • LinuxMCE God
  • ****
  • Posts: 1758
    • View Profile
Re: PnpQueue... it disturbs me. Please run a couple of commands.
« Reply #14 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.