Package evaluation to test PSRDatabase on Julia 1.14.0-DEV.30 (073666df8b*) started at 2025-11-04T16:32:54.892 ################################################################################ # Set-up # Installing PkgEval dependencies (TestEnv)... Set-up completed after 9.55s ################################################################################ # Installation # Installing PSRDatabase... Resolving package versions... Updating `~/.julia/environments/v1.14/Project.toml` [d9b62651] + PSRDatabase v0.2.1 Updating `~/.julia/environments/v1.14/Manifest.toml` [34da2185] + Compat v4.18.1 [a8cc5b0e] + Crayons v4.1.1 [a10d1c49] + DBInterface v2.6.1 [9a962f9c] + DataAPI v1.16.0 [a93c6f00] + DataFrames v1.8.1 [864edb3b] + DataStructures v0.19.2 [e2d170a0] + DataValueInterfaces v1.0.0 [842dd82b] + InlineStrings v1.4.5 [41ab1584] + InvertedIndices v1.3.1 [82899510] + IteratorInterfaceExtensions v1.0.0 [692b3bcd] + JLLWrappers v1.7.1 [b964fa9f] + LaTeXStrings v1.4.0 [e1d29d7a] + Missings v1.2.0 [bac558e1] + OrderedCollections v1.8.1 [d9b62651] + PSRDatabase v0.2.1 [69de0a69] + Parsers v2.8.3 [2dfb63ee] + PooledArrays v1.4.3 [aea7be01] + PrecompileTools v1.3.3 [21216c6a] + Preferences v1.5.0 [08abe8d2] + PrettyTables v3.1.0 [189a3867] + Reexport v1.2.2 [0aa819cd] + SQLite v1.6.1 [91c51154] + SentinelArrays v1.4.8 [a2af1166] + SortingAlgorithms v1.2.2 [10745b16] + Statistics v1.11.1 [892a3eda] + StringManipulation v0.4.1 [3783bdb8] + TableTraits v1.0.1 [bd369af6] + Tables v1.12.1 [ea10d353] + WeakRefStrings v1.4.2 [76ed43ae] + SQLite_jll v3.48.0+0 [56f22d72] + Artifacts v1.11.0 [2a0f44e3] + Base64 v1.11.0 [ade2ca70] + Dates v1.11.0 [7b1f6079] + FileWatching v1.11.0 [9fa8497b] + Future v1.11.0 [b77e0a4c] + InteractiveUtils v1.11.0 [ac6e5ff7] + JuliaSyntaxHighlighting v1.12.0 [8f399da3] + Libdl v1.11.0 [37e2e46d] + LinearAlgebra v1.13.0 [d6f4376e] + Markdown v1.11.0 [de0858da] + Printf v1.11.0 [3fa0cd96] + REPL v1.11.0 [9a3f8284] + Random v1.11.0 [ea8e919c] + SHA v1.0.0 [9e88b42a] + Serialization v1.11.0 [6462fe0b] + Sockets v1.11.0 [f489334b] + StyledStrings v1.11.0 [fa267f1f] + TOML v1.0.3 [cf7118a7] + UUIDs v1.11.0 [4ec0a83e] + Unicode v1.11.0 [e66e0078] + CompilerSupportLibraries_jll v1.3.0+1 [4536629a] + OpenBLAS_jll v0.3.29+0 [83775a58] + Zlib_jll v1.3.1+2 [8e850b90] + libblastrampoline_jll v5.15.0+0 Installation completed after 4.9s ################################################################################ # Precompilation # Precompiling PkgEval dependencies... ┌ Error: Failed to use TestEnv.jl; test dependencies will not be precompiled │ exception = │ UndefVarError: `project_rel_path` not defined in `TestEnv` │ Suggestion: this global was defined as `Pkg.Operations.project_rel_path` but not assigned a value. │ Stacktrace: │ [1] get_test_dir(ctx::Pkg.Types.Context, pkgspec::PackageSpec) │ @ TestEnv ~/.julia/packages/TestEnv/nGMfF/src/julia-1.11/common.jl:75 │ [2] test_dir_has_project_file │ @ ~/.julia/packages/TestEnv/nGMfF/src/julia-1.11/common.jl:52 [inlined] │ [3] maybe_gen_project_override! │ @ ~/.julia/packages/TestEnv/nGMfF/src/julia-1.11/common.jl:83 [inlined] │ [4] activate(pkg::String; allow_reresolve::Bool) │ @ TestEnv ~/.julia/packages/TestEnv/nGMfF/src/julia-1.11/activate_set.jl:12 │ [5] activate(pkg::String) │ @ TestEnv ~/.julia/packages/TestEnv/nGMfF/src/julia-1.11/activate_set.jl:9 │ [6] top-level scope │ @ /PkgEval.jl/scripts/precompile.jl:24 │ [7] include(mod::Module, _path::String) │ @ Base ./Base.jl:309 │ [8] exec_options(opts::Base.JLOptions) │ @ Base ./client.jl:344 │ [9] _start() │ @ Base ./client.jl:577 └ @ Main /PkgEval.jl/scripts/precompile.jl:26 Precompiling package dependencies... Precompiling packages... 4321.8 ms ✓ SQLite 12494.4 ms ✓ PSRDatabase 2 dependencies successfully precompiled in 17 seconds. 44 already precompiled. Precompilation completed after 30.21s ################################################################################ # Testing # Testing PSRDatabase Status `/tmp/jl_FMifdi/Project.toml` [4c88cf16] Aqua v0.8.14 [a10d1c49] DBInterface v2.6.1 [a93c6f00] DataFrames v1.8.1 [bac558e1] OrderedCollections v1.8.1 [d9b62651] PSRDatabase v0.2.1 [0aa819cd] SQLite v1.6.1 [bd369af6] Tables v1.12.1 [ade2ca70] Dates v1.11.0 [9a3f8284] Random v1.11.0 [fa267f1f] TOML v1.0.3 [8dfed614] Test v1.11.0 Status `/tmp/jl_FMifdi/Manifest.toml` [4c88cf16] Aqua v0.8.14 [34da2185] Compat v4.18.1 [a8cc5b0e] Crayons v4.1.1 [a10d1c49] DBInterface v2.6.1 [9a962f9c] DataAPI v1.16.0 [a93c6f00] DataFrames v1.8.1 [864edb3b] DataStructures v0.19.2 [e2d170a0] DataValueInterfaces v1.0.0 [842dd82b] InlineStrings v1.4.5 [41ab1584] InvertedIndices v1.3.1 [82899510] IteratorInterfaceExtensions v1.0.0 [692b3bcd] JLLWrappers v1.7.1 [b964fa9f] LaTeXStrings v1.4.0 [e1d29d7a] Missings v1.2.0 [bac558e1] OrderedCollections v1.8.1 [d9b62651] PSRDatabase v0.2.1 [69de0a69] Parsers v2.8.3 [2dfb63ee] PooledArrays v1.4.3 [aea7be01] PrecompileTools v1.3.3 [21216c6a] Preferences v1.5.0 [08abe8d2] PrettyTables v3.1.0 [189a3867] Reexport v1.2.2 [0aa819cd] SQLite v1.6.1 [91c51154] SentinelArrays v1.4.8 [a2af1166] SortingAlgorithms v1.2.2 [10745b16] Statistics v1.11.1 [892a3eda] StringManipulation v0.4.1 [3783bdb8] TableTraits v1.0.1 [bd369af6] Tables v1.12.1 [ea10d353] WeakRefStrings v1.4.2 [76ed43ae] SQLite_jll v3.48.0+0 [0dad84c5] ArgTools v1.1.2 [56f22d72] Artifacts v1.11.0 [2a0f44e3] Base64 v1.11.0 [ade2ca70] Dates v1.11.0 [f43a241f] Downloads v1.7.0 [7b1f6079] FileWatching v1.11.0 [9fa8497b] Future v1.11.0 [b77e0a4c] InteractiveUtils v1.11.0 [ac6e5ff7] JuliaSyntaxHighlighting v1.12.0 [b27032c2] LibCURL v1.0.0 [76f85450] LibGit2 v1.11.0 [8f399da3] Libdl v1.11.0 [37e2e46d] LinearAlgebra v1.13.0 [56ddb016] Logging v1.11.0 [d6f4376e] Markdown v1.11.0 [ca575930] NetworkOptions v1.3.0 [44cfe95a] Pkg v1.13.0 [de0858da] Printf v1.11.0 [3fa0cd96] REPL v1.11.0 [9a3f8284] Random v1.11.0 [ea8e919c] SHA v1.0.0 [9e88b42a] Serialization v1.11.0 [6462fe0b] Sockets v1.11.0 [f489334b] StyledStrings v1.11.0 [fa267f1f] TOML v1.0.3 [a4e569a6] Tar v1.10.0 [8dfed614] Test v1.11.0 [cf7118a7] UUIDs v1.11.0 [4ec0a83e] Unicode v1.11.0 [e66e0078] CompilerSupportLibraries_jll v1.3.0+1 [deac9b47] LibCURL_jll v8.16.0+0 [e37daf67] LibGit2_jll v1.9.1+0 [29816b5a] LibSSH2_jll v1.11.3+1 [14a3606d] MozillaCACerts_jll v2025.9.9 [4536629a] OpenBLAS_jll v0.3.29+0 [458c3c95] OpenSSL_jll v3.5.4+0 [efcefdf7] PCRE2_jll v10.47.0+0 [83775a58] Zlib_jll v1.3.1+2 [3161d3a3] Zstd_jll v1.5.7+1 [8e850b90] libblastrampoline_jll v5.15.0+0 [8e850ede] nghttp2_jll v1.67.1+0 [3f19e933] p7zip_jll v17.6.0+0 Testing Running tests... ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/migrations.jl:119 ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/migrations.jl:119 ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/migrations.jl:119 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Configuration" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Configuration" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Product" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Product" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 Starting perfromance reports Adding one by one Time to create 100 parameters => 0.381362434 Time to create 100 vectors => 2.718792729 Adding one by one within a transaction Time to create 100 parameters => 0.00208256 Time to create 100 vectors => 0.01360448 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/create.jl:351 ┌ Error: The foreign key "plant_turbine_to" in table "Plant" of collection "Plant" does not set to null on delete. You must set it to "SET NULL". └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/collection.jl:588 ┌ Error: The foreign key "id" in table "Plant" of collection "Plant" does not cascade on update. This might cause problems in the future. You must set it to "CASCADE". └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/collection.jl:596 ┌ Error: Table Resource_vector_some_group is a vector table and does not have an "vector_index" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/validate.jl:122 ┌ Error: Duplicated attribute some_type in collection Resource └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/collection.jl:633 ┌ Error: Table Resource has a nullable "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/validate.jl:71 ┌ Error: Table Plant has a non-unique "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/validate.jl:67 ┌ Error: Table Plant has a nullable "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/validate.jl:71 ┌ Error: psr_database_sqlite_error executing command: CREATE TABLE Resource ( │ id INTEGER PRIMARY KEY AUTOINCREMENT, │ label TEXT UNIQUE NOT NULL, │ type2 TEXT NOT NULL DEFAULT "D" CHECK(type IN ('D', 'E', 'F')) │ ) STRICT │ psr_database_sqlite_error message: table Resource already exists └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/utils.jl:25 ┌ Error: Scalar relation "plant_turbine_to" in collection "Plant" has a not null constraint. This is not allowed. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/collection.jl:676 ┌ Error: Table Process_set_someset is a set table but does not have a unique constraint on all its columns. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/validate.jl:150 ┌ Error: Table Process_set_someset is a set table but does not have any unique constraints. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/NDCGi/src/validate.jl:141 Test Summary: | Pass Total Time test set | 671 671 4m40.3s test_backups | 3 3 29.3s test_applying_migrations_from_a_certain_point | 2 2 2.1s test_chaining_migrations | 1 1 0.0s test_create_database_from_migrations | 1 1 0.2s test_create_table_migration | 1 1 0.0s test_foreign_keys | 0 5.5s test_invalid_migrations | 1 1 0.5s test_apply_invalid_range_of_migrations | 1 1 0.0s test_apply_migration_that_does_not_exist | 3 3 0.1s test_apply_migrations_in_inavlid_direction | 2 2 0.0s test_create_migration_with_existing_name | 1 1 0.2s Aqua | 10 10 1m36.1s test_create_empty_parameters | 2 2 4.3s test_create_parameters | 3 3 1.1s test_create_parameters_and_vectors | 4 4 7.5s test_create_scalar_parameter_date | 4 4 1.9s test_create_sets_with_relations | 5 5 4.1s test_create_time_series | 2 2 4.6s test_create_vector_with_empty_relations_id | 1 1 2.2s test_create_vector_with_empty_relations_string | 1 1 1.7s test_create_vectors_with_different_sizes_in_same_group | 2 2 0.1s test_create_vectors_with_relations | 5 5 1.7s test_create_with_transaction | 1 1 0.3s test_delete_cascade | 10 10 5.5s test_delete_element | 3 3 0.5s test_performance_naive | 0 3.7s test_performance_with_transactions | 0 0.2s test_no_user_version_database | 1 1 0.0s test_valid_pragmas_database | 0 0.0s test_read_parameters | 31 31 5.6s test_read_relations | 12 12 9.0s test_read_time_series_files | 5 5 2.2s test_read_only | 4 4 1.0s test_add_time_series_row | 6 6 3.6s test_create_wrong_time_series | 4 4 1.8s test_delete_time_series | 3 3 1.9s test_read_time_series_single | 253 253 9.0s test_time_controller_empty | 1 1 1.9s test_time_controller_filled_then_empty | 19 19 5.2s test_time_controller_read | 108 108 3.6s test_time_controller_read_more_agents | 18 18 1.6s test_time_controller_read_more_agents_2 | 6 6 1.6s test_unordered_time_controller | 1 1 2.5s test_update_time_series | 75 75 4.7s test_update_scalar_parameters | 4 4 3.3s test_update_scalar_relations | 9 9 1.9s test_update_set_parameters | 3 3 2.3s test_update_set_relations | 3 3 0.6s test_update_time_series | 10 10 1.5s test_update_time_series_files | 4 4 0.3s test_update_vector_parameters | 3 3 0.7s test_update_vector_relations | 3 3 0.8s test_update_vector_with_empty_relations_id | 1 1 1.8s test_update_vector_with_empty_relations_string | 1 1 1.7s test_extra_lines_sql_file | 0 0.0s test_invalid_database_foreign_key_actions | 1 1 0.5s test_invalid_database_vector_table_without_vector_index | 1 1 0.0s test_invalid_database_with_duplicated_attributes | 2 2 0.2s test_invalid_database_with_invalid_collection_id | 1 1 0.0s test_invalid_database_without_configuration_table | 1 1 0.1s test_invalid_database_without_label_constraints | 1 1 0.6s test_invalid_duplicated_collection_definition | 1 1 0.0s test_invalid_foreign_key_has_not_null_constraint | 1 1 0.0s test_invalid_relation_attribute | 1 1 0.1s test_invalid_set_table_not_all_unique | 1 1 0.1s test_invalid_set_table_without_unique_constraint | 1 1 0.1s test_invalid_vector_table | 1 1 0.0s test_valid_database | 1 1 0.1s Testing PSRDatabase tests passed Testing completed after 265.85s PkgEval succeeded after 348.12s