Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!
Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.
Strony: 1
/var/log/apache2/error.log w tydzien przybrał na wadze 1.1gb
jako ze /var/ ma 2gb musze cos z tym zrobic bo co chwile wywala mi mysql'a ;/
/var/log/apache2/error.log:
[Mon Apr 14 22:57:01 2008] [notice] Apache/2.2.3 (Debian) PHP/4.4.4-8+etch4 mod_ssl/2.2.3 OpenSSL/0.9.8c configured -- resuming normal operations [Mon Apr 14 22:57:02 2008] [notice] caught SIGTERM, shutting down PHP Warning: Function registration failed - duplicate name - gd_info in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagearc in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imageellipse in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagechar in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecharup in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorat in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorallocate in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepalettecopy in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatefromstring in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorclosest in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorclosesthwb in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolordeallocate in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorresolve in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorexact in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorset in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolortransparent in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorstotal in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorsforindex in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecopy in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecopymerge in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecopymergegray in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecopyresized in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreate in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatetruecolor in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imageistruecolor in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagetruecolortopalette in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagesetthickness in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefilledarc in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefilledellipse in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagealphablending in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagesavealpha in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorallocatealpha in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorresolvealpha in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorclosestalpha in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecolorexactalpha in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecopyresampled in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagesettile in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagesetbrush in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagesetstyle in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatefrompng in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatefromgif in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatefromjpeg in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatefromwbmp in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatefromgd in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatefromgd2 in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagecreatefromgd2part in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepng in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagegif in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagejpeg in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagewbmp in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagegd in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagegd2 in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagedestroy in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagegammacorrect in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefill in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefilledpolygon in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefilledrectangle in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefilltoborder in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefontwidth in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefontheight in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imageinterlace in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imageline in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imageloadfont in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepolygon in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagerectangle in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagesetpixel in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagestring in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagestringup in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagesx in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagesy in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagedashedline in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagettfbbox in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagettftext in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imageftbbox in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagefttext in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepsloadfont in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepsfreefont in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepsencodefont in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepsextendfont in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepsslantfont in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepstext in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagepsbbox in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - imagetypes in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - jpeg2wbmp in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - png2wbmp in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - image2wbmp in Unknown on line 0 PHP Warning: gd: Unable to register functions, unable to load in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_connect in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_pconnect in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_close in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_select_db in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_query in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_unbuffered_query in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_db_query in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_list_dbs in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_list_tables in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_list_fields in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_list_processes in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_error in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_errno in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_affected_rows in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_insert_id in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_result in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_num_rows in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_num_fields in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fetch_row in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fetch_array in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fetch_assoc in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fetch_object in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_data_seek in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fetch_lengths in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fetch_field in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_field_seek in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_free_result in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_field_name in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_field_table in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_field_len in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_field_type in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_field_flags in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_escape_string in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_real_escape_string in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_stat in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_thread_id in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_client_encoding in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_ping in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_get_client_info in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_get_host_info in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_get_proto_info in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_get_server_info in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_info in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fieldname in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fieldtable in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fieldlen in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fieldtype in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_fieldflags in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_selectdb in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_freeresult in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_numfields in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_numrows in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_listdbs in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_listtables in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_listfields in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_db_name in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_dbname in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_tablename in Unknown on line 0 PHP Warning: Function registration failed - duplicate name - mysql_table_name in Unknown on line 0 PHP Warning: mysql: Unable to register functions, unable to load in Unknown on line 0 [Mon Apr 14 22:57:04 2008] [notice] Apache/2.2.3 (Debian) PHP/4.4.4-8+etch4 mod_ssl/2.2.3 OpenSSL/0.9.8c configured -- resuming normal operations
przyznam, ze ostatnio posadzilem mysql'a na lopatki, skonczylo sie na przeinstalowaniu mysql i php,
moze o czyms zapomnialem ?
Offline
żeby opanować ekspansję logów zainstaluj [url=http://packages.debian.org/logrotate]logrotate[/url]
natomiast co zrobić, żeby php/mysql się nie krzaczył — nie mam zielonego pojęcia (abstrahujac od tego, że to temat od sieci)
Ostatnio edytowany przez azhag (2008-04-14 23:46:17)
Offline
Nie no, dział jest jak najbardziej na miejscu "Podstawowa konfiguracja" i tegoż właśnie błąd dotyczy. Co więcej problem został określony w logach :P. Najprawdopodobniej ładujesz dwa razy bibliotekę gd - poszukaj sobie w php.ini linijki extension=gd.so i usuń. Mogło podejść pod autoload jeśli było instalowane z paczki i ztąd problem.
Offline
[quote=larret]Nie no, dział jest jak najbardziej na miejscu "Podstawowa konfiguracja" i tegoż właśnie błąd dotyczy.[/quote]
O ile zapanowanie nad rozmiarem logów można zaliczyć do 'podstawówki" (i tylko dlatego temat nie został brutalnie przeniesiony), o tyle konfiguracja usług sieciowych (w tym wypadku mysql i php) to już do Sieci należy.
Idąc Twoim tokiem myślenia 99% należałoby do tego wątku. Bo "podstawowa konfiguracja" najróżniejszych programów, środowisk graficznych, sprzętów, gier czy nawet kernela podczas kompilacji. ;)
Offline
Fakt. Nie bić! :P
Ostatnio edytowany przez larret (2008-04-15 10:44:45)
Offline
Strony: 1
Time (s) | Query |
---|---|
0.00019 | SET CHARSET latin2 |
0.00011 | SET NAMES latin2 |
0.00157 | SELECT u.*, g.*, o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='3.135.205.26' WHERE u.id=1 |
0.00149 | REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '3.135.205.26', 1732576562) |
0.00071 | SELECT * FROM punbb_online WHERE logged<1732576262 |
0.00087 | SELECT topic_id FROM punbb_posts WHERE id=88699 |
0.00060 | SELECT id FROM punbb_posts WHERE topic_id=11200 ORDER BY posted |
0.00100 | SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=11200 AND t.moved_to IS NULL |
0.00007 | SELECT search_for, replace_with FROM punbb_censoring |
0.00140 | SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=11200 ORDER BY p.id LIMIT 0,25 |
0.00091 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=11200 |
Total query time: 0.00892 s |