Re: [WebDNA] Crashing Database
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106167
interpreted = N
texte = --Apple-Mail-4--219671623Content-Type: multipart/alternative;boundary=Apple-Mail-3--219672458--Apple-Mail-3--219672458Content-Transfer-Encoding: 7bitContent-Type: text/plain;charset=US-ASCII;delsp=yes;format=flowedHave you looked at the database in a text editor, i.e. BBedit, to look for corruption or possibly no CR in the final record?-JeffOn Jan 24, 2011, at 4:16 PM, World Wide Art wrote:> Hi all,>> We have a database (about 12MB) that will crash/lock up the server. > We have moved from a PPC to an Intel (mac) computer and still have > the same problem. Sometimes (not always) when we update this > database (always the same one) WebDNA locks up. The server will > still serve pages that don't require database access, all others > are dead. The only way to fix the problem is to re-start the > computer. Re-starting Apache does not work. Any ideas to solve this > problem would be greatly appreciated?>> Thanks,> david.>> World Wide Art, Art Gallery and Custom Framing> questions@world-wide-art.com> Disney Preferred Animation Art Gallery> Specializing in Limited Editions by Today's Top Artists and Custom> Conservation Framing.> http://www.world-wide-art.com> 1-800-518-8453 or 1-510-538-8453>>> --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/ > list/talk@webdna.us Bug Reporting: support@webdna.us
Art.vcf>>--Apple-Mail-3--219672458Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=US-ASCIIHave you looked at the database in a text editor, i.e. BBedit, to look =for corruption or possibly no CR in the final =record?
-Jeff
On Jan 24, =2011, at 4:16 PM, World Wide Art wrote:
Hi =all,
We have a database (about 12MB) that will =crash/lock up the server. We have moved from a PPC to an Intel (mac) =computer and still have the same problem. Sometimes (not always) when we =update this database (always the same one) WebDNA locks up. The server =will still serve pages that don't require database access, all others =are dead. The only way to fix the problem is to re-start the computer. =Re-starting Apache does not work. Any ideas to solve this problem would =be greatly =appreciated?
Thanks,
david.
World Wide Art, =Art Gallery and Custom Framing
Disney Preferred Animation Art Gallery
Specializing in =Limited Editions by Today's Top Artists and =Custom
Conservation =Framing.
1-800-518-8453 or 1-510-538-8453
=--------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list =
. To unsubscribe, E-mail to: =archives: http://mail.webdna.us/l=ist/talk@webdna.us Bug Reporting: support@webdna.us<World-Wide-Art.vcf>
=--Apple-Mail-3--219672458----Apple-Mail-4--219671623Content-Transfer-Encoding: base64Content-Type: application/pkcs7-signature;name=smime.p7sContent-Disposition: attachment;filename=smime.p7sMIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIILEzCCBN0wggPFoAMCAQICEHGS++YZX6xNEoV0cTSiGKcwDQYJKoZIhvcNAQEFBQAwezELMAkGA1UEBhMCR0IxGzAZBgNVBAgMEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBwwHU2FsZm9yZDEaMBgGA1UECgwRQ29tb2RvIENBIExpbWl0ZWQxITAfBgNVBAMMGEFBQSBDZXJ0aWZpY2F0ZSBTZXJ2aWNlczAeFw0wNDAxMDEwMDAwMDBaFw0yODEyMzEyMzU5NTlaMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsjmFpPJ9q0E7YkY3rs3BYHW8OWX5ShpHornMSMxqmNVNNRm5pELlzkniii8efNIxB8dOtINknS4p1aJkxIW9hVE1eaROaJB7HHqkkqgX8pgV8pPMyaQylbsMTzC9mKALi+VuG6JG+ni8om+rWV6lL8/K2m2qL+usobNqqrcuZzWLeeEeaYji5kbNoKXqvgvOdjp6Dpvq/NonWz1zHyLmSGHGTPNpsaguG7bUMSAsvIKKjqQOpdeJQ/wWWq8dcdcRWdq6hw2v+vPhwvCkxWeM1tZUOt4KpLoDd7NlyP0e03RiqhjKaJMeoYV+9Udly/hNVyh00jT/MLbu9mIwFIws6wIDAQABo4IBJzCCASMwHwYDVR0jBBgwFoAUoBEKIz6W8Qfs4q8p74Klf9AwpLQwHQYDVR0OBBYEFImCZ33EnSZwAEu0UEh83j2uBG59MA4GA1UdDwEB/wQEAwIBBjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDARBgNVHSAECjAIMAYGBFUdIAAwewYDVR0fBHQwcjA4oDagNIYyaHR0cDovL2NybC5jb21vZG9jYS5jb20vQUFBQ2VydGlmaWNhdGVTZXJ2aWNlcy5jcmwwNqA0oDKGMGh0dHA6Ly9jcmwuY29tb2RvLm5ldC9BQUFDZXJ0aWZpY2F0ZVNlcnZpY2VzLmNybDARBglghkgBhvhCAQEEBAMCAQYwDQYJKoZIhvcNAQEFBQADggEBAJ2Vyzy4fqUJxB6/C8LHdo45PJTGEKpPDMngq4RdiVTgZTvzbRx8NywlVF+WIfw3hJGdFdwUT4HPVB1rbEVgxy35l1FM+WbKPKCCjKbI8OLp1Er57D9Wyd12jMOCAU9sAPMeGmF0BEcDqcZAV5G8ZSLFJ2dPV9tkWtmNH7qGL/QGrpxp7en0zykX2OBKnxogL5dMUbtGB8SKN04g4wkxaMeexIud6H4RvDJoEJYRmETYKlFgTYjrdDrfQwYyyDlWjDoRUtNBpEMD9O3vMyfbOeAUTibJ2PU54om4k123KSZB6rObroP8d3XK6Mq1/uJlSmM+RMTQw16Hc6mYHK9/FX8wggYuMIIFFqADAgECAhEA+iab9x1bqDObIzlE8HwITzANBgkqhkiG9w0BAQUFADCBrjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExha2UgQ2l0eTEeMBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExhodHRwOi8vd3d3LnVzZXJ0cnVzdC5jb20xNjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xpZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBFbWFpbDAeFw0xMDA3MDEwMDAwMDBaFw0xMTA3MDEyMzU5NTlaMIHcMTUwMwYDVQQLEyxDb21vZG8gVHJ1c3QgTmV0d29yayAtIFBFUlNPTkEgTk9UIFZBTElEQVRFRDFGMEQGA1UECxM9VGVybXMgYW5kIENvbmRpdGlvbnMgb2YgdXNlOiBodHRwOi8vd3d3LmNvbW9kby5uZXQvcmVwb3NpdG9yeTEfMB0GA1UECxMWKGMpMjAwMyBDb21vZG8gTGltaXRlZDEWMBQGA1UEAxMNSmVmZnJleSBKb25lczEiMCAGCSqGSIb3DQEJARYTampvbmVzQHN5bmVyZ29zLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAM3lJNEqUw8rDp12YIGSoIrOGHd6RfoE+IvmJXEm4XQwivI7E3Z9yAdGeY31g7dihi0lYkuH5h1A3GmxqgNAyXy6Lk+9SoTWjSSFxlIbwxYP1htK1Zvt07/7FVkee65LfCIKpIvCkhoshOQXpTfqXgmO1rN00moEyJK+9qLJU/r+qG6pX6mNU/ujCCgMD3ykT9raG9dopBaybYk3RkXVJkgOgxbRvBU/Kx7v5p2qNXkzUwCYqpTPvH6zDnDUV1YrltZYr/AXOwpSGzlTepkLxlaHlGa2WrcYuiMbR7yC8PWUwmRlYHFonLgGckh6FVgNX73+N3QZzCEazp50DrIELF8CAwEAAaOCAhUwggIRMB8GA1UdIwQYMBaAFImCZ33EnSZwAEu0UEh83j2uBG59MB0GA1UdDgQWBBT0iTceyMud0BGoLXy1ghkPj8s6zDAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMIGlBgNVHR8EgZ0wgZowTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL1VUTi1VU0VSRmlyc3QtQ2xpZW50QXV0aGVudGljYXRpb25hbmRFbWFpbC5jcmwwSqBIoEaGRGh0dHA6Ly9jcmwuY29tb2RvLm5ldC9VVE4tVVNFUkZpcnN0LUNsaWVudEF1dGhlbnRpY2F0aW9uYW5kRW1haWwuY3JsMGwGCCsGAQUFBwEBBGAwXjA2BggrBgEFBQcwAoYqaHR0cDovL2NydC5jb21vZG9jYS5jb20vVVROQUFBQ2xpZW50Q0EuY3J0MCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5jb21vZG9jYS5jb20wHgYDVR0RBBcwFYETampvbmVzQHN5bmVyZ29zLmNvbTANBgkqhkiG9w0BAQUFAAOCAQEAkj37MktQR+BQPkguH9fSevTnl5dEtRvu1+d3HtfwU+j2ybIlqb1vpaslWJvg3KLmDy+ch/GSnaJZ1EKaJE1BJ+SbDW7zSgEGogdRjxZbQ8wjSJtzLnFvXF/PSQGZTI9D/R/49y4PzuC2xmNN5A7k7NZ4LsURatHNJMJwzrBYPbgbgERVylqRSL+a73+rPeri23/h0PW3B8eK+nXNkDPjaoPIXhuI3xn5ecC7AopJBDlMTxHAtgQn127ZFnURcKrUjhKopCMkxoo7N6B8/unPeA5N9sbf/Ir4dyNFVCzOSDnIaKGZklF+RIOCq4uR1hHZ/U1deecV6w+2Nz2CmrJAfjGCA/8wggP7AgEBMIHEMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsAhEA+iab9x1bqDObIzlE8HwITzAJBgUrDgMCGgUAoIICDzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xMTAxMjUwMDI1MDhaMCMGCSqGSIb3DQEJBDEWBBQYdztCXJNh2RZzsMdCCJdyEGPD/DCB1QYJKwYBBAGCNxAEMYHHMIHEMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsAhEA+iab9x1bqDObIzlE8HwITzCB1wYLKoZIhvcNAQkQAgsxgceggcQwga4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJVVDEXMBUGA1UEBxMOU2FsdCBMYWtlIENpdHkxHjAcBgNVBAoTFVRoZSBVU0VSVFJVU1QgTmV0d29yazEhMB8GA1UECxMYaHR0cDovL3d3dy51c2VydHJ1c3QuY29tMTYwNAYDVQQDEy1VVE4tVVNFUkZpcnN0LUNsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgRW1haWwCEQD6Jpv3HVuoM5sjOUTwfAhPMA0GCSqGSIb3DQEBAQUABIIBAGWldih8vJyIyabYFPBrFRnhfr99MdKAtLdeklOl/VTbRG+Yzj+jvhxqbZRFlGovVlBNnyH/UGOBE1zn/e62Zy0V7qaCdWVp59ivqYQwFtZbb0hNIQ0U6IQHHxo2vPMmV2tdhVfetIZRvTseIXPmjnsi56YKfPoUpXkd5gTiyH8tcpW6mD67jPK4t7MtfIez3o4QgWYHhK3+0wEcJU61gMMNewc6upIWk9usT9uwYcTKGRyNKibybbCb/T3qDPgjOJDMQEYAGa9xyObnQ2qdPEk7A3HIq+zIEClYGvkl0J1FBRUjtNOs3KWZ7uQ6uh6gKhw0J/1DGuZJKT/gtt+jReEAAAAAAAA=--Apple-Mail-4--219671623--
Associated Messages, from the most recent to the oldest: