[support] Drupal, MySQL 5, and caching?

[codepoet at codepoetry.net]

On Dec 7, 2005, at 11:57 AM, Chris Johnson wrote:

> codepoet at codepoetry.net wrote:
>> I'm running into a bit of a problem and I'm not seeing an out.  I  
>> run  several Drupal sites that work just fine (macgeekery.com and   
>> codepoetry.net among them) so I'm not new to this, but this one  
>> has  me a bit confused.
>
>
>> The very first page loads without issue after I turn on caching.   
>> The  next load of that page as an anonymous user, coming from the  
>> cache I  would suppose, gives me a white screen with no errors in  
>> the Apache  error log (and a 200 in the access).  In the watchdog  
>> log I get the  famed error:
>> Duplicate entry 'http://triton.codepoetry.net/' for key 1 query:   
>> INSERT INTO cache (cid, data, created, expire, headers) VALUES   
>> ('http://triton.codepoetry.net/', '
>
> Have you tried doing an SQL "DELETE FROM cache" and turning caching  
> back on and see if the problem persists?
>
> ..chrisxj

Yes, and the symptom is that I got one page load out of it before  
failure from the new cache.  The final resolution on that site turned  
out to be making the table column a LONGBLOB instead of LONGTEXT.   
I'm trying a copy of a live site now and seeing if that will work  
there as well.