Salesforce

Cannot start database due to corruption of database after .lk file is intentionally removed.

« Go Back

Information

 
TitleCannot start database due to corruption of database after .lk file is intentionally removed.
URL Name000050869
Article Number000137161
EnvironmentProduct: OpenEdge
Version: All supported versions
OS: UNIX
Question/Problem Description
Cannot start database Memory Violation (49)
Can't startup database server with dbman or _mprosrv.
Database startup errors with Memory Violation (49)
Single user -RO session is possible, but the database still cannot be opened multi-user
Truncate BI is possible, but the database still cannot be opened multi-user

User run scripts first verify if the .lk file exists and delete it prior to running an intensive data load or schema update single user
The initial script used to start the database contains "delete <db>.lk" prior to the _mprosrv

Contents of protrace file indicate attempting to get object record from database metaschema failing: omGetObjectRecord

Stack trace from _mprosrv reads:
omGetObjectRecord
omCachePreload
Steps to Reproduce
Clarifying Information
Evidence of removal of .lk file:
 WDOG 205: (4195) /db/dbname.lk is missing, shutting down... 
 
BROKER  0: (333)   Multi-user session begin.
BROKER  0: (15321) Before Image Log Initialization at block 0  offset 235.
BROKER  0: (49)    SYSTEM ERROR: Memory violation.
BROKER  0: (5292)  SYSTEM ERROR: The broker is exiting unexpectedly, beginning Abnormal Shutdown.
BROKER  0: (-----) drexit: Initiating Abnormal Shutdown
BROKER  0: (439)   ** Save file named core for analysis by Progress Software Corporation.
Error Message(4195) <dbname>.lk is missing, shutting down...
Defect Number
Enhancement Number
Cause
The .lk file was deleted while database was running while multiple user sessions were updating the database. The watchdog detected the missing lock file and initiated an abnormal shutdown but the damage was already done to the database.  As a consequence, the database has become irrecoverably corrupted.  For further clarification refer to Article:
Resolution
Recommended course of action:
  • Restore the database from backup.
  • Roll forward any subsequent available AI files to a point in time just before the .lk file was removed.

Alternate course of action:
  • Dump the data from the database (which may fail due to the suspected meta-schema corruption)
  • If the dump is successful (and no errors listed in the database log) then load the data into a completely new database.
Workaround
Notes
Progress Article:

 The database .lk file.  
Keyword Phrase
Last Modified Date11/20/2020 6:57 AM

Powered by