Open ctlbau opened 10 months ago
@dcarrot Thanks for reporting this. Regarding the issue, is it more accurate to say that you can't set up the Postgres backend - or have you also tested the MySQL backend and that one failed as well?
Looks like an issue in LibPQ.jl
which is an external dependency - let me check.
Hmmm... I see this when attempting to generate an app... Which is probably the cause. But it's strange, because when I install the package independently, it works.
@dcarrot Thanks for reporting this. Regarding the issue, is it more accurate to say that you can't set up the Postgres backend - or have you also tested the MySQL backend and that one failed as well?
Looks like an issue in
LibPQ.jl
which is an external dependency - let me check.
Hi Adrian, yes I tested MySQL as well. Do you want the stacktrace on that one too?
@dcarrot If you have it at hand, yes please.
@dcarrot If you have it at hand, yes please.
WARNING: redefinition of constant PATH. This may fail, cause incorrect answers, or produce other errors.
WARNING: redefinition of constant LIBPATH. This may fail, cause incorrect answers, or produce other errors.
WARNING: redefinition of constant PATH_list. This may fail, cause incorrect answers, or produce other errors.
WARNING: redefinition of constant LIBPATH_list. This may fail, cause incorrect answers, or produce other errors.
┌ Error: Error watching manifest
│ exception =
│ cannot set type for global best_wrapper. It already has a value or is already set to a different type.
│ Stacktrace:
│ [1] top-level scope
│ @ ~/.julia/packages/JLLWrappers/pG9bm/src/toplevel_generators.jl:119
│ Revise evaluation error at /Users/ctl/.julia/packages/JLLWrappers/pG9bm/src/toplevel_generators.jl:119
│
│ Stacktrace:
│ [1] methods_by_execution!(recurse::Any, methodinfo::Revise.CodeTrackingMethodInfo, docexprs::Dict{Module, Vector{Expr}}, mod::Module, ex::Expr; mode::Symbol, disablebp::Bool, always_rethrow::Bool, kwargs::Base.Pairs{Symbol, Union{}, Tuple{}, NamedTuple{(), Tuple{}}})
│ @ Revise ~/.julia/packages/Revise/t6Vjc/src/lowered.jl:227
└ @ Revise ~/.julia/packages/Revise/t6Vjc/src/pkgs.jl:489
[ Info: Done! New app created at /Users/ctl/webdev/try/try
[ Info: Changing active directory to /Users/ctl/webdev/try/try
/var/folders/yn/pvy4skp56mq63d2qq0m56zlw0000gn/T/jl_4P7ynf/Try/Project.toml
[ Info: Project.toml has been generated
[ Info: Installing app dependencies
Activating project at `~/webdev/try/try`
Resolving package versions...
Updating `~/webdev/try/try/Project.toml`
[c43c736e] + Genie v5.19.0
Updating `~/webdev/try/try/Manifest.toml`
[c7e460c6] + ArgParse v1.1.4
[d1d4a3ce] + BitFlags v0.1.7
[00ebfdb7] + CSTParser v3.3.6
[da1fd8a2] + CodeTracking v1.3.5
[944b1d66] + CodecZlib v0.7.2
[a80b9123] + CommonMark v0.8.12
[34da2185] + Compat v4.10.0
[f0e56b4a] + ConcurrentUtilities v2.2.1
[a8cc5b0e] + Crayons v4.1.1
[864edb3b] + DataStructures v0.18.15
[4dc1fcf4] + DotEnv v0.3.1
[460bff9d] + ExceptionUnwrapping v0.1.9
[8f5d6c58] + EzXML v1.1.0
[48062228] + FilePathsBase v0.9.21
[c43c736e] + Genie v5.19.0
[c27321d9] + Glob v1.3.1
[cd3eb016] + HTTP v1.10.0
[77172c1b] + HttpCommon v0.5.0
[6d011eab] + Inflector v1.1.0
[692b3bcd] + JLLWrappers v1.5.0
[682c06a0] + JSON v0.21.4
[0f8b85d8] + JSON3 v1.13.2
[98e50ef6] + JuliaFormatter v1.0.39
[aa1ae85d] + JuliaInterpreter v0.9.25
[e6f89c97] + LoggingExtras v1.0.3
[6f1432cf] + LoweredCodeUtils v2.3.0
[6c6e2e6c] + MIMEs v0.1.4
[739be429] + MbedTLS v1.1.7
[39ec1447] + Millboard v0.2.5
[49dea1ee] + Nettle v1.0.0
[4d1e1d77] + Nullables v1.0.0
[4d8831e6] + OpenSSL v1.4.1
[bac558e1] + OrderedCollections v1.6.2
[69de0a69] + Parsers v2.7.2
[aea7be01] + PrecompileTools v1.2.0
[21216c6a] + Preferences v1.4.1
[189a3867] + Reexport v1.2.2
[ae029012] + Requires v1.3.0
[295af30f] + Revise v3.5.6
[777ac1f9] + SimpleBufferStream v1.1.0
[69024149] + StringEncodings v0.3.7
[856f2bd8] + StructTypes v1.10.0
[b718987f] + TextWrap v1.0.1
[0796e94c] + Tokenize v0.5.25
[3bb67fe8] + TranscodingStreams v0.9.13
[30578b45] + URIParser v0.4.1
[5c2747f8] + URIs v1.5.0
[ddb6d928] + YAML v0.4.9
[94ce4f54] + Libiconv_jll v1.17.0+0
[4c82536e] + Nettle_jll v3.7.2+0
[458c3c95] + OpenSSL_jll v3.0.11+0
[02c8fc9c] + XML2_jll v2.11.5+0
[0dad84c5] + ArgTools v1.1.1
[56f22d72] + Artifacts
[2a0f44e3] + Base64
[ade2ca70] + Dates
[8ba89e20] + Distributed
[f43a241f] + Downloads v1.6.0
[7b1f6079] + FileWatching
[b77e0a4c] + InteractiveUtils
[b27032c2] + LibCURL v0.6.3
[76f85450] + LibGit2
[8f399da3] + Libdl
[56ddb016] + Logging
[d6f4376e] + Markdown
[a63ad114] + Mmap
[ca575930] + NetworkOptions v1.2.0
[44cfe95a] + Pkg v1.9.2
[de0858da] + Printf
[3fa0cd96] + REPL
[9a3f8284] + Random
[ea8e919c] + SHA v0.7.0
[9e88b42a] + Serialization
[6462fe0b] + Sockets
[fa267f1f] + TOML v1.0.3
[a4e569a6] + Tar v1.10.0
[8dfed614] + Test
[cf7118a7] + UUIDs
[4ec0a83e] + Unicode
[781609d7] + GMP_jll v6.2.1+2
[deac9b47] + LibCURL_jll v7.84.0+0
[29816b5a] + LibSSH2_jll v1.10.2+0
[c8ffd9c3] + MbedTLS_jll v2.28.2+0
[14a3606d] + MozillaCACerts_jll v2022.10.11
[83775a58] + Zlib_jll v1.2.13+0
[8e850ede] + nghttp2_jll v1.48.0+0
[3f19e933] + p7zip_jll v17.4.0+0
Precompiling project...
1 dependency successfully precompiled in 1 seconds. 56 already precompiled.
┌ Warning: You need to edit the database configuration file at db/connection.yml to set your database connection info.
└ @ Genie.Generator ~/.julia/packages/Genie/dOqOT/src/Generator.jl:617
Activating project at `~/webdev/try/try`
[ Info: Installing dependencies for unit tests
Activating new project at `~/webdev/try/try/test`
┌ Warning: You need to edit the database configuration file at db/connection.yml to set your database connection info.
└ @ Genie.Generator ~/.julia/packages/Genie/dOqOT/src/Generator.jl:617
Activating project at `~/webdev/try/try`
Activating project at `~/webdev/try/try`
[ Info: Starting your brand new Genie app - hang tight!
[ Info: Precompiling SearchLightMySQL [1297d576-4826-11ea-035e-9995c721bad1]
ERROR: LoadError: InitError: could not load library "/Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib"
dlopen(/Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib, 0x0001): Library not loaded: @rpath/libssl.1.1.dylib
Referenced from: <691549D3-D087-371A-9DA1-7CC70A0DC142> /Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib
Reason: tried: '/Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/../libssl.1.1.dylib' (no such file), '/Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/../libssl.1.1.dylib' (no such file), '/Users/ctl/.julia/juliaup/julia-1.9.3+0.aarch64.apple.darwin14/lib/julia/libssl.1.1.dylib' (no such file), '/Users/ctl/.julia/juliaup/julia-1.9.3+0.aarch64.apple.darwin14/lib/julia/../libssl.1.1.dylib' (no such file), '/Users/ctl/.julia/juliaup/julia-1.9.3+0.aarch64.apple.darwin14/lib/libssl.1.1.dylib' (no such file)
Stacktrace:
[1] dlopen(s::String, flags::UInt32; throw_error::Bool)
@ Base.Libc.Libdl ./libdl.jl:117
[2] dlopen(s::String, flags::UInt32)
@ Base.Libc.Libdl ./libdl.jl:116
[3] macro expansion
@ ~/.julia/packages/JLLWrappers/pG9bm/src/products/library_generators.jl:63 [inlined]
[4] __init__()
@ MariaDB_Connector_C_jll ~/.julia/packages/MariaDB_Connector_C_jll/izE4H/src/wrappers/aarch64-apple-darwin.jl:12
[5] register_restored_modules(sv::Core.SimpleVector, pkg::Base.PkgId, path::String)
@ Base ./loading.jl:1115
[6] _include_from_serialized(pkg::Base.PkgId, path::String, ocachepath::String, depmods::Vector{Any})
@ Base ./loading.jl:1061
[7] _require_search_from_serialized(pkg::Base.PkgId, sourcepath::String, build_id::UInt128)
@ Base ./loading.jl:1506
[8] _require(pkg::Base.PkgId, env::String)
@ Base ./loading.jl:1783
[9] _require_prelocked(uuidkey::Base.PkgId, env::String)
@ Base ./loading.jl:1660
[10] macro expansion
@ ./loading.jl:1648 [inlined]
[11] macro expansion
@ ./lock.jl:267 [inlined]
[12] require(into::Module, mod::Symbol)
@ Base ./loading.jl:1611
[13] top-level scope
@ ~/.julia/packages/MySQL/3VbD5/src/api/API.jl:19
[14] include(mod::Module, _path::String)
@ Base ./Base.jl:457
[15] include(x::String)
@ MySQL ~/.julia/packages/MySQL/3VbD5/src/MySQL.jl:1
[16] top-level scope
@ ~/.julia/packages/MySQL/3VbD5/src/MySQL.jl:13
[17] include
@ ./Base.jl:457 [inlined]
[18] include_package_for_output(pkg::Base.PkgId, input::String, depot_path::Vector{String}, dl_load_path::Vector{String}, load_path::Vector{String}, concrete_deps::Vector{Pair{Base.PkgId, UInt128}}, source::String)
@ Base ./loading.jl:2049
[19] top-level scope
@ stdin:3
during initialization of module MariaDB_Connector_C_jll
in expression starting at /Users/ctl/.julia/packages/MySQL/3VbD5/src/api/API.jl:1
in expression starting at /Users/ctl/.julia/packages/MySQL/3VbD5/src/MySQL.jl:1
in expression starting at stdin:3
ERROR: LoadError: Failed to precompile MySQL [39abe10b-433b-5dbd-92d4-e302a9df00cd] to "/Users/ctl/.julia/compiled/v1.9/MySQL/jl_DlkjMr".
Stacktrace:
[1] error(s::String)
@ Base ./error.jl:35
[2] compilecache(pkg::Base.PkgId, path::String, internal_stderr::IO, internal_stdout::IO, keep_loaded_modules::Bool)
@ Base ./loading.jl:2300
[3] compilecache
@ ./loading.jl:2167 [inlined]
[4] _require(pkg::Base.PkgId, env::String)
@ Base ./loading.jl:1805
[5] _require_prelocked(uuidkey::Base.PkgId, env::String)
@ Base ./loading.jl:1660
[6] macro expansion
@ ./loading.jl:1648 [inlined]
[7] macro expansion
@ ./lock.jl:267 [inlined]
[8] require(into::Module, mod::Symbol)
@ Base ./loading.jl:1611
[9] include
@ ./Base.jl:457 [inlined]
[10] include_package_for_output(pkg::Base.PkgId, input::String, depot_path::Vector{String}, dl_load_path::Vector{String}, load_path::Vector{String}, concrete_deps::Vector{Pair{Base.PkgId, UInt128}}, source::Nothing)
@ Base ./loading.jl:2049
[11] top-level scope
@ stdin:3
in expression starting at /Users/ctl/.julia/packages/SearchLightMySQL/CtQr6/src/SearchLightMySQL.jl:1
in expression starting at stdin:3
ERROR: Failed to precompile SearchLightMySQL [1297d576-4826-11ea-035e-9995c721bad1] to "/Users/ctl/.julia/compiled/v1.9/SearchLightMySQL/jl_469Xo0".
Stacktrace:
[1] error(s::String)
@ Base ./error.jl:35
[2] compilecache(pkg::Base.PkgId, path::String, internal_stderr::IO, internal_stdout::IO, keep_loaded_modules::Bool)
@ Base ./loading.jl:2300
[3] compilecache
@ ./loading.jl:2167 [inlined]
[4] _require(pkg::Base.PkgId, env::String)
@ Base ./loading.jl:1805
[5] _require_prelocked(uuidkey::Base.PkgId, env::String)
@ Base ./loading.jl:1660
[6] macro expansion
@ ./loading.jl:1648 [inlined]
[7] macro expansion
@ ./lock.jl:267 [inlined]
[8] require(into::Module, mod::Symbol)
@ Base ./loading.jl:1611
[9] eval
@ ./boot.jl:370 [inlined]
[10] autoconfdb(dbadapter::String)
@ Genie.Generator ~/.julia/packages/Genie/dOqOT/src/Generator.jl:856
[11] loadapp(path::String; autostart::Bool, dbadapter::String, context::Module)
@ Genie ~/.julia/packages/Genie/dOqOT/src/Genie.jl:100
[12] loadapp
@ ~/.julia/packages/Genie/dOqOT/src/Genie.jl:95 [inlined]
[13] autostart_app(path::String; autostart::Bool, initdb::Bool, dbadapter::String)
@ Genie.Generator ~/.julia/packages/Genie/dOqOT/src/Generator.jl:656
[14] post_create(app_name::String, app_path::String; autostart::Bool, testmode::Bool, dbsupport::Bool, dbadapter::String, interactive::Bool)
@ Genie.Generator ~/.julia/packages/Genie/dOqOT/src/Generator.jl:768
[15] post_create
@ ~/.julia/packages/Genie/dOqOT/src/Generator.jl:755 [inlined]
[16] newapp(app_name::String; autostart::Bool, fullstack::Bool, dbsupport::Bool, mvcsupport::Bool, testmode::Bool, dbadapter::Nothing, interactive::Bool)
@ Genie.Generator ~/.julia/packages/Genie/dOqOT/src/Generator.jl:748
[17] newapp
@ ~/.julia/packages/Genie/dOqOT/src/Generator.jl:720 [inlined]
[18] #newapp_mvc#47
@ ~/.julia/packages/Genie/dOqOT/src/Generator.jl:830 [inlined]
[19] newapp_mvc(name::String)
@ Genie.Generator ~/.julia/packages/Genie/dOqOT/src/Generator.jl:828
[20] top-level scope
@ REPL[4]:1
It's a bit strange... yesterday when I tried setting it up I don think I got the warnings and errors about redefinition of path constants...
Here there seems to be an issue with the MariaDB library
LoadError: InitError: could not load library "/Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib"
dlopen(/Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib, 0x0001): Library not loaded: @rpath/libssl.1.1.dylib
Referenced from: <691549D3-D087-371A-9DA1-7CC70A0DC142> /Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib
Here there seems to be an issue with the MariaDB library
LoadError: InitError: could not load library "/Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib" dlopen(/Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib, 0x0001): Library not loaded: @rpath/libssl.1.1.dylib Referenced from: <691549D3-D087-371A-9DA1-7CC70A0DC142> /Users/ctl/.julia/artifacts/bfe66c4df465af0bde5e6d003cd71d40c8ae63e9/lib/mariadb/libmariadb.3.dylib
Indeed. Let me know what else I can do to help.
Thanks - I'll do some debugging and follow up. You could use SQLite for now as in theory the switch should be seamless.
Describe the bug In brand new project with only Genie added
Genie.Generator.newapp_mvc(<...>)
fails to precompile any backend other than SQLiteError stacktrace
To reproduce Created new directory, cd'ed into it, fired up Julia,
] add Genie
,using Genie
,Genie.Generator.newapp_mvc(<...>)
Expected behavior Setup PostgreSQL and/or MySQL backend support
Additional context Julia Version 1.9.3 Commit bed2cd540a1 (2023-08-24 14:43 UTC) Build Info: Official https://julialang.org/ release Platform Info: OS: macOS (arm64-apple-darwin22.4.0) CPU: 12 × Apple M2 Max WORD_SIZE: 64 LIBM: libopenlibm LLVM: libLLVM-14.0.6 (ORCJIT, apple-m1) Threads: 1 on 8 virtual cores and
pkg> st