Got it - that fixed it. Thanks very much for the reply. I am also having a strange issue with scaling. My farm just ... does not scale. I created a 4-role farm (www, memcache, mysql-lvm and app); I customized the 'app' role (added my webroot, added an SVN script, etc) and 'synchronized' it. Now, the following things happen:
- it is set to 1 instance min, max 4. If I raise the minimum to 2, 3, 4, whatever, nothing happens (no new instances scale). This is the case for the customized app instance, but also for the default memcached instance. - if I configure scaling by LA, the setting does not seem to save (when I return to the same tab after clicking 'Save', the checkbox is not checked and the settings do not seem to be present). I don't know if it's related, but the message on top says "You have -36 spare instances in your Amazon account" (not sure why so few; but I went to AWS Settings and set "max AWS instances" to something like 70, just to get a positive number in that box). Any thoughts appreciated. Thanks again. -j On Tue, Apr 20, 2010 at 2:09 AM, Igor Savchenko <[email protected]> wrote: > Hello Jason, > > > Please use latest version from SVN: > http://code.google.com/p/scalr/source/browse/ > > Tuesday, April 20, 2010, 5:33:45 AM, you wrote: > > > Hi all, > > > I did the v1.2.0 install, and ran the database.sql. It seems, though, > > that some MySQL tables weren't set up properly. Here are some examples > > of what I am getting in the logs: > > > Cannot store event in database: mysql error: [1054: Unknown column > > 'event_object' in 'field list'] in EXECUTE("INSERT INTO events SET > > farmid = '3', type = 'MysqlBackupComplete', dtadded = NOW(), message = > > 'MySQL backup complete ', short_message = 'MySQL backup complete ', > > event_object = > > 'O:24:"MysqlBackupCompleteEvent":7:{s:10:"DBInstance";O: > > 10:"DBInstance":13:{s:2:"ID";s:1:"4";s:6:"FarmID";s:1:"3";s: > > 10:"InstanceID";s:10:"i-xxxxxx";s:5:"AMIID";s:12:"ami-xxxxxx";s: > > 10:"InternalIP";s:14:"xx.xxx.xxx.xxx";s:10:"ExternalIP";s: > > 13:"xxx.xx.xx.xxx";s:9:"AvailZone";s:10:"us-east-1c";s:5:"Index";s: > > 1:"1";s:6:"Region";s:9:"us-east-1";s:10:"FarmRoleID";s:1:"5";s: > > 8:"RoleName";s:8:"mysqllvm";s:22:"DBInstanceDBFarmRole";O: > > 10:"DBFarmRole":5:{s:2:"ID";s:1:"5";s:6:"FarmID";s:1:"3";s:5:"AMIID";s: > > 12:"ami-d09572b9";s:21:"DBFarmRoleRoleAlias";s:5:"mysql";s: > > 20:"DBFarmRoleRoleName";s:8:"mysqllvm";}s:18:"DBInstanceDBFarm";O: > > 6:"DBFarm":4:{s:2:"ID";s:1:"3";s:8:"ClientID";s:1:"1";s:4:"Name";s: > > 10:"trailblaze";s:6:"Region";s:9:"us-east-1";}}s:9:"Operation";s: > > 6:"bundle";s:12:"SnapshotInfo";N;s:22:"SkipDeferredOperations";b:0;s: > > 14:"EventEventID";s:36:"fcc5c2ee-4faa-41d2-a887-9d6b40c95a2d";s: > > 13:"EventFarmID";s:1:"3";s:6:"DBFarm";O:6:"DBFarm":4:{s:2:"ID";s: > > 1:"3";s:8:"ClientID";s:1:"1";s:4:"Name";s:10:"trailblaze";s: > > 6:"Region";s:9:"us-east-1";}}', event_id = 'fcc5c2ee-4faa-41d2- > > a887-9d6b40c95a2d' ") > > Exception thrown in query-env interface: Cannot retrieve environment > > by operation 'list-scripts': mysql error: [1054: Unknown column > > 'event_id' in 'where clause'] in EXECUTE("SELECT * FROM events WHERE > > event_id='0406b3db-dadc-4bc9-9753-3032ed7ea4de'") > > > > > I can alter those tables, but I'm curious what else I might be > > missing. > > > Also: I increased the 'minimum # of instances' of a custom role to 2 > > (was 1), but no new instance is being created. Could this be due to > > some missing column as well? > > > Thanks very much. > > > -j > > > > > -- > Best regards, > Igor mailto:[email protected] > > -- > You received this message because you are subscribed to the Google Groups > "scalr-discuss" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<scalr-discuss%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/scalr-discuss?hl=en. > > -- You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en.
