[ic] Sudden loss of products.comment in otherwise perfect catalog

[interchange-users@interchange.redhat.com (Dan Browning)]

(dedicated RH 7.2, IC 4.8.3, RPC mode, Pgsql database)

The "comment" field (AKA "long description") of ~75% of a client's products 
went blank (NULL) recently.  TGIF (Thank Goodness I Found a backup).  I 
don't yet have enough data to be useful to anyone (I can't even reproduce 
the problem yet), but I thought there was a chance someone had already seen 
this one or had some ideas.

The only connecting factor between the ones that disappeared is that they 
were quite large and full of HTML tags.  (The 25% that remain have simple 
one-line entries in the comment field).

  * We don't know the specific time it happened
  * Current Intel says no one was using the admin
  * error.log, /var/log/messages, and logs/* didn't reveal anything
  * I'm thinking about turning on query logging, but I'll probably wait 
until I can reproduce it.

At any rate, just posting as a shot in the dark.  :-)


+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Dan Browning, Kavod Technologies <db@kavod.com>
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
While you don't greatly need the outside world, it's still very
reassuring to know that it's still there.