Hello,
Is there a way to clear/re-initializing the database? Or if I drop the database and reimport a clean one do I lose all the graps? I'm having some huge mysql problem after I did a php upgrade_database.php --forcever 1.2.14 from cli. To be exact, after that, mysql is killing the CPU and sometimes the server became unavailable. I've looked for errors, and I see tons of it , all mysql related, but dont know how to fix and what.
Centos 8, mariadb 10, php 7.2, cacti [ 1.3.0 - Dev 1ccc5f893 @ 2020-08-31 01:51 ], spine 1.2.8
Also some errors in httpd log :
[Wed Sep 02 09:38:06.063143 2020] [proxy_fcgi:error] [pid 50447:tid 140133777012480] (70007)The timeout specified has expired: [client 192.168.1.1:51138] AH01075: Error dispatching request to :5080: (polling), referer: http://192.168.1.254:5080/index.php
[Wed Sep 02 13:48:05.159084 2020] [proxy_fcgi:error] [pid 50446:tid 140134338832128] (70007)The timeout specified has expired: [client 192.168.1.1:49321] AH01075: Error dispatching request to :5080: (polling), referer: http://192.168.1.254:5080/graphs.php?
[Wed Sep 02 13:50:09.211255 2020] [proxy_fcgi:error] [pid 50445:tid 140134229989120] (70007)The timeout specified has expired: [client 192.168.1.1:49352] AH01075: Error dispatching request to :5080: (polling), referer: http://192.168.1.254:5080/graphs.php?
[Wed Sep 02 13:50:38.658701 2020] [proxy_fcgi:error] [pid 50445:tid 140134196418304] (70007)The timeout specified has expired: [client 192.168.1.1:49370] AH01075: Error dispatching request to :5080: (polling), referer: http://192.168.1.254:5080/graph_view.ph ... hyper=true
[Wed Sep 02 13:52:02.245097 2020] [proxy_fcgi:error] [pid 50445:tid 140134506817280] (70007)The timeout specified has expired: [client 192.168.1.1:49388] AH01075: Error dispatching request to :5080: (polling), referer: http://192.168.1.254:5080/graph_view.ph ... hyper=true
[Thu Sep 03 17:56:34.675084 2020] [proxy_fcgi:error] [pid 50446:tid 140134372402944] (70007)The timeout specified has expired: [client 192.168.1.1:50546] AH01075: Error dispatching request to :5080: (polling), referer: http://192.168.1.254:5080/graphs.php?
[Thu Sep 03 17:56:45.748525 2020] [proxy_fcgi:error] [pid 50447:tid 140133944768256] (70007)The timeout specified has expired: [client 192.168.1.1:50570] AH01075: Error dispatching request to :5080: (polling), referer: http://192.168.1.254:5080/clog.php
[Thu Sep 03 17:57:37.179130 2020] [proxy_fcgi:error] [pid 50446:tid 140133927982848] (70007)The timeout specified has expired: [client 192.168.1.1:50546] AH01075: Error dispatching request to :5080: (polling), referer: http://192.168.1.254:5080/clog.php
PS : I did a php repair_database also. Didnt help.
PS2: Also I'm having some problem starting(restarting) mariadb, even after server restart :
2020-09-03 18:53:04 0 [Note] InnoDB: To recover: 23485 pages from log
2020-09-03 18:53:19 0 [Note] InnoDB: To recover: 23091 pages from log
2020-09-03 18:53:34 0 [Note] InnoDB: To recover: 21873 pages from log
2020-09-03 18:53:49 0 [Note] InnoDB: To recover: 20613 pages from log
2020-09-03 18:54:04 0 [Note] InnoDB: To recover: 19507 pages from log
2020-09-03 18:54:19 0 [Note] InnoDB: To recover: 18227 pages from log
2020-09-03 18:54:34 0 [Note] InnoDB: To recover: 17714 pages from log
2020-09-03 18:54:49 0 [Note] InnoDB: To recover: 17408 pages from log
2020-09-03 18:55:04 0 [Note] InnoDB: To recover: 16967 pages from log
2020-09-03 18:55:19 0 [Note] InnoDB: To recover: 16582 pages from log
2020-09-03 18:58:49 0 [Note] InnoDB: To recover: 2276 pages from log
2020-09-03 18:59:04 0 [Note] InnoDB: To recover: 966 pages from log
2020-09-03 18:59:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-09-03 18:59:16 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2020-09-03 18:59:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-09-03 18:59:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-09-03 18:59:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-09-03 18:59:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-09-03 18:59:16 0 [Note] InnoDB: 10.3.17 started; log sequence number 198291720059; transaction id 119077714
2020-09-03 18:59:16 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-09-03 18:59:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-09-03 18:59:16 0 [Warning] mysqld: GSSAPI plugin : default principal 'mariadb/cacti.localhost@' not found in keytab
2020-09-03 18:59:16 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure. Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty.
2020-09-03 18:59:16 0 [ERROR] Plugin 'gssapi' init function returned error.
2020-09-03 18:59:16 0 [Note] Recovering after a crash using tc.log
2020-09-03 18:59:16 0 [Note] Starting crash recovery...
2020-09-03 18:59:16 0 [Note] Crash recovery finished.
2020-09-03 18:59:16 0 [Note] Server socket created on IP: '::'.
2020-09-03 18:59:18 0 [Note] Reading of all Master_info entries succeeded
2020-09-03 18:59:18 0 [Note] Added new Master_info '' to hash table
2020-09-03 18:59:18 0 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.3.17-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
2020-09-03 18:59:19 0 [Note] InnoDB: To roll back: 1 transactions, 788137 rows
2020-09-03 18:59:34 0 [Note] InnoDB: To roll back: 1 transactions, 786253 rows
2020-09-03 18:59:49 0 [Note] InnoDB: To roll back: 1 transactions, 784325 rows
2020-09-03 19:00:04 0 [Note] InnoDB: To roll back: 1 transactions, 782615 rows
2020-09-03 19:00:11 8 [ERROR] mysqld: Table './cacti/weathermap_data' is marked as crashed and should be repaired
2020-09-03 19:00:11 8 [Warning] Checking table: './cacti/weathermap_data'
2020-09-03 19:00:19 0 [Note] InnoDB: To roll back: 1 transactions, 780843 rows
2020-09-03 19:00:34 0 [Note] InnoDB: To roll back: 1 transactions, 779557 rows
2020-09-03 19:00:37 0 [Note] InnoDB: Buffer pool(s) load completed at 200903 19:00:37
2020-09-03 19:00:39 8 [ERROR] mysqld: Table './cacti/plugin_intropage_trends' is marked as crashed and should be repaired
2020-09-03 19:00:39 8 [Warning] Checking table: './cacti/plugin_intropage_trends'
2020-09-03 19:00:42 8 [ERROR] mysqld: Table './cacti/weathermap_maps' is marked as crashed and should be repaired
2020-09-03 19:00:42 8 [Warning] Checking table: './cacti/weathermap_maps'
2020-09-03 19:00:49 0 [Note] InnoDB: To roll back: 1 transactions, 771419 rows
2020-09-03 19:01:04 0 [Note] InnoDB: To roll back: 1 transactions, 769657 rows
2020-09-03 19:01:19 0 [Note] InnoDB: To roll back: 1 transactions, 768251 rows
2020-09-03 19:01:34 0 [Note] InnoDB: To roll back: 1 transactions, 765937 rows
2020-09-03 19:01:49 0 [Note] InnoDB: To roll back: 1 transactions, 764415 rows
2020-09-03 19:02:04 0 [Note] InnoDB: To roll back: 1 transactions, 763017 rows
2020-09-03 19:02:19 0 [Note] InnoDB: To roll back: 1 transactions, 761253 rows
2020-09-03 19:02:34 0 [Note] InnoDB: To roll back: 1 transactions, 760207 rows
2020-09-03 19:02:49 0 [Note] InnoDB: To roll back: 1 transactions, 758247 rows
2020-09-03 19:03:04 0 [Note] InnoDB: To roll back: 1 transactions, 755859 rows
2020-09-03 19:03:19 0 [Note] InnoDB: To roll back: 1 transactions, 753397 rows
2020-09-03 19:03:34 0 [Note] InnoDB: To roll back: 1 transactions, 748501 rows
2020-09-03 19:03:49 0 [Note] InnoDB: To roll back: 1 transactions, 745411 rows
2020-09-03 19:04:04 0 [Note] InnoDB: To roll back: 1 transactions, 743047 rows (this rollback happens everytime I try to start/restart mariadb)
2020-09-04 7:13:30 272 [Warning] Aborted connection 272 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:14:31 274 [Warning] Aborted connection 274 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:15:32 277 [Warning] Aborted connection 277 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:16:33 278 [Warning] Aborted connection 278 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:17:34 273 [Warning] Aborted connection 273 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:18:36 276 [Warning] Aborted connection 276 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:19:37 269 [Warning] Aborted connection 269 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:20:38 531 [Warning] Aborted connection 531 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:21:39 275 [Warning] Aborted connection 275 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
2020-09-04 7:22:40 530 [Warning] Aborted connection 530 to db: 'cacti' user: 'cacti' host: 'localhost' (Got timeout reading communication packets)
CPU usage is extremly high : 10:33:25 up 12:41, 1 user, load average: 26.18, 28.84, 29.93
Also the webpage is unavailable everytime I try to delete graphs(504 gateway timeout).
Is not a production server, so I dont mind losing graphs for a day or even all, as long as it will repopulate those graps.
Cacti 1.3.0 - devel - Database clear/re-initializing
Moderators: Developers, Moderators
Cacti 1.3.0 - devel - Database clear/re-initializing
- Attachments
-
- 504 timeout.jpg (47.98 KiB) Viewed 1543 times
-
- 504 gateway timeout.jpg (120.84 KiB) Viewed 1543 times
Who is online
Users browsing this forum: No registered users and 1 guest