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.
I installed a fresh copy of 4.6.4 on a brand new Linux 2.6 server running:
Apache 2.0.54 PHP 5.0.5 MySQL 5.0.16
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/', '
I searched Google and drupal.org and got a *lot* of hits ... and read them all. This incarnation, however, isn't a race condition as older forum posts would indicate ... this is every single page hit to a cached page.
If I turn off caching then the site works as expected, logged in or anonymous.
Now, CP and MG are run from MySQL 4.1, so is it possible some SQL behavior changed in-between that Drupal doesn't like? Is anyone using MySQL 5 with caching and no errors?
Thanks for anything you have...
http://drupal.org/node/30920 http://drupal.org/node/38804
Altered the table accordingly:
alter table cache change data data longblob not null;
And life was good. Next I move a complete site over, make the change, and see what happens...
[This message for the sake of drifters and list archives.]
On Dec 7, 2005, at 10:42 AM, codepoet@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.
I installed a fresh copy of 4.6.4 on a brand new Linux 2.6 server running:
Apache 2.0.54 PHP 5.0.5 MySQL 5.0.16
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/', '
I searched Google and drupal.org and got a *lot* of hits ... and read them all. This incarnation, however, isn't a race condition as older forum posts would indicate ... this is every single page hit to a cached page.
If I turn off caching then the site works as expected, logged in or anonymous.
Now, CP and MG are run from MySQL 4.1, so is it possible some SQL behavior changed in-between that Drupal doesn't like? Is anyone using MySQL 5 with caching and no errors?
Thanks for anything you have...
codepoet@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
On Dec 7, 2005, at 11:57 AM, Chris Johnson wrote:
codepoet@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.
-
Chris Johnson -
codepoet＠codepoetry.net