CLAPI Export - PHP Fatal error: Uncaught exception 'PDOException'

[rgerbranda]

I just installed version 1.8.1 of CLAPI. During export I get the following error.

[root@monitoring ~]# centreon -u my.name -pxxxx -e {OBJECT_TYPE};{COMMAND};{PARAMETERS} INSTANCE;ADD;Central;127.0.0.1;22;CENGINE INSTANCE;setparam;Central;localhost;1 INSTANCE;setparam;Central;is_default;0 INSTANCE;setparam;Central;ns_activate;1 INSTANCE;setparam;Central;ns_status;0 INSTANCE;setparam;Central;init_script;/etc/init.d/centengine INSTANCE;setparam;Central;nagios_bin;/usr/sbin/centengine INSTANCE;setparam;Central;nagiostats_bin;/usr/sbin/centenginestats INSTANCE;setparam;Central;nagios_perfdata;/var/log/centreon-engine/service-perfdata INSTANCE;setparam;Central;centreonbroker_cfg_path;/etc/centreon-broker INSTANCE;setparam;Central;centreonbroker_module_path;/usr/share/centreon/lib/centreon-broker INSTANCE;setparam;Central;init_script_centreontrapd;/etc/init.d/centreontrapd INSTANCE;setparam;Central;snmp_trapd_path_conf;/etc/snmp/centreon_traps/ TP;ADD;24x7;24_Hours_A_Day,_7_Days_A_Week TP;setparam;24x7;tp_sunday;00:00-24:00 TP;setparam;24x7;tp_monday;00:00-24:00 TP;setparam;24x7;tp_tuesday;00:00-24:00 TP;setparam;24x7;tp_wednesday;00:00-24:00 TP;setparam;24x7;tp_thursday;00:00-24:00 TP;setparam;24x7;tp_friday;00:00-24:00 TP;setparam;24x7;tp_saturday;00:00-24:00 TP;ADD;none;No Time Is A Good Time TP;ADD;nonworkhours;Non-Work Hours TP;setparam;nonworkhours;tp_sunday;00:00-24:00 TP;setparam;nonworkhours;tp_monday;00:00-09:00,17:00-24:00 TP;setparam;nonworkhours;tp_tuesday;00:00-09:00,17:00-24:00 TP;setparam;nonworkhours;tp_wednesday;00:00-09:00,17:00-24:00 TP;setparam;nonworkhours;tp_thursday;00:00-09:00,17:00-24:00 TP;setparam;nonworkhours;tp_friday;00:00-09:00,17:00-24:00 TP;setparam;nonworkhours;tp_saturday;00:00-24:00 TP;ADD;workhours;Work hours TP;setparam;workhours;tp_monday;09:00-18:00 TP;setparam;workhours;tp_tuesday;14:35-18:00 TP;setparam;workhours;tp_wednesday;09:00-18:00 TP;setparam;workhours;tp_thursday;09:00-18:00 TP;setparam;workhours;tp_friday;09:00-18:00 DEP;ADD;nrpe-services_ON_nrpe-running;nrpe-services depend on nrpe-running;SG;nrpe-running DEP;SETPARAM;nrpe-services_ON_nrpe-running;inherits_parent;1 DEP;SETPARAM;nrpe-services_ON_nrpe-running;execution_failure_criteria; DEP;SETPARAM;nrpe-services_ON_nrpe-running;notification_failure_criteria;u,c DEP;SETPARAM;nrpe-services_ON_nrpe-running;dep_comment;Voorkomt dat meldingen worden verstuurd wanneer nrpe-agent niet draait. PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2050 ' in /usr/share/centreon/www/modules/centreon-clapi/core/lib/Zend/Db/Statement/Pdo.php:290 Stack trace:

0 /usr/share/centreon/www/modules/centreon-clapi/core/lib/Zend/Db/Statement/Pdo.php(290): PDOStatement->fetchAll(2)

1 /usr/share/centreon/www/modules/centreon-clapi/core/class/centreonDependency.class.php(1404): Zend_Db_Statement_Pdo->fetchAll()

2 /usr/share/centreon/www/modules/centreon-clapi/core/class/centreonDependency.class.php(1055): CentreonDependency->exportServicegroupDep()

3 /usr/share/centreon/www/modules/centreon-clapi/core/class/centreonAPI.class.php(719): CentreonDependency->export()

4 /usr/share/centreon/www/modules/centreon-clapi/core/centreon(167): CentreonAPI->export()

5 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 2050 ' in /usr/share/centreon/www/modules/centreon-clapi/core/lib/Zend/Db/Statement/Pdo.php:294 Stack trace:

0 /usr/share/centreon/ww in /usr/share/centreon/www/modules/centreon-clapi/core/lib/Zend/Db/Statement/Pdo.php on line 294

[maksimatveev]

@querwin Hi! Similarly: [root@rnd-oms-centreon ~]# centreon -u admin -p xyz -e > clapi-export.txt PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 108 bytes) in /usr/share/centreon/lib/Zend/Db/Statement/Pdo.php on line 290

[root@rnd-oms-centreon ~]# centreon -V Centreon version 2.7.7 Centreon CLAPI version undefined

[sgaudart]

I increase the setting "memory_limit" in php.ini (128M => 256M), it solved the issue (like maksimatveev). But is it the right way ?

[maksimatveev]

@sgaudart Thanks, I will try ;)

[maksimatveev]

@sgaudart Thanks It works =)

[jronzon]

Centreon version 2.8.22 --> It's same error. Change memory_limit to 256M --> It works.