gistfile1.txt

2014-04-04 23:14:19.416 21849 TRACE quark.ipam     result = conn.execute(querycontext.statement, self._params)                              [0/1831]
2014-04-04 23:14:19.416 21849 TRACE quark.ipam   File "/opt/rackstack/615.22/neutron/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 14
49, in execute
2014-04-04 23:14:19.416 21849 TRACE quark.ipam     params)
2014-04-04 23:14:19.416 21849 TRACE quark.ipam   File "/opt/rackstack/615.22/neutron/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 15
84, in _execute_clauseelement
2014-04-04 23:14:19.416 21849 TRACE quark.ipam     compiled_sql, distilled_params
2014-04-04 23:14:19.416 21849 TRACE quark.ipam   File "/opt/rackstack/615.22/neutron/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 16
98, in _execute_context
2014-04-04 23:14:19.416 21849 TRACE quark.ipam     context)
2014-04-04 23:14:19.416 21849 TRACE quark.ipam   File "/opt/rackstack/615.22/neutron/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 16
91, in _execute_context
2014-04-04 23:14:19.416 21849 TRACE quark.ipam     context)
2014-04-04 23:14:19.416 21849 TRACE quark.ipam   File "/opt/rackstack/615.22/neutron/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line
 331, in do_execute
2014-04-04 23:14:19.416 21849 TRACE quark.ipam     cursor.execute(statement, parameters)
2014-04-04 23:14:19.416 21849 TRACE quark.ipam   File "/opt/rackstack/615.22/neutron/lib/python2.6/site-packages/MySQLdb/cursors.py", line 205, in e
xecute
2014-04-04 23:14:19.416 21849 TRACE quark.ipam     self.errorhandler(self, exc, value)
2014-04-04 23:14:19.416 21849 TRACE quark.ipam   File "/opt/rackstack/615.22/neutron/lib/python2.6/site-packages/MySQLdb/connections.py", line 36, i
n defaulterrorhandler
2014-04-04 23:14:19.416 21849 TRACE quark.ipam     raise errorclass, errorvalue
2014-04-04 23:14:19.416 21849 TRACE quark.ipam OperationalError: (OperationalError) (1665, 'Cannot execute statement: impossible to write to binary
log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when
 transaction isolation level is READ COMMITTED or READ UNCOMMITTED.') 'SELECT quark_mac_address_ranges.id AS quark_mac_address_ranges_id, quark_mac_
address_ranges.created_at AS quark_mac_address_ranges_created_at, quark_mac_address_ranges.cidr AS quark_mac_address_ranges_cidr, quark_mac_address_
ranges.first_address AS quark_mac_address_ranges_first_address, quark_mac_address_ranges.last_address AS quark_mac_address_ranges_last_address, quar
k_mac_address_ranges.next_auto_assign_mac AS quark_mac_address_ranges_next_auto_assign_mac, count(quark_mac_addresses.address) AS count \nFROM quark
_mac_address_ranges LEFT OUTER JOIN quark_mac_addresses ON quark_mac_address_ranges.id = quark_mac_addresses.mac_address_range_id \nWHERE quark_mac_
address_ranges.next_auto_assign_mac != %s GROUP BY quark_mac_address_ranges.id ORDER BY count DESC \n LIMIT %s FOR UPDATE' (-1, 1)
2014-04-04 23:14:19.416 21849 TRACE quark.ipam