NeDi Community

NeDi Software Specific => Discovery => Topic started by: Son-Mac on March 11, 2019, 05:17:09 PM

Title: RE Parrallel Discoverys and Database Lock issues
Post by: Son-Mac on March 11, 2019, 05:17:09 PM
In regard to this post:
https://forum.nedi.ch/index.php?topic=1841.msg7417#msg7417 (https://forum.nedi.ch/index.php?topic=1841.msg7417#msg7417)

I still got a similar or the same problem with using version 1.7
Code: [Select]
DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction at /var/nedi/inc/libdb.pm line 1227
So how was that problem fixed? Or does anyone know how to fix that problem?


The highest amount of parallel discovery’s is 4 scans.
Title: Re: RE Parrallel Discoverys and Database Lock issues
Post by: rickli on March 11, 2019, 07:53:57 PM
This has been improved in 1.8 and 1.9. One of the biggest issues was slow DNS reverse lookups. You can try with -n1 to see, if that makes a difference...
Title: Re: RE Parrallel Discoverys and Database Lock issues
Post by: Son-Mac on March 12, 2019, 04:59:48 PM
Thank you for the quick reply ;D
I changed it in the start program and for now it works.
But that also happened in the past so I will observe it for some weeks and post whether it works. ::)
Title: Re: RE Parrallel Discoverys and Database Lock issues
Post by: Son-Mac on March 25, 2019, 11:04:15 AM
Hello everyone,
for now, it does not solve the problem. There are still errors in the MySQL Database, but less than before

But I think there is also another Problem with my rrd-Graphs because of which they are not population.
So I will troubleshoot further, and create a new post.

Thanks for the support.