Platform for automated administration and monitoring of in-memory systems

Patent metadata

Field	Value
Publication number	US-11144383-B2
Application number	US-202016813934-A
Country	US
Kind code	B2
Filing date	Mar 10, 2020
Priority date	Mar 10, 2020
Publication date	Oct 12, 2021
Grant date	Oct 12, 2021

Abstract

Methods, systems, and computer-readable storage media for receiving, by an auto-pilot platform, one or more log files from an in-memory system, determining, by the auto-pilot platform, occurrence of a first error within the in-memory system based on the one or more logs, wherein the first error is indicated by a first error code within the one or more log files, identifying, by the auto-pilot platform, a first resolution from a resolution repository based on the first error code, the resolution repository including one or more mappings associating error codes to resolutions including associating the first error code with the first resolution, initiating, by the auto-pilot platform, execution of the first resolution, and updating, by the auto-pilot platform, the resolution repository based on execution of the first resolution.

First claim

What is claimed is:

1. A computer-implemented method for providing an auto-pilot platform for automated monitoring and resolution of errors in in-memory systems, the method being executed by one or more processors and comprising:
receiving, by the auto-pilot platform, one or more log files from an in-memory system;
determining, by the auto-pilot platform, occurrence of a first error within the in-memory system based on the one or more logs, wherein the first error is indicated by a first error code within the one or more log files;
identifying, by the auto-pilot platform, a first resolution from a resolution repository based on the first error code, the resolution repository comprising one or more mappings associating error codes to resolutions including associating the first error code with the first resolution;
initiating, by the auto-pilot platform, execution of the first resolution; and
updating, by the auto-pilot platform and in response to the first resolution successfully resolving the first error, the resolution repository based on execution of the first resolution, updating at least partially comprising incrementing a frequency representing a number of times the first resolution has resolved errors.

2. The method of claim 1 , wherein determining, by the auto-pilot platform, occurrence of a first error within the in-memory system based on the one or more logs comprises cross-referencing the first error code with a list of error codes and determining that the first error code is included in the list of error codes.

3. The method of claim 1 , wherein the one or more mappings are provided in a configuration read by the auto-pilot platform.

4. The method of claim 1 , wherein the first resolution is identified from a plurality of resolutions as a best-fit resolution for the first error in response to determining one or more of: the frequency associated with the first resolution being greater than frequencies of one or more other resolutions in the plurality of resolutions, and a last execution time of the first resolution being more recent than respective last execution times of the one or more other resolutions in the plurality of resolutions.

5. The method of claim 1 , further comprising:
determining, by the auto-pilot platform, occurrence of a second error within the in-memory system based on the one or more logs, wherein the second error is indicated by a second error code within the one or more log files;
identifying, by the auto-pilot platform, a second resolution from the resolution repository based on the second error code;
initiating, by the auto-pilot platform, execution of the second resolution; and
determining, by the auto-pilot platform, that the second resolution is unsuccessful, and in response, initiating a support ticket for manual intervention in resolving the second error.

6. The method of claim 5 , further comprising updating the resolution repository to include a third resolution, the third resolution being executed to resolve the second issue in response to the support ticket.

7. The method of claim 1 , wherein the in-memory system comprises an in-memory database system.

8. A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for providing an auto-pilot platform for automated monitoring and resolution of errors in in-memory systems, the operations comprising:
receiving, by the auto-pilot platform, one or more log files from an in-memory system;
determining, by the auto-pilot platform, occurrence of a first error within the in-memory system based on the one or more logs, wherein the first error is indicated by a first error code within the one or more log files;
identifying, by the auto-pilot platform, a first resolution from a resolution repository based on the first error code, the resolution repository comprising one or more mappings associating error codes to resolutions including associating the first error code with the first resolution;
initiating, by the auto-pilot platform, execution of the first resolution; and
updating, by the auto-pilot platform and in response to the first resolution successfully resolving the first error, the resolution repository based on execution of the first resolution, updating at least partially comprising incrementing a frequency representing a number of times the first resolution has resolved errors.

9. The computer-readable storage medium of claim 8 , wherein determining, by the auto-pilot platform, occurrence of a first error within the in-memory system based on the one or more logs comprises cross-referencing the first error code with a list of error codes and determining that the first error code is included in the list of error codes.

10. The computer-readable storage medium of claim 8 , wherein the one or more mappings are provided in a configuration read by the auto-pilot platform.

11. The computer-readable storage medium of claim 8 , wherein the first resolution is identified from a plurality of resolutions as a best-fit resolution for the first error in response to determining one or more of: the frequency associated with the first resolution being greater than frequencies of one or more other resolutions in the plurality of resolutions, and a last execution time of the first resolution being more recent than respective last execution times of the one or more other resolutions in the plurality of resolutions.

12. The computer-readable storage medium of claim 8 , wherein operations further comprise:
determining, by the auto-pilot platform, occurrence of a second error within the in-memory system based on the one or more logs, wherein the second error is indicated by a second error code within the one or more log files;
identifying, by the auto-pilot platform, a second resolution from the resolution repository based on the second error code;
initiating, by the auto-pilot platform, execution of the second resolution; and
determining, by the auto-pilot platform, that the second resolution is unsuccessful, and in response, initiating a support ticket for manual intervention in resolving the second error.

13. The computer-readable storage medium of claim 12 , wherein operations further comprise updating the resolution repository to include a third resolution, the third resolution being executed to resolve the second issue in response to the support ticket.

14. The computer-readable storage medium of claim 8 , wherein the in-memory system comprises an in-memory database system.

15. A system, comprising:
a computing device; and
a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations for providing an auto-pilot platform for automated monitoring and resolution of errors in in-memory systems, the operations comprising:
receiving, by the auto-pilot platform, one or more log files from an in-memory system;
determining, by the auto-pilot platform, occurrence of a first error within the in-memory system based on the one or more logs, wherein the first error is indicated by a first error code within the one or more log files;
identifying, by the auto-pilot platform, a first resolution from a resolution repository based on the first error code, the resolution repository comprising one or more mappings associating error codes to resolutions including associating the first error code with the first resolution;
initiating, by the au

Assignees

• Sap Se

Inventors

• Amulu James Michael
• C K Biddappa
• Kaluti Deepak
• Vijayakrishnan Vishnu

Classifications

• G06F11/3034 Primary

  where the computing system component is a storage system, e.g. DASD based or network based (digital input from or digital output to record carriers G06F3/06; digital recording or reproducing G11B20/18; for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS], H04L67/1097) · CPC title

• G06F11/3051

  Monitoring arrangements for monitoring the configuration of the computing system or of the computing system component, e.g. monitoring the presence of processing resources, peripherals, I/O links, software programs (verification or detection of system hardware configuration G06F11/2247) · CPC title

• G06F11/0766

  Error or fault reporting or storing · CPC title

• G06F16/21

  Design, administration or maintenance of databases · CPC title

• G06F2201/80

  Database-specific techniques · CPC title