Team B
[ZBX-13257] Doesn’t a display the lastest in auditlog. Created: 2017 Dec 26 Updated: 2024 Apr 10 Resolved: 2018 Mar 08 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | None |
| Fix Version/s: | 3.0.16rc1, 3.4.8rc1, 4.0.0alpha5, 4.0 (plan) |
| Type: | Problem report | Priority: | Minor |
| Reporter: | Hayato Watanabe | Assignee: | Andrejs Griščenko |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
3.0 |
||
| Team: | Team B |
| Sprint: | Sprint 25, Sprint 26, Sprint 27, Sprint 28, Sprint 29 |
| Story Points: | 1 |
| Description |
|
When "Search/Filter elements" over than an limit, doesn't a display the lastest in Reports -> auditlog. Zoom_All 2017-12-26 09:32:12 Admin 192.168.10.109 User group Added 0 Group name [hoge] 2017-12-26 09:31:53 Admin 192.168.10.109 User group Enabled 0 Debug mode for group name [Disabled] .... Displaying 1 to 50 of 100+ found Zoom_1h 2017-12-26 09:39:26 Admin 192.168.10.109 User Updated 0 User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] 2017-12-26 09:32:12 Admin 192.168.10.109 User group Added 0 Group name [hoge] 2017-12-26 09:31:53 Admin 192.168.10.109 User group Enabled 0 Debug mode for group name [Disabled] .... Displaying 39 of 39 found 2017-12-26 09:39:26 ... UNIXTIME(1514248766) There is nothing wrong with it clock. webui_debug_All SQL (0.001353): SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1512455625' AND a.clock<'1514250039' ORDER BY a.clock DESC LIMIT 101 OFFSET 0 webui_debug_1h SQL (0.000241): SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1514246407' AND a.clock<'1514250007' ORDER BY a.clock DESC LIMIT 101 OFFSET 0 mysql_query_log_All 105 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.auditlogs.filter.resourcetype'
105 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.auditlogs.filter.alias'
105 Query SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1512455625' AND a.clock<'1514250039' ORDER BY a.clock DESC LIMIT 101 OFFSET 0
105 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='188'
105 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='156'
105 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='155'
105 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='154'
mysql_query_log_1h 99 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.auditlogs.filter.resourcetype'
99 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.auditlogs.filter.alias'
99 Query SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1514246407' AND a.clock<'1514250007' ORDER BY a.clock DESC LIMIT 101 OFFSET 0
99 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='188'
99 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.lastpage'
99 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.page'
thank you. |
| Comments |
| Comment by Oleksii Zagorskyi [ 2017 Dec 26 ] |
|
Could it be duplicate of |
| Comment by Hayato Watanabe [ 2017 Dec 28 ] |
|
Not like that. That was proper time " from ~ to" MariaDB [zabbix]> SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1512455625' AND a.clock<'1514250039' ORDER BY a.clock DESC LIMIT 101 OFFSET 0; +---------+------------+-------+----------------+--------------+--------+------------+--------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | auditid | clock | alias | ip | resourcetype | action | resourceid | resourcename | details | +---------+------------+-------+----------------+--------------+--------+------------+--------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 226 | 1514248766 | Admin | 192.168.10.109 | 0 | 1 | 0 | | User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] | | 225 | 1514248332 | Admin | 192.168.10.109 | 11 | 0 | 0 | | Group name [hoge] | | 223 | 1514248313 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 224 | 1514248313 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 222 | 1514248312 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 221 | 1514248312 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 218 | 1514248311 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 219 | 1514248311 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 220 | 1514248311 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 216 | 1514248310 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 217 | 1514248310 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 215 | 1514248309 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 213 | 1514248309 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 214 | 1514248309 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 212 | 1514248308 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 211 | 1514248307 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 210 | 1514248307 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 208 | 1514248306 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 209 | 1514248306 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 207 | 1514248305 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 205 | 1514248304 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 206 | 1514248304 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 204 | 1514248303 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 202 | 1514248303 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 203 | 1514248303 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 200 | 1514248302 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 201 | 1514248302 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 197 | 1514248301 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 198 | 1514248301 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 199 | 1514248301 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 194 | 1514248300 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 195 | 1514248300 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 196 | 1514248300 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 193 | 1514248299 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 192 | 1514248299 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Disabled] | | 191 | 1514248298 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Disabled] | | 190 | 1514248297 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 189 | 1514248296 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 188 | 1514248123 | Admin | 192.168.10.109 | 4 | 1 | 10154 | ping | 0 | | 187 | 1514193097 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 186 | 1514192997 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 185 | 1514192982 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 184 | 1514191647 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 183 | 1514191555 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 182 | 1514191533 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 181 | 1514191431 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 180 | 1514191396 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 179 | 1514191317 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Enabled debug mode] | | 178 | 1514191314 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 177 | 1514191313 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 175 | 1514191312 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 176 | 1514191312 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 173 | 1514191311 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 174 | 1514191311 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 172 | 1514191310 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 171 | 1514191308 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 170 | 1514191297 | Admin | 192.168.10.109 | 2 | 1 | 0 | | デフォルトのテーマ"blue-theme"。; イベントの障害対応コメント"1".; イベントの表示期間(日) "7"; イベントの最大表示期間 "100"; ドロップダウンの1つ目の項目 "1"; ドロップダウンの選択を記憶する "1"; テーブル... | | 168 | 1514191290 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 169 | 1514191290 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 166 | 1514191289 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 167 | 1514191289 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 165 | 1514191288 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 164 | 1514191288 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 163 | 1514191287 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 162 | 1514191286 | Admin | 192.168.10.109 | 11 | 6 | 0 | | Debug mode for group name [Zabbix administrators] | | 161 | 1514177848 | Admin | 192.168.10.109 | 11 | 5 | 0 | | Debug mode for group name [Zabbix administrators] | | 160 | 1513852532 | Admin | 192.168.10.109 | 15 | 2 | 0 | | アイテム [icmpping[192.168.11.2 ,3,2000,50000,3000]] [25442] ホスト [ping] | | 159 | 1513852441 | Admin | 192.168.10.109 | 15 | 2 | 0 | | アイテム [icmpping[192.168.11.2,3,2000,50000,3000]] [25441] ホスト [ping] | | 158 | 1513852422 | Admin | 192.168.10.109 | 2 | 1 | 0 | | 取得不可アイテムの更新間隔(秒) "30".; ディスカバリで発見されたホスト"Discovered hosts"のグループ。; データベース停止メッセージ"Zabbix administrators"の送信先グループ。 | | 157 | 1513852083 | Admin | 192.168.10.109 | 0 | 1 | 0 | | User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] | | 156 | 1513852011 | Admin | 192.168.10.109 | 4 | 1 | 10139 | 5239f75b-7d4f-d65e-2252-1ec3a89a0336 | 0 | | 155 | 1513852000 | Admin | 192.168.10.109 | 4 | 1 | 10139 | 5239f75b-7d4f-d65e-2252-1ec3a89a0336 | 0 | | 154 | 1513851933 | Admin | 192.168.10.109 | 4 | 1 | 10139 | 5239f75b-7d4f-d65e-2252-1ec3a89a0336 | 0 | | 153 | 1513851906 | Admin | 192.168.10.109 | 4 | 1 | 10139 | 5239f75b-7d4f-d65e-2252-1ec3a89a0336 | 0 | | 152 | 1513851870 | Admin | 192.168.10.109 | 0 | 1 | 0 | | User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] | | 151 | 1513851830 | Admin | 192.168.10.109 | 4 | 1 | 10139 | 5239f75b-7d4f-d65e-2252-1ec3a89a0336 | 0 | | 150 | 1513851817 | Admin | 192.168.10.109 | 4 | 1 | 10139 | 5239f75b-7d4f-d65e-2252-1ec3a89a0336 | 0 | | 149 | 1513851795 | Admin | 192.168.10.109 | 4 | 1 | 10151 | test server | 0 | | 148 | 1513851790 | Admin | 192.168.10.109 | 4 | 1 | 10152 | trapper | 0 | | 147 | 1513851784 | Admin | 192.168.10.109 | 4 | 1 | 10084 | Zabbix server | 0 | | 146 | 1513851781 | Admin | 192.168.10.109 | 4 | 1 | 10153 | test | 0 | | 145 | 1513851689 | Admin | 192.168.10.109 | 4 | 0 | 10154 | ping | 0 | | 144 | 1513655798 | Admin | 192.168.10.109 | 15 | 2 | 0 | | アイテム [logrt["/tmp/errorlog.txt"]] [25439] ホスト [Zabbix server] | | 143 | 1513654683 | Admin | 192.168.10.109 | 4 | 1 | 10084 | Zabbix server | 0 | | 142 | 1513652717 | Admin | 192.168.10.109 | 0 | 1 | 0 | | User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] | | 141 | 1513236105 | Admin | 192.168.10.109 | 5 | 1 | 0 | | Name: echo test | | 140 | 1513235630 | Admin | 192.168.10.109 | 5 | 1 | 0 | | Name: echo test | | 139 | 1513232692 | Admin | 192.168.10.109 | 0 | 1 | 0 | | User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] | | 138 | 1513229996 | Admin | 192.168.10.109 | 5 | 1 | 0 | | 名前: echo test | | 137 | 1513229099 | Admin | 192.168.10.109 | 13 | 0 | 13561 | test | 0 | | 136 | 1513229060 | Admin | 192.168.10.109 | 4 | 0 | 10153 | test | 0 | | 135 | 1513228659 | Admin | 192.168.10.109 | 13 | 1 | 13560 | trap | 0 | | 134 | 1513228527 | Admin | 192.168.10.109 | 13 | 0 | 13560 | trap | 0 | | 133 | 1513228072 | Admin | 192.168.10.109 | 4 | 0 | 10152 | trapper | 0 | | 132 | 1513222816 | Admin | 192.168.10.109 | 5 | 1 | 0 | | 名前: echo test | | 131 | 1513048640 | Admin | 192.168.10.109 | 5 | 1 | 0 | | 名前: echo test | | 130 | 1513044020 | Admin | 192.168.10.109 | 0 | 1 | 0 | | User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] | | 129 | 1513040800 | Admin | 192.168.10.109 | 0 | 1 | 0 | | User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] | | 128 | 1513040688 | Admin | 192.168.10.109 | 0 | 1 | 0 | | User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1] | | 127 | 1513040631 | Admin | 192.168.10.109 | 3 | 1 | 0 | | Media type [Email] | | 126 | 1513040605 | Admin | 192.168.10.109 | 5 | 1 | 0 | | Name: echo test | +---------+------------+-------+----------------+--------------+--------+------------+--------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 101 rows in set (0.00 sec) For example, when always "+ found" of "Displaying 1 to 50 of 100+ found" message occurring. |
| Comment by Andrejs Griščenko [ 2018 Feb 08 ] |
|
(1) No translation string changes. sasha CLOSED |
| Comment by Andrejs Griščenko [ 2018 Feb 08 ] |
|
RESOLVED in svn://svn.zabbix.com/branches/dev/ZBX-13257 |
| Comment by Andrejs Griščenko [ 2018 Mar 07 ] |
|
Fixed in:
|