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 (Joseph Bernard)
   2. Re: Arpwalk, Macsuck or Discover not successful on some
      devices (Oliver Gorwits)
--- Begin Message ---
What OS are you running?  I’ve been using the following command to troubleshoot 
the pollers.  I’m sure it can be written better.

watch -n 1 "ps ax -o etime,command | grep nd2"


Thanks,
Joseph B.

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

Reply via email to