Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Wed Jul 17, 2019 9:54 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Oddball problem with MariaDB
PostPosted: Fri Jun 28, 2019 6:47 pm 
Offline
Cacti User
User avatar

Joined: Wed Jun 24, 2009 9:42 am
Posts: 97
I have a Cacti install that has been around since the .8.7 days (I think). It's been upgraded with the windows installer periodically.

Around the .8.8g days, I made a central DB and figured, why not? Let's use 1 DB server for everything. Okay, that was going well while the DB was MySQL 5.x. I decided that it was probably best to move up to MariaDB, and installed that. Everything went swimmingly, except Cacti.

About every 4 hours, my logs complain about a lost connection to the DB server with this:

Code:
2019/06/25 00:47:31 - SPINE: Poller[Main Poller] FATAL: MySQL Error:'2006', Message:'MySQL server has gone away' [11, Resource temporarily unavailable] (Spine thread)
2019/06/25 00:47:31 - SPINE: Poller[Main Poller] ERROR: SQL Failed! Error:'2006', Message:'MySQL server has gone away', SQL Fragment:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES', ''))'
2019/06/25 00:47:31 - SPINE: Poller[Main Poller] ERROR: SQL Failed! Error:'2006', Message:'MySQL server has gone away', SQL Fragment:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'STRICT_ALL_TABLES', ''))'
2019/06/25 00:47:31 - SPINE: Poller[Main Poller] ERROR: SQL Failed! Error:'2006', Message:'MySQL server has gone away', SQL Fragment:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'TRADITIONAL', ''))'
2019/06/25 00:47:31 - SPINE: Poller[Main Poller] ERROR: SQL Failed! Error:'2006', Message:'MySQL server has gone away', SQL Fragment:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'NO_AUTO_VALUE_ON_ZERO', ''))'
2019/06/25 00:47:31 - SPINE: Poller[Main Poller] ERROR: SQL Failed! Error:'2006', Message:'MySQL server has gone away', SQL Fragment:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY', ''))'
2019/06/25 00:47:31 - SPINE: Poller[Main Poller] ERROR: SQL Failed! Error:'2013', Message:'Lost connection to MySQL server during query', SQL Fragment:'SET SESSION sql_mode = (SELECT REPLACE(@@sql_mode,'NO_ZERO_IN_DATE', ''))'


This is the mode on my SQL server:

Code:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 539684
Server version: 10.2.22-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@sql_mode;
+-----------------------------------------------------------------------+
| @@sql_mode                                                            |
+-----------------------------------------------------------------------+
| ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]>


There's no need to set the SQL mode as all the STRICTS are off, so I'm wondering if I have missed something.

_________________
mount -o protected -t voluptuous,selfmaintaining /dev/woman /mnt/me
Attitude is no substitute for competence
See through faded, super jaded, out of my mind


Top
 Profile  
 
 Post subject: Re: Oddball problem with MariaDB
PostPosted: Mon Jul 01, 2019 5:25 pm 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2585
What vefsion of spine/cacti are you running?

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Oddball problem with MariaDB
PostPosted: Tue Jul 16, 2019 7:19 pm 
Offline
Cacti User
User avatar

Joined: Wed Jun 24, 2009 9:42 am
Posts: 97
Cacti 1.2.3 with Spine 1.2.3 x86. . .

I had an issue where the 64-bit compiled Spine couldn't find the resources. Did a search on that and it pointed me to the x86 version.

On a side note, I apologize for the delayed answer. . .I have it set to notify me when a reply was posted, but I never got notified. :( Or gmail's spam filter didn't like the notification.

_________________
mount -o protected -t voluptuous,selfmaintaining /dev/woman /mnt/me
Attitude is no substitute for competence
See through faded, super jaded, out of my mind


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group