PHP recache problems

[spex]

I'm using the latest cacti release on a windows 2003 server.
Apache 2.2.21 and PHP is at 5.2.17
Everything runs fine with the exception of one node, that cacti thinks it needs to be recached:

The host shows the following error in cacti.log

....
10/25/2011 09:15:01 AM - CMDPHP: Poller[0] Host[157] RECACHE: Processing 3 items in the auto reindex cache for 'SZENT098'.
10/25/2011 09:15:01 AM - CMDPHP: Poller[0] Host[157] RECACHE DQ[1] OID: .1.3.6.1.2.1.2.1.0
10/25/2011 09:15:01 AM - CMDPHP: Poller[0] Host[157] RECACHE DQ[1] OID: .1.3.6.1.2.1.2.1.0, output: 41
10/25/2011 09:15:01 AM - CMDPHP: Poller[0] Host[157] RECACHE DQ[8] Script Server: D:wwwcactiscriptsss_host_disk.php ss_host_disk SZENT098 157 1:1612:50:ADAC:::::: num_indexes
10/25/2011 09:15:01 AM - PHPSVR: Poller[0] DEBUG: PID[3536] CTR[0] INC: 'D:wwwcactiscriptsss_host_disk.php' FUNC: 'ss_host_disk' PARMS: 'SZENT098 157 1:1612:50:ADAC:::::: num_indexes'
10/25/2011 09:15:01 AM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist
....

Doing a verbose query in the web gui works for num_indexes:
+ Running data query [8].
+ Found type = '6' [Script Query - Script Server].
+ Found data query XML file at 'D:/www/cacti/resource/script_server/host_disk.xml'
+ XML file parsed ok.
+ Executing script for num of indexes '"c:\php\php.exe" -q D:\www\cacti\scripts\ss_host_disk.php SZENT098 157 1:1612:50:ADAC:::::: num_indexes'
+ Found number of indexes: 6
....

Any ideas?

[gandalf]

10/25/2011 09:15:01 AM - CMDPHP: Poller[0] Host[157] RECACHE DQ[8] Script Server: D:wwwcactiscriptsss_host_disk.php ss_host_disk SZENT098 157 1:1612:50:ADAC:::::: num_indexes

This script name indeed looks weird. All backslashes are removed. Is this the only failing one? Or do you use the same script on a different host?
R.

[TheWitness]

Make sure that you are using forward slashes for everything and not spaces in paths. To me it looks like you are running a customized install. Did you obtain this from someone or roll your own.

[spex]

10/25/2011 09:15:01 AM - CMDPHP: Poller[0] Host[157] RECACHE DQ[8] Script Server: D:wwwcactiscriptsss_host_disk.php ss_host_disk SZENT098 157 1:1612:50:ADAC:::::: num_indexes

This script name indeed looks weird. All backslashes are removed. Is this the only failing one? Or do you use the same script on a different host?
R.

This script runs ok for 3 hosts within my cacti server aslong it is not used for recaching.

[TheWitness]

So, are you saying recache is the only thing failing? If so, please dump your database, and PM to me.

[spex]

So, are you saying recache is the only thing failing? If so, please dump your database, and PM to me.

Within the cacti database the string sss_host_disk.php only occurs in table poller_reindex.
(Btw the problem also occurs for sss_host_cpu.php)

LOCK TABLES `poller_reindex` WRITE;
/*!40000 ALTER TABLE `poller_reindex` DISABLE KEYS */;
INSERT INTO `poller_reindex` VALUES (2,1,0,1,'<','26584998','.1.3.6.1.2.1.1.3.0'),(2,8,0,1,'<','26584998','.1.3.6.1.2.1.1.3.0'),(2,9,0,1,'<','26584998','.1.3.6.1.2.1.1.3.0'),(3,1,0,1,'<','26615785','.1.3.6.1.2.1.1.3.0'),(3,8,0,1,'<','26615785','.1.3.6.1.2.1.1.3.0'),(3,9,0,1,'<','26615787','.1.3.6.1.2.1.1.3.0'),(4,1,0,1,'<','26645020','.1.3.6.1.2.1.1.3.0'),(4,8,0,1,'<','26645020','.1.3.6.1.2.1.1.3.0'),(4,9,0,1,'<','26645020','.1.3.6.1.2.1.1.3.0'),(5,1,0,1,'<','26675032','.1.3.6.1.2.1.1.3.0'),(5,8,0,1,'<','26675034','.1.3.6.1.2.1.1.3.0'),(5,9,0,1,'<','26675034','.1.3.6.1.2.1.1.3.0'),(6,1,0,1,'<','26668535','.1.3.6.1.2.1.1.3.0'),(6,8,0,1,'<','26668782','.1.3.6.1.2.1.1.3.0'),(6,9,0,1,'<','26668907','.1.3.6.1.2.1.1.3.0'),(7,1,0,1,'<','26855046','.1.3.6.1.2.1.1.3.0'),(7,8,0,1,'<','26855048','.1.3.6.1.2.1.1.3.0'),(7,9,0,1,'<','26855048','.1.3.6.1.2.1.1.3.0'),(9,1,0,1,'<','28707783','.1.3.6.1.2.1.1.3.0'),(9,8,0,1,'<','28707783','.1.3.6.1.2.1.1.3.0'),(9,9,0,1,'<','28707784','.1.3.6.1.2.1.1.3.0'),(15,1,0,1,'<','','.1.3.6.1.2.1.1.3.0'),(15,6,0,1,'<','','.1.3.6.1.2.1.1.3.0'),(15,2,0,1,'<','','.1.3.6.1.2.1.1.3.0'),(17,1,0,1,'<','261008560','.1.3.6.1.2.1.1.3.0'),(17,10,0,1,'<','261022384','.1.3.6.1.2.1.1.3.0'),(126,8,0,1,'<','10226885','.1.3.6.1.2.1.1.3.0'),(126,9,0,1,'<','10226885','.1.3.6.1.2.1.1.3.0'),(164,1,0,1,'=','2','.1.3.6.1.2.1.2.1.0'),(155,1,0,1,'=','41','.1.3.6.1.2.1.2.1.0'),(157,1,0,1,'=','41','.1.3.6.1.2.1.2.1.0'),(158,1,0,1,'=','41','.1.3.6.1.2.1.2.1.0'),(126,1,0,1,'=','40','.1.3.6.1.2.1.2.1.0'),(159,27,0,1,'<','513262351','.1.3.6.1.2.1.1.3.0'),(160,27,0,1,'<','514248126','.1.3.6.1.2.1.1.3.0'),(165,1,0,1,'=','37','.1.3.6.1.2.1.2.1.0'),(161,27,0,1,'<','514312739','.1.3.6.1.2.1.1.3.0'),(165,14,0,1,'=','32','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(118,14,0,1,'=','80','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(135,14,0,1,'=','40','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(164,8,2,1,'=','8','D:wwwcactiscriptsss_host_disk.php ss_host_disk SZENT121 164 1:1612:50:xxxx:::::: num_indexes'),(119,14,0,1,'=','80','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(136,14,0,1,'=','40','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(164,9,2,1,'=','2','D:wwwcactiscriptsss_host_cpu.php ss_host_cpu SZENT121 164 1:1612:50:xxxx:::::: num_indexes'),(120,14,0,1,'=','24','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(13,1,0,1,'<','42792374','.1.3.6.1.2.1.1.3.0'),(13,8,0,1,'<','42792374','.1.3.6.1.2.1.1.3.0'),(13,9,0,1,'<','42792374','.1.3.6.1.2.1.1.3.0'),(14,1,0,1,'<','361703600','.1.3.6.1.2.1.1.3.0'),(29,1,0,1,'<','643805200','.1.3.6.1.2.1.1.3.0'),(29,11,0,1,'<','643805200','.1.3.6.1.2.1.1.3.0'),(30,1,0,1,'<','699862700','.1.3.6.1.2.1.1.3.0'),(30,11,0,1,'<','699862700','.1.3.6.1.2.1.1.3.0'),(48,1,0,1,'<','6011803','.1.3.6.1.2.1.1.3.0'),(55,1,0,1,'<','59960161','.1.3.6.1.2.1.1.3.0'),(55,8,0,1,'<','59960161','.1.3.6.1.2.1.1.3.0'),(56,1,0,1,'<','59960595','.1.3.6.1.2.1.1.3.0'),(57,1,0,1,'<','59802823','.1.3.6.1.2.1.1.3.0'),(62,1,0,1,'<','44432130','.1.3.6.1.2.1.1.3.0'),(62,8,0,1,'<','44432130','.1.3.6.1.2.1.1.3.0'),(79,1,0,1,'<','42767070','.1.3.6.1.2.1.1.3.0'),(79,8,0,1,'<','42767072','.1.3.6.1.2.1.1.3.0'),(80,1,0,1,'<','60171983','.1.3.6.1.2.1.1.3.0'),(80,8,0,1,'<','60171984','.1.3.6.1.2.1.1.3.0'),(80,9,0,1,'<','60171984','.1.3.6.1.2.1.1.3.0'),(121,14,0,1,'=','24','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(126,21,10,1,'=','6','.1.3.6.1.4.1.232.19.2.10.2.1.1'),(134,19,10,1,'=','5','.1.3.6.1.4.1.232.19.2.3.2.1.1'),(134,20,10,1,'=','3','.1.3.6.1.4.1.232.19.2.7.2.1.1'),(134,21,10,1,'=','3','.1.3.6.1.4.1.232.19.2.10.2.1.1'),(134,22,10,1,'=','1','.1.3.6.1.4.1.232.3.2.7.1.1.1'),(134,23,10,1,'=','2','.1.3.6.1.4.1.232.3.2.8.1.1.1'),(134,24,10,1,'=','5','.1.3.6.1.4.1.232.6.2.6.8.1.2'),(134,25,10,1,'=','3','.1.3.6.1.4.1.232.3.2.5.1.1.1'),(151,14,0,1,'=','80','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(152,14,0,1,'=','80','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(153,26,1,1,'=','0','perl D:wwwcactiscriptssvcsvc_pooldf_indexed.pl vsvc02 num_indexes'),(162,14,0,1,'=','80','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(155,8,2,1,'=','6','D:wwwcactiscriptsss_host_disk.php ss_host_disk SZENT097 155 1:1612:150:xxxx:::::: num_indexes'),(155,9,2,1,'=','24','D:wwwcactiscriptsss_host_cpu.php ss_host_cpu SZENT097 155 1:1612:150:xxxx:::::: num_indexes'),(157,8,2,1,'=','U','D:wwwcactiscriptsss_host_disk.php ss_host_disk SZENT098 157 1:1612:50:xxxx:::::: num_indexes'),(157,9,2,1,'=','U','D:wwwcactiscriptsss_host_cpu.php ss_host_cpu SZENT098 157 1:1612:50:xxxx:::::: num_indexes'),(158,8,2,1,'=','6','D:wwwcactiscriptsss_host_disk.php ss_host_disk szent099 158 1:1612:50:xxxx:::::: num_indexes'),(158,9,2,1,'=','24','D:wwwcactiscriptsss_host_cpu.php ss_host_cpu szent099 158 1:1612:50:xxxx:::::: num_indexes'),(162,1,0,1,'=','3','.1.3.6.1.2.1.2.1.0'),(163,1,0,1,'=','86','.1.3.6.1.2.1.2.1.0'),(163,14,0,1,'=','80','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0'),(166,1,0,1,'=','37','.1.3.6.1.2.1.2.1.0'),(166,14,0,1,'=','32','.1.3.6.1.4.1.1588.2.1.1.1.6.1.0');
/*!40000 ALTER TABLE `poller_reindex` ENABLE KEYS */;
UNLOCK TABLES;

[TheWitness]

Ok, that's good enough. Please open a bug at http://bugs.cacti.net and copy the contents of the dump to the ticket. Please assign it to Gandalf.

TheWitness

[gandalf]

Larry, you are assuming that there's too much of cacti_escapeshell_something being used on that verz string, are you?
R.

[TheWitness]

That's correct. He is first using a back slash. And I believe that the back slash is being stripped. If not, he is using a forward slash, and that is also being stripped. The forward slash should be a permitted character. I'm not too certain about the back slash though.

[BSOD2600]

spex:
Was this problem ever resolved?
Was this a fresh 0.8.7h install or an upgrade?
Up for trying the latest 0.8.7 SVN release to see if this issue is still present?

[spex]

I'm still having this problem.
It was an upgrade installation.
Not sure if I can try latest svn release. Will have a look at it.
Meanwhile I have similar problems as described in "Multiple SQL Row Failed errors and missing data from graphs"
http://forums.cacti.net/viewtopic.php?f=21&t=45123

[BSOD2600]

Yea, there are several major issues with the 0.8.7h release. They've been fixed in the SVN.

For now, it's probably best if you rolled back to 0.8.7g or downloaded the latest code from the SVN (TortoiseSVN client makes this easy).