Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Arpwalk, Macsuck or Discover not successful on some
devices (Pavel Skovajsa)
--- Begin Message ---
bump
On Mon, Oct 7, 2019 at 6:39 PM Pavel Skovajsa <[email protected]>
wrote:
> Hello,
>
> I think we have the same issue - the jobs haven't finished since the
> upgrade to 2.44.0. Last week I deleted all the job (using the web frontend
> trash bin icon). Poller performance only shows nbtstat job completed,
> nothing else is there since the update. The output for the slow queries and
> running queries is on https://pastebin.com/LPtEDD6h.
>
> On the other side, it looks like it is really working, because things are
> working based on the output below:
> query result
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '2 hours') AND (CURRENT_TIMESTAMP -
> interval '1 hours')); 1809
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '3 hours') AND (CURRENT_TIMESTAMP -
> interval '2 hours')); 1856
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '4 hours') AND (CURRENT_TIMESTAMP -
> interval '3 hours')); 1815
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '5 hours') AND (CURRENT_TIMESTAMP -
> interval '4 hours')); 1932
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '6 hours') AND (CURRENT_TIMESTAMP -
> interval '5 hours')); 712
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '7 hours') AND (CURRENT_TIMESTAMP -
> interval '6 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '8 hours') AND (CURRENT_TIMESTAMP -
> interval '7 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '9 hours') AND (CURRENT_TIMESTAMP -
> interval '8 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '10 hours') AND (CURRENT_TIMESTAMP -
> interval '9 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_discover
> BETWEEN (CURRENT_TIMESTAMP - interval '11 hours') AND (CURRENT_TIMESTAMP -
> interval '10 hours')); 0
>
>
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '2 hours') AND (CURRENT_TIMESTAMP -
> interval '1 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '3 hours') AND (CURRENT_TIMESTAMP -
> interval '2 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '4 hours') AND (CURRENT_TIMESTAMP -
> interval '3 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '5 hours') AND (CURRENT_TIMESTAMP -
> interval '4 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '6 hours') AND (CURRENT_TIMESTAMP -
> interval '5 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '7 hours') AND (CURRENT_TIMESTAMP -
> interval '6 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '8 hours') AND (CURRENT_TIMESTAMP -
> interval '7 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '9 hours') AND (CURRENT_TIMESTAMP -
> interval '8 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '10 hours') AND (CURRENT_TIMESTAMP -
> interval '9 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '11 hours') AND (CURRENT_TIMESTAMP -
> interval '10 hours')); 1066
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '12 hours') AND (CURRENT_TIMESTAMP -
> interval '11hours')); 2021
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '13 hours') AND (CURRENT_TIMESTAMP -
> interval '12 hours')); 1957
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '14 hours') AND (CURRENT_TIMESTAMP -
> interval '13 hours')); 1913
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '15 hours') AND (CURRENT_TIMESTAMP -
> interval '14 hours')); 1972
> select count(name) from device where vendor = 'cisco' AND (last_macsuck
> BETWEEN (CURRENT_TIMESTAMP - interval '16 hours') AND (CURRENT_TIMESTAMP -
> interval '15 hours')); 237
>
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '2 hours') AND (CURRENT_TIMESTAMP -
> interval '1 hours')); 2010
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '3 hours') AND (CURRENT_TIMESTAMP -
> interval '2 hours')); 2271
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '4 hours') AND (CURRENT_TIMESTAMP -
> interval '3 hours')); 1301
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '5 hours') AND (CURRENT_TIMESTAMP -
> interval '4 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '6 hours') AND (CURRENT_TIMESTAMP -
> interval '5 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '7 hours') AND (CURRENT_TIMESTAMP -
> interval '6 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '8 hours') AND (CURRENT_TIMESTAMP -
> interval '7 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '9 hours') AND (CURRENT_TIMESTAMP -
> interval '8 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '10 hours') AND (CURRENT_TIMESTAMP -
> interval '9 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '11 hours') AND (CURRENT_TIMESTAMP -
> interval '10 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '12 hours') AND (CURRENT_TIMESTAMP -
> interval '11hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '13 hours') AND (CURRENT_TIMESTAMP -
> interval '12 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '14 hours') AND (CURRENT_TIMESTAMP -
> interval '13 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '15 hours') AND (CURRENT_TIMESTAMP -
> interval '14 hours')); 0
> select count(name) from device where vendor = 'cisco' AND (last_arpnip
> BETWEEN (CURRENT_TIMESTAMP - interval '16 hours') AND (CURRENT_TIMESTAMP -
> interval '15 hours')); 0
> netdisco=> select action,status,count (job) from admin group by
> action,status;
> action | status | count
> -------------+---------------------------+--------
> arpnip | done | 51663
> arpnip | queued | 248
> arpwalk | done | 6
> discover | done | 36793
> discover | error | 6635
> discover | info | 5
> discover | queued | 4076
> discoverall | done | 3
> expire | done | 4
> macsuck | done | 46684
> macsuck | queued | 299
> macsuck | queued-mdnetdisco | 2
> macwalk | done | 4
> nbtstat | done | 105197
> nbtstat | queued | 303
> nbtwalk | done | 9
> (16 rows)
>
> -pavel
>
> On Sat, Oct 5, 2019 at 1:17 PM Oliver Gorwits <[email protected]> wrote:
>
>> It would be interesting to know what the backend server process table
>>> shows when the workers are not progressing. Output of ps should show what
>>> the workers are doing.
>>>
>>> Also, here is a way to show active queries against a database and at the
>>> same time I wonder if running this will show some blockage somewhere:
>>>
>>> -- show running queries (pre 9.2)
>>> SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
>>> FROM pg_stat_activity
>>> WHERE current_query != '<IDLE>' AND current_query NOT ILIKE
>>> '%pg_stat_activity%'
>>> ORDER BY query_start desc;
>>>
>>> -- show running queries (9.2)
>>> SELECT pid, age(clock_timestamp(), query_start), usename, query
>>> FROM pg_stat_activity
>>> WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
>>> ORDER BY query_start desc;
>>>
>>> —- long running (9.2)
>>>
>>> SELECT now() - query_start as "runtime", usename, datname, waiting, state,
>>> query
>>>
>>> FROM pg_stat_activity
>>> WHERE now() - query_start > '2 minutes'::interval
>>> ORDER BY runtime DESC;
>>>
>>>
>>> Regards
>>> Oliver.
>>>
>>>
>>> On Fri, 4 Oct 2019 at 18:03, Charlie Butera via netdisco-users <
>>> [email protected]> wrote:
>>>
>>>> I had to restart the backend after running ./bin/netdisco-do psql -e
>>>> 'DELETE FROM admin'
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *Charles Butera*
>>>>
>>>> *Network Engineer*
>>>>
>>>> [email protected] <[email protected]>
>>>>
>>>> Squarespace
>>>>
>>>> Squarespace.com
>>>>
>>>>
>>>> On Fri, Oct 4, 2019 at 8:57 AM Tobias Gerlach <[email protected]>
>>>> wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> I'm facing the same issue after a fresh new installation of Netdisco
>>>>> 2.44.1. This is my environment:
>>>>>
>>>>> App::Netdisco 2.44.1
>>>>> SNMP::Info 3.68
>>>>> DB Schema 60
>>>>> PostgreSQL 11.00.5
>>>>> Perl 5.16.3
>>>>>
>>>>> Happens in my case on a lot of devices, not just a few. The stuck jobs
>>>>> doesn't finish after even days. This is quite odd. On my old server a full
>>>>> discovery (~12.000 devices) finished after 2-3 hours.
>>>>> I've removed all entries from the admin table already
>>>>> (./bin/netdisco-do psql -e 'DELETE FROM admin').
>>>>>
>>>>> Regards,
>>>>> Tobias
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Netdisco mailing list
>>>>> [email protected]
>>>>> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>>>>
>>>> _______________________________________________
>>>> Netdisco mailing list
>>>> [email protected]
>>>> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>>>
>>> _______________________________________________
>> Netdisco mailing list
>> [email protected]
>> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
>
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
