I setup a asterisk server with addon cdr_mysql and mysql server in a single machine,it run good few days already.Last few day,my server disk space was fulled,and mysql server was stoped,so i deleted some monitor files,and the disk space return to 60% free,and i restarted the mysql,but i found the asterisk can’t record the cdr in mysql server no more,so i check the log of mysql,found the asterisk sent the error SQL command like this: “insert into cdr() values()”, and i must restart the asterisk to correct the problem,is there anyone tell me how come this problem?
Did you try restarting Asterisk or reloading cdr_mysql module from the Asterisk CLI? (usually with the command “core restart now” and “module reload cdr_mysql”)