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 (Tobias Gerlach)
2. Re: Arpwalk, Macsuck or Discover not successful on some
devices (Charlie Butera)
3. Re: Arpwalk, Macsuck or Discover not successful on some
devices (Oliver Gorwits)
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
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/
--- End Message ---
--- Begin Message ---
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/
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
