Quantcast

Regression 3.18.0 cannot import Lightroom dump - Expression tree is too large (maximum depth 1000)

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Regression 3.18.0 cannot import Lightroom dump - Expression tree is too large (maximum depth 1000)

Axel Reinhold
Dear sqlite-team,

after update to 3.18.0 from 3.17.0 i can no more import a dump of
my Adobe Lightroom database. The command:

echo .dump | /opt/sqlite/bin/sqlite3 "/save/axel/alr3lb/2017-03-26 2040/lr5.lrcat" | /opt/sqlite/bin/sqlite3 t.sq3

which works fine with 3.17.0 produces hundreds of errors with 3.18.0:

Error: near line 69675: Expression tree is too large (maximum depth 1000)
Error: near line 69676: Expression tree is too large (maximum depth 1000)
Error: near line 69677: Expression tree is too large (maximum depth 1000)
Error: near line 69678: Expression tree is too large (maximum depth 1000)
Error: near line 69679: Expression tree is too large (maximum depth 1000)
Error: near line 69692: Expression tree is too large (maximum depth 1000)
Error: near line 69706: Expression tree is too large (maximum depth 1000)
...

I also compiled sqlite with SQLITE_MAX_EXPR_DEPTH=0 but this binary
core dumps with segfault:

echo .dump | /opt/sqlite/bin/sqlite3 "/save/axel/alr3lb/2017-03-26 2040/lr5.lrcat" |\
 ~/p/rpm/BUILD/sqlite-3.18.0-root/opt/sqlite-3.18.0-1/bin/sqlite3 t.sq3
Segmentation fault

I think this is a regression/bug because sqlite should always read
an own dump successfully. I cannot supply you with my lightroom database
due to privacy reasons and it is far too big anyways.

Here is one line that cause: Error: near line 166572: Expression tree is too large (maximum depth 1000)

INSERT INTO Adobe_AdditionalMetadata VALUES(291489,'B9B16929-C8C5-4BE7-8C1A-1A0910ADFEE7',1,0,0,291485,0,'67f86eb2b0d5033453a675c1b5e4213d',1,'25374f5c51006a2c1d2e0de7c0e3dbf8',-63113817600.0,'C9B8F38A-F4B8-48D7-800D-4EDF3870FDFE',4.0,0,'<x:xmpmeta xmlns:x="adobe:ns:meta/" x:xmptk="Adobe XMP Core 5.5-c002 1.148022, 2012/07/15-18:06:45        ">'||char(10)||' <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">'||char(10)||'  <rdf:Description rdf:about=""'||char(10)||'    xmlns:tiff="http://ns.adobe.com/tiff/1.0/"'||char(10)||'    xmlns:exif="http://ns.adobe.com/exif/1.0/"'||char(10)||'    xmlns:dc="http://purl.org/dc/elements/1.1/"'||char(10)||'    xmlns:xmp="http://ns.adobe.com/xap/1.0/"'||char(10)||'    xmlns:aux="http://ns.adobe.com/exif/1.0/aux/"'||char(10)||'    xmlns:photoshop="http://ns.adobe.com/photoshop/1.0/"'||char(10)||'    xmlns:xmpMM="http://ns.adobe.com/xap/1.0/mm/"'||char(10)||'    xmlns:xmpRights="http://ns.adobe.com/xap/1.0/rights/"'||char(10)||'    xmlns:crs="http://ns.adobe.com/camera-raw-settings/1.0/"'||char(10)||'    xmlns:Iptc4xmpCore="http://iptc.org/std/Iptc4xmpCore/1.0/xmlns/"'||char(10)||'   tiff:Make="NIKON CORPORATION"'||char(10)||'   tiff:Model="NIKON D700"'||char(10)||'   tiff:Orientation="1"'||char(10)||'   tiff:ImageWidth="4256"'||char(10)||'   tiff:ImageLength="2832"'||char(10)||'   exif:ExifVersion="0221"'||char(10)||'   exif:ExposureTime="1/250"'||char(10)||'   exif:ShutterSpeedValue="7965784/1000000"'||char(10)||'   exif:FNumber="25/10"'||char(10)||'   exif:ApertureValue="2643856/1000000"'||char(10)||'   exif:ExposureProgram="3"'||char(10)||'   exif:ExposureBiasValue="0/6"'||char(10)||'   exif:MaxApertureValue="0/10"'||char(10)||'   exif:MeteringMode="5"'||char(10)||'   exif:LightSource="0"'||char(10)||'   exif:FocalLength="1050/10"'||char(10)||'   exif:SensingMethod="2"'||char(10)||'   exif:FileSource="3"'||char(10)||'   exif:SceneType="1"'||char(10)||'   exif:FocalLengthIn35mmFilm="105"'||char(10)||'   exif:CustomRendered="0"'||char(10)||'   exif:ExposureMode="0"'||char(10)||'   exif:WhiteBalance="0"'||char(10)||'   exif:SceneCaptureType="0"'||char(10)||'   exif:GainControl="2"'||char(10)||'   exif:Contrast="0"'||char(10)||'   exif:Saturation="0"'||char(10)||'   exif:Sharpness="2"'||char(10)||'   exif:SubjectDistanceRange="0"'||char(10)||'   exif:DigitalZoomRatio="1/1"'||char(10)||'   exif:DateTimeOriginal="2012-05-27T19:58:19.56"'||char(10)||'   exif:PixelXDimension="4256"'||char(10)||'   exif:PixelYDimension="2832"'||char(10)||'   exif:GPSLatitude="50,10.0435N"'||char(10)||'   exif:GPSLongitude="12,7.5083333333334E"'||char(10)||'   dc:format="image/x-nikon-nef"'||char(10)||'   xmp:CreatorTool="Ver.1.02"'||char(10)||'   xmp:ModifyDate="2012-05-27T19:58:19.56"'||char(10)||'   xmp:CreateDate="2012-05-27T19:58:19.56"'||char(10)||'   xmp:Label="Private"'||char(10)||'   xmp:Rating="4"'||char(10)||'   aux:SerialNumber="2344388"'||char(10)||'   aux:LensInfo="0/10 0/10 0/10 0/10"'||char(10)||'   aux:Lens="0.0 mm f/0.0"'||char(10)||'   aux:ImageNumber="2366"'||char(10)||'   photoshop:DateCreated="2012-05-27T19:58:19.56"'||char(10)||'   photoshop:AuthorsPosition="Engineer"'||char(10)||'   xmpMM:DocumentID="074CBC20DE8F6EC75C19A1BDFD2E708A"'||char(10)||'   xmpRights:Marked="True"'||char(10)||'   xmpRights:WebStatement="http://www.fotosuppe.de/license.html"'||char(10)||'   crs:Version="7.3"'||char(10)||'   crs:ProcessVersion="6.7"'||char(10)||'   crs:WhiteBalance="Custom"'||char(10)||'   crs:Temperature="5000"'||char(10)||'   crs:Tint="-20"'||char(10)||'   crs:Sharpness="50"'||char(10)||'   crs:LuminanceSmoothing="35"'||char(10)||'   crs:ColorNoiseReduction="25"'||char(10)||'   crs:VignetteAmount="0"'||char(10)||'   crs:ShadowTint="0"'||char(10)||'   crs:RedHue="0"'||char(10)||'   crs:RedSaturation="0"'||char(10)||'   crs:GreenHue="0"'||char(10)||'   crs:GreenSaturation="0"'||char(10)||'   crs:BlueHue="0"'||char(10)||'   crs:BlueSaturation="0"'||char(10)||'   crs:GrayMixerRed="+50"'||char(10)||'   crs:GrayMixerOrange="+25"'||char(10)||'   crs:GrayMixerYellow="0"'||char(10)||'   crs:GrayMixerGreen="-50"'||char(10)||'   crs:GrayMixerAqua="0"'||char(10)||'   crs:GrayMixerBlue="0"'||char(10)||'   crs:GrayMixerPurple="0"'||char(10)||'   crs:GrayMixerMagenta="+20"'||char(10)||'   crs:SplitToningShadowHue="0"'||char(10)||'   crs:SplitToningShadowSaturation="0"'||char(10)||'   crs:SplitToningHighlightHue="0"'||char(10)||'   crs:SplitToningHighlightSaturation="0"'||char(10)||'   crs:SplitToningBalance="0"'||char(10)||'   crs:ParametricShadows="0"'||char(10)||'   crs:ParametricDarks="0"'||char(10)||'   crs:ParametricLights="0"'||char(10)||'   crs:ParametricHighlights="0"'||char(10)||'   crs:ParametricShadowSplit="25"'||char(10)||'   crs:ParametricMidtoneSplit="50"'||char(10)||'   crs:ParametricHighlightSplit="75"'||char(10)||'   crs:SharpenRadius="+1.0"'||char(10)||'   crs:SharpenDetail="40"'||char(10)||'   crs:SharpenEdgeMasking="25"'||char(10)||'   crs:PostCropVignetteAmount="0"'||char(10)||'   crs:GrainAmount="0"'||char(10)||'   crs:LuminanceNoiseReductionDetail="40"'||char(10)||'   crs:ColorNoiseReductionDetail="50"'||char(10)||'   crs:LuminanceNoiseReductionContrast="50"'||char(10)||'   crs:LensProfileEnable="0"'||char(10)||'   crs:LensManualDistortionAmount="0"'||char(10)||'   crs:PerspectiveVertical="0"'||char(10)||'   crs:PerspectiveHorizontal="0"'||char(10)||'   crs:PerspectiveRotate="0.0"'||char(10)||'   crs:PerspectiveScale="100"'||char(10)||'   crs:AutoLateralCA="0"'||char(10)||'   crs:Exposure2012="+0.40"'||char(10)||'   crs:Contrast2012="+20"'||char(10)||'   crs:Highlights2012="0"'||char(10)||'   crs:Shadows2012="0"'||char(10)||'   crs:Whites2012="-80"'||char(10)||'   crs:Blacks2012="-3"'||char(10)||'   crs:Clarity2012="+20"'||char(10)||'   crs:ConvertToGrayscale="True"'||char(10)||'   crs:ToneCurveName2012="Linear"'||char(10)||'   crs:CameraProfile="Adobe Standard"'||char(10)||'   crs:CameraProfileDigest="AC58BA900C3A001F052B43DA5615508D"'||char(10)||'   crs:LensProfileSetup="LensDefaults"'||char(10)||'   crs:HasSettings="True"'||char(10)||'   crs:CropTop="0.10425"'||char(10)||'   crs:CropLeft="0.230673"'||char(10)||'   crs:CropBottom="0.800052"'||char(10)||'   crs:CropRight="0.848001"'||char(10)||'   crs:CropAngle="0"'||char(10)||'   crs:CropConstrainToWarp="0"'||char(10)||'   crs:HasCrop="True"'||char(10)||'   crs:AlreadyApplied="False">'||char(10)||'   <exif:ISOSpeedRatings>'||char(10)||'    <rdf:Seq>'||char(10)||'     <rdf:li>1100</rdf:li>'||char(10)||'    </rdf:Seq>'||char(10)||'   </exif:ISOSpeedRatings>'||char(10)||'   <exif:Flash'||char(10)||'    exif:Fired="False"'||char(10)||'    exif:Return="0"'||char(10)||'    exif:Mode="0"'||char(10)||'    exif:Function="False"'||char(10)||'    exif:RedEyeMode="False"/>'||char(10)||'   <dc:rights>'||char(10)||'    <rdf:Alt>'||char(10)||'     <rdf:li xml:lang="x-default">Copyright 2012 Axel Reinhold www.freakout.de Rights Reserved</rdf:li>'||char(10)||'    </rdf:Alt>'||char(10)||'   </dc:rights>'||char(10)||'   <dc:creator>'||char(10)||'    <rdf:Seq>'||char(10)||'     <rdf:li>Axel Reinhold</rdf:li>'||char(10)||'    </rdf:Seq>'||char(10)||'   </dc:creator>'||char(10)||'   <dc:title>'||char(10)||'    <rdf:Alt>'||char(10)||'     <rdf:li xml:lang="x-default">Laura1:1</rdf:li>'||char(10)||'    </rdf:Alt>'||char(10)||'   </dc:title>'||char(10)||'   <xmpRights:UsageTerms>'||char(10)||'    <rdf:Alt>'||char(10)||'     <rdf:li xml:lang="x-default">Creative Commons by-nc-nd/3.0</rdf:li>'||char(10)||'    </rdf:Alt>'||char(10)||'   </xmpRights:UsageTerms>'||char(10)||'   <crs:ToneCurvePV2012>'||char(10)||'    <rdf:Seq>'||char(10)||'     <rdf:li>0, 0</rdf:li>'||char(10)||'     <rdf:li>255, 255</rdf:li>'||char(10)||'    </rdf:Seq>'||char(10)||'   </crs:ToneCurvePV2012>'||char(10)||'   <crs:ToneCurvePV2012Red>'||char(10)||'    <rdf:Seq>'||char(10)||'     <rdf:li>0, 0</rdf:li>'||char(10)||'     <rdf:li>255, 255</rdf:li>'||char(10)||'    </rdf:Seq>'||char(10)||'   </crs:ToneCurvePV2012Red>'||char(10)||'   <crs:ToneCurvePV2012Green>'||char(10)||'    <rdf:Seq>'||char(10)||'     <rdf:li>0, 0</rdf:li>'||char(10)||'     <rdf:li>255, 255</rdf:li>'||char(10)||'    </rdf:Seq>'||char(10)||'   </crs:ToneCurvePV2012Green>'||char(10)||'   <crs:ToneCurvePV2012Blue>'||char(10)||'    <rdf:Seq>'||char(10)||'     <rdf:li>0, 0</rdf:li>'||char(10)||'     <rdf:li>255, 255</rdf:li>'||char(10)||'    </rdf:Seq>'||char(10)||'   </crs:ToneCurvePV2012Blue>'||char(10)||'   <crs:RetouchInfo>'||char(10)||'    <rdf:Seq>'||char(10)||'     <rdf:li>centerX = 0.646759, centerY = 0.750586, radius = 0.010000, sourceState = sourceAutoComputed, sourceX = 0.641682, sourceY = 0.781427, spotType = heal</rdf:li>'||char(10)||'     <rdf:li>centerX = 0.560974, centerY = 0.783214, radius = 0.010000, sourceState = sourceAutoComputed, sourceX = 0.581767, sourceY = 0.775424, spotType = heal</rdf:li>'||char(10)||'    </rdf:Seq>'||char(10)||'   </crs:RetouchInfo>'||char(10)||'   <crs:PaintBasedCorrections>'||char(10)||'    <rdf:Seq>'||char(10)||'     <rdf:li>'||char(10)||'      <rdf:Description'||char(10)||'       crs:What="Correction"'||char(10)||'       crs:CorrectionAmount="1.000000"'||char(10)||'       crs:CorrectionActive="true"'||char(10)||'       crs:LocalExposure="-0.080460"'||char(10)||'       crs:LocalSaturation="0.000000"'||char(10)||'       crs:LocalContrast="0.000000"'||char(10)||'       crs:LocalClarity="0.000000"'||char(10)||'       crs:LocalSharpness="0.000000"'||char(10)||'       crs:LocalBrightness="0.000000"'||char(10)||'       crs:LocalToningHue="240.000000"'||char(10)||'       crs:LocalToningSaturation="0.000000"'||char(10)||'       crs:LocalExposure2012="-0.080460"'||char(10)||'       crs:LocalContrast2012="0.000000"'||char(10)||'       crs:LocalHighlights2012="0.000000"'||char(10)||'       crs:LocalShadows2012="0.000000"'||char(10)||'       crs:LocalClarity2012="0.000000"'||char(10)||'       crs:LocalLuminanceNoise="0.000000"'||char(10)||'       crs:LocalMoire="0.000000"'||char(10)||'       crs:LocalTemperature="0.000000"'||char(10)||'       crs:LocalTint="0.000000">'||char(10)||'      <crs:CorrectionMasks>'||char(10)||'       <rdf:Seq>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.433030 0.674552</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.436789 0.677729</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.442429 0.682671</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.445719 0.683377</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.449949 0.683377</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.452534 0.683377</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.456059 0.682318</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.460289 0.680553</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.463814 0.679141</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.446189 0.680906</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.469924 0.673845</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.472743 0.670668</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.475093 0.669256</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.477443 0.666079</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.461699 0.654076</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.457234 0.651605</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.453709 0.651605</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.449009 0.654429</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.446894 0.655488</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.438669 0.657254</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.435380 0.655135</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.435380 0.655135</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.433030 0.655135</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.430445 0.655488</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.007755"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.429740 0.656547</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'       </rdf:Seq>'||char(10)||'      </crs:CorrectionMasks>'||char(10)||'      </rdf:Description>'||char(10)||'     </rdf:li>'||char(10)||'     <rdf:li>'||char(10)||'      <rdf:Description'||char(10)||'       crs:What="Correction"'||char(10)||'       crs:CorrectionAmount="1.000000"'||char(10)||'       crs:CorrectionActive="true"'||char(10)||'       crs:LocalExposure="0.057471"'||char(10)||'       crs:LocalSaturation="0.000000"'||char(10)||'       crs:LocalContrast="0.000000"'||char(10)||'       crs:LocalClarity="0.000000"'||char(10)||'       crs:LocalSharpness="0.000000"'||char(10)||'       crs:LocalBrightness="0.000000"'||char(10)||'       crs:LocalToningHue="240.000000"'||char(10)||'       crs:LocalToningSaturation="0.000000"'||char(10)||'       crs:LocalExposure2012="0.057471"'||char(10)||'       crs:LocalContrast2012="0.000000"'||char(10)||'       crs:LocalHighlights2012="0.000000"'||char(10)||'       crs:LocalShadows2012="0.000000"'||char(10)||'       crs:LocalClarity2012="0.000000"'||char(10)||'       crs:LocalLuminanceNoise="0.000000"'||char(10)||'       crs:LocalMoire="0.000000"'||char(10)||'       crs:LocalTemperature="0.000000"'||char(10)||'       crs:LocalTint="0.000000">'||char(10)||'      <crs:CorrectionMasks>'||char(10)||'       <rdf:Seq>'||char(10)||'        <rdf:li>'||char(10)||'         <rdf:Description'||char(10)||'          crs:What="Mask/Paint"'||char(10)||'          crs:MaskValue="0.700000"'||char(10)||'          crs:Radius="0.000589"'||char(10)||'          crs:Flow="1.000000"'||char(10)||'          crs:CenterWeight="0.000000">'||char(10)||'         <crs:Dabs>'||char(10)||'          <rdf:Seq>'||char(10)||'           <rdf:li>M 0.498094 0.503966</rdf:li>'||char(10)||'          </rdf:Seq>'||char(10)||'         </crs:Dabs>'||char(10)||'         </rdf:Description>'||char(10)||'        </rdf:li>'||char(10)||'       </rdf:Seq>'||char(10)||'      </crs:CorrectionMasks>'||char(10)||'      </rdf:Description>'||char(10)||'     </rdf:li>'||char(10)||'    </rdf:Seq>'||char(10)||'   </crs:PaintBasedCorrections>'||char(10)||'   <Iptc4xmpCore:CreatorContactInfo'||char(10)||'    Iptc4xmpCore:CiAdrPcode="95100"'||char(10)||'    Iptc4xmpCore:CiTelWork="+49-9287-8244"'||char(10)||'    Iptc4xmpCore:CiAdrRegion="Bavaria"'||char(10)||'    Iptc4xmpCore:CiAdrCtry="Germany"'||char(10)||'    Iptc4xmpCore:CiEmailWork="[hidden email]"'||char(10)||'    Iptc4xmpCore:CiAdrCity="Selb"'||char(10)||'    Iptc4xmpCore:CiAdrExtadr="Franz-Heinrich-Str. 20"'||char(10)||'    Iptc4xmpCore:CiUrlWork="http://www.fotosuppe.de/"/>'||char(10)||'  </rdf:Description>'||char(10)||' </rdf:RDF>'||char(10)||'</x:xmpmeta>'||char(10));

Hope that this is enough info to track the issue down.

Regards and thank you for sqlite.
Axel Reinhold
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Regression 3.18.0 cannot import Lightroom dump - Expression tree is too large (maximum depth 1000)

Rowan Worth-2
This was already reported recently - if you need a workaround in the short
term (before sqlite itself is fixed) see CL's answer here:

http://stackoverflow.com/q/43145117/11654

-Rowan

2017-04-05 14:10 GMT+08:00 Axel Reinhold <[hidden email]>:

> Dear sqlite-team,
>
> after update to 3.18.0 from 3.17.0 i can no more import a dump of
> my Adobe Lightroom database. The command:
>
> echo .dump | /opt/sqlite/bin/sqlite3 "/save/axel/alr3lb/2017-03-26
> 2040/lr5.lrcat" | /opt/sqlite/bin/sqlite3 t.sq3
>
> which works fine with 3.17.0 produces hundreds of errors with 3.18.0:
>
> Error: near line 69675: Expression tree is too large (maximum depth 1000)
> Error: near line 69676: Expression tree is too large (maximum depth 1000)
> Error: near line 69677: Expression tree is too large (maximum depth 1000)
> Error: near line 69678: Expression tree is too large (maximum depth 1000)
> Error: near line 69679: Expression tree is too large (maximum depth 1000)
> Error: near line 69692: Expression tree is too large (maximum depth 1000)
> Error: near line 69706: Expression tree is too large (maximum depth 1000)
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...