Strange SQL error

plaguekriz · Post by **plaguekriz** » Tue Jul 14, 2009 2:16 am

I've installed Cacti recently and have problem with SQL database. In cacti log some time appear records like that:

07/14/2009 11:10:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (7, 'proc', '2009-07-14 11:10:01', '136')"
07/14/2009 11:10:01 AM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl /var/www/cacti/scripts/unix_processes.pl, output: 136
07/14/2009 11:10:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (6, 'users', '2009-07-14 11:10:01', '0')'

As you can see cacti cannot write information about users but easily write information about processes. Also there are same errors with mem_swap and mem_buffers. Please help me fix this problem.

BSOD2600 · Post by **BSOD2600** » Tue Jul 14, 2009 12:19 pm

What cacti, php, mysql version? Cacti 0.8.7e is the latest, I suggest you upgrade.

Cacti technical support page show any errors?

Post by **gandalf** » Tue Jul 14, 2009 3:20 pm

This may be a result of a double poller issue, please see 2nd link of my sig and read thoroughly
Reinhard

hapklaar · Post by **hapklaar** » Thu Jul 16, 2009 3:54 pm

Having the same problem, resulting in occasional gaps in graphs. Another symptom is that a poll run sometimes times out on 300secs. Normally this takes 58 secs using cmd.php. Haven't been able to find out yet what it could be using cacti.log.

I'm using cacti 0.8.7d and had one red line on the technical support page saying I needed to increase memory_limit in php.ini. Just increased it to 128MB.

I will check out the link Gandalf suggested now and will report back later

hapklaar · Post by **hapklaar** » Mon Jul 20, 2009 8:27 am

I've not been able to track the cause down. This seems to be happening a couple of times a day. Sometime giving SQL errors, other times just exceeded runtime errors or script errors. I've included a piece of the log file, not debug log though, because this becomes too huge to work with.

What could this be?

BSOD2600 · Post by **BSOD2600** » Mon Jul 20, 2009 5:22 pm

Those spurts of time where lots of devices get the "Result from SERVER not valid" -- what types of devices and what are those DS's running? The MySQL server on the same box as cacti or remote? A WAG would be a network latency/other issue, since the poller runs ok for 1+ hour periods at a time.

hapklaar · Post by **hapklaar** » Mon Jul 20, 2009 5:29 pm

Those datasources are all advanced ping (1.3) to cisco dsl routers and the MySQL server is on the same server as cacti.

BSOD2600 · Post by **BSOD2600** » Mon Jul 20, 2009 5:35 pm

I forget, advanced ping use the script server? maybe php crashes or something during those times. Do you have php error logging enabled?

hapklaar · Post by **hapklaar** » Mon Jul 20, 2009 5:45 pm

It does indeed use the script server. I did not have php error logging enabled, but I do now (php.ini: log_errors = On) .

BSOD2600 · Post by **BSOD2600** » Mon Jul 20, 2009 10:56 pm

I hope you're writing it to file so you can see what gets logged...

Post by **TheWitness** » Thu Jul 23, 2009 8:50 pm

If you are using process leveling, turn it off under Settings->Poller.

TheWitness

Strange SQL error

Strange SQL error

Who is online