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