Database table "phpbb_posts" crashed and won't repair due to temp file?

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
WWu777
Registered User
Posts: 537
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by WWu777 » Wed Dec 13, 2017 6:03 am

Dear support,
My server crashed today and when I had my webhost restart it, the database tables suddenly crashed too. Then when MySQL was restarted, one of the tables crashed and could not be repaired. I tried going to phpmyadmin and when I tried used this command: "REPAIR TABLE phpbb_posts", I got this error message:

error : Can't create new tempfile: './happier2_HappierAbroad/phpbb_posts.TMD'
status : Operation failed

Usually the repair works, but this time it keeps saying it can't create a temp file. What does that mean? What can I do? Any suggestions?
Last edited by WWu777 on Wed Dec 13, 2017 2:06 pm, edited 1 time in total.

User avatar
canonknipser
Registered User
Posts: 1544
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by canonknipser » Wed Dec 13, 2017 6:23 am

Ask your host's support, maybe it is a space issue on your server
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

WWu777
Registered User
Posts: 537
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

[Split] Error Accessing Posts

Post by WWu777 » Wed Dec 13, 2017 6:25 am

Im having the same problem after my server crashed. What does that error message mean? Whats a temp file?
Last edited by Mick on Wed Dec 13, 2017 8:48 am, edited 1 time in total.
Reason: Split from https://www.phpbb.com/community/viewtopic.php?f=556&t=2399436

User avatar
canonknipser
Registered User
Posts: 1544
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Error Accessing Posts

Post by canonknipser » Wed Dec 13, 2017 6:38 am

Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

WWu777
Registered User
Posts: 537
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by WWu777 » Wed Dec 13, 2017 2:10 pm

canonknipser wrote:
Wed Dec 13, 2017 6:23 am
Ask your host's support, maybe it is a space issue on your server
My server has plenty of space. And this doesnt usually happen.

What does the error message mean? Why cant it create a temp file?

My server has been crashing every week now ever since i upgraded to phpbb 3.2. Does this new version of phpbb use up more resources? Why would that be? Its supposed to be better right?

My webhost is working on it but they still haven't fixed it yet.

User avatar
david63
Jr. Extension Validator
Posts: 14471
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by david63 » Wed Dec 13, 2017 2:24 pm

It sounds to me as if that table became corrupt when the "server crashed".

Easiest option is to restore your database to the last backup that you have from before the crash - you do back your database up don't you?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
canonknipser
Registered User
Posts: 1544
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by canonknipser » Wed Dec 13, 2017 2:40 pm

WWu777 wrote:
Wed Dec 13, 2017 2:10 pm
What does the error message mean?
The MySql repair process can't create a temp(orary) file needed to copy the table content, because the current table file needs to be deleted and re-created during repair.
WWu777 wrote:
Wed Dec 13, 2017 2:10 pm
Why cant it create a temp file?
There can be many reason only your host can answer, eg.
  • no space available in the temp file's directory (this is usualy NOT in your regular web server file system, but in the database servers file system, so you can't tell
    WWu777 wrote:
    Wed Dec 13, 2017 2:10 pm
    My server has plenty of space.
    for that error
  • missing permission on the temp file's directory
  • the temp file already exist and can't be deleted
  • file system integrity error
  • 99+ more possible reasons...
WWu777 wrote:
Wed Dec 13, 2017 2:10 pm
this doesnt usually happen
WWu777 wrote:
Wed Dec 13, 2017 2:10 pm
My server has been crashing every week now
Ask your host, there must be server error logs about the crash - usually that don't happen either
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

WWu777
Registered User
Posts: 537
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by WWu777 » Wed Dec 13, 2017 9:20 pm

How do i set the permissions on that file directory? Where is the exact directory tree?

The support staff said the server logs cant tell them what the cause of the crash is, only that there is a server overload.

Phpbb 3.2 is not more resource heavy than previous versions right?

I only have a backup from a few weeks ago. I dont wanna do that cause a lot of posts would be lost. Thats only a last resort.

Are all database problems repairable with the right tools? If my webhost doesnt fix it where do i hire someone? Do they have special tools beyond phpmyadmin? I cant even download the table at this point. It reads as null or in use. However its still 2.4 GB so the data is still there.
Last edited by WWu777 on Wed Dec 13, 2017 9:31 pm, edited 2 times in total.

User avatar
canonknipser
Registered User
Posts: 1544
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by canonknipser » Wed Dec 13, 2017 9:25 pm

WWu777 wrote:
Wed Dec 13, 2017 9:20 pm
How do i set the permissions on that file directory? Where is the exact directory tree?
As said earlier: Because nobody here knows your server setup, it is a question you have to ask the people who should know the answer - and that is your host support staff:
canonknipser wrote:
Wed Dec 13, 2017 2:40 pm
There can be many reason only your host can answer, eg.
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

User avatar
david63
Jr. Extension Validator
Posts: 14471
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by david63 » Wed Dec 13, 2017 9:31 pm

WWu777 wrote:
Wed Dec 13, 2017 9:20 pm
How do i set the permissions on that file directory?
You will need shell access
WWu777 wrote:
Wed Dec 13, 2017 9:20 pm
Where is the exact directory tree?
You will need to ask your hosts - all servers are different.
WWu777 wrote:
Wed Dec 13, 2017 9:20 pm
Are all database problems repairable with the right tools?
No - that is why you make backups.
WWu777 wrote:
Wed Dec 13, 2017 9:20 pm
If my webhost doesnt fix it where do i hire someone?
Try Mr Google
WWu777 wrote:
Wed Dec 13, 2017 9:20 pm
I cant even download the table at this point.
If you cannot download it then it is unlikely that anyone else can.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
warmweer
Registered User
Posts: 974
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by warmweer » Wed Dec 13, 2017 11:44 pm

WWu777 wrote:
Wed Dec 13, 2017 9:20 pm
...
I only have a backup from a few weeks ago. I dont wanna do that cause a lot of posts would be lost. Thats only a last resort.
:?: :?: :?:
You had problems upgrading and finally succeeded: viewtopic.php?f=556&t=2446631&p=14870161#p14870161.
If I interpret your message (the one I just quoted) correctly, then your (personal) backup is either your phpBB3.0.x board or a 3.2.1 board from around November 22.
a) With all the problems you've had in upgrading: how can you not take backups before installing a whole bunch of extensions on your live board???
b) You've had weekly crashes? Backup alert!!!
c) What about your host: don't they have backups?
d) If this gets sorted out, considering the size of your database, take some time to read up on incremental backups (so that you don't have to download the whole database each time, and can have an almost up to date offline (backup)board available in case of calamities).
A bug is a feature that hasn't made it to the manual (yet)

WWu777
Registered User
Posts: 537
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by WWu777 » Thu Dec 14, 2017 2:38 am

warmweer wrote:
Wed Dec 13, 2017 11:44 pm
WWu777 wrote:
Wed Dec 13, 2017 9:20 pm
...
I only have a backup from a few weeks ago. I dont wanna do that cause a lot of posts would be lost. Thats only a last resort.
:?: :?: :?:
You had problems upgrading and finally succeeded: viewtopic.php?f=556&t=2446631&p=14870161#p14870161.
If I interpret your message (the one I just quoted) correctly, then your (personal) backup is either your phpBB3.0.x board or a 3.2.1 board from around November 22.
a) With all the problems you've had in upgrading: how can you not take backups before installing a whole bunch of extensions on your live board???
b) You've had weekly crashes? Backup alert!!!
c) What about your host: don't they have backups?
d) If this gets sorted out, considering the size of your database, take some time to read up on incremental backups (so that you don't have to download the whole database each time, and can have an almost up to date offline (backup)board available in case of calamities).
Because I'm on VPS and only have 30 GB hosting space. Not enough for backups. VPS sucks. I'm paying more and it's less stable than shared hosting. A total ripoff. Everyone told me VPS was better. Turned out to be false. I would have to pay more to add more disc space. I was gonna do that. But I've never had a database table that was unrepairable before.

Extensions here don't usually crash databases. They are safe and tested and approved.

No my host doesn't do automatic backups unless I'm on shared hosting. My VPS doesn't have enough room and they won't allow me to downgrade to shared hosting without closing and reopening a new account. Very lame.

How do you do incremental backups?

What if I do a backup now and then try to download the corrupted database and repair it offline? There are database programs. I downloaded two of them, but there is one big problem. Neither of them can recognize the SQL files of the databases! So they are useless and cannot even load or allow me to select any database files!!! That is messed up. I don't know what to say. A database software repair program cannot even recognize a database file! WTF? Sounds incredible but it's true. It can't recognize any database file from phpbb, not even a gz file or a db file.

All database problems are repairable right? It's just a matter of whether one wants to do all the necessary steps or not.

And of course, webhosts always try to pass on the blame to the software, and not to them. They always do that.

There are many complains about Bluehost online now. They are getting worse and worse of a reputation.

My forum has been down 24 hours now and the admins at Bluehost still haven't gotten to my ticket yet.

janus_zonstraal
Registered User
Posts: 2441
Joined: Sat Aug 30, 2014 1:30 pm

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by janus_zonstraal » Thu Dec 14, 2017 8:30 am

I use Adminer in this cases, it is a very small file but better than PhpMyAdmin
https://www.adminer.org/

You download, upload, repair, edit and much more with this program.
Sorry! My English is bat ;) !!!

User avatar
warmweer
Registered User
Posts: 974
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by warmweer » Thu Dec 14, 2017 8:31 am

WWu777 wrote:
Thu Dec 14, 2017 2:38 am
Because I'm on VPS and only have 30 GB hosting space. Not enough for backups.
Your database is 2.5 GB and you only have 30 GB hosting space. Correct me if I am wrong but that leaves 27.5 GB available for other things. Seems to me that there's room for a copy of the whole forum.
Also, a webhosting account isn't the only place one can keep backups.
Extensions here don't usually crash databases. They are safe and tested and approved.
Extensions are modifications and are tested as such. It's hard to guarantee that certain combinations of extensions won't cause conflicts somewhere, no matter how thoroughly they've been tested. And it's not exactly easy to test extensions in crash situations either.
The principle is: the more changes/additions are made, the higher the risk of something going wrong, which is not saying that extensions are the cause.
No my host doesn't do automatic backups unless I'm on shared hosting.
Well, there's also another principle which comes in handy sometimes: DIY
How do you do incremental backups?
Only backup the differences between the current state and the state of the previous backup. BTW the previous backup could thus also be an incremental backup. I'ld suggest going for differential backups so that your last backup contains the differences with your latest full backup.
How? Look it up and try it, test and learn.
What if I do a backup now and then try to download the corrupted database and repair it offline?
Actually (the dead horse is being flogged to gibberish now). If the database cannot be repaired online, what would you download to repair? With some luck it's only one table which is corrupt (you didn't even mention which table) but that one table may be linked to others.

Either this can be solved by the database software, or by the host, or by uploading a working backup (perhaps there are other possibilities but I can't think of any now). According to you, the database software can't do the repairs, and your host can't either. That leaves the third option and sooner or later you will have to decide which way to go
A bug is a feature that hasn't made it to the manual (yet)

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49249
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Database table "phpbb_posts" crashed and won't repair due to temp file?

Post by stevemaury » Thu Dec 14, 2017 3:11 pm

WWu777 wrote:
Thu Dec 14, 2017 2:38 am

All database problems are repairable right? It's just a matter of whether one wants to do all the necessary steps or not.
No. As mentioned above, this is one of the reasons one backs up.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

Locked

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: hewmac06, hoarybat, netingirl, stephhhh, stevemaury and 21 guests