Database-Problem

Help
Jens Wulf
2007-07-03
2012-12-29
  • Jens Wulf

    Jens Wulf - 2007-07-03

    Hello,

    i got a strange Problem here:

    GTM>W $ZV
    GT.M V5.2-000 Linux x86
    GTM>S GL="^SD010V" S GL=$Q(@GL) W "***",GL,"***",!,"###",@GL,"###"
    ***^SD010V(0,300009,2)***
    ###
    %GTM-E-GVUNDEF, Global variable undefined: ^SD010V("0","300009","2")
    %GTM-I-RTSLOC,          At M source location ^GTM$DMOD

    GTM>ZWR ^SD010V
    ^SD010V("0","021683","2")=";;38.15;;34.00;;;;;;;;;;;;;;;;;34.00;48.75"
    ^SD010V("0","021683","4")=";;;;;;;;;;;;;;;;001"
    ^SD010V("0","021684","2")=";;15.2;;;;;;;;;;;;;;;;;;;13.55;48.75"
    ^SD010V("0","021684","4")=";;;;;;;;;;;;;;;;001"
    ^SD010V("0","021686","2")=";;43.3;;38.60;;;;;;;;;;;;;;;;;38.60;48.75"
    ^SD010V("0","021687","2")=";;84.1;;;;;;;;;;;;;;;;;;;74.95;48.75"
    ...
    With $Q it finds a node which does not really exist and which is not the first node.

    mupip integ reports no errors in Database.
    mupip reorg doesn't change anything

    anything else i can check ?

    Greets

    Jens

     
    • Narayanan S Rajamani

      I tried running the following M program (based on the data seen above) and got the expected output with GT.M V5.2-000.

      x    ;
          set ^SD010V("0","021683","2")=";;38.15;;34.00;;;;;;;;;;;;;;;;;34.00;48.75"
          set ^SD010V("0","021683","4")=";;;;;;;;;;;;;;;;001"
          set ^SD010V("0","021684","2")=";;15.2;;;;;;;;;;;;;;;;;;;13.55;48.75"
          set ^SD010V("0","021684","4")=";;;;;;;;;;;;;;;;001"
          set ^SD010V("0","021686","2")=";;43.3;;38.60;;;;;;;;;;;;;;;;;38.60;48.75"
          set ^SD010V("0","021687","2")=";;84.1;;;;;;;;;;;;;;;;;;;74.95;48.75"
              S GL="^SD010V" S GL=$Q(@GL) W "***",GL,"***",!,"###",@GL,"###"
          quit

      > gtm
      GTM>d ^x
      ***^SD010V(0,"021683",2)***
      ###;;38.15;;34.00;;;;;;;;;;;;;;;;;34.00;48.75###

      I was not able to reproduce the issue with the given information. Can you give us a test case that demonstrates the issue.

      Thanks,
      Narayanan.

       
    • Jens Wulf

      Jens Wulf - 2007-07-05

      Thank you for your answer Narayanan, but my problem is of a different nature.
      I can't reproduce the defective global either, but i wonder that there's a database inconsistence that isn't detected by mupip integ (even not by mupip integ -Full).
      I wrote the global in a file, killed it and reread it with ^%GI. It seems all OK now, but what if there are more errors like this and i'll never find them because integ says 'all ok'?

      Greets

      Jens

       
      • Narayanan S Rajamani

        Jens,

        We do not know of any issue with MUPIP INTEG's ability to detect database inconsistencies. The issue is more likely in the GT.M process that reported the bad $QUERY result. Unfortunately, without a reproducible case, there is not a lot that we can do. If you encounter such errors in the future, do take the following steps so we will have more information to analyze.

        1) Assuming you get a bad return from $QUERY, try redoing the $QUERY to confirm the problem still happens.
        2) Start a separate GT.M process (without halting the previous one) and see if the same $QUERY issue exists there. Note down the result.
        3) Halt both GT.M processes. Make sure there is no other process accessing the database.
        4) Start a new GT.M process and retry the $QUERY. Note down whether it produces the right results or not.
        5) If you do NOT see the issue now, the issue is not in the database file but in the GT.M process and we are back to square one needing a sequence of steps that you did to create the issue. Exit.
        6) Assuming you still get the wrong result, halt the GT.M process and run MUPIP INTEG on the database file. Make sure you get no integ errors.
        7) At this point please take a backup of the database file.
        8) Even if you are not able to give us a testcase to reproduce the issue, you can give us a copy of this database file and that should be enough for us to analyze this issue.

        Narayanan.

         
    • Jens Wulf

      Jens Wulf - 2007-07-05

      Hi Narayanan,

      i think i can say it is a database problem because i copied the database to a different machine and got the same result there too (with no one else accessing this database.)
      Giving you a copy is a problem because it's a 6,6 GB-Database and so the Up- and Download could take a while ;-).

      Maybe i can have a look with the dse-tool and send extracts of this.

      Greets

      Jens

       
      • Narayanan S Rajamani

        Jens,

        Good that you still have the database file which shows the issue. Can you send us the following output for a start.

        1) ls -l of the database file
        2) mupip integ -full <dbfile>

        Narayanan.

         
    • Jens Wulf

      Jens Wulf - 2007-07-05

      OK - here is the (shortened) output:

      -------------------------------------------------------------------
      ....
      Global variable ^SD010T
      Level          Blocks         Records          % Used      Adjacent
          1               1               1           2.343             0
          0               1               0           1.562             0

      Global variable ^SD010V
      Level          Blocks         Records          % Used      Adjacent
          3               1               1           2.343             0
          2               1              11          20.605             0
          1              11             163          23.552             0
          0             163            1903          57.928            28

      Global variable ^SD010VS
      Level          Blocks         Records          % Used      Adjacent
          3               1               1           2.343             0
          2               1              21          51.562             0
          1              21             318          30.552             0
          0             318           12440          47.646           137

      Global variable ^SD011
      Level          Blocks         Records          % Used      Adjacent
          3               1              49          97.070             0
          2              49            1250          47.317             0
          1            1250           34849          46.302            87
          0           34849          285453          45.507          5296

      .....

      Global variable ^test
      Level          Blocks         Records          % Used      Adjacent
          1               1               1           2.343             0
          0               1               0           1.562             0

      No errors detected by integ.

      Type           Blocks         Records          % Used      Adjacent

      Directory          23             787          54.008            NA
      Index          278198         6758572          60.543         15940
      Data          6481139       108032315          80.318       4282495
      Free             2140              NA              NA            NA
      Total         6761500       114791674              NA       4298435
      -------------------------------------------------------------------
      root@linux2b:/d1/database# ls -l mumps.dat
      -rw-r--r-- 1 root root 6937350656 2007-07-07 09:39 mumps.dat
      -------------------------------------------------------------------

      ok - i know the system time on my backup-system is not ok but this shouldn't be a problem.

      I ll add some dse-output too:
      --------------------------------------------------------------------------
      DSE> find -K="^SD010V"

      Key not found, would be in block  553E02.
          Directory path
          Path--blk:off
              1:11B,  E:228,
          Global tree path
          Path--blk:off
              36EB0A:10,      554FF9:10,      599801:10,      553E02:10,
      DSE> D -BL=553E02

      Block 553E02   Size 263   Level 0   TN C40AB4D4 V5

      Rec:1  Blk 553E02  Off 10  Size 30  Cmpc 0  Key ^SD010V(0,300009,2)
            10 : | 30  0  0  0 53 44 30 31 30 56  0 80  0 C4 31  1  A  0 BF 21|
                 |  0  .  .  .  S  D  0  1  0  V  .  .  .  .  1  .  .  .  .  !|
            24 : |  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
            38 : | 3B 3B 3B 31 34 2E 32 35                                    |
                 |  ;  ;  ;  1  4  .  2  5                                    |

      Rec:2  Blk 553E02  Off 40  Size 24  Cmpc C  Key ^SD010V(0,300010,2)
            40 : | 24  0  C  0 11  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  .  .  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
            54 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 31 34 2E 32 35            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  1  4  .  2  5            |

      Rec:3  Blk 553E02  Off 64  Size 25  Cmpc C  Key ^SD010V(0,300021,2)
            64 : | 25  0  C  0 22  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  %  .  .  .  "  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
            78 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 32 32 35 2E 30 30         |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  2  2  5  .  0  0         |

      Rec:4  Blk 553E02  Off 89  Size 24  Cmpc C  Key ^SD010V(0,300028,2)
            89 : | 24  0  C  8 29  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  .  )  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
            9D : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 31 34 2E 33 30            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  1  4  .  3  0            |

      Rec:5  Blk 553E02  Off AD  Size 24  Cmpc C  Key ^SD010V(0,300034,2)
            AD : | 24  0  C 3B 35  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  ;  5  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
            C1 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 34 33 2E 39 30            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  4  3  .  9  0            |

      Rec:6  Blk 553E02  Off D1  Size 24  Cmpc C  Key ^SD010V(0,300035,2)
            D1 : | 24  0  C  8 36  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  .  6  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
            E5 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 34 33 2E 39 30            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  4  3  .  9  0            |

      Rec:7  Blk 553E02  Off F5  Size 24  Cmpc C  Key ^SD010V(0,300063,2)
            F5 : | 24  0  C 3B 64  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  ;  d  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           109 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 39 36 2E 33 35            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  9  6  .  3  5            |

      Rec:8  Blk 553E02  Off 119  Size 26  Cmpc B  Key ^SD010V(0,300141,2)
           119 : | 26  0  B  8  2 42  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  &  .  .  .  .  B  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           12D : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 38 36 30 2E 30 30      |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  8  6  0  .  0  0      |

      Rec:9  Blk 553E02  Off 13F  Size 24  Cmpc C  Key ^SD010V(0,300143,2)
           13F : | 24  0  C  0 44  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  .  D  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           153 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 37 31 2E 30 30            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  7  1  .  0  0            |

      Rec:A  Blk 553E02  Off 163  Size 24  Cmpc C  Key ^SD010V(0,300144,2)
           163 : | 24  0  C  0 45  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  .  E  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           177 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 39 38 2E 30 30            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  9  8  .  0  0            |

      Rec:B  Blk 553E02  Off 187  Size 24  Cmpc C  Key ^SD010V(0,300145,2)
           187 : | 24  0  C  8 46  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  .  F  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           19B : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 32 39 2E 35 30            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  2  9  .  5  0            |

      Rec:C  Blk 553E02  Off 1AB  Size 24  Cmpc C  Key ^SD010V(0,300189,2)
           1AB : | 24  0  C 3B 8A  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  ;  .  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           1BF : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 34 30 2E 33 35            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  4  0  .  3  5            |

      Rec:D  Blk 553E02  Off 1CF  Size 26  Cmpc B  Key ^SD010V(0,300214,2)
           1CF : | 26  0  B 3B  3 15  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  &  .  .  ;  .  .  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           1E3 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 38 36 30 2E 30 30      |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  8  6  0  .  0  0      |

      Rec:E  Blk 553E02  Off 1F5  Size 24  Cmpc C  Key ^SD010V(0,300215,2)
           1F5 : | 24  0  C  8 16  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  $  .  .  .  .  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           209 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 34 31 2E 34 35            |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  4  1  .  4  5            |

      Rec:F  Blk 553E02  Off 219  Size 25  Cmpc C  Key ^SD010V(0,300216,2)
           219 : | 25  0  C 3B 17  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  %  .  .  ;  .  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           22D : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 33 37 35 2E 37 30         |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  3  7  5  .  7  0         |

      Rec:10  Blk 553E02  Off 23E  Size 25  Cmpc C  Key ^SD010V(0,300218,2)
           23E : | 25  0  C  0 19  0 BF 21  0  0 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B|
                 |  %  .  .  .  .  .  .  !  .  .  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;|
           252 : | 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 3B 31 34 38 2E 30 30         |
                 |  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  1  4  8  .  0  0         |

      DSE> F -E
              Directory path
              Path--blk:off
              1:11B   E:228

              Global paths
              Path--blk:off
              36EB0A:10       554FF9:10       599801:10       553E02

      DSE> D -BL=599801
      Block 599801   Size 11C   Level 1   TN C40B4D9F V5
      Rec:1  Blk 599801  Off 10  Size 1A  Cmpc 0  Ptr 553E02  Key ^SD010V(0,300218,2)
            10 : | 1A  0  0  0 53 44 30 31 30 56  0 80  0 C4 31  3 19  0 BF 21|
                 |  .  .  .  .  S  D  0  1  0  V  .  .  .  .  1  .  .  .  .  !|
            24 : |  0  0  2 3E 55  0                                          |
                 |  .  .  .  >  U  .                                          |

      Rec:2  Blk 599801  Off 2A  Size B  Cmpc C  Ptr 553E06  Key ^SD010V(0,300276)
            2A : |  B  0  C  0 77  0  0  6 3E 55  0                           |
                 |  .  .  .  .  w  .  .  .  >  U  .                           |

      Rec:3  Blk 599801  Off 35  Size E  Cmpc C  Ptr 553E07  Key ^SD010V(0,300280,2)
            35 : |  E  0  C  0 81  0 BF 21  0  0  7 3E 55  0                  |
                 |  .  .  .  .  .  .  .  !  .  .  .  >  U  .                  |

      Rec:4  Blk 599801  Off 43  Size D  Cmpc A  Ptr 553EC6  Key ^SD010V(0,31321*)
            43 : |  D  0  A  0 32 33 1C  0  0 C6 3E 55  0                     |
                 |  .  .  .  .  2  3  .  .  .  .  >  U  .                     |

      Rec:5  Blk 599801  Off 50  Size B  Cmpc C  Ptr 553ECA  Key ^SD010V(0,313246)
            50 : |  B  0  C 37 47  0  0 CA 3E 55  0                           |
                 |  .  .  .  7  G  .  .  .  >  U  .                           |

      Rec:6  Blk 599801  Off 5B  Size E  Cmpc C  Ptr 553EE1  Key ^SD010V(0,313267,2)
            5B : |  E  0  C 37 68  0 BF 21  0  0 E1 3E 55  0                  |
                 |  .  .  .  7  h  .  .  !  .  .  .  >  U  .                  |

      Rec:7  Blk 599801  Off 69  Size F  Cmpc B  Ptr 648772  Key ^SD010V(0,313311,2)
            69 : |  F  0  B  0 34 12  0 BF 21  0  0 72 87 64  0               |
                 |  .  .  .  .  4  .  .  .  !  .  .  r  .  d  .               |

      Rec:8  Blk 599801  Off 78  Size E  Cmpc C  Ptr 546FED  Key ^SD010V(0,313358,2)
            78 : |  E  0  C FF 59  0 BF 21  0  0 ED 6F 54  0                  |
                 |  .  .  .  .  Y  .  .  !  .  .  .  o  T  .                  |

      Rec:9  Blk 599801  Off 86  Size B  Cmpc C  Ptr 5467CA  Key ^SD010V(0,313366)
            86 : |  B  0  C  0 67  0  0 CA 67 54  0                           |
                 |  .  .  .  .  g  .  .  .  g  T  .                           |

      Rec:A  Blk 599801  Off 91  Size B  Cmpc C  Ptr 546FF4  Key ^SD010V(0,313384)
            91 : |  B  0  C 31 85  0  0 F4 6F 54  0                           |
                 |  .  .  .  1  .  .  .  .  o  T  .                           |

      Rec:B  Blk 599801  Off 9C  Size F  Cmpc B  Ptr 546747  Key ^SD010V(0,313404,2)
            9C : |  F  0  B  0 35  5  0 BF 21  0  0 47 67 54  0               |
                 |  .  .  .  .  5  .  .  .  !  .  .  G  g  T  .               |

      Rec:C  Blk 599801  Off AB  Size E  Cmpc C  Ptr 542C9A  Key ^SD010V(0,313414,2)
            AB : |  E  0  C  0 15  0 BF 21  0  0 9A 2C 54  0                  |
                 |  .  .  .  .  .  .  .  !  .  .  .  ,  T  .                  |

      Rec:D  Blk 599801  Off B9  Size 10  Cmpc A  Ptr 53F036  Key ^SD010V(0,358418,2)
            B9 : | 10  0  A 32 36 85 19  0 BF 21  0  0 36 F0 53  0            |
                 |  .  .  .  2  6  .  .  .  .  !  .  .  6  .  S  .            |

      Rec:E  Blk 599801  Off C9  Size B  Cmpc C  Ptr 53F02C  Key ^SD010V(0,35841*)
            C9 : |  B  0  C  0 1D  0  0 2C F0 53  0                           |
                 |  .  .  .  .  .  .  .  ,  .  S  .                           |

      Rec:F  Blk 599801  Off D4  Size B  Cmpc C  Ptr 53F039  Key ^SD010V(0,35842*)
            D4 : |  B  0  C  0 2E  0  0 39 F0 53  0                           |
                 |  .  .  .  .  .  .  .  9  .  S  .                           |

      Rec:10  Blk 599801  Off DF  Size E  Cmpc C  Ptr 53F02A  Key ^SD010V(0,358452,2)
            DF : |  E  0  C  0 53  0 BF 21  0  0 2A F0 53  0                  |
                 |  .  .  .  .  S  .  .  !  .  .  *  .  S  .                  |

      Rec:11  Blk 599801  Off ED  Size E  Cmpc C  Ptr 53F00F  Key ^SD010V(0,358463,2)
            ED : |  E  0  C  0 64  0 BF 21  0  0  F F0 53  0                  |
                 |  .  .  .  .  d  .  .  !  .  .  .  .  S  .                  |

      Rec:12  Blk 599801  Off FB  Size B  Cmpc C  Ptr 53F031  Key ^SD010V(0,35847*)
            FB : |  B  0  C FF 7E  0  0 31 F0 53  0                           |
                 |  .  .  .  .  ~  .  .  1  .  S  .                           |

      Rec:13  Blk 599801  Off 106  Size E  Cmpc C  Ptr 53F03F  Key ^SD010V(0,358485,2)
           106 : |  E  0  C  0 86  0 BF 21  0  0 3F F0 53  0                  |
                 |  .  .  .  .  .  .  .  !  .  .  ?  .  S  .                  |

      Rec:14  Blk 599801  Off 114  Size 8  Cmpc 0  Ptr 53F00C  Key *
           114 : |  8  0  0  0  C F0 53  0                                    |
                 |  .  .  .  .  .  .  S  .                                    |

      DSE>
      ----------------------------------------------------------------------------
      Can you say what's going on here?

      Greets

      Jens

       
      • Narayanan S Rajamani

        The DSE output helped. It indicates that the first node in the ^SD010V global is ^SD010V(0,300009,2).

        Your first mail (the one that started this thread) had a ZWRITE ^SD010V show a different node as the first.

        GTM>ZWR ^SD010V
        ^SD010V("0","021683","2")=";;38.15;;34.00;;;;;;;;;;;;;;;;;34.00;48.75"

        With this information, if we see your error again

        GTM>S GL="^SD010V" S GL=$Q(@GL) W "***",GL,"***",!,"###",@GL,"###"
        ***^SD010V(0,300009,2)***
        ###
        %GTM-E-GVUNDEF, Global variable undefined: ^SD010V("0","300009","2")
        %GTM-I-RTSLOC,          At M source location ^GTM$DMOD

        $QUERY is consistent with what DSE shows but is inconsistent with what ZWR shows. Notice that GL is printed properly but writing @GL somehow seems to transform ^SD010V(0,300009,2) to ^SD010V("0","300009","2") where all numeric subscripts are being treated as string subscripts.

        I am suspecting that you have a non-default setting in the database file header for subscript collation. Can you get us a DSE DUMP -FILE -ALL output.

        Narayanan.

         
    • Jens Wulf

      Jens Wulf - 2007-07-06

      The dump is below, but i think the global is defined with string-collation via the %gbldef utility.
      Do you think the integ has a problem with string collation?

      Jens

      -------------------------------------------------------------------------------
      File    /d1/database/mumps.dat
      Region  DEFAULT

      File            /d1/database/mumps.dat
      Region          DEFAULT
      Date/Time       08-JUL-2007 04:30:28 [$H = 60819,16228]
        Access method                          BG  Global Buffers                1024
        Reserved Bytes                          0  Block size (in bytes)         1024
        Maximum record size                   480  Starting VBN                    49
        Maximum key size                      200  Total blocks            0x00675FCC
        Null subscripts                     NEVER  Free blocks             0x0000085C
        Standard Null Collation             FALSE  Free space              0x00000000
        Last Record Backup     0x0000000000000001  Extension Count                100
        Last Database Backup   0x0000000143494F7C  Number of local maps         13232
        Last Bytestream Backup 0x0000000000000001  Lock space              0x00000028
        In critical section            0x00000000  Timers pending                   0
        Cache freeze id                0x00000000  Flush timer            00:00:01:00
        Freeze match                   0x00000000  Flush trigger                  960
        Current transaction    0x000000014364648B  No. of writes/flush              7
        Maximum TN             0xFFFFFFFFDFFFFFFF  Certified for Upgrade to        V5
        Maximum TN Warn        0xFFFFFFFF5FFFFFFF  Desired DB Format               V5
        Master Bitmap Size                     32  Blocks to Upgrade       0x00000000
        Create in progress                  FALSE  Modified cache blocks            0
        Reference count                         1  Wait Disk                        0
        Journal State               [inactive] ON  Journal Before imaging       FALSE
        Journal Allocation                    100  Journal Extension              100
        Journal Buffer Size                   128  Journal Alignsize              128
        Journal AutoSwitchLimit           8388600  Journal Epoch Interval         300
        Journal Yield Limit                     8  Journal Sync IO              FALSE
        Journal File: /daten/journal/gtmjrnl.mjl
        Mutex Hard Spin Count                 128  Mutex Sleep Spin Count         128
        Mutex Spin Sleep Time                2048  KILLs in progress                0
        Replication State                     OFF  Region Seqno    0x0000000000000001
        Zqgblmod Seqno         0x0000000000000000  Zqgblmod Trans  0x0000000000000000
        Endian Format                      LITTLE

        Dualsite Resync Seqno  0x0000000000000001
        Blks Last Record Backup        0x00000000  Blks Last Stream Backup 0x00000000
        Blks Last Comprehensive Backup 0x00675FCC  DB Creation Version             V4

        Full Block Writes                     OFF  Full Block Write Len             0

        Retries [0]               21338201
        Retries [1]                  20301
        Retries [2]                    246
        Retries [3]                      0

        Total TP Retries [ 0]            0     Cnflct TP Retries [ 0]            0
        Total TP Retries [ 1]            0     Cnflct TP Retries [ 1]            0
        Total TP Retries [ 2]            0     Cnflct TP Retries [ 2]            0
        Total TP Retries [ 3]            0     Cnflct TP Retries [ 3]            0
        Total TP Retries [ 4]            0     Cnflct TP Retries [ 4]            0
        Total TP Retries [ 5]            0     Cnflct TP Retries [ 5]            0
        Total TP Retries [ 6]            0     Cnflct TP Retries [ 6]            0
        Total TP Retries [ 7]            0     Cnflct TP Retries [ 7]            0
        Total TP Retries [ 8]            0     Cnflct TP Retries [ 8]            0
        Total TP Retries [ 9]            0     Cnflct TP Retries [ 9]            0
        Total TP Retries [10]            0     Cnflct TP Retries [10]            0
        Total TP Retries [11]            0     Cnflct TP Retries [11]            0

        Number of        : GET                      : 0x6125DEA8
        Number of        : ORDER                    : 0x6492E432
        Number of        : QUERY                    : 0x08AE9E04
        Number of        : ZPREV                    : 0x04E835A0
        Number of        : DATA                     : 0xC6872744
        Number of        : KILL                     : 0x5B625C33
        Number of Non-TP : SET                      : 0x6B21F3F0
        Number of Non-TP : SET (duplicate SETS)     : 0x00000000
        Number of     TP : UPDATES                  : 0x00000000
        Number of     TP : UPDATES (duplicate SETS) : 0x00000000

        TP blkmod nomod                  0
        TP blkmod gvcst_srch             0
        TP blkmod t_qread                0
        TP blkmod tp_tend                0
        TP blkmod tp_hist                0

        Spcfc buff flshs        0x000083EE        Transaction =   0x00000001436380A1
        Spcfc buff flsh lps     0x00000045        Transaction =   0x0000000135984CE6
        Spcfc buff flsh rtries  0x000050F1        Transaction =   0x000000013F1710E4
        DbCshGetn_FlushDirty    0x00000AAC        Transaction =   0x00000001436380A1
        TQread_BfOwnerStuck     0x00000076        Transaction =   0x000000012E0791B5
        BtPut_FlushDirty        0x00007942        Transaction =   0x00000001436374B6
        M-lock wakeups          0x0000138B        Transaction =   0x00000001433DFF66
        WcBlocked WcsReoverInv  0x00000001        Transaction =   0x000000012E056811
        DbCshGet TooManyLoops   0x0000001B        Transaction =   0x0000000141FA9BF7
        Journal fsyncs          0x00032C54        Transaction =   0x000000014364648B
        Journal fsync tries     0x00032C54        Transaction =   0x000000014364648B
        DB fsyncs               0x0000004C        Transaction =   0x0000000143494F7C
        DB fsyncs in crit       0x0000004C        Transaction =   0x0000000143494F7C
        Epoch Timer Calls       0x000863E6        Transaction =   0x0000000143646485
        Epoch Timer Writes      0x00037439        Transaction =   0x000000014364639A
        WcBlocked secshrclnup1  0x00000001        Transaction =   0x000000012E056810
        WcBlocked dirtystuck2   0x00000001        Transaction =   0x000000012E056810

        Jnl Buffer Size         0x00000000        Dskaddr                 0x00000000
        Free                    0x00000000        Freeaddr                0x00000000
        Dsk                     0x00000000        Wrtsize                 0x00000000
        Journal checksum seed   0x047E05EF        Min_write_size          0x00000000
        bytcnt                  0x00000000        Max_write_size          0x00000000
        Before image                 FALSE        Filesize                         0
        Iosb.cond                        0        qiocnt                           0
        Iosb.length                 0x0000        errcnt                           0
        Iosb.dev_specific                0        Next Epoch_Time         47117,3600
        Blocked Process                  0        Epoch_tn        0x0000000000000000
        Io_in_progress               FALSE        Epoch_Interval                   0
        Now_writer                       0        Image_count                      0
        fsync_in_prog                FALSE        fsync pid                        0
        fsync addrs             0x00000000        Need_db_fsync                FALSE
        Jnl Rec Type    PINI             0        Jnl Rec Type    PFIN             0
        Jnl Rec Type    ZTCOM            0        Jnl Rec Type    KILL             0
        Jnl Rec Type    FKILL            0        Jnl Rec Type    GKILL            0
        Jnl Rec Type    SET              0        Jnl Rec Type    FSET             0
        Jnl Rec Type    GSET             0        Jnl Rec Type    PBLK             0
        Jnl Rec Type    EPOCH            0        Jnl Rec Type    EOF              0
        Jnl Rec Type    TKILL            0        Jnl Rec Type    UKILL            0
        Jnl Rec Type    TSET             0        Jnl Rec Type    USET             0
        Jnl Rec Type    TCOM             0        Jnl Rec Type    ALIGN            0
        Jnl Rec Type    NULL             0        Jnl Rec Type    ZKILL            0
        Jnl Rec Type    FZKIL            0        Jnl Rec Type    GZKIL            0
        Jnl Rec Type    TZKIL            0        Jnl Rec Type    UZKIL            0
        Jnl Rec Type    INCTN            0        Jnl Rec Type    AIMG             0
        Jnl Rec Type    TRIPL            0

        Recover interrupted          FALSE        INTRPT resolve time              0
        INTRPT seqno    0x0000000000000000        INTRPT jnl_state                 0
        INTRPT repl_state                0

        Free blocks                    992        Backup blocks                    0
        Reformat blocks                  0        Total blocks                   992
        Shmpool blocked              FALSE        File Offset     0x0000000000000000
        Shmpool crit holder              0        Backup_errno                     0
        Backup Process ID                0        Backup TN       0x0000000000000000
        Inc Backup TN   0x0000000000000000        Process Failed                   0
        Allocs since check               0        Backup Image Count               0
        Temp File:

        Database is Fully Upgraded                :  TRUE
        Blocks to Upgrade subzero(negative) error : 0x00000000
        TN when Blocks to Upgrade last became 0   : 0x00000000C2DF1531
        TN when Desired DB Format last changed    : 0x00000000C27A4C00
        TN when REORG upgrd/dwngrd changed dbfmt  : 0x00000000C27A4C00

        Block Number REORG upgrd/dwngrd will restart from : 0x0064C991

        Upd reserved area [% global buffers]   50  Avg blks read per 100 records  200
        Pre read trigger factor [% upd rsrvd]  50  Upd writer trigger [%flshTrgr]  33
      --------------------------------------------------------------------------------

       
      • Narayanan S Rajamani

        MUPIP INTEG has no problem with string collation. On a fresh database, I tried the following test to see if this could reproduce your issue. But this worked fine.

        x       ;
                set ^SD010V(0,300009,2)=1
                write $$set^%GBLDEF("^SD010V",1,0)
                set ^SD010V("0","021683","2")=";;38.15;;34.00;;;;;;;;;;;;;;;;;34.00;48.75"
                S GL="^SD010V" S GL=$Q(@GL) W "***",GL,"***",!,"###",@GL,"###"
                quit

        I have spent enough time on this issue and have not yet been able to get a testcase that demonstrates an issue in GT.M.

        As I said earlier, if you can give us a reproducible testcase that demonstrates this issue, I will analyze it further. Otherwise, I would like to close this.

        Thanks,
        Narayanan.

         
        • Jens Wulf

          Jens Wulf - 2007-07-09

          Hello Naranayan,
          i can't reprodruce this either. We are working with GT.M since 2004 and this is the first case where this error raises up (and we use GT.M really much). Since i've killed that global and reread it we had no new problems. So i hope i never see this again. But i'll report it as a bug of mupip integ. In my opinion mupip integ should normally detect such a database-problem.

          Thank you for your time and your help.

          Greets

          Jens

           

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks