Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
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
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Searching with negative result very slow (Pavel Skovajsa)
--- Begin Message ---
Hello,
thanks for pointing me the right direction! Turns out I had many search
domain suffixes in my server DNS settings and many of them stopped
existing. I removed most of them and it is all working great now.
Regards,
-pavel
On Sat, Sep 16, 2023 at 4:50 PM Oliver Gorwits <oli...@cpan.org> wrote:
> Hi Pavel
>
> Unfortunately I can't reproduce this with any simple tests.
>
> Given the amount of time the search takes, I wonder if it's DNS related,
> like there's some strange setting forcing long DNS lookup timeout on the
> name. Just an idea. Normally Netdisco sets quite aggressive/low DNS
> timeouts so you don't notice failed results.
>
> If you can run the web frontend in the foreground you can trace the work
> it does and the SQL:
>
> DBIC_TRACE=1 ~/bin/localenv starman bin/netdisco-web-fg --workers=1
> --disable-keepalive
>
> regards
> Oliver.
>
> On Sat, 16 Sept 2023 at 07:18, Pavel Skovajsa <pavel.skova...@gmail.com>
> wrote:
>
>> Hello,
>>
>> for some time now (must be at least 2 months now) we noticed everytime we
>> search for something that does not exist, it takes long time for Netdisco
>> to provide the answer. In the example in the screenshot below, it took 42s
>> for the query to respond.
>>
>> All search queries that actually have a positive answer are very fast,
>> almost instant. Can you help us troubleshoot this? We do not even know
>> where to start, we are thinking the search is waiting for some SQL query to
>> finish, but no idea how to isolate it, there are lot of queries fired
>> during the search.
>>
>> Thanks,
>> Pavel
>> ///////////////////////////////////////////////
>> Version and stats info:
>> 8,471 devices with 27,365 IPs
>> 376,286 interfaces of which 140,158 are up
>> 11,457 layer 2 links between devices
>> 316,391 nodes logged, of which 185,836 are active
>> 181,565 IPs logged, of which 131,557 are active
>>
>> Software Version
>> App::Netdisco 2.64.1
>> SNMP::Info 3.94
>> DB Schema 81
>> PostgreSQL 15.00.3
>> Perl 5.30.0
>>
>> Screenshot:
>>
>> _______________________________________________
>> Netdisco mailing list
>> netdisco-users@lists.sourceforge.net
>> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
>
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
