agesys-dev team mailing list archive

[Matt Fehrenbacher <1572180@xxxxxxxxxxxxxxxxxx>]

** Description changed:

  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
+     select
+         case
+             when 1 = 1
+                 then 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
+     '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)
+     conn = oursql.connect(**config)
+     cursor = conn.cursor(oursql.DictCursor)
+     cursor.execute(query)
  except:
-     print "Whoops:", sys.exc_info()
- 
- 
+     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>)

-- 
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 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