while deploying 231 on 5.5.33a-MariaDB-log, got this error message -- status_variables_aggregated_hour table exists (1146, "Table 'mycheckpoint.status_variables_aggregated_hour' doesn't exist")

[GoogleCodeExporter]

What steps will reproduce the problem?
1. status_variables_aggregated_hour table exists
2.
3.

What is the expected output? What do you see instead?
-- status_variables_aggregated_hour table exists
(1146, "Table 'mycheckpoint.status_variables_aggregated_hour' doesn't exist")

What is the output when running with the "--verbose --debug" options?
Traceback (most recent call last):
  File "mycheckpoint.py", line 2260, in create_status_variables_hour_aggregation_table
    act_query(query)
  File "mycheckpoint.py", line 247, in act_query
    num_affected_rows = cursor.execute(query)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1005, "Can't create table 
'mycheckpoint.status_variables_aggregated_hour' (errno: 139)")
-- status_variables_aggregated_hour table exists
(1146, "Table 'mycheckpoint.status_variables_aggregated_hour' doesn't exist")
Traceback (most recent call last):
  File "mycheckpoint.py", line 4950, in <module>
    deploy_schema()
  File "mycheckpoint.py", line 4847, in deploy_schema
    create_status_variables_views_and_aggregations()
  File "mycheckpoint.py", line 3914, in create_status_variables_views_and_aggregations
    upgrade_status_variables_hour_aggregation_table()
  File "mycheckpoint.py", line 2021, in upgrade_status_variables_hour_aggregation_table
    return upgrade_status_variables_aggregation_table("status_variables_aggregated_hour")
  File "mycheckpoint.py", line 1994, in upgrade_status_variables_aggregation_table
    existing_columns = [row["Field"] for row in get_rows(query, write_conn)]
  File "mycheckpoint.py", line 268, in get_rows
    cursor.execute(query)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'mycheckpoint.status_variables_aggregated_hour' 
doesn't exist")


What version of the mycheckpoint are you using? 231
What version of the MySQL are you using? (SELECT VERSION())5.5.33a-MariaDB-log
What version of Python are you using? (python --version) Python 2.6.8

On what operating system? SUSE Linux Enterprise Server 11 (x86_64)
What is your sql_mode? (SELECT @@global.sql_mode)  NO_AUTO_CREATE_USER


Please provide any additional information below.

Original issue reported on code.google.com by jayakuma...@gmail.com on 17 Jul 2014 at 3:35