Forum down again
-
Just woke up to discover that the forum was down, this is due to a database corruption. I have now repaired the database and everything seems to be okay. The cause of this was the ‘optimise database’ scheduled task. Doing some searching there seems to be a history of this problem with SMF.
After looking around for alternatives for SMF I have decided upon Invision. It is actively developed, has excellent documentation and has the bells and whistles that we want. It is commercial but I do not mind paying for a good solution as long as it is does what we want, is stable and secure.
I will setup an empty install of Invision today to test and style. SMF should be fine for the mean time as it will no longer automatically optimise the database.
-
Epic!
Sounds like fun!
The new forum bit that is… not the db corruption… :/
-
That’s really bad luck ;(
I hope, hat the new forum sw will work fine.
Thanks for all your work, Bushstar :)
-
Thanks Bushstar.
-
[quote name=“Wellenreiter” post=“54877” timestamp=“1390634749”]
That’s really bad luck ;(I hope, hat the new forum sw will work fine.
Thanks for all your work, Bushstar :)
[/quote]It is bad luck. MySQL MyIASM tables are buggy like that. It can be as simple as if the number of read locks on a table is different than the number stored, it’s marked as crashed.
InnoDB’s don’t suffer from this symptom, and can be a good fix for a small performance hit for the added ACID transactability. There’s a 4 liner script you can use to convert them. Not running optimizations is fine, it just means once every few months you should probably do it yourself.
-
You are correct Kevlar, thanks for the tip. I am setting up a development Invision install and will convert it to InnoDB.
-
I have now upgraded us to SMF 2.0.7 which is a compatibility release for PHP 5.5 which is the version that we are running. At a quiet time I will test SMF’s ability to optimise the database.
-
What version of 5.5? There were updates / fixes for 5.5.x version recently.
-
We seem to be on the latest available for Ubuntu 13.10. PHP version is 5.5.3+dfsg-1ubuntu2.1.
-
Good work once again that man
-
[quote name=“Bushstar” post=“54898” timestamp=“1390644627”]
We seem to be on the latest available for Ubuntu 13.10. PHP version is 5.5.3+dfsg-1ubuntu2.1.
[/quote]Current Stable PHP 5.5.8 and according Change log http://php.net/ChangeLog-5.php there were some updates for 5.5.4, 5.5.5, 5.5.6, 5.5.7 and best practice says that need to be used some older version of PHP ( 5.3.*, 5.4.* ) and it’s updates doesn’t affect functions used in the application.
My choice would be 5.3.28 -
Please… Don’t change things (Databases Forum software or database) at this busy time for Feathercoin.
The best fix for the database problem is to just switch of optimisation and leave well alone. Do as Kevlar says and plan in a manual optimisation.
Other changes will have bugs too, it will not save you work or us forum “out time.”
Also we should always go with an Open Source solution, propriety = bad
So I think we should only consider propriety as a very very very last resort.
-
[quote name=“slavco” post=“54909” timestamp=“1390647734”]
[quote author=Bushstar link=topic=7180.msg54898#msg54898 date=1390644627]
We seem to be on the latest available for Ubuntu 13.10. PHP version is 5.5.3+dfsg-1ubuntu2.1.
[/quote]Current Stable PHP 5.5.8 and according Change log http://php.net/ChangeLog-5.php there were some updates for 5.5.4, 5.5.5, 5.5.6, 5.5.7 and best practice says that need to be used some older version of PHP ( 5.3.*, 5.4.* ) and it’s updates doesn’t affect functions used in the application.
My choice would be 5.3.28
[/quote]For this build I thought I would use the latest Ubuntu when I normally go for the last LTS edition. This means that I hit a few relatively new bugs along the way but have fixed or worked around them. PHP 5.5.3 is the latest offered by the Ubuntu Server 13.10 package management and I do not want to update outside of it or let it use anything other than stable repos.
Quote from a PM from me to Wrapper.
[quote]As for the forum software I’m interested in moving forum software for reasons of security and Invision seem to have a better track record than others. Also it is much easier to work with as there is proper documentation for everything. Do not worry though, the transition will be relatively quick when it happens and for a large part the forums operate in a similar way so people will not be lost on how to use it.[/quote]Edit: Forgot to mention that the DB for the new board is InnoDB as suggested by Kevlar.
-
stop breaking things lol :P , but for real i was worried people was trying to wipe us out are we going to get chat box back i rather miss being at work and reading random ideas or arguments lol
[quote name=“Bushstar” post=“54873” timestamp=“1390633772”]
Just woke up to discover that the forum was down, this is due to a database corruption. I have now repaired the database and everything seems to be okay. The cause of this was the ‘optimise database’ scheduled task. Doing some searching there seems to be a history of this problem with SMF.After looking around for alternatives for SMF I have decided upon Invision. It is actively developed, has excellent documentation and has the bells and whistles that we want. It is commercial but I do not mind paying for a good solution as long as it is does what we want, is stable and secure.
I will setup an empty install of Invision today to test and style. SMF should be fine for the mean time as it will no longer automatically optimise the database.
[/quote]
