DB crash (free lists corrupted) during Rebuild Stock
Aldevinas Katkus
6-3-21
Operating system: Windows
Why the server crashes during Rebuild Stock maintenance when the second checkbox "Use item history records" is ticked after upgrading to 8.5 2021-04-18 (build 85360453)?

I can see in the log a connection to the smtp server is made after rebuild stock has started.
Shouldn't this maintenance block all incoming and outgoing connections during stock rebuilding?
Aldevinas Katkus
6-3-21
It looks like it has something to do with Optional features>>reconnect. I turned it off and no more crashes.
With Reconnect feature ON, our client experienced endless (at least 4 times in a row) Rebuild Stock maintenances:
The maintenance finishes and starts again after the user is reconnected:

2021-06-03 17:15:26 AVA Maintenance RebuildStockMn
2021-06-03 17:15:26 AVA Database set to unsafe (import and maintenance) mode
2021-06-03 17:15:26 AVA Database set to unsafe (import and maintenance) mode
2021-06-03 17:20:35 AVA Database set to safe (normal) mode, flushing cache...
2021-06-03 17:20:35 AVA Database set to safe (normal) mode, flushing cache...
2021-06-03 17:20:35 AVA GetThreadRepCancel() = true -- SendROData(): SendDataSV() Failed 2
...
2021-06-03 17:20:36 Database not in Live Mode
2021-06-03 17:20:36 SYSTEM Logoff 10.78.254.182:51595: the client closed the connection (2)
2021-06-03 17:20:36 AVA Login @10.78.254.182 << automatic reconnect

2021-06-03 17:20:37 AVA Maintenance RebuildStockMn < 2021-06-03 17:20:37 AVA Database set to unsafe (import and maintenance) mode
2021-06-03 17:20:37 AVA Database set to unsafe (import and maintenance) mode
David Delač
6-10-21
Hi Aldevinas,

Can you please report this bug with backup where we can repeat the issue?

Best Regards,
David Delač
Aldevinas Katkus
7-9-21
it Should be a quite big DB for Rebuild Stock to last more than 5 minutes. I do not think it possible.
I think you may create some test maintenance which exits after running for 6 mins. Not tested this idea.
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Hello, Kindly please report the bug so that we can further investigate and resolve it. Thank you. Best regards, Benjamin...
11:31 3 May 2024
Hi, No changes should have been made that would increase client&apos;s HDB file. Please try to delete HANSA.HDB from client folder and reconnect to server and check if it will grow to 30MB again. ...
10:14 30 Apr 2024