1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
|
#
# WL#9651: Logging services: filter configuration engine
#
SET @old_log_error_verbosity = @@global.log_error_verbosity;
SET @@global.log_error_verbosity=3;
FLUSH LOGS;
SET @@session.debug="+d,parser_stmt_to_error_log";
SET @@session.debug="+d,log_error_normalize";
SELECT @@global.log_error_services;
@@global.log_error_services
log_filter_internal; log_sink_internal
## WL#9651
SET @save_filters= @@global.dragnet.log_error_filter_rules;
ERROR HY000: Unknown system variable 'dragnet.log_error_filter_rules'
# currently nothing is loaded that can handle this, so we'll fail
SET @@global.dragnet.log_error_filter_rules= DEFAULT;
ERROR HY000: Unknown system variable 'dragnet.log_error_filter_rules'
INSTALL COMPONENT "file://component_log_filter_dragnet";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
SET @save_filters= @@global.dragnet.log_error_filter_rules;
SET @@global.dragnet.log_error_filter_rules="IF EXISTS source_line THEN unset source_line.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS source_line THEN unset source_line.
SHOW STATUS LIKE "dragnet.Status";
Variable_name Value
dragnet.Status IF EXISTS source_line THEN unset source_line.
# when clearing rule-set, notice should also show an empty rule-set
SET @@global.dragnet.log_error_filter_rules="";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
SET @@global.dragnet.log_error_filter_rules="IF EXISTS source_line THEN unset source_line.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS source_line THEN unset source_line.
SET @@global.log_error_services="log_sink_internal; log_sink_internal";
ERROR 42000: Variable 'log_error_services' can't be set to the value of 'log_sink_internal; log_sink_internal'
SET @@global.log_error_services="log_filter_dragnet; log_filter_dragnet";
ERROR 42000: Variable 'log_error_services' can't be set to the value of 'log_filter_dragnet; log_filter_dragnet'
SET @@global.log_error_services="log_filter_dragnet; log_sink_internal";
# error, not starting with IF
SET @@global.dragnet.log_error_filter_rules='drop.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: getting first token ...) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'drop.'
# error, ELSE without IF
SET @@global.dragnet.log_error_filter_rules='ELSE drop.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'ELSE drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "drop." (state: IF expected) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'ELSE drop.'
# correct OR
SET @@global.dragnet.log_error_filter_rules='IF EXISTS a OR NOT EXISTS b THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS a OR NOT EXISTS b THEN drop.
# correct AND
SET @@global.dragnet.log_error_filter_rules='IF EXISTS a AND NOT EXISTS b THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS a AND NOT EXISTS b THEN drop.
# multi-chain
SET @@global.dragnet.log_error_filter_rules='IF EXISTS a AND NOT EXISTS b OR c>=5 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS a AND NOT EXISTS b OR c>=5 THEN drop.
# test presence/absence operator
SET @@global.dragnet.log_error_filter_rules="IF EXISTS prio THEN SET a=1. IF NOT EXISTS a THEN SET a='asd'.";
SET @@global.dragnet.log_error_filter_rules="IF EXISTS prio THEN SET a='qwerty'. IF EXISTS a THEN SET a='asd'.";
SET @@global.dragnet.log_error_filter_rules="IF EXISTS prio THEN SET a='qwerty'. IF NOT EXISTS a THEN SET a='asd'.";
# correct conditions:
SET @@global.dragnet.log_error_filter_rules='IF a>0 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a>0 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a<3 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a<3 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a>=0 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a>=0 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a<=3 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a<=3 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a=>0 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a>=0 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a=<3 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a<=3 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a!=2 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a!=2 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a<>2 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a!=2 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF EXISTS a THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS a THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF NOT EXISTS a THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF NOT EXISTS a THEN drop.
# correct actions:
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 5.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN throttle 5/60.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 5/30.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN throttle 5/30.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:=2.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN set b:=2.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b=2.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN set b:=2.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b= 2.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN set b:=2.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:="2".';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN set b:="2".
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:=2.0.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN set b:=2.000000.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN unset.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN unset a.
SET @@global.dragnet.log_error_filter_rules='IF EXISTS a THEN unset.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS a THEN unset a.
SET @@global.dragnet.log_error_filter_rules='IF NOT EXISTS a THEN unset.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF NOT EXISTS a THEN unset a.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN unset a.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN unset a.
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN unset a.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN unset a.
SET @@global.dragnet.log_error_filter_rules='IF a==ER_STARTUP THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==1408 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF err_code==ER_STARTUP THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF err_code==MY-001408 THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF err_symbol=="ER_STARTUP" THEN drop.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF err_symbol=="ER_STARTUP" THEN drop.
SET @@global.dragnet.log_error_filter_rules="IF err_symbol=='ER_STARTUP' THEN drop.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF err_symbol=="ER_STARTUP" THEN drop.
SET @@global.dragnet.log_error_filter_rules='IF err_code==ER_STARTUP THEN set err_code:=ER_YES.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF err_code==MY-001408 THEN set err_code:=MY-001003.
SET @@global.dragnet.log_error_filter_rules='IF err_symbol=="ER_STARTUP" THEN set err_symbol:="ER_YES".';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF err_symbol=="ER_STARTUP" THEN set err_symbol:="ER_YES".
SET @@global.dragnet.log_error_filter_rules='IF a=="\\\\a\\\"\\\'" THEN set err_symbol:="ER_YES".';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a=="\\a\"\'" THEN set err_symbol:="ER_YES".
# error, unrecognized token
SET @@global.dragnet.log_error_filter_rules='DRAUGR.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'DRAUGR.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: getting first token ...) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'DRAUGR.'
# error, == is not an assignment operator
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b==2.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set b==2.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "==2." (state: malformed number) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set b==2.'
# error, mismatching quotation signs
SET @@global.dragnet.log_error_filter_rules="IF err_symbol=='ER_STARTUP THEN drop.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol=='ER_STARTUP THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "'ER_STARTUP THEN drop." (state: testing for prefix) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol=='ER_STARTUP THEN drop.'
# error, mismatching quotation signs
SET @@global.dragnet.log_error_filter_rules="IF err_symbol==ER_STARTUP' THEN drop.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol==ER_STARTUP' THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "ER_STARTUP' THEN drop." (state: unknown ER_code) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol==ER_STARTUP' THEN drop.'
# error, mismatching quotation signs
SET @@global.dragnet.log_error_filter_rules="IF err_symbol=='ER_STARTUP\" THEN drop.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol=='ER_STARTUP" THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "'ER_STARTUP" THEN drop." (state: testing for prefix) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol=='ER_STARTUP" THEN drop.'
# error, mismatching quotation signs
SET @@global.dragnet.log_error_filter_rules="IF err_symbol==\"ER_STARTUP' THEN drop.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol=="ER_STARTUP' THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at ""ER_STARTUP' THEN drop." (state: testing for prefix) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol=="ER_STARTUP' THEN drop.'
# error, reserved
SET @@global.dragnet.log_error_filter_rules="IF misc_cstring=='1' THEN drop.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF misc_cstring=='1' THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "=='1' THEN drop." (state: could not set up field before comparator) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF misc_cstring=='1' THEN drop.'
SET @@global.dragnet.log_error_filter_rules="IF a=='1' THEN set misc_cstring:='abc'.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a=='1' THEN set misc_cstring:='abc'.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at ":='abc'." (state: could not set up field in action) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a=='1' THEN set misc_cstring:='abc'.'
SET @@global.dragnet.log_error_filter_rules="IF EXISTS misc_cstring THEN drop.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS misc_cstring THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "THEN drop." (state: could not set up field for EXISTS) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS misc_cstring THEN drop.'
# error, trying to assign integer to string field
SET @@global.dragnet.log_error_filter_rules="IF EXISTS foo THEN set component:=1.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS foo THEN set component:=1.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "1." (state: Argument is of numeric type, field is not.) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS foo THEN set component:=1.'
# error, trying to assign float to string field
SET @@global.dragnet.log_error_filter_rules="IF EXISTS foo THEN set component:=1..5.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS foo THEN set component:=1..5.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "1..5." (state: Argument is of numeric type, field is not.) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS foo THEN set component:=1..5.'
# error, trying to assign float to an integer field
SET @@global.dragnet.log_error_filter_rules="IF EXISTS foo THEN set prio:=1.5.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS foo THEN set prio:=1.5.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "1.5." (state: Argument is of float type, field is not.) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS foo THEN set prio:=1.5.'
# error, no action (condition ends in NUL)
SET @@global.dragnet.log_error_filter_rules="IF err_symbol==ER_STARTUP";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol==ER_STARTUP'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "ER_STARTUP" (state: 'err_code' is the only built-in field-type we will resolve ER_symbols and MY-codes for) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol==ER_STARTUP'
# error, NOT requires EXISTS
SET @@global.dragnet.log_error_filter_rules="IF NOT field THEN action.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF NOT field THEN action.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "field THEN action." (state: NOT requires EXISTS) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF NOT field THEN action.'
SET @@global.dragnet.log_error_filter_rules="IF\tEXISTS\tfield\tTHEN\tDROP.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS field THEN drop.
SET @@global.dragnet.log_error_filter_rules="IF\t \t\tEXISTS field\rTHEN\nDROP.\nIF EXISTS field2 THEN DROP.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF EXISTS field THEN drop. IF EXISTS field2 THEN drop.
# error, wrong data-type
SET @@global.dragnet.log_error_filter_rules='IF err_symbol==ER_STARTUP THEN drop.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol==ER_STARTUP THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "ER_STARTUP THEN drop." (state: 'err_code' is the only built-in field-type we will resolve ER_symbols and MY-codes for) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_symbol==ER_STARTUP THEN drop.'
SET @@global.dragnet.log_error_filter_rules='IF err_code=="ER_STARTUP" THEN drop.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_code=="ER_STARTUP" THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at ""ER_STARTUP" THEN drop." (state: Argument is of string type, field is not.) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF err_code=="ER_STARTUP" THEN drop.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN unset.';
SET @@global.dragnet.log_error_filter_rules='IF a==2 AND b==3 THEN unset.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 AND b==3 THEN unset.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: implicit field name only allowed for IFs with exactly 1 condition.) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 AND b==3 THEN unset.'
# error, both prefix and infix operators
SET @@global.dragnet.log_error_filter_rules='IF EXISTS a>0 THEN drop.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS a>0 THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at ">0 THEN drop." (state: looking for THEN) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS a>0 THEN drop.'
# error, no terminator
SET @@global.dragnet.log_error_filter_rules='IF EXISTS a THEN drop';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS a THEN drop'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "" (state: statement incomplete) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS a THEN drop'
# error, malformed statement
SET @@global.dragnet.log_error_filter_rules="IF EXISTS field THEN AND.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS field THEN AND.'
# error, malformed statement
SET @@global.dragnet.log_error_filter_rules="IF EXISTS field DROP.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS field DROP.'
# error, incomplete action:
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: looking for action's field name) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set b.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: looking for action field's value) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set b.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:=.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set b:=.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: looking for action field's value) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set b:=.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:=.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set b:=.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: looking for action field's value) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set b:=.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set :=2.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set :=2.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at ":=2." (state: looking for action's field name) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN set :=2.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "" (state: statement incomplete) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop'
# NULL should not be allowed
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.';
SET @@global.dragnet.log_error_filter_rules=NULL;
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'NULL'
SHOW WARNINGS;
Level Code Message
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'NULL'
# empty rule-set should be allowed
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.';
SET @@global.dragnet.log_error_filter_rules="";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
SELECT @@global.dragnet.log_error_filter_rules;
@@global.dragnet.log_error_filter_rules
# interaction with SET PERSIST
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.';
SET PERSIST dragnet.log_error_filter_rules= '';
SHOW WARNINGS;
Level Code Message
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
SELECT @@global.dragnet.log_error_filter_rules;
@@global.dragnet.log_error_filter_rules
SELECT @@session.dragnet.log_error_filter_rules;
ERROR HY000: Variable 'dragnet.log_error_filter_rules' is a GLOBAL variable
RESET PERSIST;
# symbolic prio
SET @@global.dragnet.log_error_filter_rules="IF prio>9999 THEN set prio:=WARNING.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>9999 THEN set prio:=WARNING.
SET @@global.dragnet.log_error_filter_rules="IF prio>=ERROR THEN drop.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>=ERROR THEN drop.
SET @@global.dragnet.log_error_filter_rules="IF prio>=WARNING THEN drop.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>=WARNING THEN drop.
SET @@global.dragnet.log_error_filter_rules="IF prio>=NOTE THEN drop.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>=INFORMATION THEN drop.
SET @@global.dragnet.log_error_filter_rules="IF prio>=INFORMATION THEN drop.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>=INFORMATION THEN drop.
SET @@global.dragnet.log_error_filter_rules="IF thread>=INFORMATION THEN drop.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF thread>=INFORMATION THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "INFORMATION THEN drop." (state: malformed number) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF thread>=INFORMATION THEN drop.'
SET @@global.dragnet.log_error_filter_rules="IF prio>=INFORMATION THEN set thread:=ERROR.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=INFORMATION THEN set thread:=ERROR.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "ERROR." (state: malformed number) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=INFORMATION THEN set thread:=ERROR.'
SET @@global.dragnet.log_error_filter_rules="IF prio>=NOUGAT THEN drop.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=NOUGAT THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "NOUGAT THEN drop." (state: unknown prio) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=NOUGAT THEN drop.'
# == should not require a space
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF msg== \'Parser saw: select 1\' THEN set a:=1. ";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF msg=="Parser saw: select 1" THEN set a:=1.
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF msg==\'Parser saw: select 1\' THEN set a:=1. ";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF msg=="Parser saw: select 1" THEN set a:=1.
# throw error for absurdly large values
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 1/1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 .";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN throttle 1/1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 .'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 ." (state: failed to parse denominator of fraction (0 < integer number of seconds <= 604800)) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN throttle 1/1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 .'
# throw error for floats
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF err_code == 001045 THEN throttle 1/1.1.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF err_code == 001045 THEN throttle 1/1.1.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "1.1." (state: failed to parse denominator of fraction (0 < integer number of seconds <= 604800)) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF err_code == 001045 THEN throttle 1/1.1.'
# test for correct range in throttle denominator
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/3600.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>=9999 THEN throttle 111/3600.
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/604800.";
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF prio>=9999 THEN throttle 111/604800.
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/604801.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN throttle 111/604801.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "604801." (state: failed to parse denominator of fraction (0 < integer number of seconds <= 604800)) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN throttle 111/604801.'
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/0.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN throttle 111/0.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "0." (state: failed to parse denominator of fraction (0 < integer number of seconds <= 604800)) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN throttle 111/0.'
SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/-1.";
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN throttle 111/-1.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "-1." (state: failed to parse denominator of fraction (0 < integer number of seconds <= 604800)) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>=9999 THEN throttle 111/-1.'
# error, drop takes no argument
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop a.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop a.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: getting first token ...) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop a.'
# error, throttle requires numeric value (limit)
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle a.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle a.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "a." (state: malformed number) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle a.'
# error, throttle requires integer value (limit)
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1.5.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle 1.5.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "1.5." (state: action "throttle" requires integer or fraction) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle 1.5.'
# error, throttle requires numeric value (window-size)
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/b.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle 1/b.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "b." (state: failed to parse denominator of fraction (0 < integer number of seconds <= 604800)) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle 1/b.'
# error, throttle -- / given, but not window-size
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle a/.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle a/.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "a/." (state: malformed number) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle a/.'
# error, throttle numerator needs to be positive
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle -1/2.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle -1/2.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "-1/2." (state: numerator must be larger than 0) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle -1/2.'
# error, throttle numerator needs to be non-zero
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 0/2.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle 0/2.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "0/2." (state: numerator must be larger than 0) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN throttle 0/2.'
# correct ELSE
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/2 ELSE throttle 1/30.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN throttle 1/2 ELSE throttle 1/30.
# incorrect ELSE
SET @@global.dragnet.log_error_filter_rules='ELSE.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'ELSE.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: IF expected) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'ELSE.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 ELSE.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 ELSE.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "ELSE." (state: looking for THEN) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 ELSE.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop ELSE drop ELSE drop.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop ELSE drop ELSE drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "drop." (state: ELSE not expected here ...) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop ELSE drop ELSE drop.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop ELSE scream.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop ELSE scream.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "scream." (state: looking for action verb) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop ELSE scream.'
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop ELSE.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop ELSE.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: failed to get token after ELSE ...) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a==2 THEN drop ELSE.'
SET @@global.dragnet.log_error_filter_rules='IF .';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF .'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: field name missing or invalid before comparator) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF .'
SET @@global.dragnet.log_error_filter_rules='IF EXISTS a THEN.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS a THEN.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: looking for action verb) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS a THEN.'
# error, unknown comparator
SET @@global.dragnet.log_error_filter_rules='IF a!!b THEN drop.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a!!b THEN drop.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "!!b THEN drop." (state: unknown comparator) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF a!!b THEN drop.'
# error, field name missing after EXISTS
SET @@global.dragnet.log_error_filter_rules='IF EXISTS.';
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS.'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "." (state: field name missing or invalid after EXISTS) ...
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF EXISTS.'
# correct ELSEIF
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/2 ELSEIF a==5 THEN throttle 1/30.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN throttle 1/2 ELSEIF a==5 THEN throttle 1/30.
# correct ELSE IF
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/2 ELSE IF a==5 THEN throttle 1/30.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN throttle 1/2 ELSEIF a==5 THEN throttle 1/30.
# correct ELSEIF-ELSE
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/5 ELSEIF a==5 THEN throttle 2/5 ELSE throttle 3/5.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN throttle 1/5 ELSEIF a==5 THEN throttle 2/5 ELSE throttle 3/5.
# correct ELSE IF-ELSE
SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/5 ELSE IF a==5 THEN throttle 2/5 ELSE throttle 3/5.';
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
IF a==2 THEN throttle 1/5 ELSEIF a==5 THEN throttle 2/5 ELSE throttle 3/5.
# correct multi-rule rule-set.
CREATE TABLE my_rules (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, rule VARCHAR(256));
INSERT INTO my_rules VALUES(NULL, 'IF EXISTS source_line THEN unset source_line.');
INSERT INTO my_rules VALUES(NULL, 'IF EXISTS thread THEN set thread:=0.'),
(NULL, 'IF EXISTS user THEN unset user.'),
(NULL, 'IF EXISTS host THEN unset host.'),
(NULL, 'IF EXISTS query_id THEN set query_id:=0.'),
(NULL, 'IF EXISTS time THEN set time:="1970-01-01T00:00:00.012345Z".'),
(NULL, 'IF EXISTS _pid THEN unset _pid.'),
(NULL, 'IF EXISTS _platform THEN unset platform.'),
(NULL, 'IF EXISTS _client_version THEN unset _client_version.'),
(NULL, 'IF EXISTS _os THEN unset _os.');
INSERT INTO my_rules VALUES(NULL, 'IF wl9651_val1 < 1 THEN set wl9651_result1:="IF" ELSE IF wl9651_val1 == 1 THEN set wl9651_result1:="ELSEIF1" ELSE IF wl9651_val1 == 2 THEN set wl9651_result1:="ELSEIF2" ELSE set wl9651_result1:="ELSE".');
INSERT INTO my_rules VALUES(NULL, 'IF wl9651_val2==1 OR wl9651_val2==2 OR wl9651_val2==3 THEN set wl9651_result2:="SUCCESS" ELSE set wl9651_result2:="FAILURE".');
INSERT INTO my_rules VALUES(NULL, 'IF wl9651_val3a==1 AND wl9651_val3b==2 AND wl9651_val3c==3 THEN set wl9651_result3:="SUCCESS" ELSE set wl9651_result3:="FAILURE".');
INSERT INTO my_rules VALUES(NULL, 'IF err_code==011825 THEN drop.');
SELECT group_concat(rule ORDER BY id SEPARATOR ' ') FROM my_rules INTO @rules;
SET @@global.dragnet.log_error_filter_rules= @rules;
INSERT INTO my_rules VALUES(NULL, 'IF NOT EXISTS does_not_exist THEN set s1:="string". IF s1=="string" THEN set cmp01:="EQ/S works" ELSE set cmp01:="EQ/S is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF s1!="stringx" THEN set cmp02:="NE/S works" ELSE set cmp02:="NE/S is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF s1>="string" THEN set cmp03:="GE/S works" ELSE set cmp03:="GE/S is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF s1>="strin" THEN set cmp04:="GE/S works" ELSE set cmp04:="GE/S is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF s1>="strinx" THEN set cmp04:="GE/S is broken" ELSE set cmp04:="GE/S works".');
INSERT INTO my_rules VALUES(NULL, 'IF s1>"strinx" THEN set cmp05:="GT/S is broken" ELSE set cmp05:="GT/S works".');
INSERT INTO my_rules VALUES(NULL, 'IF s1>"string" THEN set cmp06:="GT/S is broken" ELSE set cmp06:="GT/S works".');
INSERT INTO my_rules VALUES(NULL, 'IF s1>"strin" THEN set cmp07:="GT/S works" ELSE set cmp07:="GT/S is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF s1<="string" THEN set cmp08:="LE/S works" ELSE set cmp08:="LE/S is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF s1<="strin" THEN set cmp09:="LE/S is broken" ELSE set cmp09:="LE/S works".');
INSERT INTO my_rules VALUES(NULL, 'IF s1<="strinx" THEN set cmp10:="LE/S works" ELSE set cmp10:="LE/S is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF s1<"string" THEN set cmp11:="LT/S is broken" ELSE set cmp11:="LT/S works".');
INSERT INTO my_rules VALUES(NULL, 'IF s1<"strin" THEN set cmp12:="LT/S is broken" ELSE set cmp12:="LT/S works".');
INSERT INTO my_rules VALUES(NULL, 'IF s1<"strinx" THEN set cmp1:="LT/S works" ELSE set cmp13:="LT/S is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF NOT EXISTS does_not_exist THEN set f1:=1.4. IF f1>=1.4 THEN set cmp14:="GE/# works" ELSE set cmp14:="GE/# is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF f1>=1 THEN set cmp15:="GE/# works" ELSE set cmp15:="GE/# is broken".');
INSERT INTO my_rules VALUES(NULL, 'IF f1>=1.5 THEN set cmp16:="GE/# is broken" ELSE set cmp16:="GE/# works".');
SET SESSION group_concat_max_len=65535;
SELECT group_concat(rule ORDER BY id SEPARATOR ' ') FROM my_rules INTO @rules;
DROP TABLE my_rules;
# Heads-up: log_sink_test sets up some debug rules in the built-in
# rule-set, including a throttle for some ER_YES messages it also
# generates. We see this succeed (rate-limit) in log_components.test;
# in here, the throttle is not applied as it is in the internal rule-set,
# and we run the rule-set generated by the log_filter_dragnet language
# (which does not contain this throttle). The throttle not being applied
# therefore demonstrates the separation of the rule-sets, and counts as a
# success in this context!
INSTALL COMPONENT "file://component_log_sink_test";
INSTALL COMPONENT "file://component_log_sink_json";
SET @@global.log_error_services="log_filter_dragnet; log_sink_test";
SET @@global.dragnet.log_error_filter_rules= @rules;
SET @@global.log_error_services="log_filter_dragnet; log_sink_json";
SET @@global.dragnet.log_error_filter_rules= REPEAT("IF prio>9 THEN drop. ", 1025);
ERROR 42000: Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 T'
SHOW WARNINGS;
Level Code Message
Warning 3621 The log-filter component "dragnet" got confused at "IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 T
Error 1231 Variable 'dragnet.log_error_filter_rules' can't be set to the value of 'IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 THEN drop. IF prio>9 T'
SET @rules= CONCAT("IF ", REPEAT("x", 20000), ">9 THEN drop.");
SET @@global.dragnet.log_error_filter_rules= @rules;
SHOW WARNINGS;
Level Code Message
Note 3703 The log-filter component "dragnet" updated its configuration from its system variable "dragnet.log_error_filter_rules", but could not update its status variable "dragnet.Status" to reflect the decompiled rule-set.
SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status";
decompiled_filter_rules
SET @@global.log_error_services="log_filter_dragnet; log_sink_internal";
UNINSTALL COMPONENT "file://component_log_sink_test";
UNINSTALL COMPONENT "file://component_log_sink_json";
SET @@global.dragnet.log_error_filter_rules="IF subsystem=='Server' THEN SET msg := 'This is a message from the Server subsystem'.";
SET @@global.dragnet.log_error_filter_rules="IF subsystem == 'Server' THEN SET msg := 'Dropping subsystem if it is \"Server\" and setting it to Repl'. IF subsystem == 'Server' THEN UNSET subsystem. IF NOT EXISTS subsystem THEN SET subsystem := 'Repl'.";
SET @@global.dragnet.log_error_filter_rules="IF subsystem == 'Server' THEN SET subsystem := 'InnoDB'. IF subsystem == 'InnoDB' THEN SET msg := 'The subsystem for this message has been overriden to InnoDB'.";
SET @@global.dragnet.log_error_filter_rules="IF subsystem != 'SERVER' THEN SET msg := 'This message is seen as the the subsystem is specified in upper case'.";
SET @@global.dragnet.log_error_filter_rules=@save_filters;
call mtr.add_suppression("\\[ERROR\\] \\[MY\\-010000\\] \\[Server\\] Errors should not be suppressed");
SET @save_suppression_list=@@global.log_error_suppression_list;
SET @@global.log_error_services='log_filter_dragnet; log_filter_internal; log_sink_internal';
Warnings:
Note 4003 @@global.log_error_services lists more than one log-filter service. This is discouraged as it will make it hard to understand which rule in which filter affected a log-event.
SET @@global.log_error_suppression_list='10000';
SET @@global.dragnet.log_error_filter_rules='IF err_code==ER_PARSER_TRACE THEN SET prio=0. IF err_code==ER_PARSER_TRACE THEN SET msg="System messages should not be suppressed".';
SET @@global.dragnet.log_error_filter_rules='IF err_code==ER_PARSER_TRACE THEN SET prio=1. IF err_code==ER_PARSER_TRACE THEN SET msg="Errors should not be suppressed".';
SET @@global.dragnet.log_error_filter_rules='IF err_code==ER_PARSER_TRACE THEN SET prio=2. IF err_code==ER_PARSER_TRACE THEN SET msg="Warnings should be suppressed".';
SET @@global.dragnet.log_error_filter_rules='IF err_code==ER_PARSER_TRACE THEN SET prio=3. IF err_code==ER_PARSER_TRACE THEN SET msg="Notes should be suppressed".';
FLUSH ERROR LOGS;
SET @@global.log_error_services=DEFAULT;
SET @@global.dragnet.log_error_filter_rules=@save_filters;
SET @@global.log_error_suppression_list=@save_suppression_list;
# Now we can uninstall.
SET @@global.dragnet.log_error_filter_rules=@save_filters;
UNINSTALL COMPONENT "file://component_log_filter_dragnet";
# cleanup
SET @@session.debug="-d,parser_stmt_to_error_log";
SET @@session.debug="-d,log_error_normalize";
FLUSH ERROR LOGS;
SET @@global.log_error_verbosity=DEFAULT;
###
### error log file
###
1970-01-01T00:00:00.000001Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@session.debug="+d,log_error_normalize"
1970-01-01T00:00:00.000002Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT @@global.log_error_services
1970-01-01T00:00:00.000003Z 0 [Note] [MY-010000] [Server] Parser saw: SET @save_filters= @@global.dragnet.log_error_filter_rules
1970-01-01T00:00:00.000004Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules= DEFAULT
1970-01-01T00:00:00.000005Z 0 [Note] [MY-010000] [Server] Parser saw: INSTALL COMPONENT "file://component_log_filter_dragnet"
1970-01-01T00:00:00.000006Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000007Z 0 [Note] [MY-010000] [Server] Parser saw: SET @save_filters= @@global.dragnet.log_error_filter_rules
1970-01-01T00:00:00.000008Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS source_line THEN unset source_line."
1970-01-01T00:00:00.000009Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000010Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW STATUS LIKE "dragnet.Status"
1970-01-01T00:00:00.000011Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules=""
1970-01-01T00:00:00.000012Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000013Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS source_line THEN unset source_line."
1970-01-01T00:00:00.000014Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000015Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.log_error_services="log_sink_internal; log_sink_internal"
1970-01-01T00:00:00.000016Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.log_error_services="log_filter_dragnet; log_filter_dragnet"
1970-01-01T00:00:00.000017Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.log_error_services="log_filter_dragnet; log_sink_internal"
1970-01-01T00:00:00.000018Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='drop.'
1970-01-01T00:00:00.000019Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000020Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='ELSE drop.'
1970-01-01T00:00:00.000021Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000024Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF EXISTS a AND NOT EXISTS b THEN drop.'
1970-01-01T00:00:00.000025Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000026Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF EXISTS a AND NOT EXISTS b OR c>=5 THEN drop.'
1970-01-01T00:00:00.000027Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000028Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS prio THEN SET a=1. IF NOT EXISTS a THEN SET a='asd'."
1970-01-01T00:00:00.000029Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS prio THEN SET a='qwerty'. IF EXISTS a THEN SET a='asd'."
1970-01-01T00:00:00.000030Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS prio THEN SET a='qwerty'. IF NOT EXISTS a THEN SET a='asd'."
1970-01-01T00:00:00.000031Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a>0 THEN drop.'
1970-01-01T00:00:00.000032Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000033Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a<3 THEN drop.'
1970-01-01T00:00:00.000034Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000035Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a>=0 THEN drop.'
1970-01-01T00:00:00.000036Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000037Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a<=3 THEN drop.'
1970-01-01T00:00:00.000038Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000039Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a=>0 THEN drop.'
1970-01-01T00:00:00.000040Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000041Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a=<3 THEN drop.'
1970-01-01T00:00:00.000042Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000043Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.'
1970-01-01T00:00:00.000044Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000045Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a!=2 THEN drop.'
1970-01-01T00:00:00.000046Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000047Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a<>2 THEN drop.'
1970-01-01T00:00:00.000048Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000049Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF EXISTS a THEN drop.'
1970-01-01T00:00:00.000050Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000053Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.'
1970-01-01T00:00:00.000054Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000055Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 5.'
1970-01-01T00:00:00.000056Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000057Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 5/30.'
1970-01-01T00:00:00.000058Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000059Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:=2.'
1970-01-01T00:00:00.000060Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000061Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b=2.'
1970-01-01T00:00:00.000062Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000063Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b= 2.'
1970-01-01T00:00:00.000064Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000065Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:="2".'
1970-01-01T00:00:00.000066Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000067Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:=2.0.'
1970-01-01T00:00:00.000068Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000069Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN unset.'
1970-01-01T00:00:00.000070Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000071Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF EXISTS a THEN unset.'
1970-01-01T00:00:00.000072Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000073Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF NOT EXISTS a THEN unset.'
1970-01-01T00:00:00.000074Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000075Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN unset a.'
1970-01-01T00:00:00.000076Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000077Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN unset a.'
1970-01-01T00:00:00.000078Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000079Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==ER_STARTUP THEN drop.'
1970-01-01T00:00:00.000080Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000081Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF err_code==ER_STARTUP THEN drop.'
1970-01-01T00:00:00.000082Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000083Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF err_symbol=="ER_STARTUP" THEN drop.'
1970-01-01T00:00:00.000084Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000085Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF err_symbol=='ER_STARTUP' THEN drop."
1970-01-01T00:00:00.000086Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000087Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF err_code==ER_STARTUP THEN set err_code:=ER_YES.'
1970-01-01T00:00:00.000088Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000089Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF err_symbol=="ER_STARTUP" THEN set err_symbol:="ER_YES".'
1970-01-01T00:00:00.000090Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000091Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a=="\\\\a\\\"\\\'" THEN set err_symbol:="ER_YES".'
1970-01-01T00:00:00.000092Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000093Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='DRAUGR.'
1970-01-01T00:00:00.000094Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000095Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b==2.'
1970-01-01T00:00:00.000096Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000097Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF err_symbol=='ER_STARTUP THEN drop."
1970-01-01T00:00:00.000098Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000099Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF err_symbol==ER_STARTUP' THEN drop."
1970-01-01T00:00:00.000100Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000101Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF err_symbol=='ER_STARTUP\" THEN drop."
1970-01-01T00:00:00.000102Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000103Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF err_symbol==\"ER_STARTUP' THEN drop."
1970-01-01T00:00:00.000104Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000105Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF misc_cstring=='1' THEN drop."
1970-01-01T00:00:00.000106Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000107Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF a=='1' THEN set misc_cstring:='abc'."
1970-01-01T00:00:00.000108Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000109Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS misc_cstring THEN drop."
1970-01-01T00:00:00.000110Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000111Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS foo THEN set component:=1."
1970-01-01T00:00:00.000112Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000113Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS foo THEN set component:=1..5."
1970-01-01T00:00:00.000114Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000115Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS foo THEN set prio:=1.5."
1970-01-01T00:00:00.000116Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000117Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF err_symbol==ER_STARTUP"
1970-01-01T00:00:00.000118Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000119Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF NOT field THEN action."
1970-01-01T00:00:00.000120Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000121Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF\tEXISTS\tfield\tTHEN\tDROP."
1970-01-01T00:00:00.000122Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000123Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF\t \t\tEXISTS field\rTHEN\nDROP.\nIF EXISTS field2 THEN DROP."
1970-01-01T00:00:00.000124Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000125Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF err_symbol==ER_STARTUP THEN drop.'
1970-01-01T00:00:00.000126Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000127Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF err_code=="ER_STARTUP" THEN drop.'
1970-01-01T00:00:00.000128Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000129Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN unset.'
1970-01-01T00:00:00.000130Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 AND b==3 THEN unset.'
1970-01-01T00:00:00.000131Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000132Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF EXISTS a>0 THEN drop.'
1970-01-01T00:00:00.000133Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000134Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF EXISTS a THEN drop'
1970-01-01T00:00:00.000135Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000136Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS field THEN AND."
1970-01-01T00:00:00.000137Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF EXISTS field DROP."
1970-01-01T00:00:00.000138Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set.'
1970-01-01T00:00:00.000139Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000140Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b.'
1970-01-01T00:00:00.000141Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000142Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:=.'
1970-01-01T00:00:00.000143Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000144Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set b:=.'
1970-01-01T00:00:00.000145Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000146Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN set :=2.'
1970-01-01T00:00:00.000147Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000148Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop'
1970-01-01T00:00:00.000149Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000150Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.'
1970-01-01T00:00:00.000151Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules=NULL
1970-01-01T00:00:00.000152Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000153Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.'
1970-01-01T00:00:00.000154Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules=""
1970-01-01T00:00:00.000155Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000156Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT @@global.dragnet.log_error_filter_rules
1970-01-01T00:00:00.000157Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop.'
1970-01-01T00:00:00.000158Z 0 [Note] [MY-010000] [Server] Parser saw: SET PERSIST dragnet.log_error_filter_rules= ''
1970-01-01T00:00:00.000159Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000160Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000161Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT @@global.dragnet.log_error_filter_rules
1970-01-01T00:00:00.000162Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT @@session.dragnet.log_error_filter_rules
1970-01-01T00:00:00.000163Z 0 [Note] [MY-010000] [Server] Parser saw: RESET PERSIST
1970-01-01T00:00:00.000164Z 0 [Note] [MY-010000] [Server] Parser saw: select @@datadir
1970-01-01T00:00:00.000165Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>9999 THEN set prio:=WARNING."
1970-01-01T00:00:00.000166Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000181Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF msg== \'Parser saw: select 1\' THEN set a:=1. "
1970-01-01T00:00:00.000182Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000183Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF msg==\'Parser saw: select 1\' THEN set a:=1. "
1970-01-01T00:00:00.000184Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000185Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 1/1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 ."
1970-01-01T00:00:00.000186Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000187Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN drop. IF EXISTS source_line THEN unset source_line. IF err_code == 001045 THEN throttle 1/1.1."
1970-01-01T00:00:00.000188Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000189Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/3600."
1970-01-01T00:00:00.000190Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000191Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/604800."
1970-01-01T00:00:00.000192Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000193Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/604801."
1970-01-01T00:00:00.000194Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000195Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/0."
1970-01-01T00:00:00.000196Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000197Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules="IF prio>=9999 THEN throttle 111/-1."
1970-01-01T00:00:00.000198Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000199Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN drop a.'
1970-01-01T00:00:00.000200Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000201Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle a.'
1970-01-01T00:00:00.000202Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000203Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1.5.'
1970-01-01T00:00:00.000204Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000205Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/b.'
1970-01-01T00:00:00.000206Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000207Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle a/.'
1970-01-01T00:00:00.000208Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000209Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle -1/2.'
1970-01-01T00:00:00.000210Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000211Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 0/2.'
1970-01-01T00:00:00.000212Z 0 [Note] [MY-010000] [Server] Parser saw: SHOW WARNINGS
1970-01-01T00:00:00.000213Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/2 ELSE throttle 1/30.'
1970-01-01T00:00:00.000233Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/2 ELSEIF a==5 THEN throttle 1/30.'
1970-01-01T00:00:00.000234Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000235Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/2 ELSE IF a==5 THEN throttle 1/30.'
1970-01-01T00:00:00.000236Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000237Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/5 ELSEIF a==5 THEN throttle 2/5 ELSE throttle 3/5.'
1970-01-01T00:00:00.000238Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000239Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules='IF a==2 THEN throttle 1/5 ELSE IF a==5 THEN throttle 2/5 ELSE throttle 3/5.'
1970-01-01T00:00:00.000240Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name="dragnet.Status"
1970-01-01T00:00:00.000241Z 0 [Note] [MY-010000] [Server] Parser saw: CREATE TABLE my_rules (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, rule VARCHAR(256))
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules= @rules
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF NOT EXISTS does_not_exist THEN set s1:="string". IF s1=="string" THEN set cmp01:="EQ/S works" ELSE set cmp01:="EQ/S is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1!="stringx" THEN set cmp02:="NE/S works" ELSE set cmp02:="NE/S is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1>="string" THEN set cmp03:="GE/S works" ELSE set cmp03:="GE/S is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1>="strin" THEN set cmp04:="GE/S works" ELSE set cmp04:="GE/S is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1>="strinx" THEN set cmp04:="GE/S is broken" ELSE set cmp04:="GE/S works".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1>"strinx" THEN set cmp05:="GT/S is broken" ELSE set cmp05:="GT/S works".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1>"string" THEN set cmp06:="GT/S is broken" ELSE set cmp06:="GT/S works".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1>"strin" THEN set cmp07:="GT/S works" ELSE set cmp07:="GT/S is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1<="string" THEN set cmp08:="LE/S works" ELSE set cmp08:="LE/S is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1<="strin" THEN set cmp09:="LE/S is broken" ELSE set cmp09:="LE/S works".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1<="strinx" THEN set cmp10:="LE/S works" ELSE set cmp10:="LE/S is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1<"string" THEN set cmp11:="LT/S is broken" ELSE set cmp11:="LT/S works".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1<"strin" THEN set cmp12:="LT/S is broken" ELSE set cmp12:="LT/S works".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF s1<"strinx" THEN set cmp1:="LT/S works" ELSE set cmp13:="LT/S is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF NOT EXISTS does_not_exist THEN set f1:=1.4. IF f1>=1.4 THEN set cmp14:="GE/# works" ELSE set cmp14:="GE/# is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF f1>=1 THEN set cmp15:="GE/# works" ELSE set cmp15:="GE/# is broken".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSERT INTO my_rules VALUES(NULL, 'IF f1>=1.5 THEN set cmp16:="GE/# is broken" ELSE set cmp16:="GE/# works".')
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: SET SESSION group_concat_max_len=65535
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: SELECT group_concat(rule ORDER BY id SEPARATOR ' ') FROM my_rules INTO @rules
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: DROP TABLE my_rules
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSTALL COMPONENT "file://component_log_sink_test"
1970-01-01T00:00:00.012345Z 0 [Note] [MY-010000] [Server] Parser saw: INSTALL COMPONENT "file://component_log_sink_json"
[prio=3];[err_code=10000];[subsystem=Server];[source_file=sql_parse.cc];[function=dispatch_command];[msg=Parser saw: SET @@global.log_error_services="log_filter_dragnet; log_sink_test"];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[prio=3];[err_symbol=ER_PARSER_TRACE];[msg=using log_message() in external service];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_code=10000];[SQL_state=XX999];[subsystem=Server];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[prio=1];[err_symbol=ER_PARSER_TRACE];[subsystem=Server];[msg=using log_message() with duplicate source-line k/v pair];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_code=10000];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[prio=1];[err_symbol=ER_PARSER_TRACE];[key=val];[msg=using log_message() with duplicate generic C-string k/v pair];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_code=10000];[SQL_state=XX999];[subsystem=Server];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[prio=1];[err_symbol=ER_PARSER_TRACE];[key=4711];[msg=using log_message() with duplicate generic mixed k/v pair];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_code=10000];[SQL_state=XX999];[subsystem=Server];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[prio=1];[err_symbol=ER_PARSER_TRACE];[msg=using log_message() with errno 0];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_code=10000];[SQL_state=XX999];[subsystem=Server];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[prio=1];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[SQL_state=HY000];[subsystem=Server];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[prio=1];[err_symbol=ER_SERVER_TEST_MESSAGE];[msg=using log_message() with errsymbol];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_code=13151];[SQL_state=HY000];[subsystem=Server];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[prio=1];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[subsystem=Server];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=XX999];[source_file=log_sink_test];[test_float=3.141592692700];[test_int=739241];[test_cstring=cstring];[test_lexstring=lexstring];[msg=using LogEvent() object in external service];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[msg=item_inconsistent(#1): NOT_FOUND];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[msg=item_inconsistent(#2): CLASS_MISMATCH];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[msg=item_inconsistent(#2): KEY_MISMATCH];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[msg=item_inconsistent(#3): KEY_NULL];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[msg=item_inconsistent(#4): STRING_NULL];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[msg=item_inconsistent(#5): OK];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[SQL_state=XX999];[subsystem=log_sink_test];[component=log_sink_test];[source_file=log_sink_test];[msg=below: 3*unknown error per writer == correct. >3*unknown error per writer == filter fail. 0*unknown error == log_sink_test fail.];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=XX999];[source_file=log_sink_test];[msg=filter_rules: (throttle: delta in medias res) 1];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=HY000];[source_file=log_sink_test];[err_code=13151];[msg=Simulated error];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_SERVER_TEST_MESSAGE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[subsystem=log_sink_test];[component=log_sink_test];[SQL_state=XX999];[source_file=log_sink_test];[msg=filter_rules: (throttle: delta ex post) 0];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[err_code=10000];[meow=test_me_for_presence];[bark=delete_me_by_rule];[prio_change=yes];[subsystem=log_sink_test];[component=log_sink_test];[source_file=log_sink_test];[msg=filter_rules: (add_item delta in medias res) 3];[prio=1];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[log_type=1];[err_code=10000];[meow=test_me_for_presence];[bark=delete_me_by_rule];[prio_change=yes];[subsystem=log_sink_test];[component=log_sink_test];[source_file=log_sink_test];[msg=filter_rules: (add_item delta ex post) 0];[prio=1];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
[log_type=1];[prio=3];[err_code=10000];[wl9651_val1=0];[wl9651_val2=1];[wl9651_val3a=1];[wl9651_val3b=2];[wl9651_val3c=3];[subsystem=log_sink_test];[component=log_sink_test];[msg=WL#9651 expected: r1-IF, r2-SUCCESS, r3-SUCCESS];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=IF];[wl9651_result2=SUCCESS];[wl9651_result3=SUCCESS];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[wl9651_val1=1];[wl9651_val2=2];[wl9651_val3a=0];[wl9651_val3b=2];[wl9651_val3c=3];[subsystem=log_sink_test];[component=log_sink_test];[msg=WL#9651 expected: r1-ELSEIF1, r2-SUCCESS, r3-FAILURE];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSEIF1];[wl9651_result2=SUCCESS];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[wl9651_val1=2];[wl9651_val2=3.100000000000];[wl9651_val3a=1];[wl9651_val3b=0];[wl9651_val3c=3];[subsystem=log_sink_test];[component=log_sink_test];[msg=WL#9651 expected: r1-ELSEIF2, r2-FAILURE, r3-FAILURE];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSEIF2];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[wl9651_val1=3];[wl9651_val2=4];[wl9651_val3a=1];[wl9651_val3b=2];[wl9651_val3c=0];[subsystem=log_sink_test];[component=log_sink_test];[msg=WL#9651 expected: r1-ELSE, r2-FAILURE, r3-FAILURE];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[log_type=1];[prio=3];[err_code=10000];[wl9651_val1=-7];[wl9651_val2=1];[wl9651_val3a=1];[wl9651_val3c=3];[subsystem=log_sink_test];[component=log_sink_test];[msg=WL#9651 expected: r1-IF, r2-FAILURE, r3-FAILURE];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[wl9651_result1=IF];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Note];
[label=log_sink_test: broken item with class 3, type 131072];[err_code=10000];[prio=1];[time=1970-01-01T00:00:00.012345Z];[ts=0];[thread=0];[err_symbol=ER_PARSER_TRACE];[SQL_state=XX999];[subsystem=Server];[wl9651_result1=ELSE];[wl9651_result2=FAILURE];[wl9651_result3=FAILURE];[label=Error];
{ "prio" : 3, "err_code" : 10000, "subsystem" : "Server", "source_file" : "sql_parse.cc", "function" : "dispatch_command", "msg" : "Parser saw: SET @@global.log_error_services=\"log_filter_dragnet; log_sink_json\"", "time" : "1970-01-01T00:00:00.012345Z", "ts" : 0, "thread" : 0, "err_symbol" : "ER_PARSER_TRACE", "SQL_state" : "XX999", "wl9651_result1" : "ELSE", "wl9651_result2" : "FAILURE", "wl9651_result3" : "FAILURE", "s1" : "string", "cmp01" : "EQ/S works", "cmp02" : "NE/S works", "cmp03" : "GE/S works", "cmp04" : "GE/S works", "cmp05" : "GT/S works", "cmp06" : "GT/S works", "cmp07" : "GT/S works", "cmp08" : "LE/S works", "cmp09" : "LE/S works", "cmp10" : "LE/S works", "cmp11" : "LT/S works", "cmp12" : "LT/S works", "cmp1" : "LT/S works", "f1" : 1.400000000000, "cmp14" : "GE/# works", "cmp15" : "GE/# works", "cmp16" : "GE/# works", "label" : "Note" }
{ "prio" : 3, "err_code" : 10000, "subsystem" : "Server", "source_file" : "sql_parse.cc", "function" : "dispatch_command", "msg" : "Parser saw: SET @@global.dragnet.log_error_filter_rules= REPEAT(\"IF prio>9 THEN drop. \", 1025)", "time" : "1970-01-01T00:00:00.012345Z", "ts" : 0, "thread" : 0, "err_symbol" : "ER_PARSER_TRACE", "SQL_state" : "XX999", "wl9651_result1" : "ELSE", "wl9651_result2" : "FAILURE", "wl9651_result3" : "FAILURE", "s1" : "string", "cmp01" : "EQ/S works", "cmp02" : "NE/S works", "cmp03" : "GE/S works", "cmp04" : "GE/S works", "cmp05" : "GT/S works", "cmp06" : "GT/S works", "cmp07" : "GT/S works", "cmp08" : "LE/S works", "cmp09" : "LE/S works", "cmp10" : "LE/S works", "cmp11" : "LT/S works", "cmp12" : "LT/S works", "cmp1" : "LT/S works", "f1" : 1.400000000000, "cmp14" : "GE/# works", "cmp15" : "GE/# works", "cmp16" : "GE/# works", "label" : "Note" }
{ "prio" : 3, "err_code" : 10000, "subsystem" : "Server", "source_file" : "sql_parse.cc", "function" : "dispatch_command", "msg" : "Parser saw: SHOW WARNINGS", "time" : "1970-01-01T00:00:00.012345Z", "ts" : 0, "thread" : 0, "err_symbol" : "ER_PARSER_TRACE", "SQL_state" : "XX999", "wl9651_result1" : "ELSE", "wl9651_result2" : "FAILURE", "wl9651_result3" : "FAILURE", "s1" : "string", "cmp01" : "EQ/S works", "cmp02" : "NE/S works", "cmp03" : "GE/S works", "cmp04" : "GE/S works", "cmp05" : "GT/S works", "cmp06" : "GT/S works", "cmp07" : "GT/S works", "cmp08" : "LE/S works", "cmp09" : "LE/S works", "cmp10" : "LE/S works", "cmp11" : "LT/S works", "cmp12" : "LT/S works", "cmp1" : "LT/S works", "f1" : 1.400000000000, "cmp14" : "GE/# works", "cmp15" : "GE/# works", "cmp16" : "GE/# works", "label" : "Note" }
{ "prio" : 3, "err_code" : 10000, "subsystem" : "Server", "source_file" : "sql_parse.cc", "function" : "dispatch_command", "msg" : "Parser saw: SET @rules= CONCAT(\"IF \", REPEAT(\"x\", 20000), \">9 THEN drop.\")", "time" : "1970-01-01T00:00:00.012345Z", "ts" : 0, "thread" : 0, "err_symbol" : "ER_PARSER_TRACE", "SQL_state" : "XX999", "wl9651_result1" : "ELSE", "wl9651_result2" : "FAILURE", "wl9651_result3" : "FAILURE", "s1" : "string", "cmp01" : "EQ/S works", "cmp02" : "NE/S works", "cmp03" : "GE/S works", "cmp04" : "GE/S works", "cmp05" : "GT/S works", "cmp06" : "GT/S works", "cmp07" : "GT/S works", "cmp08" : "LE/S works", "cmp09" : "LE/S works", "cmp10" : "LE/S works", "cmp11" : "LT/S works", "cmp12" : "LT/S works", "cmp1" : "LT/S works", "f1" : 1.400000000000, "cmp14" : "GE/# works", "cmp15" : "GE/# works", "cmp16" : "GE/# works", "label" : "Note" }
{ "prio" : 3, "err_code" : 10000, "subsystem" : "Server", "source_file" : "sql_parse.cc", "function" : "dispatch_command", "msg" : "Parser saw: SET @@global.dragnet.log_error_filter_rules= @rules", "time" : "1970-01-01T00:00:00.000320Z", "ts" : 0, "thread" : 0, "err_symbol" : "ER_PARSER_TRACE", "SQL_state" : "XX999", "label" : "Note" }
{ "prio" : 3, "err_code" : 10000, "subsystem" : "Server", "source_file" : "sql_parse.cc", "function" : "dispatch_command", "msg" : "Parser saw: SHOW WARNINGS", "time" : "1970-01-01T00:00:00.000321Z", "ts" : 0, "thread" : 0, "err_symbol" : "ER_PARSER_TRACE", "SQL_state" : "XX999", "label" : "Note" }
{ "prio" : 3, "err_code" : 10000, "subsystem" : "Server", "source_file" : "sql_parse.cc", "function" : "dispatch_command", "msg" : "Parser saw: SELECT variable_value AS decompiled_filter_rules FROM performance_schema.global_status WHERE variable_name=\"dragnet.Status\"", "time" : "1970-01-01T00:00:00.000322Z", "ts" : 0, "thread" : 0, "err_symbol" : "ER_PARSER_TRACE", "SQL_state" : "XX999", "label" : "Note" }
1970-01-01T00:00:00.000323Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.log_error_services="log_filter_dragnet; log_sink_internal"
1970-01-01T00:00:00.000324Z 0 [Note] [MY-010000] [Server] Parser saw: UNINSTALL COMPONENT "file://component_log_sink_test"
1970-01-01T00:00:00.000325Z 0 [Note] [MY-010000] [Server] Parser saw: UNINSTALL COMPONENT "file://component_log_sink_json"
1970-01-01T00:00:00.000326Z 0 [Note] [MY-010000] [Server] This is a message from the Server subsystem
1970-01-01T00:00:00.000327Z 0 [Note] [MY-010000] [Repl] Dropping subsystem if it is "Server" and setting it to Repl
1970-01-01T00:00:00.000328Z 0 [Note] [MY-010000] [InnoDB] The subsystem for this message has been overriden to InnoDB
1970-01-01T00:00:00.000329Z 0 [Note] [MY-010000] [Server] This message is seen as the the subsystem is specified in upper case
1970-01-01T00:00:00.000336Z 0 [System] [MY-010000] [Server] System messages should not be suppressed
1970-01-01T00:00:00.000337Z 0 [ERROR] [MY-010000] [Server] Errors should not be suppressed
1970-01-01T00:00:00.000343Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.log_error_suppression_list=@save_suppression_list
1970-01-01T00:00:00.000344Z 0 [Note] [MY-010000] [Server] Parser saw: SET @@global.dragnet.log_error_filter_rules=@save_filters
1970-01-01T00:00:00.000345Z 0 [Note] [MY-010000] [Server] Parser saw: UNINSTALL COMPONENT "file://component_log_filter_dragnet"
SET @@global.log_error_verbosity=@old_log_error_verbosity;
###
### done
###
|
