Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
dahjelle opened this issue Sep 9, 2015 · 8 comments
Open

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

dahjelle opened this issue Sep 9, 2015 · 8 comments

Comments

@dahjelle
Copy link

dahjelle commented Sep 9, 2015

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?
@Nabellaleen
Copy link

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

@dahjelle
Copy link
Author

@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?

@Nabellaleen
Copy link

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 ?

@df1
Copy link

df1 commented Sep 16, 2015

Same in RHEL5 + MariaDB

@X41
Copy link

X41 commented Sep 17, 2015

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

@manish0109
Copy link

I installed it on MacOS and everything worked fine

@almereyda
Copy link

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.

@X41
Copy link

X41 commented Dec 6, 2015

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

@whackpadimportbot whackpadimportbot mentioned this issue Jan 8, 2017
Open
@nikosprodro nikosprodro mentioned this issue Mar 30, 2017
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
6 participants
@dahjelle @df1 @almereyda @X41 @manish0109 @Nabellaleen