Sybase – Adaptive Server had XXX major and XXX minor page faults since boot
In last time I observed in my Sybase database situations like this:
- The dataserver process of the SAP ASE server leaks memory – total size of memory allocated to the dataserver process is constantly growing.
- SAP ASE server is inaccessible and silently crashes.
- In logs I found many entries like in below frame.
2021/05/27 10:00:44.76 kernel Adaptive Server had 714140 major and 2744242 minor page faults since boot, and 44643 major and 32253 minor page faults in last 50000 milliseconds. 2021/05/27 10:01:40.78 kernel Adaptive Server had 756387 major and 2778281 minor page faults since boot, and 42247 major and 34039 minor page faults in last 50000 milliseconds.
Solution
First, You should check Your Sybase version. My version was: 16.0.03.07. SAP described this issue under SAP CR 819273:
On SAP ASE version 16.0 SP03 PL06 the dataserver process of the SAP ASE server leaks memory when stored procedure ‘saptools..SP_SAP_ATM’ is being executed.
My version Sybase also have mentioned bug. This problem is fixed in version SAP ASE 16.0 SP02 PL09 or SAP ASE 16.0 SP03 PL08. In next article I show You how to upgrade Sybase to version without bug.
But if You need faster eliminate errors in Your database You can implement workaround:
- For systems running SAP applications, see SAP Note 2806756
- For systems running custom applications: reboot ASE regularly and/or disable Job Scheduler (this option does not apply to SAP systems)
- If a similar problem is seen on the above fix releases, see SAP KBA 2868544