CN116089141A - Database fault repairing method and device, emergency library system equipment and storage medium - Google Patents
Database fault repairing method and device, emergency library system equipment and storage medium Download PDFInfo
- Publication number
- CN116089141A CN116089141A CN202211645518.1A CN202211645518A CN116089141A CN 116089141 A CN116089141 A CN 116089141A CN 202211645518 A CN202211645518 A CN 202211645518A CN 116089141 A CN116089141 A CN 116089141A
- Authority
- CN
- China
- Prior art keywords
- fault
- database
- alarm
- repair
- library
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
- G06F11/0793—Remedial or corrective actions
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The database fault repairing method, the device, the emergency library system equipment and the storage medium provided by the embodiment of the invention comprise the steps of receiving alarm information reported by a database through an alarm management platform; analyzing and extracting an alarm code, a component type and an ip address of a database carried in the alarm information; determining a functional component to be repaired in the database based on the component type and the ip address; inquiring a fault restoration operation file matched with the alarm code from a pre-stored fault restoration library; and performing fault repair on the functional component to be repaired based on the fault repair operation file. According to the method and the device, the fault repair operation file of the functional component capable of repairing the fault can be obtained based on the alarm code in the alarm information, the fault repair operation file is utilized to accurately and rapidly repair the functional component with the fault in time, and compared with a manual repair mode, the automatic database repair mode is used for automatically and accurately repairing the fault of the database, database service is provided for users in time, and the use experience of the users is greatly improved.
Description
Technical Field
The embodiment of the invention relates to the technical field of databases, in particular to a database fault repairing method and device, emergency library system equipment and a storage medium.
Background
With the development of informatization, the data storage and extraction operations are not separated, so the importance of the database is also more and more prominent, and how to ensure the database to work continuously and efficiently has become an important ring for the development of informatization process.
In the current database operation and maintenance process, most of the database operation and maintenance processes still stay in the stage of manually repairing the database, and because the database has more functional components and complex architecture, the mode of manually repairing the database consumes a long time and is easy to make mistakes, so that data is lost, database service cannot be continuously provided for users, and the use experience of the users is reduced.
Disclosure of Invention
In view of the above, the embodiment of the invention provides a database fault repairing method, a database fault repairing device, an emergency library system device and a storage medium, which can automatically and accurately repair database faults, provide database services for users in time and greatly improve the use experience of the users.
In a first aspect, an embodiment of the present invention provides a method for repairing a database fault, where the method is applied to an emergency library system device, where the emergency library system device is further connected to a database and an alarm management platform, and the method includes:
receiving alarm information reported by a database through an alarm management platform;
analyzing and extracting an alarm code, a component type and an ip address of a database carried in the alarm information;
determining a functional component to be repaired in the database based on the component type and the ip address; the functional component is a functional program for realizing a preset function;
inquiring a fault restoration operation file matched with the alarm code from a pre-stored fault restoration library;
and performing fault repair on the functional component to be repaired based on the fault repair operation file.
In one possible implementation, a plurality of different specific fault repair operation files and specific alarm codes corresponding to each specific fault repair operation file are stored in a pre-stored fault repair library;
inquiring a fault repair operation file matched with the alarm code from a pre-stored fault repair library, wherein the fault repair operation file comprises:
inquiring a target specific alarm code matched with the alarm code from a pre-stored fault restoration library;
and determining the specific fault repairing operation file corresponding to the target specific alarm code as the fault repairing operation file matched with the alarm code.
In one possible embodiment, the method further comprises:
analyzing monitoring channel information of the emergency library system equipment, and monitoring the running state of each service component of the emergency library system equipment according to the monitoring channel information;
monitoring whether the running state corresponding to each service component is normal or not;
repairing the service component with the running state being the abnormal running state under the condition that the running state of at least one service component is monitored to be the abnormal running state;
and under the condition that the service component with the abnormal operation state is repaired, executing the step of inquiring the fault repair operation file matched with the alarm code from the pre-stored fault repair library.
In one possible embodiment, the method further comprises:
inquiring a fault rechecking operation file matched with the alarm code from a pre-stored fault rechecking library;
rechecking the component state of the repaired functional component to be repaired based on the fault rechecking operation file;
judging whether the component state is an abnormal component state or not;
and under the condition that the component state is the abnormal component state, executing the step of inquiring the fault repairing operation file matched with the alarm code from the pre-stored fault repairing library.
In one possible implementation manner, a plurality of different specific fault rechecking operation files and specific alarm codes corresponding to each specific fault rechecking operation file are stored in a pre-stored fault rechecking library;
inquiring a fault rechecking operation file matched with the alarm code from a pre-stored fault rechecking library, wherein the method comprises the following steps:
inquiring a target specific alarm code matched with the alarm code from a pre-stored fault rechecking library;
and determining the specific fault rechecking operation file corresponding to the target specific alarm code as the fault rechecking operation file matched with the alarm code.
In one possible embodiment, the method further comprises:
acquiring the execution times of steps of inquiring a fault restoration operation file matched with an alarm code from a pre-stored fault restoration library under the condition that the component state is an abnormal component state;
judging whether the execution times exceeds the preset execution times or not;
generating repair failure information under the condition that the execution times exceed preset execution times;
reporting the repair failure information to an alarm management platform.
In one possible embodiment, the method further comprises:
generating repair completion information under the condition that the component state is a normal component state;
reporting the repair completion information to an alarm management platform.
In a second aspect, an embodiment of the present invention provides a database fault repairing apparatus, where the apparatus is applied to an emergency library system device, and the emergency library system device is further connected to a database and an alarm management platform, where the apparatus includes:
the receiving module is used for receiving the alarm information reported by the database through the alarm management platform;
the analysis and extraction module is used for analyzing and extracting the alarm code, the component type and the ip address of the database carried in the alarm information;
the determining module is used for determining the functional components to be repaired in the database based on the component types and the ip addresses; the functional component is a functional program for realizing a preset function;
the query module is used for querying a fault restoration operation file matched with the alarm code from a pre-stored fault restoration library;
the fault repair module is used for repairing the fault of the functional component to be repaired based on the fault repair operation file.
In a third aspect, an embodiment of the present invention provides an emergency library system apparatus, including: the processor is used for executing the database fault repairing program stored in the memory so as to realize the database fault repairing method.
In a fourth aspect, an embodiment of the present invention provides a storage medium, where the storage medium stores one or more programs, and the one or more programs are executable by one or more processors to implement the database fault repair method described above.
The database fault repairing method, the device, the emergency library system equipment and the storage medium provided by the embodiment of the invention comprise the steps of receiving alarm information reported by a database through an alarm management platform; analyzing and extracting an alarm code, a component type and an ip address of a database carried in the alarm information; determining a functional component to be repaired in the database based on the component type and the ip address; inquiring a fault restoration operation file matched with the alarm code from a pre-stored fault restoration library; and performing fault repair on the functional component to be repaired based on the fault repair operation file. According to the method and the device for automatically repairing the database, the fault repairing operation file of the functional component capable of repairing the fault can be obtained based on the alarm code in the alarm information reported by the database, the functional component capable of repairing the fault can be accurately and quickly repaired in time by using the fault repairing operation file, and compared with a manual repairing mode, the mode of automatically and accurately repairing the database fault can automatically and accurately repair the database, database service can be provided for users in time, and the use experience of the users is greatly improved.
Drawings
Fig. 1 is a schematic hardware structure diagram of a database fault repairing method according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a database fault repairing method according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating another database fault repair method according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a database fault repairing apparatus according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of an emergency library system device according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
For the purpose of facilitating an understanding of the embodiments of the present invention, reference will now be made to the following description of specific embodiments, taken in conjunction with the accompanying drawings, which are not intended to limit the embodiments of the invention.
For the sake of understanding the present embodiment, the following first describes in detail a database fault repairing method provided in the embodiment of the present invention. The execution main body is emergency library system equipment, and as shown in fig. 1, the emergency library system equipment 1 is also connected with a database 2 and an alarm management platform 3; in practical application, the database 2 may be a hierarchical database, a network database or a relational database, which is not limited herein, the alarm management platform 3 is mainly used for displaying alarm information reported by the database 2 so as to be convenient for maintenance personnel to check, wherein the emergency database system device 1 includes an alarm information analysis module 4, an emergency method module 5, an emergency processing result rechecking module 6 and an execution module 7, the alarm information analysis module 4 is mainly used for receiving the alarm information reported by the database 2 through the alarm management platform 3 and analyzing and extracting relevant information of a database fault carried in the alarm information, the execution module 7 is mainly used for extracting a corresponding fault repairing method from the emergency method module 5 according to the relevant information of the fault to repair the database, and performing self-diagnosis, and after the repair is completed, the execution module 7 is also used for calling a corresponding rechecking method in the emergency processing result rechecking module 6 to ensure that the fault is truly eliminated, so as to automatically repair the database fault in time, thereby greatly improving the user experience.
Based on the emergency library system equipment, the embodiment of the invention provides a database fault repairing method, as shown in fig. 2, comprising the following steps:
because the alarm information carries relevant information about the fault, the relevant information about the fault is generally packaged into alarm information, and therefore, after the alarm information is received, the emergency library system equipment needs to analyze the alarm information in an analysis mode corresponding to the packaging mode so as to extract the relevant information about the fault.
In this embodiment, the relevant information of the fault includes an alarm code, a component type and an ip (Internet Protocol ) address of the database, where the alarm code is unique identification information of the fault, that is, it can be determined which fault the database is specifically.
The component type is unique identification information of each functional component in the database, through which it can be known clearly which functional component in the database has failed, and the functional component can be understood as a functional program for implementing a preset function, for example, the database includes a calling component for implementing a data calling function, a querying component for querying data, and the like, and the functional components included in the database are defined herein.
In general, multiple identical databases are required to be configured, so that when one database fails and cannot be repaired, other databases can still provide database services for users, and in actual use, each database is configured with a different ip address to distinguish.
the above functional component to be repaired is a functional component with a fault, and it can be known from the above description that through the component type and the ip address, it can be uniquely determined which functional component in which database has a fault, and in actual use, one piece of alarm information may include one or more fault codes, so that what fault has occurred in the functional component to be repaired is clarified through the alarm code, so as to repair the fault in the functional component to be repaired.
in this embodiment, the corresponding fault repair operation file is queried from the pre-stored fault repair library through the alarm code, the fault repair operation file includes a specific repair step for repairing the functional component of the fault, and the emergency library system device automatically and accurately repairs the functional component to be repaired through the specific repair step in the fault repair operation file.
The prestored fault repair library stores a plurality of different specific fault repair operation files and specific alarm codes corresponding to each specific fault repair operation file; specifically, the process of inquiring the fault repairing operation file matched with the alarm code from the pre-stored fault repairing library comprises the following steps: inquiring a target specific alarm code matched with the alarm code from a pre-stored fault restoration library; and determining the specific fault repairing operation file corresponding to the target specific alarm code as the fault repairing operation file matched with the alarm code.
By way of the above description of the pre-stored fault repair library, as shown in table 1 below, is one example of a pre-stored fault repair library:
TABLE 1
| Specific alarm code | Specific fault repair operation file |
| Specific alarm code 1 | Specific failure repair operation file 1 |
| Specific alarm code 2 | Specific fault repair operation file 2 |
| Specific alarm code 3 | Specific fault repair operation file 3 |
| Specific alarm code 4 | Specific failure repair operation file 4 |
Continuing to table 1, if the alarm code is 2 and matches with the specific alarm code 2 in table 1, the method for repairing the functional component to be repaired needs to repair according to the specific repairing steps included in the specific fault repairing operation file 2.
It should be noted that, the specific repair operation files corresponding to different fault needs are repaired, so specific repair steps included in the specific repair operation files may be different, and only examples of the correspondence between the specific repair operation files and the specific alarm codes are shown in table 1, and the correspondence between the specific repair operation files and the specific alarm codes may be set according to actual needs, which is not limited herein.
And 205, performing fault repair on the functional component to be repaired based on the fault repair operation file.
The emergency library system equipment can automatically and accurately repair the functional components to be repaired according to the specific repair steps included in the determined fault repair operation file without manually repairing the faults, so that the repair rate is greatly improved, database services are provided for users in time, and the use experience of the users is improved.
The database fault repairing method provided by the embodiment of the invention comprises the steps of receiving alarm information reported by a database through an alarm management platform; analyzing and extracting an alarm code, a component type and an ip address of a database carried in the alarm information; determining a functional component to be repaired in the database based on the component type and the ip address; inquiring a fault restoration operation file matched with the alarm code from a pre-stored fault restoration library; and performing fault repair on the functional component to be repaired based on the fault repair operation file. According to the method and the device for automatically repairing the database, the fault repairing operation file of the functional component capable of repairing the fault can be obtained based on the alarm code in the alarm information reported by the database, the functional component capable of repairing the fault can be accurately and quickly repaired in time by using the fault repairing operation file, and compared with a manual repairing mode, the mode of automatically and accurately repairing the database fault can automatically and accurately repair the database, database service can be provided for users in time, and the use experience of the users is greatly improved.
In general, in the process of repairing a functional component to be repaired based on a fault repairing operation file, the emergency library system device needs to perform self-diagnosis in real time, repair work is not performed on the functional component to be repaired when the emergency library system device itself fails, repair work is performed on the functional component to be repaired after the emergency library system device itself fails to repair, and after the functional component to be repaired is completed, the functional component needs to be checked to ensure that the fault of the functional component to be repaired is really eliminated, and based on the description, referring to fig. 3, a flow diagram of another database fault repairing method is provided for the embodiment of the invention. The flow shown in fig. 3 is implemented based on the flow shown in fig. 2. As shown in fig. 3, the process may include the steps of:
for the description of steps 301 to 305, reference may be made to the descriptions of steps 201 to 205 in the above embodiments, and the description thereof will be omitted herein.
the method comprises the steps of collecting version information of emergency library system equipment, inquiring matched basic monitoring channels from a resource library according to the version information, storing monitoring channel information of various versions of emergency library system equipment by the resource library, reading configuration files of the emergency library system equipment, and analyzing running states of all service components from the configuration files.
and under the condition that the operation state of at least one service component is monitored to be in an abnormal operation state, executing step 308 to repair the service component in the abnormal operation state, and when the operation state corresponding to each service component is monitored to be in a normal operation state, continuing executing step 305 until the repair of the functional component to be repaired is completed, and further executing step 310 to check whether the fault of the repaired functional component to be repaired is really eliminated or not.
one or more service components in abnormal operation states can be repaired manually or self-repaired, and the repair mode of the service components is not limited. And under the condition that the service component with the running state being the abnormal running state is repaired, the step 304 is required to be re-executed, and the fault repair operation file matched with the alarm code is queried from the pre-stored fault repair library again so as to repair the functional component to be repaired based on the fault repair operation file, thereby effectively avoiding the situation that the database of the service component cannot provide database service for a user due to incomplete repair caused by damage in the process of repairing the functional component.
in this embodiment, the corresponding fault rechecking operation file is queried from the pre-stored fault rechecking library through the alarm code, the fault rechecking operation file includes a specific rechecking step for checking the component state of the functional component to be repaired, and the emergency library system device checks the component state of the functional component to be repaired through the specific rechecking step in the fault rechecking operation file to determine whether the functional component to be repaired is truly repaired successfully.
The pre-stored fault rechecking library stores a plurality of different specific fault rechecking operation files and specific alarm codes corresponding to each specific fault rechecking operation file; specifically, the process of inquiring the fault rechecking operation file matched with the alarm code from the pre-stored fault rechecking library comprises the following steps: inquiring a target specific alarm code matched with the alarm code from a pre-stored fault rechecking library; and determining the specific fault rechecking operation file corresponding to the target specific alarm code as the fault rechecking operation file matched with the alarm code.
Through the above description of the pre-stored fault review library, as shown in table 2 below, an example of the pre-stored fault review library:
TABLE 2
| Specific alarm code | Specific fault rechecking operation file |
| Specific alarm code 1 | Specific failure rechecking operation file 1 |
| Specific alarmsCode 2 | Specific failure rechecking operation file 2 |
| Specific alarm code 3 | Specific fault rechecking operation file 3 |
| Specific alarm code 4 | Specific failure rechecking operation file 4 |
Continuing to table 2, if the alarm code is 2 and matches with the specific alarm code 2 in table 2, the method for checking the component state of the functional component to be repaired needs to check according to the specific checking step included in the specific fault checking operation file 2.
It should be noted that, the specific fault review operation files corresponding to the specific fault review needs to be reviewed for different faults, so specific review steps included in the specific fault review operation files may be different, and only examples of the correspondence between the specific fault review operation files and the specific alarm codes are shown in table 2, and the correspondence between the specific fault review operation files and the specific alarm codes may be set according to actual needs, which is not limited herein.
if the component status is an abnormal component status, which indicates that the repair of the functional component to be repaired fails, the functional component to be repaired still has a fault, so that the step 304 needs to be re-executed to re-repair the functional component to be repaired, and if the repair is not successful after the repair is performed for a plurality of times, repair failure information is generated to inform maintenance personnel of repairing the database.
The specific process for generating the repair failure information comprises the following steps: acquiring the execution times of steps of inquiring a fault restoration operation file matched with an alarm code from a pre-stored fault restoration library under the condition that the component state is an abnormal component state; judging whether the execution times exceeds the preset execution times or not; generating repair failure information under the condition that the execution times exceed preset execution times; reporting the repair failure information to an alarm management platform.
The preset execution times can be set according to actual needs, the method is not limited herein, and the generated repair failure information can be displayed on the alarm management platform in the form of characters, symbols or the like, or can be broadcasted on the alarm management platform in the form of prompt sounds, so that the purpose of notifying maintenance personnel is achieved, and the maintenance personnel is notified of the repair failure of the database.
If the component status is a normal component status, indicating that the functional component to be repaired is successfully repaired, step 312 is performed.
and step 313, reporting the repair completion information to an alarm management platform.
Likewise, the generated repair completion information can be displayed on the alarm management platform in the form of characters or symbols, or can be broadcasted on the alarm management platform in the form of prompting sound, so that the purpose of notifying maintenance personnel is achieved, and the maintenance personnel is notified that the database is successfully repaired.
According to the database fault repairing method, the emergency library system equipment can conduct self-diagnosis in real time in the process of conducting fault repairing on the functional component to be repaired based on the fault repairing operation file, so that the normal performance of fault repairing of the database is guaranteed, and after the functional component to be repaired is repaired, the functional component is required to be checked, so that the fault of the functional component to be repaired is truly eliminated, effective database service can be provided for a user, and the use experience of the user is provided.
Corresponding to the above-mentioned method embodiment, the present embodiment provides a database fault repairing device, which is applied to an emergency library system device, where the emergency library system device is further connected to a database and an alarm management platform, and referring to a schematic structural diagram of the database fault repairing device shown in fig. 4, the device includes:
the receiving module 401 is configured to receive alarm information reported by the database through the alarm management platform;
the parsing and extracting module 402 is configured to parse and extract an alarm code, a component type and an ip address of a database carried in the alarm information;
a determining module 403, configured to determine a functional component to be repaired in the database based on the component type and the ip address; the functional component is a functional program for realizing a preset function;
the query module 404 is configured to query a fault repair operation file matching the alarm code from a pre-stored fault repair library;
the fault repair module 405 is configured to perform fault repair on the functional component to be repaired based on the fault repair operation file.
The database fault repairing device provided by the embodiment of the invention comprises the steps of receiving alarm information reported by a database through an alarm management platform; analyzing and extracting an alarm code, a component type and an ip address of a database carried in the alarm information; determining a functional component to be repaired in the database based on the component type and the ip address; inquiring a fault restoration operation file matched with the alarm code from a pre-stored fault restoration library; and performing fault repair on the functional component to be repaired based on the fault repair operation file. According to the method and the device for automatically repairing the database, the fault repairing operation file of the functional component capable of repairing the fault can be obtained based on the alarm code in the alarm information reported by the database, the functional component capable of repairing the fault can be accurately and quickly repaired in time by using the fault repairing operation file, and compared with a manual repairing mode, the mode of automatically and accurately repairing the database fault can automatically and accurately repair the database, database service can be provided for users in time, and the use experience of the users is greatly improved.
Fig. 5 is a schematic structural diagram of an emergency library system device according to an embodiment of the present invention, and the emergency library system device 500 shown in fig. 5 includes: at least one processor 501, memory 502, at least one network interface 504, and other user interfaces 503. The various components in the emergency library system device 500 are coupled together by a bus system 505. It is understood that bus system 505 is used to enable connected communications between these components. The bus system 505 includes a power bus, a control bus, and a status signal bus in addition to a data bus. But for clarity of illustration the various buses are labeled as bus system 505 in fig. 5.
The user interface 503 may include, among other things, a display, a keyboard, or a pointing device (e.g., a mouse, a trackball, a touch pad, or a touch screen, etc.).
It will be appreciated that the memory 502 in embodiments of the invention can be either volatile memory or nonvolatile memory, or can include both volatile and nonvolatile memory. The nonvolatile Memory may be a Read-Only Memory (ROM), a Programmable ROM (PROM), an Erasable PROM (EPROM), an Electrically Erasable EPROM (EEPROM), or a flash Memory. The volatile memory may be random access memory (Random Access Memory, RAM) which acts as an external cache. By way of example, and not limitation, many forms of RAM are available, such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (Double Data Rate SDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), and Direct memory bus RAM (DRRAM). The memory 502 described herein is intended to comprise, without being limited to, these and any other suitable types of memory.
In some implementations, the memory 502 stores the following elements, executable units or data structures, or a subset thereof, or an extended set thereof: an operating system 5021 and application programs 5022.
The operating system 5021 includes various system programs, such as a framework layer, a core library layer, a driver layer, and the like, for implementing various basic services and processing hardware-based tasks. The application 5022 includes various application programs such as a Media Player (Media Player), a Browser (Browser), and the like for realizing various application services. A program for implementing the method according to the embodiment of the present invention may be included in the application 5022.
In the embodiment of the present invention, the processor 501 is configured to execute the method steps provided in the method embodiments by calling a program or an instruction stored in the memory 502, specifically, a program or an instruction stored in the application 5022.
The method disclosed in the above embodiment of the present invention may be applied to the processor 501 or implemented by the processor 501. The processor 501 may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuitry in hardware or instructions in software in the processor 501. The processor 501 may be a general purpose processor, a digital signal processor (Digital Signal Processor, DSP), an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), an off-the-shelf programmable gate array (Field Programmable Gate Array, FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components. The disclosed methods, steps, and logic blocks in the embodiments of the present invention may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present invention may be embodied directly in the execution of a hardware decoding processor, or in the execution of a combination of hardware and software elements in a decoding processor. The software elements may be located in a random access memory, flash memory, read-only memory, programmable read-only memory or electrically erasable programmable memory, registers, etc. as well known in the art. The storage medium is located in a memory 502, and the processor 501 reads information in the memory 502 and, in combination with its hardware, performs the steps of the method described above.
It is to be understood that the embodiments described herein may be implemented in hardware, software, firmware, middleware, microcode, or a combination thereof. For a hardware implementation, the processing units may be implemented within one or more application specific integrated circuits (Application Specific Integrated Circuits, ASIC), digital signal processors (Digital Signal Processing, DSP), digital signal processing devices (dspev, DSPD), programmable logic devices (Programmable Logic Device, PLD), field programmable gate arrays (Field-Programmable Gate Array, FPGA), general purpose processors, controllers, micro-controllers, microprocessors, other electronic units designed to perform the functions described herein, or a combination thereof.
For a software implementation, the techniques described herein may be implemented by means of units that perform the functions described herein. The software codes may be stored in a memory and executed by a processor. The memory may be implemented within the processor or external to the processor.
The emergency library system device provided in this embodiment may be an emergency library system device as shown in fig. 5, and may perform all steps of the database fault repairing method as shown in fig. 2-3, so as to achieve the technical effects of the database fault repairing method as shown in fig. 2-3, and the detailed description will be omitted herein for brevity.
The embodiment of the invention also provides a storage medium (computer readable storage medium). The storage medium here stores one or more programs. Wherein the storage medium may comprise volatile memory, such as random access memory; the memory may also include non-volatile memory, such as read-only memory, flash memory, hard disk, or solid state disk; the memory may also comprise a combination of the above types of memories.
When one or more programs are executed by one or more processors in a storage medium, the database fault remediation method described above is implemented.
The processor is used for executing a database fault repair program stored in the memory to realize the steps of the database fault repair method.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative elements and steps are described above generally in terms of function in order to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied in hardware, in a software module executed by a processor, or in a combination of the two. The software modules may be disposed in Random Access Memory (RAM), memory, read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the invention, and is not meant to limit the scope of the invention, but to limit the invention to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (10)
1. A database fault repair method, wherein the method is applied to an emergency library system device, the emergency library system device is further connected with a database and an alarm management platform, and the method comprises:
receiving alarm information reported by the database through the alarm management platform;
analyzing and extracting an alarm code, a component type and an ip address of the database carried in the alarm information;
determining a functional component to be repaired in the database based on the component type and the ip address; wherein the functional component is a functional program for realizing a preset function;
inquiring a fault restoration operation file matched with the alarm code from a pre-stored fault restoration library;
and performing fault repair on the functional component to be repaired based on the fault repair operation file.
2. The method of claim 1, wherein a plurality of different specific failover operation files, and a specific alarm code corresponding to each of the specific failover operation files, are stored in the pre-stored failover library;
the step of inquiring the fault repairing operation file matched with the alarm code from the pre-stored fault repairing library comprises the following steps:
inquiring a target specific alarm code matched with the alarm code from the pre-stored fault restoration library;
and determining the specific fault repairing operation file corresponding to the target specific alarm code as the fault repairing operation file matched with the alarm code.
3. The method according to claim 1, wherein the method further comprises:
analyzing the monitoring channel information of the emergency library system equipment, and monitoring the running state of each service component of the emergency library system equipment according to the monitoring channel information;
monitoring whether the running state corresponding to each service component is normal or not;
repairing the service component with the running state being the abnormal running state under the condition that the running state of at least one service component is monitored to be the abnormal running state;
and under the condition that the service component with the abnormal running state is repaired, executing the step of inquiring the fault repair operation file matched with the alarm code from a pre-stored fault repair library.
4. A method according to claim 3, characterized in that the method further comprises:
inquiring a fault rechecking operation file matched with the alarm code from a pre-stored fault rechecking library;
rechecking the component state of the repaired functional component to be repaired based on the fault rechecking operation file;
judging whether the component state is an abnormal component state or not;
and under the condition that the component state is an abnormal component state, executing the step of inquiring the fault restoration operation file matched with the alarm code from a pre-stored fault restoration library.
5. The method of claim 4, wherein a plurality of different specific fault review operation files and specific alarm codes corresponding to each specific fault review operation file are stored in the pre-stored fault review library;
the step of inquiring the fault rechecking operation file matched with the alarm code from the pre-stored fault rechecking library comprises the following steps:
inquiring a target specific alarm code matched with the alarm code from the pre-stored fault rechecking library;
and determining the specific fault rechecking operation file corresponding to the target specific alarm code as the fault rechecking operation file matched with the alarm code.
6. The method according to claim 4, wherein the method further comprises:
acquiring the execution times of steps of inquiring a fault repairing operation file matched with the alarm code from a pre-stored fault repairing library under the condition that the component state is an abnormal component state;
judging whether the execution times exceeds preset execution times or not;
generating repair failure information under the condition that the execution times exceed the preset execution times;
and reporting the repair failure information to the alarm management platform.
7. The method according to claim 4, wherein the method further comprises:
generating repair completion information under the condition that the component state is a normal component state;
and reporting the repair completion information to the alarm management platform.
8. A database fault remediation device, the device being applied to an emergency library system facility, the emergency library system facility further being connected to a database and an alarm management platform, the device comprising:
the receiving module is used for receiving the alarm information reported by the database through the alarm management platform;
the analysis and extraction module is used for analyzing and extracting the alarm code, the component type and the ip address of the database carried in the alarm information;
the determining module is used for determining the functional components to be repaired in the database based on the component type and the ip address; wherein the functional component is a functional program for realizing a preset function;
the query module is used for querying a fault restoration operation file matched with the alarm code from a pre-stored fault restoration library;
and the fault repair module is used for performing fault repair on the functional component to be repaired based on the fault repair operation file.
9. An emergency library system apparatus, comprising: a processor and a memory, the processor being configured to execute a database fault repair program stored in the memory to implement the database fault repair method of any one of claims 1 to 7.
10. A storage medium storing one or more programs executable by one or more processors to implement the database fault remediation method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211645518.1A CN116089141A (en) | 2022-12-16 | 2022-12-16 | Database fault repairing method and device, emergency library system equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211645518.1A CN116089141A (en) | 2022-12-16 | 2022-12-16 | Database fault repairing method and device, emergency library system equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116089141A true CN116089141A (en) | 2023-05-09 |
Family
ID=86186064
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211645518.1A Pending CN116089141A (en) | 2022-12-16 | 2022-12-16 | Database fault repairing method and device, emergency library system equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116089141A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117290144A (en) * | 2023-10-12 | 2023-12-26 | 北京首都在线科技股份有限公司 | Fault processing method, device, electronic equipment and storage medium |
-
2022
- 2022-12-16 CN CN202211645518.1A patent/CN116089141A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117290144A (en) * | 2023-10-12 | 2023-12-26 | 北京首都在线科技股份有限公司 | Fault processing method, device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109284269B (en) | Abnormal log analysis method and device, storage medium and server | |
| CN107451040B (en) | Method and device for positioning fault reason and computer readable storage medium | |
| CN107678936B (en) | Business system pre-inspection method, server and computer readable storage medium | |
| US10552242B2 (en) | Runtime failure detection and correction | |
| CN116089141A (en) | Database fault repairing method and device, emergency library system equipment and storage medium | |
| CN116627848B (en) | Automatic test method and system for application program | |
| JP2015011372A (en) | Debug support system, method, program, and recording medium | |
| CN111026576A (en) | Method, equipment and medium for analyzing mainboard faults | |
| CN112363920A (en) | Test case repairing method and device, computer equipment and storage medium | |
| CN110618890A (en) | Fault processing method and device, electronic equipment and computer readable storage medium | |
| CN113392000B (en) | Test case execution result analysis method, device, equipment and storage medium | |
| CN114020432A (en) | Task exception handling method and device and task exception handling system | |
| CN110532146B (en) | Data acquisition monitoring method and device | |
| CN111309584B (en) | Data processing method, device, electronic equipment and storage medium | |
| CN105159810B (en) | The method and device that the BIOS of computer system is tested | |
| CN111125990A (en) | Method for judging result correctness of parasitic parameters | |
| CN115904698A (en) | Method for managing OPC UA architecture by using YAML format file | |
| CN115168217A (en) | Defect discovery method and device for source code file | |
| CN113722229A (en) | Software testing method and device, electronic equipment and storage medium | |
| CN109783263B (en) | Method and system for processing aging test fault of server | |
| CN111198798B (en) | Service stability measuring method and device | |
| CN112463444A (en) | Data inconsistency repairing method and related device | |
| CN113900914A (en) | Exception handling method and device, electronic equipment and computer storage medium | |
| CN113886165B (en) | Verification method, device and equipment for firmware diagnosis function and readable medium | |
| CN111722997A (en) | Abnormality detection method for automated testing and computer-readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |