Create an Account
username: password:
 
  MemeStreams Logo

The OID Problem

search

Decius
Picture of Decius
Decius's Pics
My Blog
My Profile
My Audience
My Sources
Send Me a Message

sponsored links

Decius's topics
Arts
  Literature
   Sci-Fi/Fantasy Literature
  Movies
   Sci-Fi/Fantasy Films
  Music
   Electronic Music
Business
  Finance & Accounting
  Tech Industry
  Telecom Industry
  Management
  Markets & Investing
Games
Health and Wellness
Home and Garden
  Parenting
Miscellaneous
  Humor
  MemeStreams
Current Events
  War on Terrorism
Recreation
  Cars and Trucks
  Travel
Local Information
  United States
   SF Bay Area
    SF Bay Area News
Science
  Biology
  History
  Math
  Nano Tech
  Physics
Society
  Economics
  Politics and Law
   Civil Liberties
    Internet Civil Liberties
    Surveillance
   Intellectual Property
  Media
   Blogging
Sports
Technology
  Computer Security
  Macintosh
  Spam
  High Tech Developments

support us

Get MemeStreams Stuff!


 
The OID Problem
Topic: MemeStreams 3:16 pm EDT, Jul 29, 2007

This morning a few links popped up on MemeStreams that don't work if you click on them. You get an error message which says "I could not find the proper URL based on the OID. You may have reached this page due to an error."

We realize that this is a serious problem. Unfortunately, it is not a simple to fix and it is going to take time.

When we first started working on this project back in 2001 we were completely green at relational database design, and we made a poor decision, which was to use a feature of Postgresql called "OID" which at the time was defined as globally unique for an entire database. Unfortunately, the Postgres team later decided that this was impossible, and change the definition of OID. In newer versions of the database, which we are running due to numerous performance enhancements, OIDs aren't globally unique, or even unique to a table.

At this point, unfortunately, we had a hell of a lot of code invested in OIDs. We figured it would be a long, long time before OIDs would end up repeating in our database, and so we could wait to change all of that code. Unfortunately, today, OIDs appear to have started repeating in the blog table far in advance of when we thought this was likely, as this table only has 44,000 entries. There are about 500 references to OIDs in our code, and in order to fix this problem, we'll likely have to change them all.

This is going to require time from us, and hopefully patience from you.



 
 
Powered By Industrial Memetics
RSS2.0