WorkLog Frontpage Log in / Register
High-Level Description | Task Dependencies | High-Level Specification | Low-Level Design | File Attachments | User Comments | Time Estimates | Funding and Votes | Progress Reports

 add server-side error logging
Title
Task ID177
Queue
Version
Status
Priority
Copies toKnielsen
Sergei
Created byMdcallag22 Feb 2011Done
Supervisor   
Lead Architect    
Architecture Review  
Implementor 30 May 2011
Code Review  
QA  
Documentation  
 High-Level Description
I want to log all or a sample of errors on the server side into a new log file 
(not general, error or slow query log) and into a file that can be rotated. In the 
facebook patch I added code to sample query errors into the slow query log using -
-log-sample-error-rate:
* when 0 do not sample
* when 1 then log all errors
* when > 1 then sample 1 of --log-sample-error-rate queries

This should have:
* query text
* username
* timestamp
* database
* errno
* error text
* client IP

The log should support rotation and possibly auto-rotation when it reaches a 
certain size.
 Task Dependencies
Others waiting for Task 177Task 177 is waiting forGraph
 
 High-Level Specification
 Low-Level Design
 File Attachments
 NameTypeSizeByDate
C:\cygwin\home\HF\wl_177_patchtext/plain24 KBHolyfoot2011-05-30
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Holyfoot2030 May 2011
Total20 
 Hrs WorkedProgressCurrentOriginal
This Task2000
Total2000
 
 Funding and Votes
Votes: 1: 33%
 Change vote: Useless    Nice to have    Important    Very important    
Funding: 0 offers, total 0 Euro
 Progress Reports
(Sergei - Sat, 16 Jul 2011, 14:52) 
    
Status updated.
--- /tmp/wklog.177.old.28296	2011-07-16 14:52:40.000000000 +0000
+++ /tmp/wklog.177.new.28296	2011-07-16 14:52:40.000000000 +0000
@@ -1,2 +1,2 @@
-Assigned
+In-Progress
(Sergei - Sat, 16 Jul 2011, 14:14) 
    
Code Review updated: Serg -> Sergei
(Holyfoot - Fri, 15 Jul 2011, 15:33) 
    
Code Review updated:  -> Serg
(Holyfoot - Fri, 15 Jul 2011, 15:33) 
    
Version updated.
--- /tmp/wklog.177.old.28182	2011-07-15 15:33:32.000000000 +0000
+++ /tmp/wklog.177.new.28182	2011-07-15 15:33:32.000000000 +0000
@@ -1,2 +1,2 @@
-WorkLog-4.0
+Server-9.x
(Holyfoot - Fri, 15 Jul 2011, 15:33) 
    
Supervisor updated:  -> Igor
(Holyfoot - Mon, 30 May 2011, 18:08) 
    
Category updated.
--- /tmp/wklog.177.old.22504	2011-05-30 18:08:27.000000000 +0000
+++ /tmp/wklog.177.new.22504	2011-05-30 18:08:27.000000000 +0000
@@ -1,2 +1,2 @@
-Server-RawIdeaBin
+Server-Sprint
(Holyfoot - Mon, 30 May 2011, 18:08) 
    
Implementor signoff
(Holyfoot - Mon, 30 May 2011, 18:07) 
    
Patch with the implementation for this task added.
Worked 20 hours and estimate 0 hours remain (original estimate increased by 20 hours).
(Holyfoot - Mon, 30 May 2011, 18:06) 
    
New attachment: 'C:\cygwin\home\HF\wl_177_patch'
(Holyfoot - Mon, 30 May 2011, 18:05) 
    
Status updated.
--- /tmp/wklog.177.old.22345	2011-05-30 18:05:53.000000000 +0000
+++ /tmp/wklog.177.new.22345	2011-05-30 18:05:53.000000000 +0000
@@ -1,2 +1,2 @@
-Un-Assigned
+Assigned
-- View All Progress Notes (13 total) --
Report Generator:
 
Saved Reports:
WorkLog v4.0.0
  © 2010  Sergei Golubchik and Monty Program AB
  © 2004  Andrew Sweger <yDNA@perlocity.org> and Addnorya
  © 2003  Matt Wagner <matt@mysql.com> and MySQL AB