Welcome, Guest. Please login or register.

Author Topic: RE Parrallel Discoverys and Database Lock issues  (Read 2250 times)

Son-Mac

  • Newbie
  • *
  • Posts: 3
    • View Profile
RE Parrallel Discoverys and Database Lock issues
« on: March 11, 2019, 05:17:09 pm »
In regard to this post:
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.
« Last Edit: March 11, 2019, 05:56:32 pm by Son-Mac »

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2901
    • View Profile
    • NeDi
Re: RE Parrallel Discoverys and Database Lock issues
« Reply #1 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...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

Son-Mac

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: RE Parrallel Discoverys and Database Lock issues
« Reply #2 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. ::)

Son-Mac

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: RE Parrallel Discoverys and Database Lock issues
« Reply #3 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.