Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ---------------------------------------------------------------------------
- InternalError Traceback (most recent call last)
- <ipython-input-9-b131a585f016> in <module>()
- 4 #create dataframe(pandas) out of above table
- 5 behav = b.fetch(order_by='institution_short, subject_nickname, training_day',
- ----> 6 format='frame').reset_index()
- 7 behav['institution_code'] = behav.institution_short.map(institution_map)
- 8 behav
- 14 frames
- /usr/local/lib/python3.6/dist-packages/datajoint/fetch.py in __call__(self, offset, limit, order_by, format, as_dict, squeeze, download_path, *attrs)
- 185 ret = return_values[0] if len(attrs) == 1 else return_values
- 186 else: # fetch all attributes as a numpy.record_array or pandas.DataFrame
- --> 187 cur = self._expression.cursor(as_dict=as_dict, limit=limit, offset=offset, order_by=order_by)
- 188 heading = self._expression.heading
- 189 if as_dict:
- /usr/local/lib/python3.6/dist-packages/datajoint/expression.py in cursor(self, offset, limit, order_by, as_dict)
- 573 sql += ' LIMIT %d' % limit + (' OFFSET %d' % offset if offset else "")
- 574 logger.debug(sql)
- --> 575 return self.connection.query(sql, as_dict=as_dict)
- 576
- 577
- /usr/local/lib/python3.6/dist-packages/datajoint/connection.py in query(self, query, args, as_dict, suppress_warnings, reconnect)
- 212 cursor = self._conn.cursor(cursor=cursor_class)
- 213 try:
- --> 214 self._execute_query(cursor, query, args, cursor_class, suppress_warnings)
- 215 except errors.LostConnectionError:
- 216 if not reconnect:
- /usr/local/lib/python3.6/dist-packages/datajoint/connection.py in _execute_query(cursor, query, args, cursor_class, suppress_warnings)
- 194 cursor.execute(query, args)
- 195 except client_errors as err:
- --> 196 raise translate_query_error(err, query) from None
- 197
- 198 def query(self, query, args=(), *, as_dict=False, suppress_warnings=True, reconnect=None):
- /usr/local/lib/python3.6/dist-packages/datajoint/connection.py in _execute_query(cursor, query, args, cursor_class, suppress_warnings)
- 192 # suppress all warnings arising from underlying SQL library
- 193 warnings.simplefilter("ignore")
- --> 194 cursor.execute(query, args)
- 195 except client_errors as err:
- 196 raise translate_query_error(err, query) from None
- /usr/local/lib/python3.6/dist-packages/pymysql/cursors.py in execute(self, query, args)
- 161 query = self.mogrify(query, args)
- 162
- --> 163 result = self._query(query)
- 164 self._executed = query
- 165 return result
- /usr/local/lib/python3.6/dist-packages/pymysql/cursors.py in _query(self, q)
- 319 self._last_executed = q
- 320 self._clear_result()
- --> 321 conn.query(q)
- 322 self._do_get_result()
- 323 return self.rowcount
- /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in query(self, sql, unbuffered)
- 503 sql = sql.encode(self.encoding, 'surrogateescape')
- 504 self._execute_command(COMMAND.COM_QUERY, sql)
- --> 505 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- 506 return self._affected_rows
- 507
- /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in _read_query_result(self, unbuffered)
- 722 else:
- 723 result = MySQLResult(self)
- --> 724 result.read()
- 725 self._result = result
- 726 if result.server_status is not None:
- /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in read(self)
- 1074 self._read_load_local_packet(first_packet)
- 1075 else:
- -> 1076 self._read_result_packet(first_packet)
- 1077 finally:
- 1078 self.connection = None
- /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in _read_result_packet(self, first_packet)
- 1144 self.field_count = first_packet.read_length_encoded_integer()
- 1145 self._get_descriptions()
- -> 1146 self._read_rowdata_packet()
- 1147
- 1148 def _read_rowdata_packet_unbuffered(self):
- /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in _read_rowdata_packet(self)
- 1178 rows = []
- 1179 while True:
- -> 1180 packet = self.connection._read_packet()
- 1181 if self._check_packet_is_eof(packet):
- 1182 self.connection = None # release reference to kill cyclic reference.
- /usr/local/lib/python3.6/dist-packages/pymysql/connections.py in _read_packet(self, packet_type)
- 674 if self._result is not None and self._result.unbuffered_active is True:
- 675 self._result.unbuffered_active = False
- --> 676 packet.raise_for_error()
- 677 return packet
- 678
- /usr/local/lib/python3.6/dist-packages/pymysql/protocol.py in raise_for_error(self)
- 221 errno = self.read_uint16()
- 222 if DEBUG: print("errno =", errno)
- --> 223 err.raise_mysql_exception(self._data)
- 224
- 225 def dump(self):
- /usr/local/lib/python3.6/dist-packages/pymysql/err.py in raise_mysql_exception(data)
- 105 if errorclass is None:
- 106 errorclass = InternalError if errno < 1000 else OperationalError
- --> 107 raise errorclass(errno, errval)
- InternalError: (3, "Error writing file '/rdsdbdata/tmp/MYuRQnWS' (Errcode: 28 - No space left on device)")
Add Comment
Please, Sign In to add comment