{"id":996,"date":"2014-04-18T07:00:33","date_gmt":"2014-04-18T07:00:33","guid":{"rendered":"http:\/\/blog.zhukunqian.com\/?p=996"},"modified":"2014-04-18T07:00:33","modified_gmt":"2014-04-18T07:00:33","slug":"loganalyzer3-6-5%e7%9a%84%e4%b8%80%e4%b8%aabug","status":"publish","type":"post","link":"https:\/\/blog.zhukunqian.com\/?p=996","title":{"rendered":"loganalyzer3.6.5\u7684\u4e00\u4e2abug"},"content":{"rendered":"

\u4ece\u6628\u5929\u5f00\u59cb\u641eloganalyzer\uff0c\u4e00\u76f4\u65e0\u6cd5\u663e\u793a\u81ea\u5df1mysql\u4e2d\u7684\u65e5\u5fd7\u3002<\/p>\n

\u65e5\u5fd7\u8868\u662f\u81ea\u5b9a\u4e49\u7684\u3002<\/p>\n

+---------+---------------------+------+-----+-------------------+----------------+\r\n| Field   | Type                | Null | Key | Default           | Extra          |\r\n+---------+---------------------+------+-----+-------------------+----------------+\r\n| logId   | bigint(20) unsigned | NO   | PRI | NULL              | auto_increment | \r\n| account | char(64)            | NO   |     |                   |                | \r\n| server  | int(10) unsigned    | NO   |     | 0                 |                | \r\n| device  | char(64)            | NO   |     |                   |                | \r\n| error   | blob                | YES  |     | NULL              |                | \r\n| uID     | int(11)             | YES  |     | 0                 |                | \r\n| date    | timestamp           | NO   |     | CURRENT_TIMESTAMP |                | \r\n+---------+---------------------+------+-----+-------------------+----------------+<\/pre>\n
\u81ea\u5df1\u5b9a\u4e49datasource,field,view,dbmapping,\u4e00\u5207\u90fdOK\u3002\u4f46\u5c31\u662f\u663e\u793a\u6709\u95ee\u9898\u3002<\/p>\n
\u5982\u4e0b\u56fe\u6240\u793a\u5c11\u4e86uID\u90a3\u4e00\u5217\u7684\u6570\u636e\u3002<\/p>\n
\"\"<\/p>\n
google\u4e86N\u591a\u8d44\u6599\u90fd\u65e0\u89e3\u3002<\/p>\n
\u7f51\u4e0a\u4e5f\u6709\u4e00\u4e2a\u76f8\u540c\u73b0\u8c61\u7684\u5e16\u5b50\uff0c\u4e5f\u6ca1\u6709\u627e\u5230\u539f\u56e0\uff1ahttp:\/\/kb.monitorware.com\/reading-custom-mysql-table-t11919.html<\/a><\/p>\n
\u4e00\u6c14\u4e4b\u5916\u611f\u89c9\u81ea\u5df1debug\u53ef\u80fd\u80fd\u627e\u5230\u539f\u56e0\u3002<\/p>\n
\u5728classes\/logstreamdb.class.php \u4e2d<\/p>\n
\u4fee\u6539readnext\u65b9\u6cd5\u5982\u4e0b\uff1a<\/p>\n
 if ( $content['MaxExecutionTime'] > 0 && $scriptruntime > ($content['MaxExecutionTime']-2) )\r\n                        {\r\n                                \/\/ This may display a warning message, so the user knows we stopped reading records because of the script timeout.\r\n                                $content['logstream_warning'] = "false";\r\n\r\n                                \/\/ Run optional Message Parsers now\r\n                                if ( isset($arrProperitesOut[SYSLOG_MESSAGE]) )\r\n                                {\r\n                                        $retParser = $this->_logStreamConfigObj->ProcessMsgParsers($arrProperitesOut[SYSLOG_MESSAGE], $arrProperitesOut);\r\n\r\n                                        \/\/ Check if we have to skip the message!\r\n                                        if ( $retParser == ERROR_MSG_SKIPMESSAGE )\r\n                                                $ret = $retParser;\r\n                                }\r\n\r\n                                \/\/ Set uID to the PropertiesOut! \/\/DEBUG -> $this->_currentRecordNum;\r\n                                echo "<br\/>";\r\n                                echo $dbmapping[$szTableType];\r\n                                foreach($dbmapping[$szTableType] as $key => $val) {\r\n                                   echo "|".$key."|".$val, '<br>';\r\n                                }\r\n                                foreach($dbmapping[$szTableType]['DBMAPPINGS'] as $key => $val) {\r\n                                   echo "|_|".$key."|".$val, '<br>';\r\n                                }\r\n\r\n                                foreach($this->bufferedRecords[$this->_currentRecordNum] as $key => $val) {\r\n                                   echo "|||".$key."|".$val,"<br\/>";\r\n                                }\r\n\r\n                                echo "SYSLOG_UID:".SYSLOG_UID."<br\/>";\r\n                                echo "hello ". $dbmapping[$szTableType]['DBMAPPINGS']['uID']."world";\r\n                                echo "hello ". $this->bufferedRecords[$this->_currentRecordNum]['uid']."world";\r\n                                echo "<br\/>";\r\n                                $uID = $arrProperitesOut[SYSLOG_UID] = $this->bufferedRecords[$this->_currentRecordNum][$dbmapping[$szTableType]['DBMAPPINGS'][SYSLOG_UID]];\r\n\r\n                                \/\/ Increment $_currentRecordNum\r\n                                $this->_currentRecordNum++;\r\n                        }<\/pre>\n
\u628adebug\u4fe1\u606f\u8f93\u51fa\u540e\uff0c\u624d\u53d1\u73b0\u95ee\u9898\u3002<\/p>\n
uID\u5bf9\u5e94\u6570\u636e\u4e2d\u7684logId\u5b57\u6bb5\uff0c\u4f46\u5728this->bufferedRecords\u4e2d\u7684key\u5168\u662f\u5c0f\u5199\u7684\u3002\u4f60\u59b9\u7684\uff0c\u5404\u4e2a\u6587\u6863\u4e0a\u8c01\u4e5f\u6ca1\u5199\u8981\u6ce8\u610f\u8fd9\u4e48\u4e00\u4e2a\u4e1c\u897f\u3002dbmapping\u76f4\u63a5\u4fee\u6539uID\u6539\u4e3alogid\u5c0f\u5199\u540e\uff0c\u65e5\u5fd7\u67e5\u770bbug\u89e3\u51b3\u4e86\u3002<\/p>\n
\"\"<\/p>\n
\u6b63\u5e38\u7684\u663e\u793a\uff1a<\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u4ece\u6628\u5929\u5f00\u59cb\u641eloganalyzer\uff0c\u4e00\u76f4\u65e0\u6cd5\u663e\u793a\u81ea\u5df1mysql\u4e2d\u7684\u65e5\u5fd7\u3002 \u65e5\u5fd7\u8868 …<\/p>\n
\u7ee7\u7eed\u9605\u8bfb »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/996"}],"collection":[{"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=996"}],"version-history":[{"count":2,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/996\/revisions"}],"predecessor-version":[{"id":998,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/996\/revisions\/998"}],"wp:attachment":[{"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}