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 ---
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
