Fatal error: Allowed memory size ... database.php on line 11

[qiMakur]

I'm using cacti-0.8.6h on SLES9 (SuSE Linux). This is a new system. I've custom complied PHP (see below) to include msyql and sessions and when I try and access index.php I get the following error.

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 42 bytes) in /opt/cacti/www/lib/database.php on line 116

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 64 bytes) in Unknown on line 0

Originally I got the same error with an 8MB error so I upped the memory limits in both php.ini and my.cnf (which doesn't appear to have any effect). Yet I still get the error. Any ideas on what I could try to get cacti running?

Regards, qiMakur

PHP was compiled with the following options:

'./configure' '--prefix=/usr' '--datadir=/usr/share/php' '--mandir=/usr/share/man' '--bindir=/usr/bin' '--libdir=/usr/share' '--includedir=/usr/include' '--sysconfdir=/etc' '--with-_lib=lib' '--with-config-file-path=/etc' '--with-exec-dir=/usr/lib/php/bin' '--disable-debug' '--enable-inline-optimization' '--enable-memory-limit' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sigchild' '--disable-ctype' '--enable-session' '--with-mysql' '--disable-cli' '--without-pear' '--with-openssl' '--with-apxs2=/usr/sbin/apxs2-prefork' 'i586-suse-linux'

[gandalf]

Seems to exceed 32 MB. This is often caused by a huge table poller_output. Please report the size of this table and truncate it if it is huge
Reinhard

[qiMakur]

Yes, it does seem to execeed 32 MB. The important question is 'why?'. The installation is brand-spanking new. The error occurred on the first web access attempt.

My poller_output table seems to be empty.

mysql> select * from poller_output;
Empty set (0.07 sec)

Regards, Kirk

[rony]

More importantly is, how many hosts do you have and data sources.

32 megs is low, but it fine for a new install with the default local host.

[qiMakur]

I don't have any devices configured. I installed the OS, apache, php and cacti and tried to bring up index.php and got the error. I can't even get an interface to configure a host yet.

I have another, older system running cacti with about 2 dozen devices configure on it. It runs fine with 8MB of memory allocated to php. I can't even get this system to display the initial web page with 32MB allocated.

If 32 MB is small, what is a good number?

Regards, Kirk

[qiMakur]

So... I upped the memory_limit value to 64M just for kicks and got the following error.

Fatal error: Maximum execution time of 30 seconds exceeded in /opt/cacti/www/lib/functions.php on line 139

It would seem that the memory_limit value isn't the issue. Something else is causing me grief. The question is 'what?'.

Regards, Kirk

[gandalf]

Seems like some php code gone wild. Fisrt, exceeding 32 MB memory, later exceeding 30 sec runtime ... bad.
Of course it is possible to up the runtime limit (php.ini). But I suppose that won't help. What does phpinfo() and "php -m" show?
Reinhard

[qiMakur]

Assuming I didn't miss anything with the cut-and-paste....

# php -m
[PHP Modules]
openssl
overload
pcre
posix
standard
tokenizer
xml

[Zend Modules]


# php -r 'phpinfo();'

phpinfo()
PHP Version => 4.3.4

System => Linux cacti-sles9 2.6.5-7.191-smp #1 SMP Tue Jun 28 14:58:56 UTC 2005 i686
Build Date => Jul 1 2004 16:43:00
Configure Command => './configure' '--prefix=/usr' '--datadir=/usr/share/php' '--mandir=/usr/share/man' '--bindir=/usr/bin' '--libdir=/usr/share' '--includedir=/usr/include' '--sysconfdir=/etc' '--with-_lib=lib' '--with-config-file-path=/etc' '--with-exec-dir=/usr/lib/php/bin' '--disable-debug' '--enable-inline-optimization' '--enable-memory-limit' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sigchild' '--disable-ctype' '--disable-session' '--without-mysql' '--disable-cli' '--without-pear' '--with-openssl' '--enable-force-cgi-redirect' '--enable-discard-path' '--enable-cli' '--with-pear' 'i586-suse-linux'
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /etc/php.ini
PHP API => 20020918
PHP Extension => 20020429
Zend Extension => 20021010
Debug Build => no
Thread Safety => disabled
Registered PHP Streams => php, http, ftp, https, ftps


This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies


_______________________________________________________________________

Configuration

PHP Core

Directive => Local Value => Master Value
allow_call_time_pass_reference => On => On
allow_url_fopen => On => On
always_populate_raw_post_data => Off => Off
arg_separator.input => & => &
arg_separator.output => & => &
asp_tags => Off => Off
auto_append_file => no value => no value
auto_prepend_file => no value => no value
browscap => no value => no value
default_charset => no value => no value
default_mimetype => text/html => text/html
define_syslog_variables => Off => Off
disable_classes => no value => no value
disable_functions => no value => no value
display_errors => On => On
display_startup_errors => Off => Off
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => On => On
error_append_string => no value => no value
error_log => no value => no value
error_prepend_string => no value => no value
error_reporting => 2039 => 2039
expose_php => On => On
extension_dir => /usr/lib/php/extensions => /usr/lib/php/extensions
file_uploads => On => On
gpc_order => GPC => GPC
highlight.bg => #FFFFFF => #FFFFFF
highlight.comment => #FF8000 => #FF8000
highlight.default => #0000BB => #0000BB
highlight.html => #000000 => #000000
highlight.keyword => #007700 => #007700
highlight.string => #DD0000 => #DD0000
html_errors => Off => On
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => Off => Off
implicit_flush => On => Off
include_path => .:/usr/share/php => .:/usr/share/php
log_errors => Off => Off
log_errors_max_len => 1024 => 1024
magic_quotes_gpc => On => On
magic_quotes_runtime => Off => Off
magic_quotes_sybase => Off => Off
max_execution_time => 0 => 30
max_input_time => 60 => 60
memory_limit => 64M => 64M
open_basedir => no value => no value
output_buffering => no value => no value
output_handler => no value => no value
post_max_size => 8M => 8M
precision => 12 => 12
register_argc_argv => On => On
register_globals => Off => Off
report_memleaks => On => On
safe_mode => Off => Off
safe_mode_exec_dir => no value => no value
safe_mode_gid => Off => Off
safe_mode_include_dir => no value => no value
sendmail_from => no value => no value
sendmail_path => /usr/sbin/sendmail -t -i => /usr/sbin/sendmail -t -i
serialize_precision => 100 => 100
short_open_tag => On => On
SMTP => localhost => localhost
smtp_port => 25 => 25
sql.safe_mode => Off => Off
track_errors => Off => Off
unserialize_callback_func => no value => no value
upload_max_filesize => 2M => 2M
upload_tmp_dir => no value => no value
user_dir => no value => no value
variables_order => EGPCS => EGPCS
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
y2k_compliance => On => On

openssl

OpenSSL support => enabled
OpenSSL Version => OpenSSL 0.9.7d 17 Mar 2004

overload

User-Space Object Overloading Support => enabled

pcre

PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 4.3 21-May-2003

posix

Revision => $Revision: 1.51.2.2 $

standard

Regex Library => Bundled library enabled
Dynamic Library Support => enabled
Path to sendmail => /usr/sbin/sendmail -t -i

Directive => Local Value => Master Value
assert.active => 1 => 1
assert.bail => 0 => 0
assert.callback => no value => no value
assert.quiet_eval => 0 => 0
assert.warning => 1 => 1
auto_detect_line_endings => 0 => 0
default_socket_timeout => 60 => 60
safe_mode_allowed_env_vars => PHP_ => PHP_
safe_mode_protected_env_vars => LD_LIBRARY_PATH => LD_LIBRARY_PATH
url_rewriter.tags => a=href,area=href,frame=src,input=src,form=,fieldset= => a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent => no value => no value

tokenizer

Tokenizer Support => enabled

xml

XML Support => active
XML Namespace Support => active
EXPAT Version => 1.95.6

Additional Modules

Module Name

Environment

Variable => Value
LESSKEY => /etc/lesskey.bin
NNTPSERVER => news
INFODIR => /usr/local/info:/usr/share/info:/usr/info
MANPATH => /usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/gnome/share/man
HOSTNAME => cacti-sles9
GNOME2_PATH => /usr/local:/opt/gnome:/usr
XKEYSYMDB => /usr/X11R6/lib/X11/XKeysymDB
HOST => cacti-sles9
TERM => rxvt
SHELL => /bin/bash
PROFILEREAD => true
HISTSIZE => 1000
SSH_CLIENT => ::ffff:10.101.0.1 23024 22
QTDIR => /usr/lib/qt3
SSH_TTY => /dev/pts/0
USER => root
LS_COLORS => no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
XNLSPATH => /usr/X11R6/lib/X11/nls
HOSTTYPE => i386
PAGER => less
MINICOM => -c on
MAIL => /var/mail/root
PATH => /sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin
CPU => i686
INPUTRC => /etc/inputrc
PWD => /root
TEXINPUTS => :/root/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
SHLVL => 1
HOME => /root
LESS_ADVANCED_PREPROCESSOR => no
OSTYPE => linux
LS_OPTIONS => -a -N --color=tty -T 0
no_proxy => localhost
WINDOWMANAGER => /usr/X11R6/bin/kde
LESS => -M -I
MACHTYPE => i686-suse-linux
LOGNAME => root
LC_CTYPE => en_US.UTF-8
SSH_CONNECTION => ::ffff:10.101.0.1 23024 ::ffff:10.101.145.193 22
PKG_CONFIG_PATH => /opt/gnome/lib/pkgconfig
LESSOPEN => lessopen.sh %s
ACLOCAL_PATH => /opt/gnome/share/aclocal
INFOPATH => /usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
LESSCLOSE => lessclose.sh %s %s
COLORTERM => 1
_ => /usr/bin/php

PHP Variables

Variable => Value
_SERVER["LESSKEY"] => /etc/lesskey.bin
_SERVER["NNTPSERVER"] => news
_SERVER["INFODIR"] => /usr/local/info:/usr/share/info:/usr/info
_SERVER["MANPATH"] => /usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/gnome/share/man
_SERVER["HOSTNAME"] => cacti-sles9
_SERVER["GNOME2_PATH"] => /usr/local:/opt/gnome:/usr
_SERVER["XKEYSYMDB"] => /usr/X11R6/lib/X11/XKeysymDB
_SERVER["HOST"] => cacti-sles9
_SERVER["TERM"] => rxvt
_SERVER["SHELL"] => /bin/bash
_SERVER["PROFILEREAD"] => true
_SERVER["HISTSIZE"] => 1000
_SERVER["SSH_CLIENT"] => ::ffff:10.101.0.1 23024 22
_SERVER["QTDIR"] => /usr/lib/qt3
_SERVER["SSH_TTY"] => /dev/pts/0
_SERVER["USER"] => root
_SERVER["LS_COLORS"] => no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
_SERVER["XNLSPATH"] => /usr/X11R6/lib/X11/nls
_SERVER["HOSTTYPE"] => i386
_SERVER["PAGER"] => less
_SERVER["MINICOM"] => -c on
_SERVER["MAIL"] => /var/mail/root
_SERVER["PATH"] => /sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin
_SERVER["CPU"] => i686
_SERVER["INPUTRC"] => /etc/inputrc
_SERVER["PWD"] => /root
_SERVER["TEXINPUTS"] => :/root/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
_SERVER["SHLVL"] => 1
_SERVER["HOME"] => /root
_SERVER["LESS_ADVANCED_PREPROCESSOR"] => no
_SERVER["OSTYPE"] => linux
_SERVER["LS_OPTIONS"] => -a -N --color=tty -T 0
_SERVER["no_proxy"] => localhost
_SERVER["WINDOWMANAGER"] => /usr/X11R6/bin/kde
_SERVER["LESS"] => -M -I
_SERVER["MACHTYPE"] => i686-suse-linux
_SERVER["LOGNAME"] => root
_SERVER["LC_CTYPE"] => en_US.UTF-8
_SERVER["SSH_CONNECTION"] => ::ffff:10.101.0.1 23024 ::ffff:10.101.145.193 22
_SERVER["PKG_CONFIG_PATH"] => /opt/gnome/lib/pkgconfig
_SERVER["LESSOPEN"] => lessopen.sh %s
_SERVER["ACLOCAL_PATH"] => /opt/gnome/share/aclocal
_SERVER["INFOPATH"] => /usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
_SERVER["LESSCLOSE"] => lessclose.sh %s %s
_SERVER["COLORTERM"] => 1
_SERVER["_"] => /usr/bin/php
_SERVER["PHP_SELF"] => -
_SERVER["SCRIPT_NAME"] => -
_SERVER["SCRIPT_FILENAME"] =>
_SERVER["PATH_TRANSLATED"] =>
_SERVER["DOCUMENT_ROOT"] =>
_SERVER["argv"] => Array
(
[0] => -
)

_SERVER["argc"] => 1
_ENV["LESSKEY"] => /etc/lesskey.bin
_ENV["NNTPSERVER"] => news
_ENV["INFODIR"] => /usr/local/info:/usr/share/info:/usr/info
_ENV["MANPATH"] => /usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/gnome/share/man
_ENV["HOSTNAME"] => cacti-sles9
_ENV["GNOME2_PATH"] => /usr/local:/opt/gnome:/usr
_ENV["XKEYSYMDB"] => /usr/X11R6/lib/X11/XKeysymDB
_ENV["HOST"] => cacti-sles9
_ENV["TERM"] => rxvt
_ENV["SHELL"] => /bin/bash
_ENV["PROFILEREAD"] => true
_ENV["HISTSIZE"] => 1000
_ENV["SSH_CLIENT"] => ::ffff:10.101.0.1 23024 22
_ENV["QTDIR"] => /usr/lib/qt3
_ENV["SSH_TTY"] => /dev/pts/0
_ENV["USER"] => root
_ENV["LS_COLORS"] => no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
_ENV["XNLSPATH"] => /usr/X11R6/lib/X11/nls
_ENV["HOSTTYPE"] => i386
_ENV["PAGER"] => less
_ENV["MINICOM"] => -c on
_ENV["MAIL"] => /var/mail/root
_ENV["PATH"] => /sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin
_ENV["CPU"] => i686
_ENV["INPUTRC"] => /etc/inputrc
_ENV["PWD"] => /root
_ENV["TEXINPUTS"] => :/root/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
_ENV["SHLVL"] => 1
_ENV["HOME"] => /root
_ENV["LESS_ADVANCED_PREPROCESSOR"] => no
_ENV["OSTYPE"] => linux
_ENV["LS_OPTIONS"] => -a -N --color=tty -T 0
_ENV["no_proxy"] => localhost
_ENV["WINDOWMANAGER"] => /usr/X11R6/bin/kde
_ENV["LESS"] => -M -I
_ENV["MACHTYPE"] => i686-suse-linux
_ENV["LOGNAME"] => root
_ENV["LC_CTYPE"] => en_US.UTF-8
_ENV["SSH_CONNECTION"] => ::ffff:10.101.0.1 23024 ::ffff:10.101.145.193 22
_ENV["PKG_CONFIG_PATH"] => /opt/gnome/lib/pkgconfig
_ENV["LESSOPEN"] => lessopen.sh %s
_ENV["ACLOCAL_PATH"] => /opt/gnome/share/aclocal
_ENV["INFOPATH"] => /usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
_ENV["LESSCLOSE"] => lessclose.sh %s %s
_ENV["COLORTERM"] => 1
_ENV["_"] => /usr/bin/php

PHP License
This program is free software; you can redistribute it and/or modify
it under the terms of the PHP License as published by the PHP Group
and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any
questions about PHP licensing, please contact license@php.net.

[gandalf]

I do not find session and mysql support from your listings. Both are needed for cacti
Reinhard

[qiMakur]

Oops, I gave the output from the cli php which doesn't have session/mysql support compiled in. The web version does have both included. I don't have access to that system right now but can repost the output later this evening if needed.

[gandalf]

So please double check that cacti's path settings do refer to the correct php version!
Reinhard

[qiMakur]

Okay, attached is the html output from a phpinfo() from the web server. I don't think the problem is with the sessions/mysql being enabled. I didn't have either enabled and I got a different error at first which clearly indicated that sessions wasn't available. This error, the one about not being able to allocate memory, is completely different. The cacti scripts are running and running and running until they run out of memory.

As for checking the path settings... where exactly do I do that? There's a path_php_binary something in the include/config_settings.php file but since I still haven't even been able to bring up the first let's-get-started page I haven't been able to set it. Apache seems to find the correct php executable. Isn't that enough? Is there somewhere else I should be checking?

Is there something I can run/do to isolate the loop that's trying to allocate more memory?

[gandalf]

Apache seems to find the correct php executable. Isn't that enough? Is there somewhere else I should be checking?

If there are more than one php executables, this is not sure. But sorry, I can't help further on this
Reinhard

[twong]

I had the same exact problem with my freebsd 6.1 with mysql 5.0

The command I ran to inject the initial db didn't work right for some reason and the database was empty.

I ran this: mysql -p cacti < /usr/local/share/cacti/cacti.sql

and then checked the database and tables are now there. I installation page now works via the web url.

Hope that helps
twong

[alfredhdahl]

I found the problem in my setup.
Avter havnig upgraded, the "wwwrun php /usr/share/cacti/poller.php" was found in both /etc/crontab and /etc/cron.d/cacti.

Eventually the ran on the same time, and I had to remove one, either from crontab or cacti, truncate poller_output - and then it worked again.