KnitWitch
Strange new message
I'm getting a variation on this message at the top of every page today: "user warning: Duplicate entry '652586' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Website Bugs/Support Requests/Feature Requests', 'forum/17', 'http://www.scottsigler.com/forum', '70.56.55.134', 52, 'd1f56692a8413e5bf0fa1574438cfeb5', 520, 1198871084) in /home/scottweb/www.scottsigler.com/htdocs/includes/database.mysql.inc on line 172." Robbie or Paul, any ideas what this is about???

--------------
MaiPhoenix

(aka KnitWitch)

KnitWitch
Re: Strange new message
FYI, after completing the Forum topic post I got this at the top of the page (messages are in a pink box with a caution triangle at the left): " * user warning: Duplicate entry '652586' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Preview', 'node/add/forum/17', 'http://www.scottsigler.com/node/add/forum/17', '70.56.55.134', 52, 'd1f56692a8413e5bf0fa1574438cfeb5', 712, 1198871170) in /home/scottweb/www.scottsigler.com/htdocs/includes/database.mysql.inc on line 172. * user warning: Duplicate entry '652586' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Submit Forum topic', 'node/add/forum/17', 'http://www.scottsigler.com/node/add/forum/17', '70.56.55.134', 52, 'd1f56692a8413e5bf0fa1574438cfeb5', 156, 1198871203) in /home/scottweb/www.scottsigler.com/htdocs/includes/database.mysql.inc on line 172." ------------ KnitWitch http://www.knitwitchzone.com

--------------
MaiPhoenix

(aka KnitWitch)

treed
Re: Strange new message
and fix it soon * It's all about the Numbers, my friends The Math god

#
The Math God of the Past
THE Mister Biz-Nass, Your friendly neighborhood Tourette-Syndrome-afflicted, throat-cancer-surviving fortune-teller who speaks through a voice box.
The Past Future gay Chief of the SFPD (the original podcast of Nocturnal)
http:Bitstrips TREED!
http://GoAnimate TREED!

Gmork
Re: Strange new message
I am getting this same error and unlike KnitWitch, I received it upon accessing the forums and before I had posted anything. ___________________ $DO || ! $DO ; try try: command not found
ogreoregon
Re: Strange new message
the portal code. This is the website for the Pastafarian Deity the Flying Spaghetti Monster, Right? I looked him up on Wikipedia and when I joined I promised I would be loyal, but I change to Siglerism and now they are trying to GET US ALLL!!!!!
*I am the Rear Admiral but Sigler gives the Orders*
stormwalker4
Re: Strange new message
I got it as soon as I logged in.
stormwalker
pulsar
Re: Strange new message

I'm hunting this bug for weeks already, still need to figure out why the database gets out of sync for no apparent reason as it seems. It might be some weird issue with the paravirtualized kernel and running the block devices on loops. *sigh* 

 

--

Paul.

/(bb|[^]b{2})/

--

Paul.

/(bb|[^]b{2})/

KnitWitch
Re: Strange new message
I hadn't seen this the last time I logged in a few days ago. ------------ KnitWitch http://www.knitwitchzone.com

--------------
MaiPhoenix

(aka KnitWitch)

KnitWitch
Re: Strange new message
Thanks! ------------ KnitWitch http://www.knitwitchzone.com

--------------
MaiPhoenix

(aka KnitWitch)

treed
Re: Strange new message
okok, i know SOME geek speek, but this is OUT of my league........... * It's all about the Numbers, my friends The Math god

#
The Math God of the Past
THE Mister Biz-Nass, Your friendly neighborhood Tourette-Syndrome-afflicted, throat-cancer-surviving fortune-teller who speaks through a voice box.
The Past Future gay Chief of the SFPD (the original podcast of Nocturnal)
http:Bitstrips TREED!
http://GoAnimate TREED!

Gmork
Re: Strange new message
Also lettinh ya know that it seems to have fixed itself. I havent gotten the error today when logging in ___________________ $DO || ! $DO ; try try: command not found
pulsar
Re: Strange new message

Thank you all for keeping the head up. I've just updated some userspace packages and more importantly - the kernel. Furthermore I've also diabled some more or less aggressive optimization tools. If the problems surfaces up again I can be at least sure it has nothing to do with that.

Cheers!
Paul.

--

Paul.

/(bb|[^]b{2})/

ogreoregon
Re: Strange new message
I know nothing about what you said you were doing on these lasts couple of posts, but I am just really glad that YOU do. thank you!
*I am the Rear Admiral but Sigler gives the Orders*
pulsar
Re: Strange new message

Got that bastard! Was a nasty (read stupid) one. That "Duplicate Entry" problem was a reoccuring one - bugging me for several weeks. Now its finally gone for good.

This was the last critical issue I have had to fix since we have moved this site to a new server.

From now on I'll be looking more into performance and more "visible" improvements.  You might even notice a small performance boost today. Just finished optimizing the database, php and apache subsystems.

Cheers!
Paul.

--

Paul.

/(bb|[^]b{2})/

ogreoregon
Re: Strange new message
I don't kow waht you did, but I am glad you did it.
*I am the Rear Admiral but Sigler gives the Orders*
KnitWitch
Re: Strange new message
Thank you muchly, darlin'! ------------ KnitWitch http://www.knitwitchzone.com

--------------
MaiPhoenix

(aka KnitWitch)

Gmork
Re: Strange new message
Awesome, Pulsar! Thanks for the update, too! ___________________ $DO || ! $DO ; try try: command not found
john83
Re: Strange new message
thnx alot , probbaly explains why i couldn't reach this site for a little while earlier today !
pulsar
Re: Strange new message

Yes, I had to do some restarts yesterday.

Now we have issues with the drupal massmailer plugin which apparently choked the server yesterday. But this is a whole different storry now. It never gets boring :)

Cheers!
Paul.

 

--

Paul.

/(bb|[^]b{2})/

treed
Re: Strange new message
technology is such fun * It's all about the Numbers, my friends The Math god

#
The Math God of the Past
THE Mister Biz-Nass, Your friendly neighborhood Tourette-Syndrome-afflicted, throat-cancer-surviving fortune-teller who speaks through a voice box.
The Past Future gay Chief of the SFPD (the original podcast of Nocturnal)
http:Bitstrips TREED!
http://GoAnimate TREED!

DragonRiderOfPernEatenByAncestors
Re: Strange new message
The Irishman from Ohio
The Irishman from Ohio
Welcome Guest!
| Register
Empty
18,486 Junkies | 1 Online Now