Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 28 Apr 2014 17:12:02 +0100
From:      Matthew Seaman <matthew@freebsd.org>
To:        freebsd-fs@freebsd.org
Subject:   File system deadlock -- postgresql related?
Message-ID:  <535E7DD2.3050600@freebsd.org>

next in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--Ae9QFTg5kUCRlpVacu9NDq5mWWmk5B4Vx
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable


Hi,

We've a FreeBSD-9.2-RELEASE-p3 server running postgresql-9.3.4 which is
giving us some problems.

I know of the performance problems with postgresql-9.3 referenced here:
http://postgresql.1045698.n5.nabble.com/Perfomance-degradation-9-3-vs-9-2=
-for-FreeBSD-td5800835.html
and also on this list.

However, we're seeing occasional system freezes for periods of maybe 5
-- 10 minutes, with many log messages like so appearing:

Apr 28 16:19:57 db-17a kernel:
g_vfs_done():mfid1p1[WRITE(offset=3D1058001420288, length=3D32768)]error =
=3D 11
Apr 28 16:19:57 db-17a kernel:
g_vfs_done():mfid1p1[WRITE(offset=3D1058001649664, length=3D32768)]error =
=3D 11
Apr 28 16:19:57 db-17a kernel:
g_vfs_done():mfid1p1[WRITE(offset=3D1058002010112, length=3D32768)]error =
=3D 11

All I can google about that problem suggests the 'error 11' is a
deadlock that occurs primarily when using disk encryption or other
setups where disk IO would be more complex than normal.  But that is
certainly not the case here --- it's a UFS2 filesystem on a hardware
RAID10 using 15k RPM SAS drives.

Any clues?  Am I correct to conclude that the mmap related performance
problem is somehow related to the g_vfs_done() log messages?

	Cheers,

	Matthew




--Ae9QFTg5kUCRlpVacu9NDq5mWWmk5B4Vx
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (FreeBSD)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQJ8BAEBCgBmBQJTXn3aXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w
ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQxOUYxNTRFQ0JGMTEyRTUwNTQ0RTNGMzAw
MDUxM0YxMEUwQTlFNEU3AAoJEABRPxDgqeTnL1kP/0DKNGlpbKg86023sH0zqjQZ
+pCnBxj2Vh5RBSdvekzKKSP1WUTkOCteGIRqabJMjuQ1barDXu5mvi9E4j+MEoHY
8HhYesVlAoyFJYzI0vbRr2clSKcsZcZcxn535QvNB1NfVhRepI/5lxeZj+yUqbN3
tBfjudtNj4aMAYVeRbQnB32CoSfYJgIjHPJCHf4TbvQOTUhTFegeFqWkF32cYDKh
f8JRKlyfRoT+LrbjWhBtxCkHn8Uoe6o4K16w8/PgTb150aPUaNJNy8NjdiHddGSA
OGXnqbz8Vv1jHM4i2avrbak6Ssc+Wcg+gwtPmB8Tfg6oKvwu2tKUbeYrPahiEt9x
zp2VssqCpyoKSPt39FYSk5bd9XIOxsWtiKsRkK6eptxzegN2taJIUaoLyiLKlcPG
VWytK5iFJQnQSUyR7vXKUs5GvUtr+VzU0ul1zTeZsXfTM+OlwVPJYGx3yxkSsbLA
1o5HpXdfi29JkGyO4f6pD8aUjGbpPENuLn5UcgkCgBm4uBFVVCnfas1JPBgf6JWG
9yOsgYHIT5mBxLN4df3rWsAxbxp3G56zdIeUUuwJVu0CGcG5s2AeioCMt8OqMnwl
rkXU3YvMqawRvcdJWDsRA49xpP0/XLh7MVfHixlnLVDwB11q16KnJLCrG2PqGNPr
tGKhXESWBMUmD/V4G6a7
=8x3a
-----END PGP SIGNATURE-----

--Ae9QFTg5kUCRlpVacu9NDq5mWWmk5B4Vx--



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