[08-Mar-2023 12:00:00 UTC] PHP Warning: Division by zero in /path/to/your/script.php on line 10
[08-Mar-2023 12:00:02 UTC] PHP Fatal error: Uncaught Error: Call to undefined function testFunction() in
/path/to/your/script.php:15
PHPのエラーログ
Slide 24
Slide 24 text
[08-Mar-2023 12:00:00 UTC] PHP Warning: Division by zero in /path/to/your/script.php on line 10
[08-Mar-2023 12:00:02 UTC] PHP Fatal error: Uncaught Error: Call to undefined function testFunction() in
/path/to/your/script.php:15
PHPのエラーログ
タイムスタンプ
Slide 25
Slide 25 text
[08-Mar-2023 12:00:00 UTC] PHP Warning: Division by zero in /path/to/your/script.php on line 10
[08-Mar-2023 12:00:02 UTC] PHP Fatal error: Uncaught Error: Call to undefined function testFunction() in
/path/to/your/script.php:15
PHPのエラーログ
エラーの種類
Slide 26
Slide 26 text
[08-Mar-2023 12:00:00 UTC] PHP Warning: Division by zero in /path/to/your/script.php on line 10
[08-Mar-2023 12:00:02 UTC] PHP Fatal error: Uncaught Error: Call to undefined function testFunction() in
/path/to/your/script.php:15
PHPのエラーログ
エラーの詳細、発生場所
MySQLのログ
2023-03-08T12:00:00.000000Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230308 8:00:00
2023-03-08T12:00:00.000000Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-03-08T12:00:00.000000Z 0 [ERROR] Cannot open table test/users from the internal data dictionary of InnoDB
though the .frm file for the table exists.
Slide 36
Slide 36 text
MySQLのログ
2023-03-08T12:00:00.000000Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230308 8:00:00
2023-03-08T12:00:00.000000Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-03-08T12:00:00.000000Z 0 [ERROR] Cannot open table test/users from the internal data dictionary of InnoDB
though the .frm file for the table exists.
タイムスタンプ
Slide 37
Slide 37 text
MySQLのログ
2023-03-08T12:00:00.000000Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230308 8:00:00
2023-03-08T12:00:00.000000Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-03-08T12:00:00.000000Z 0 [ERROR] Cannot open table test/users from the internal data dictionary of InnoDB
though the .frm file for the table exists.
プロセスID
Slide 38
Slide 38 text
MySQLのログ
2023-03-08T12:00:00.000000Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230308 8:00:00
2023-03-08T12:00:00.000000Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-03-08T12:00:00.000000Z 0 [ERROR] Cannot open table test/users from the internal data dictionary of InnoDB
though the .frm file for the table exists.
ログレベル
Slide 39
Slide 39 text
MySQLのログ
2023-03-08T12:00:00.000000Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230308 8:00:00
2023-03-08T12:00:00.000000Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-03-08T12:00:00.000000Z 0 [ERROR] Cannot open table test/users from the internal data dictionary of InnoDB
though the .frm file for the table exists.
ログ内容
Slide 40
Slide 40 text
システムログ(syslog)
Mar 8 12:00:00 myhost systemd[1]: Started Session 1234 of user root.
Mar 8 12:05:00 myhost sshd[23456]: Accepted publickey for user1 from 192.168.1.100 port 22 ssh2
Mar 8 12:10:00 myhost CRON[23457]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
Mar 8 12:15:00 myhost kernel: [123456.789012] Firewall: *TCP_IN Blocked* IN=eth0 OUT=
MAC=01:23:45:67:89:ab:cd:ef:gh:ij:kl:mn SRC=10.1.2.3 DST=192.168.1.100 LEN=60 TOS=0x00 PREC=0x00 TTL=64 ID=12345
DF PROTO=TCP SPT=12345 DPT=80 WINDOW=65535 RES=0x00 SYN URGP=0
Slide 41
Slide 41 text
システムログ(syslog)
Mar 8 12:00:00 myhost systemd[1]: Started Session 1234 of user root.
Mar 8 12:05:00 myhost sshd[23456]: Accepted publickey for user1 from 192.168.1.100 port 22 ssh2
Mar 8 12:10:00 myhost CRON[23457]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
Mar 8 12:15:00 myhost kernel: [123456.789012] Firewall: *TCP_IN Blocked* IN=eth0 OUT=
MAC=01:23:45:67:89:ab:cd:ef:gh:ij:kl:mn SRC=10.1.2.3 DST=192.168.1.100 LEN=60 TOS=0x00 PREC=0x00 TTL=64 ID=12345
DF PROTO=TCP SPT=12345 DPT=80 WINDOW=65535 RES=0x00 SYN URGP=0
タイムスタンプ
Slide 42
Slide 42 text
システムログ(syslog)
Mar 8 12:00:00 myhost systemd[1]: Started Session 1234 of user root.
Mar 8 12:05:00 myhost sshd[23456]: Accepted publickey for user1 from 192.168.1.100 port 22 ssh2
Mar 8 12:10:00 myhost CRON[23457]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
Mar 8 12:15:00 myhost kernel: [123456.789012] Firewall: *TCP_IN Blocked* IN=eth0 OUT=
MAC=01:23:45:67:89:ab:cd:ef:gh:ij:kl:mn SRC=10.1.2.3 DST=192.168.1.100 LEN=60 TOS=0x00 PREC=0x00 TTL=64 ID=12345
DF PROTO=TCP SPT=12345 DPT=80 WINDOW=65535 RES=0x00 SYN URGP=0
ホスト名
Slide 43
Slide 43 text
システムログ(syslog)
Mar 8 12:00:00 myhost systemd[1]: Started Session 1234 of user root.
Mar 8 12:05:00 myhost sshd[23456]: Accepted publickey for user1 from 192.168.1.100 port 22 ssh2
Mar 8 12:10:00 myhost CRON[23457]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
Mar 8 12:15:00 myhost kernel: [123456.789012] Firewall: *TCP_IN Blocked* IN=eth0 OUT=
MAC=01:23:45:67:89:ab:cd:ef:gh:ij:kl:mn SRC=10.1.2.3 DST=192.168.1.100 LEN=60 TOS=0x00 PREC=0x00 TTL=64 ID=12345
DF PROTO=TCP SPT=12345 DPT=80 WINDOW=65535 RES=0x00 SYN URGP=0
プロセス名とプロセスID
Slide 44
Slide 44 text
システムログ(syslog)
Mar 8 12:00:00 myhost systemd[1]: Started Session 1234 of user root.
Mar 8 12:05:00 myhost sshd[23456]: Accepted publickey for user1 from 192.168.1.100 port 22 ssh2
Mar 8 12:10:00 myhost CRON[23457]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
Mar 8 12:15:00 myhost kernel: [123456.789012] Firewall: *TCP_IN Blocked* IN=eth0 OUT=
MAC=01:23:45:67:89:ab:cd:ef:gh:ij:kl:mn SRC=10.1.2.3 DST=192.168.1.100 LEN=60 TOS=0x00 PREC=0x00 TTL=64 ID=12345
DF PROTO=TCP SPT=12345 DPT=80 WINDOW=65535 RES=0x00 SYN URGP=0
ログ内容
Slide 45
Slide 45 text
ログの処理
Slide 46
Slide 46 text
バッチ処理とストリーム処理の違
い
Slide 47
Slide 47 text
バッチ処理の例
total 40
-rw-r--r-- 1 root root 1024 Mar 5 00:00 app.log-20230304
-rw-r--r-- 1 root root 20480 Mar 6 00:00 app.log-20230305
-rw-r--r-- 1 root root 10240 Mar 7 00:00 app.log-20230306
-rw-r--r-- 1 root root 5120 Mar 8 00:00 app.log-20230307
-rw-r--r-- 1 root root 123 Mar 8 12:00 app.log
Slide 48
Slide 48 text
バッチ処理の例
total 40
-rw-r--r-- 1 root root 1024 Mar 5 00:00 app.log-20230304
-rw-r--r-- 1 root root 20480 Mar 6 00:00 app.log-20230305
-rw-r--r-- 1 root root 10240 Mar 7 00:00 app.log-20230306
-rw-r--r-- 1 root root 5120 Mar 8 00:00 app.log-20230307
-rw-r--r-- 1 root root 123 Mar 8 12:00 app.log
1日ごとに処理する
Slide 49
Slide 49 text
バッチ処理の例
total 40
-rw-r--r-- 1 root root 1024 Mar 5 00:00 app.log-20230304
-rw-r--r-- 1 root root 20480 Mar 6 00:00 app.log-20230305
-rw-r--r-- 1 root root 10240 Mar 7 00:00 app.log-20230306
-rw-r--r-- 1 root root 5120 Mar 8 00:00 app.log-20230307
-rw-r--r-- 1 root root 123 Mar 8 12:00 app.log
1日ごとに処理する
Slide 50
Slide 50 text
バッチ処理の例
total 40
-rw-r--r-- 1 root root 1024 Mar 5 00:00 app.log-20230304
-rw-r--r-- 1 root root 20480 Mar 6 00:00 app.log-20230305
-rw-r--r-- 1 root root 10240 Mar 7 00:00 app.log-20230306
-rw-r--r-- 1 root root 5120 Mar 8 00:00 app.log-20230307
-rw-r--r-- 1 root root 123 Mar 8 12:00 app.log
1日ごとに処理する
Slide 51
Slide 51 text
バッチ処理の例
total 40
-rw-r--r-- 1 root root 1024 Mar 5 00:00 app.log-20230304
-rw-r--r-- 1 root root 20480 Mar 6 00:00 app.log-20230305
-rw-r--r-- 1 root root 10240 Mar 7 00:00 app.log-20230306
-rw-r--r-- 1 root root 5120 Mar 8 00:00 app.log-20230307
-rw-r--r-- 1 root root 123 Mar 8 12:00 app.log
1日ごとに処理する
62
イベント
[08-Mar-2023 12:00:00 UTC] PHP Warning: Division by zero in /path/to/your/script.php on line 10
[“app.log”, 2023-03-08T12:00:00Z, {"level": "WARNING","message": "Division by zero", …}]
Input
Slide 63
Slide 63 text
63
イベント
[08-Mar-2023 12:00:00 UTC] PHP Warning: Division by zero in /path/to/your/script.php on line 10
[“app.log”, 2023-03-08T12:00:00Z, {"level": "WARNING","message": "Division by zero", …}]
Inputプラグインがログからイベ
ントを生成する
Input