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]. For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en.
