Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>So you have 2 services, configured the same way, except that one fails over correctly and the other doesn't?</p> <p>There is a general rule of thumb when you're seeing something that looks impossible. And that rule is that you're not seeing what you think you are seeing. Frequently because of what is jokingly referred to as PEBKAC (Problem Exists Between Keyboard And Chair). The really frustrating thing is that, no matter how obvious it is, you can stare at it 100 times and it won't be obvious because you see what you "know" is there rather than what is there.</p> <p>In my experience there are two good ways to solve this kind of problem.</p> <ol> <li>Take it to someone else, and ask them to find what you're doing differently. Given that they see what is there, and not what you "know" is there, they will often see what you can't. (In full course of time you may be able to return the favor some day.)</li> <li>Start with the working configuration and the non-working one, and start "bisecting" the path between them until you get a minimal difference that tells the difference between working and non-working. Whittle that difference down, and you'll either know what to fix, or else have a test case to give someone else.</li> </ol> <p>Odds are that you'll need to follow the second approach. You probably don't want to - I never do - but it usually is less painful than you imagine. You start by replicating the full application on a test system, and demonstrating that you have the same failure. (If you don't, then you start looking, carefully, for differences between production and test. In particular look at things like operating system version, library versions, and the like.)</p> <p>Assuming that you have a test system, save that configuration. Then start ripping out large chunks of your actual application that you imagine have nothing to do with your configuration problems, testing periodically that you are on the right path. (And saving every time that you are.) Once you have a minimal application, start trying to walk it over towards the working test application. Somewhere you'll find a change that makes a difference. It could be anywhere. Once you have found it, you'll usually know exactly how to fix your production system. Or if you don't, you'll know your problem fairly clearly.</p> <p>Sometimes you'll have found a weird bug. If so, then you should then start trying to simplify everything as much as possible until you have a nice bug report to send in.</p>
    singulars
    1. This table or related slice is empty.
    1. POClustering doesn't work
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USbtilly
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO@ Btilly, there is nothing wrong with the configuration because i tried this for 2-3 test application and all are working fine but when i am try to achieve the same for my great webapp it doesn't work. There might be something wrong in the application security or anywhere else that me and my team is not able to trace.
      singulars
      1. PO
      1. USR. Rahul
    2. CO@Kuri: Somewhere deep in the application it may be caching stuff in a way that you are not aware of. For instance someone wrote stuff to files. Anyways the binary search algorithm that I described, as big a PITA as it may be, is the only method that I am aware of for tracking down entirely unknown differences in a lot of code. And you have an entirely unknown difference to deal with.
      singulars
      1. PO
      1. USbtilly
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload