Strange and Mysterious LISTS Keys (AREV Specific)
At 02 JAN 2004 10:56:31AM Ralph Johler wrote:
Our LISTS table is bursting at the seams!!! And we then get lots of error messages, that as far as we can tell aren't. Like "error deleteing blahblah in table LISTS" but the list is actually getting deleted. BUT the batch overnight job sits there whating for a human to press a key to continue, and then if finishes but really late.
We can't just clear the LISTS table, as we run 24/7 and there is always something good in LISTS. Our LISTS table is set to 4K framesize, sizelock is 2, we have 55K rows, the LK table is 735MB and the OV is 1,493MB. Novell 5.5 sp6 with NLM 1.5.
We find lots (over 6,000 now and counting) rows in our LISTS table, just counting the first row, sometimes we go up to *25 or more. They all start with "SK" appear to have a timestamp counter, a ":" and then what looks to be part of the MAC like this:
SK15927:D83Can't find any of our code that generates these (but that doesn't mean there isn't we have a pretty big collection of code) - any ideas? Are these rows coming from some RTI code? Save_list_sub or something?
Anyone know what these Strange and Myserious LISTS keys are from?
At 02 JAN 2004 11:03AM Victor Engel wrote:
Those don't look like any kind of generic records I can think of.
If you don't need to share lists, you might want to consider having a local version of the LISTS file. This would substantially cut down on network traffic. On the other hand, it would make management of the mysterious records more difficult since they wouldn't be centrally located anymore, so you probably should find out where they're coming from first.
At 02 JAN 2004 11:14AM The Sprezzatura Group wrote:
Do you have any workstations with names such as "Andrew's Machine"? Specifically spaces, apostrophes or quotes.
The Sprezzatura Group
World Leaders in all things RevSoft
At 02 JAN 2004 02:31PM Ralph Johler wrote:
Generally, no. Most of the workstations with last the 3 digits of the MAC address matching the "SK12345:D83" list key do not. They have mixed alpha-numeric names like CR07.
The rest I don't have easy access to, how important is it to know about spaces and apotophe's - I could check if.
At 03 JAN 2004 04:16AM The Sprezzatura Group wrote:
The apostrophes, quotes and spaces led to an "unable to delete" message as the system tries to DELETE-LIST ANDREW'S MACHINE*DDMMYY*HHSS type thing and naturally TCL can't parse this properly.
The Sprezzatura Group
World Leaders in all things RevSoft