hackpad icon indicating copy to clipboard operation
hackpad copied to clipboard
verified publisher icon dropbox

`Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it` during `bin/run.sh`

Open dahjelle opened this issue 10 years ago • 8 comments

I've been generally following this guide for installing hackpad on CentOS to install it on my Fedora box. Everything seems fine except for getting a Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it error during bin/run.sh.

Everything I've read seems to indicate this is either a probably with not enough disk space or with a corrupted table, but I have both plenty of free space and trying to repair that table doesn't work.

Thoughts?

dahjelle avatar Sep 09 '15 16:09 dahjelle

Same problem for me ...

It happens during :

performing database migration: [rename-pro-users-table]
info: 2015-09-11 10:15:05.314+0200  migration completed in 310ms
info: 2015-09-11 10:15:05.348+0200  performing database migration: [rename-pro-users-table]
Startup execution failed with non-200 response: 500

Full Traceback is :

net.appjet.bodylock.JSRuntimeException: Error while executing: Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it
    at net.appjet.bodylock.InnerExecutable.execute(bodylock.scala:84)
    at net.appjet.oui.execution$$anonfun$execute$4.apply(execution.scala:517)
    at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
    at net.appjet.oui.ExecutionContextUtils$.withContext(execution.scala:340)
    at net.appjet.oui.execution$.execute(execution.scala:513)
    at net.appjet.oui.execution$.runOutOfBand(execution.scala:640)
    at net.appjet.oui.main$.runOnStartup(main.scala:114)
    at net.appjet.oui.main$.main(main.scala:292)
    at net.appjet.oui.main.main(main.scala)
Caused by: java.sql.SQLException: Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
    at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
    at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
    at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
    at JS$module$sqlbase$sqlobj$js$10._c_anonymous_10(module sqlbase/sqlobj.js:92)
    at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
    at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
    at JS$module$sqlbase$sqlcommon$js$13._c_closing_7(module sqlbase/sqlcommon.js:72)
    at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
    at JS$module$sqlbase$sqlobj$js$10._c_anonymous_9(module sqlbase/sqlobj.js:90)
    at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
    at org.mozilla.javascript.JavaAdapter.doCall(JavaAdapter.java:598)
    at org.mozilla.javascript.JavaAdapter.callMethod(JavaAdapter.java:573)
    at adapter4.apply(<adapter>)
    at net.appjet.ajstdlib.SQLBase.withConnection(sqlbase.scala:92)
    at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
    at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
    at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
    at JS$module$sqlbase$sqlcommon$js$13._c_withConnection_5(module sqlbase/sqlcommon.js:60)
    at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
    at JS$module$sqlbase$sqlobj$js$10._c__execute_8(module sqlbase/sqlobj.js:88)
    at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
    at JS$module$sqlbase$sqlobj$js$10._c__executeUpdate_11(module sqlbase/sqlobj.js:98)
    at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
    at JS$module$sqlbase$sqlobj$js$10._c_changeColumn_78(module sqlbase/sqlobj.js:661)
    at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:86)
    at JS$module$etherpad$db$migrations$m0025$rename$pro$users$table$js$164._c_run_1(module etherpad/db_migrations/m0025_rename_pro_users_table.js:23)
    at JS$module$etherpad$db$migrations$m0025$rename$pro$users$table$js$164.call(module etherpad/db_migrations/m0025_rename_pro_users_table.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
    at JS$module$etherpad$db$migrations$migration$runner$js$140._c_anonymous_9(module etherpad/db_migrations/migration_runner.js:173)
    at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
    at org.mozilla.javascript.JavaAdapter.doCall(JavaAdapter.java:598)
    at org.mozilla.javascript.JavaAdapter.callMethod(JavaAdapter.java:573)
    at adapter2.apply(<adapter>)
    at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1$$anonfun$apply$10.apply(sqlbase.scala:121)
    at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
    at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1.apply(sqlbase.scala:116)
    at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1.apply(sqlbase.scala:112)
    at net.appjet.ajstdlib.SQLBase$$anonfun$withConnection$1.apply(sqlbase.scala:100)
    at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
    at net.appjet.ajstdlib.SQLBase.withConnection(sqlbase.scala:99)
    at net.appjet.ajstdlib.SQLBase.inTransaction(sqlbase.scala:112)
    at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
    at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
    at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
    at JS$module$sqlbase$sqlcommon$js$13._c_inTransaction_6(module sqlbase/sqlcommon.js:64)
    at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
    at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
    at JS$module$etherpad$db$migrations$migration$runner$js$140._c_anonymous_8(module etherpad/db_migrations/migration_runner.js:169)
    at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
    at org.mozilla.javascript.NativeArray.iterativeMethod(NativeArray.java:1563)
    at org.mozilla.javascript.NativeArray.execIdCall(NativeArray.java:345)
    at org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:129)
    at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
    at JS$module$etherpad$db$migrations$migration$runner$js$140._c_runMigrations_7(module etherpad/db_migrations/migration_runner.js:166)
    at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
    at JS$module$etherpad$db$migrations$migration$runner$js$140._c_onStartup_3(module etherpad/db_migrations/migration_runner.js:142)
    at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
    at JS$module$main$js$139._c_anonymous_1(module main.js:108)
    at JS$module$main$js$139.call(module main.js)
    at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
    at JS$module$onstartup$js$1._c_script_0(module onstartup.js:18)
    at JS$module$onstartup$js$1.call(module onstartup.js)
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:426)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3178)
    at JS$module$onstartup$js$1.call(module onstartup.js)
    at JS$module$onstartup$js$1.exec(module onstartup.js)
    at net.appjet.bodylock.InnerExecutable$$anonfun$execute$1.apply(bodylock.scala:76)
    at net.appjet.bodylock.InnerExecutable$$anonfun$execute$1.apply(bodylock.scala:75)
    at net.appjet.bodylock.BodyLock$.runInContext(bodylock.scala:111)
    at net.appjet.bodylock.InnerExecutable.execute(bodylock.scala:75)
    ... 8 more

and

exception: 2015-09-11 10:08:26.080+0200 net.appjet.bodylock.JSRuntimeException: Error while executing: Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it
exception:  at net.appjet.bodylock.InnerExecutable.execute(bodylock.scala:84)
exception:  at net.appjet.oui.execution$$anonfun$execute$4.apply(execution.scala:517)
exception:  at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
exception:  at net.appjet.oui.ExecutionContextUtils$.withContext(execution.scala:340)
exception:  at net.appjet.oui.execution$.execute(execution.scala:513)
exception:  at net.appjet.oui.execution$.runOutOfBand(execution.scala:640)
exception:  at net.appjet.oui.main$.runOnStartup(main.scala:114)
exception:  at net.appjet.oui.main$.main(main.scala:292)
exception:  at net.appjet.oui.main.main(main.scala)
exception: Caused by: java.sql.SQLException: Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it
exception:  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
exception:  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
exception:  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
exception:  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
exception:  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
exception:  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
exception:  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
exception:  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
exception:  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077)
exception:  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062)
exception:  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
exception:  at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
exception:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
exception:  at java.lang.reflect.Method.invoke(Method.java:606)
exception:  at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
exception:  at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
exception:  at JS$module$sqlbase$sqlobj$js$10._c_anonymous_10(module sqlbase/sqlobj.js:92)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
exception:  at JS$module$sqlbase$sqlcommon$js$13._c_closing_7(module sqlbase/sqlcommon.js:72)
exception:  at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
exception:  at JS$module$sqlbase$sqlobj$js$10._c_anonymous_9(module sqlbase/sqlobj.js:90)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.JavaAdapter.doCall(JavaAdapter.java:598)
exception:  at org.mozilla.javascript.JavaAdapter.callMethod(JavaAdapter.java:573)
exception:  at adapter4.apply(<adapter>)
exception:  at net.appjet.ajstdlib.SQLBase.withConnection(sqlbase.scala:92)
exception:  at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
exception:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
exception:  at java.lang.reflect.Method.invoke(Method.java:606)
exception:  at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
exception:  at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
exception:  at JS$module$sqlbase$sqlcommon$js$13._c_withConnection_5(module sqlbase/sqlcommon.js:60)
exception:  at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
exception:  at JS$module$sqlbase$sqlobj$js$10._c__execute_8(module sqlbase/sqlobj.js:88)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
exception:  at JS$module$sqlbase$sqlobj$js$10._c__executeUpdate_11(module sqlbase/sqlobj.js:98)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
exception:  at JS$module$sqlbase$sqlobj$js$10._c_changeColumn_78(module sqlbase/sqlobj.js:661)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:86)
exception:  at JS$module$etherpad$db$migrations$m0025$rename$pro$users$table$js$164._c_run_1(module etherpad/db_migrations/m0025_rename_pro_users_table.js:23)
exception:  at JS$module$etherpad$db$migrations$m0025$rename$pro$users$table$js$164.call(module etherpad/db_migrations/m0025_rename_pro_users_table.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140._c_anonymous_9(module etherpad/db_migrations/migration_runner.js:173)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
exception:  at org.mozilla.javascript.JavaAdapter.doCall(JavaAdapter.java:598)
exception:  at org.mozilla.javascript.JavaAdapter.callMethod(JavaAdapter.java:573)
exception:  at adapter2.apply(<adapter>)
exception:  at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1$$anonfun$apply$10.apply(sqlbase.scala:121)
exception:  at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
exception:  at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1.apply(sqlbase.scala:116)
exception:  at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1.apply(sqlbase.scala:112)
exception:  at net.appjet.ajstdlib.SQLBase$$anonfun$withConnection$1.apply(sqlbase.scala:100)
exception:  at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
exception:  at net.appjet.ajstdlib.SQLBase.withConnection(sqlbase.scala:99)
exception:  at net.appjet.ajstdlib.SQLBase.inTransaction(sqlbase.scala:112)
exception:  at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
exception:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
exception:  at java.lang.reflect.Method.invoke(Method.java:606)
exception:  at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
exception:  at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
exception:  at JS$module$sqlbase$sqlcommon$js$13._c_inTransaction_6(module sqlbase/sqlcommon.js:64)
exception:  at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140._c_anonymous_8(module etherpad/db_migrations/migration_runner.js:169)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
exception:  at org.mozilla.javascript.NativeArray.iterativeMethod(NativeArray.java:1563)
exception:  at org.mozilla.javascript.NativeArray.execIdCall(NativeArray.java:345)
exception:  at org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:129)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140._c_runMigrations_7(module etherpad/db_migrations/migration_runner.js:166)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140._c_onStartup_3(module etherpad/db_migrations/migration_runner.js:142)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
exception:  at JS$module$main$js$139._c_anonymous_1(module main.js:108)
exception:  at JS$module$main$js$139.call(module main.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
exception:  at JS$module$onstartup$js$1._c_script_0(module onstartup.js:18)
exception:  at JS$module$onstartup$js$1.call(module onstartup.js)
exception:  at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:426)
exception:  at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3178)
exception:  at JS$module$onstartup$js$1.call(module onstartup.js)
exception:  at JS$module$onstartup$js$1.exec(module onstartup.js)
exception:  at net.appjet.bodylock.InnerExecutable$$anonfun$execute$1.apply(bodylock.scala:76)
exception:  at net.appjet.bodylock.InnerExecutable$$anonfun$execute$1.apply(bodylock.scala:75)
exception:  at net.appjet.bodylock.BodyLock$.runInContext(bodylock.scala:111)
exception:  at net.appjet.bodylock.InnerExecutable.execute(bodylock.scala:75)
exception:  ... 8 more
exception:  net.appjet.bodylock.JSRuntimeException: Error while executing: Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it
exception:  at net.appjet.bodylock.InnerExecutable.execute(bodylock.scala:84)
exception:  at net.appjet.oui.execution$$anonfun$execute$4.apply(execution.scala:517)
exception:  at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
exception:  at net.appjet.oui.ExecutionContextUtils$.withContext(execution.scala:340)
exception:  at net.appjet.oui.execution$.execute(execution.scala:513)
exception:  at net.appjet.oui.execution$.runOutOfBand(execution.scala:640)
exception:  at net.appjet.oui.main$.runOnStartup(main.scala:114)
exception:  at net.appjet.oui.main$.main(main.scala:292)
exception:  at net.appjet.oui.main.main(main.scala)
exception: Caused by: java.sql.SQLException: Incorrect key file for table 'pro_accounts_auto_signin'; try to repair it
exception:  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
exception:  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
exception:  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
exception:  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
exception:  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
exception:  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
exception:  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
exception:  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
exception:  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077)
exception:  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062)
exception:  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
exception:  at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
exception:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
exception:  at java.lang.reflect.Method.invoke(Method.java:606)
exception:  at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
exception:  at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
exception:  at JS$module$sqlbase$sqlobj$js$10._c_anonymous_10(module sqlbase/sqlobj.js:92)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
exception:  at JS$module$sqlbase$sqlcommon$js$13._c_closing_7(module sqlbase/sqlcommon.js:72)
exception:  at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
exception:  at JS$module$sqlbase$sqlobj$js$10._c_anonymous_9(module sqlbase/sqlobj.js:90)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.JavaAdapter.doCall(JavaAdapter.java:598)
exception:  at org.mozilla.javascript.JavaAdapter.callMethod(JavaAdapter.java:573)
exception:  at adapter4.apply(<adapter>)
exception:  at net.appjet.ajstdlib.SQLBase.withConnection(sqlbase.scala:92)
exception:  at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
exception:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
exception:  at java.lang.reflect.Method.invoke(Method.java:606)
exception:  at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
exception:  at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
exception:  at JS$module$sqlbase$sqlcommon$js$13._c_withConnection_5(module sqlbase/sqlcommon.js:60)
exception:  at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
exception:  at JS$module$sqlbase$sqlobj$js$10._c__execute_8(module sqlbase/sqlobj.js:88)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
exception:  at JS$module$sqlbase$sqlobj$js$10._c__executeUpdate_11(module sqlbase/sqlobj.js:98)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)
exception:  at JS$module$sqlbase$sqlobj$js$10._c_changeColumn_78(module sqlbase/sqlobj.js:661)
exception:  at JS$module$sqlbase$sqlobj$js$10.call(module sqlbase/sqlobj.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:86)
exception:  at JS$module$etherpad$db$migrations$m0025$rename$pro$users$table$js$164._c_run_1(module etherpad/db_migrations/m0025_rename_pro_users_table.js:23)
exception:  at JS$module$etherpad$db$migrations$m0025$rename$pro$users$table$js$164.call(module etherpad/db_migrations/m0025_rename_pro_users_table.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140._c_anonymous_9(module etherpad/db_migrations/migration_runner.js:173)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
exception:  at org.mozilla.javascript.JavaAdapter.doCall(JavaAdapter.java:598)
exception:  at org.mozilla.javascript.JavaAdapter.callMethod(JavaAdapter.java:573)
exception:  at adapter2.apply(<adapter>)
exception:  at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1$$anonfun$apply$10.apply(sqlbase.scala:121)
exception:  at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
exception:  at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1.apply(sqlbase.scala:116)
exception:  at net.appjet.ajstdlib.SQLBase$$anonfun$inTransaction$1.apply(sqlbase.scala:112)
exception:  at net.appjet.ajstdlib.SQLBase$$anonfun$withConnection$1.apply(sqlbase.scala:100)
exception:  at net.appjet.oui.NoninheritedDynamicVariable.withValue(dynamicvar.scala:38)
exception:  at net.appjet.ajstdlib.SQLBase.withConnection(sqlbase.scala:99)
exception:  at net.appjet.ajstdlib.SQLBase.inTransaction(sqlbase.scala:112)
exception:  at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
exception:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
exception:  at java.lang.reflect.Method.invoke(Method.java:606)
exception:  at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
exception:  at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
exception:  at JS$module$sqlbase$sqlcommon$js$13._c_inTransaction_6(module sqlbase/sqlcommon.js:64)
exception:  at JS$module$sqlbase$sqlcommon$js$13.call(module sqlbase/sqlcommon.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140._c_anonymous_8(module etherpad/db_migrations/migration_runner.js:169)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
exception:  at org.mozilla.javascript.NativeArray.iterativeMethod(NativeArray.java:1563)
exception:  at org.mozilla.javascript.NativeArray.execIdCall(NativeArray.java:345)
exception:  at org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:129)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140._c_runMigrations_7(module etherpad/db_migrations/migration_runner.js:166)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140._c_onStartup_3(module etherpad/db_migrations/migration_runner.js:142)
exception:  at JS$module$etherpad$db$migrations$migration$runner$js$140.call(module etherpad/db_migrations/migration_runner.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
exception:  at JS$module$main$js$139._c_anonymous_1(module main.js:108)
exception:  at JS$module$main$js$139.call(module main.js)
exception:  at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
exception:  at JS$module$onstartup$js$1._c_script_0(module onstartup.js:18)
exception:  at JS$module$onstartup$js$1.call(module onstartup.js)
exception:  at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:426)
exception:  at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3178)
exception:  at JS$module$onstartup$js$1.call(module onstartup.js)
exception:  at JS$module$onstartup$js$1.exec(module onstartup.js)
exception:  at net.appjet.bodylock.InnerExecutable$$anonfun$execute$1.apply(bodylock.scala:76)
exception:  at net.appjet.bodylock.InnerExecutable$$anonfun$execute$1.apply(bodylock.scala:75)
exception:  at net.appjet.bodylock.BodyLock$.runInContext(bodylock.scala:111)
exception:  at net.appjet.bodylock.InnerExecutable.execute(bodylock.scala:75)
exception:  ... 8 more

Nabellaleen avatar Sep 11 '15 08:09 Nabellaleen

@Nabellaleen — what OS are you trying to install on? I never did figure this out, but I'm curious if it is a cross-OS issue or not. Are you using MySQL or MariaDB?

dahjelle avatar Sep 11 '15 14:09 dahjelle

Yeah, sorry to have not be more precise. I am on Fedora, with MariaDB "aliased" in mysql.

Maybe a bug specific to RedHat-like distribution, seeing you are on CentOS ?

Nabellaleen avatar Sep 11 '15 15:09 Nabellaleen

Same in RHEL5 + MariaDB

df1 avatar Sep 16 '15 07:09 df1

i assume this is only a problem with newer MariaDB versions. 10.0.21-MariaDB fails, 5.5.44-MariaDB and 5.6.26-MySQL work without any issues. I've patched the db migrations HERE and tested it successfully on all three versions.

you are gonna have to drop all tables in the DB before starting again or it'll just fail at renaming the table pro_users that has already been renamed

X41 avatar Sep 17 '15 10:09 X41

I installed it on MacOS and everything worked fine

manish0109 avatar Oct 07 '15 06:10 manish0109

I can confirm this error with mariadb:10.0.21. Using mysql helped here. @X41 Is there any information when your patch will propagate to upstream? I'm using the custom fork at https://github.com/TransforMap/hackpad and feel quite tempted to cherry-pick your contribution.

almereyda avatar Dec 06 '15 01:12 almereyda

there is no pull request because i suck at git and github tbh and i'm too lazy to check how it's done. if someone could tell me how it's done real quick i'll do it, feel free to just cherry-pick it till then

X41 avatar Dec 06 '15 06:12 X41