Package evaluation to test PSRDatabase on Julia 1.11.7 (58327cce5e*) started at 2025-10-28T20:07:54.376 ################################################################################ # Set-up # Installing PkgEval dependencies (TestEnv)... Set-up completed after 7.9s ################################################################################ # Installation # Installing PSRDatabase... Resolving package versions... Installed PSRDatabase ─ v0.2.0 Updating `~/.julia/environments/v1.11/Project.toml` [d9b62651] + PSRDatabase v0.2.0 Updating `~/.julia/environments/v1.11/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.1 [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.0 [69de0a69] + Parsers v2.8.3 [2dfb63ee] + PooledArrays v1.4.3 ⌅ [aea7be01] + PrecompileTools v1.2.1 [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 [9fa8497b] + Future v1.11.0 [b77e0a4c] + InteractiveUtils v1.11.0 [8f399da3] + Libdl v1.11.0 [37e2e46d] + LinearAlgebra v1.11.0 [d6f4376e] + Markdown v1.11.0 [de0858da] + Printf v1.11.0 [3fa0cd96] + REPL v1.11.0 [9a3f8284] + Random v1.11.0 [ea8e919c] + SHA v0.7.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.1.1+0 [4536629a] + OpenBLAS_jll v0.3.27+1 [83775a58] + Zlib_jll v1.2.13+1 [8e850b90] + libblastrampoline_jll v5.11.0+0 Info Packages marked with ⌅ have new versions available but compatibility constraints restrict them from upgrading. To see why use `status --outdated -m` Installation completed after 7.85s ################################################################################ # Precompilation # Precompiling PkgEval dependencies... Precompiling package dependencies... Precompilation completed after 24.92s ################################################################################ # Testing # Testing PSRDatabase Status `/tmp/jl_N6fv3G/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.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_N6fv3G/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.1 [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.0 [69de0a69] Parsers v2.8.3 [2dfb63ee] PooledArrays v1.4.3 ⌅ [aea7be01] PrecompileTools v1.2.1 [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.6.0 [7b1f6079] FileWatching v1.11.0 [9fa8497b] Future v1.11.0 [b77e0a4c] InteractiveUtils v1.11.0 [b27032c2] LibCURL v0.6.4 [76f85450] LibGit2 v1.11.0 [8f399da3] Libdl v1.11.0 [37e2e46d] LinearAlgebra v1.11.0 [56ddb016] Logging v1.11.0 [d6f4376e] Markdown v1.11.0 [ca575930] NetworkOptions v1.2.0 [44cfe95a] Pkg v1.11.0 [de0858da] Printf v1.11.0 [3fa0cd96] REPL v1.11.0 [9a3f8284] Random v1.11.0 [ea8e919c] SHA v0.7.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.1.1+0 [deac9b47] LibCURL_jll v8.6.0+0 [e37daf67] LibGit2_jll v1.7.2+0 [29816b5a] LibSSH2_jll v1.11.0+1 [c8ffd9c3] MbedTLS_jll v2.28.6+0 [14a3606d] MozillaCACerts_jll v2023.12.12 [4536629a] OpenBLAS_jll v0.3.27+1 [83775a58] Zlib_jll v1.2.13+1 [8e850b90] libblastrampoline_jll v5.11.0+0 [8e850ede] nghttp2_jll v1.59.0+0 [3f19e933] p7zip_jll v17.4.0+2 Info Packages marked with ⌅ have new versions available but compatibility constraints restrict them from upgrading. Testing Running tests... ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/migrations.jl:119 ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/migrations.jl:119 ┌ Warning: Database file does not exist. Not creating a backup. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/migrations.jl:119 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Configuration" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Configuration" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Product" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Product" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Process" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Plant" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 Starting perfromance reports Adding one by one Time to create 100 parameters => 1.129842258 Time to create 100 vectors => 7.039493066 Adding one by one within a transaction Time to create 100 parameters => 0.00409062 Time to create 100 vectors => 0.022961265 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/create.jl:351 ┌ Error: Error creating element in collection "Resource" └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/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/XstLO/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/XstLO/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/XstLO/src/validate.jl:122 ┌ Error: Duplicated attribute some_type in collection Resource └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/collection.jl:633 ┌ Error: Table Resource has a nullable "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/validate.jl:71 ┌ Error: Table Plant has a non-unique "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/validate.jl:67 ┌ Error: Table Plant has a nullable "label" column. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/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/XstLO/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/XstLO/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/XstLO/src/validate.jl:150 ┌ Error: Table Process_set_someset is a set table but does not have any unique constraints. └ @ PSRDatabase ~/.julia/packages/PSRDatabase/XstLO/src/validate.jl:141 Test Summary: | Pass Total Time test set | 670 670 5m24.3s test_backups | 3 3 28.1s test_applying_migrations_from_a_certain_point | 2 2 3.1s test_chaining_migrations | 1 1 0.0s test_create_database_from_migrations | 1 1 0.3s test_create_table_migration | 1 1 0.0s test_foreign_keys | 0 5.8s test_invalid_migrations | 1 1 0.3s 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.1s test_create_migration_with_existing_name | 1 1 0.2s Aqua | 10 10 2m50.5s test_create_empty_parameters | 2 2 0.2s test_create_parameters | 3 3 1.1s test_create_parameters_and_vectors | 4 4 9.2s test_create_scalar_parameter_date | 4 4 2.5s test_create_sets_with_relations | 5 5 5.2s test_create_time_series | 2 2 5.1s test_create_vector_with_empty_relations_id | 1 1 1.3s test_create_vector_with_empty_relations_string | 1 1 1.2s test_create_vectors_with_different_sizes_in_same_group | 2 2 0.3s test_create_vectors_with_relations | 5 5 1.7s test_create_with_transaction | 1 1 0.5s test_delete_cascade | 10 10 4.0s test_delete_element | 3 3 1.1s test_performance_naive | 0 8.5s test_performance_with_transactions | 0 0.4s test_no_user_version_database | 1 1 0.0s test_valid_pragmas_database | 0 0.0s test_read_parameters | 31 31 7.8s test_read_relations | 12 12 4.3s test_read_time_series_files | 5 5 1.7s test_read_only | 4 4 0.2s test_add_time_series_row | 6 6 2.8s test_create_wrong_time_series | 4 4 1.6s test_delete_time_series | 3 3 1.4s test_read_time_series_single | 253 253 5.4s test_time_controller_empty | 1 1 1.6s test_time_controller_filled_then_empty | 19 19 4.8s test_time_controller_read | 108 108 3.2s test_time_controller_read_more_agents | 18 18 1.3s test_time_controller_read_more_agents_2 | 6 6 1.1s test_update_time_series | 75 75 3.4s test_update_scalar_parameters | 4 4 0.4s test_update_scalar_relations | 9 9 0.8s test_update_set_parameters | 3 3 1.9s test_update_set_relations | 3 3 0.4s test_update_time_series | 10 10 1.5s test_update_time_series_files | 4 4 0.4s test_update_vector_parameters | 3 3 1.6s test_update_vector_relations | 3 3 0.5s test_update_vector_with_empty_relations_id | 1 1 1.7s test_update_vector_with_empty_relations_string | 1 1 1.1s test_extra_lines_sql_file | 0 0.0s test_invalid_database_foreign_key_actions | 1 1 0.1s test_invalid_database_vector_table_without_vector_index | 1 1 0.1s test_invalid_database_with_duplicated_attributes | 2 2 0.3s 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.1s test_invalid_foreign_key_has_not_null_constraint | 1 1 0.1s 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.1s test_valid_database | 1 1 0.1s Testing PSRDatabase tests passed Testing completed after 315.97s PkgEval succeeded after 414.41s