Cacti 1.3.0 - devel - Database clear/re-initializing

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
Atreides
Cacti User
Posts: 174
Joined: Mon May 31, 2010 9:26 am

Cacti 1.3.0 - devel - Database clear/re-initializing

Post by Atreides »

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.
Attachments
504 timeout.jpg
504 timeout.jpg (47.98 KiB) Viewed 1543 times
504 gateway timeout.jpg
504 gateway timeout.jpg (120.84 KiB) Viewed 1543 times
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest