Tell me how to change the limit on the maximum file size of the innodb table. When the file size reaches 4 GB, the exception is "The table 'buffer' is full". And after restarting the server, it starts to fail (Shows what is running and crashes when accessing)

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1246) at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1241) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4102) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4071) at com.tetra.lib.io.db.DataBaseORM.insert(DataBaseORM.java:131) at com.tetra.lib.io.internet.TaskSend.insert(TaskSend.java:253) at com.tetra.lib.io.internet.TaskSend.run(TaskSend.java:110) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 220 milliseconds ago. The last packet sent successfully to the server was 212 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3552) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3452) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3893) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) at com.tetra.lib.io.db.buffer.MySQLJDBC.createTable(MySQLJDBC.java:71) at com.tetra.lib.io.db.buffer.MySQLJDBC.<init>(MySQLJDBC.java:64) at com.tetra.lib.io.db.DataBaseORM.createConnection(DataBaseORM.java:51) at com.tetra.lib.io.db.DataBaseORM.<init>(DataBaseORM.java:38) at com.tetra.lib.io.internet.AtlantRunnable.<init>(AtlantRunnable.java:53) at ua.tetra.atlant.monitor.controller.MainController.atlant(MainController.java:283) at ua.tetra.atlant.monitor.controller.MainController.<init>(MainController.java:94) at ua.tetra.atlant.monitor.tetra_atlant_monitor.main(tetra_atlant_monitor.java:79) Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(Unknown Source) at java.net.SocketInputStream.read(Unknown Source) at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101) at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144) at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3001) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3462) ... 16 more

I tried to change the settings

 innodb_data_file_path = ibdata1:12M:autoextend innodb_log_buffer_size=200M innodb_buffer_pool_size=1G

When setting large values, the server simply does not start. "Timeout expired"

Now I work with base using Java, JDBC. I tried to upload a dump made in macOS somewhere around 10 GB with the same error "The table 'buffer' is full"

Windows 10 32 bit.

RAM 3.25 GB. mysql 5.7.15.

I looked at the log file, the exception does not fall on all insert.

 2016-09-26T03:11:31.077085Z 11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: The table 'buffer' is full 2016-09-26T03:25:29.966517Z 11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: The table 'buffer' is full 2016-09-26T03:30:58.179531Z 11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: The table 'buffer' is full 2016-09-26T03:36:30.177381Z 11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: The table 'buffer' is full 2016-09-26T03:46:16.193598Z 11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: The table 'buffer' is full
  • Switch tables c innodb in myisam and there will be a second life. - nick_n_a
  • 2
    Your database does not accidentally lie on a partition with FAT32? - Yaant
  • I have an NTFS partition - Doom
  • Is there a lot of free disk space? You may also have a LOG overflowed, see here the last post Stephen DeGabriele. - Igor Kudryashov
  • Free space about 50gig, Set innodb_log_file_size = 900M innodb_log_buffer_size = 200M, if you install the server no longer starts - Doom

0