Still having an odd problem migrating to NoSQL. I get an error:
java.sql.SQLException: Error writing file '/tmp/MYiO9VmW' (Errcode: 28 "No space left on device")
But /tmp is not full:
$ df -h /tmp; df -i /tmp
Filesystem Size Used Avail Use% Mounted on
tmpfs 503M 36K 503M 1% /tmp
Filesystem Inodes IUsed IFree IUse% Mounted on
tmpfs 128614 25 128589 1% /tmp
The long contains this information:
ERROR 2017-12-05T20:48:31,566 (com.infiniteautomation.nosql.maint.GenericSqlPointValueDao.query:365) - Error writing file '/tmp/MYiO9VmW' (Errcode: 28 "No space left on device")
java.sql.SQLException: Error writing file '/tmp/MYiO9VmW' (Errcode: 28 "No space left on device")
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.26.jar:?]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) ~[mysql-connector-java-5.1.26.jar:?]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) ~[mysql-connector-java-5.1.26.jar:?]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) ~[mysql-connector-java-5.1.26.jar:?]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) ~[mysql-connector-java-5.1.26.jar:?]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) ~[mysql-connector-java-5.1.26.jar:?]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761) ~[mysql-connector-java-5.1.26.jar:?]
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612) ~[mysql-connector-java-5.1.26.jar:?]
at com.infiniteautomation.nosql.maint.GenericSqlPointValueDao.query(GenericSqlPointValueDao.java:357) [mangoNoSqlDatabase-3.2.3.jar:?]
at com.infiniteautomation.nosql.maint.GenericSqlPointValueDao.getPointValuesBetween(GenericSqlPointValueDao.java:230) [mangoNoSqlDatabase-3.2.3.jar:?]
at com.infiniteautomation.nosql.maint.MangoNoSqlMigrationWorkItem.execute(MangoNoSqlMigrationWorkItem.java:150) [mangoNoSqlDatabase-3.2.3.jar:?]
at com.serotonin.m2m2.rt.maint.BackgroundProcessing$RejectableWorkItemRunnable.run(BackgroundProcessing.java:556) [mango-3.2.2.jar:?]
at com.serotonin.timer.Task.runTask(Task.java:179) [mango-3.2.2.jar:?]
at com.serotonin.timer.TaskWrapper.run(TaskWrapper.java:23) [mango-3.2.2.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
That suggests a Mariadb/MySQL issue, but it's on a different volume, with plenty of space as well.
I've tried running with "Maximum point value queue size" as low as 1000, but it still fails on this "No space left on device" error, which halts the migration process.
Out of ideas to try.
Aldo