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



  • 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]


  • Developer

    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.


  • Developer

    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


  • Senior Developer

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

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



  • [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.



  • [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.


  • Senior Developer

    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]


  • Developer

    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.



  • 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.


Log in to reply
 

488
Online

38957
Users

10706
Topics

101581
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.