• [Info-ingres] index problem on a partitioned table

    From Martin Bowes@21:1/5 to All on Fri Oct 8 07:28:09 2021
    Hi All,

    II 11.1.0 (a64.lnx/100) +p15599

    I have a partitioned table (pidapp) with an index (pidapp_pid). The table is fine, but the index is now bumping into max pages.

    BBA_CTSU_OX_AC_UK ::[42297 , 11346 , 0000000000000000:00007faf22db5ac0, dm1p.c:4471 ]: Thu Oct 7 18:39:18 2021 E_DM92BF_DM1P_TABLE_TOO_BIG Error extending table past maximum table size of 8388608, Database ace_trexy_live,
    Table ace.pidapp_pid, Current size 8388596 pages, Extend size 16 pages

    The index looks like this:
    ame: pidapp_pid
    Owner: ace
    Created: 20/02/2020 13:41:32
    Location: ii_database
    Type: secondary index on pidapp
    Version: II10.0
    Page size: 8192
    Cache priority: 0
    Alter table version: 0
    Alter table totwidth: 12
    Row width: 12
    Number of rows: 1124378214
    Storage structure: btree
    Compression: none
    Duplicate Rows: allowed
    Number of pages: 7272402
    Overflow data pages: 0
    Journaling: enabled if journaling on the base table is enabled
    Base table for view: no
    Permissions: none
    Integrities: none
    Optimizer statistics: will use any existing statistics on the base table

    Index Column Information:
    Key
    Column Name Type Length Nulls Defaults Seq
    pid integer 4 no no 1
    tidp integer 8 no no 2

    I'm not sure if we can partition an index. I'm not sure if bumping the index to a higher page size will help either as the data is so small we can easily fit the max number of tids per page into 8k as it is.

    Ideas?

    Martin Bowes

    <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
    <meta name="Generator" content="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;}
    @font-face
    {font-family:"Lucida Console";
    panose-1:2 11 6 9 4 5 4 2 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="edit" spidmax="1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext="edit">
    <o:idmap v:ext="edit" data="1" />
    </o:shapelayout></xml><![endif]-->
    </head>
    <body lang="EN-GB" link="#0563C1" vlink="#954F72">
    <div class="WordSection1">
    <p class="MsoNormal">Hi All,<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal" style="text-autospace:none">II 11.1.0 (a64.lnx/100) &#43;p15599<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">I have a partitioned table (pidapp) with an index (pidapp_pid). The table is fine, but the index is now bumping into max pages.<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">BBA_CTSU_OX_AC_UK ::[42297&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , 11346&nbsp;&nbsp;&nbsp;&nbsp; ,&
    nbsp; 0000000000000000:00007faf22db5ac0, dm1p.c:4471&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ]: Thu
    <span style="color:black;background:olive;mso-highlight:olive">Oct&nbsp; 7 18:39</span>:18 2021 E_DM92BF_DM1P_TABLE_TOO_BIG&nbsp; Error extending table past maximum table size of 8388608, Database ace_trexy_live,&nbsp; Table ace.pidapp_pid, Current size
    8388596 pages, Extend
    size 16 pages<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">The index looks like this:<o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">ame:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pidapp_pid<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Owner:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ace<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Created:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20/02/2020 13:41:32<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Location:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ii_database<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Type:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; secondary index on pidapp<o:p></o:
    </span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Version:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; II10.0<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Page size:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8192<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Cache priority:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Alter table version:&nbsp; 0<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Alter table totwidth: 12<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Row width:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Number of rows:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1124378214<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Storage structure:&nbsp;&nbsp;&nbsp; btree<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Compression:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; none<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Duplicate Rows:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; allowed<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Number of pages:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7272402<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Overflow data pages:&nbsp; 0<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Journaling:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; enabled if journaling on the base table is enabled<o:p></o:p></
    span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Base table for view:&nbsp; no<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Permissions:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; none<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Integrities:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; none<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Optimizer statistics: will use any existing statistics on the base table<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Index Column Information:<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
    nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
    nbsp;Key<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Column Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Length Nulls Defaults Seq<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">pid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp; no&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; no&nbsp;&nbsp;&nbsp;&nbsp; 1<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">tidp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; integer&
    nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp; no&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; no&nbsp;&nbsp;&nbsp;&nbsp; 2<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">I&#8217;m not sure if we can partition an index. I&#8217;m not sure if bumping the index to a higher page size will help either as the data is so small we can easily fit the max number of tids per page into 8k as it is.<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Ideas?<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Martin Bowes<o:p></o:p></p>
    </div>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Karl Schendel@21:1/5 to All on Fri Oct 8 09:24:31 2021
    You can't partition an index. That was a feature in the original partitioned tables spec,
    but never got implemented. Part of the reason is that a partitioned index would
    require three identifiying numbers: base table, index, partition, and we only have two.
    Adding a number, or somehow rejiggering the numbering scheme, would be a massive
    change throughout DMF and other places. The can has been kicked down the road ever since.

    I'm not sure what exactly to suggest in this case. You might have to split up the base
    table, or do a manual pseudo-index that's explicitly referenced in queries.

    Karl


    On Oct 8, 2021, at 3:28 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:

    Hi All,

    II 11.1.0 (a64.lnx/100) +p15599

    I have a partitioned table (pidapp) with an index (pidapp_pid). The table is fine, but the index is now bumping into max pages.

    BBA_CTSU_OX_AC_UK ::[42297 , 11346 , 0000000000000000:00007faf22db5ac0, dm1p.c:4471 ]: Thu Oct 7 18:39:18 2021 E_DM92BF_DM1P_TABLE_TOO_BIG Error extending table past maximum table size of 8388608, Database ace_trexy_live,
    Table ace.pidapp_pid, Current size 8388596 pages, Extend size 16 pages

    The index looks like this:
    ame: pidapp_pid
    Owner: ace
    Created: 20/02/2020 13:41:32
    Location: ii_database
    Type: secondary index on pidapp
    Version: II10.0
    Page size: 8192
    Cache priority: 0
    Alter table version: 0
    Alter table totwidth: 12
    Row width: 12
    Number of rows: 1124378214
    Storage structure: btree
    Compression: none
    Duplicate Rows: allowed
    Number of pages: 7272402
    Overflow data pages: 0
    Journaling: enabled if journaling on the base table is enabled
    Base table for view: no
    Permissions: none
    Integrities: none
    Optimizer statistics: will use any existing statistics on the base table

    Index Column Information:
    Key
    Column Name Type Length Nulls Defaults Seq
    pid integer 4 no no 1
    tidp integer 8 no no 2

    I’m not sure if we can partition an index. I’m not sure if bumping the index to a higher page size will help either as the data is so small we can easily fit the max number of tids per page into 8k as it is.

    Ideas?

    Martin Bowes
    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Paul White@21:1/5 to Karl Schendel on Sat Oct 9 00:39:01 2021
    Hi there Karl,

    I suggested to Marty earlier he may like to try to create the index with multiple locations.

    I created two locations pointing to the same path. It seems to work:


    create index p1_idx on p1 (v)
    with structure=btree,
    page_size = 8192,
    location=(ii_database, ii_database2, ii_database3)


    ls -l /data4/ingresII/ingres/data/default/pw
    total 0
    -rw-------. 1 ingres ingres 0 Oct  8 19:24 aaaaanfo.t01
    -rw-------. 1 ingres ingres 0 Oct  8 19:24 aaaaanfo.t02


    Paul



    On 8/10/2021 11:24 pm, Karl Schendel wrote:
    You can't partition an index. That was a feature in the original partitioned tables spec,
    but never got implemented. Part of the reason is that a partitioned index would
    require three identifiying numbers: base table, index, partition, and we only have two.
    Adding a number, or somehow rejiggering the numbering scheme, would be a massive
    change throughout DMF and other places. The can has been kicked down the road
    ever since.

    I'm not sure what exactly to suggest in this case. You might have to split up the base
    table, or do a manual pseudo-index that's explicitly referenced in queries.

    Karl


    On Oct 8, 2021, at 3:28 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote: >>
    Hi All,

    II 11.1.0 (a64.lnx/100) +p15599

    I have a partitioned table (pidapp) with an index (pidapp_pid). The table is fine, but the index is now bumping into max pages.

    BBA_CTSU_OX_AC_UK ::[42297 , 11346 , 0000000000000000:00007faf22db5ac0, dm1p.c:4471 ]: Thu Oct 7 18:39:18 2021 E_DM92BF_DM1P_TABLE_TOO_BIG Error extending table past maximum table size of 8388608, Database ace_trexy_live,
    Table ace.pidapp_pid, Current size 8388596 pages, Extend size 16 pages

    The index looks like this:
    ame: pidapp_pid
    Owner: ace
    Created: 20/02/2020 13:41:32
    Location: ii_database
    Type: secondary index on pidapp
    Version: II10.0
    Page size: 8192
    Cache priority: 0
    Alter table version: 0
    Alter table totwidth: 12
    Row width: 12
    Number of rows: 1124378214
    Storage structure: btree
    Compression: none
    Duplicate Rows: allowed
    Number of pages: 7272402
    Overflow data pages: 0
    Journaling: enabled if journaling on the base table is enabled
    Base table for view: no
    Permissions: none
    Integrities: none
    Optimizer statistics: will use any existing statistics on the base table

    Index Column Information:
    Key
    Column Name Type Length Nulls Defaults Seq
    pid integer 4 no no 1
    tidp integer 8 no no 2

    I’m not sure if we can partition an index. I’m not sure if bumping the index to a higher page size will help either as the data is so small we can easily fit the max number of tids per page into 8k as it is.

    Ideas?

    Martin Bowes
    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org
    https://lists.planetingres.org/mailman/listinfo/info-ingres
    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    --
    Paul White<br>
    Shift Seven Solutions<br>
    <b>m: 0414681799</b><br>
    p: 0754482137<br>
    e: paul.white@shift7solutions.com.au<br>
    w: https://www.shift7solutions.com.au<br>
    International: +61414681799<br>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to All on Fri Oct 8 14:43:40 2021
    To: info-ingres@lists.planetingres.org (info-ingres@lists.planetingres.org)

    TXVsdGlwbGUgbG9jYXRpb25zIHdvdWxkbid0IGhhdmUgYWx0ZXJlZCB0aGUgbnVtYmVyIG9mIHBh Z2VzIGF2YWlsYWJsZS4gLi4uIEkgdGhpbmsuDQoNCkkgbWFuYWdlZCB0byBhZGp1c3QgdGhlIHBh Z2Vfc2l6ZSBvZiB0aGUgaW5kZXggdG8gMTZLIGFuZCB0aGF0IGhhcyBnaXZlbiBtZSBiYWNrIGEg ZmV3IG1pbGxpb24gcGFnZXMgd2hpY2ggaXMgZW5vdWdoIHRvIGNvbnRpbnVlIGZvciBhIHdoaWxl Lg0KDQpJIHN1c3BlY3QgbXkgYmVzdCBhbnN3ZXIgaXMgdG8gY29udmVydCB0aGlzIHRhYmxlIHRv IGFuIHgxMDAgdGFibGUuIEFuZCBhbHRlciBhIGZldyBwcm9ncmFtcyB0byBtb2RpZnkgdG8gY29t YmluZS4gU2FkbHkgaXQgYWxzbyBtZWFucyBJIGhhdmUgdG8gdW5sb2FkLCByZWNyZWF0ZSB3aXRo IHgxMDAgYW5kIHJlbG9hZCB0aGlzIG9sZCBkYXRhYmFzZS4NCg0KU29tZXRoaW5nIHRvIGxvb2sg Zm9yd2FyZCB0b28uDQoNCk1hcnR5IA0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJv bTogUGF1bCBXaGl0ZSA8c2hpZnQ3c29sdXRpb25zQGdtYWlsLmNvbT4gDQpTZW50OiAwOCBPY3Rv YmVyIDIwMjEgMTU6MzkNClRvOiBpbmZvLWluZ3Jlc0BsaXN0cy5wbGFuZXRpbmdyZXMub3JnDQpT dWJqZWN0OiBSZTogW0luZm8taW5ncmVzXSBpbmRleCBwcm9ibGVtIG9uIGEgcGFydGl0aW9uZWQg dGFibGUNCg0KSGkgdGhlcmUgS2FybCwNCg0KSSBzdWdnZXN0ZWQgdG8gTWFydHkgZWFybGllciBo ZSBtYXkgbGlrZSB0byB0cnkgdG8gY3JlYXRlIHRoZSBpbmRleCB3aXRoIG11bHRpcGxlIGxvY2F0 aW9ucy4NCg0KSSBjcmVhdGVkIHR3byBsb2NhdGlvbnMgcG9pbnRpbmcgdG8gdGhlIHNhbWUgcGF0 aC4gSXQgc2VlbXMgdG8gd29yazoNCg0KDQpjcmVhdGUgaW5kZXggcDFfaWR4IG9uIHAxICh2KQ0K d2l0aCBzdHJ1Y3R1cmU9YnRyZWUsDQpwYWdlX3NpemUgPSA4MTkyLA0KbG9jYXRpb249KGlpX2Rh dGFiYXNlLCBpaV9kYXRhYmFzZTIsIGlpX2RhdGFiYXNlMykNCg0KDQpscyAtbCAvZGF0YTQvaW5n cmVzSUkvaW5ncmVzL2RhdGEvZGVmYXVsdC9wdw0KdG90YWwgMA0KLXJ3LS0tLS0tLS4gMSBpbmdy ZXMgaW5ncmVzIDAgT2N0wqAgOCAxOToyNCBhYWFhYW5mby50MDEgLXJ3LS0tLS0tLS4gMSBpbmdy ZXMgaW5ncmVzIDAgT2N0wqAgOCAxOToyNCBhYWFhYW5mby50MDINCg0KDQpQYXVsDQoNCg0KDQpP biA4LzEwLzIwMjEgMTE6MjQgcG0sIEthcmwgU2NoZW5kZWwgd3JvdGU6DQo+IFlvdSBjYW4ndCBw YXJ0aXRpb24gYW4gaW5kZXguICBUaGF0IHdhcyBhIGZlYXR1cmUgaW4gdGhlIG9yaWdpbmFsIA0K PiBwYXJ0aXRpb25lZCB0YWJsZXMgc3BlYywgYnV0IG5ldmVyIGdvdCBpbXBsZW1lbnRlZC4gIFBh cnQgb2YgdGhlIA0KPiByZWFzb24gaXMgdGhhdCBhIHBhcnRpdGlvbmVkIGluZGV4IHdvdWxkIHJl cXVpcmUgdGhyZWUgaWRlbnRpZml5aW5nIG51bWJlcnM6IGJhc2UgdGFibGUsIGluZGV4LCBwYXJ0 aXRpb24sIGFuZCB3ZSBvbmx5IGhhdmUgdHdvLg0KPiBBZGRpbmcgYSBudW1iZXIsIG9yIHNvbWVo b3cgcmVqaWdnZXJpbmcgdGhlIG51bWJlcmluZyBzY2hlbWUsIHdvdWxkIGJlIA0KPiBhIG1hc3Np dmUgY2hhbmdlIHRocm91Z2hvdXQgRE1GIGFuZCBvdGhlciBwbGFjZXMuICBUaGUgY2FuIGhhcyBi ZWVuIA0KPiBraWNrZWQgZG93biB0aGUgcm9hZCBldmVyIHNpbmNlLg0KPg0KPiBJJ20gbm90IHN1 cmUgd2hhdCBleGFjdGx5IHRvIHN1Z2dlc3QgaW4gdGhpcyBjYXNlLiAgWW91IG1pZ2h0IGhhdmUg dG8gDQo+IHNwbGl0IHVwIHRoZSBiYXNlIHRhYmxlLCBvciBkbyBhIG1hbnVhbCBwc2V1ZG8taW5k ZXggdGhhdCdzIGV4cGxpY2l0bHkgcmVmZXJlbmNlZCBpbiBxdWVyaWVzLg0KPg0KPiBLYXJsDQo+ DQo+DQo+PiBPbiBPY3QgOCwgMjAyMSwgYXQgMzoyOCBBTSwgTWFydGluIEJvd2VzIDxtYXJ0aW4u Ym93ZXNAbmRwaC5veC5hYy51az4gd3JvdGU6DQo+Pg0KPj4gSGkgQWxsLA0KPj4gICANCj4+IElJ IDExLjEuMCAoYTY0LmxueC8xMDApICtwMTU1OTkNCj4+ICAgDQo+PiBJIGhhdmUgYSBwYXJ0aXRp b25lZCB0YWJsZSAocGlkYXBwKSB3aXRoIGFuIGluZGV4IChwaWRhcHBfcGlkKS4gVGhlIHRhYmxl IGlzIGZpbmUsIGJ1dCB0aGUgaW5kZXggaXMgbm93IGJ1bXBpbmcgaW50byBtYXggcGFnZXMuDQo+ PiAgIA0KPj4gQkJBX0NUU1VfT1hfQUNfVUsgOjpbNDIyOTcgICAgICAgICAgICAgLCAxMTM0NiAg ICAgLCAgMDAwMDAwMDAwMDAwMDAwMDowMDAwN2ZhZjIyZGI1YWMwLCBkbTFwLmM6NDQ3MSAgICAg ICAgICAgXTogVGh1IE9jdCAgNyAxODozOToxOCAyMDIxIEVfRE05MkJGX0RNMVBfVEFCTEVfVE9P X0JJRyAgRXJyb3IgZXh0ZW5kaW5nIHRhYmxlIHBhc3QgbWF4aW11bSB0YWJsZSBzaXplIG9mIDgz ODg2MDgsIERhdGFiYXNlIGFjZV90cmV4eV9saXZlLCAgVGFibGUgYWNlLnBpZGFwcF9waWQsIEN1 cnJlbnQgc2l6ZSA4Mzg4NTk2IHBhZ2VzLCBFeHRlbmQgc2l6ZSAxNiBwYWdlcw0KPj4gICANCj4+ IFRoZSBpbmRleCBsb29rcyBsaWtlIHRoaXM6DQo+PiBhbWU6ICAgICAgICAgICAgICAgICBwaWRh cHBfcGlkDQo+PiBPd25lcjogICAgICAgICAgICAgICAgYWNlDQo+PiBDcmVhdGVkOiAgICAgICAg ICAgICAgMjAvMDIvMjAyMCAxMzo0MTozMg0KPj4gTG9jYXRpb246ICAgICAgICAgICAgIGlpX2Rh dGFiYXNlDQo+PiBUeXBlOiAgICAgICAgICAgICAgICAgc2Vjb25kYXJ5IGluZGV4IG9uIHBpZGFw cA0KPj4gVmVyc2lvbjogICAgICAgICAgICAgIElJMTAuMA0KPj4gUGFnZSBzaXplOiAgICAgICAg ICAgIDgxOTINCj4+IENhY2hlIHByaW9yaXR5OiAgICAgICAwDQo+PiBBbHRlciB0YWJsZSB2ZXJz aW9uOiAgMA0KPj4gQWx0ZXIgdGFibGUgdG90d2lkdGg6IDEyDQo+PiBSb3cgd2lkdGg6ICAgICAg ICAgICAgMTINCj4+IE51bWJlciBvZiByb3dzOiAgICAgICAxMTI0Mzc4MjE0DQo+PiBTdG9yYWdl IHN0cnVjdHVyZTogICAgYnRyZWUNCj4+IENvbXByZXNzaW9uOiAgICAgICAgICBub25lDQo+PiBE dXBsaWNhdGUgUm93czogICAgICAgYWxsb3dlZA0KPj4gTnVtYmVyIG9mIHBhZ2VzOiAgICAgIDcy NzI0MDINCj4+IE92ZXJmbG93IGRhdGEgcGFnZXM6ICAwDQo+PiBKb3VybmFsaW5nOiAgICAgICAg ICAgZW5hYmxlZCBpZiBqb3VybmFsaW5nIG9uIHRoZSBiYXNlIHRhYmxlIGlzIGVuYWJsZWQNCj4+ IEJhc2UgdGFibGUgZm9yIHZpZXc6ICBubw0KPj4gUGVybWlzc2lvbnM6ICAgICAgICAgIG5vbmUN Cj4+IEludGVncml0aWVzOiAgICAgICAgICBub25lDQo+PiBPcHRpbWl6ZXIgc3RhdGlzdGljczog d2lsbCB1c2UgYW55IGV4aXN0aW5nIHN0YXRpc3RpY3Mgb24gdGhlIGJhc2UgDQo+PiB0YWJsZQ0K Pj4gICANCj4+IEluZGV4IENvbHVtbiBJbmZvcm1hdGlvbjoNCj4+ICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBLZXkNCj4+ IENvbHVtbiBOYW1lICAgICAgICAgICAgICBUeXBlICAgICAgICAgICAgICAgTGVuZ3RoIE51bGxz IERlZmF1bHRzIFNlcQ0KPj4gcGlkICAgICAgICAgICAgICAgICAgICAgIGludGVnZXIgICAgICAg ICAgICAgICAgIDQgICBubyAgICAgIG5vICAgICAxDQo+PiB0aWRwICAgICAgICAgICAgICAgICAg ICAgaW50ZWdlciAgICAgICAgICAgICAgICAgOCAgIG5vICAgICAgbm8gICAgIDINCj4+ICAgDQo+ PiBJ4oCZbSBub3Qgc3VyZSBpZiB3ZSBjYW4gcGFydGl0aW9uIGFuIGluZGV4LiBJ4oCZbSBub3Qg c3VyZSBpZiBidW1waW5nIHRoZSBpbmRleCB0byBhIGhpZ2hlciBwYWdlIHNpemUgd2lsbCBoZWxw IGVpdGhlciBhcyB0aGUgZGF0YSBpcyBzbyBzbWFsbCB3ZSBjYW4gZWFzaWx5IGZpdCB0aGUgbWF4 IG51bWJlciBvZiB0aWRzIHBlciBwYWdlIGludG8gOGsgYXMgaXQgaXMuDQo+PiAgIA0KPj4gSWRl YXM/DQo+PiAgIA0KPj4gTWFydGluIEJvd2VzDQo+PiBfX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXw0KPj4gSW5mby1pbmdyZXMgbWFpbGluZyBsaXN0DQo+PiBJ bmZvLWluZ3Jlc0BsaXN0cy5wbGFuZXRpbmdyZXMub3JnDQo+PiBodHRwczovL2xpc3RzLnBsYW5l dGluZ3Jlcy5vcmcvbWFpbG1hbi9saXN0aW5mby9pbmZvLWluZ3Jlcw0KPiBfX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KPiBJbmZvLWluZ3JlcyBtYWlsaW5n IGxpc3QNCj4gSW5mby1pbmdyZXNAbGlzdHMucGxhbmV0aW5ncmVzLm9yZw0KPiBodHRwczovL2xp c3RzLnBsYW5ldGluZ3Jlcy5vcmcvbWFpbG1hbi9saXN0aW5mby9pbmZvLWluZ3Jlcw0KDQotLQ0K UGF1bCBXaGl0ZTxicj4NClNoaWZ0IFNldmVuIFNvbHV0aW9uczxicj4NCjxiPm06IDA0MTQ2ODE3 OTk8L2I+PGJyPg0KcDogMDc1NDQ4MjEzNzxicj4NCmU6IHBhdWwud2hpdGVAc2hpZnQ3c29sdXRp b25zLmNvbS5hdTxicj4NCnc6IGh0dHBzOi8vd3d3LnNoaWZ0N3NvbHV0aW9ucy5jb20uYXU8YnI+ DQpJbnRlcm5hdGlvbmFsOiArNjE0MTQ2ODE3OTk8YnI+DQoNCl9fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fDQpJbmZvLWluZ3JlcyBtYWlsaW5nIGxpc3QNCklu Zm8taW5ncmVzQGxpc3RzLnBsYW5ldGluZ3Jlcy5vcmcNCmh0dHBzOi8vbGlzdHMucGxhbmV0aW5n cmVzLm9yZy9tYWlsbWFuL2xpc3RpbmZvL2luZm8taW5ncmVzDQo=

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)