機能追加 #1890
RDS側のクリックログのみ9時間ずれている現象が発生。
RDSのタイムゾーン確認
<pre>
mysql> show variables like '%time_zone%';
+------------------+------------+
| Variable_name | Value |
+------------------+------------+
| system_time_zone | UTC |
| time_zone | Asia/Tokyo |
+------------------+------------+
2 rows in set (0.00 sec)
</pre>
DB2のタイムゾーン確認
<pre>
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | JST |
| time_zone | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)
</pre>
同一aff_idでのレコード確認
RDS
<pre>
mysql> select * from click_log_202011 where aff_id = "gsy46h4f05147958"\G
*************************** 1. row ***************************
click_log_id: 164285
c_owner_id: 284
c_id: 1372
m_owner_id: NULL
m_id: NULL
t_id:
asp_id: 275
listing_id: NULL
aff_id: gsy46h4f05147958
career_type: NULL
career: 4
agent: Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebK
term_name: PC
subscriber:
ip: 203.136.16.181
referer:
user_id: #asp#108204#2Po6hjRu##
media_data: NULL
url: http://spmode.takarakujiget.co.jp/sp/?af=gsy46h4f05147958
status: 0
click_cost_set: 0.00
click_cost_cl_set: 0.00
click_cost: 0.00
click_cost_cl: 0.00
action_cost_set: NULL
action_cost_cl_set: NULL
action_ratio_set: NULL
action_ratio_cl_set: NULL
click_date: 2020-11-12 02:27:34
1 row in set (0.00 sec)
</pre>
DB2
<pre>
mysql> select * from click_log_202011 where aff_id = "gsy46h4f05147958"\G
*************************** 1. row ***************************
click_log_id: 164285
c_owner_id: 284
c_id: 1372
m_owner_id: NULL
m_id: NULL
t_id:
asp_id: 275
listing_id: NULL
aff_id: gsy46h4f05147958
career_type: NULL
career: 4
agent: Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebK
term_name: PC
subscriber:
ip: 203.136.16.181
referer:
user_id: #asp#108204#2Po6hjRu##
media_data: NULL
url: http://spmode.takarakujiget.co.jp/sp/?af=gsy46h4f05147958
status: 0
click_cost_set: 0.00
click_cost_cl_set: 0.00
click_cost: 0.00
click_cost_cl: 0.00
action_cost_set: NULL
action_cost_cl_set: NULL
action_ratio_set: NULL
action_ratio_cl_set: NULL
click_date: 2020-11-12 11:27:34
1 row in set (0.00 sec)
</pre>
click_dateが9時間ずれている。
action_logや、stat_logではズレは発生していない。
RDSのタイムゾーン確認
<pre>
mysql> show variables like '%time_zone%';
+------------------+------------+
| Variable_name | Value |
+------------------+------------+
| system_time_zone | UTC |
| time_zone | Asia/Tokyo |
+------------------+------------+
2 rows in set (0.00 sec)
</pre>
DB2のタイムゾーン確認
<pre>
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | JST |
| time_zone | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)
</pre>
同一aff_idでのレコード確認
RDS
<pre>
mysql> select * from click_log_202011 where aff_id = "gsy46h4f05147958"\G
*************************** 1. row ***************************
click_log_id: 164285
c_owner_id: 284
c_id: 1372
m_owner_id: NULL
m_id: NULL
t_id:
asp_id: 275
listing_id: NULL
aff_id: gsy46h4f05147958
career_type: NULL
career: 4
agent: Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebK
term_name: PC
subscriber:
ip: 203.136.16.181
referer:
user_id: #asp#108204#2Po6hjRu##
media_data: NULL
url: http://spmode.takarakujiget.co.jp/sp/?af=gsy46h4f05147958
status: 0
click_cost_set: 0.00
click_cost_cl_set: 0.00
click_cost: 0.00
click_cost_cl: 0.00
action_cost_set: NULL
action_cost_cl_set: NULL
action_ratio_set: NULL
action_ratio_cl_set: NULL
click_date: 2020-11-12 02:27:34
1 row in set (0.00 sec)
</pre>
DB2
<pre>
mysql> select * from click_log_202011 where aff_id = "gsy46h4f05147958"\G
*************************** 1. row ***************************
click_log_id: 164285
c_owner_id: 284
c_id: 1372
m_owner_id: NULL
m_id: NULL
t_id:
asp_id: 275
listing_id: NULL
aff_id: gsy46h4f05147958
career_type: NULL
career: 4
agent: Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebK
term_name: PC
subscriber:
ip: 203.136.16.181
referer:
user_id: #asp#108204#2Po6hjRu##
media_data: NULL
url: http://spmode.takarakujiget.co.jp/sp/?af=gsy46h4f05147958
status: 0
click_cost_set: 0.00
click_cost_cl_set: 0.00
click_cost: 0.00
click_cost_cl: 0.00
action_cost_set: NULL
action_cost_cl_set: NULL
action_ratio_set: NULL
action_ratio_cl_set: NULL
click_date: 2020-11-12 11:27:34
1 row in set (0.00 sec)
</pre>
click_dateが9時間ずれている。
action_logや、stat_logではズレは発生していない。