Hi all,

I need your help, I received an error after I upgraded to the most recent IPB version, I am not sure where to start.

I checked the free space in CentOS and got this,

root@server [~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/vda1 30G 8.2G 20G 29% /

tmpfs 499M 0 499M 0% /dev/shm

/usr/tmpDSK 1.1G 315M 676M 32% /tmp

Any advice? Now I cant even login admin :/

Error: 1 - Can't create/write to file '/tmp/#sql_54a_0.MAI' (Errcode: 28 "No space left on device") IP Address: 68.180.228.43 - /topic/1477-hello-from-italy/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM ipb_core_tags tg LEFT JOIN ipb_topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN ipb_members m ON (last_poster_id=m.member_id) LEFT JOIN ipb_profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN ipb_core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=1477 AND tg.tag_text IN ('hello','italy') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM ipb_core_tags_perms WHERE ( ( FIND_IN_SET(2,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/classes/tags/abstract.php | [classes_tags_search_sql].run | 868 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/forums/extensions/tags/topics.php | [classes_tag_abstract].search | 265 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/forums/modules_public/forums/topics.php | [tags_forums_topics].search | 1263 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/forums/modules_public/forums/topics.php | [public_forums_forums_topics]._getSameTaggedData | 303 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [public_forums_forums_topics].doExecute | 306 |

You've run out of /tmp space on disk.

Thanks Aiwa for your reply, but how do you fix it?

http://www.ivankuznetsov.com/2010/02/no-space-left-on-device-running-out-of-inodes.html

Thanks aiwa,

So this is what I found

root@server [~]# df -i

Filesystem Inodes IUsed IFree IUse% Mounted on

/dev/vda1 1966080 205199 1760881 11% /

tmpfs 127550 1 127549 1% /dev/shm

/usr/tmpDSK 67824 67824 0 100% /tmp

root@server [~]# for i in /*; do echo $i; find $i |wc -l; done

/backup

1

/bin

101

/boot

46

/dev

536

/etc

1606

/home

65792

/lib

10846

/lib64

411

/lost+found

1

/media

1

/mnt

1

/opt

923

/proc

56691

/razor-agent.log

1

/root

313

/sbin

245

/scripts

1

/selinux

1

/srv

1

/sys

6494

/tmp

67810

/usr

120858

/var

77159

root@server [~]# for i in /home/*; do echo $i; find $i |wc -l; done

/home/cPanelInstall

1

/home/cpeasyapache

22417

/home/mod-pagespeed-stable_current_x86_64.rpm

1

/home/tchfonum

6945

/home/techforum

6944

/home/thecpforum

25070

/home/virtfs

3

root@server [~]# cd /home/cpeasyapache

root@server [/home/cpeasyapache]# ls

./ ../ src/

root@server [/home/cpeasyapache]#

When I look into the culprit, which appears to be easypache, but how do I create more space? Like, I dont know what files to delete? Any advice?

Thanks,

Jake

Filesystem      Inodes  IUsed   IFree IUse% Mounted on
/usr/tmpDSK      67824  67824       0  100% /tmp

That's the culprit...

Thanks for that aiwa,

So how do I clear it out? What could have caused an issue like that?

First... I would try simply rebooting the server...

Otherwise, you might be able to manually fire tmpwatch.

/etc/cron.daily/

Do NOT manually delete files in /tmp...

I actually ended up increasing the size of the file, so that fixed that issue, however, I cannot get into admin cp now :sad: I found the directions here, http://cpanelwhm.org/ssh/increase-tmp-partition-size/144

It recommends not to run cronjobs? Does it really matter?

What error are you getting logging into your ACP?

After I get passed the ACP login screen. I receive this error,

500 Internal Server Error

When i attempt to run the upgrade @ domainname.com/admin/upgrade,

mySQL query error: ALTER TABLE ipb_upgrade_history ADD upgrade_app varchar(32) NOT NULL default 'core'

SQL error: Duplicate column name 'upgrade_app'

SQL error code: 1060

Date: Thursday 16th October 2014 11:28:32 PM

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Date: Thu, 16 Oct 2014 23:28:32 +0000

Error: 1060 - Duplicate column name 'upgrade_app'

IP Address: 50.25.6.170 - /admin/upgrade/

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

mySQL query error: ALTER TABLE ipb_upgrade_history ADD upgrade_app varchar(32) NOT NULL default 'core'

.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.

| File | Function | Line No. |

|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|

| admin/setup/sources/base/ipsRegistry_setup.php | [upgradeLegacy].__construct | 313 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

What version are you upgrading from? 346 to 347?

There shouldn't be an ALTER TABLE on upgrade_history... To my knowledge, there are NO upgrade queries that need to be run other than to INSERT the upgrade into upgrade_history....

Check your server / apache error logs... What's the 500 error?

Hello Aiwa,

Yes, I was upgrading from 3.46 to 3.47. I use Cpanel with a reverse proxy for Nginx

Either way... What's the 500 error?

I restarted nginx, and it went away :) I changed the file size to 2gb, because by default in cpanel it is only set to 500mb, which is a known issue. But everything seems to be in working order!