Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Craziest fix that actually worked

Craziest fix that actually worked

Scheduled Pinned Locked Moved The Lounge
helpcomdatabasesysadminquestion
46 Posts 38 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R rriegel

    Our company has to reboot our Win2008R2 server every morning at 6am so it performs right during the day. I think it's mainly related to our ERP system (Epicor) but it seems to work. I've worked with VMS systems that under a HEAVY load have way over a year of uptime with no problems, we had to shut it down to replace a hardware component :(

    L Offline
    L Offline
    LordWabbit1
    wrote on last edited by
    #22

    One company I worked for rebooted their Red Hat box every day at 4 in the morning, otherwise it would inexplicably freeze and drop messages (ie. money). It was not the OS's fault though, it was the crappy java/jboss app that did the messaging from the mainframe to swift and back. The log files it produced were over a gig each day and everyone spent some jail time sifting through them to try figure out what exactly caused the freeze. AFAIK they are still rebooting them every day.

    1 Reply Last reply
    0
    • R Reelix

      http://support.microsoft.com/kb/168702[^] - Method 2

      -= Reelix =-

      G Offline
      G Offline
      G Tek
      wrote on last edited by
      #23

      That is hilarious. I actually a lol moment when I read that. So all these years that I've made fun of people that continuously "exercised" their mouse while waiting for results (I've been guilty myself) and you're telling me that it's a legitimate solution? Too bad they don't give the explanation behind why the method works.

      E 1 Reply Last reply
      0
      • D Dan Neely

        I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

        Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

        E Offline
        E Offline
        englebart
        wrote on last edited by
        #24

        A person that used Scantron sheets for data entry upgraded their computer. After the upgrade, the computer could no longer communicate with the Scantron reader. It was a simple RS-232 interface. Reconnecting to the old computer, I noticed that the Scantron "ready" light would activate for about 30 seconds during which time the sheets would be successfully fed. With the new computer, the Scantron "ready" light would activate for about 0.2 seconds. Solution: toggle "Turbo" mode off for reading Scantrons. This gave them about a 5 second window to feed the sheet. Dang hard coded delay loops!

        1 Reply Last reply
        0
        • D Dan Neely

          I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

          Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

          E Offline
          E Offline
          Eric Whitmore
          wrote on last edited by
          #25

          I once had network problems at 10:12 am every morning. It turns out that the static electricity produced by office staff walking on the carpet at the office was running up an unplugged cat5 cable short circuiting the cheap hub we had. Unplugged the cable from the hub completely and no more problems. craziest problem i have ever had to solve.

          Eric

          1 Reply Last reply
          0
          • R rriegel

            Our company has to reboot our Win2008R2 server every morning at 6am so it performs right during the day. I think it's mainly related to our ERP system (Epicor) but it seems to work. I've worked with VMS systems that under a HEAVY load have way over a year of uptime with no problems, we had to shut it down to replace a hardware component :(

            D Offline
            D Offline
            DerekT P
            wrote on last edited by
            #26

            My very first paid job involved some Fortran development on an IBM360. I'd go home at 5pm each day, having logged out and powered down my terminal. (I don't recall what system we used, but this was 1977). Each morning I'd find the other staff scratching their heads about the mysterious crash of the '360 the evening before. This happened each day for a week until I overheard one of them saying "the only thing I can think causing it is someone's powering down their terminal". I left my terminal on after that and the daily crashing problem "went away". I never did own up.

            M 1 Reply Last reply
            0
            • A Argonia

              Ah, port 80 is really a bad idea. The default port of Skype is 80 and the XAMPP server's too. And i don't imagine working without skype and/or youtube

              Microsoft ... the only place where VARIANT_TRUE != true

              E Offline
              E Offline
              Ennis Ray Lynch Jr
              wrote on last edited by
              #27

              What a weird response, suggesting that somehow skype an use port 80 and not interfere with XAMPP but that somehow my code would have a problem. Normally, I would just say it is a little too late to go back to that decade and change code mandated by a very large client who would only open port 80 and just say, but only because I think honesty is the best policy, maybe you should go and learn how TCP/IP works.

              Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost "All users always want Excel" --Ennis Lynch

              1 Reply Last reply
              0
              • D Dan Neely

                I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

                Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

                C Offline
                C Offline
                Chris Quinn
                wrote on last edited by
                #28

                There was a problem with earlier versions of MSOffice where it would not install or run properly unless you renamed a particular TrueType font file (Hattenschwiller) - See here:[^]


                It's well known that if all the cat videos and porn disappeared from the internet there would be only one site left and it would be called whereareallthecatvideosandporn.com


                1 Reply Last reply
                0
                • D Dan Neely

                  I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

                  Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

                  G Offline
                  G Offline
                  GenJerDan
                  wrote on last edited by
                  #29

                  It happens with hardware, too. Our satellite dish would simply not track the damn satellite. I fixed it by disconnecting a blue wire. No idea what that particular blue wire was connecting...there were hundreds of them in there and we didn't have detailed schematics available. And, yes, the report we sent in closing the ticket did say "disconnected a blue wire". :laugh:

                  YouTube and My Mu[sic], Films and Windows Programs, etc.

                  1 Reply Last reply
                  0
                  • D Dan Neely

                    I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

                    Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

                    K Offline
                    K Offline
                    kalberts
                    wrote on last edited by
                    #30

                    Removing the PC cover to give the program enough space to fit in... This was back in the DOS days. It kept our hardware service guy puzzled for a week: As long as the cover was off the PC, the application ran flawlessly. Once he put the cover back on, the application crashed. The reason was that the program was too big for the physical memory, with no check for this to give a reasonable error message. Some PCs in those days had covers that slid backwards: You simply had to unplug the power cord and everything else before getting access to the inner workings. This was a deliberate security measure. You had to plug in the cables again after removing the cover; presumably the service man knew to be careful. After sliding the cover back on, he plugged in everything, including the mouse. We were running Win 2.11 at the time, starting Windows only for those special applications needing it. So during the boot, the driver tries to make contact with the mouse, succeeds, and stays in RAM. This DOS application didn't use the mouse; it was a pure command line application. At the hardware service bench, it failed to find any mouse (because it wasn't plugged in), terminated, and a couple hundred bytes were freed. Enough to make the application run. Obviously, we didn't really need to remove the cover - unplugging the mouse and rebooting would do the trick. But for a week, until we saw the light, the only way we knew to avoid the crash was to remoe the cover.

                    1 Reply Last reply
                    0
                    • E Erudite_Eric

                      Taking a space character out of a modem name string on Windows. Yep, it fixed it. Piece of shit MSFT parsing code!

                      B Offline
                      B Offline
                      BrainiacV
                      wrote on last edited by
                      #31

                      Erudite_Eric wrote:

                      Taking a space character out of a modem name string on Windows.

                      Yeah I had something like that, I had to take the space out of a window name. Only MSIE freaked when it had one.

                      Psychosis at 10 Film at 11 Those who do not remember the past, are doomed to repeat it. Those who do not remember the past, cannot build upon it.

                      1 Reply Last reply
                      0
                      • Sander RosselS Sander Rossel

                        A coworker had a SQL query in MS SQL Server that didn't run at all. All it did was process the query for a looooong time. My coworker entered a random line break somewhere and the query ran instantly. Weirdest performance fix I've ever seen... I've been searching for a problem in C#. I was using some library from a different solution which I had built myself. I encountered a bug, fixed the library and everything worked... For a few runs at least. Out of nowhere the bug came back. I spent the whole afternoon trying to fix it, but I got MessageBoxes that weren't there anymore, errors that could not be explained etc. Restarting VS2010 finally did the trick... Another great hack I've used: in a live production we print some files and save these files to disk and call them something like 'File+date+time+milliseconds'. Then our client got a new server and the files weren't saved to disk anymore because the filename was already used! Obviously the new server was so fast it could print and save two files in the same millisecond... A Thread.Sleep(500) fixed the problem! We've actually used that solution more than once... Although it's not something I'm particulary proud of, it does the job.

                        It's an OO world.

                        public class Naerling : Lazy<Person>{
                        public void DoWork(){ throw new NotImplementedException(); }
                        }

                        P Offline
                        P Offline
                        PIEBALDconsult
                        wrote on last edited by
                        #32

                        Naerling wrote:

                        A Thread.Sleep(500) fixed the problem!

                        I've used a Sleep(50) between reads of a socket to ensure unique timestamps for each message. :rolleyes:

                        1 Reply Last reply
                        0
                        • D Dan Neely

                          I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

                          Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

                          K Offline
                          K Offline
                          kalberts
                          wrote on last edited by
                          #33

                          In the late 1970s when 64 kbit RAM chips (yes, 8 kbyte) were appearing, they were plauged by bit errors said to be caused by alpha radiation from outer space. People were worried that no denser memory chips could be made. (I have no idea how they got around that problem, but that is irrelevant to this story.) Norsk Data, a Norwegian manufacturer of 16-bit minimachines, increased the number of ECC bits from five to six per 16-bit memory word (from 21 to 22 bits/word) to cope with the high bit error rate. Every time an error was corrected, a red LED on the memory card would flash up. If the LED was more or less constantly flashing, that card should be replaced. (Usually, it was sufficient to replace one or more unreliable RAM chips on the board - the chips varied in their sensitivity to this alpha radiation.) One of my colleauges was working at a satellite ground station - actually, the one used for the very first transatlantic Internet connection. It just had to be operational 24/7; computers couldn't be turned off to replace a memory card. So for this project, my colleague set up one of these minicomputers with 22 memory cards (!) which he had rewired to store one bit per card, rather than full words + ECC on one card. Now, if the warning LED was too busy on one of the cards, he could snap it out and insert a new one while the computer was running at full speed. Of course there would be a lot of bit errors while one of the 22 cards were missing, but the ECC could handle all 1-bit and most 2-bit errors (all? That math has left my brain...) until the new card was in place. This setup was used for actual production work for months (maybe years, I wasn't invoved myself). They kept a supply of tested spare memory cards, gradually weeding out those populated with less reliable chips, so the replacement rate was gradually falling. If anyone can point me to info on how the REAL problem was fixed - the alpha radiation sensitivity of the RAM chips - I would be curious to know!

                          M 1 Reply Last reply
                          0
                          • L Lost User

                            I once wrote a 6502 routine, running off an interrupt, to modify a single bit in memory when a particular byte of memory had a certain value. This allowed me to move the game "Frak!" from cassette tape to disk - as the anti-piracy software flipped the bit occasionally resulting in a rather amusing Captain Pugwash based "you're a Pirate" screen.

                            MVVM # - I did it My Way ___________________________________________ Man, you're a god. - walterhevedeich 26/05/2011 .\\axxx (That's an 'M')

                            E Offline
                            E Offline
                            eFotografo
                            wrote on last edited by
                            #34

                            Many (many!) years ago, I hooked up (soldered!) a second tape recorder to a standard Commodore VIC20 tape recorder, so I could (ahem :-)) "backup" game cassettes. Curiously the "backed up" cassettes would only load correctly (and only from the Commodore recorder) when the second tape recorder was still attached (but not recording) and only then if the speaker was switched on and at high volume.

                            D 1 Reply Last reply
                            0
                            • D Dan Neely

                              I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

                              Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

                              R Offline
                              R Offline
                              RafagaX
                              wrote on last edited by
                              #35

                              This a known error for those who use Excel Interop and also want to use it with a system account (mostly Windows services), and actually I encountered this problem once, the solution was that the installer of our application will create this folder if it didn't exist.

                              CEO at: - Rafaga Systems - Para Facturas - Modern Components for the moment...

                              1 Reply Last reply
                              0
                              • D Dan Neely

                                I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

                                Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

                                C Offline
                                C Offline
                                costas0811
                                wrote on last edited by
                                #36

                                Had built a Slot Machine game that was meant to be played on the iPad. When you spun the slot sounds played normally, but I guess there are restrictions so that sounds cannot be played unless it is a user event that spawns them. So I was at a loss. A slot machine without sounds is actually pretty lame. Friend suggested - as a complete guess - that I edit all the sounds into one massive wave file with gaps of time in between and that on the other timed events I just forward to the index where the sound plays that I need. It was so ludicrous that I did it as a joke to prove how badly it would not work, but of course it worked perfectly. Still can't believe that one.

                                1 Reply Last reply
                                0
                                • D Dan Neely

                                  I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

                                  Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

                                  P Offline
                                  P Offline
                                  patbob
                                  wrote on last edited by
                                  #37

                                  HW: video/audio recorder app running on a dual core laptop. Had to use windows boot options to set NUMCPUS to 1 so the video viewfinder display update wouldn't stop when the user stopped recording the audio. SW: Same app, video arrived as a series of undelineated JPEGs in a byte stream, 90 per second. 700 MHz computer couldn't run a loop to find the jpegs fast enough (it had to look for the first four bytes of a jpeg). Had to add an if at the top of the loop to check if the next couple of bytes in the byte stream were the first two bytes of a jpeg and continue if they were not.

                                  We can program with only 1's, but if all you've got are zeros, you've got nothing.

                                  1 Reply Last reply
                                  0
                                  • G G Tek

                                    That is hilarious. I actually a lol moment when I read that. So all these years that I've made fun of people that continuously "exercised" their mouse while waiting for results (I've been guilty myself) and you're telling me that it's a legitimate solution? Too bad they don't give the explanation behind why the method works.

                                    E Offline
                                    E Offline
                                    erzengel des lichtes
                                    wrote on last edited by
                                    #38

                                    I'm actually guilty of writing a program where, in one version, "move the mouse" was required to keep it from getting stuck while processing in certain conditions. In my case, I neglected to close a file that was reopened later. It got stuck because it was waiting for someone to release the file, but it was holding the file itself. Moving the mouse produced enough garbage to trigger the garbage collector, which then closed the file that was no longer in use. Once the finalizer had closed the file, the app was able to open the file and continue. It wasn't caught in QA because usually enough work was done in QA's tests that the garbage collector would be triggered at least once... Technicians only had to move the mouse for a few days while the patch went through QA...

                                    1 Reply Last reply
                                    0
                                    • D Dan Neely

                                      I'm just curious what the most surreal fix to a problem you've ever ran into has been? Trying to get some integration tests for an application that uses COM Interop to manipulate MS Excel on a new CI server a coworker and I ran into a problem where the tests would pass if ran manually; but when Cruise Control tried to run them we got an access denied type error when trying to write a file. The solution[^], courtesy of MSDN was to create a folder named Desktop in C:\Windows\SysWOW64\config\systemprofile. I don't even....

                                      Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt

                                      M Offline
                                      M Offline
                                      Mike Riley QUSA
                                      wrote on last edited by
                                      #39

                                      I worked for a company where a small group of us had created a multi-user OS that ran on x86 CPUs. I had created the filesystem design and all of a sudden we ran into an issue where directory blocks where somehow being written to the wrong place in the directory. This wiped out the entries that had been in that block and created duplicate directories entries for the files in the block that had been copied. We couldn't figure out the root cause, because it happened so rarely and only some customers saw it more than once. I used a spare dword in the header block, which stored the allocation block numbers for the file data as well as file attribute info, and stored the block number for the directory entry it should be using. There were then checks made in utilities for directory listings and file searches that checked that the correct directory entry was being used and reported an error if it saw a mismatch. So now duplicate directory entries showed as bad entries when doing a directory listing, but it didn't do that until well after it had occurred. So I added a check in the write directory block routine to also do the check. It would generate an error if it had ever been told to write a directory block to a sector that did not match what was in the file header. This would only happen during a create, close, or delete operation. Once the code with that check went out the error never happened again. No fix was done. I had only created a check to report an error to catch it happening before it wrote to the wrong directory sector. I called it the Schrodinger's Cat bug. Just looking in the box prevented it from ever happening. Mike

                                      1 Reply Last reply
                                      0
                                      • D DerekT P

                                        My very first paid job involved some Fortran development on an IBM360. I'd go home at 5pm each day, having logged out and powered down my terminal. (I don't recall what system we used, but this was 1977). Each morning I'd find the other staff scratching their heads about the mysterious crash of the '360 the evening before. This happened each day for a week until I overheard one of them saying "the only thing I can think causing it is someone's powering down their terminal". I left my terminal on after that and the daily crashing problem "went away". I never did own up.

                                        M Offline
                                        M Offline
                                        Member 3257606
                                        wrote on last edited by
                                        #40

                                        I read about a ground fault circuit trap tripped an old computer way back - but only after hours. The guy who tried to find it could watch it run for hours, and every time he came back after taking the elevator to get a cup of coffee, the computer would be down... My favorite fix came around February 2000 - a customer using an imaging system (third party software we provided running on SQL Server 6.5) was suddenly experiencing major performance issues and consistently timing out against the database. We couldn't change the app or the query it issued. The database seemed to be working fine, except for the one query, which had been working great until it suddenly started timing out. No amount of basic database repair or index tweaking seemed to help. We finally decided that the selectivity of one of the main indexes for the application caused the wrong plan to be chosen. Solution: Insert 40 thousand dummy records with the only purpose to change the selectivity of the index. Worked like a charm. I should mention that a subsequent service pack update to SQL Server allowed us to remove the dummy records.

                                        1 Reply Last reply
                                        0
                                        • K kalberts

                                          In the late 1970s when 64 kbit RAM chips (yes, 8 kbyte) were appearing, they were plauged by bit errors said to be caused by alpha radiation from outer space. People were worried that no denser memory chips could be made. (I have no idea how they got around that problem, but that is irrelevant to this story.) Norsk Data, a Norwegian manufacturer of 16-bit minimachines, increased the number of ECC bits from five to six per 16-bit memory word (from 21 to 22 bits/word) to cope with the high bit error rate. Every time an error was corrected, a red LED on the memory card would flash up. If the LED was more or less constantly flashing, that card should be replaced. (Usually, it was sufficient to replace one or more unreliable RAM chips on the board - the chips varied in their sensitivity to this alpha radiation.) One of my colleauges was working at a satellite ground station - actually, the one used for the very first transatlantic Internet connection. It just had to be operational 24/7; computers couldn't be turned off to replace a memory card. So for this project, my colleague set up one of these minicomputers with 22 memory cards (!) which he had rewired to store one bit per card, rather than full words + ECC on one card. Now, if the warning LED was too busy on one of the cards, he could snap it out and insert a new one while the computer was running at full speed. Of course there would be a lot of bit errors while one of the 22 cards were missing, but the ECC could handle all 1-bit and most 2-bit errors (all? That math has left my brain...) until the new card was in place. This setup was used for actual production work for months (maybe years, I wasn't invoved myself). They kept a supply of tested spare memory cards, gradually weeding out those populated with less reliable chips, so the replacement rate was gradually falling. If anyone can point me to info on how the REAL problem was fixed - the alpha radiation sensitivity of the RAM chips - I would be curious to know!

                                          M Offline
                                          M Offline
                                          Member 3257606
                                          wrote on last edited by
                                          #41

                                          ND was a great place to work!

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups