Temp file issues on Ubuntu 9.10

--------------ms030106010200060006090503
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi all,

I just recently upgraded to Ubuntu 9.10, but now I'm having all sorts of
temp file problems. For example, when I try to delete a row and violate
a contraint I get:

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails (temp file operation failed)

Instead of telling me which constraint is violated, it tells me the temp
file creation failed. I have no reason why it failed, I don't see any
error messages in the log.

To solve this problem I tried to make a tmpfs partition (I thought,
maybe somehow my using ext4 might be a problem):

mkdir /tmpfs
mount -t tmpfs -o size=1g tmpfs /tmpfs
mkdir /tmpfs/mysql
chown mysql:mysql

and changed the tmpdir in the mysql config to /tmpfs/mysql

tmpdir=/tmpfs/mysql

But then mysql fails on startup:

/usr/sbin/mysqld: Can't create/write to file '/tmpfs/mysql/ibGgjPv7'
(Errcode: 13)
091108 10:12:46 InnoDB: Error: unable to create temporary file; errno: 13
091108 10:12:46 [ERROR] Plugin 'InnoDB' init function returned error.
091108 10:12:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.

I checked error code 13, which is permission denied, but I don't
understand this, because if I change tmpdir to /tmp/mysql it does work,
and I have:

$ ls -ld /tmp/mysql
drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql

$ ls -ld /tmpfs/mysql
drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql

So I don't see the difference....

Has anyone encountered similar problems, or know what's going on here?

Best regards,
Sebastiaan


--------------ms030106010200060006090503
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJUTCC
AwMwggJsoAMCAQICEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEFBQAw YjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4x LDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDcw MTA1MjIxMVoX
DTEwMDcwMTA1MjIxMVowaDEQMA4GA1UEBBMHdmFuIEVyazETMBEGA1UEKhMK U2ViYXN0aWFh
bjEbMBkGA1UEAxMSU2ViYXN0aWFhbiB2YW4gRXJrMSIwIAYJKoZIhvcNAQkB FhNzZWJzdGVy
QHNlYnN0ZXIuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA xnkA/HlKscOk
7wNt76nwOKIIsm3qlgX3Sf3jNOl+gVBi4Fq3n5BfDR0FBj4pbiQT+Q9s2oTJ coX3/AdZuNga
UH/6+dhcyD2kxgvVK8WK41WG9WyzPkfw4M2g3e51NrEsGC+H+eMbbvlrzvPa /asUwqERy60u
6XIlj5kwO/QxHx2iJpgUFtkOYr1BSkP0FC/Qe8VbF7Fi1fu3I5Rk/+9j49OM /IBMbmEkKFoD
/e8KgyhCgREAv08/yntwHRos5m6AK27zR+4dTsbb/B8fCjRT8tttCvbo1C/U iuM7u/YcfY0d
8mLp+dRI7xpHl/9Fp86q31OmAfwD1tw9UYL1DnIbHwIDAQABozAwLjAeBgNV HREEFzAVgRNz
ZWJzdGVyQHNlYnN0ZXIuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEF BQADgYEAw63Z
9kpNbme1LCtCeAvXVM8oTGJy0L85qtbO5DUBxjmBTBMSe1Kbn160wibMP++C v1p/PwCumRbe
XjJSI3HclQasaF8FpDWtRQlHFj/w/3Q2GsBpoHxSOENjY/+jgtDTOnX5+0lP HaN/iQTAdW8+
rm0P+FIKeYRpdOjFsIoeudYwggMDMIICbKADAgECAhBi2E2zbOyC1fBY1nuI WKaQMA0GCSqG
SIb3DQEBBQUAMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29u c3VsdGluZyAo
UHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg SXNzdWluZyBD
QTAeFw0wOTA3MDEwNTIyMTFaFw0xMDA3MDEwNTIyMTFaMGgxEDAOBgNVBAQT B3ZhbiBFcmsx
EzARBgNVBCoTClNlYmFzdGlhYW4xGzAZBgNVBAMTElNlYmFzdGlhYW4gdmFu IEVyazEiMCAG
CSqGSIb3DQEJARYTc2Vic3RlckBzZWJzdGVyLmNvbTCCASIwDQYJKoZIhvcN AQEBBQADggEP
ADCCAQoCggEBAMZ5APx5SrHDpO8Dbe+p8DiiCLJt6pYF90n94zTpfoFQYuBa t5+QXw0dBQY+
KW4kE/kPbNqEyXKF9/wHWbjYGlB/+vnYXMg9pMYL1SvFiuNVhvVssz5H8ODN oN3udTaxLBgv
h/njG275a87z2v2rFMKhEcutLulyJY+ZMDv0MR8doiaYFBbZDmK9QUpD9BQv 0HvFWxexYtX7
tyOUZP/vY+PTjPyATG5hJChaA/3vCoMoQoERAL9PP8p7cB0aLOZugCtu80fu HU7G2/wfHwo0
U/LbbQr26NQv1IrjO7v2HH2NHfJi6fnUSO8aR5f/RafOqt9TpgH8A9bcPVGC 9Q5yGx8CAwEA
AaMwMC4wHgYDVR0RBBcwFYETc2Vic3RlckBzZWJzdGVyLmNvbTAMBgNVHRMB Af8EAjAAMA0G
CSqGSIb3DQEBBQUAA4GBAMOt2fZKTW5ntSwrQngL11TPKExictC/OarWzuQ1 AcY5gUwTEntS
m59etMImzD/vgr9afz8ArpkW3l4yUiNx3JUGrGhfBaQ1rUUJRxY/8P90NhrA aaB8UjhDY2P/
o4LQ0zp1+ftJTx2jf4kEwHVvPq5tD/hSCnmEaXToxbCKHrnWMIIDPzCCAqig AwIBAgIBDTAN
BgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rl cm4gQ2FwZTES
MBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGlu ZzEoMCYGA1UE
CxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMb VGhhd3RlIFBl
cnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1m cmVlbWFpbEB0
aGF3dGUuY29tMB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjEL MAkGA1UEBhMC
WkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3 DQEBAQUAA4GN
ADCBiQKBgQDEpjxVc1X7TrnKmVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph 8r9RzgHU5VAK
MNcCY1osiRVwjt3J8CuFWqo/cVbLrzwLB+fxH5E2JCoTzyvV84J3PQO+K/67 GD4Hv0CAAmTX
p6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZcmC3+wIDAQABo4GUMIGRMBIGA1Ud EwEB/wQIMAYB
Af8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0cDovL2NybC50aGF3dGUuY29t L1RoYXd0ZVBl
cnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQDAgEGMCkGA1UdEQQiMCCk HjAcMRowGAYD
VQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0BAQUFAAOBgQBIjNFQ g+oLLswNo2as
Zw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3hYWLD2ToZfoSx mRsAxRoLgnSe
JVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1TXfjViF4 gtwhGTXeJLHT
HUb/XV9lTzGCA3EwggNtAgEBMHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT HFRoYXd0ZSBD
b25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h bCBGcmVlbWFp
bCBJc3N1aW5nIENBAhBi2E2zbOyC1fBY1nuIWKaQMAkGBSsOAwIaBQCgggHQ MBgGCSqGSIb3
DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA5MTEwODA5MjEz N1owIwYJKoZI
hvcNAQkEMRYEFKB3R4jXI12UalTZXc338f9XrjN8MF8GCSqGSIb3DQEJDzFS MFAwCwYJYIZI
AWUDBAECMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0D AgIBQDAHBgUr
DgMCBzANBggqhkiG9w0DAgIBKDCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYD VQQGEwJaQTEl
MCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE AxMjVGhhd3Rl
IFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEGLYTbNs7ILV8FjWe4hY ppAwgYcGCyqG
SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRp
bmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3Vp
bmcgQ0ECEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEBBQAEggEANJ0G IdnUu8i6jPqT
hVHRrO5LZ0atJw81XekhYDSXD4VN2Gvtm9wnCXuK9vdkzXO7hU2B4ykJNa5g gFHBagMmLGCv
3hw+lGeWp4xal2jXYrWJrNqY3Yg12dS2IJoGVrb6JQobzDwku0Cbe5goCR6K jBen0ZfpfUd8
o5A6QVpKSx23lRBz/4WhQgwc8DYwWQAqtxeF8fWjBDP78rkEmM0JxlvKk8nH UMBYX90CzMZr
FNZz7V+cPsAIsHaOpR4by2kLRwVbV0mbupFt/0eORAzNv5ERV11jHdcvhWqN JVMk6sUDhXQf
U7x9aX5pNdCQJPMLqwaAjpqbhVvIk8QETocCzAAAAAAAAA==
--------------ms030106010200060006090503--

Re: Temp file issues on Ubuntu 9.10

Sebastiaan van Erk wrote:
> Hi all,
>
> I just recently upgraded to Ubuntu 9.10, but now I'm having all sorts
> of temp file problems. For example, when I try to delete a row and
> violate a contraint I get:
>
> ERROR 1451 (23000): Cannot delete or update a parent row: a foreign
> key constraint fails (temp file operation failed)
>
> Instead of telling me which constraint is violated, it tells me the
> temp file creation failed. I have no reason why it failed, I don't see
> any error messages in the log.
>
> To solve this problem I tried to make a tmpfs partition (I thought,
> maybe somehow my using ext4 might be a problem):
>
> mkdir /tmpfs
> mount -t tmpfs -o size=1g tmpfs /tmpfs
> mkdir /tmpfs/mysql
> chown mysql:mysql
>
> and changed the tmpdir in the mysql config to /tmpfs/mysql
>
> tmpdir=/tmpfs/mysql
>
> But then mysql fails on startup:
>
> /usr/sbin/mysqld: Can't create/write to file '/tmpfs/mysql/ibGgjPv7'
> (Errcode: 13)
> 091108 10:12:46 InnoDB: Error: unable to create temporary file;
> errno: 13
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' init function returned error.
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE
> ENGINE failed.
>
> I checked error code 13, which is permission denied, but I don't
> understand this, because if I change tmpdir to /tmp/mysql it does
> work, and I have:
>
> $ ls -ld /tmp/mysql
> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>
> $ ls -ld /tmpfs/mysql
> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>
> So I don't see the difference....
>
> Has anyone encountered similar problems, or know what's going on here?
>
> Best regards,
> Sebastiaan
>

This might just be a typo, but the chown statement you gave us didn't
have a target and so would not have affected the relevant directories:

mkdir /tmpfs
mount -t tmpfs -o size=1g tmpfs /tmpfs
mkdir /tmpfs/mysql
chown mysql:mysql

Probably should be:
chown -R mysql:mysql /tmpfs/mysql

john


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Temp file issues on Ubuntu 9.10

--------------ms040700090201020609030103
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

>> $ ls -ld /tmp/mysql
>> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>>
>> $ ls -ld /tmpfs/mysql
>> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>>
>> So I don't see the difference....
>>
>> Has anyone encountered similar problems, or know what's going on here?
>>
>> Best regards,
>> Sebastiaan
>>
>
> This might just be a typo, but the chown statement you gave us didn't
> have a target and so would not have affected the relevant directories:
>
> mkdir /tmpfs
> mount -t tmpfs -o size=1g tmpfs /tmpfs
> mkdir /tmpfs/mysql
> chown mysql:mysql
> Probably should be:
> chown -R mysql:mysql /tmpfs/mysql
>
> john

Hi,

Thanks, yes that's a typo indeed, sorry I didn't catch it before sending
the mail. The ls output was copy-pasted from a terminal and there the
ownerships are correct.

Regards,
Sebastiaan


--------------ms040700090201020609030103
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJUTCC
AwMwggJsoAMCAQICEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEFBQAw YjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4x LDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDcw MTA1MjIxMVoX
DTEwMDcwMTA1MjIxMVowaDEQMA4GA1UEBBMHdmFuIEVyazETMBEGA1UEKhMK U2ViYXN0aWFh
bjEbMBkGA1UEAxMSU2ViYXN0aWFhbiB2YW4gRXJrMSIwIAYJKoZIhvcNAQkB FhNzZWJzdGVy
QHNlYnN0ZXIuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA xnkA/HlKscOk
7wNt76nwOKIIsm3qlgX3Sf3jNOl+gVBi4Fq3n5BfDR0FBj4pbiQT+Q9s2oTJ coX3/AdZuNga
UH/6+dhcyD2kxgvVK8WK41WG9WyzPkfw4M2g3e51NrEsGC+H+eMbbvlrzvPa /asUwqERy60u
6XIlj5kwO/QxHx2iJpgUFtkOYr1BSkP0FC/Qe8VbF7Fi1fu3I5Rk/+9j49OM /IBMbmEkKFoD
/e8KgyhCgREAv08/yntwHRos5m6AK27zR+4dTsbb/B8fCjRT8tttCvbo1C/U iuM7u/YcfY0d
8mLp+dRI7xpHl/9Fp86q31OmAfwD1tw9UYL1DnIbHwIDAQABozAwLjAeBgNV HREEFzAVgRNz
ZWJzdGVyQHNlYnN0ZXIuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEF BQADgYEAw63Z
9kpNbme1LCtCeAvXVM8oTGJy0L85qtbO5DUBxjmBTBMSe1Kbn160wibMP++C v1p/PwCumRbe
XjJSI3HclQasaF8FpDWtRQlHFj/w/3Q2GsBpoHxSOENjY/+jgtDTOnX5+0lP HaN/iQTAdW8+
rm0P+FIKeYRpdOjFsIoeudYwggMDMIICbKADAgECAhBi2E2zbOyC1fBY1nuI WKaQMA0GCSqG
SIb3DQEBBQUAMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29u c3VsdGluZyAo
UHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg SXNzdWluZyBD
QTAeFw0wOTA3MDEwNTIyMTFaFw0xMDA3MDEwNTIyMTFaMGgxEDAOBgNVBAQT B3ZhbiBFcmsx
EzARBgNVBCoTClNlYmFzdGlhYW4xGzAZBgNVBAMTElNlYmFzdGlhYW4gdmFu IEVyazEiMCAG
CSqGSIb3DQEJARYTc2Vic3RlckBzZWJzdGVyLmNvbTCCASIwDQYJKoZIhvcN AQEBBQADggEP
ADCCAQoCggEBAMZ5APx5SrHDpO8Dbe+p8DiiCLJt6pYF90n94zTpfoFQYuBa t5+QXw0dBQY+
KW4kE/kPbNqEyXKF9/wHWbjYGlB/+vnYXMg9pMYL1SvFiuNVhvVssz5H8ODN oN3udTaxLBgv
h/njG275a87z2v2rFMKhEcutLulyJY+ZMDv0MR8doiaYFBbZDmK9QUpD9BQv 0HvFWxexYtX7
tyOUZP/vY+PTjPyATG5hJChaA/3vCoMoQoERAL9PP8p7cB0aLOZugCtu80fu HU7G2/wfHwo0
U/LbbQr26NQv1IrjO7v2HH2NHfJi6fnUSO8aR5f/RafOqt9TpgH8A9bcPVGC 9Q5yGx8CAwEA
AaMwMC4wHgYDVR0RBBcwFYETc2Vic3RlckBzZWJzdGVyLmNvbTAMBgNVHRMB Af8EAjAAMA0G
CSqGSIb3DQEBBQUAA4GBAMOt2fZKTW5ntSwrQngL11TPKExictC/OarWzuQ1 AcY5gUwTEntS
m59etMImzD/vgr9afz8ArpkW3l4yUiNx3JUGrGhfBaQ1rUUJRxY/8P90NhrA aaB8UjhDY2P/
o4LQ0zp1+ftJTx2jf4kEwHVvPq5tD/hSCnmEaXToxbCKHrnWMIIDPzCCAqig AwIBAgIBDTAN
BgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rl cm4gQ2FwZTES
MBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGlu ZzEoMCYGA1UE
CxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMb VGhhd3RlIFBl
cnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1m cmVlbWFpbEB0
aGF3dGUuY29tMB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjEL MAkGA1UEBhMC
WkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3 DQEBAQUAA4GN
ADCBiQKBgQDEpjxVc1X7TrnKmVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph 8r9RzgHU5VAK
MNcCY1osiRVwjt3J8CuFWqo/cVbLrzwLB+fxH5E2JCoTzyvV84J3PQO+K/67 GD4Hv0CAAmTX
p6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZcmC3+wIDAQABo4GUMIGRMBIGA1Ud EwEB/wQIMAYB
Af8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0cDovL2NybC50aGF3dGUuY29t L1RoYXd0ZVBl
cnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQDAgEGMCkGA1UdEQQiMCCk HjAcMRowGAYD
VQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0BAQUFAAOBgQBIjNFQ g+oLLswNo2as
Zw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3hYWLD2ToZfoSx mRsAxRoLgnSe
JVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1TXfjViF4 gtwhGTXeJLHT
HUb/XV9lTzGCA3EwggNtAgEBMHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT HFRoYXd0ZSBD
b25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h bCBGcmVlbWFp
bCBJc3N1aW5nIENBAhBi2E2zbOyC1fBY1nuIWKaQMAkGBSsOAwIaBQCgggHQ MBgGCSqGSIb3
DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA5MTEwODE3NDgz OFowIwYJKoZI
hvcNAQkEMRYEFM+ac7cTegypIxTIvbBN1AQclMS8MF8GCSqGSIb3DQEJDzFS MFAwCwYJYIZI
AWUDBAECMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0D AgIBQDAHBgUr
DgMCBzANBggqhkiG9w0DAgIBKDCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYD VQQGEwJaQTEl
MCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE AxMjVGhhd3Rl
IFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEGLYTbNs7ILV8FjWe4hY ppAwgYcGCyqG
SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRp
bmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3Vp
bmcgQ0ECEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEBBQAEggEAeZ9Y WI87cgXZuIbW
73fuJ+OVM8IFdk3bq6oWtuJxMAVFUMZsESIVY98+wgHdGTlsivnXDEvSZoYp awIHVcyjX5sR
uYZumMrEhi6je0oIuUtJR3RnwysPvz7iqrLnf2/XHwpaS/PjMqQoBpzvwN0v wv66ZdM+S34s
Eq7l6riMyhZhd8m/6GH7mbVMmZb/ekydnSxBOZL2EhytTwRUl1So981+gM2x FF7XvzRlVOdC
0J4UyiX3x8vz5pULTA8jtXfUugt7T6qczB7lDrQf0/4kZgvYkzAubjZzdhO1 YW3PJRTxyPUR
oVhbR8tRWZ9gXz2laogpHDpxjtpLFR2uhKbGNQAAAAAAAA==
--------------ms040700090201020609030103--

Re: Temp file issues on Ubuntu 9.10

Are you running selinux?

On Sunday, November 8, 2009, Sebastiaan van Erk wrote=
:
> Hi,
>
>
> $ ls -ld /tmp/mysql
> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>
> $ ls -ld /tmpfs/mysql
> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>
> So I don't see the difference....
>
> Has anyone encountered similar problems, or know what's going on here?
>
> Best regards,
> Sebastiaan
>
>
>
> This might just be a typo, but the chown statement you gave us didn't hav=
e a target and so would not have affected the relevant directories:
>
> mkdir /tmpfs
> mount -t tmpfs -o size=3D1g tmpfs /tmpfs
> mkdir /tmpfs/mysql
> chown mysql:mysql
> Probably should be:
> chown -R mysql:mysql =A0/tmpfs/mysql
>
> john
>
>
> Hi,
>
> Thanks, yes that's a typo indeed, sorry I didn't catch it before sending =
the mail. The ls output was copy-pasted from a terminal and there the owner=
ships are correct.
>
> Regards,
> Sebastiaan
>
>

--=20
-----------------------------
Johnny Withers
601.209.4985
johnny@pixelated.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Temp file issues on Ubuntu 9.10

--------------ms020702080104010106080605
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Not that I am aware of. I'm just running a standard out of the box 9.10
Ubuntu, upgraded from 9.04. Note that when I'm using /tmp/mysql or /tmp
as tmpdir, at least InnoDB starts up, but then I still get the strange
"temp file operation failed" message instead of the constraint when I
try to do a delete of a record which would violate a constraint.

So it seems there are at least 2 problems:
1) tmpfs refuses to work for me
2) even on a working tmpdir, temp file creations fails in some cases

I'm thinking of doing a reinstall of my system (back to 9.04, why o why
did I have to upgrade in the first place).

Regards,
Sebastiaan

Johnny Withers wrote:
> Are you running selinux?
>
> On Sunday, November 8, 2009, Sebastiaan van Erk wrote:
>> Hi,
>>
>>
>> $ ls -ld /tmp/mysql
>> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>>
>> $ ls -ld /tmpfs/mysql
>> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>>
>> So I don't see the difference....
>>
>> Has anyone encountered similar problems, or know what's going on here?
>>
>> Best regards,
>> Sebastiaan
>>
>>
>>
>> This might just be a typo, but the chown statement you gave us didn't have a target and so would not have affected the relevant directories:
>>
>> mkdir /tmpfs
>> mount -t tmpfs -o size=1g tmpfs /tmpfs
>> mkdir /tmpfs/mysql
>> chown mysql:mysql
>> Probably should be:
>> chown -R mysql:mysql /tmpfs/mysql
>>
>> john
>>
>>
>> Hi,
>>
>> Thanks, yes that's a typo indeed, sorry I didn't catch it before sending the mail. The ls output was copy-pasted from a terminal and there the ownerships are correct.
>>
>> Regards,
>> Sebastiaan
>>
>>
>

--------------ms020702080104010106080605
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJUTCC
AwMwggJsoAMCAQICEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEFBQAw YjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4x LDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDcw MTA1MjIxMVoX
DTEwMDcwMTA1MjIxMVowaDEQMA4GA1UEBBMHdmFuIEVyazETMBEGA1UEKhMK U2ViYXN0aWFh
bjEbMBkGA1UEAxMSU2ViYXN0aWFhbiB2YW4gRXJrMSIwIAYJKoZIhvcNAQkB FhNzZWJzdGVy
QHNlYnN0ZXIuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA xnkA/HlKscOk
7wNt76nwOKIIsm3qlgX3Sf3jNOl+gVBi4Fq3n5BfDR0FBj4pbiQT+Q9s2oTJ coX3/AdZuNga
UH/6+dhcyD2kxgvVK8WK41WG9WyzPkfw4M2g3e51NrEsGC+H+eMbbvlrzvPa /asUwqERy60u
6XIlj5kwO/QxHx2iJpgUFtkOYr1BSkP0FC/Qe8VbF7Fi1fu3I5Rk/+9j49OM /IBMbmEkKFoD
/e8KgyhCgREAv08/yntwHRos5m6AK27zR+4dTsbb/B8fCjRT8tttCvbo1C/U iuM7u/YcfY0d
8mLp+dRI7xpHl/9Fp86q31OmAfwD1tw9UYL1DnIbHwIDAQABozAwLjAeBgNV HREEFzAVgRNz
ZWJzdGVyQHNlYnN0ZXIuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEF BQADgYEAw63Z
9kpNbme1LCtCeAvXVM8oTGJy0L85qtbO5DUBxjmBTBMSe1Kbn160wibMP++C v1p/PwCumRbe
XjJSI3HclQasaF8FpDWtRQlHFj/w/3Q2GsBpoHxSOENjY/+jgtDTOnX5+0lP HaN/iQTAdW8+
rm0P+FIKeYRpdOjFsIoeudYwggMDMIICbKADAgECAhBi2E2zbOyC1fBY1nuI WKaQMA0GCSqG
SIb3DQEBBQUAMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29u c3VsdGluZyAo
UHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg SXNzdWluZyBD
QTAeFw0wOTA3MDEwNTIyMTFaFw0xMDA3MDEwNTIyMTFaMGgxEDAOBgNVBAQT B3ZhbiBFcmsx
EzARBgNVBCoTClNlYmFzdGlhYW4xGzAZBgNVBAMTElNlYmFzdGlhYW4gdmFu IEVyazEiMCAG
CSqGSIb3DQEJARYTc2Vic3RlckBzZWJzdGVyLmNvbTCCASIwDQYJKoZIhvcN AQEBBQADggEP
ADCCAQoCggEBAMZ5APx5SrHDpO8Dbe+p8DiiCLJt6pYF90n94zTpfoFQYuBa t5+QXw0dBQY+
KW4kE/kPbNqEyXKF9/wHWbjYGlB/+vnYXMg9pMYL1SvFiuNVhvVssz5H8ODN oN3udTaxLBgv
h/njG275a87z2v2rFMKhEcutLulyJY+ZMDv0MR8doiaYFBbZDmK9QUpD9BQv 0HvFWxexYtX7
tyOUZP/vY+PTjPyATG5hJChaA/3vCoMoQoERAL9PP8p7cB0aLOZugCtu80fu HU7G2/wfHwo0
U/LbbQr26NQv1IrjO7v2HH2NHfJi6fnUSO8aR5f/RafOqt9TpgH8A9bcPVGC 9Q5yGx8CAwEA
AaMwMC4wHgYDVR0RBBcwFYETc2Vic3RlckBzZWJzdGVyLmNvbTAMBgNVHRMB Af8EAjAAMA0G
CSqGSIb3DQEBBQUAA4GBAMOt2fZKTW5ntSwrQngL11TPKExictC/OarWzuQ1 AcY5gUwTEntS
m59etMImzD/vgr9afz8ArpkW3l4yUiNx3JUGrGhfBaQ1rUUJRxY/8P90NhrA aaB8UjhDY2P/
o4LQ0zp1+ftJTx2jf4kEwHVvPq5tD/hSCnmEaXToxbCKHrnWMIIDPzCCAqig AwIBAgIBDTAN
BgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rl cm4gQ2FwZTES
MBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGlu ZzEoMCYGA1UE
CxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMb VGhhd3RlIFBl
cnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1m cmVlbWFpbEB0
aGF3dGUuY29tMB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjEL MAkGA1UEBhMC
WkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3 DQEBAQUAA4GN
ADCBiQKBgQDEpjxVc1X7TrnKmVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph 8r9RzgHU5VAK
MNcCY1osiRVwjt3J8CuFWqo/cVbLrzwLB+fxH5E2JCoTzyvV84J3PQO+K/67 GD4Hv0CAAmTX
p6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZcmC3+wIDAQABo4GUMIGRMBIGA1Ud EwEB/wQIMAYB
Af8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0cDovL2NybC50aGF3dGUuY29t L1RoYXd0ZVBl
cnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQDAgEGMCkGA1UdEQQiMCCk HjAcMRowGAYD
VQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0BAQUFAAOBgQBIjNFQ g+oLLswNo2as
Zw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3hYWLD2ToZfoSx mRsAxRoLgnSe
JVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1TXfjViF4 gtwhGTXeJLHT
HUb/XV9lTzGCA3EwggNtAgEBMHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT HFRoYXd0ZSBD
b25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h bCBGcmVlbWFp
bCBJc3N1aW5nIENBAhBi2E2zbOyC1fBY1nuIWKaQMAkGBSsOAwIaBQCgggHQ MBgGCSqGSIb3
DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA5MTEwOTE0MDEy MVowIwYJKoZI
hvcNAQkEMRYEFH+8aklL6qt9y1QGZg63z6ey40O0MF8GCSqGSIb3DQEJDzFS MFAwCwYJYIZI
AWUDBAECMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0D AgIBQDAHBgUr
DgMCBzANBggqhkiG9w0DAgIBKDCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYD VQQGEwJaQTEl
MCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE AxMjVGhhd3Rl
IFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEGLYTbNs7ILV8FjWe4hY ppAwgYcGCyqG
SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRp
bmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3Vp
bmcgQ0ECEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEBBQAEggEAtg7K 1Q038vrqUWte
Q4r9zjOGlMNP6ts86+DSdjolcdgCuLN9yQULvtTIPaRZ7H1PWZRGGTY7RujI A6TYPIcUbCw9
CmQ/GxX5bLPR5YjJETKcU1WwyQuyCUSzsjCNLXxjwbQQ7R4dBLOwe5y7El7Q dAwfgkHPnHKd
k3vojeRjpYcMxFWRjW8y1CDzf/M1oH8edaIPB3wLVPRyGw2kBDzqhAQfKbmj rVkFqHq6GE3Z
ysugQvLmO3/h0cjpht3XAvveyeYiBvrQDngdGsAeIGoSk85UItoCVv0Z2tfR ltyZYpV+hawO
lMxnPYziFzemSSyqQEgxPLBOqIGwcy02cyWIEwAAAAAAAA==
--------------ms020702080104010106080605--

Re: Temp file issues on Ubuntu 9.10

--001636e0a6fe4998900477f4643d
Content-Type: text/plain; charset=ISO-8859-1

Hi Sebastiaan,

Steps to fix the issue.
1. Do proper shutdown of mysql server.
2. Check the error log file that mysql server is shutdown properly.
3. Remove log files (ib_logfile0 and ib_logfile1).
4. Start mysql server (The log files will be created automatically)

Thanks,
Krishna

On Sun, Nov 8, 2009 at 2:51 PM, Sebastiaan van Erk wrote:

> Hi all,
>
> I just recently upgraded to Ubuntu 9.10, but now I'm having all sorts of
> temp file problems. For example, when I try to delete a row and violate a
> contraint I get:
>
> ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
> constraint fails (temp file operation failed)
>
> Instead of telling me which constraint is violated, it tells me the temp
> file creation failed. I have no reason why it failed, I don't see any error
> messages in the log.
>
> To solve this problem I tried to make a tmpfs partition (I thought, maybe
> somehow my using ext4 might be a problem):
>
> mkdir /tmpfs
> mount -t tmpfs -o size=1g tmpfs /tmpfs
> mkdir /tmpfs/mysql
> chown mysql:mysql
>
> and changed the tmpdir in the mysql config to /tmpfs/mysql
>
> tmpdir=/tmpfs/mysql
>
> But then mysql fails on startup:
>
> /usr/sbin/mysqld: Can't create/write to file '/tmpfs/mysql/ibGgjPv7'
> (Errcode: 13)
> 091108 10:12:46 InnoDB: Error: unable to create temporary file; errno: 13
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' init function returned error.
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
> failed.
>
> I checked error code 13, which is permission denied, but I don't understand
> this, because if I change tmpdir to /tmp/mysql it does work, and I have:
>
> $ ls -ld /tmp/mysql
> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>
> $ ls -ld /tmpfs/mysql
> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>
> So I don't see the difference....
>
> Has anyone encountered similar problems, or know what's going on here?
>
> Best regards,
> Sebastiaan
>
>

--001636e0a6fe4998900477f4643d--

Re: Temp file issues on Ubuntu 9.10

--------------ms020501080806000101080905
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I followed the instructions but still get:

mysql> delete from mytable;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails (temp file operation failed)
mysql>

Regards,
Sebastiaan


Krishna Chandra Prajapati wrote:
> Hi Sebastiaan,
>
> Steps to fix the issue.
> 1. Do proper shutdown of mysql server.
> 2. Check the error log file that mysql server is shutdown properly.
> 3. Remove log files (ib_logfile0 and ib_logfile1).
> 4. Start mysql server (The log files will be created automatically)
>
> Thanks,
> Krishna
>
> On Sun, Nov 8, 2009 at 2:51 PM, Sebastiaan van Erk > > wrote:
>
> Hi all,
>
> I just recently upgraded to Ubuntu 9.10, but now I'm having all
> sorts of temp file problems. For example, when I try to delete a row
> and violate a contraint I get:
>
> ERROR 1451 (23000): Cannot delete or update a parent row: a foreign
> key constraint fails (temp file operation failed)
>
> Instead of telling me which constraint is violated, it tells me the
> temp file creation failed. I have no reason why it failed, I don't
> see any error messages in the log.
>
> To solve this problem I tried to make a tmpfs partition (I thought,
> maybe somehow my using ext4 might be a problem):
>
> mkdir /tmpfs
> mount -t tmpfs -o size=1g tmpfs /tmpfs
> mkdir /tmpfs/mysql
> chown mysql:mysql
>
> and changed the tmpdir in the mysql config to /tmpfs/mysql
>
> tmpdir=/tmpfs/mysql
>
> But then mysql fails on startup:
>
> /usr/sbin/mysqld: Can't create/write to file '/tmpfs/mysql/ibGgjPv7'
> (Errcode: 13)
> 091108 10:12:46 InnoDB: Error: unable to create temporary file;
> errno: 13
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' init function returned error.
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE
> ENGINE failed.
>
> I checked error code 13, which is permission denied, but I don't
> understand this, because if I change tmpdir to /tmp/mysql it does
> work, and I have:
>
> $ ls -ld /tmp/mysql
> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>
> $ ls -ld /tmpfs/mysql
> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>
> So I don't see the difference....
>
> Has anyone encountered similar problems, or know what's going on here?
>
> Best regards,
> Sebastiaan
>
>

--------------ms020501080806000101080905
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJUTCC
AwMwggJsoAMCAQICEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEFBQAw YjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4x LDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDcw MTA1MjIxMVoX
DTEwMDcwMTA1MjIxMVowaDEQMA4GA1UEBBMHdmFuIEVyazETMBEGA1UEKhMK U2ViYXN0aWFh
bjEbMBkGA1UEAxMSU2ViYXN0aWFhbiB2YW4gRXJrMSIwIAYJKoZIhvcNAQkB FhNzZWJzdGVy
QHNlYnN0ZXIuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA xnkA/HlKscOk
7wNt76nwOKIIsm3qlgX3Sf3jNOl+gVBi4Fq3n5BfDR0FBj4pbiQT+Q9s2oTJ coX3/AdZuNga
UH/6+dhcyD2kxgvVK8WK41WG9WyzPkfw4M2g3e51NrEsGC+H+eMbbvlrzvPa /asUwqERy60u
6XIlj5kwO/QxHx2iJpgUFtkOYr1BSkP0FC/Qe8VbF7Fi1fu3I5Rk/+9j49OM /IBMbmEkKFoD
/e8KgyhCgREAv08/yntwHRos5m6AK27zR+4dTsbb/B8fCjRT8tttCvbo1C/U iuM7u/YcfY0d
8mLp+dRI7xpHl/9Fp86q31OmAfwD1tw9UYL1DnIbHwIDAQABozAwLjAeBgNV HREEFzAVgRNz
ZWJzdGVyQHNlYnN0ZXIuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEF BQADgYEAw63Z
9kpNbme1LCtCeAvXVM8oTGJy0L85qtbO5DUBxjmBTBMSe1Kbn160wibMP++C v1p/PwCumRbe
XjJSI3HclQasaF8FpDWtRQlHFj/w/3Q2GsBpoHxSOENjY/+jgtDTOnX5+0lP HaN/iQTAdW8+
rm0P+FIKeYRpdOjFsIoeudYwggMDMIICbKADAgECAhBi2E2zbOyC1fBY1nuI WKaQMA0GCSqG
SIb3DQEBBQUAMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29u c3VsdGluZyAo
UHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg SXNzdWluZyBD
QTAeFw0wOTA3MDEwNTIyMTFaFw0xMDA3MDEwNTIyMTFaMGgxEDAOBgNVBAQT B3ZhbiBFcmsx
EzARBgNVBCoTClNlYmFzdGlhYW4xGzAZBgNVBAMTElNlYmFzdGlhYW4gdmFu IEVyazEiMCAG
CSqGSIb3DQEJARYTc2Vic3RlckBzZWJzdGVyLmNvbTCCASIwDQYJKoZIhvcN AQEBBQADggEP
ADCCAQoCggEBAMZ5APx5SrHDpO8Dbe+p8DiiCLJt6pYF90n94zTpfoFQYuBa t5+QXw0dBQY+
KW4kE/kPbNqEyXKF9/wHWbjYGlB/+vnYXMg9pMYL1SvFiuNVhvVssz5H8ODN oN3udTaxLBgv
h/njG275a87z2v2rFMKhEcutLulyJY+ZMDv0MR8doiaYFBbZDmK9QUpD9BQv 0HvFWxexYtX7
tyOUZP/vY+PTjPyATG5hJChaA/3vCoMoQoERAL9PP8p7cB0aLOZugCtu80fu HU7G2/wfHwo0
U/LbbQr26NQv1IrjO7v2HH2NHfJi6fnUSO8aR5f/RafOqt9TpgH8A9bcPVGC 9Q5yGx8CAwEA
AaMwMC4wHgYDVR0RBBcwFYETc2Vic3RlckBzZWJzdGVyLmNvbTAMBgNVHRMB Af8EAjAAMA0G
CSqGSIb3DQEBBQUAA4GBAMOt2fZKTW5ntSwrQngL11TPKExictC/OarWzuQ1 AcY5gUwTEntS
m59etMImzD/vgr9afz8ArpkW3l4yUiNx3JUGrGhfBaQ1rUUJRxY/8P90NhrA aaB8UjhDY2P/
o4LQ0zp1+ftJTx2jf4kEwHVvPq5tD/hSCnmEaXToxbCKHrnWMIIDPzCCAqig AwIBAgIBDTAN
BgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rl cm4gQ2FwZTES
MBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGlu ZzEoMCYGA1UE
CxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMb VGhhd3RlIFBl
cnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1m cmVlbWFpbEB0
aGF3dGUuY29tMB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjEL MAkGA1UEBhMC
WkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3 DQEBAQUAA4GN
ADCBiQKBgQDEpjxVc1X7TrnKmVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph 8r9RzgHU5VAK
MNcCY1osiRVwjt3J8CuFWqo/cVbLrzwLB+fxH5E2JCoTzyvV84J3PQO+K/67 GD4Hv0CAAmTX
p6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZcmC3+wIDAQABo4GUMIGRMBIGA1Ud EwEB/wQIMAYB
Af8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0cDovL2NybC50aGF3dGUuY29t L1RoYXd0ZVBl
cnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQDAgEGMCkGA1UdEQQiMCCk HjAcMRowGAYD
VQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0BAQUFAAOBgQBIjNFQ g+oLLswNo2as
Zw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3hYWLD2ToZfoSx mRsAxRoLgnSe
JVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1TXfjViF4 gtwhGTXeJLHT
HUb/XV9lTzGCA3EwggNtAgEBMHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT HFRoYXd0ZSBD
b25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h bCBGcmVlbWFp
bCBJc3N1aW5nIENBAhBi2E2zbOyC1fBY1nuIWKaQMAkGBSsOAwIaBQCgggHQ MBgGCSqGSIb3
DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA5MTEwOTIxNDk0 MlowIwYJKoZI
hvcNAQkEMRYEFB+NRajch0OxP4TyQxruwzcOuXN+MF8GCSqGSIb3DQEJDzFS MFAwCwYJYIZI
AWUDBAECMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0D AgIBQDAHBgUr
DgMCBzANBggqhkiG9w0DAgIBKDCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYD VQQGEwJaQTEl
MCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE AxMjVGhhd3Rl
IFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEGLYTbNs7ILV8FjWe4hY ppAwgYcGCyqG
SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRp
bmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3Vp
bmcgQ0ECEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEBBQAEggEAKuKh BLI8L+Qbz6SX
+j0ENdGOqWCPmeN5SkynbIFS9cpKIuCtEIFbwDQQ365iuDEucAnCH6kWzSGk g/RXcag1ZaXs
02CXOESU+wUEALyW2XaIX5oT9tuC5+JSeWlXBqWRHnUrpVU0az1r5+/5EoO1 DQLy0yw94OSV
2noLaBRJBm0g2g5ATAhQOwd3qCTwcV/FMeFYG7AQQtetF52PdpPawGCWeYsb cwPMckyO34B+
G+fhkXNk2dLG6dnTGIg5cAisYFBNiYKtiqkb+SrRrKp7Osn+Bx6NjnQzpHc2 stA335Udj2mz
xN5TyOSnr6EavZsx3UD13cZtTXCPnFGOk3Kq8QAAAAAAAA==
--------------ms020501080806000101080905--

Re: Temp file issues on Ubuntu 9.10

--0016e64d95febae3e70478007415
Content-Type: text/plain; charset=ISO-8859-1

does the table ur trying to delete has any primary-foreign key relation.

do "show create table table_name\G"

Also instead of delete, use truncate, i t will be faster.

regards
anandkl

On Tue, Nov 10, 2009 at 3:19 AM, Sebastiaan van Erk wrote:

> Hi,
>
> I followed the instructions but still get:
>
> mysql> delete from mytable;
>
> ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
> constraint fails (temp file operation failed)
> mysql>
>
> Regards,
> Sebastiaan
>
>
> Krishna Chandra Prajapati wrote:
>
>> Hi Sebastiaan,
>>
>> Steps to fix the issue.
>> 1. Do proper shutdown of mysql server.
>> 2. Check the error log file that mysql server is shutdown properly.
>> 3. Remove log files (ib_logfile0 and ib_logfile1).
>> 4. Start mysql server (The log files will be created automatically)
>>
>> Thanks,
>> Krishna
>>
>> On Sun, Nov 8, 2009 at 2:51 PM, Sebastiaan van Erk >> sebster@sebster.com>> wrote:
>>
>> Hi all,
>>
>> I just recently upgraded to Ubuntu 9.10, but now I'm having all
>> sorts of temp file problems. For example, when I try to delete a row
>> and violate a contraint I get:
>>
>> ERROR 1451 (23000): Cannot delete or update a parent row: a foreign
>> key constraint fails (temp file operation failed)
>>
>> Instead of telling me which constraint is violated, it tells me the
>> temp file creation failed. I have no reason why it failed, I don't
>> see any error messages in the log.
>>
>> To solve this problem I tried to make a tmpfs partition (I thought,
>> maybe somehow my using ext4 might be a problem):
>>
>> mkdir /tmpfs
>> mount -t tmpfs -o size=1g tmpfs /tmpfs
>> mkdir /tmpfs/mysql
>> chown mysql:mysql
>>
>> and changed the tmpdir in the mysql config to /tmpfs/mysql
>>
>> tmpdir=/tmpfs/mysql
>>
>> But then mysql fails on startup:
>>
>> /usr/sbin/mysqld: Can't create/write to file '/tmpfs/mysql/ibGgjPv7'
>> (Errcode: 13)
>> 091108 10:12:46 InnoDB: Error: unable to create temporary file;
>> errno: 13
>> 091108 10:12:46 [ERROR] Plugin 'InnoDB' init function returned error.
>> 091108 10:12:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE
>> ENGINE failed.
>>
>> I checked error code 13, which is permission denied, but I don't
>> understand this, because if I change tmpdir to /tmp/mysql it does
>> work, and I have:
>>
>> $ ls -ld /tmp/mysql
>> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>>
>> $ ls -ld /tmpfs/mysql
>> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>>
>> So I don't see the difference....
>>
>> Has anyone encountered similar problems, or know what's going on here?
>>
>> Best regards,
>> Sebastiaan
>>
>>
>>

--0016e64d95febae3e70478007415--

Re: Temp file issues on Ubuntu 9.10

--------------ms070706070805090302060800
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I have got the correct answer now, from Linus Larsson, just forwarding
it for the archives:

-------8<-------
Hello, my name is Linus Larsson.

I saw you got a problem with mysql on Ubuntu 9.10, I was researching the
exact same problem and found your post. In the end I turned off
app-armor. It seems to have a buggy profile for mysql.

sudo /etc/init.d/apparmor stop

Of course the correct fix is to update the profile, but I have no time
to look into that now. I'm only using mysql temporarily on my computer
anyway.

Regards,
Linus
-------8<-------

Thanks to everybody who answered. :)

Regards,
Sebastiaan

Ananda Kumar wrote:
> does the table ur trying to delete has any primary-foreign key relation.
>
> do "show create table table_name\G"
>
> Also instead of delete, use truncate, i t will be faster.
>
> regards
> anandkl
>
> On Tue, Nov 10, 2009 at 3:19 AM, Sebastiaan van Erk > > wrote:
>
> Hi,
>
> I followed the instructions but still get:
>
> mysql> delete from mytable;
>
> ERROR 1451 (23000): Cannot delete or update a parent row: a foreign
> key constraint fails (temp file operation failed)
> mysql>
>
> Regards,
> Sebastiaan
>
>
> Krishna Chandra Prajapati wrote:
>
> Hi Sebastiaan,
>
> Steps to fix the issue.
> 1. Do proper shutdown of mysql server.
> 2. Check the error log file that mysql server is shutdown properly.
> 3. Remove log files (ib_logfile0 and ib_logfile1).
> 4. Start mysql server (The log files will be created automatically)
>
> Thanks,
> Krishna
>
> On Sun, Nov 8, 2009 at 2:51 PM, Sebastiaan van Erk
>
> >> wrote:
>
> Hi all,
>
> I just recently upgraded to Ubuntu 9.10, but now I'm having all
> sorts of temp file problems. For example, when I try to
> delete a row
> and violate a contraint I get:
>
> ERROR 1451 (23000): Cannot delete or update a parent row: a
> foreign
> key constraint fails (temp file operation failed)
>
> Instead of telling me which constraint is violated, it tells
> me the
> temp file creation failed. I have no reason why it failed, I
> don't
> see any error messages in the log.
>
> To solve this problem I tried to make a tmpfs partition (I
> thought,
> maybe somehow my using ext4 might be a problem):
>
> mkdir /tmpfs
> mount -t tmpfs -o size=1g tmpfs /tmpfs
> mkdir /tmpfs/mysql
> chown mysql:mysql
>
> and changed the tmpdir in the mysql config to /tmpfs/mysql
>
> tmpdir=/tmpfs/mysql
>
> But then mysql fails on startup:
>
> /usr/sbin/mysqld: Can't create/write to file
> '/tmpfs/mysql/ibGgjPv7'
> (Errcode: 13)
> 091108 10:12:46 InnoDB: Error: unable to create temporary file;
> errno: 13
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' init function
> returned error.
> 091108 10:12:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE
> ENGINE failed.
>
> I checked error code 13, which is permission denied, but I don't
> understand this, because if I change tmpdir to /tmp/mysql it does
> work, and I have:
>
> $ ls -ld /tmp/mysql
> drwxr-xr-x 2 mysql mysql 4096 2009-11-08 10:14 /tmp/mysql
>
> $ ls -ld /tmpfs/mysql
> drwxr-xr-x 2 mysql mysql 40 2009-11-08 10:12 /tmpfs/mysql
>
> So I don't see the difference....
>
> Has anyone encountered similar problems, or know what's going
> on here?
>
> Best regards,
> Sebastiaan
>
>
>

--------------ms070706070805090302060800
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJUTCC
AwMwggJsoAMCAQICEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEFBQAw YjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4x LDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDcw MTA1MjIxMVoX
DTEwMDcwMTA1MjIxMVowaDEQMA4GA1UEBBMHdmFuIEVyazETMBEGA1UEKhMK U2ViYXN0aWFh
bjEbMBkGA1UEAxMSU2ViYXN0aWFhbiB2YW4gRXJrMSIwIAYJKoZIhvcNAQkB FhNzZWJzdGVy
QHNlYnN0ZXIuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA xnkA/HlKscOk
7wNt76nwOKIIsm3qlgX3Sf3jNOl+gVBi4Fq3n5BfDR0FBj4pbiQT+Q9s2oTJ coX3/AdZuNga
UH/6+dhcyD2kxgvVK8WK41WG9WyzPkfw4M2g3e51NrEsGC+H+eMbbvlrzvPa /asUwqERy60u
6XIlj5kwO/QxHx2iJpgUFtkOYr1BSkP0FC/Qe8VbF7Fi1fu3I5Rk/+9j49OM /IBMbmEkKFoD
/e8KgyhCgREAv08/yntwHRos5m6AK27zR+4dTsbb/B8fCjRT8tttCvbo1C/U iuM7u/YcfY0d
8mLp+dRI7xpHl/9Fp86q31OmAfwD1tw9UYL1DnIbHwIDAQABozAwLjAeBgNV HREEFzAVgRNz
ZWJzdGVyQHNlYnN0ZXIuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEF BQADgYEAw63Z
9kpNbme1LCtCeAvXVM8oTGJy0L85qtbO5DUBxjmBTBMSe1Kbn160wibMP++C v1p/PwCumRbe
XjJSI3HclQasaF8FpDWtRQlHFj/w/3Q2GsBpoHxSOENjY/+jgtDTOnX5+0lP HaN/iQTAdW8+
rm0P+FIKeYRpdOjFsIoeudYwggMDMIICbKADAgECAhBi2E2zbOyC1fBY1nuI WKaQMA0GCSqG
SIb3DQEBBQUAMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29u c3VsdGluZyAo
UHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg SXNzdWluZyBD
QTAeFw0wOTA3MDEwNTIyMTFaFw0xMDA3MDEwNTIyMTFaMGgxEDAOBgNVBAQT B3ZhbiBFcmsx
EzARBgNVBCoTClNlYmFzdGlhYW4xGzAZBgNVBAMTElNlYmFzdGlhYW4gdmFu IEVyazEiMCAG
CSqGSIb3DQEJARYTc2Vic3RlckBzZWJzdGVyLmNvbTCCASIwDQYJKoZIhvcN AQEBBQADggEP
ADCCAQoCggEBAMZ5APx5SrHDpO8Dbe+p8DiiCLJt6pYF90n94zTpfoFQYuBa t5+QXw0dBQY+
KW4kE/kPbNqEyXKF9/wHWbjYGlB/+vnYXMg9pMYL1SvFiuNVhvVssz5H8ODN oN3udTaxLBgv
h/njG275a87z2v2rFMKhEcutLulyJY+ZMDv0MR8doiaYFBbZDmK9QUpD9BQv 0HvFWxexYtX7
tyOUZP/vY+PTjPyATG5hJChaA/3vCoMoQoERAL9PP8p7cB0aLOZugCtu80fu HU7G2/wfHwo0
U/LbbQr26NQv1IrjO7v2HH2NHfJi6fnUSO8aR5f/RafOqt9TpgH8A9bcPVGC 9Q5yGx8CAwEA
AaMwMC4wHgYDVR0RBBcwFYETc2Vic3RlckBzZWJzdGVyLmNvbTAMBgNVHRMB Af8EAjAAMA0G
CSqGSIb3DQEBBQUAA4GBAMOt2fZKTW5ntSwrQngL11TPKExictC/OarWzuQ1 AcY5gUwTEntS
m59etMImzD/vgr9afz8ArpkW3l4yUiNx3JUGrGhfBaQ1rUUJRxY/8P90NhrA aaB8UjhDY2P/
o4LQ0zp1+ftJTx2jf4kEwHVvPq5tD/hSCnmEaXToxbCKHrnWMIIDPzCCAqig AwIBAgIBDTAN
BgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rl cm4gQ2FwZTES
MBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGlu ZzEoMCYGA1UE
CxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMb VGhhd3RlIFBl
cnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1m cmVlbWFpbEB0
aGF3dGUuY29tMB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjEL MAkGA1UEBhMC
WkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3 DQEBAQUAA4GN
ADCBiQKBgQDEpjxVc1X7TrnKmVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph 8r9RzgHU5VAK
MNcCY1osiRVwjt3J8CuFWqo/cVbLrzwLB+fxH5E2JCoTzyvV84J3PQO+K/67 GD4Hv0CAAmTX
p6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZcmC3+wIDAQABo4GUMIGRMBIGA1Ud EwEB/wQIMAYB
Af8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0cDovL2NybC50aGF3dGUuY29t L1RoYXd0ZVBl
cnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQDAgEGMCkGA1UdEQQiMCCk HjAcMRowGAYD
VQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0BAQUFAAOBgQBIjNFQ g+oLLswNo2as
Zw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3hYWLD2ToZfoSx mRsAxRoLgnSe
JVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1TXfjViF4 gtwhGTXeJLHT
HUb/XV9lTzGCA3EwggNtAgEBMHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT HFRoYXd0ZSBD
b25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h bCBGcmVlbWFp
bCBJc3N1aW5nIENBAhBi2E2zbOyC1fBY1nuIWKaQMAkGBSsOAwIaBQCgggHQ MBgGCSqGSIb3
DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA5MTExMDEwMTYx N1owIwYJKoZI
hvcNAQkEMRYEFKhNc0VinnDLX43Q+iAthcIsx8glMF8GCSqGSIb3DQEJDzFS MFAwCwYJYIZI
AWUDBAECMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0D AgIBQDAHBgUr
DgMCBzANBggqhkiG9w0DAgIBKDCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYD VQQGEwJaQTEl
MCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE AxMjVGhhd3Rl
IFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEGLYTbNs7ILV8FjWe4hY ppAwgYcGCyqG
SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRp
bmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3Vp
bmcgQ0ECEGLYTbNs7ILV8FjWe4hYppAwDQYJKoZIhvcNAQEBBQAEggEAdTg6 GCCKeYJA+rIb
dT6wKdQZd/OghD5dAW4jmMru0rWQAnBpydWrDSTPI588ooNdD5OcqBwBiM+M XJesuhFjE57+
K9Hp+o+XIg2n8WNqKCCqmr4+fpaUhpQASThwE2jRPnjPj+mX0Qz2j2BIyFCN 94AcwOCpjIk0
6KLAFlqCSXeSx9HhuSMFfBjHFxoVt3WWDeJq/X4gCQripmyqD6jLtpjLR4DH 3YRkkOMk2c93
9GoRKpfKSnsYhmmimBnZiE52teqRB/E4HiW1dMFFGCmJNEL948KXmr/0Ta0Y TgAmua1TcE4u
IXN0/0D+o4HjT557tx1PVs5an4i4kS1ml6NGnwAAAAAAAA==
--------------ms070706070805090302060800--