X-Original-To: alpine-infra@alpinelinux.org Delivered-To: alpine-infra@mail.alpinelinux.org Received: from mail.wtbts.no (mail.wtbts.no [213.234.126.131]) by mail.alpinelinux.org (Postfix) with ESMTP id 75BA3DC00C4 for ; Wed, 11 Jan 2012 13:02:51 +0000 (UTC) Received: from localhost (bsna.nor.wtbts.net [127.0.0.1]) by mail.wtbts.no (Postfix) with ESMTP id 1894DAE4003 for ; Wed, 11 Jan 2012 13:02:50 +0000 (UTC) X-Virus-Scanned: Yes Received: from mail.wtbts.no ([127.0.0.1]) by localhost (bsna.nor.wtbts.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id AD1bo3nYjlQG for ; Wed, 11 Jan 2012 13:02:49 +0000 (UTC) Received: from mail.ytre.org (extmail.nor.wtbts.net [10.65.72.14]) by mail.wtbts.no (Postfix) with ESMTP id 45AE4376267 for ; Wed, 11 Jan 2012 13:02:49 +0000 (UTC) Received: from mail.ytre.org (localhost [127.0.0.1]) by mail.ytre.org (Postfix) with ESMTP id 0ED0060A7A673 for ; Wed, 11 Jan 2012 13:02:49 +0000 (UTC) Received: from ncopa-desktop.nor.wtbts.net (ncopa-desktop.nor.wtbts.net [10.65.65.1]) (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: ncopa@ytre.org) by mail.ytre.org (Postfix) with ESMTPSA id E7B4360A86A63 for ; Wed, 11 Jan 2012 13:02:48 +0000 (UTC) Date: Wed, 11 Jan 2012 14:02:48 +0100 From: Natanael Copa To: alpine-infra@alpinelinux.org Subject: Re: Bugs.a.o Message-ID: <20120111140248.435971dc@ncopa-desktop.nor.wtbts.net> In-Reply-To: References: <4F0C8B9E.40808@nothome.org> <2B149571-CAE6-463D-BDD7-EE2CA5B74977@gmail.com> X-Mailer: Claws Mail 3.8.0 (GTK+ 2.24.6; x86_64-unknown-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: ClamAV using ClamSMTP On Wed, 11 Jan 2012 01:34:30 +0100 Carlo Landmeter wrote: > Im not able to bring it back online. I'm trying with ubuntu and start > the db (same version) but mysql crashes again. >=20 > If somebody else wants to take a look? im going to bed. Me and clandmeter got bugs.a.o back online. Here is what i did: * copied /var/lib/mysql to /var/lib/mysql.try1 in case someone had made parital progress. * remove /var/lib/mysql and copied over /var/lib/mysql.bak to /var/lib/mysql (this i did various times) * tried to start with different innodb_force_recovery settings in /etc/mysql/my.cnf * tried to remove parts of /var/lib/mysql/* dirs to try to disable single databases (in case it was only one database was broke) Nothing worked. Then i saw that disk usage was 97%. I increased the /vservers partition from 60G to 70G (thanks to who ever set up the LVM!) and resizefs'ed it. I removed my mysql.try1 and the ubuntu vserver /var/lib/mysql to free up some space. After that the database started up with innodb_force_recovery=3D6 and clandmeter was able to mysqldump out the alpine-bugs database. =46rom there clandmeter took over. I think he restored the alpine-bugs some other place and pointed redmine to there. -nc