مشکل عجیب سرور لینوکس [بایگانی] - انجمن تخصصی وب هاستینگ ایران

توجه ! این یک نسخه آرشیو شده میباشد و در این حالت شما عکسی را مشاهده نمیکنید برای مشاهده کامل متن و عکسها بر روی لینک مقابل کلیک کنید : مشکل عجیب سرور لینوکس

payam-cyrus

May 14th, 2014, 22:24

سلام دوستان

بنده يک مشکل اساسي دارم

کسي ميتونه راهنماييي کنه

حدود سه روز پيش از طريق از طريق اس اس اچ ديتابيس رو بهينه کردم
و کامل خوب و سلامت کار ميکرد

تا ديشب که ارور 504 اينا ميداد دقيق يادم نيست اما زيرش
nginx
نوشته بود
بعد رفتم
nginx
پاک کردم
و دوباره از ايزي آپاچي کامپايل کردم

دو سه ساعت درست بود که

کليه سايتها ارور اساسي پيدا کردن

سي پنل آپديت کردم

ماي اسکيو ال آپديت کردم نشد

مدير سرور ميگه مشکل از رمه و کم دارين
چک کردن رم کم داشتم اما سايت هاي که رم زياد استفاده ميکرد و ساسپند کردم و رم آزاد شد
اما بازم اين مشکل برطرف نشد

يک ساعت يه بار درست ميشه باز دوباره با ارور هاي زير مواجه ميشم :

abaadgaran.com

Warning: Invalid argument supplied for foreach() in /home/abaadgar/public_html/libraries/joomla/database/database/mysql.php on line 383

Warning: Invalid argument supplied for foreach() in /home/abaadgar/public_html/components/com_content/models/articles.php on line 486

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/abaadgar/public_html/libraries/joomla/database/database/mysqli.php on line 263

===============

arm-tourist.com

Warning: Invalid argument supplied for foreach() in /home/armtouri/public_html/libraries/joomla/database/database/mysql.php on line 377

Warning: Invalid argument supplied for foreach() in /home/armtouri/public_html/libraries/joomla/database/database/mysql.php on line 377

Warning: Invalid argument supplied for foreach() in /home/armtouri/public_html/libraries/joomla/database/table.php on line 406

============================

کليه سايت هاي ديگه يه جاشو ميلنگه
صفحه نخست (http://tehrantype.ir/)

يکي ميره داخل مديريت ولي مطالب رو باز نمکينه ارور تي بل ميده
يکي تيبيل هاي ديتابيس رو کامل لود نميکنه و نمياره
يکي يه چي ديگه

>> يک ساعت يبار درست ميشه >>>>

ممنون ميشم راهنمايي کنيد.

nginxweb

May 14th, 2014, 23:11

درود
دوست گرامی یا php سرورتون بدرستی کانفیگ نیست و یا ورژن php سرورتون با اسکریپت سازگاری ندارد
اگر از کدها مطمئن هستید نیاز به بررسی میباشد

payam-cyrus

May 14th, 2014, 23:17

از کدها مطمئن نیستم

ورژن php رو هم دست نزدم که خراب بشه . قبلا مثل ساعت کار میکرد.
ممنون میشم بیشتر راهنمایی کنید

- - - Updated - - -

من فکر میکنم مشکل از این باشه etc/my.cnf

محتویات :
[mysqld]
default-storage-engine=MyISAM
log-slow-queries
open_files_limit=44436
innodb_file_per_table=1
max_connections=500

نظر شما چیه؟

k-h

May 14th, 2014, 23:53

memory_limit سرورتون چقدر هست ؟
مشکل هبه نظرم از php هست

payam-cyrus

May 15th, 2014, 01:56

a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM aazxd_content AS a LEFT JOIN aazxd_categories AS c ON c.id = a.catid LEFT JOIN aazxd_users AS ua ON ua.id = a.created_by LEFT JOIN aazxd_users AS uam ON uam.id = a.modified_by LEFT JOIN aazxd_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN aazxd_categories as parent ON parent.id = c.parent_id LEFT JOIN aazxd_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM aazxd_categories AS cat JOIN aazxd_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN aazxd_content_frontpage AS fp ON fp.content_id = a.id WHERE (contact.published = 1 OR contact.published IS NULL) AND a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-05-14 21:04:13') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-05-14 21:04:13') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, fp.ordering, a.created DESC LIMIT 0, 4 Can't create/write to file '/tmp/#sql_972_1.MYI' (Errcode: 28) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM aazxd_content AS a LEFT JOIN aazxd_categories AS c ON c.id = a.catid LEFT JOIN aazxd_users AS ua ON ua.id = a.created_by LEFT JOIN aazxd_users AS uam ON uam.id = a.modified_by LEFT JOIN aazxd_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN aazxd_categories as parent ON parent.id = c.parent_id LEFT JOIN aazxd_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM aazxd_categories AS cat JOIN aazxd_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN aazxd_content_frontpage AS fp ON fp.content_id = a.id WHERE (contact.published = 1 OR contact.published IS NULL) AND a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-05-14 21:04:13') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-05-14 21:04:13') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, paren

- - - Updated - - -

خطا

Can't create/write to file '/tmp/#sql_972_2.MYI' (Errcode: 28) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM wc9fe_content AS a LEFT JOIN wc9fe_categories AS c ON c.id = a.catid LEFT JOIN wc9fe_users AS ua ON ua.id = a.created_by LEFT JOIN wc9fe_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM wc9fe_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN wc9fe_categories as parent ON parent.id = c.parent_id LEFT JOIN wc9fe_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM wc9fe_categories AS cat JOIN wc9fe_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN wc9fe_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-05-14 21:20:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-05-14 21:20:55') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, fp.ordering, a.created DESC LIMIT 0, 4 Can't create/write to file '/tmp/#sql_972_2.MYI' (Errcode: 28) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM wc9fe_content AS a LEFT JOIN wc9fe_categories AS c ON c.id = a.catid LEFT JOIN wc9fe_users AS ua ON ua.id = a.created_by LEFT JOIN wc9fe_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM wc9fe_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN wc9fe_categories as parent ON parent.id = c.parent_id LEFT JOIN wc9fe_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM wc9fe_categories AS cat JOIN wc9fe_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN wc9fe_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-05-14 21:20:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-05-14 21:20:55') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, fp.ordering, a.created DESC