sudden error in syslog-ng 3.0.1..PLZ....HELP......

[GoogleCodeExporter]

hi 

i installed the syslog-ng above version in my production. it's really 
worked for long time . but suddenly occured a error (attached) .

it says that syslog.all_logs table doesnt exists. how can this happend 
even without doing a single change to the config.

i do the select * from all_logs; and says that 

ERROR 1146 (42S02): Table 'syslog.all_logs' doesn't exist

but still i can see the logs for particular date. but i couldn see the 
logs graph for particular date.

you replies are highly appriciated in order to solve this soon.

Thanks

Original issue reported on code.google.com by harshaa...@gmail.com on 7 Apr 2010 at 5:56

Attachments:

• 1.JPG
• 2.JPG

[GoogleCodeExporter]

Hi,
If it's not too much trouble, could you please post your question to
http://forum.logzilla.info.
I moved everything there so that others might benefit from any solutions :-)

To your issue:
It appears to be a log rotation problem. You should also make sure that none of 
your
tables are marked as crashed my using mysqlcheck.

If you can post this question to the forum, I'll work with you to get it 
resolved
asap :-)

Original comment by cdu...@gmail.com on 7 Apr 2010 at 1:35

• Changed state: Accepted
• Added labels: Priority-Medium