CN103441861A - Method and device for generating data records - Google Patents

Method and device for generating data records Download PDF

Info

Publication number
CN103441861A
CN103441861A CN2013103022915A CN201310302291A CN103441861A CN 103441861 A CN103441861 A CN 103441861A CN 2013103022915 A CN2013103022915 A CN 2013103022915A CN 201310302291 A CN201310302291 A CN 201310302291A CN 103441861 A CN103441861 A CN 103441861A
Authority
CN
China
Prior art keywords
interface
data record
output data
data
interface identifier
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.)
Granted
Application number
CN2013103022915A
Other languages
Chinese (zh)
Other versions
CN103441861B (en
Inventor
张蔚
李娟�
张羽
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hangzhou Huawei Digital Technologies Co Ltd
Original Assignee
Hangzhou Huawei Digital Technologies Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Hangzhou Huawei Digital Technologies Co Ltd filed Critical Hangzhou Huawei Digital Technologies Co Ltd
Priority to CN201310302291.5A priority Critical patent/CN103441861B/en
Publication of CN103441861A publication Critical patent/CN103441861A/en
Priority to PCT/CN2014/072211 priority patent/WO2015007091A1/en
Application granted granted Critical
Publication of CN103441861B publication Critical patent/CN103441861B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/3065Monitoring arrangements determined by the means or processing involved in reporting the monitored data
    • G06F11/3072Monitoring arrangements determined by the means or processing involved in reporting the monitored data where the reporting involves data filtering, e.g. pattern matching, time or event triggered, adaptive or policy-based reporting
    • G06F11/3075Monitoring arrangements determined by the means or processing involved in reporting the monitored data where the reporting involves data filtering, e.g. pattern matching, time or event triggered, adaptive or policy-based reporting the data filtering being achieved in order to maintain consistency among the monitored data, e.g. ensuring that the monitored data belong to the same timeframe, to the same system or component
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/3003Monitoring arrangements specially adapted to the computing system or computing system component being monitored
    • G06F11/3006Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system is distributed, e.g. networked systems, clusters, multiprocessor systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3466Performance evaluation by tracing or monitoring
    • G06F11/3476Data logging
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/86Event-based monitoring

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Quality & Reliability (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computing Systems (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The invention discloses a method and device for generating data records. The method includes the steps that output data of all interfaces in a server are monitored by a BMC in the server, acquiring time corresponding to the output data is recorded, and interface information corresponding to any interface, the output data of any interface and the acquiring time corresponding to the output data are marshaled to the data records. By the adoption of the technical scheme, the data records are generated by the BMC in the server from a hardware drive layer without depending on a network or an independent terminal device or monitoring software, therefore, cost is effectively reduced, and reliability for acquiring the data records is improved; in addition, the data records comprise the acquiring time corresponding to the output data of the interfaces, therefore, the data records and event logs of the BMC are matched, and accuracy of failure locating and failure cause detection is improved.

Description

A kind of data record generation method and device
Technical field
The present invention relates to communication technical field, relate in particular to a kind of data record generation method and device.
Background technology
At present, along with the extensive use of server in the communications field, the fault detect of server receives increasing concern.
When startup of server stage or server break down, the data of server interface output contribute to fault location and obtain failure cause.At present, usually adopt two kinds of modes of on-the-spot record and remote logging to obtain the output data of server interface, wherein:
Consult and Figure 1 shows that the on-the-spot record mode obtains the schematic diagram of server interface output data, this mode is in a terminal of server side configuration, this terminal establishes a connection by the I/O interface of hardware bus and server, and in this terminal, monitoring software is installed.After startup of server, realize obtaining the output data of this each interface of server by moving monitoring software in above-mentioned terminal.When adopting above-mentioned on-the-spot record mode to obtain the output data of server interface, at first need to monitoring software be installed in terminal, and set up being connected between terminal and server, thereby increased the cost of maintenance terminal, and, when this connects disconnection, monitoring software can't obtain the output data of server interface; Serial ports for server, the data of its output are stream data, to there is bulk information output at interface of each time point, above-mentioned monitoring software can't record each interface output time corresponding to data, thereby can't be complementary with the middle event log recorded of the BMC (Baseboard Management Controller, baseboard management controller) of server inside.
Consult and Figure 2 shows that remote mode obtains the schematic diagram of server interface output data, this mode is in a terminal of far-end configuration of server, and this terminal connects by network and server, and in this terminal, monitoring software is installed.After startup of server, move the monitoring software in above-mentioned terminal and realize obtaining the output data of this each interface of server by network.When adopting above-mentioned remote logging mode to obtain the output data of server interface, at first need to monitoring software be installed in terminal, thereby increased the cost of maintenance terminal, due between terminal and server, by network, be connected, bandwidth resources have been taken, and, when this network connects disconnection, monitoring software can't obtain the output data of server interface; Serial ports for server, the data of its output are stream data, to there is bulk information output at interface of each time point, above-mentioned monitoring software can't record each interface output time corresponding to data, thereby the event log that can't record with the BMC of server inside is complementary, thereby is not easy to the location of fault and the detection of failure cause.
In sum, in prior art, to the acquisition methods of server interface output data, exist cost high, acquisition process is unreliable, and the output data lack temporal information and cause fault location and failure cause to detect inaccurate problem.
Summary of the invention
The embodiment of the present invention provides a kind of data record generation method and device, in order to the acquisition methods solved server interface output data, exist cost high, acquisition process is unreliable, and the output data lack temporal information and cause fault location and failure cause to detect inaccurate problem.
First aspect, provide a kind of data record generation method, comprising:
Obtain the output data of any one interface in server by local hardware interface;
According to described output data, obtain interface message corresponding to described output data, and the acquisition time of described output data;
By the output data of described any one interface, described interface message, and described acquisition time is converted to the data record of specified format, and store described data record.
In conjunction with first aspect, in the first, in possible implementation, indicate local bus control unit to produce interrupt signal according to the output data of any one interface in described server, and described interrupt signal is sent to local processor; Indicate described processor to be resolved described interrupt signal, and obtain the keyword of the output data of described interrupt signal indication, generate the interface message of described any one interface according to described keyword, wherein, described interface message comprises interface identifier and corresponding interface status information thereof.
In conjunction with first aspect, at the second, in possible implementation, when receiving the output data of described any one interface, read the temporal information in local real-time clock RTC, the acquisition time using described temporal information as described output data.
The possible implementation in conjunction with the first of first aspect, the perhaps possible implementation of the second of first aspect, at the third in possible implementation, output data by described any one interface, described interface message, and described acquisition time is converted to the storage instruction of SQL SQL form; The data record of carrying in the storage instruction of described SQL form is stored in local data base.
In conjunction with the third possible implementation of first aspect, in the 4th kind of possible implementation, receive the query statement of input by specified interface; Described query statement is converted to corresponding SQL form query statement; Extract data record corresponding to described SQL form query statement from described local data base, and the Query Result corresponding as described query statement exported using described data record.
The 4th kind of possible implementation in conjunction with first aspect, in the 5th kind of possible implementation, while in described query statement, comprising an interface identifier, all data record that the acquisition time sequencing of corresponding output data is corresponding to described interface identifier according to described interface identifier are sorted, and export the data record after described sequence; While in described query statement, comprising at least two interface identifier, obtain respectively the data record that each interface identifier is corresponding, and export successively according to the order of the interface identifier in described query statement the data record that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier; While comprising zero-time and concluding time in described query statement, obtain respectively each interface identifier corresponding in described zero-time and the data record between the concluding time, and export successively according to default interface identifier priority orders the data record that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier; While in described query statement, comprising interface status information, extract respectively the data record that meets described interface status information corresponding data record from each interface identifier, and export successively according to default interface identifier priority orders the data record that meets described interface status information that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier.
Second aspect, provide a kind of data record generating apparatus, comprising:
The first acquiring unit, obtain the output data of any one interface of server, and described output data be sent to second acquisition unit and generation unit for the hardware interface by local;
Second acquisition unit, the output data that send for receiving described the first acquiring unit, and, according to described output data, obtain interface message corresponding to described output data, and the acquisition time of described output data, and described interface message and described acquisition time are sent to generation unit;
Generation unit, for receiving the output data of any one interface that described the first acquiring unit and second acquisition unit send, interface message and acquisition time, output data by described any one interface, described interface message, and described acquisition time is converted to the data record of specified format, and store described data record.
In conjunction with second aspect, in the first in possible implementation, described second acquisition unit, produce interrupt signal specifically for indicating local bus control unit according to the output data of any one interface in described server, and described interrupt signal be sent to local processor; Indicate described processor to be resolved described interrupt signal, and obtain the keyword of the output data of described interrupt signal indication, generate the interface message of described any one interface according to described keyword, wherein, described interface message comprises interface identifier and corresponding interface status information thereof.
In conjunction with second aspect, at the second, in possible implementation, described second acquisition unit, specifically for when receiving the output data of described any one interface, read the temporal information in local real-time clock RTC, the acquisition time using described temporal information as described output data.
The possible implementation in conjunction with the first of aspect, the perhaps possible implementation of the second of second aspect, at the third in possible implementation, described generation unit, specifically for the output data by described any one interface, described interface message, and described acquisition time is converted to the storage instruction of SQL SQL form; The data record of carrying in the storage instruction of described SQL form is stored in local data base.
In conjunction with the third possible implementation of second aspect, in the 4th kind of possible implementation, also comprise output unit, for receive the query statement of input by specified interface; Described query statement is converted to corresponding SQL form query statement; Extract data record corresponding to described SQL form query statement from described local data base, and the Query Result corresponding as described query statement exported using described data record.
The 4th kind of possible implementation in conjunction with second aspect, in the 5th kind of possible implementation, described output unit, when in described query statement, comprising an interface identifier, all data record that the acquisition time sequencing of corresponding output data is corresponding to described interface identifier according to described interface identifier are sorted, and export the data record after described sequence, while in described query statement, comprising at least two interface identifier, obtain respectively the data record that each interface identifier is corresponding, and export successively according to the order of the interface identifier in described query statement the data record that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier, while comprising zero-time and concluding time in described query statement, obtain respectively each interface identifier corresponding in described zero-time and the data record between the concluding time, and export successively according to default interface identifier priority orders the data record that each interface identifier is corresponding, wherein, when the acquisition time sequencing sequence of the output data that all data record that any one interface identifier is corresponding are corresponding according to this any one interface identifier comprises interface status information in described query statement, extract respectively the data record that meets described interface status information corresponding data record from each interface identifier, and export successively according to default interface identifier priority orders the data record that meets described interface status information that each interface identifier is corresponding, wherein, the acquisition time sequencing sequence of the output data that all data record that any one interface identifier is corresponding are corresponding according to this any one interface identifier.
In the embodiment of the present invention, output data by total interface in the BMC monitoring server of server inside, and record acquisition time corresponding to these output data, and by any one interface corresponding interface message, the output data of above-mentioned this any one interface, and acquisition time corresponding to the output data of this any one interface arranges as data record.Adopt technical solution of the present invention, the BMC by server inside realizes the generation of data record from the hardware driving layer, need not be by network and independent terminal equipment and monitoring software, thus effectively reduce cost, improved the reliability that data record is obtained; And, comprise the acquisition time corresponding to output data of interface in the data record of above-mentioned generation, thereby guaranteed that data record and BMC event log are complementary, improved the accuracy that fault location and failure cause detect.
The accompanying drawing explanation
Fig. 1 is the schematic diagram that in prior art, the on-the-spot record mode is obtained server interface output data;
Fig. 2 is the schematic diagram that prior art medium-long range mode is obtained server interface output data;
Fig. 3 is system construction drawing in the embodiment of the present invention;
Fig. 4 is data record product process figure in the embodiment of the present invention;
The detail flowchart that Fig. 5 is user's data query record in the embodiment of the present invention;
Fig. 6 is data record product process figure under concrete application scenarios in the embodiment of the present invention;
Fig. 7 is data record generating apparatus structural representation one in the embodiment of the present invention;
Fig. 8 is data record generating apparatus structural representation two in the embodiment of the present invention;
Fig. 9 is BMC equipment schematic diagram in the embodiment of the present invention.
Embodiment
For the acquisition methods solved in prior art server interface output data exists cost high, acquisition process is unreliable, and the output data lack temporal information and cause fault location and failure cause to detect inaccurate problem.In the embodiment of the present invention, output data by total interface in the BMC monitoring server of server inside, and record acquisition time corresponding to these output data, the output data of above-mentioned this any one interface, and by any one interface corresponding interface message, and acquisition time corresponding to the output data of this any one interface arranges as data record.Adopt technical solution of the present invention, the BMC by server inside realizes the generation of data record from the hardware driving layer, need not be by network and independent terminal equipment and monitoring software, thus effectively reduce cost, improved the reliability that data record is obtained; And, comprise the acquisition time corresponding to output data of interface in the data record of above-mentioned generation, thereby guaranteed that data record and BMC event log are complementary, improved the accuracy that fault location and failure cause detect.
Consult and Figure 3 shows that system architecture diagram in the embodiment of the present invention, wherein, BMC is arranged in server, by hardware interface and server, connect, and by bus control unit and processor the state generated data record according to each interface in server, and the database in BMC is for storing above-mentioned data record.Below in conjunction with accompanying drawing, the preferred embodiment of the present invention is elaborated.
Consult shown in Fig. 4, in the embodiment of the present invention, the detailed process of generated data record is:
Step 400: the output data of obtaining any one interface in server by the hardware interface of BMC this locality.
In the embodiment of the present invention, because server comprises a plurality of interfaces, BMC monitors the state of the total interface in this server, when any one interface output data is arranged in above-mentioned server, the hardware bus passed through between each interface of the hardware interface of BMC and server establishes a connection, and obtains the output data of any one interface in above-mentioned server by this hardware interface.Wherein, the interface of above-mentioned server can be the system serial ports, can be also other system interface (as 80port etc.).
Step 410: according to above-mentioned output data, obtain interface message corresponding to these output data, and the acquisition time of these output data.
In the embodiment of the present invention, after BMC receives the output data of any one interface of server, local bus control unit produces interrupt signal according to the output data of any one interface in above-mentioned server, and this interrupt signal is sent to the processor of BMC, by this processor, this interrupt signal is resolved, obtain the keyword in this terminal signaling, and generating the interface message corresponding to above-mentioned any one interface according to this keyword, this interface message comprises interface identifier and corresponding interface status information thereof.Wherein, above-mentioned interface identifier comprises interface type (as 80port) and interface label (as serial ports 1); The interface status information that above-mentioned interface identifier is corresponding comprises output data category and data attribute, as indicate server wrong error message to occur, perhaps general log information, the obtaining of above-mentioned interface status information is convenient to the follow-up classification storage to the data record that generates.
By said process, BMC obtains interface identifier and the corresponding interface status information thereof of any one interface in server, and when obtaining the output data of above-mentioned any one interface, BMC reads local RTC(Real Time Clock; Real-time clock) temporal information in, and the acquisition time of the output data using this temporal information as above-mentioned any one interface.Wherein, it is optional that above-mentioned RTC generally is positioned at the inside of BMC, can pass through the NTP(Network Time Protocol based on Ethernet; NTP (Network Time Protocol)) agreement makes the time of RTC and the time of server keep synchronizeing.
Adopt technique scheme, when BMC receives the output data of any one interface in server, pass through the acquisition time of the above-mentioned output data of RTC Real-time Obtaining of BMC this locality, output data due to above-mentioned any one interface, and the acquisition time of these output data obtains by BMC, need not obtain by the miscellaneous part in server above-mentioned acquisition time, therefore avoid having by actual acquisition time and the acquisition time of input message the problem postponed; And, output data due to BMC each interface in hardware driving aspect monitor server, when above-mentioned any one interface has the output data, BMC can accurately obtain the information such as acquisition time of these output data and these output data, thereby has improved the obtaining information accuracy.
Step 420: by the output data of above-mentioned any one interface, and the interface message of this any one interface, and acquisition time is converted to the data record of specified format, and stores this data record.
In the embodiment of the present invention, after the processor of BMC is resolved according to the interrupt signal of the output data generation of any one interface bus control unit, obtain the output data of above-mentioned any one interface, interface message (comprising interface identifier and corresponding interface status information thereof), output data by above-mentioned any one interface, the interface identifier of this any one interface and corresponding interface status information thereof, and corresponding acquisition time is converted to SQL(Structure Query Language; SQL) the storage instruction of form; And the data record of carrying in the storage instruction of this SQL form is stored in local data base.From said process, article one, the data record comprises acquisition time, interface status information, and interface identifier, the much informations such as output data, wherein, acquisition time, interface identifier and interface status information all can be used as identification information, and this identification information all can be used as query statement so that the user inquires about data record corresponding to each interface in above-mentioned server the later stage.
Through said process, according to interface identifier and the corresponding interface status information thereof of any one interface, the output data of this any one interface, and the acquisition time of these output data generates the data record that this any one interface is corresponding; When this any one interface, when the next one still has the output data constantly, BMC can repeat said process, generates another data record, the like.Can comprise the data record that a plurality of interfaces are corresponding in above-mentioned database, and each interface can corresponding many data records.Optionally, many can be according to the sequencing of acquisition time corresponding to above-mentioned any one interface data records are sorted, thereby facilitate the later stage user to check and to the management of this data record.
Adopt technique scheme, because BMC disposes independently operating system and working power, therefore, BMC can continue to monitor the output data of each interface in server, is not subject to the impact of the state of server, thereby has guaranteed reliably generated data record.
After said process, preserve many data records in the database of BMC this locality, the user can input corresponding identification information by the user interface at BMC according to the demand of self, inquires about above-mentioned data record.Be specially: the query statement that receives user's input by specified interface; Wherein, this specified interface is CLI(Command Line Interface; Command Line Interface) interface, WEB interface, or SNMP(Simple Network Management Protocol; Simple Network Management Protocol) interface; Due to the above-mentioned query statement of database None-identified, therefore, BMC is converted to corresponding SQL form query statement by above-mentioned query statement; And, according to this SQL form query statement, extract Query Result corresponding to above-mentioned SQL form query statement from the database of BMC this locality; And corresponding Query Result is presented to the user interface of above-mentioned BMC by above-mentioned query statement.
In the process of above-mentioned user's data query record, comprise corresponding identification information in the query statement of user's input, as interface identifier, acquisition time etc.While in above-mentioned query statement, comprising interface identifier, the number of this interface identifier can be one, also can be for a plurality of.Be specially: while in above-mentioned query statement, comprising an interface identifier, all data record that the acquisition time sequencing of corresponding output data is corresponding to this interface identifier according to this interface identifier are sorted, and the data record after sequence is exported as Query Result, for example, when this interface identifier corresponding to three data records, it is data record 1, data record 2 and data record 3, and the acquisition time of the output data of its correspondence is respectively t1, t2 and t3, wherein, t1 is early than t3, t3 is early than t2, according to the Query Result of query statement output, be followed successively by data record 1, data record 3, data record 2, while in above-mentioned query statement, comprising at least two interface identifier, obtain respectively the data record that each interface identifier is corresponding, and export successively according to the order of interface identifier in above-mentioned query statement the data record that each interface identifier is corresponding, wherein, make all data record that any one interface identifier is corresponding, according to this any one interface identifier, the acquisition time sequencing of corresponding output data is sorted, for example, the interface identifier comprised in query statement is followed successively by interface identifier 1 and interface identifier 2, interface identifier 1 is corresponding to data record 10 and data record 11, the acquisition time of the output data of its correspondence is respectively t10 and t11, t11 is early than t10, interface identifier 2 is corresponding to data record 20 and data record 21, the acquisition time of the output data of its correspondence is respectively t20 and t21, t20 is early than t21, according to the Query Result of query statement output, be followed successively by " interface identifier 1: data record 11, data record 10, interface identifier 2: data record 20, data record 21 ".
Comprise interface identifier in above-mentioned query statement, in this query statement, can also comprise acquisition time, this acquisition time is generally two times (zero-time and concluding time), i.e. a time period.Be specially: while comprising zero-time and concluding time in above-mentioned query statement, obtain respectively each interface identifier corresponding in above-mentioned zero-time and the data record between the concluding time, and export successively according to default interface identifier priority orders the data record that each interface identifier is corresponding, wherein, make the acquisition time sequencing sequence of all data record that any one interface identifier is corresponding output data corresponding according to this any one interface identifier.Special, above-mentioned zero-time and concluding time can be (sometime) at the same time, now, BMC will export above-mentioned data record corresponding to each interface identifier sometime, wherein, all data record that any one interface is corresponding can be according to default output Cahn-Ingold-Prelog sequence rule output, as random output, perhaps according to the data category output of carrying in data record, or according to the data attribute output of carrying in data record.Adopt technique scheme, support to present the related data record according to the acquisition time of output data to the user, facilitate the user to inquire about the interface status information corresponding to each interface identifier of particular point in time.
Special, can also comprise interface status information in the query statement of above-mentioned user's input, extract respectively the data record that meets above-mentioned interface status information corresponding data record from each interface identifier, and export successively according to default interface identifier priority orders the data record that meets interface status information that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier.For example, the interface status information comprised in query statement is error message, now, BMC will obtain the total interface of storing in local data base and identify the data record that meets error message in corresponding data record, and export successively according to default interface identifier priority orders the data record that each interface identifier is corresponding, wherein, make all data record that any one interface identifier is corresponding, according to this any one interface identifier, the acquisition time sequencing of corresponding output data is sorted.
Optionally, can comprise a plurality of identification informations in the query statement of user's input, as comprised interface identifier, comprise again acquisition time (as be a moment), now, BMC will obtain the above-mentioned interface identifier stored in the local data base all data record in above-mentioned moment correspondence, and these all data record are exported successively according to default output Cahn-Ingold-Prelog sequence rule.
Consult shown in Fig. 5, in the embodiment of the present invention, the detailed process of user's data query record is:
Step 500:BMC receives the query statement of user's input by specified interface.
Step 510:BMC obtains the identification information carried in this query statement, and this identification information is converted to SQL form query statement.
Step 520:BMC is sent to local database by above-mentioned SQL form query statement.
Step 530: above-mentioned database root extracts corresponding Query Result according to above-mentioned SQL form query statement, and this Query Result is sent to user interface is presented.
In the embodiment of the present invention, above-mentioned Query Result is all data record corresponding to distinct interface in query statement.
Based on technique scheme, consult shown in Fig. 6, introduce in detail below in conjunction with concrete application scenarios the flow process that data record generates:
Step 600: start the monitoring of BMC to each interface in server.
Step 610:BMC judges whether to receive the output data of any one interface in server, if nothing performs step 620; Otherwise, perform step 630.
Step 620:BMC continues the state of total interface in this server of monitoring.
The bus control unit of step 630:BMC generates interrupt signal according to the output data of above-mentioned any one interface, and this interrupt signal is sent to the processor of BMC.
After the processor of step 640:BMC receives above-mentioned interrupt signal, obtain the interface message of carrying in this interrupt signal, and obtain the acquisition time of above-mentioned output data from RTC.
Step 650:BMC is the interface message of above-mentioned any one interface obtained, the output data of this any one interface, and the acquisition time of these output data is converted to the storage instruction of SQL form.
Step 660: the data record of carrying in the storage instruction of above-mentioned generation is stored in local database.
Adopt technique scheme, comprise multiple identification information in the data record generated, the user can obtain corresponding data record by various identification informations, as obtains sometime or output data corresponding to certain interface identifier, thereby is convenient to fault location and failure cause detects.
Based on technique scheme, consult shown in Fig. 7, a kind of data record generating apparatus is provided in the embodiment of the present invention, comprise the first acquiring unit 70, second acquisition unit 71, and generation unit 72, wherein:
The first acquiring unit 70, obtain the output data of any one interface of server, and described output data be sent to second acquisition unit 71 and generation unit 72 for the hardware interface by local;
Second acquisition unit 71, the output data that send for receiving described the first acquiring unit 70, and according to described output data, obtain interface message corresponding to described output data, and the acquisition time of described output data, and described interface message and described acquisition time are sent to generation unit 72;
Generation unit 72, for receiving the output data of any one interface that described the first acquiring unit 70 and second acquisition unit 71 send, interface message and acquisition time, output data by described any one interface, described interface message, and described acquisition time is converted to the data record of specified format, and store described data record.
Wherein, above-mentioned data record generation unit also comprises output unit 73, for receive the query statement of input by specified interface; Described query statement is converted to corresponding SQL form query statement; Extract data record corresponding to described SQL form query statement from described local data base, and the Query Result corresponding as described query statement exported using described data record.
Consult and Figure 8 shows that the another kind of way of realization of data generating device, wherein:
Hardware interface 80, for the output data of each interface of obtaining server, and be sent to these output data to monitor module 82;
Real-time clock 81, for information memory time, and be sent to this temporal information to monitor module 82;
Monitor module 82, for obtain the output data of any one interface of server by local hardware interface 80, and obtain interface message corresponding to described output data, and the acquisition time of the output data of described real-time clock 81 transmissions, and, by the output data of this any one interface, interface message and acquisition time are sent to Data Identification module 83;
Data Identification module 83, for receiving the output data of any one interface of monitoring module 82 transmissions, interface message and acquisition time, and by the output data of described any one interface, described interface message, and described acquisition time is converted to the data record of specified format, and this data record is sent to database 84 by database access interface;
Database 84, for storing above-mentioned data record.
Consult shown in Fig. 9, the present invention also provides a kind of BMC, comprises hardware interface 90, bus control unit 91, and processor 92, database 93:
Hardware interface 90, for the output data of each interface of obtaining server, and be sent to bus control unit 91 by these output data;
Bus control unit 91, for passing through the output data of hardware interface 90 any one interface of reception server, and generate corresponding interrupt signal according to above-mentioned output data, and this interrupt signal be sent to processor 92;
Processor 92, the interrupt signal sent for receiving bus control unit 91, obtain interface message corresponding to described output data according to this interrupt signal, and the acquisition time of described output data, output data by described any one interface, described interface message, and described acquisition time is converted to the data record of specified format, and this data record is sent to database 93.
Database 93, for storing above-mentioned data record.
In sum, in the embodiment of the present invention, BMC obtains the output data of any one interface in server by local hardware interface, and obtains interface message corresponding to described output data, and the acquisition time of above-mentioned output data; By the output data of above-mentioned any one interface, interface message, and acquisition time is stored after being converted to the data record of specified format.Adopt technical solution of the present invention, the BMC by server inside realizes the generation of data record from the hardware driving layer, need not be by network and independent terminal equipment and monitoring software, thus effectively reduce cost, improved the reliability that data record is obtained; And, comprise the acquisition time corresponding to output data of interface in the data record of above-mentioned generation, thereby guaranteed that data record and BMC event log are complementary, improved the accuracy that fault location and failure cause detect.
Those skilled in the art should understand, embodiments of the invention can be provided as method, system or computer program.Therefore, the present invention can adopt complete hardware implementation example, implement software example or in conjunction with the form of the embodiment of software and hardware aspect fully.And the present invention can adopt the form that wherein includes the upper computer program of implementing of computer-usable storage medium (including but not limited to magnetic disc store, CD-ROM, optical memory etc.) of computer usable program code one or more.
The present invention describes with reference to flow chart and/or the block diagram of method, equipment (system) and computer program according to the embodiment of the present invention.Should understand can be in computer program instructions realization flow figure and/or block diagram each flow process and/or the flow process in square frame and flow chart and/or block diagram and/or the combination of square frame.Can provide these computer program instructions to the processor of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing device to produce a machine, make the instruction of carrying out by the processor of computer or other programmable data processing device produce for realizing the device in the function of flow process of flow chart or a plurality of flow process and/or square frame of block diagram or a plurality of square frame appointments.
These computer program instructions also can be stored in energy vectoring computer or the computer-readable memory of other programmable data processing device with ad hoc fashion work, make the instruction be stored in this computer-readable memory produce the manufacture that comprises command device, this command device is realized the function of appointment in flow process of flow chart or a plurality of flow process and/or square frame of block diagram or a plurality of square frame.
These computer program instructions also can be loaded on computer or other programmable data processing device, make and carry out the sequence of operations step to produce computer implemented processing on computer or other programmable devices, thereby the instruction of carrying out on computer or other programmable devices is provided for realizing the step of the function of appointment in flow process of flow chart or a plurality of flow process and/or square frame of block diagram or a plurality of square frame.
Although described the preferred embodiments of the present invention, once those skilled in the art obtain the basic creative concept of cicada, can make other change and modification to these embodiment.So claims are intended to all changes and the modification that are interpreted as comprising preferred embodiment and fall into the scope of the invention.
Obviously, those skilled in the art can carry out various changes and modification and not break away from the spirit and scope of the embodiment of the present invention the embodiment of the present invention.Like this, if within these of the embodiment of the present invention are revised and modification belongs to the scope of the claims in the present invention and equivalent technologies thereof, the present invention also is intended to comprise these changes and modification interior.

Claims (12)

1. a data record generation method, is characterized in that, comprising:
Obtain the output data of any one interface in server by local hardware interface;
According to described output data, obtain interface message corresponding to described output data, and the acquisition time of described output data;
By the output data of described any one interface, described interface message, and described acquisition time is converted to the data record of specified format, and store described data record.
2. the method for claim 1, is characterized in that, obtains interface message corresponding to described output data, specifically comprises:
Indicate local bus control unit to produce interrupt signal according to the output data of any one interface in described server, and described interrupt signal is sent to local processor;
Indicate described processor to be resolved described interrupt signal, and obtain the keyword of the output data of described interrupt signal indication, generate the interface message of described any one interface according to described keyword, wherein, described interface message comprises interface identifier and corresponding interface status information thereof.
3. the method for claim 1, is characterized in that, obtains the acquisition time of described output data, specifically comprises:
When receiving the output data of described any one interface, read the temporal information in local real-time clock RTC, the acquisition time using described temporal information as described output data.
4. as claim 1,2 or 3 described methods, it is characterized in that, by the output data of described any one interface, described interface message, and described acquisition time is converted to the data record of specified format, and store described data record, specifically comprise:
By the output data of described any one interface, described interface message, and described acquisition time is converted to the storage instruction of SQL SQL form;
The data record of carrying in the storage instruction of described SQL form is stored in local data base.
5. method as claimed in claim 4, is characterized in that, after storing described data record, further comprises:
Receive the query statement of input by specified interface;
Described query statement is converted to corresponding SQL form query statement;
Extract data record corresponding to described SQL form query statement from described local data base, and the Query Result corresponding as described query statement exported using described data record.
6. method as claimed in claim 5, is characterized in that, exports the Query Result that described query statement is corresponding, specifically comprises:
While in described query statement, comprising an interface identifier, all data record that the acquisition time sequencing of corresponding output data is corresponding to described interface identifier according to described interface identifier are sorted, and export the data record after described sequence;
While in described query statement, comprising at least two interface identifier, obtain respectively the data record that each interface identifier is corresponding, and export successively according to the order of the interface identifier in described query statement the data record that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier;
While comprising zero-time and concluding time in described query statement, obtain respectively each interface identifier corresponding in described zero-time and the data record between the concluding time, and export successively according to default interface identifier priority orders the data record that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier;
While in described query statement, comprising interface status information, extract respectively the data record that meets described interface status information corresponding data record from each interface identifier, and export successively according to default interface identifier priority orders the data record that meets described interface status information that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier.
7. a data record generating apparatus, is characterized in that, comprising:
The first acquiring unit, obtain the output data of any one interface of server, and described output data be sent to second acquisition unit and generation unit for the hardware interface by local;
Second acquisition unit, the output data that send for receiving described the first acquiring unit, and, according to described output data, obtain interface message corresponding to described output data, and the acquisition time of described output data, and described interface message and described acquisition time are sent to generation unit;
Generation unit, for receiving the output data of any one interface that described the first acquiring unit and second acquisition unit send, interface message and acquisition time, output data by described any one interface, described interface message, and described acquisition time is converted to the data record of specified format, and store described data record.
8. device as claimed in claim 7, is characterized in that, described second acquisition unit, specifically for:
Indicate local bus control unit to produce interrupt signal according to the output data of any one interface in described server, and described interrupt signal is sent to local processor; Indicate described processor to be resolved described interrupt signal, and obtain the keyword of the output data of described interrupt signal indication, generate the interface message of described any one interface according to described keyword, wherein, described interface message comprises interface identifier and corresponding interface status information thereof.
9. device as claimed in claim 7, is characterized in that, described second acquisition unit, specifically for:
When receiving the output data of described any one interface, read the temporal information in local real-time clock RTC, the acquisition time using described temporal information as described output data.
10. as claim 7,8 or 9 described devices, it is characterized in that, described generation unit, specifically for:
By the output data of described any one interface, described interface message, and described acquisition time is converted to the storage instruction of SQL SQL form; The data record of carrying in the storage instruction of described SQL form is stored in local data base.
11. device as claimed in claim 10, is characterized in that, also comprises output unit, for:
Receive the query statement of input by specified interface; Described query statement is converted to corresponding SQL form query statement; Extract data record corresponding to described SQL form query statement from described local data base, and the Query Result corresponding as described query statement exported using described data record.
12. device as claimed in claim 11, is characterized in that, described output unit, specifically for:
While in described query statement, comprising an interface identifier, all data record that the acquisition time sequencing of corresponding output data is corresponding to described interface identifier according to described interface identifier are sorted, and export the data record after described sequence; While in described query statement, comprising at least two interface identifier, obtain respectively the data record that each interface identifier is corresponding, and export successively according to the order of the interface identifier in described query statement the data record that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier; While comprising zero-time and concluding time in described query statement, obtain respectively each interface identifier corresponding in described zero-time and the data record between the concluding time, and export successively according to default interface identifier priority orders the data record that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier; While in described query statement, comprising interface status information, extract respectively the data record that meets described interface status information corresponding data record from each interface identifier, and export successively according to default interface identifier priority orders the data record that meets described interface status information that each interface identifier is corresponding, the acquisition time sequencing sequence of the output data that all data record that wherein, any one interface identifier is corresponding are corresponding according to this any one interface identifier.
CN201310302291.5A 2013-07-16 2013-07-16 A kind of data record generation method and device Expired - Fee Related CN103441861B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201310302291.5A CN103441861B (en) 2013-07-16 2013-07-16 A kind of data record generation method and device
PCT/CN2014/072211 WO2015007091A1 (en) 2013-07-16 2014-02-19 Data record generating method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310302291.5A CN103441861B (en) 2013-07-16 2013-07-16 A kind of data record generation method and device

Publications (2)

Publication Number Publication Date
CN103441861A true CN103441861A (en) 2013-12-11
CN103441861B CN103441861B (en) 2017-03-08

Family

ID=49695530

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201310302291.5A Expired - Fee Related CN103441861B (en) 2013-07-16 2013-07-16 A kind of data record generation method and device

Country Status (2)

Country Link
CN (1) CN103441861B (en)
WO (1) WO2015007091A1 (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2015007091A1 (en) * 2013-07-16 2015-01-22 华为技术有限公司 Data record generating method and device
CN104754035A (en) * 2015-03-06 2015-07-01 浪潮集团有限公司 Method for guaranteeing management mainboard time by virtue of cooperation of NTP and RTC chip
CN105574010A (en) * 2014-10-13 2016-05-11 阿里巴巴集团控股有限公司 Data querying method and device
CN107219788A (en) * 2016-03-22 2017-09-29 兄弟工业株式会社 Information Collection System, formation gathering method, terminal installation
CN109947690A (en) * 2019-03-18 2019-06-28 联想(北京)有限公司 Control method, device and electronic equipment
CN111061338A (en) * 2019-11-30 2020-04-24 苏州浪潮智能科技有限公司 Method, system and equipment for updating time sequence of baseboard management controller
CN111221763A (en) * 2018-11-26 2020-06-02 英业达科技有限公司 Information acquisition system
US10698788B2 (en) 2015-10-02 2020-06-30 Wiwynn Corporation Method for monitoring server, and monitoring device and monitoring system using the same
CN111554367A (en) * 2020-04-26 2020-08-18 贵州精准健康数据有限公司 Data processing method and device and computer readable medium

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TWI679579B (en) * 2018-08-17 2019-12-11 英業達股份有限公司 Remote login method for server subsystem and remote login system

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101135715A (en) * 2007-05-25 2008-03-05 中兴通讯股份有限公司 North direction interface data integrity verification method
US20080103729A1 (en) * 2006-10-31 2008-05-01 Microsoft Corporation Distributed detection with diagnosis
CN101247275A (en) * 2008-03-18 2008-08-20 杭州华三通信技术有限公司 Interrupt reporting method and network appliance
CN101355531A (en) * 2008-09-24 2009-01-28 华为技术有限公司 Method, apparatus and equipment for transmitting and receiving information
CN101540694A (en) * 2008-03-17 2009-09-23 联想(北京)有限公司 Method for monitoring server and server adopting same
CN101594259A (en) * 2008-05-28 2009-12-02 韩美爱提株式会社 Terminating apparatus management system and interface arrangement and correlation method, recording medium

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1308834C (en) * 2002-03-15 2007-04-04 联想(北京)有限公司 Method for getting and outputting information monitored by server through multiple approaches
CN102073578A (en) * 2009-11-23 2011-05-25 英业达股份有限公司 Method for recording system event log
CN102478897A (en) * 2010-11-30 2012-05-30 英业达股份有限公司 Computer system
CN103441861B (en) * 2013-07-16 2017-03-08 杭州华为数字技术有限公司 A kind of data record generation method and device

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080103729A1 (en) * 2006-10-31 2008-05-01 Microsoft Corporation Distributed detection with diagnosis
CN101135715A (en) * 2007-05-25 2008-03-05 中兴通讯股份有限公司 North direction interface data integrity verification method
CN101540694A (en) * 2008-03-17 2009-09-23 联想(北京)有限公司 Method for monitoring server and server adopting same
CN101247275A (en) * 2008-03-18 2008-08-20 杭州华三通信技术有限公司 Interrupt reporting method and network appliance
CN101594259A (en) * 2008-05-28 2009-12-02 韩美爱提株式会社 Terminating apparatus management system and interface arrangement and correlation method, recording medium
CN101355531A (en) * 2008-09-24 2009-01-28 华为技术有限公司 Method, apparatus and equipment for transmitting and receiving information

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2015007091A1 (en) * 2013-07-16 2015-01-22 华为技术有限公司 Data record generating method and device
CN105574010A (en) * 2014-10-13 2016-05-11 阿里巴巴集团控股有限公司 Data querying method and device
CN104754035A (en) * 2015-03-06 2015-07-01 浪潮集团有限公司 Method for guaranteeing management mainboard time by virtue of cooperation of NTP and RTC chip
US10698788B2 (en) 2015-10-02 2020-06-30 Wiwynn Corporation Method for monitoring server, and monitoring device and monitoring system using the same
CN107219788A (en) * 2016-03-22 2017-09-29 兄弟工业株式会社 Information Collection System, formation gathering method, terminal installation
CN107219788B (en) * 2016-03-22 2019-07-26 兄弟工业株式会社 Information Collection System, formation gathering method, terminal installation
CN111221763A (en) * 2018-11-26 2020-06-02 英业达科技有限公司 Information acquisition system
CN109947690A (en) * 2019-03-18 2019-06-28 联想(北京)有限公司 Control method, device and electronic equipment
CN109947690B (en) * 2019-03-18 2023-05-23 联想(北京)有限公司 Control method and device and electronic equipment
CN111061338A (en) * 2019-11-30 2020-04-24 苏州浪潮智能科技有限公司 Method, system and equipment for updating time sequence of baseboard management controller
CN111061338B (en) * 2019-11-30 2021-06-01 苏州浪潮智能科技有限公司 Method, system and equipment for updating time sequence of baseboard management controller
CN111554367A (en) * 2020-04-26 2020-08-18 贵州精准健康数据有限公司 Data processing method and device and computer readable medium

Also Published As

Publication number Publication date
CN103441861B (en) 2017-03-08
WO2015007091A1 (en) 2015-01-22

Similar Documents

Publication Publication Date Title
CN103441861A (en) Method and device for generating data records
US8792385B2 (en) Method and device for auto-generating goose signal connection topology from substation level
CN102355368B (en) Fault processing method of network equipment and system
WO2014049804A1 (en) System operation trace method in distributed system
CN110554930B (en) Data storage method and related equipment
CN104281520A (en) Tracking and debugging method, device and system
EP2535994A2 (en) Fault processing system
CN111800443A (en) Data processing system and method, device and electronic equipment
US10296431B2 (en) Generation of debugging log list in a blade server environment
CN109508295B (en) Block chain consensus algorithm testing method and device, calculating device and storage medium
CN109254922A (en) A kind of automated testing method and device of server B MC Redfish function
CN113127307A (en) Method for processing tracing request, related device, system and storage medium
US9280426B2 (en) System and method for server redundancy
CN114978883B (en) Network wakeup management method and device, electronic equipment and storage medium
CN110427297B (en) Diagnostic information acquisition method, system, gateway and computer readable medium
CN111324480A (en) Large host transaction fault positioning system and method
CN103678423A (en) Data file input system, device and method
CN104539449B (en) A kind of failure information processing method and relevant apparatus
CN107861821B (en) Mining method and device for module call relation and computer readable medium
CN113791792A (en) Application calling information acquisition method and device and storage medium
CN109347685A (en) A kind of network equipment, logic device and notification information transmission method
CN109257185A (en) A kind of network equipment, service card, logic device and notification information transmission method
CN114756301A (en) Log processing method, device and system
CN108805741B (en) Fusion method, device and system of power quality data
US11106656B2 (en) Method and apparatus for a software-seamed and augmented view of an asynchronous network fabric

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20170308

Termination date: 20190716