xwiki schema update failure
I've been running xwiki for ages and ages but suddenly it's gone down the pan! It was loading some pages and not others. So I restarted Tomcat and now it never starts: 11:29:26,386 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:177 - Schema update for wiki xwiki 11:29:26,681 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:240 - Failed updating schema: Got error 127 from table handler 11:29:36,548 WARN http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:71 - SQL Error: 1030, SQLState: HY000 11:29:36,550 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:72 - Got error 127 from table handler is there any reason it would want to start updating a schema? thanks, Alistair
hi, which version of XWiki you are running? Have you take a look at the integrity of your database? You use Mysql? Have you upgraded? Jérémi On 4/6/06, Alistair Young <alistair@smo.uhi.ac.uk> wrote:
I've been running xwiki for ages and ages but suddenly it's gone down the pan!
It was loading some pages and not others. So I restarted Tomcat and now it never starts:
11:29:26,386 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:177 - Schema update for wiki xwiki 11:29:26,681 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:240 - Failed updating schema: Got error 127 from table handler 11:29:36,548 WARN http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:71 - SQL Error: 1030, SQLState: HY000 11:29:36,550 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:72 - Got error 127 from table handler
is there any reason it would want to start updating a schema?
thanks,
Alistair
-- You receive this message as a subscriber of the xwiki-dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 Project Manager XWiki: http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23@gmail.com
I'm running 0.9.840 - using Mysql. The database hasn't been touched in ages.
Have you upgraded? no - the schema is different on the svn version and I couldn't find any info on what the changes were.
Alistair On 6 Apr 2006, at 12:14, jeremi joslin wrote:
hi, which version of XWiki you are running? Have you take a look at the integrity of your database? You use Mysql?
Have you upgraded?
Jérémi
On 4/6/06, Alistair Young <alistair@smo.uhi.ac.uk> wrote:
I've been running xwiki for ages and ages but suddenly it's gone down the pan!
It was loading some pages and not others. So I restarted Tomcat and now it never starts:
11:29:26,386 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:177 - Schema update for wiki xwiki 11:29:26,681 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:240 - Failed updating schema: Got error 127 from table handler 11:29:36,548 WARN http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:71 - SQL Error: 1030, SQLState: HY000 11:29:36,550 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:72 - Got error 127 from table handler
is there any reason it would want to start updating a schema?
thanks,
Alistair
-- You receive this message as a subscriber of the xwiki- dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http:// www.objectweb.org/wws
-- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 Project Manager XWiki: http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23@gmail.com
-- You receive this message as a subscriber of the xwiki- dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws
hi, have you checked your db ? $ mysqlcheck xwiki -uxwiki -pxwiki ... $ On 4/6/06, Alistair Young <alistair@smo.uhi.ac.uk> wrote:
I'm running 0.9.840 - using Mysql. The database hasn't been touched in ages.
Have you upgraded? no - the schema is different on the svn version and I couldn't find any info on what the changes were.
Alistair
On 6 Apr 2006, at 12:14, jeremi joslin wrote:
hi, which version of XWiki you are running? Have you take a look at the integrity of your database? You use Mysql?
Have you upgraded?
Jérémi
On 4/6/06, Alistair Young <alistair@smo.uhi.ac.uk> wrote:
I've been running xwiki for ages and ages but suddenly it's gone down the pan!
It was loading some pages and not others. So I restarted Tomcat and now it never starts:
11:29:26,386 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:177 - Schema update for wiki xwiki 11:29:26,681 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:240 - Failed updating schema: Got error 127 from table handler 11:29:36,548 WARN http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:71 - SQL Error: 1030, SQLState: HY000 11:29:36,550 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:72 - Got error 127 from table handler
is there any reason it would want to start updating a schema?
thanks,
Alistair
-- You receive this message as a subscriber of the xwiki- dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http:// www.objectweb.org/wws
-- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 Project Manager XWiki: http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23@gmail.com
-- You receive this message as a subscriber of the xwiki- dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws
-- You receive this message as a subscriber of the xwiki-dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 Project Manager XWiki: http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23@gmail.com
thanks for the pointer - yep db is stuffed! - will try to fix it guanxi_xwiki.xwikidoc warning : Table is marked as crashed warning : 3 clients are using or haven't closed the table properly warning : Size of datafile is: 5869568 Should be: 5869560 error : Recordlink that points outside datafile at 158716 error : Corrupt thanks, Alistair On 6 Apr 2006, at 12:48, jeremi joslin wrote:
hi,
have you checked your db ?
$ mysqlcheck xwiki -uxwiki -pxwiki ... $
On 4/6/06, Alistair Young <alistair@smo.uhi.ac.uk> wrote:
I'm running 0.9.840 - using Mysql. The database hasn't been touched in ages.
Have you upgraded? no - the schema is different on the svn version and I couldn't find any info on what the changes were.
Alistair
On 6 Apr 2006, at 12:14, jeremi joslin wrote:
hi, which version of XWiki you are running? Have you take a look at the integrity of your database? You use Mysql?
Have you upgraded?
Jérémi
On 4/6/06, Alistair Young <alistair@smo.uhi.ac.uk> wrote:
I've been running xwiki for ages and ages but suddenly it's gone down the pan!
It was loading some pages and not others. So I restarted Tomcat and now it never starts:
11:29:26,386 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/ xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:177 - Schema update for wiki xwiki 11:29:26,681 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/ xwiki/ bin/view/Main/WebHome XWikiHibernateStore:updateSchema:240 - Failed updating schema: Got error 127 from table handler 11:29:36,548 WARN http-80-Processor24 http://guanxi.uhi.ac.uk/ xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:71 - SQL Error: 1030, SQLState: HY000 11:29:36,550 ERROR http-80-Processor24 http://guanxi.uhi.ac.uk/ xwiki/ bin/view/Main/WebHome JDBCExceptionReporter:logExceptions:72 - Got error 127 from table handler
is there any reason it would want to start updating a schema?
thanks,
Alistair
-- You receive this message as a subscriber of the xwiki- dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http:// www.objectweb.org/wws
-- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 Project Manager XWiki: http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23@gmail.com
-- You receive this message as a subscriber of the xwiki- dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws
-- You receive this message as a subscriber of the xwiki- dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http:// www.objectweb.org/wws
-- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 Project Manager XWiki: http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23@gmail.com
-- You receive this message as a subscriber of the xwiki- dev@objectweb.org mailing list. To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws
participants (2)
-
Alistair Young -
jeremi joslin