【产品名称】oceanbase-ce
【产品版本】3.1.2
【问题描述】两个问题:
1.执行查询报错:Over tenant memory limits
caused by: java.sql.SQLException: Over tenant memory limits at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:716) … 46 more
2.随后重启集群,重启数十分钟后失败,再次重启OK,但数据库不能连接
重启集群是,在wait for observer ini \ 等待时间较长,数十分钟,且启动失败
重启日志:
[2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] Traceback (most recent call last): [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “core.py”, line 1439, in restart_cluster [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “core.py”, line 1073, in start_cluster [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “_plugin.py”, line 235, in __call__ [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “_plugin.py”, line 209, in _new_func [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “/home/admin/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 64, in connect [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] db, cursor = _connect(server.ip, server_config[‘mysql_port’], password if password is not None else ‘’) [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “/home/admin/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 41, in _connect [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] db = mysql.connect(host=ip, user=user, port=int(port), password=str(password), cursorclass=mysql.cursors.DictCursor) [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 353, in __init__ [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] self.connect() [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 633, in connect [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] self._request_authentication() [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 907, in _request_authentication [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] auth_packet = self._read_packet() [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 725, in _read_packet [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] packet.raise_for_error() [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “/usr/obd/lib/site-packages/pymysql/protocol.py”, line 221, in raise_for_error [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] err.raise_mysql_exception(self._data) [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] File “/usr/obd/lib/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] raise errorclass(errno, errval) [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR] pymysql.err.OperationalError: (1045, “Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)”) [2022-01-14 10:41:52] [7cd38a0c-74e3-11ec-a20d-6c4b90ecdaef] [ERROR]