Use Glance to backup Images in Nova to Swift

Asked by Chau Pham

Hi Everybody,

I have all Nova, Swift and Glance installed successfully to my machines.

And I also configured Glance to use swift. I have 3 images running on Nova. they are stored in /var/lib/nova/buckets/my_bucket/

I call my first Machine that installed Nova (scheduler, network, compute,..) is Cloud Controller.

In my second Machine, I have installed Swift and Glance. in here I configured Glance to use swift.

=>

I am due to backup my images in Cloud Controller to Swift by using Glance. But I couldn't figure out how to start it.

Could Anybody help me?

Thank in advance.

Question information

Language:
English Edit question
Status:
Answered
For:
Glance Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Jay Pipes (jaypipes) said :
#1

Hi!

Can you paste the output of your glance-api log and glance-api.conf please? Remember to remove any confidential security creds...

Thanks,
jay

Revision history for this message
Chau Pham (chaupv79) said :
#2

Thank Jay - The Man Power ,

Below is my glance-api.conf and glance-aip.log

---------------------------glance-api.conf-----------------------------------------
[DEFAULT]
# Show more verbose log output (sets INFO log level output)
verbose = True

# Show debugging output in logs (sets DEBUG log level output)
debug = True

# Which backend store should Glance use by default is not specified
# in a request to add a new image to Glance? Default: 'file'
# Available choices are 'file', 'swift', and 's3'
default_store = swift

# Address to bind the API server
bind_host = 0.0.0.0

# Port the bind the API server to
bind_port = 9292

# Address to find the registry server
registry_host = 0.0.0.0

# Port the registry server is listening on
registry_port = 9191

# Log to this file. Make sure you do not set the same log
# file for both the API and registry servers!
log_file = /var/log/glance/api.log

# Send logs to syslog (/dev/log) instead of to file specified by `log_file`
use_syslog = False

# ============ Filesystem Store Options ========================

# Directory that the Filesystem backend store
# writes image data to
filesystem_store_datadir = /var/lib/glance/images/

# ============ Swift Store Options =============================

# Address where the Swift authentication service lives
swift_store_auth_address = https://127.0.0.1:8080/auth/v1.0/

# User to authenticate against the Swift authentication service
swift_store_user = test:tester

# Auth key for the user authenticating against the
# Swift authentication service
swift_store_key = testing

# Container within the account that the account should use
# for storing images in Swift
swift_store_container = glance

# Do we create the container if it does not exist?
swift_store_create_container_on_put = True

# Whether to use ServiceNET to communicate with the Swift storage servers.
# (If you aren't RACKSPACE, leave this False!)
#
# To use ServiceNET for authentication, prefix hostname of
# `swift_store_auth_address` with 'snet-'.
# Ex. https://example.com/v1.0/ -> https://snet-example.com/v1.0/
swift_enable_snet = False

# ============ S3 Store Options =============================

# Address where the S3 authentication service lives
s3_store_host = 127.0.0.1:8080/v1.0/

# User to authenticate against the S3 authentication service
s3_store_access_key = <20-char AWS access key>

# Auth key for the user authenticating against the
# S3 authentication service
s3_store_secret_key = <40-char AWS secret key>

# Container within the account that the account should use
# for storing images in S3. Note that S3 has a flat namespace,
# so you need a unique bucket name for your glance images. An
# easy way to do this is append your AWS access key to "glance".
# S3 buckets in AWS *must* be lowercased, so remember to lowercase
# your AWS access key if you use it in your bucket name below!
s3_store_bucket = <lowercased 20-char aws access key>glance

# Do we create the bucket if it does not exist?
s3_store_create_bucket_on_put = False

# ============ Image Cache Options ========================

image_cache_enabled = False

# Directory that the Image Cache writes data to
# Make sure this is also set in glance-pruner.conf
image_cache_datadir = /var/lib/glance/image-cache/

# Number of seconds after which we should consider an incomplete image to be
# stalled and eligible for reaping
image_cache_stall_timeout = 86400

# ============ Delayed Delete Options =============================

# Turn on/off delayed delete
delayed_delete = False

[pipeline:glance-api]
pipeline = versionnegotiation context apiv1app

# To enable Image Cache Management API replace pipeline with below:
# pipeline = versionnegotiation imagecache apiv1app

[pipeline:versions]
pipeline = versionsapp

[app:versionsapp]
paste.app_factory = glance.api.versions:app_factory

[app:apiv1app]
paste.app_factory = glance.api.v1:app_factory

[filter:versionnegotiation]
paste.filter_factory = glance.api.middleware.version_negotiation:filter_factory

[filter:imagecache]
paste.filter_factory = glance.api.middleware.image_cache:filter_factory

[filter:context]
paste.filter_factory = glance.common.context:filter_factory

---------------------------------------------------------------------

--------------------------------glance-api.log---------------------

2011-08-31 15:16:15 DEBUG [glance-api] ********************************************************************************
2011-08-31 15:16:15 DEBUG [glance-api] Configuration options gathered from config file:
2011-08-31 15:16:15 DEBUG [glance-api] /etc/glance/glance-api.conf
2011-08-31 15:16:15 DEBUG [glance-api] ================================================
2011-08-31 15:16:15 DEBUG [glance-api] bind_host 0.0.0.0
2011-08-31 15:16:15 DEBUG [glance-api] bind_port 9292
2011-08-31 15:16:15 DEBUG [glance-api] debug True
2011-08-31 15:16:15 DEBUG [glance-api] default_store swift
2011-08-31 15:16:15 DEBUG [glance-api] delayed_delete False
2011-08-31 15:16:15 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-08-31 15:16:15 DEBUG [glance-api] image_cache_datadir /var/lib/glance/image-cache/
2011-08-31 15:16:15 DEBUG [glance-api] image_cache_enabled False
2011-08-31 15:16:15 DEBUG [glance-api] image_cache_stall_timeout 86400
2011-08-31 15:16:15 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-08-31 15:16:15 DEBUG [glance-api] registry_host 0.0.0.0
2011-08-31 15:16:15 DEBUG [glance-api] registry_port 9191
2011-08-31 15:16:15 DEBUG [glance-api] s3_store_access_key <20-char AWS access key>
2011-08-31 15:16:15 DEBUG [glance-api] s3_store_bucket <lowercased 20-char aws access key>glance
2011-08-31 15:16:15 DEBUG [glance-api] s3_store_create_bucket_on_put False
2011-08-31 15:16:15 DEBUG [glance-api] s3_store_host 127.0.0.1:8080/v1.0/
2011-08-31 15:16:15 DEBUG [glance-api] s3_store_secret_key <40-char AWS secret key>
2011-08-31 15:16:15 DEBUG [glance-api] swift_enable_snet False
2011-08-31 15:16:15 DEBUG [glance-api] swift_store_auth_address https://127.0.0.1:8080/auth/v1.0/
2011-08-31 15:16:15 DEBUG [glance-api] swift_store_container glance
2011-08-31 15:16:15 DEBUG [glance-api] swift_store_create_container_on_put True
2011-08-31 15:16:15 DEBUG [glance-api] swift_store_key testing
2011-08-31 15:16:15 DEBUG [glance-api] swift_store_user test:tester
2011-08-31 15:16:15 DEBUG [glance-api] use_syslog False
2011-08-31 15:16:15 DEBUG [glance-api] verbose True
2011-08-31 15:16:15 DEBUG [glance-api] ********************************************************************************
2011-08-31 15:16:15 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-09-05 10:11:05 DEBUG [glance-api] ********************************************************************************
2011-09-05 10:11:05 DEBUG [glance-api] Configuration options gathered from config file:
2011-09-05 10:11:05 DEBUG [glance-api] /etc/glance/glance-api.conf
2011-09-05 10:11:05 DEBUG [glance-api] ================================================
2011-09-05 10:11:05 DEBUG [glance-api] bind_host 0.0.0.0
2011-09-05 10:11:05 DEBUG [glance-api] bind_port 9292
2011-09-05 10:11:05 DEBUG [glance-api] debug True
2011-09-05 10:11:05 DEBUG [glance-api] default_store swift
2011-09-05 10:11:05 DEBUG [glance-api] delayed_delete False
2011-09-05 10:11:05 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-09-05 10:11:05 DEBUG [glance-api] image_cache_datadir /var/lib/glance/image-cache/
2011-09-05 10:11:05 DEBUG [glance-api] image_cache_enabled False
2011-09-05 10:11:05 DEBUG [glance-api] image_cache_stall_timeout 86400
2011-09-05 10:11:05 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-09-05 10:11:05 DEBUG [glance-api] registry_host 0.0.0.0
2011-09-05 10:11:05 DEBUG [glance-api] registry_port 9191
2011-09-05 10:11:05 DEBUG [glance-api] s3_store_access_key <20-char AWS access key>
2011-09-05 10:11:05 DEBUG [glance-api] s3_store_bucket <lowercased 20-char aws access key>glance
2011-09-05 10:11:05 DEBUG [glance-api] s3_store_create_bucket_on_put False
2011-09-05 10:11:05 DEBUG [glance-api] s3_store_host 127.0.0.1:8080/v1.0/
2011-09-05 10:11:05 DEBUG [glance-api] s3_store_secret_key <40-char AWS secret key>
2011-09-05 10:11:05 DEBUG [glance-api] swift_enable_snet False
2011-09-05 10:11:05 DEBUG [glance-api] swift_store_auth_address https://127.0.0.1:8080/auth/v1.0/
2011-09-05 10:11:05 DEBUG [glance-api] swift_store_container glance
2011-09-05 10:11:05 DEBUG [glance-api] swift_store_create_container_on_put True
2011-09-05 10:11:05 DEBUG [glance-api] swift_store_key testing
2011-09-05 10:11:05 DEBUG [glance-api] swift_store_user test:tester
2011-09-05 10:11:05 DEBUG [glance-api] use_syslog False
2011-09-05 10:11:05 DEBUG [glance-api] verbose True
2011-09-05 10:11:05 DEBUG [glance-api] ********************************************************************************
2011-09-05 10:11:05 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-09-05 10:11:05 DEBUG [eventlet.wsgi.server] (954) wsgi starting up on http://0.0.0.0:9292/
2011-09-05 10:13:45 DEBUG [glance-api] ********************************************************************************
2011-09-05 10:13:45 DEBUG [glance-api] Configuration options gathered from config file:
2011-09-05 10:13:45 DEBUG [glance-api] /etc/glance/glance-api.conf
2011-09-05 10:13:45 DEBUG [glance-api] ================================================
2011-09-05 10:13:45 DEBUG [glance-api] bind_host 0.0.0.0
2011-09-05 10:13:45 DEBUG [glance-api] bind_port 9292
2011-09-05 10:13:45 DEBUG [glance-api] debug True
2011-09-05 10:13:45 DEBUG [glance-api] default_store swift
2011-09-05 10:13:45 DEBUG [glance-api] delayed_delete False
2011-09-05 10:13:45 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-09-05 10:13:45 DEBUG [glance-api] image_cache_datadir /var/lib/glance/image-cache/
2011-09-05 10:13:45 DEBUG [glance-api] image_cache_enabled False
2011-09-05 10:13:45 DEBUG [glance-api] image_cache_stall_timeout 86400
2011-09-05 10:13:45 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-09-05 10:13:45 DEBUG [glance-api] registry_host 0.0.0.0
2011-09-05 10:13:45 DEBUG [glance-api] registry_port 9191
2011-09-05 10:13:45 DEBUG [glance-api] s3_store_access_key <20-char AWS access key>
2011-09-05 10:13:45 DEBUG [glance-api] s3_store_bucket <lowercased 20-char aws access key>glance
2011-09-05 10:13:45 DEBUG [glance-api] s3_store_create_bucket_on_put False
2011-09-05 10:13:45 DEBUG [glance-api] s3_store_host 127.0.0.1:8080/v1.0/
2011-09-05 10:13:45 DEBUG [glance-api] s3_store_secret_key <40-char AWS secret key>
2011-09-05 10:13:45 DEBUG [glance-api] swift_enable_snet False
2011-09-05 10:13:45 DEBUG [glance-api] swift_store_auth_address https://127.0.0.1:8080/auth/v1.0/
2011-09-05 10:13:45 DEBUG [glance-api] swift_store_container glance
2011-09-05 10:13:45 DEBUG [glance-api] swift_store_create_container_on_put True
2011-09-05 10:13:45 DEBUG [glance-api] swift_store_key testing
2011-09-05 10:13:45 DEBUG [glance-api] swift_store_user test:tester
2011-09-05 10:13:45 DEBUG [glance-api] use_syslog False
2011-09-05 10:13:45 DEBUG [glance-api] verbose True
2011-09-05 10:13:45 DEBUG [glance-api] ********************************************************************************
2011-09-05 10:13:45 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-09-05 10:14:12 DEBUG [glance-api] ********************************************************************************
2011-09-05 10:14:12 DEBUG [glance-api] Configuration options gathered from config file:
2011-09-05 10:14:12 DEBUG [glance-api] /etc/glance/glance-api.conf
2011-09-05 10:14:12 DEBUG [glance-api] ================================================
2011-09-05 10:14:12 DEBUG [glance-api] bind_host 0.0.0.0
2011-09-05 10:14:12 DEBUG [glance-api] bind_port 9292
2011-09-05 10:14:12 DEBUG [glance-api] debug True
2011-09-05 10:14:12 DEBUG [glance-api] default_store swift
2011-09-05 10:14:12 DEBUG [glance-api] delayed_delete False
2011-09-05 10:14:12 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-09-05 10:14:12 DEBUG [glance-api] image_cache_datadir /var/lib/glance/image-cache/
2011-09-05 10:14:12 DEBUG [glance-api] image_cache_enabled False
2011-09-05 10:14:12 DEBUG [glance-api] image_cache_stall_timeout 86400
2011-09-05 10:14:12 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-09-05 10:14:12 DEBUG [glance-api] registry_host 0.0.0.0
2011-09-05 10:14:12 DEBUG [glance-api] registry_port 9191
2011-09-05 10:14:12 DEBUG [glance-api] s3_store_access_key <20-char AWS access key>
2011-09-05 10:14:12 DEBUG [glance-api] s3_store_bucket <lowercased 20-char aws access key>glance
2011-09-05 10:14:12 DEBUG [glance-api] s3_store_create_bucket_on_put False
2011-09-05 10:14:12 DEBUG [glance-api] s3_store_host 127.0.0.1:8080/v1.0/
2011-09-05 10:14:12 DEBUG [glance-api] s3_store_secret_key <40-char AWS secret key>
2011-09-05 10:14:12 DEBUG [glance-api] swift_enable_snet False
2011-09-05 10:14:12 DEBUG [glance-api] swift_store_auth_address https://127.0.0.1:8080/auth/v1.0/
2011-09-05 10:14:12 DEBUG [glance-api] swift_store_container glance
2011-09-05 10:14:12 DEBUG [glance-api] swift_store_create_container_on_put True
2011-09-05 10:14:12 DEBUG [glance-api] swift_store_key testing
2011-09-05 10:14:12 DEBUG [glance-api] swift_store_user test:tester
2011-09-05 10:14:12 DEBUG [glance-api] use_syslog False
2011-09-05 10:14:12 DEBUG [glance-api] verbose True
2011-09-05 10:14:12 DEBUG [glance-api] ********************************************************************************
2011-09-05 10:14:12 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-09-05 10:33:59 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images Accept:
2011-09-05 10:33:59 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-05 10:33:59 DEBUG [routes.middleware] Matched GET /images
2011-09-05 10:33:59 DEBUG [routes.middleware] Route path: 'images', defaults: {'action': u'index', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 10:33:59 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 10:33:59 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [05/Sep/2011 10:33:59] "GET /v1/images?limit=10 HTTP/1.1" 200 603 0.053337
2011-09-05 10:33:59 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images Accept:
2011-09-05 10:33:59 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-05 10:33:59 DEBUG [routes.middleware] Matched GET /images
2011-09-05 10:33:59 DEBUG [routes.middleware] Route path: 'images', defaults: {'action': u'index', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 10:33:59 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 10:33:59 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [05/Sep/2011 10:33:59] "GET /v1/images?marker=1&limit=10 HTTP/1.1" 200 162 0.046529
2011-09-05 10:34:32 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images/detail Accept:
2011-09-05 10:34:32 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-05 10:34:32 DEBUG [routes.middleware] Matched GET /images/detail
2011-09-05 10:34:32 DEBUG [routes.middleware] Route path: 'images/detail', defaults: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 10:34:32 DEBUG [routes.middleware] Match dict: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 10:34:32 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [05/Sep/2011 10:34:32] "GET /v1/images/detail?limit=10 HTTP/1.1" 200 1339 0.030624
2011-09-05 10:34:32 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images/detail Accept:
2011-09-05 10:34:32 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-05 10:34:32 DEBUG [routes.middleware] Matched GET /images/detail
2011-09-05 10:34:32 DEBUG [routes.middleware] Route path: 'images/detail', defaults: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 10:34:32 DEBUG [routes.middleware] Match dict: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 10:34:32 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [05/Sep/2011 10:34:32] "GET /v1/images/detail?marker=1&limit=10 HTTP/1.1" 200 162 0.044875
2011-09-05 15:36:02 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images Accept:
2011-09-05 15:36:02 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-05 15:36:02 DEBUG [routes.middleware] Matched GET /images
2011-09-05 15:36:02 DEBUG [routes.middleware] Route path: 'images', defaults: {'action': u'index', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 15:36:02 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 15:36:02 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [05/Sep/2011 15:36:02] "GET /v1/images?limit=10 HTTP/1.1" 200 603 0.057828
2011-09-05 15:36:02 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images Accept:
2011-09-05 15:36:02 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-05 15:36:02 DEBUG [routes.middleware] Matched GET /images
2011-09-05 15:36:02 DEBUG [routes.middleware] Route path: 'images', defaults: {'action': u'index', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 15:36:02 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 15:36:02 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [05/Sep/2011 15:36:02] "GET /v1/images?marker=1&limit=10 HTTP/1.1" 200 162 0.033928
2011-09-05 15:36:13 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images/detail Accept:
2011-09-05 15:36:13 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-05 15:36:13 DEBUG [routes.middleware] Matched GET /images/detail
2011-09-05 15:36:13 DEBUG [routes.middleware] Route path: 'images/detail', defaults: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 15:36:13 DEBUG [routes.middleware] Match dict: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 15:36:13 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [05/Sep/2011 15:36:13] "GET /v1/images/detail?limit=10 HTTP/1.1" 200 1339 0.027886
2011-09-05 15:36:13 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images/detail Accept:
2011-09-05 15:36:13 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-05 15:36:13 DEBUG [routes.middleware] Matched GET /images/detail
2011-09-05 15:36:13 DEBUG [routes.middleware] Route path: 'images/detail', defaults: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 15:36:13 DEBUG [routes.middleware] Match dict: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x9b6306c>}
2011-09-05 15:36:13 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [05/Sep/2011 15:36:13] "GET /v1/images/detail?marker=1&limit=10 HTTP/1.1" 200 162 0.041786
2011-09-08 09:53:47 DEBUG [glance-api] ********************************************************************************
2011-09-08 09:53:47 DEBUG [glance-api] Configuration options gathered from config file:
2011-09-08 09:53:47 DEBUG [glance-api] /etc/glance/glance-api.conf
2011-09-08 09:53:47 DEBUG [glance-api] ================================================
2011-09-08 09:53:47 DEBUG [glance-api] bind_host 0.0.0.0
2011-09-08 09:53:47 DEBUG [glance-api] bind_port 9292
2011-09-08 09:53:47 DEBUG [glance-api] debug True
2011-09-08 09:53:47 DEBUG [glance-api] default_store swift
2011-09-08 09:53:47 DEBUG [glance-api] delayed_delete False
2011-09-08 09:53:47 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-09-08 09:53:47 DEBUG [glance-api] image_cache_datadir /var/lib/glance/image-cache/
2011-09-08 09:53:47 DEBUG [glance-api] image_cache_enabled False
2011-09-08 09:53:47 DEBUG [glance-api] image_cache_stall_timeout 86400
2011-09-08 09:53:47 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-09-08 09:53:47 DEBUG [glance-api] registry_host 0.0.0.0
2011-09-08 09:53:47 DEBUG [glance-api] registry_port 9191
2011-09-08 09:53:47 DEBUG [glance-api] s3_store_access_key <20-char AWS access key>
2011-09-08 09:53:47 DEBUG [glance-api] s3_store_bucket <lowercased 20-char aws access key>glance
2011-09-08 09:53:47 DEBUG [glance-api] s3_store_create_bucket_on_put False
2011-09-08 09:53:47 DEBUG [glance-api] s3_store_host 127.0.0.1:8080/v1.0/
2011-09-08 09:53:47 DEBUG [glance-api] s3_store_secret_key <40-char AWS secret key>
2011-09-08 09:53:47 DEBUG [glance-api] swift_enable_snet False
2011-09-08 09:53:47 DEBUG [glance-api] swift_store_auth_address https://127.0.0.1:8080/auth/v1.0/
2011-09-08 09:53:47 DEBUG [glance-api] swift_store_container glance
2011-09-08 09:53:47 DEBUG [glance-api] swift_store_create_container_on_put True
2011-09-08 09:53:47 DEBUG [glance-api] swift_store_key testing
2011-09-08 09:53:47 DEBUG [glance-api] swift_store_user test:tester
2011-09-08 09:53:47 DEBUG [glance-api] use_syslog False
2011-09-08 09:53:47 DEBUG [glance-api] verbose True
2011-09-08 09:53:47 DEBUG [glance-api] ********************************************************************************
2011-09-08 09:53:47 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-09-08 09:53:47 DEBUG [eventlet.wsgi.server] (926) wsgi starting up on http://0.0.0.0:9292/
2011-09-08 11:04:05 DEBUG [glance-api] ********************************************************************************
2011-09-08 11:04:05 DEBUG [glance-api] Configuration options gathered from config file:
2011-09-08 11:04:05 DEBUG [glance-api] /etc/glance/glance-api.conf
2011-09-08 11:04:05 DEBUG [glance-api] ================================================
2011-09-08 11:04:05 DEBUG [glance-api] bind_host 0.0.0.0
2011-09-08 11:04:05 DEBUG [glance-api] bind_port 9292
2011-09-08 11:04:05 DEBUG [glance-api] debug True
2011-09-08 11:04:05 DEBUG [glance-api] default_store swift
2011-09-08 11:04:05 DEBUG [glance-api] delayed_delete False
2011-09-08 11:04:05 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-09-08 11:04:05 DEBUG [glance-api] image_cache_datadir /var/lib/glance/image-cache/
2011-09-08 11:04:05 DEBUG [glance-api] image_cache_enabled False
2011-09-08 11:04:05 DEBUG [glance-api] image_cache_stall_timeout 86400
2011-09-08 11:04:05 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-09-08 11:04:05 DEBUG [glance-api] registry_host 0.0.0.0
2011-09-08 11:04:05 DEBUG [glance-api] registry_port 9191
2011-09-08 11:04:05 DEBUG [glance-api] s3_store_access_key <20-char AWS access key>
2011-09-08 11:04:05 DEBUG [glance-api] s3_store_bucket <lowercased 20-char aws access key>glance
2011-09-08 11:04:05 DEBUG [glance-api] s3_store_create_bucket_on_put False
2011-09-08 11:04:05 DEBUG [glance-api] s3_store_host 127.0.0.1:8080/v1.0/
2011-09-08 11:04:05 DEBUG [glance-api] s3_store_secret_key <40-char AWS secret key>
2011-09-08 11:04:05 DEBUG [glance-api] swift_enable_snet False
2011-09-08 11:04:05 DEBUG [glance-api] swift_store_auth_address https://127.0.0.1:8080/auth/v1.0/
2011-09-08 11:04:05 DEBUG [glance-api] swift_store_container glance
2011-09-08 11:04:05 DEBUG [glance-api] swift_store_create_container_on_put True
2011-09-08 11:04:05 DEBUG [glance-api] swift_store_key testing
2011-09-08 11:04:05 DEBUG [glance-api] swift_store_user test:tester
2011-09-08 11:04:05 DEBUG [glance-api] use_syslog False
2011-09-08 11:04:05 DEBUG [glance-api] verbose True
2011-09-08 11:04:05 DEBUG [glance-api] ********************************************************************************
2011-09-08 11:04:05 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-09-08 12:02:36 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images/detail Accept:
2011-09-08 12:02:36 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-08 12:02:36 DEBUG [routes.middleware] Matched GET /images/detail
2011-09-08 12:02:36 DEBUG [routes.middleware] Route path: 'images/detail', defaults: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x903f06c>}
2011-09-08 12:02:36 DEBUG [routes.middleware] Match dict: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x903f06c>}
2011-09-08 12:02:36 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [08/Sep/2011 12:02:36] "GET /v1/images/detail?limit=10 HTTP/1.1" 200 1339 0.052177
2011-09-08 12:02:36 DEBUG [glance.api.middleware.version_negotiation] Processing request: GET /v1/images/detail Accept:
2011-09-08 12:02:36 DEBUG [glance.api.middleware.version_negotiation] Matched versioned URI. Version: 1.0
2011-09-08 12:02:36 DEBUG [routes.middleware] Matched GET /images/detail
2011-09-08 12:02:36 DEBUG [routes.middleware] Route path: 'images/detail', defaults: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x903f06c>}
2011-09-08 12:02:36 DEBUG [routes.middleware] Match dict: {'action': u'detail', 'controller': <glance.common.wsgi.Resource object at 0x903f06c>}
2011-09-08 12:02:36 DEBUG [eventlet.wsgi.server] 192.168.0.15 - - [08/Sep/2011 12:02:36] "GET /v1/images/detail?marker=1&limit=10 HTTP/1.1" 200 162 0.055839
2011-09-09 09:39:24 DEBUG [glance-api] ********************************************************************************
2011-09-09 09:39:24 DEBUG [glance-api] Configuration options gathered from config file:
2011-09-09 09:39:24 DEBUG [glance-api] /etc/glance/glance-api.conf
2011-09-09 09:39:24 DEBUG [glance-api] ================================================
2011-09-09 09:39:24 DEBUG [glance-api] bind_host 0.0.0.0
2011-09-09 09:39:24 DEBUG [glance-api] bind_port 9292
2011-09-09 09:39:24 DEBUG [glance-api] debug True
2011-09-09 09:39:24 DEBUG [glance-api] default_store swift
2011-09-09 09:39:24 DEBUG [glance-api] delayed_delete False
2011-09-09 09:39:24 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-09-09 09:39:24 DEBUG [glance-api] image_cache_datadir /var/lib/glance/image-cache/
2011-09-09 09:39:24 DEBUG [glance-api] image_cache_enabled False
2011-09-09 09:39:24 DEBUG [glance-api] image_cache_stall_timeout 86400
2011-09-09 09:39:24 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-09-09 09:39:24 DEBUG [glance-api] registry_host 0.0.0.0
2011-09-09 09:39:24 DEBUG [glance-api] registry_port 9191
2011-09-09 09:39:24 DEBUG [glance-api] s3_store_access_key <20-char AWS access key>
2011-09-09 09:39:24 DEBUG [glance-api] s3_store_bucket <lowercased 20-char aws access key>glance
2011-09-09 09:39:24 DEBUG [glance-api] s3_store_create_bucket_on_put False
2011-09-09 09:39:24 DEBUG [glance-api] s3_store_host 127.0.0.1:8080/v1.0/
2011-09-09 09:39:24 DEBUG [glance-api] s3_store_secret_key <40-char AWS secret key>
2011-09-09 09:39:24 DEBUG [glance-api] swift_enable_snet False
2011-09-09 09:39:24 DEBUG [glance-api] swift_store_auth_address https://127.0.0.1:8080/auth/v1.0/
2011-09-09 09:39:24 DEBUG [glance-api] swift_store_container glance
2011-09-09 09:39:24 DEBUG [glance-api] swift_store_create_container_on_put True
2011-09-09 09:39:24 DEBUG [glance-api] swift_store_key testing
2011-09-09 09:39:24 DEBUG [glance-api] swift_store_user test:tester
2011-09-09 09:39:24 DEBUG [glance-api] use_syslog False
2011-09-09 09:39:24 DEBUG [glance-api] verbose True
2011-09-09 09:39:24 DEBUG [glance-api] ********************************************************************************
2011-09-09 09:39:24 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-09-09 09:39:24 DEBUG [eventlet.wsgi.server] (930) wsgi starting up on http://0.0.0.0:9292/

---------------------------------------------------------------

Revision history for this message
Jay Pipes (jaypipes) said :
#3

Hi again,

So, I actually don't see anything in your log file that indicates any requests have been made to Glance. Have you used the glance CLI tool to add images to Glance?

-jay

Revision history for this message
Chau Pham (chaupv79) said :
#4

HI Jay,

Thank you for your feedback,

I am sure I have used CLI tool to add images to Glance

glance index --host=192.168.0.15

ID Name Disk Format Container Format Size
---------------- ------------------------------ -------------------- -------------------- --------------
3 ubuntu-10-10-server-glance-add raw ovf 58
2 My Image raw ovf 12
1 My Image raw ovf 12

when I check the gegistry.conf, I see the image information as below, the log looks like a sql statement for the images:

2011-08-31 15:13:39 INFO [glance.registry.db.migration] Upgrading sqlite:////var/lib/glance/glance.sqlite to version latest
2011-08-31 15:13:39 INFO [migrate.versioning.api] 0 -> 1...
2011-08-31 15:13:39 INFO [glance.registry.db.migrate_repo.schema] creating table images
2011-08-31 15:13:39 INFO [migrate.versioning.api] done
2011-08-31 15:13:39 INFO [migrate.versioning.api] 1 -> 2...
2011-08-31 15:13:39 INFO [glance.registry.db.migrate_repo.schema] creating table image_properties
2011-08-31 15:13:39 INFO [migrate.versioning.api] done
2011-08-31 15:13:39 INFO [migrate.versioning.api] 2 -> 3...
2011-08-31 15:13:39 INFO [migrate.versioning.api] done
2011-08-31 15:13:39 INFO [migrate.versioning.api] 3 -> 4...
2011-08-31 15:13:39 INFO [migrate.versioning.api] done
2011-08-31 15:13:39 INFO [migrate.versioning.api] 4 -> 5...
2011-08-31 15:13:39 INFO [migrate.versioning.api] done
2011-08-31 15:13:39 INFO [migrate.versioning.api] 5 -> 6...
2011-08-31 15:13:39 INFO [migrate.versioning.api] done
2011-08-31 15:13:39 INFO [migrate.versioning.api] 6 -> 7...
2011-08-31 15:13:39 INFO [migrate.versioning.api] done
2011-08-31 15:13:41 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] PRAGMA table_info("images")
2011-08-31 15:13:41 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ()
2011-08-31 15:13:41 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] PRAGMA table_info("image_properties")
2011-08-31 15:13:41 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ()
2011-08-31 15:13:41 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] PRAGMA table_info("images")
2011-08-31 15:13:41 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ()
2011-08-31 15:13:41 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] PRAGMA table_info("image_properties")
2011-08-31 15:13:41 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ()
2011-08-31 15:14:35 INFO [sqlalchemy.engine.base.Engine.0x...efec] PRAGMA table_info("images")
2011-08-31 15:14:35 INFO [sqlalchemy.engine.base.Engine.0x...efec] ()
2011-08-31 15:14:35 INFO [sqlalchemy.engine.base.Engine.0x...efec] PRAGMA table_info("image_properties")
2011-08-31 15:14:35 INFO [sqlalchemy.engine.base.Engine.0x...efec] ()
2011-08-31 15:14:35 INFO [sqlalchemy.engine.base.Engine.0x...efec] PRAGMA table_info("images")
2011-08-31 15:14:35 INFO [sqlalchemy.engine.base.Engine.0x...efec] ()
2011-08-31 15:14:35 INFO [sqlalchemy.engine.base.Engine.0x...efec] PRAGMA table_info("image_properties")
2011-08-31 15:14:35 INFO [sqlalchemy.engine.base.Engine.0x...efec] ()
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] INSERT INTO images (created_at, updated_at, deleted_at, deleted, name, disk_format, container_format, size, status, is_public, location, checksum, owner) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:19:08.296820', None, None, False, u'My Image', u'raw', u'ovf', 0, u'queued', True, None, None, None)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT image_properties.created_at AS image_properties_created_at, image_properties.updated_at AS image_properties_updated_at, image_properties.deleted_at AS image_properties_deleted_at, image_properties.deleted AS image_properties_deleted, image_properties.id AS image_properties_id, image_properties.image_id AS image_properties_image_id, image_properties.name AS image_properties_name, image_properties.value AS image_properties_value
FROM image_properties
WHERE ? = image_properties.image_id
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (1,)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, status=? WHERE images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:19:08.351428', u'saving', 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, size=?, checksum=? WHERE images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:19:08.389306', 12, u'd27df4f0c983bdca4c09e4ce98e93c27', 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, status=?, location=? WHERE images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:19:08.426948', u'active', u'file:///var/lib/glance/images/1', 1)
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:08 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] INSERT INTO images (created_at, updated_at, deleted_at, deleted, name, disk_format, container_format, size, status, is_public, location, checksum, owner) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:19:47.081484', None, None, False, u'My Image', u'raw', u'ovf', 0, u'queued', True, None, None, None)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT image_properties.created_at AS image_properties_created_at, image_properties.updated_at AS image_properties_updated_at, image_properties.deleted_at AS image_properties_deleted_at, image_properties.deleted AS image_properties_deleted, image_properties.id AS image_properties_id, image_properties.image_id AS image_properties_image_id, image_properties.name AS image_properties_name, image_properties.value AS image_properties_value
FROM image_properties
WHERE ? = image_properties.image_id
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (2,)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, status=? WHERE images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:19:47.110521', u'saving', 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, size=?, checksum=? WHERE images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:19:47.133997', 12, u'd27df4f0c983bdca4c09e4ce98e93c27', 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, status=?, location=? WHERE images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:19:47.156010', u'active', u'file:///var/lib/glance/images/2', 2)
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:19:47 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 2)
2011-08-31 15:21:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:21:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True)
2011-08-31 15:21:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:21:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:21:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:21:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-08-31 15:21:21 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:21:21 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True)
2011-08-31 15:21:21 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:21:21 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:21:21 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:21:21 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] INSERT INTO images (created_at, updated_at, deleted_at, deleted, name, disk_format, container_format, size, status, is_public, location, checksum, owner) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:29:03.186300', None, None, False, u'ubuntu-10-10-server-glance-add', u'raw', u'ovf', 0, u'queued', True, None, None, None)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT image_properties.created_at AS image_properties_created_at, image_properties.updated_at AS image_properties_updated_at, image_properties.deleted_at AS image_properties_deleted_at, image_properties.deleted AS image_properties_deleted, image_properties.id AS image_properties_id, image_properties.image_id AS image_properties_image_id, image_properties.name AS image_properties_name, image_properties.value AS image_properties_value
FROM image_properties
WHERE ? = image_properties.image_id
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (3,)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, status=? WHERE images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:29:03.225314', u'saving', 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, size=?, checksum=? WHERE images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:29:03.247960', 58, u'b9b4b35d1fbcd9e5b49a7bf3a6e68867', 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] BEGIN
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] UPDATE images SET updated_at=?, status=?, location=? WHERE images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] ('2011-08-31 06:29:03.271194', u'active', u'file:///var/lib/glance/images/3', 3)
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] COMMIT
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:29:03 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 3)
2011-08-31 15:30:04 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:30:04 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True)
2011-08-31 15:30:04 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:30:04 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:30:04 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:30:04 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-08-31 15:58:50 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:58:50 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True)
2011-08-31 15:58:50 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:58:50 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:58:50 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:58:50 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-08-31 15:59:29 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:59:29 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True)
2011-08-31 15:59:29 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 15:59:29 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 15:59:29 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 15:59:29 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-08-31 16:28:11 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 16:28:11 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True)
2011-08-31 16:28:11 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-08-31 16:28:11 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 1)
2011-08-31 16:28:11 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-08-31 16:28:11 INFO [sqlalchemy.engine.base.Engine.0x...1f2c] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-09-05 10:11:05 INFO [sqlalchemy.engine.base.Engine.0x...60ac] PRAGMA table_info("images")
2011-09-05 10:11:05 INFO [sqlalchemy.engine.base.Engine.0x...60ac] ()
2011-09-05 10:11:05 INFO [sqlalchemy.engine.base.Engine.0x...60ac] PRAGMA table_info("image_properties")
2011-09-05 10:11:05 INFO [sqlalchemy.engine.base.Engine.0x...60ac] ()
2011-09-05 10:11:05 INFO [sqlalchemy.engine.base.Engine.0x...60ac] PRAGMA table_info("images")
2011-09-05 10:11:05 INFO [sqlalchemy.engine.base.Engine.0x...60ac] ()
2011-09-05 10:11:05 INFO [sqlalchemy.engine.base.Engine.0x...60ac] PRAGMA table_info("image_properties")
2011-09-05 10:11:05 INFO [sqlalchemy.engine.base.Engine.0x...60ac] ()
2011-09-05 10:14:24 INFO [sqlalchemy.engine.base.Engine.0x...01ec] PRAGMA table_info("images")
2011-09-05 10:14:24 INFO [sqlalchemy.engine.base.Engine.0x...01ec] ()
2011-09-05 10:14:24 INFO [sqlalchemy.engine.base.Engine.0x...01ec] PRAGMA table_info("image_properties")
2011-09-05 10:14:24 INFO [sqlalchemy.engine.base.Engine.0x...01ec] ()
2011-09-05 10:14:24 INFO [sqlalchemy.engine.base.Engine.0x...01ec] PRAGMA table_info("images")
2011-09-05 10:14:24 INFO [sqlalchemy.engine.base.Engine.0x...01ec] ()
2011-09-05 10:14:24 INFO [sqlalchemy.engine.base.Engine.0x...01ec] PRAGMA table_info("image_properties")
2011-09-05 10:14:24 INFO [sqlalchemy.engine.base.Engine.0x...01ec] ()
2011-09-05 10:33:59 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-05 10:33:59 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True)
2011-09-05 10:33:59 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-09-05 10:33:59 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 1)
2011-09-05 10:33:59 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-05 10:33:59 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-09-05 10:34:32 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-05 10:34:32 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True)
2011-09-05 10:34:32 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-09-05 10:34:32 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 1)
2011-09-05 10:34:32 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-05 10:34:32 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-09-05 15:36:02 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-05 15:36:02 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True)
2011-09-05 15:36:02 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-09-05 15:36:02 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 1)
2011-09-05 15:36:02 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-05 15:36:02 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-09-05 15:36:13 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-05 15:36:13 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True)
2011-09-05 15:36:13 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-09-05 15:36:13 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 1)
2011-09-05 15:36:13 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-05 15:36:13 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-09-08 09:53:47 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("images")
2011-09-08 09:53:47 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-08 09:53:47 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("image_properties")
2011-09-08 09:53:47 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-08 09:53:47 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("images")
2011-09-08 09:53:47 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-08 09:53:47 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("image_properties")
2011-09-08 09:53:47 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-08 11:04:16 INFO [sqlalchemy.engine.base.Engine.0x...00ac] PRAGMA table_info("images")
2011-09-08 11:04:16 INFO [sqlalchemy.engine.base.Engine.0x...00ac] ()
2011-09-08 11:04:16 INFO [sqlalchemy.engine.base.Engine.0x...00ac] PRAGMA table_info("image_properties")
2011-09-08 11:04:16 INFO [sqlalchemy.engine.base.Engine.0x...00ac] ()
2011-09-08 11:04:16 INFO [sqlalchemy.engine.base.Engine.0x...00ac] PRAGMA table_info("images")
2011-09-08 11:04:16 INFO [sqlalchemy.engine.base.Engine.0x...00ac] ()
2011-09-08 11:04:16 INFO [sqlalchemy.engine.base.Engine.0x...00ac] PRAGMA table_info("image_properties")
2011-09-08 11:04:16 INFO [sqlalchemy.engine.base.Engine.0x...00ac] ()
2011-09-08 12:02:36 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-08 12:02:36 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] (False, 'killed', True)
2011-09-08 12:02:36 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-09-08 12:02:36 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] (False, 1)
2011-09-08 12:02:36 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-08 12:02:36 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)
2011-09-09 09:39:24 INFO [sqlalchemy.engine.base.Engine.0x...f0ac] PRAGMA table_info("images")
2011-09-09 09:39:24 INFO [sqlalchemy.engine.base.Engine.0x...f0ac] ()
2011-09-09 09:39:24 INFO [sqlalchemy.engine.base.Engine.0x...f0ac] PRAGMA table_info("image_properties")
2011-09-09 09:39:24 INFO [sqlalchemy.engine.base.Engine.0x...f0ac] ()
2011-09-09 09:39:24 INFO [sqlalchemy.engine.base.Engine.0x...f0ac] PRAGMA table_info("images")
2011-09-09 09:39:24 INFO [sqlalchemy.engine.base.Engine.0x...f0ac] ()
2011-09-09 09:39:24 INFO [sqlalchemy.engine.base.Engine.0x...f0ac] PRAGMA table_info("image_properties")
2011-09-09 09:39:24 INFO [sqlalchemy.engine.base.Engine.0x...f0ac] ()
2011-09-09 18:48:34 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("images")
2011-09-09 18:48:34 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-09 18:48:34 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("image_properties")
2011-09-09 18:48:34 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-09 18:48:34 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("images")
2011-09-09 18:48:34 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-09 18:48:34 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("image_properties")
2011-09-09 18:48:34 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-14 11:07:23 INFO [sqlalchemy.engine.base.Engine.0x...70ac] PRAGMA table_info("images")
2011-09-14 11:07:23 INFO [sqlalchemy.engine.base.Engine.0x...70ac] ()
2011-09-14 11:07:23 INFO [sqlalchemy.engine.base.Engine.0x...70ac] PRAGMA table_info("image_properties")
2011-09-14 11:07:23 INFO [sqlalchemy.engine.base.Engine.0x...70ac] ()
2011-09-14 11:07:23 INFO [sqlalchemy.engine.base.Engine.0x...70ac] PRAGMA table_info("images")
2011-09-14 11:07:23 INFO [sqlalchemy.engine.base.Engine.0x...70ac] ()
2011-09-14 11:07:23 INFO [sqlalchemy.engine.base.Engine.0x...70ac] PRAGMA table_info("image_properties")
2011-09-14 11:07:23 INFO [sqlalchemy.engine.base.Engine.0x...70ac] ()
2011-09-14 11:39:33 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("images")
2011-09-14 11:39:33 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-14 11:39:33 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("image_properties")
2011-09-14 11:39:33 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-14 11:39:33 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("images")
2011-09-14 11:39:33 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-14 11:39:33 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] PRAGMA table_info("image_properties")
2011-09-14 11:39:33 INFO [sqlalchemy.engine.base.Engine.0x...e0ac] ()
2011-09-15 09:31:16 INFO [sqlalchemy.engine.base.Engine.0x...60ac] PRAGMA table_info("images")
2011-09-15 09:31:16 INFO [sqlalchemy.engine.base.Engine.0x...60ac] ()
2011-09-15 09:31:16 INFO [sqlalchemy.engine.base.Engine.0x...60ac] PRAGMA table_info("image_properties")
2011-09-15 09:31:16 INFO [sqlalchemy.engine.base.Engine.0x...60ac] ()
2011-09-15 09:31:16 INFO [sqlalchemy.engine.base.Engine.0x...60ac] PRAGMA table_info("images")
2011-09-15 09:31:16 INFO [sqlalchemy.engine.base.Engine.0x...60ac] ()
2011-09-15 09:31:16 INFO [sqlalchemy.engine.base.Engine.0x...60ac] PRAGMA table_info("image_properties")
2011-09-15 09:31:16 INFO [sqlalchemy.engine.base.Engine.0x...60ac] ()
2011-09-15 09:47:00 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-15 09:47:00 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True)
2011-09-15 09:47:00 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
WHERE images.deleted = ? AND images.id = ?
2011-09-15 09:47:00 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 1)
2011-09-15 09:47:00 INFO [sqlalchemy.engine.base.Engine.0x...60ac] SELECT anon_1.images_created_at AS anon_1_images_created_at, anon_1.images_updated_at AS anon_1_images_updated_at, anon_1.images_deleted_at AS anon_1_images_deleted_at, anon_1.images_deleted AS anon_1_images_deleted, anon_1.images_id AS anon_1_images_id, anon_1.images_name AS anon_1_images_name, anon_1.images_disk_format AS anon_1_images_disk_format, anon_1.images_container_format AS anon_1_images_container_format, anon_1.images_size AS anon_1_images_size, anon_1.images_status AS anon_1_images_status, anon_1.images_is_public AS anon_1_images_is_public, anon_1.images_location AS anon_1_images_location, anon_1.images_checksum AS anon_1_images_checksum, anon_1.images_owner AS anon_1_images_owner, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
FROM (SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, images.owner AS images_owner
FROM images
WHERE images.deleted = ? AND images.status != ? AND images.is_public = ? AND (images.created_at < ? OR images.created_at = ? AND images.id < ?) ORDER BY images.created_at DESC, images.id DESC
 LIMIT 10 OFFSET 0) AS anon_1 LEFT OUTER JOIN image_properties AS image_properties_1 ON anon_1.images_id = image_properties_1.image_id ORDER BY anon_1.images_created_at DESC, anon_1.images_id DESC
2011-09-15 09:47:00 INFO [sqlalchemy.engine.base.Engine.0x...60ac] (False, 'killed', True, '2011-08-31 06:19:08.296820', '2011-08-31 06:19:08.296820', 1)

I eager to know the relationship between Nova, Swift and Glance.
how can I backup the images from Nova to swift by using glance, are they working independently or not?

Look forward to hearing from you, Jay.

Revision history for this message
Chau Pham (chaupv79) said :
#5

Thank Jay,

your request for log file make me suddenly come up with an idea, I replace bind_host = 0.0.0.0 and registry_host = 0.0.0.0

by
host = 192.168.0.15
host = 192.168.0.15

192.168.0.15 is my host IP address.

and now, glance can put images to swift successfully. I absolutely download images in swift server.

but i got another issue, it is the Nova and Swift

My purpose is to use Swifts' Images in Nova.
I am making question how Nova could recognize Swifts' Images.

I am eager to hear your Idea, Jay!!!!!!!

Thank You.

Revision history for this message
Chau Pham (chaupv79) said :
#6

Thank Jay,

your request for log file make me suddenly come up with an idea, I replace bind_host = 0.0.0.0 and registry_host = 0.0.0.0

by
bind_host = 192.168.0.15
registry_host = 192.168.0.15

192.168.0.15 is my host IP address.

and now, glance can put images to swift successfully. I absolutely download images in swift server.

but i got another issue, it is the Nova and Swift

My purpose is to use Swifts' Images in Nova.
I am making question how Nova could recognize Swifts' Images.

I am eager to hear your Idea, Jay!!!!!!!

Thank You.

Revision history for this message
Jay Pipes (jaypipes) said :
#7

OK, good to know the first issue was resolved easily! :)

As for using images in Swift to boot in Nova, you need to specify the Glance image URI for the imageRef property of the create server request:

http://docs.openstack.org/trunk/openstack-compute/developer/openstack-compute-api-1.1/content/CreateServers.html

Cheers!
jay

Revision history for this message
Chau Pham (chaupv79) said :
#8

Thank Jay,

I am due to make xml manifest to test this.

Can you help with this problem?

Provide an answer of your own, or ask Chau Pham for more information if necessary.

To post a message you must log in.