DB crash during Stock Rebuild
Aldevinas Katkus
4-24-20
Operating system: Windows
Customer tried to run rebuild stock maintenance in client server mode and it crashed the database (--skip-free-lists did not help to start the server).
Any ideas why this happened?
2020-04-23 12:12:00 /THREAD(5) *** Uploading backup D:\Backup\TB-2020-04-03.TXT to cloud storage ***
2020-04-23 12:12:09 ALGI Apdorojimas RebuildStockMn
2020-04-23 12:12:09 ALGI Database set to unsafe (import and maintenance) mode
2020-04-23 12:12:10 ALGI requeueing
2020-04-23 12:12:11 /THREAD(5) Error: Failed registering upload job
2020-04-23 12:12:11 ALGI Database set to unsafe (import and maintenance) mode
2020-04-23 12:13:11 /THREAD(5) Duomenų bazė: gp->D4recoveryMode!=kTransactionModeSafe
2020-04-23 12:13:13 Windows Service version
2020-04-23 12:13:13 Starting application...
2020-04-23 12:13:13 20547 cache sectors added
2020-04-23 12:13:13 16384 hash table entries added

2020-04-23 12:13:13 *** running with new mail receiving and parsing ***
2020-04-23 12:13:13 *** Using LRU Replacement ***
2020-04-23 12:13:13 Ankstesnis veiksmas nebuvo reikiamai užbaigtas
2020-04-23 12:13:13 *** using a freelist to keep track of free space ***
2020-04-23 12:13:13 *******************************************************************
2020-04-23 12:13:13 *******************************************************************
2020-04-23 12:13:13 *******************************************************************
2020-04-23 12:13:13 *******************************************************************
2020-04-23 12:13:13 **** ****
2020-04-23 12:13:13 **** WARNING WARNING WARNING ****
2020-04-23 12:13:13 **** WARNING WARNING WARNING ****
2020-04-23 12:13:13 **** ****
2020-04-23 12:13:13 **** free-lists corrupted ****
2020-04-23 12:13:13 **** The database is seriously damaged ****
2020-04-23 12:13:13 **** You Must do an Export + Import to properly recover ****
2020-04-23 12:13:13 **** To skip the free-lists please use the --skip-free-lists ****
2020-04-23 12:13:13 **** parameter when starting Hansa. Then you Must Immediately ****
2020-04-23 12:13:13 **** perform an Export + Import if possible ****
2020-04-23 12:13:13 **** ****
2020-04-23 12:13:13 *******************************************************************
2020-04-23 12:13:13 *******************************************************************
2020-04-23 12:13:13 *******************************************************************

2020-04-23 12:13:13 *******************************************************************
2020-04-23 12:13:14 enabler flag 2 set by using PACKFIELDMATRIX in halcust\Import70to81.hal:497
2020-04-23 12:13:14 Database ID is: ED150FC123998F301ADB8E74CA885F0D
2020-04-23 12:13:15 Listening on port: 7015 (Clients)
2020-04-23 12:13:15 Listening on port: 1082 (HTTP)
2020-04-23 12:13:15 Server process running
2020-04-23 12:13:15 8.5 2020-01-07 (build 85330538)

2020-04-23 12:13:15 Server process running, pid 10796
2020-04-23 12:13:15 /THREAD(4) Starting Mail sender
2020-04-23 12:13:17 *** Running with Cloud Backups, plan level 1 ***
2020-04-23 12:13:17 /THREAD(18) *** Uploading backup D:\Backup\TB200402_naktis.TXT to cloud storage ***
2020-04-23 12:13:19 Trying to add threaded idle task UpdateLicenses with updating HAL function UpdateLicensesIdleTask
2020-04-23 12:13:19 Trying to add idle task SugarCRMRefreshAccessTokenTimedTask when already running, skipping

2020-04-23 12:13:19 Trying to add idle task SugarCRMRefreshAccessTokenTimedTask when already running, skipping
...
" Trying to add idle task SugarCRMRefreshAccessTokenTimedTask when already running, skipping" repeated many times.

..
2020-04-23 12:13:19 Įeinanti jungtis 10.20.205.130:56197
2020-04-23 12:13:19 Įeinanti jungtis 10.20.205.153:64120
2020-04-23 12:13:19 Duomenų bazė: D4DiskRead nextdp!=-1
2020-04-23 12:13:19 D4DiskRead nextdp!=-1

2020-04-23 12:13:19 DñMESIO! Duomenų bazė gali būti sugadinta. If you have tried a normal backup and that failed, we suggest you choose to create and save a raw data export from the next dialogue box
2020-04-23 12:14:19 Level 2 processed -45.63 percent, found 568 825 records
2020-04-23 12:15:19 Level 2 processed -35.98 percent, found 1 313 030 records
2020-04-23 12:15:46 GetThreadRepCancel() = true -- SendROData(): SendDataSV() Failed 2
2020-04-23 12:16:19 Level 4 processed 1.62 percent, found 2 226 992 records
2020-04-23 12:16:35 D4DiskRead nextdp!=-1
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
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