Quantcast

assp with mysql

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

assp with mysql

Nelson Serafica-2
Has anyone encountered this error?

Apr-02-17 13:44:44 [Worker_10001] Error: FIRSTKEY (spamdbhelo): Can't
execute select statement: MySQL server has gone away
Apr-02-17 13:44:44 [Worker_10001] Database count statement failed
(spamdbhelo): MySQL server has gone away
Error: FIRSTKEY (spamdbhelo): Can't execute select statement: MySQL
server has gone away (suppressed 2 concurrent equal 'Error' loglines
from all Workers)

This is my my.cnf

# grep -v "^#" /etc/my.cnf | grep -v "^$"
[mysqld]
bind-address=127.0.0.1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
wait_timeout = 86400
connect_timeout = 86400
interactive_timeout = 86400
max_allowed_packet=1024M
max_connections=500
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

I have 6 cpu and 12GB RAM. I hope someone can share in resolving this
error. Google is not being friendly on this error :-)

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Assp-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: assp with mysql

aquilinux

Hi, what does the MySQL error log say?

Regards,


Il dom 2 apr 2017, 09:57 Nelson <[hidden email]> ha scritto:
Has anyone encountered this error?

Apr-02-17 13:44:44 [Worker_10001] Error: FIRSTKEY (spamdbhelo): Can't
execute select statement: MySQL server has gone away
Apr-02-17 13:44:44 [Worker_10001] Database count statement failed
(spamdbhelo): MySQL server has gone away
Error: FIRSTKEY (spamdbhelo): Can't execute select statement: MySQL
server has gone away (suppressed 2 concurrent equal 'Error' loglines
from all Workers)

This is my my.cnf

# grep -v "^#" /etc/my.cnf | grep -v "^$"
[mysqld]
bind-address=127.0.0.1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
wait_timeout = 86400
connect_timeout = 86400
interactive_timeout = 86400
max_allowed_packet=1024M
max_connections=500
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

I have 6 cpu and 12GB RAM. I hope someone can share in resolving this
error. Google is not being friendly on this error :-)

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Assp-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Assp-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: assp with mysql

Nelson Serafica-2
On Sun, Apr 2, 2017 at 5:14 PM, aquilinux <[hidden email]> wrote:
> Hi, what does the MySQL error log say?


Issue resolve after removing check on HMMusesBDB

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Assp-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user
Loading...