Home » Other » Suggestions & Feedback » Weird thing in SQL & PL/SQL forum
Weird thing in SQL & PL/SQL forum [message #493713] Wed, 09 February 2011 08:42 Go to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know if someone else sees the same thing.

In SQL & PL/SQL forum, the topic "Preform math calculation upon dates" at http://www.orafaq.com/forum/t/166852/102589/ is displayed with last update "Wed, 09 February 2011 11:23 By: Michel Cadot" but when you go into the topîc the last update was by cookiemonster (although at the same time).

More, even if I read it again and again, it still appears to me as unread topic in the list.

Anyone else in this case?

Regards
Michel
Re: Weird thing in SQL & PL/SQL forum [message #493721 is a reply to message #493713] Wed, 09 February 2011 09:06 Go to previous messageGo to next message
cookiemonster
Messages: 11287
Registered: September 2008
Location: Rainy Manchester
Senior Member
I was thinking of raising the exact same issue. So yes I can see it too.
I reckon we both posted at the exact same second and there are ordering issues.
Re: Weird thing in SQL & PL/SQL forum [message #493726 is a reply to message #493721] Wed, 09 February 2011 09:44 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes exactly!

But what about this?
Quote:
"More, even if I read it again and again, it still appears to me as unread topic in the list"

Same for me.
I have replied to the last message(deleted) and verified from that moment It appears as a read topic to me !

Sriram

[Updated on: Wed, 09 February 2011 09:45]

Report message to a moderator

Re: Weird thing in SQL & PL/SQL forum [message #493728 is a reply to message #493726] Wed, 09 February 2011 09:54 Go to previous messageGo to next message
cookiemonster
Messages: 11287
Registered: September 2008
Location: Rainy Manchester
Senior Member
I rather suspect that's a knock-on effect from the discrepancy between the last message in the thread and what the forum says is the last message.

Frank Naude should be able to answer for sure.
Re: Weird thing in SQL & PL/SQL forum [message #493731 is a reply to message #493728] Wed, 09 February 2011 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I already PMed him but he is currently very busy with his own work and as this is not an urgent case...

Regards
Michel
Re: Weird thing in SQL & PL/SQL forum [message #493756 is a reply to message #493731] Wed, 09 February 2011 12:31 Go to previous messageGo to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
It was a minor data corruption - probably a MySQL concurrency issue.
The problem was fixed by adding another reply.
Re: Weird thing in SQL & PL/SQL forum [message #493757 is a reply to message #493756] Wed, 09 February 2011 12:35 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks
Michel
Re: Weird thing in SQL & PL/SQL forum [message #493759 is a reply to message #493757] Wed, 09 February 2011 13:55 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8024
Registered: November 2002
Location: California, USA
Senior Member
It still shows as unread for me. It may show read for those of you who have replied then deleted, but for those of us who have not replied it still shows unread. I tried reading it again and refreshing my browser, but that thread still shows unread. Even in a new window it shows unread. I will refrain from replying, so that I will still be able to test whether it shows read or unread after any further changes.


Re: Weird thing in SQL & PL/SQL forum [message #493761 is a reply to message #493759] Wed, 09 February 2011 14:03 Go to previous message
Barbara Boehmer
Messages: 8024
Registered: November 2002
Location: California, USA
Senior Member
After Cookie Monster's latest reply, it now shows read. Apparently, if anybody replies, then that fixes the problem, but if that reply is deleted, then the problem returns. It looks like maybe an issue where one thing relies on a timestamp of some sort and another relies on an auto-incrementing key and there is some conflict when there are two replies at the same time. When there is another record (reply) added, then the other two are not referenced, so there is no conflict.
Previous Topic: OFM - IPM & UCM
Next Topic: Is Marketplace is right place to post about the blogs
Goto Forum:
  


Current Time: Sat Dec 27 14:10:02 CST 2014

Total time taken to generate the page: 0.11482 seconds