From: John Stile
Date: October 29 2004 10:23pm
Subject: need to drop a table twice
List-Archive: http://lists.mysql.com/cluster/1008
Message-Id: <1099088604.3761.1439.camel@johns2.stilen.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-ZASxD5XfSEcvtDTy484W"

--=-ZASxD5XfSEcvtDTy484W
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Using mysql-max-4.1.7-pc-linux-i686 on Debian stable, 2GB RAM, with dual
2.4G Xeon, running MGM, NDB, and API with 2 replicas.

When dropping a database, first attempt reports error 17, but second
attempt reports dropped.  Is this normal or a bug?  Is there a special
flag to mysqladmin or a special version for clusters?  After the first
attempt, all tables in the database are dropped from all members of the
cluster, but the database remains on all nodes.  The second attempt
removes the database from the API node it was run from.

perror 17
   Error code  17:  File exists

mysqladmin -u root -p31nux4u drop somedomain_com_messenger

    mysqladmin: DROP DATABASE somedomain_com_messenger failed;
    error: 'Error dropping database (can't rmdir './somedomain_com_messenge=
r/', errno: 17)'
mysqladmin -u root -p31nux4u drop somedomain_com_messenger=20
 =20
    Database "somedomain_com_messenger" dropped
--=20
._____________________.
|   \0/    John Stile |
| UniX Administration |
|   / \  510-305-3800 |    =20
|     john@stripped |
.---------------------.

--=-ZASxD5XfSEcvtDTy484W
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBBgsLcoiuA4LhjdrQRAlljAJ96O/7llEKNuYixrHxJrVWSNpGcxQCglzWp
LpjXwTLrfgmSJDioqzkhulo=
=X2Gs
-----END PGP SIGNATURE-----

--=-ZASxD5XfSEcvtDTy484W--