|
主題: [問題]LT1.2.1的/tmp/sql_error.log高達27GB?? 作者: TomexOu 於 四月 19, 2007, 06:55:52 下午 最近由1.1.6升級至1.2.1，過程沒有發生什麼問題
只有覺得在載入頁面時慢了一些，比前版的慢。 過了不久，常常就發生磁碟空間不足 經查竟發現/tmp/sql_error.log高達27GB，怎會這樣?! 我該怎麼避免寫這檔案的log檔呢? 主題: Re: [問題]LT1.2.1的/tmp/sql_error.log高達27GB?? 作者: TomexOu 於 四月 19, 2007, 07:00:12 下午 查了log內容:
19-04-2007 19:56:42 ERROR - The following query = INSERT INTO bayesian_filter_info (blog_id, total_spam, total_nonspam) VALUES ('212', '0', '');generated the following error message = Out of range value adjusted for column 'total_nonspam' at row 1 Blog\class\logger\logger\logger.class.php(157): PatternLayout.format Blog\class\logger\logger\logger.class.php(137): Logger.log Blog\class\dao\model.class.php(142): Logger.error Blog\class\dao\bayesianfilterinfos.class.php(144): Model.Execute Blog\class\dao\bayesianfilterinfos.class.php(173): BayesianFilterInfos.insert Blog\class\dao\bayesianfilterinfos.class.php(37): BayesianFilterInfos.insertLate Blog\class\dao\bayesianfilterinfos.class.php(40): BayesianFilterInfos.getBlogBayesianFilterInfo Blog\class\security\bayesianfilter.class.php(198): BayesianFilterInfos.getBlogBayesianFilterInfo Blog\class\security\bayesianfilter.class.php(182): BayesianFilter._getMostSignificantTokens Blog\class\security\bayesianfilter.class.php(93): BayesianFilter.getSpamProbability Blog\class\security\pipeline.class.php(166): BayesianFilter.filter Blog\class\action\blogaction.class.php(83): Pipeline.process Blog\class\action\addcommentaction.class.php(42): BlogAction.BlogAction Blog\class\controller\controller.class.php(340): AddCommentAction.AddCommentAction Blog\index.php(52): Controller.process 看起來total_nonspam應該要是數值，卻傳入空白，導致錯誤! 有否可能這schema有問題呢? 我先把bayesian_filter_enabled 設為false了。 |