Closed TMinusBlastedRocket closed 1 year ago
the sqlite jdbc driver is implemented as a native library.
Do you have logs of the failure? But regardless, very likely not something for paper to fix/do anything about.
java.sql.SQLException: Error opening connection
at org.sqlite.SQLiteConnection.open(SQLiteConnection.java:244) ~[sqlite-jdbc-3.36.0.3.jar:?]
at org.sqlite.SQLiteConnection.
Java is write once, debug everywhere; native libraries however, are not
It looks like newer versions of the SQLite connector have this resolved, 3.39.2.0 resolves this, spigot is using 3.36.0.3
The nature of the SQLite driver and, well, jdbc stuff in general generally makes just bumping this stuff somewhat of a pain, but, trivial to do if you can build your own jar
On Fri, 30 Dec 2022, 23:15 TMinusBlastedRocket, @.***> wrote:
Expected behavior
sqlite enabled plugins working on a ppc64le system (because java should be universal) Observed/Actual behavior
any plugin that uses SQL fails spectacularly Steps/models to reproduce
acquire a very expensive IBM server (such as the S824 (the unit i have) or an,S924,S822,etc...) or use QEMU like a normal person who doesn't drunkenly buy supercomputers on eBay (be sure to set ppc64le and not ppc64 or ppc32)
run paper with a plugin that uses papers SQL functions (such as plotsquared) watch as it doesn't run Plugin and Datapack List
plotsquared and many, many more Paper version
This server is running Paper version git-Paper-387 (MC: 1.18.2) (Implementing API version 1.18.2-R0.1-SNAPSHOT) (Git: df630a2 https://github.com/PaperMC/Paper/commit/df630a27cc2d0b3731bf5dd311c4119c9c5b43f6 on ver/1.18.2) Other
No response
— Reply to this email directly, view it on GitHub https://github.com/PaperMC/Paper/issues/8745, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJMAZBAJIPYCMZC56TUL3DWP5UHTANCNFSM6AAAAAATNGZLVE . You are receiving this because you are subscribed to this thread.Message ID: @.***>
After some testing, the problem is not with sqllite but with how paper interprets architectures, the "ppc64" tag is used for "ppc64le" systems in the sqllite jar, but paper is looking for ppc64le , papers arch checker code needs a check to use the ppc64 folder binary when ppc64le is in use
After some testing, the problem is not with sqllite but with how paper interprets architectures, the "ppc64" tag is used for "ppc64le" systems in the sqllite jar, but paper is looking for ppc64le , papers arch checker code needs a check to use the ppc64 folder binary when ppc64le is in use
This is in addition to needing to merge the 64le fix sqllite has recently added
the logic for that exists within the sqlite library, not paper; the 64le fix that we pointed to of sqlite is basically where they fixed that platform mapping
Ah, nevermind.... hope that a merge will be possible as paper seems to be the only MC server that actually performs well on power systems. good multithreading is a necessity on POWER as it's single threading is flaming garbage, that being said its MT is incredible
But I understand if a merge won't be possible soon, as it is a complex project
(Note after a year: POWER has great ST, but i was using SMT8 so i didn't know that, if your running MC, PLEASE use SMT1-4)
This issue can be closed considering https://github.com/PaperMC/Paper/pull/8778#issuecomment-1551521397
Expected behavior
sqlite enabled plugins working on a ppc64le system (because java should be universal)
Observed/Actual behavior
any plugin that uses SQL fails spectacularly
Steps/models to reproduce
acquire a very expensive IBM server (such as the S824 (the unit i have) or an,S924,S822,etc...) or use QEMU like a normal person who doesn't drunkenly buy supercomputers on eBay (be sure to set ppc64le and not ppc64 or ppc32)
run paper with a plugin that uses papers SQL functions (such as plotsquared) watch as it doesn't run
Plugin and Datapack List
plotsquared and many, many more
Paper version
This server is running Paper version git-Paper-387 (MC: 1.18.2) (Implementing API version 1.18.2-R0.1-SNAPSHOT) (Git: df630a2 on ver/1.18.2)
Other
No response