Ad Widget

Collapse

Session terminated, re-login, please

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Fractal1990
    Senior Member
    • Mar 2016
    • 129
    #1

    Session terminated, re-login, please

    Поставил 3 дня назад zabbix на виртуалку, сделал партиционирование, воткнул один хост - сам Zabbix сервер, графики были, сегодня решил зайти глянуть и в итоге при вводе логина с паролем с любого браузера пишет "Session terminated, re-login, please."
    Attached Files
    Tags: None
    • Fractal1990
      Senior Member
      • Mar 2016
      • 129
      #2
      в логах пестрит:

      Code:
      1296:20160803:005734.147 Starting Zabbix Server. Zabbix 3.0.4 (revision 61185).
  1296:20160803:005734.147 ****** Enabled features ******
  1296:20160803:005734.148 SNMP monitoring:           YES
  1296:20160803:005734.148 IPMI monitoring:           YES
  1296:20160803:005734.148 Web monitoring:            YES
  1296:20160803:005734.148 VMware monitoring:         YES
  1296:20160803:005734.148 SMTP authentication:       YES
  1296:20160803:005734.148 Jabber notifications:      YES
  1296:20160803:005734.148 Ez Texting notifications:  YES
  1296:20160803:005734.148 ODBC:                      YES
  1296:20160803:005734.148 SSH2 support:              YES
  1296:20160803:005734.148 IPv6 support:              YES
  1296:20160803:005734.148 TLS support:               YES
  1296:20160803:005734.148 ******************************
  1296:20160803:005734.148 using configuration file: /etc/zabbix/zabbix_server.conf
  1296:20160803:005734.156 current database version (mandatory/optional): 03000000/03000000
  1296:20160803:005734.156 required mandatory version: 03000000
  1296:20160803:005734.161 server #0 started [main process]
  1300:20160803:005734.164 server #2 started [db watchdog #1]
  1301:20160803:005734.164 server #3 started [poller #1]
  1302:20160803:005734.168 server #4 started [poller #2]
  1299:20160803:005734.172 server #1 started [configuration syncer #1]
  1303:20160803:005734.172 server #5 started [poller #3]
  1305:20160803:005734.176 server #7 started [poller #5]
  1304:20160803:005734.180 server #6 started [poller #4]
  1306:20160803:005734.181 server #8 started [unreachable poller #1]
  1307:20160803:005734.184 server #9 started [trapper #1]
  1309:20160803:005734.192 server #11 started [trapper #3]
  1308:20160803:005734.193 server #10 started [trapper #2]
  1312:20160803:005734.195 server #14 started [icmp pinger #1]
  1310:20160803:005734.195 server #12 started [trapper #4]
  1311:20160803:005734.196 server #13 started [trapper #5]
  1313:20160803:005734.197 server #15 started [alerter #1]
  1314:20160803:005734.197 server #16 started [housekeeper #1]
  1315:20160803:005734.198 server #17 started [timer #1]
  1316:20160803:005734.198 server #18 started [http poller #1]
  1318:20160803:005734.200 server #20 started [history syncer #1]
  1319:20160803:005734.201 server #21 started [history syncer #2]
  1323:20160803:005734.224 server #23 started [history syncer #4]
  1324:20160803:005734.224 server #24 started [escalator #1]
  1325:20160803:005734.226 server #25 started [java poller #1]
  1326:20160803:005734.228 server #26 started [java poller #2]
  1327:20160803:005734.229 server #27 started [java poller #3]
  1328:20160803:005734.232 server #28 started [java poller #4]
  1329:20160803:005734.232 server #29 started [java poller #5]
  1330:20160803:005734.233 server #30 started [snmp trapper #1]
  1322:20160803:005734.234 server #22 started [history syncer #3]
  1331:20160803:005734.236 server #31 started [proxy poller #1]
  1332:20160803:005734.240 server #32 started [self-monitoring #1]
  1317:20160803:005734.310 server #19 started [discoverer #1]
  1315:20160803:005800.207 [Z3005] query failed: [1526] Table has no partition for value 1470185880 [insert into events (eventid,source,object,objectid,clock,ns,value) values (63,3,0,13491,1470185880,206115568,1);
]
  1322:20160803:010022.452 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (23662,1470182400,2,0,0,0);
]
  1318:20160803:010032.457 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23252,1470182400,2,0.000000,0.000000,0.000000);
]
  1319:20160803:010033.467 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23253,1470182400,2,0.000000,0.000000,0.000000);
]
  1319:20160803:010034.471 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23254,1470182400,2,0.000000,0.000000,0.000000);
]
  1322:20160803:010035.476 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23255,1470182400,3,0.000000,2.333333,7.000000);
]
  1322:20160803:010036.479 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23256,1470182400,3,0.000000,0.000000,0.000000);
]
  1322:20160803:010037.483 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23257,1470182400,3,0.067774,0.277294,0.666667);
]
  1318:20160803:010038.484 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23258,1470182400,3,0.000000,0.000000,0.000000);
]
  1319:20160803:010039.484 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23259,1470182400,3,0.000000,0.000000,0.000000);
]
  1322:20160803:010040.488 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23620,1470182400,3,99.666962,99.710706,99.777784),(23260,1470182400,3,0.000000,0.000000,0.000000);
]
  1318:20160803:010042.489 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23262,1470182400,3,0.000000,0.008333,0.025000);
]
  1319:20160803:010044.490 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23264,1470182400,3,0.000000,0.233333,0.700000);
]
  1319:20160803:010045.494 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23265,1470182400,3,0.000000,0.030303,0.090909),(23625,1470182400,2,1.616114,2.574212,3.532310);
]
  1318:20160803:010046.507 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23266,1470182400,3,0.000000,0.000000,0.000000);
]
  1322:20160803:010047.507 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23267,1470182400,3,0.000000,0.000000,0.000000);
]
  1318:20160803:010048.511 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23628,1470182400,2,0.000000,0.741429,1.482858),(23268,1470182400,3,0.000000,0.011296,0.033887);
]
  1318:20160803:010049.527 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23269,1470182400,3,0.000000,0.000000,0.000000);
]
  1322:20160803:010050.527 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23270,1470182400,3,0.000000,0.151481,0.437500);
]
  1319:20160803:010053.529 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23273,1470182400,3,98.554707,98.565388,98.586750);
]
  1318:20160803:010054.539 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23274,1470182400,3,99.999666,99.999889,100.000000);
]
  1322:20160803:010055.540 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23275,1470182400,3,99.777391,99.777391,99.777391);
]
  1318:20160803:010056.544 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23276,1470182400,3,99.912453,99.918747,99.929237);
]
  1319:20160803:010057.547 [Z3005] query failed: [1526] Table has no partition for value 1470182400 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23277,1470182400,2,0.433200,0.433206,0.433212);
]

        Comment

        • Fractal1990
          Senior Member
          • Mar 2016
          • 129
          #3
          я так понимаю походу что то со скриптом создания таблиц? вроде все по статье делал, прошло без ошибок, после этого запустил все работало, как найти ошибку? делал так, там вроде процедуры проверки и создания есть http://unixadm.info/content/разбиени...;-zabbix-mysql

            Comment

            • Fractal1990
              Senior Member
              • Mar 2016
              • 129
              #4
              Code:
              mysql> SHOW PROCEDURE STATUS;
+--------+---------------------------+-----------+----------------+-------------                                                                                        --------+---------------------+---------------+---------+----------------------+                                                                                        ----------------------+--------------------+
| Db     | Name                      | Type      | Definer        | Modified                                                                                                    | Created             | Security_type | Comment | character_set_client |                                                                                         collation_connection | Database Collation |
+--------+---------------------------+-----------+----------------+-------------                                                                                        --------+---------------------+---------------+---------+----------------------+                                                                                        ----------------------+--------------------+
| zabbix | create_next_partitions    | PROCEDURE | root@localhost | 2016-07-31 1                                                                                        3:02:32 | 2016-07-31 13:02:32 | DEFINER       |         | utf8                 |                                                                                         utf8_general_ci      | utf8_bin           |
| zabbix | create_partition_by_day   | PROCEDURE | root@localhost | 2016-07-31 1                                                                                        3:02:55 | 2016-07-31 13:02:55 | DEFINER       |         | utf8                 |                                                                                         utf8_general_ci      | utf8_bin           |
| zabbix | create_partition_by_month | PROCEDURE | root@localhost | 2016-07-31 1                                                                                        3:03:24 | 2016-07-31 13:03:24 | DEFINER       |         | utf8                 |                                                                                         utf8_general_ci      | utf8_bin           |
| zabbix | drop_old_partition        | PROCEDURE | root@localhost | 2016-07-31 1                                                                                        3:04:51 | 2016-07-31 13:04:51 | DEFINER       |         | utf8                 |                                                                                         utf8_general_ci      | utf8_bin           |
| zabbix | drop_partitions           | PROCEDURE | root@localhost | 2016-07-31 1                                                                                        3:03:55 | 2016-07-31 13:03:55 | DEFINER       |         | utf8                 |                                                                                         utf8_general_ci      | utf8_bin           |
+--------+---------------------------+-----------+----------------+-------------                                                                                        --------+---------------------+---------------+---------+----------------------+                                                                                        ----------------------+--------------------+
5 rows in set (0.00 sec)

                Comment

                Previous template Next
                Working...