System Reporter errors

[toefoz]

We are seeing errors with System Reporter. We are using MySql. System Reporter 3.1.

Last sampling was 40 days ago.

Restart of system (VM) did not restart sampling.

Windows Event Log has the following SQL errors, oldest first:

a. Disk is full writing '.\inservstats\statldrg_hourly_2.TMD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
b. C:/Program Files/MySQL/MySQL Server 5.5/bin\mysqld: Table '.\inservstats\statldrg_hourly_2' is marked as crashed and last (automatic?) repair failed
c. Disk is full writing 'C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp\ST993E.tmp' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)


MySQL is on the C: drive. It has plenty of space.

How do we fix this issue?

Thanks

[Richard Siemers]

Sounds like your Mysql database is kaput. Since its been 40 days with no data anyway... you might save alot of time nuking (uninstalling) and rebuilding it... (Ripley: its the only way to be sure)

I would recommend putting the app and DB on a new drive for the new install.

If your SR data is very important, I recommend looking to use an external database server that your company supports in house with real DBAs. I keep 3 years of history on a oracle instance our DBAs keep around for "misc" stuff.