Mysql not logging in a new mysq.log file -

-

i've enabled logging in dev environment follows:

 general_log_file        = /var/log/mysql/mysql.log  general_log             = 1

but problem whenever server creates new mysql.log file, new log doesn't record mysql activities have restart mysql service , starts logging activities being on production cannot everyday restart mysql service. have checked newly created mysql.log file mysql:adm.


Comments

Post a Comment

Popular posts from this blog

python - Setting ctypes.Structure default values -

-
this doesn't work: class ifinfomsg(ctypes.structure): _fields_ = [ ('ifi_family', ctypes.c_ubyte), ('__ifi_pad', ctypes.c_ubyte), ('ifi_type', ctypes.c_ushort), ('ifi_index', ctypes.c_int), ('ifi_flags', ctypes.c_uint), ('ifi_change', ctypes.c_uint(0xffffffff)) ] it errors with: file "rtnetlink.py", line 243, in <module> class ifinfomsg(ctypes.structure): typeerror: error when calling metaclass bases second item in _fields_ tuple (index 5) must c type however can set values in __init__() : class ifinfomsg(ctypes.structure): _fields_ = [ ('ifi_family', ctypes.c_ubyte), ('__ifi_pad', ctypes.c_ubyte), ('ifi_type', ctypes.c_ushort), ('ifi_index', ctypes.c_int)...
Read more

Ansible - ERROR! the field 'hosts' is required but was not set -

-
i've error when launch playbook don't found why.... error! field 'hosts' required not set there main.yml : --- - hosts: hosts - vars: - elasticsearch_java_home: /usr/lib/jmv/jre-1.7.0 - elasticsearch_http_port: 8443 - tasks: - include: tasks/main.yml - handlers: - include: handlers/main.yml and /etc/ansible/hosts : [hosts] 10.23.108.182 10.23.108.183 10.23.108.184 10.23.108.185 when test ping, : [root@poste08-08-00 elasticsearch]# ansible hosts -m ping 10.23.108.183 | success => { "changed": false, "ping": "pong" } 10.23.108.182 | success => { "changed": false, "ping": "pong" } 10.23.108.185 | success => { "changed": false, "ping": "pong" } 10.23.108.184 | success => { "changed": false, "ping": "pong" } please, me :) regards, you have syntax error in playbook. ...
Read more

java - HTTP Status 500 - No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode -

-
i know question has been asked lot of times. have searched entire stack overflow, haven't been able out of it. understand exception arises when column name used in query different property specified in bean class, however, both of parameters same. complete error: java.lang.illegalstateexception: no data type node: org.hibernate.hql.internal.ast.tree.identnode +-[ident] identnode: 'iduserinfo' {originaltext=iduserinfo} this query: list<object[]> tuples = session.createquery( "select iduserinfo, sum(points) " + persistentclass.getname() + " group iduserinfo " + "order sum(points) desc").list(); and bean class: @xmlrootelement @entity @table(name = "userinfo") public class userinfo { protected @xmlelement int id; protected @xmlelement int iduserinfo; protected @xmlelement int idquestion; protected @xmlelement string location; protected @xmlelement string state; protected @xmlelement stri...
Read more