From nobody Mon Jul 12 16:46:33 2021 X-Original-To: freebsd-java@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4843212A73FB for ; Mon, 12 Jul 2021 16:46:42 +0000 (UTC) (envelope-from 1983-01-06@gmx.net) Received: from mout.gmx.net (mout.gmx.net [212.227.17.20]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "mout.gmx.net", Issuer "TeleSec ServerPass Class 2 CA" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4GNqRP71qGz4kx8 for ; Mon, 12 Jul 2021 16:46:41 +0000 (UTC) (envelope-from 1983-01-06@gmx.net) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1626108394; bh=IO1HfMEJy+ri39NlKgH1K++aL/P/wBNukfAayX9MsuU=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=ZdmHJLU6tynDbJVJnSW29r7MwyW1ZQouqB5NHpj4GIYTPxZA+KdxUo908dUhBf9wn XrnfZ7nGO5LQQ7f/8CxLHoHouXexH/5c9WlNzM5w6NxPBROzyFY0u282CCc+jQy0a8 iWrXQcfK0AIvD9MqFEfiVq3fJCwpfWk0QlOEMajs= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [192.168.1.52] ([84.143.154.11]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1McpNy-1lUTXP3cX4-00ZttC for ; Mon, 12 Jul 2021 18:46:33 +0200 Subject: Re: Fwd: Java core dump on freeBSD 12.2 To: freebsd-java@freebsd.org References: <261b4107-b2cb-8008-e092-8b05300ef337@gmx.net> From: Michael Osipov <1983-01-06@gmx.net> Message-ID: Date: Mon, 12 Jul 2021 18:46:33 +0200 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 List-Id: Porting Java to FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-java List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-java@freebsd.org MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:HnytiK5dIw6Wf+QlLmC40jcqx0qnMaxxarb1PKJ28ZC/xpkj2/L DM1ZRER3JnmyzDUqhgITTvD0iz3ZCP1Zn+UbE9RenbN/tfbJdFq43zAC2NftqTlrYsO9wSH UVIabyAOmbITwpvxiZNhZU1ZEgDablb4SmTot0iAHJvIQxkIWOj5deu0gi4YKJvw9BGFTPW yrKNHNDmW0BFuAk71keXw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:pE6s+n1GA6w=:hBeCTx3+JTokUKAWMiNLSJ 9lfsoi1ttSBBOAsufZHkrjEtvjgfW10rjYFE1EHnGuUgzfBX74fAtbzMut/M3mAM2iOo7U4OW KI9LomnP7djLbX7E84zk40/jw87zA4k47rK41IB7j44AUsO+MzwMFs4uYB78Qgzz36mDOve1s W+WNUdyjPhnKdPvHrnMbCX6RcZ47jghwet1UtOmt3cvlCZvlKEe0lfIiAnTmNkyAOypQwJ1tN gj7E2z/Kt3B3DKzMEGtYnDAJMZTJl7/RUxr8Sen7SsMHOuTdnPkKdSuxTPpatCBrGDmph69rx wSgjjqnTnPGsLFOC1fpzckczftzm65IyyONPECT/N35CrYGzusbQ+FTjTwLaf3AGIk2W3D1Ba YZNKoU12gOjWviOASVLxJL+uJd8jO5/omLVqBNQmY4hyTnAIpaVsKbjNedzFODpLIOZL9FMcO rUiH2xOfkyw7eZneLwVkX+dXXYt1KcZVKH4YLas87rV+jneLDuyhgtpdVY/iRMmC8u5GOkKIO 9NJIRTphvP/ohf7eVE6EQ2IIJdbIkEVlsSlHb6BnT0kEfzvfyTXWgdQkOeCYlB6jI3rgNVPl6 Seh0F9j/jOthi3xGoqo3XasvRJRQkTL5MtSq2m2d/7V5H3OaWxwAGx35suXQ3p3quP1vNK7Cp q64hu+VfTbdu1ORAyIaJQVbtQCpL6qDe4nZLm4sBBTTW5C/JIcQtAtY1Y/0+vyAEpaE2eJ4ps Mn9fd30np1NzmSjhJyjPhJNE00TyK125x5B6n7rU0jg+L0IiMZ+fd6K30C2s7ez99zjGy4BH7 mcKqfLjRP9GRHrAOOdsFpAMPiRy/NF/oeRelZFUZpe5gMISdp72t1/jIsta63m26Rq35P+xmG RGkqdfvGPvobG/yf4AKTWlInnEfL0GGR6MH3mnny3J1Xi2sXj/4+lhwjNpkiGLXEGRr5IWgvn pRXW/sDK8gsYy36sdLUFWAmxczC2Cwc/eQa+PcwYTyy0jYjye+YMFGjHc9QHwCtAuQfbcF2EB kX/CioUtKUP2LDjt/cwpDyuAf9sQZdhVJgRF/6SBndOxUy6Mn+i++2Fgadudf/o8Iv88eitqq 6YrQo/ar7bDhmo4KsY6Ctk/R2xc9dzbyOJf X-Rspamd-Queue-Id: 4GNqRP71qGz4kx8 X-Spamd-Bar: ---- Authentication-Results: mx1.freebsd.org; none X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[] X-ThisMailContainsUnwantedMimeParts: N Am 2021-07-12 um 17:59 schrieb Simeo Reig: > Hi again, > > You are right. JDBC driver from xerial seems to have some issues in > freebsd. Version 3.32.X versions works ok, but above it (right now last = one > is 3.36.01 ) don't want = to > connect with DB: "DB corrupt" or "java.lang.UnsatisfiedLinkError: 'int > org.sqlite.core.NativeDB.limit(int, int)'" it depends on version. Db is= n't > corrupt, it has the same sha1 in the Linux machine and I have tested it > with pragma integrity_check on freeBSD. I needed to have it online and I > downgraded jdbc to last 3.32 version. Although I don't have access to your deployment, the error is likely very obvious. I'd like to see these solved to avoid issues like yours: * https://github.com/xerial/sqlite-jdbc/issues/542 * https://github.com/xerial/sqlite-jdbc/issues/495 Generally, I don't trust binaries precomplied for FreeBSD because I know people screw up. There is a mismatch between the compiled version and the version loaded at runtime. It seems that the bundled (if this one is used) native library misses these: * https://github.com/xerial/sqlite-jdbc/blame/master/src/main/java/org/sqlit= e/core/NativeDB.java#L434-L436 * https://github.com/xerial/sqlite-jdbc/blame/master/src/main/java/org/sqlit= e/core/NativeDB.c#L1329-L1343 My recommendation: * Remove all native libs from the JAR * Install SQLite 3 through ports * Compile the driver native shim and link /dynamically/ against the libsqlte3.so from LOCALBASE. I have modified the driver recently and upstreamed to load all libs from loader's default path w/o the need to provide anything. If you don't know how to do the above, let me know I can compile the shim for you for amd64. Michael