Mysql Error

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Mysql Error

Postby ayan07 » Tue Jul 24, 2018 7:28 am

Hi,

Suddenly getting error as "Mysql Error: Too many connections" during admin panel login and prior today vicibox 8.0 configurations was working smoothly for last 1 months.

Please advise how to fix this issue as i already set "max connections" variable value to 1000.

Please help me and seeking your expert advise.

Thanks in Advance ...

Roy
ayan07
 
Posts: 27
Joined: Mon Jul 23, 2018 8:21 am

Re: Mysql Error

Postby mflorell » Tue Jul 24, 2018 9:24 am

This is usually caused by too many log entries. Do you have the archiving process set up in your system?

How many leads are in your vicidial_list table?

Have you looked at your database's slow query log?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Mysql Error

Postby ayan07 » Fri Jul 27, 2018 8:02 am

Hello mflorell,

first of all thanks for your prompt reply and sorry for my delayed response ...

Yes i have archiving process set up in my system...

there are all together 8 lead pack and leads count would be around 60K , not more than that...

Actually slow query log was not installed in my system and i have installed it now...

+--------------------+----------------------+
| Data Base Name | Data Base Size in MB |
+--------------------+----------------------+
| asterisk | 32.24125767 |
| information_schema | 0.17187500 |
| mysql | 0.65864754 |
| performance_schema | 0.00000000 |
+--------------------+----------------------+

Looking for your expert views plz...

Thanks in Advance.

Roy
ayan07
 
Posts: 27
Joined: Mon Jul 23, 2018 8:21 am

Re: Mysql Error

Postby mflorell » Fri Jul 27, 2018 7:59 pm

If this has happened again since enabling slow query logging, did you find anything in the slow query log around the time this happened?

Also, when this happens, try going to the mysql CLI client and type "show full processlist;"
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Mysql Error

Postby ayan07 » Sat Jul 28, 2018 4:38 am

Hello mflorell,

Thanks for your prompt reply. I am still getting the same error and cant login into admin / agent prompt.

***Here is the output of full process list :-

MariaDB [(none)]> show full processlist;
+----+------+-----------+----------+---------+------+-------+-----------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+------+-----------+----------+---------+------+-------+-----------------------+----------+
| 13 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 14 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 18 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 19 | cron | localhost | asterisk | Sleep | 178 | | NULL | 0.000 |
| 30 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 31 | cron | localhost | asterisk | Sleep | 14 | | NULL | 0.000 |
| 32 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 33 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 34 | cron | localhost | asterisk | Sleep | 0 | | NULL | 0.000 |
| 42 | root | localhost | NULL | Query | 0 | init | show full processlist | 0.000 |
| 44 | cron | localhost | asterisk | Sleep | 1 | | NULL | 0.000 |
| 47 | cron | localhost | asterisk | Sleep | 1 | | NULL | 0.000 |
+----+------+-----------+----------+---------+------+-------+-----------------------+----------+
12 rows in set (0.00 sec)

***Here is the output of slow query log :-

/usr/sbin/mysqld, Version: 10.1.25-MariaDB (openSUSE package). started with:
Tcp port: 3306 Unix socket: /var/run/mysql/mysql.sock
Time Id Command Argument

***Here is the output of mysql log :-

2018-07-28 14:46:54 139784997292288 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: The InnoDB memory heap is disabled
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Using Linux native AIO
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Using SSE crc32 instructions
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Completed initialization of buffer pool
2018-07-28 14:46:54 139784997292288 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-28 14:46:55 139784997292288 [Note] InnoDB: 128 rollback segment(s) are active.
2018-07-28 14:46:55 139784997292288 [Note] InnoDB: Waiting for purge to start
2018-07-28 14:46:55 139784997292288 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1617275
2018-07-28 14:46:55 139784997292288 [Note] Plugin 'FEEDBACK' is disabled.
2018-07-28 14:46:55 139782067844864 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-07-28 14:46:56 139784997292288 [Note] Server socket created on IP: '::'.
2018-07-28 14:46:56 139784997292288 [Warning] 'user' entry 'root@vicibox8' ignored in --skip-name-resolve mode.
2018-07-28 14:46:56 139784997292288 [Warning] 'user' entry '@vicibox8' ignored in --skip-name-resolve mode.
2018-07-28 14:46:56 139784997292288 [Warning] 'proxies_priv' entry '@% root@vicibox8' ignored in --skip-name-resolve mode.
2018-07-28 14:46:56 139784997292288 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.25-MariaDB' socket: '/var/run/mysql/mysql.sock' port: 3306 openSUSE package

Looking for your expert views plz...

Thanks in Advance.

Roy
ayan07
 
Posts: 27
Joined: Mon Jul 23, 2018 8:21 am

Re: Mysql Error

Postby mflorell » Sat Jul 28, 2018 5:23 am

Was the "Too many connections" issue happening when you generated this output?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Mysql Error

Postby ayan07 » Sat Jul 28, 2018 7:27 am

Hello mflorell,

Actually its happening for last 5 days ... we can login by putty and wincsp but cant login into dialer by typing ip in url... admin and agent login screen is not coming , its showing only "MySQL Error: Too many connections" in screen...

Please Advise...

Thanks in Advance...

Roy
ayan07
 
Posts: 27
Joined: Mon Jul 23, 2018 8:21 am

Re: Mysql Error

Postby mflorell » Sat Jul 28, 2018 2:21 pm

That doesn't make much sense to me, might be a bug I guess, but I have never seen a situation like that myself.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Mysql Error

Postby ayan07 » Mon Jul 30, 2018 5:24 am

any mysql or database troubleshooting recommendation mflorell sir...

otherwise reinstalling would be the last therapy...

waiting for your expert views mflorell sir...

Thanks in Advance

Roy
ayan07
 
Posts: 27
Joined: Mon Jul 23, 2018 8:21 am

Re: Mysql Error

Postby uncapped_shady » Thu Aug 02, 2018 4:09 pm

Hi there

Try modifying the max_connections in your /etc/my.cnf

Set it to something like max_connections=2048
Also make a backup of your /etc/apache2/server-tuning.conf file as per below:

cp -r /etc/apache2/server-tuning.conf /etc/apache2/server-tuning.conf.bak
Then copy /usr/src/astguiclient/conf/server-tuning.conf to /etc/apache2/server-tuning.conf and reboot your server.

Let me know if this helps.
uncapped_shady
 
Posts: 30
Joined: Sat Jan 20, 2018 5:51 pm
Location: South Africa Gauteng

Re: Mysql Error

Postby ayan07 » Sat Aug 04, 2018 4:21 am

hello uncapped_shady,

Thanks for your help but problem still persists...

I have extended max connections to 2048 by editing /etc/my.cnf file...

MariaDB [(none)]> show variables like "max_connections";
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 2048 |
+-----------------+-------+
1 row in set (0.00 sec)


I have followed your instruction towards server-tuning.conf file strictly but no response as of yet...

Waiting for your expert views & Thanks in Advance...

Roy
ayan07
 
Posts: 27
Joined: Mon Jul 23, 2018 8:21 am

Re: Mysql Error

Postby uncapped_shady » Sat Aug 04, 2018 10:22 am

Please provide us with a bit more information regarding your setup.
Server setup (Express 1 server install or cluster) If clustered, how is this setup?
Specs of the server/s used including type of drives + RAID config, CPU information as well as your memory configuration, especially of the database server.

Once we have the above information we can troubleshoot this a bit more.

Tanks
uncapped_shady
 
Posts: 30
Joined: Sat Jan 20, 2018 5:51 pm
Location: South Africa Gauteng


Return to Support

Who is online

Users browsing this forum: No registered users and 82 guests