source: WAeUP_SysConf/logging/trunk/tests/event-staff.log.test @ 8794

Last change on this file since 8794 was 2827, checked in by uli, 17 years ago

Added test script to check logfile parser functionality.
File size: 12.6 KB
Line 
1INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000002','2007-11-29','10:22:38','INFO','Z2','Log files reopened successfully','','','');
2INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000003','2007-11-29','10:23:29','INFO','Skins.disable_pins','benamechi disabled pin ART11244402853','','','');
3INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000004','2007-11-29','10:24:01','INFO','Skins.search_students','despej searches for student with id N248648','','','');
4INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000005','2007-11-29','10:24:08','INFO','Skins.getStudentFolderInfo','searchtime 0.001000','','','');
5INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000006','2007-11-29','10:24:08','INFO','Skins.getStudentFolderInfo','listtime 0.025000','','','');
6INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000007','2007-11-29','10:26:30','INFO','Skins.logged_in','abigailoigbochie logged in','','','');
7INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000008','2007-11-29','10:27:04','INFO','Skins.search_students','despej searches for student with matric_no EDU0000370','','','');
8INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000009','2007-11-29','10:27:07','INFO','Skins.search_students','abigailoigbochie searches for student with matric_no ART0400434','','','');
9INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000010','2007-11-29','10:27:17','INFO','Skins.search_students','despej searches for student with matric_no EDU0000370','','','');
10INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000011','2007-11-29','10:27:18','INFO','Skins.search_students','abigailoigbochie searches for student with matric_no ART0400434','','','');
11INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000012','2007-11-29','10:33:02','INFO','Skins.enable_pins','benamechi enabled pin ART11244402853','','','');
12INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000013','2007-11-29','10:39:03','INFO','ZPublisher.Conflict','ConflictError at /process_queues: database conflict error (oid 0x9a6b47, class Products.QueueCatalog.CatalogEventQueue.CatalogEventQueue, serial this txn started with 0x03720902958d85dd 2007-11-29 09:38:35.051443, serial currently committed 0x0372090300075988 2007-11-29 09:39:00.006729) (3 conflicts (0 unresolved) since startup at Wed Nov 28 21:25:48 2007)','ConflictError','','');
13INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000014','2007-11-29','10:43:02','INFO','ZPublisher.Conflict','ConflictError at /process_queues: database conflict error (oid 0x9a6b50, class Products.QueueCatalog.CatalogEventQueue.CatalogEventQueue, serial this txn started with 0x037209065e9a6644 2007-11-29 09:42:22.172607, serial currently committed 0x03720907019c41ee 2007-11-29 09:43:00.377433) (4 conflicts (0 unresolved) since startup at Wed Nov 28 21:25:48 2007)','ConflictError','','');
14INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000015','2007-11-29','10:44:02','INFO','ZPublisher.Conflict','ConflictError at /process_queues: database conflict error (oid 0x9a6b50, class Products.QueueCatalog.CatalogEventQueue.CatalogEventQueue, serial this txn started with 0x037209079e46d4cc 2007-11-29 09:43:37.096098, serial currently committed 0x03720907fe21cf55 2007-11-29 09:43:59.562204) (5 conflicts (0 unresolved) since startup at Wed Nov 28 21:25:48 2007)','ConflictError','','');
15INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000016','2007-11-29','10:50:07','INFO','ZPublisher.Conflict','ConflictError at /process_queues: database conflict error (oid 0x9a6d45, class Products.QueueCatalog.CatalogEventQueue.CatalogEventQueue, serial this txn started with 0x0372090d53e25c88 2007-11-29 09:49:19.660365, serial currently committed 0x0372090e143fafcc 2007-11-29 09:50:04.745807) (6 conflicts (0 unresolved) since startup at Wed Nov 28 21:25:48 2007)','ConflictError','','');
16INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000017','2007-11-29','10:50:30','INFO','Widgets.PumePinWidget.validate','kehindesamuel tried to use scratch card APP-3-7909832385','','','');
17INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000018','2007-11-29','10:51:00','INFO','Widgets.PumePinWidget.validate','kehindesamuel tried to use scratch card APP-3-7909832385','','','');
18INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000019','2007-11-29','10:53:56','INFO','Skins.search_students','despej searches for student with id P251128','','','');
19INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000020','2007-11-29','10:54:45','INFO','Skins.logged_in','shinakale logged in','','','');
20INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000021','2007-11-29','10:55:56','INFO','Skins.search_students','shinakale searches for student with id F320495','','','');
21INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000022','2007-11-29','10:56:00','INFO','Skins.getStudentFolderInfo','searchtime 0.000000','','','');
22INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000023','2007-11-29','10:56:00','INFO','Skins.getStudentFolderInfo','listtime 0.027000','','','');
23INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000024','2007-11-29','10:57:53','INFO','Skins.search_students','despej searches for student with id P251128','','','');
24INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000025','2007-11-29','10:58:00','INFO','Skins.getStudentFolderInfo','searchtime 0.001000','','','');
25INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000026','2007-11-29','10:58:00','INFO','Skins.getStudentFolderInfo','listtime 0.022000','','','');
26INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000027','2007-11-29','10:58:00','INFO','Skins.waeup_edit','shinakale edited StudentPersonal personal of F320495','','','');
27INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000028','2007-11-29','10:58:29','INFO','Skins.getStudentFolderInfo','searchtime 0.000000','','','');
28INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000029','2007-11-29','10:58:29','INFO','Skins.getStudentFolderInfo','listtime 0.005000','','','');
29INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000030','2007-11-29','10:59:37','INFO','Skins.waeup_edit','despej edited StudentStudyCourse study_course of P251128','','','');
30INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000031','2007-11-29','10:59:46','INFO','Skins.getStudentFolderInfo','searchtime 0.000000','','','');
31INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000032','2007-11-29','10:59:46','INFO','Skins.getStudentFolderInfo','listtime 0.006000','','','');
32INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000033','2007-11-29','11:01:39','INFO','Skins.search_students','despej searches for student with id U313480','','','');
33INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000034','2007-11-29','11:01:44','INFO','Skins.logged_in','shinakale logged in','','','');
34INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000035','2007-11-29','11:01:46','INFO','Skins.getStudentFolderInfo','searchtime 0.000000','','','');
35INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000036','2007-11-29','11:01:46','INFO','Skins.getStudentFolderInfo','listtime 0.057000','','','');
36INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000037','2007-11-29','11:12:05','INFO','Skins.search_students','abigailoigbochie searches for student with id C837922','','','');
37INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000038','2007-11-29','11:12:11','INFO','Skins.getStudentFolderInfo','searchtime 0.000000','','','');
38INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000039','2007-11-29','11:12:11','INFO','Skins.getStudentFolderInfo','listtime 0.059000','','','');
39INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000040','2007-11-29','11:14:01','INFO','Skins.search_students','abigailoigbochie searches for student with matric_no SSC0306387','','','');
40INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000041','2007-11-29','11:15:01','INFO','Skins.search_students','abigailoigbochie searches for student with id X810044','','','');
41INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000042','2007-11-29','11:15:07','INFO','Skins.getStudentFolderInfo','searchtime 0.001000','','','');
42INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000043','2007-11-29','11:15:07','INFO','Skins.getStudentFolderInfo','listtime 0.044000','','','');
43INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000044','2007-11-29','11:16:43','INFO','Skins.logged_in','edafeohwo logged in','','','');
44INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000045','2007-11-29','11:17:16','INFO','Skins.search_students','edafeohwo searches for student with matric_no T254455','','','');
45INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000046','2007-11-29','11:17:24','INFO','Skins.search_students','edafeohwo searches for student with id T254455','','','');
46INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000047','2007-11-29','11:17:38','INFO','Skins.getStudentFolderInfo','searchtime 0.000000','','','');
47INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000048','2007-11-29','11:17:38','INFO','Skins.getStudentFolderInfo','listtime 0.006000','','','');
48INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000049','2007-11-29','11:19:44','INFO','Skins.disable_pins','despej disabled pin APP46615089463','','','');
49INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000050','2007-11-29','11:22:17','INFO','Skins.enable_pins','despej enabled pin APP46615089463','','','');
50INSERT INTO "ZEVENTS" ("ID","DATESTR","TIMESTR","LOGLEVEL","MSG_SRC","MSG","ERR_TYPE","ERR_MSG","TRACEBACK") VALUES ('0000051','2007-11-29','11:29:15','INFO','Skins.disable_pins','shinakale disabled pin APP46496559213','','','');
Note: See TracBrowser for help on using the repository browser.