Repeatedly being prompted to update database schema and then receiving errors on v110

[Magnus_CA]

HI fogsters,

I was having an issue with my fog v1.0.1 server and after a bit of unsuccessful troubleshooting and noticing v1.1.0 had dropped I decided to do a clean install (Ubuntu 14.04 LTS).

The install went fine and I was able to pull an issue from my client computer with no issues but now I’m being repeatedly prompted to update my database schema despite doing so successfully when asked during the fog server install. When I click the button to update the schema (again) I get an ‘Update/Install Failed’ message.

I attached a copy of my install log and a copy of the error log I received.

Can anyone point me to how to resolve this?

Thanks in advance for the help!

[url=“/_imported_xf_attachments/0/928_FOG 1.1.0 Database Schema Installer _ Updater.txt?:”]FOG 1.1.0 Database Schema Installer _ Updater.txt[/url][url=“/_imported_xf_attachments/0/929_v110_foginstall.txt?:”]v110_foginstall.txt[/url]

[Magnus_CA]

Update - restarting the mysql service and then clicking install/upgrade seems to have fixed the problem. It reported no upgrade was necessary and I’m no longer being prompted. Hope it doesn’t return.

Thanks.

[Wolfbane8653]

Ubuntu 14.04 LTS is having serious issues with mysql. At this time it is[B] not recommended[/B] by anyone here to have your fog installation on Ubuntu 14.04.

[Tom Elliott]

All those having mysql problems on 14.04, what is the RAM amount on your systems?

What’s the mysql version installed?

[url]https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1312936[/url]

[Magnus_CA]

[quote=“Tom Elliott, post: 29566, member: 7271”]All those having mysql problems on 14.04, what is the RAM amount on your systems?

What’s the mysql version installed?

[URL=‘https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1312936’]https://bugs.launchpad.net/ubuntu/ source/mysql-5.6/ bug/1312936[/URL][/quote]

I have 4GB of RAM and running mysql v5.5.37.

[Magnus_CA]

[quote=“Wolfbane8653, post: 29564, member: 3362”]Ubuntu 14.04 LTS is having serious issues with mysql. At this time it is[B] not recommended[/B] by anyone here to have your fog installation on Ubuntu 14.04.[/quote]

That’s great. I’ve lost count of how many times I’ve re-installed my linux server. What do you recommend for the most headache free fog experience? The latest version of Debian (I’d want to install a desktop environment)? Ubuntu 13.10?

I don’t need a bleeding edge Linux OS…just a stable environment for using fog.

[Tom Elliott]

I’d recommend Debian 7.5, Ubuntu 10 thru 13, Centos 6.5.

Either of these I haven’t heard or seen anything major.

[Andy Abplanalp]

Tom -

Fresh install of 1.1.0
New install of Ubuntu 13.10 Serverx64
MySQL 5.5.32-0ubuntu7
AMD880 chipset, AMD hex core CPU, 16GB RAM

When I make changes to snapins, groups, etc., I’m sporadically being asked to update the database schema and a “service mysql restart” will allow me to log in again.

Andy

[Andy Abplanalp]

Just to update this thread - I don’t know if this was an issue just for a short while after reboot but it seems to have cleared up (although I haven’t been making any changes to the DB). I also added “service mysql restart” to the /etc/rc.local file.