Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 11 Apr 2013 10:30:50 +0200
From:      Baptiste Daroussin <bapt@freebsd.org>
To:        "Eggert, Lars" <lars@netapp.com>
Cc:        "current@freebsd.org" <current@freebsd.org>
Subject:   Re: newnfs pkgng database corruption?
Message-ID:  <20130411083050.GD95891@ithaqua.etoilebsd.net>
In-Reply-To: <33784095-E88E-4069-84E9-3A477483EC2E@netapp.com>
References:  <4C9A5BAE-8607-4E3A-8E69-E3993EA9873F@netapp.com> <20130410080228.GB74304@ithaqua.etoilebsd.net> <2F60DB6E-768F-426C-9BE6-737B144D4776@netapp.com> <20130410221652.GB95891@ithaqua.etoilebsd.net> <33784095-E88E-4069-84E9-3A477483EC2E@netapp.com>

next in thread | previous in thread | raw e-mail | index | archive | help

--tNQTSEo8WG/FKZ8E
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Apr 11, 2013 at 05:52:52AM +0000, Eggert, Lars wrote:
> Hi,
>=20
> On Apr 11, 2013, at 0:16, Baptiste Daroussin <bapt@freebsd.org> wrote:
> > Will you be able to test it?
>=20
> yes. (But I will be traveling for the next two weeks and so the turnaroun=
d may be a bit longer than normal.)
>=20
> Lars

First, I think you can recover your database.

Can you try the following command:

# mv /var/db/pkg/local.sqlite /var/db/pkg/backup.sqlite
# echo '.dump' | pkg shell /var/db/pkg/backup.sqlite | pkg shell
# echo 'pragma user_config=3D12;' | pkg shell

This should give you again a working database I hope :)

I think the corruption you get are due to the synchronous pragma. I need to=
 dig
in that direction.

regards,
Bapt

--tNQTSEo8WG/FKZ8E
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (FreeBSD)

iEYEARECAAYFAlFmdLoACgkQ8kTtMUmk6EyyiACfXxz7JotkRRDyLHedE4iOmMbT
T4gAmwVK1rKM8pRwUP1rqKvB/K3GnqLA
=GYpY
-----END PGP SIGNATURE-----

--tNQTSEo8WG/FKZ8E--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20130411083050.GD95891>