Changeset 2879 for WAeUP_SysConf/logging/trunk

Timestamp:

8 Dec 2007, 00:05:14 (17 years ago)

Author:

uli

Message:

Overlong fields are corrected now.

File:

• WAeUP_SysConf/logging/trunk/usr/local/lib/zevents.py (modified) (1 diff)

WAeUP_SysConf/logging/trunk/usr/local/lib/zevents.py

@@ -90 +90 @@
         }
 
+    # If msg_text is too long, append it to traceback...
+    if len(val['msg_text']) > 1024:
+        val['traceback'] = val['msg_text'] + " " + val['traceback']
+        val['msg_text'] = val['msg_text'][:1024]
+
+    # Shorten overlong fields...
+    for name,maxlen in [('loglevel',32), ('msg_src',1024), ('msg_text', 1024),
+                 ('err_type', 32), ('err_msg', 1024)]:
+        val[name]=val[name][:maxlen]
+
     if mode == "COPY":
         print "%07d\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s" % (
-            val['id'], val['date'], val['time'], val['loglevel'],
-            val['msg_src'], val['msg_text'], val['err_type'], val['err_msg'],
-            val['traceback']
+            val['id'], val['date'], val['time'], val['msg_src'],
+            val['msg_text'], val['err_type'], val['err_msg'], val['traceback'],
+            val['loglevel']
         )
     else:
-        print "INSERT INTO \"ZEVENTS\" (\"ID\",\"DATE\",\"TIME\",\"LOGLEVEL\",\"MSG_SRC\",\"MSG_TEXT\",\"ERR_TYPE\",\"ERR_MSG\",\"TRACEBACK\") VALUES ('%07d','%s','%s','%s','%s','%s','%s','%s','%s');" % (
-            val['id'], val['date'], val['time'], val['loglevel'],
-            val['msg_src'], val['msg_text'], val['err_type'], val['err_msg'],
-            val['traceback']
+        print "INSERT INTO \"ZEVENTS\" (\"ID\",\"DATESTR\",\"TIMESTR\",\"MSG_SRC\",\"MSG\",\"ERR_TYPE\",\"ERR_MSG\",\"TRACEBACK\",\"LOGLEVEL\") VALUES ('%07d','%s','%s','%s','%s','%s','%s','%s');" % (
+            val['id'], val['date'], val['time'], val['msg_src'],
+            val['msg_text'], val['err_type'], val['err_msg'], val['traceback'],
+            val['loglevel']
         )
     return