Forum - DB crash during Stock Rebuild

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

Zilvinas Suliauskas

4-24-20

Hello Aldevinas,

I was told that this maintenance was created to rebuild 5.0 version stock to 5.1 version. It should not be used in 8.5.

Pls restore customers DB from the latest backup.

Martins Ebersteins

5-19-20

I know it is "not supported", but in practice it is required to use this maintenance, as this is the one which allows you to rebuild support registers after you have manually changed stock records (e.g. by "importing" a goods receipt to unOK an existing one or any other stock updating record)

Regarding the question - what we have investigated is that it crashes the database if at the moment of the maintenance system receives any API / WEB requests.

Aldevinas Katkus

5-19-20

Created byMartins Ebersteins10:13 19 May 2020

I don't think it crashed because of web request. The server is behind firewall and not accessible from outside. It also crashed in single user mode. I saw this myself.

Martins Ebersteins

5-20-20

Created byAldevinas Katkus15:12 19 May 2020

I don't think it crashed because of web request. The server is behind firewall and not accessible from outside. It also crashed in single user mode. I saw this myself.

Could be also some periodic maintenances - check them. If anything tries to write (not sure about read) anything to the database during the rebuilding, it crashes the database.

Back to the list

New Message
Open Questions My Questions