Simple query causes AWS Aurora server to crash
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
oursql |
New
|
Undecided
|
Unassigned |
Bug Description
We've been using oursql to interact with an Amazon Aurora database, which is supposed to be compatible with MySQL 5.6. We were getting repeated crashes, and have been able to find a minimal test case that will reproduce this crash.
We're on Aurora version 5.6.10a , Aurora parameter group default.aurora5.6, oursql 0.9.3.1, Python 2.7.10.
Here's the Python that will cause our server to crash, including the create table statement for the referenced table:
import oursql
import sys
# Table structure (can be empty):
#
# create table `compound_pk` (
# a int not null,
# b int not null,
# primary key(a, b)
# ) engine=InnoDB default charset=utf8;
query = """
select
case
when 1 = 1
end as a_case
from compound_pk c
where c.a = 1
group by c.b
"""
config = {
'host': '127.0.0.1',
'user': 'user',
'passwd': 'password',
'db': 'my_db',
'port': 3306
}
try:
conn = oursql.
cursor = conn.cursor(
cursor.
except:
print "Whoops:", sys.exc_info()
And here's the output (in addition to the server crashing):
Whoops: (<class 'oursql.
description: | updated |