• [Info-ingres] The database that isn't there

    From Martin Bowes@martin.bowes@ndph.ox.ac.uk to info-ingres@lists.planetingres.org on Wed Sep 29 14:09:49 2021
    From Newsgroup: comp.databases.ingres

    --_000_e784c0760f0342d2899dc962d2d1b711ndphoxacuk_
    Content-Type: text/plain; charset="us-ascii"
    Content-Transfer-Encoding: quoted-printable
    X-WatchGuard-AntiVirus: part scanned. clean action=allow

    Hi All

    I have a database which is listed in my iidatabase catalog, but it isn't on=
    the disk system. There is no trace of this database whatsoever under any l= ocation.

    I could remove it from the catalogs using an sql iidbdb +Y connection. But =
    I was wondering if it was possible to copy the aaaaaaaa.ext from another da= tabase , edit it to reflect the database of interest, rebuild a stub config=
    file from that and then hopefully perform the destroydb that we have all c= ome to know and love.

    I ask this as I'm vaguely sure I saw something somewhere that suggested tha=
    t it was possible to rebuild/edit a config file using the .ext file. Can an= yone shed light on that?

    Martin Bowes

    PS. The database was created as a test of using a readonly database as a ta= rget from a distributed database. The test did not return the database to r= eadwrite status before attempting the destroydb.

    --_000_e784c0760f0342d2899dc962d2d1b711ndphoxacuk_
    Content-Type: text/html; charset="us-ascii"
    Content-Transfer-Encoding: quoted-printable
    X-WatchGuard-AntiVirus: part scanned. clean action=allow

    <html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:= //www.w3.org/TR/REC-html40">
    <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=

    <meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style><!--
    /* Font Definitions */
    @font-face
    {font-family:"Cambria Math";
    panose-1:2 4 5 3 5 4 6 3 2 4;}
    @font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}
    /* Style Definitions */
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0cm;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    a:link, span.MsoHyperlink
    {mso-style-priority:99;
    color:#0563C1;
    text-decoration:underline;}
    a:visited, span.MsoHyperlinkFollowed
    {mso-style-priority:99;
    color:#954F72;
    text-decoration:underline;}
    span.EmailStyle17
    {mso-style-type:personal-compose;
    font-family:"Calibri",sans-serif;
    color:windowtext;}
    .MsoChpDefault
    {mso-style-type:export-only;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    @page WordSection1
    {size:612.0pt 792.0pt;
    margin:72.0pt 72.0pt 72.0pt 72.0pt;}
    div.WordSection1
    {page:WordSection1;}
    </style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext=3D"edit">
    <o:idmap v:ext=3D"edit" data=3D"1" />
    </o:shapelayout></xml><![endif]-->
    </head>
    <body lang=3D"EN-GB" link=3D"#0563C1" vlink=3D"#954F72">
    <div class=3D"WordSection1">
    <p class=3D"MsoNormal">Hi All<o:p></o:p></p>
    <p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class=3D"MsoNormal">I have a database which is listed in my iidatabase c= atalog, but it isn&#8217;t on the disk system. There is no trace of this da= tabase whatsoever under any location.<o:p></o:p></p>
    <p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class=3D"MsoNormal">I could remove it from the catalogs using an sql iid= bdb &#43;Y connection. But I was wondering if it was possible to copy the a= aaaaaaa.ext from another database , edit it to reflect the database of inte= rest, rebuild a stub config file from
    that and then hopefully perform the destroydb that we have all come to kno=
    w and love.<o:p></o:p></p>
    <p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class=3D"MsoNormal">I ask this as I&#8217;m vaguely sure I saw something=
    somewhere that suggested that it was possible to rebuild/edit a config fil=
    e using the .ext file. Can anyone shed light on that?<o:p></o:p></p>
    <p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class=3D"MsoNormal">Martin Bowes<o:p></o:p></p>
    <p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class=3D"MsoNormal">PS. The database was created as a test of using a re= adonly database as a target from a distributed database. The test did not r= eturn the database to readwrite status before attempting the destroydb.<o:p= ></o:p></p>
    </div>
    </body>
    </html>

    --_000_e784c0760f0342d2899dc962d2d1b711ndphoxacuk_--
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Karl Schendel@schendel@kbcomputer.com to info-ingres@lists.planetingres.org on Wed Sep 29 10:29:46 2021
    From Newsgroup: comp.databases.ingres


    On Sep 29, 2021, at 10:09 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:

    Hi All

    I have a database which is listed in my iidatabase catalog, but it isnrCOt on the disk system. There is no trace of this database whatsoever under any location.

    I could remove it from the catalogs using an sql iidbdb +Y connection.
    Right.
    But I was wondering if it was possible to copy the aaaaaaaa.ext from another database , edit it to reflect the database of interest, rebuild a stub config file from that and then hopefully perform the destroydb that we have all come to know and love.
    I don't think you can reconstruct an entire .cnf file from an ext file. You can reset the database locations, but
    the rest of the cnf file has to be valid. You might be able to copy an existing cnf file AND ext file, and
    go from there.
    Or, you could do it the easy way with sql +Y iidbdb...

    I ask this as IrCOm vaguely sure I saw something somewhere that suggested that it was possible to rebuild/edit a config file using the .ext file.
    It used to be an alterdb comment, but I think that got changed to an ii_sync_config() builtin DB procedure.
    ii_sync_config(database='dbname', mode=mode, operation='operation')
    operation of interest would be 'sync_extents' and possibly 'sync_consistent' mode appears to be 'run' or 'report'
    I'd guess that the sync-config can be run in an iidbdb session but I've never tried it, use at your own risk!
    Karl
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Martin Bowes@martin.bowes@ndph.ox.ac.uk to info-ingres@lists.planetingres.org on Wed Sep 29 14:36:38 2021
    From Newsgroup: comp.databases.ingres

    Hi Karl,

    Sql +Y it is then.

    Thanks.

    Marty

    -----Original Message-----
    From: Karl Schendel <schendel@kbcomputer.com>
    Sent: 29 September 2021 15:30
    To: info-ingres@lists.planetingres.org
    Cc: Martin Bowes <martin.bowes@ndph.ox.ac.uk>
    Subject: Re: [Info-ingres] The database that isn't there


    On Sep 29, 2021, at 10:09 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:

    Hi All

    I have a database which is listed in my iidatabase catalog, but it isnrCOt on the disk system. There is no trace of this database whatsoever under any location.

    I could remove it from the catalogs using an sql iidbdb +Y connection.

    Right.

    But I was wondering if it was possible to copy the aaaaaaaa.ext from another database , edit it to reflect the database of interest, rebuild a stub config file from that and then hopefully perform the destroydb that we have all come to know and love.

    I don't think you can reconstruct an entire .cnf file from an ext file. You can reset the database locations, but the rest of the cnf file has to be valid. You might be able to copy an existing cnf file AND ext file, and go from there.

    Or, you could do it the easy way with sql +Y iidbdb...


    I ask this as IrCOm vaguely sure I saw something somewhere that suggested that it was possible to rebuild/edit a config file using the .ext file.

    It used to be an alterdb comment, but I think that got changed to an ii_sync_config() builtin DB procedure.
    ii_sync_config(database='dbname', mode=mode, operation='operation') operation of interest would be 'sync_extents' and possibly 'sync_consistent'
    mode appears to be 'run' or 'report'
    I'd guess that the sync-config can be run in an iidbdb session but I've never tried it, use at your own risk!

    Karl

    --- Synchronet 3.21b-Linux NewsLink 1.2