# US 2008/0307266 A1 · Techniques for automatically tracking software errors

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2008/0307266 A1
- Document ID: US20080307266A1
- Status: Published application
- Kind: A1
- Application number: 12/116,145
- Filed: 2008-05-06
- Published: 2008-12-11
- Earliest claimed: 2004-09-24
- Assignees: Oracle International Corporation
- Inventors: Sashikanth Chandrasekaran
- Web page: https://patentgrep.com/patent/US20080307266A1

## CPC

- G06F 11/3688: {for test execution, e.g. scheduling of test suites}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Techniques are provided for automatically tracking errors encountered by a software system. An occurrence of an error that affects performance of an operation being performed by a database server is detected. In response to detecting the occurrence, error information about the error is automatically recorded in a storage space within a database that is managed by the database server. The error information is automatically recorded by executing one or more computer instructions in a first code path of the database server, where the first code path is a separate code path than a second code path of the database server that performs the operation whose performance is affected by the error.

## Claims

### Claim 1

A method for automatically keeping track of software errors, the method comprising the computer-implemented steps of:
detecting an occurrence of an error that affects performance of an operation being performed by a database server; and
in response to detecting the occurrence, automatically recording error information about the error in a storage space within a database that is managed by the database server;
wherein the step of automatically recording the error information is performed by executing one or more computer instructions in a first code path of the database server;
wherein the first code path is a separate code path than a second code path of the database server that performs the operation whose performance is affected by the error.

### Claim 2 (depends on 1)

The method of claim 1, wherein the step of automatically recording is performed by the database server.

### Claim 3 (depends on 1)

The method of claim 1, wherein the step of automatically recording includes:
determining whether the storage space is filled up; and
if the storage space is filled up, then automatically recording the error information over the oldest error information existing in the storage space.

### Claim 4 (depends on 1)

The method of claim 1, wherein the first code path is a code path dedicated to automatically recording the error information.

### Claim 5 (depends on 1)

The method of claim 1, wherein the method further comprises the steps of:
determining what type of error occurred; and
selecting which type of error information to store in the storage space based on the type of error that occurred.

### Claim 6 (depends on 5)

The method of claim 5, wherein the type of error information selected to be stored in the storage space includes at least one of a value of a parameter maintained by the database server, a value of a parameter maintained by an operating system, and a value of a parameter associated with a network connection.

### Claim 7 (depends on 1)

The method of claim 1, further comprising the steps of:
receiving, from a user, a database command that requests retrieval of the error information from the storage space;
the database server executing the database command to retrieve the error information from the storage space; and
returning the error information to the user.

### Claim 8 (depends on 7)

The method of claim 7, wherein the database command is a Structured Query Language (SQL) command.

### Claim 9 (depends on 1)

The method of claim 1, further comprising the step of receiving configuration information from a user, wherein the configuration information determines a location and a size of the storage space.

### Claim 10 (depends on 1)

The method of claim 1, wherein the step of automatically recording the error information comprises the steps of:
determining whether errors have previously been detected; and
recording error information only about errors that have not previously been detected.

### Claim 11 (depends on 10)

The method of claim 10, wherein the step of determining whether the errors have previously been detected comprises determining that the errors have not been encountered within a preset interval of time.

### Claim 12

A computer-readable storage medium storing one or more sequences of instructions for automatically keeping track of software errors, which instructions, when executed by one or more processors, cause the one or more processors to perform the steps of:
detecting an occurrence of an error that affects performance of an operation being performed by a database server; and
in response to detecting the occurrence, automatically recording error information about the error in a storage space within a database that is managed by the database server;
wherein the step of automatically recording the error information is performed by executing one or more computer instructions in a first code path of the database server;
wherein the first code path is a separate code path than a second code path of the database server that performs the operation whose performance is affected by the error.

### Claim 13 (depends on 12)

The computer-readable storage medium of claim 12, wherein the instructions that cause the one or more processors to perform the step of automatically recording are included in a set of executable instructions of the database server.

### Claim 14 (depends on 12)

The computer-readable storage medium of claim 12, wherein the instructions that cause the one or more processors to perform the step of automatically recording comprise instructions which, when executed by the one or more processors, cause the one or more processors to perform the steps of:
determining whether the storage space is filled up; and
if the storage space is filled up, then automatically recording the error information over the oldest error information existing in the storage space.

### Claim 15 (depends on 12)

The computer-readable storage medium of claim 12, wherein the first code path is a code path dedicated to automatically recording the error information.

### Claim 16 (depends on 12)

The computer-readable storage medium of claim 12, wherein the one or more sequences of instructions further comprise instructions which, when executed by the one or more processors, cause the one or more processors to perform the steps of:
determining what type of error occurred; and
selecting which type of error information to store in the storage space based on the type of error that occurred.

### Claim 17 (depends on 16)

The computer-readable storage medium of claim 16, wherein the type of error information selected to be stored in the storage space includes at least one of a value of a parameter maintained by the database server, a value of a parameter maintained by an operating system, and a value of a parameter associated with a network connection.

### Claim 18 (depends on 12)

The computer-readable storage medium of claim 12, wherein the one or more sequences of instructions further comprise instructions which, when executed by the one or more processors, cause the one or more processors to perform the steps of:
receiving, from a user, a database command that requests retrieval of the error information from the storage space;
the database server executing the database command to retrieve the error information from the storage space; and
returning the error information to the user.

### Claim 19 (depends on 18)

The computer-readable storage medium of claim 18, wherein the database command is a Structured Query Language (SQL) command.

### Claim 20 (depends on 12)

The computer-readable storage medium of claim 12, wherein the one or more sequences of instructions further comprise instructions which, when executed by the one or more processors, cause the one or more processors to perform the step of receiving configuration information from a user, wherein the configuration information determines a location and a size of the storage space.

### Claim 21 (depends on 12)

The computer-readable storage medium of claim 12, wherein the instructions that cause the one or more processors to perform the step of automatically recording the error information comprise instructions which, when executed by the one or more processors, cause the one or more processors to perform the steps of:
determining whether errors have previously been detected; and
recording error information only about errors that have not previously been detected.

### Claim 22 (depends on 21)

The computer-readable storage medium of claim 21, wherein the instructions that cause the one or more processors to perform the step of determining whether the errors have previously been detected comprise instructions which, when executed by the one or more processors, cause the one or more processors to perform the step of determining that the errors have not been encountered within a preset interval of time.
