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
David Delač
Hi Piotr, The log entry:
2024-12-14 08:40:43 0.000 CallHal(IsHansaWorldCustomer) appears because the server is running with the verbosity=debug-detailed setting in its parameters.txt file. Thi...
09:43 16 Dec 2024
Brittany McGrath
Hi Vaughn, I can confirm this has been fixed now and is live in Standard ERP 2024-11-20 Version: 85556786. Thank you. ...
10:04 10 Dec 2024