Package evaluation to test PSRDatabase on Julia 1.14.0-DEV.1475 (42ad41c179*) started at 2026-01-04T16:02:50.844 ################################################################################ # Set-up # Installing PkgEval dependencies (TestEnv)... Activating project at `~/.julia/environments/v1.14` Set-up completed after 8.51s ################################################################################ # Installation # Installing PSRDatabase... Resolving package versions... Updating `~/.julia/environments/v1.14/Project.toml` [d9b62651] + PSRDatabase v0.5.0 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.3 [e2d170a0] + DataValueInterfaces v1.0.0 [4e289a0a] + EnumX v1.0.5 [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.5.0 [69de0a69] + Parsers v2.8.3 [2dfb63ee] + PooledArrays v1.4.3 [aea7be01] + PrecompileTools v1.3.3 [21216c6a] + Preferences v1.5.1 [08abe8d2] + PrettyTables v3.1.2 [189a3867] + Reexport v1.2.2 [0aa819cd] + SQLite v1.6.1 [91c51154] + SentinelArrays v1.4.9 [a2af1166] + SortingAlgorithms v1.2.2 [10745b16] + Statistics v1.11.1 [892a3eda] + StringManipulation v0.4.2 [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.13.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.13.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.8s ################################################################################ # Precompilation # ERROR: LoadError: MethodError: no method matching setindex!(::Base.ScopedValues.ScopedValue{IO}, ::Nothing) The function `setindex!` exists, but no method is defined for this combination of argument types. Stacktrace: [1] top-level scope @ /PkgEval.jl/scripts/precompile.jl:10 [2] include(mod::Module, _path::String) @ Base ./Base.jl:309 [3] exec_options(opts::Base.JLOptions) @ Base ./client.jl:344 [4] _start() @ Base ./client.jl:585 in expression starting at /PkgEval.jl/scripts/precompile.jl:6 caused by: MethodError: no method matching setindex!(::Base.ScopedValues.ScopedValue{IO}, ::Base.DevNull) The function `setindex!` exists, but no method is defined for this combination of argument types. Stacktrace: [1] top-level scope @ /PkgEval.jl/scripts/precompile.jl:7 [2] include(mod::Module, _path::String) @ Base ./Base.jl:309 [3] exec_options(opts::Base.JLOptions) @ Base ./client.jl:344 [4] _start() @ Base ./client.jl:585 Precompilation failed after 11.96s ################################################################################ # Testing # Testing PSRDatabase Status `/tmp/jl_8A5fCj/Project.toml` [4c88cf16] Aqua v0.8.14 [a10d1c49] DBInterface v2.6.1 [a93c6f00] DataFrames v1.8.1 [4e289a0a] EnumX v1.0.5 [bac558e1] OrderedCollections v1.8.1 [d9b62651] PSRDatabase v0.5.0 [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_8A5fCj/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.3 [e2d170a0] DataValueInterfaces v1.0.0 [4e289a0a] EnumX v1.0.5 [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.5.0 [69de0a69] Parsers v2.8.3 [2dfb63ee] PooledArrays v1.4.3 [aea7be01] PrecompileTools v1.3.3 [21216c6a] Preferences v1.5.1 [08abe8d2] PrettyTables v3.1.2 [189a3867] Reexport v1.2.2 [0aa819cd] SQLite v1.6.1 [91c51154] SentinelArrays v1.4.9 [a2af1166] SortingAlgorithms v1.2.2 [10745b16] Statistics v1.11.1 [892a3eda] StringManipulation v0.4.2 [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.13.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.14.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.13.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.17.0+0 [e37daf67] LibGit2_jll v1.9.2+0 [29816b5a] LibSSH2_jll v1.11.3+1 [14a3606d] MozillaCACerts_jll v2025.12.2 [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.68.0+1 [3f19e933] p7zip_jll v17.7.0+0 Testing Running tests... ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/migrations.jl:119 ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/migrations.jl:119 ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/migrations.jl:119 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Configuration" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Configuration" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Product" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Product" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 Starting perfromance reports Adding one by one Time to create 100 parameters => 0.363102475 Time to create 100 vectors => 2.123314308 Adding one by one within a transaction Time to create 100 parameters => 0.002778042 Time to create 100 vectors => 0.021449948 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/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/xbait/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/xbait/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/xbait/src/validate.jl:122 ┌ Error: Duplicated attribute some_type in collection Resource └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/collection.jl:633 ┌ Error: Table Resource has a nullable "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/validate.jl:71 ┌ Error: Table Plant has a non-unique "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/validate.jl:67 ┌ Error: Table Plant has a nullable "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/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/xbait/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/xbait/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/xbait/src/validate.jl:150 ┌ Error: Table Process_set_someset is a set table but does not have any unique constraints. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/xbait/src/validate.jl:141 Test Summary: | Pass Total Time test set | 66526 66526 4m50.9s test_backups | 3 3 24.0s test_applying_migrations_from_a_certain_point | 2 2 1.2s test_chaining_migrations | 1 1 0.0s test_create_database_from_migrations | 1 1 1.0s test_create_table_migration | 1 1 0.0s test_foreign_keys | 0 4.1s 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.0s test_apply_migrations_in_inavlid_direction | 2 2 0.0s test_create_migration_with_existing_name | 1 1 0.1s Aqua | 10 10 1m21.6s test_compare_databases_comprehensive | 3 3 18.9s test_compare_databases_different_element_counts | 2 2 4.5s test_compare_databases_empty | 1 1 2.6s test_compare_identical_databases | 1 1 0.7s test_compare_scalar_parameters_different_count | 2 2 0.8s test_compare_scalar_parameters_different_values | 3 3 0.5s test_compare_scalar_parameters_null_mismatch | 2 2 0.9s test_compare_scalar_relations_different_relations | 3 3 1.0s test_compare_scalar_relations_identical | 1 1 0.8s test_compare_set_parameters_different_lengths | 2 2 1.2s test_compare_set_parameters_different_sets | 3 3 0.8s test_compare_set_parameters_empty_set | 2 2 0.4s test_compare_set_parameters_identical | 1 1 0.4s test_compare_set_parameters_null_mismatch | 2 2 0.5s test_compare_set_relations_different_lengths | 2 2 0.9s test_compare_set_relations_different_relations | 3 3 0.9s test_compare_set_relations_identical | 1 1 0.4s test_compare_set_relations_null_mismatch | 2 2 0.7s test_compare_time_series_different_columns | 2 2 2.1s test_compare_time_series_different_sizes | 2 2 0.4s test_compare_time_series_different_values | 3 3 0.5s test_compare_time_series_files_different_paths | 3 3 1.3s test_compare_time_series_files_missing_in_one | 2 2 0.4s test_compare_time_series_identical | 1 1 0.3s test_compare_time_series_missing_values | 2 2 1.3s test_compare_vector_parameters_different_element_count | 2 2 0.4s test_compare_vector_parameters_different_lengths | 2 2 0.4s test_compare_vector_parameters_different_values | 3 3 0.8s test_compare_vector_parameters_empty_vector | 2 2 0.6s test_compare_vector_parameters_null_mismatch | 2 2 0.6s test_compare_vector_relations_different_lengths | 2 2 1.2s test_compare_vector_relations_different_relations | 3 3 0.6s test_create_empty_parameters | 2 2 0.3s test_create_parameters | 3 3 0.6s test_create_parameters_and_vectors | 4 4 1.0s test_create_scalar_parameter_date | 4 4 1.1s test_create_sets_with_relations | 5 5 2.2s test_create_time_series | 2 2 2.7s test_create_vector_with_empty_relations_id | 1 1 1.6s test_create_vector_with_empty_relations_string | 1 1 1.5s test_create_vectors_with_different_sizes_in_same_group | 2 2 0.2s test_create_vectors_with_relations | 5 5 1.9s test_create_with_transaction | 1 1 0.2s test_cross | 23 23 0.6s test_date | 2 2 0.1s test_decade | 6 6 0.1s test_month | 4394 4394 0.4s test_week | 4390 4390 0.3s test_year | 56964 56964 0.5s test_delete_cascade | 10 10 2.1s test_delete_element | 3 3 0.5s test_performance_naive | 0 3.3s 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 4.2s test_read_relations | 12 12 3.1s test_read_time_series_files | 5 5 0.9s test_read_only | 4 4 0.8s test_generate_code_from_date_parameters | 1 1 6.4s test_generate_code_from_parameters_and_vectors | 1 1 1.5s test_generate_code_from_simple_parameters | 1 1 0.1s test_generate_code_from_time_series | 1 1 4.3s test_generate_code_from_vectors_with_relations | 1 1 2.0s test_generate_code_throws_both_path_schema_and_path_migrations | 1 1 0.1s test_generate_code_throws_invalid_output_db_path_directory | 1 1 0.1s test_generate_code_throws_invalid_output_jl_path_directory | 1 1 0.1s test_generate_code_throws_missing_path_schema_and_path_migrations | 1 1 0.1s test_add_time_series_row | 6 6 2.7s test_create_wrong_time_series | 4 4 1.8s test_delete_time_series | 3 3 1.8s test_read_time_series_single | 253 253 2.8s test_time_controller_empty | 1 1 1.8s test_time_controller_filled_then_empty | 19 19 3.3s test_time_controller_read | 108 108 3.1s test_time_controller_read_more_agents | 18 18 1.6s test_time_controller_read_more_agents_2 | 6 6 1.5s test_unordered_time_controller | 1 1 2.3s test_update_time_series | 75 75 4.3s test_update_scalar_parameters | 4 4 0.4s test_update_scalar_relations | 9 9 0.2s test_update_set_parameters | 3 3 1.4s test_update_set_relations | 3 3 0.4s test_update_time_series | 10 10 0.7s test_update_time_series_files | 4 4 0.3s test_update_vector_parameters | 3 3 0.5s test_update_vector_relations | 3 3 0.2s test_update_vector_with_empty_relations_id | 1 1 1.8s test_update_vector_with_empty_relations_string | 1 1 1.5s test_extra_lines_sql_file | 0 0.0s test_invalid_database_foreign_key_actions | 1 1 0.2s test_invalid_database_vector_table_without_vector_index | 1 1 0.0s test_invalid_database_with_duplicated_attributes | 2 2 0.1s test_invalid_database_with_invalid_collection_id | 1 1 0.0s test_invalid_database_without_configuration_table | 1 1 0.0s test_invalid_database_without_label_constraints | 1 1 0.4s 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 280.42s PkgEval succeeded after 337.75s