ramielrowe

$ keystone --debug  --os_username=admin --os_password=secrete --os_tenant_name=admin --os_auth_url=http://127.0.0.1:5000/v2.0/ service-list
REQ: curl -i http://127.0.0.1:5000/v2.0/tokens -X POST -H "Content-Type: application/json" -H "User-Agent: python-keystoneclient"

REQ BODY: {"auth": {"tenantName": "admin", "passwordCredentials": {"username": "admin", "password": "secrete"}}}

connect: (127.0.0.1, 5000) ************
send: 'POST /v2.0/tokens HTTP/1.1\r\nHost: 127.0.0.1:5000\r\nContent-Length: 102\r\ncontent-type: application/json\r\naccept-encoding: gzip, deflate\r\nuser-agent: python-keystoneclient\r\n\r\n{"auth": {"tenantName": "admin", "passwordCredentials": {"username": "admin", "password": "secrete"}}}'
reply: 'HTTP/1.1 401 Not Authorized\r\n'
header: Vary: X-Auth-Token
header: Content-Type: application/json

ramielrowe

root@tach:~/stacktach_app# ./manage.py migrate stacktach
Running migrations for stacktach:
 - Migrating forwards to 0005_create_glancerawdata_and_genericrawdata.
 > stacktach:0002_create_rawdataimagemeta_and_add_usage_related_fields_to_instanceexists_and_instanceusages
 > stacktach:0003_populate_usage_related_fields_in_rawdataimagemeta_instanceexists_and_instanceusages_from_rawdata
 - Migration 'stacktach:0003_populate_usage_related_fields_in_rawdataimagemeta_instanceexists_and_instanceusages_from_rawdata' is marked for no-dry-run.
Started inserting records in RawDataImageMeta
 ! Error found during real run of migration! Aborting.

 ! Since you have a database that does not support running

ramielrowe

METADATA_MAPPING = {
    'image_org.openstack__1__architecture': 'os_architecture',
    'image_org.openstack__1__os_distro': 'os_distro',
    'image_org.openstack__1__os_version': 'os_version',
    'image_com.rackspace__1__options': 'rax_options',
}
METADATA_FIELDS = ["'%s'" % x for x in METADATA_MAPPING.keys()]
METADATA_FIELDS = ','.join(METADATA_FIELDS)

GET_INSTANCE_SYSTEM_METADATA = """

ramielrowe

FAIL: tests.storage.test_impl_mongodb.StatisticsTest.test_by_user_period
tags: worker-0
----------------------------------------------------------------------
Empty attachments:
  pythonlogging:''

Traceback (most recent call last):
  File "/home/ramielrowe/projects/ceilometer/tests/storage/base.py", line 588, in test_by_user_period
    datetime.datetime(2012, 9, 25, 12, 28)]))
  File "/home/ramielrowe/projects/ceilometer/.tox/py27/local/lib/python2.7/site-packages/testtools/testcase.py", line 322, in assertEqual

ramielrowe

db version v2.0.6, pdfile version 4.5
Mon Jul 15 12:49:54 git version: nogitversion

ramielrowe

{
    "_context_request_id": "req-1a26e836-ac64-4e59-a420-b85769536f72",
    "_context_roles": [
        "role1",
        "role2"
    ],
    "_context_service_catalog": [],
    "payload": {
      "instance_id": "6e45fcad-7a1f-4a50-bcdc-09ec4ad81a94",
      "image_meta": {

ramielrowe

CREATE TABLE `notifications` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `key` varchar(300),
    `value` varchar(300),
    `index` varchar(300),
    `message_id` varchar(50)
);
CREATE INDEX `notifications_key` ON `notifications` (`key`);
CREATE INDEX `notifications_value` ON `notifications` (`value`);
CREATE INDEX `notifications_message_id` ON `notifications` (`message_id`);

ramielrowe

|  7 | _context_service_catalog.*.endpoints.*.publicURL   | http://166.78.17.138:8776/v1/11a0a07e2aff4638abd8c8765df6e690 | 0,0   | bbdd4252-0c69-4477-ac16-61da
04c28332 |
|  8 | _context_service_catalog.*.endpoints.*.internalURL | http://166.78.17.138:8776/v1/11a0a07e2aff4638abd8c8765df6e690 | 0,0   | bbdd4252-0c69-4477-ac16-61da
04c28332 |
|  9 | _context_service_catalog.*.endpoints.*.id          | 54316f256c0d418a976e2dde81fe9ae8                              | 0,0   | bbdd4252-0c69-4477-ac16-61da
04c28332 |
| 10 | _context_service_catalog.*.type                    | volume                                                        | 0     | bbdd4252-0c69-4477-ac16-61da
04c28332 |

ramielrowe

| key                                                | value                                                         | message_id                           |
+----------------------------------------------------+---------------------------------------------------------------+--------------------------------------+
| _context_request_id                                | req-e4ff2394-4732-40d5-b332-6b595189aa53                      | bbdd4252-0c69-4477-ac16-61da04c28332 |
| _context_quota_class                               | None                                                          | bbdd4252-0c69-4477-ac16-61da04c28332 |
| event_type                                         | compute.instance.create.start                                 | bbdd4252-0c69-4477-ac16-61da04c28332 |
| _context_service_catalog.*.endpoints_links         |                                                               | bbdd4252-0c69-4477-ac16-61da04c28332 |
| _context_service_catalog.*.endpoints.*.adminURL    | http://166.78.17.138:

ramielrowe

mysql> explain select max(length(`key`)), max(length(value)) from notifications;
+----+-------------+---------------+------+---------------+------+---------+------+-----------+-------+
| id | select_type | table         | type | possible_keys | key  | key_len | ref  | rows      | Extra |
+----+-------------+---------------+------+---------------+------+---------+------+-----------+-------+
|  1 | SIMPLE      | notifications | ALL  | NULL          | NULL | NULL    | NULL | 262505557 |       |
+----+-------------+---------------+------+---------------+------+---------+------+-----------+-------+
1 row in set (0.00 sec)

mysql> explain select max(length(value)) from notifications;
+----+-------------+---------------+-------+---------------+---------------------+---------+------+-----------+-------------+