Skip to content

Instantly share code, notes, and snippets.

@roaet
Created April 4, 2014 23:15
Show Gist options
  • Save roaet/9984892 to your computer and use it in GitHub Desktop.
Save roaet/9984892 to your computer and use it in GitHub Desktop.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment