Guest User

IBL access error

a guest
Jul 22nd, 2020
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.73 KB | None | 0 0
  1. ---------------------------------------------------------------------------
  2.  
  3. InternalError Traceback (most recent call last)
  4.  
  5. <ipython-input-9-b131a585f016> in <module>()
  6. 4 #create dataframe(pandas) out of above table
  7. 5 behav = b.fetch(order_by='institution_short, subject_nickname, training_day',
  8. ----> 6 format='frame').reset_index()
  9. 7 behav['institution_code'] = behav.institution_short.map(institution_map)
  10. 8 behav
  11.  
  12. 14 frames
  13.  
  14. /usr/local/lib/python3.6/dist-packages/datajoint/fetch.py in __call__(self, offset, limit, order_by, format, as_dict, squeeze, download_path, *attrs)
  15. 185 ret = return_values[0] if len(attrs) == 1 else return_values
  16. 186 else: # fetch all attributes as a numpy.record_array or pandas.DataFrame
  17. --> 187 cur = self._expression.cursor(as_dict=as_dict, limit=limit, offset=offset, order_by=order_by)
  18. 188 heading = self._expression.heading
  19. 189 if as_dict:
  20.  
  21. /usr/local/lib/python3.6/dist-packages/datajoint/expression.py in cursor(self, offset, limit, order_by, as_dict)
  22. 573 sql += ' LIMIT %d' % limit + (' OFFSET %d' % offset if offset else "")
  23. 574 logger.debug(sql)
  24. --> 575 return self.connection.query(sql, as_dict=as_dict)
  25. 576
  26. 577
  27.  
  28. /usr/local/lib/python3.6/dist-packages/datajoint/connection.py in query(self, query, args, as_dict, suppress_warnings, reconnect)
  29. 212 cursor = self._conn.cursor(cursor=cursor_class)
  30. 213 try:
  31. --> 214 self._execute_query(cursor, query, args, cursor_class, suppress_warnings)
  32. 215 except errors.LostConnectionError:
  33. 216 if not reconnect:
  34.  
  35. /usr/local/lib/python3.6/dist-packages/datajoint/connection.py in _execute_query(cursor, query, args, cursor_class, suppress_warnings)
  36. 194 cursor.execute(query, args)
  37. 195 except client_errors as err:
  38. --> 196 raise translate_query_error(err, query) from None
  39. 197
  40. 198 def query(self, query, args=(), *, as_dict=False, suppress_warnings=True, reconnect=None):
  41.  
  42. /usr/local/lib/python3.6/dist-packages/datajoint/connection.py in _execute_query(cursor, query, args, cursor_class, suppress_warnings)
  43. 192 # suppress all warnings arising from underlying SQL library
  44. 193 warnings.simplefilter("ignore")
  45. --> 194 cursor.execute(query, args)
  46. 195 except client_errors as err:
  47. 196 raise translate_query_error(err, query) from None
  48.  
  49. /usr/local/lib/python3.6/dist-packages/pymysql/cursors.py in execute(self, query, args)
  50. 161 query = self.mogrify(query, args)
  51. 162
  52. --> 163 result = self._query(query)
  53. 164 self._executed = query
  54. 165 return result
  55.  
  56. /usr/local/lib/python3.6/dist-packages/pymysql/cursors.py in _query(self, q)
  57. 319 self._last_executed = q
  58. 320 self._clear_result()
  59. --> 321 conn.query(q)
  60. 322 self._do_get_result()
  61. 323 return self.rowcount
  62.  
  63. /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in query(self, sql, unbuffered)
  64. 503 sql = sql.encode(self.encoding, 'surrogateescape')
  65. 504 self._execute_command(COMMAND.COM_QUERY, sql)
  66. --> 505 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  67. 506 return self._affected_rows
  68. 507
  69.  
  70. /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in _read_query_result(self, unbuffered)
  71. 722 else:
  72. 723 result = MySQLResult(self)
  73. --> 724 result.read()
  74. 725 self._result = result
  75. 726 if result.server_status is not None:
  76.  
  77. /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in read(self)
  78. 1074 self._read_load_local_packet(first_packet)
  79. 1075 else:
  80. -> 1076 self._read_result_packet(first_packet)
  81. 1077 finally:
  82. 1078 self.connection = None
  83.  
  84. /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in _read_result_packet(self, first_packet)
  85. 1144 self.field_count = first_packet.read_length_encoded_integer()
  86. 1145 self._get_descriptions()
  87. -> 1146 self._read_rowdata_packet()
  88. 1147
  89. 1148 def _read_rowdata_packet_unbuffered(self):
  90.  
  91. /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in _read_rowdata_packet(self)
  92. 1178 rows = []
  93. 1179 while True:
  94. -> 1180 packet = self.connection._read_packet()
  95. 1181 if self._check_packet_is_eof(packet):
  96. 1182 self.connection = None # release reference to kill cyclic reference.
  97.  
  98. /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in _read_packet(self, packet_type)
  99. 674 if self._result is not None and self._result.unbuffered_active is True:
  100. 675 self._result.unbuffered_active = False
  101. --> 676 packet.raise_for_error()
  102. 677 return packet
  103. 678
  104.  
  105. /usr/local/lib/python3.6/dist-packages/pymysql/protocol.py in raise_for_error(self)
  106. 221 errno = self.read_uint16()
  107. 222 if DEBUG: print("errno =", errno)
  108. --> 223 err.raise_mysql_exception(self._data)
  109. 224
  110. 225 def dump(self):
  111.  
  112. /usr/local/lib/python3.6/dist-packages/pymysql/err.py in raise_mysql_exception(data)
  113. 105 if errorclass is None:
  114. 106 errorclass = InternalError if errno < 1000 else OperationalError
  115. --> 107 raise errorclass(errno, errval)
  116.  
  117. InternalError: (3, "Error writing file '/rdsdbdata/tmp/MYuRQnWS' (Errcode: 28 - No space left on device)")
Add Comment
Please, Sign In to add comment