agesys-dev team mailing list archive

[Matt Fehrenbacher <1572180@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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
                then 1
        end as a_case
    from hopper.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.connect(**config)
    cursor = conn.cursor(oursql.DictCursor)
    cursor.execute(query)
except:
    print "Whoops:", sys.exc_info()


And here's the output (in addition to the server crashing):
Whoops: (<class 'oursql.OperationalError'>, OperationalError(2013, 'Lost connection to MySQL server during query', None), <traceback object at 0x108f10320>)

** Affects: oursql
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Agesys
Team, which is subscribed to oursql.
https://bugs.launchpad.net/bugs/1572180

Title:
  Simple query causes AWS Aurora server to crash

Status in oursql:
  New

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
                  then 1
          end as a_case
      from hopper.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.connect(**config)
      cursor = conn.cursor(oursql.DictCursor)
      cursor.execute(query)
  except:
      print "Whoops:", sys.exc_info()


  
  And here's the output (in addition to the server crashing):
  Whoops: (<class 'oursql.OperationalError'>, OperationalError(2013, 'Lost connection to MySQL server during query', None), <traceback object at 0x108f10320>)

To manage notifications about this bug go to:
https://bugs.launchpad.net/oursql/+bug/1572180/+subscriptions