=== Test case: cets_disco_SUITE:rdbms_backend_db_queries/1 (click for source code)
=== Config value:
[{watchdog,<0.88044.0>},
{preset,"odbc_mssql_mnesia"},
{mim_data_dir,"/home/circleci/project/big_tests/tests/cets_disco_SUITE_data"},
{tc_logfile,"/home/circleci/project/big_tests/ct_report/ct_run.test@ca2b1cd7241c.2024-03-11_11.25.11/big_tests.tests.cets_disco_SUITE.logs/run.2024-03-11_11.42.37/cets_disco_suite.rdbms_backend_db_queries.html"},
{tc_group_properties,[{name,rdbms}]},
{tc_group_path,[[{suite,cets_disco_SUITE}]]},
{data_dir,"/home/circleci/project/big_tests/_build/default/lib/mongoose_tests/ebin/cets_disco_SUITE_data/"},
{priv_dir,"/home/circleci/project/big_tests/ct_report/ct_run.test@ca2b1cd7241c.2024-03-11_11.25.11/big_tests.tests.cets_disco_SUITE.logs/run.2024-03-11_11.42.37/log_private/"}]
=== Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@ca2b1cd7241c.2024-03-11_11.25.11"
=== Started at 2024-03-11 11:42:38
*** User 2024-03-11 11:42:38.284 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>, <<"test1">>, 1, <<>>, 1710157358) = {updated, 1}
*** User 2024-03-11 11:42:38.285 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>, <<"test1">>, 1, <<>>, 1710157358) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__59D9EC25972B8FF1'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (big_test_rdbms_backend_db_queries_b6ea452f48a5d989, test1).[FreeTDS][SQL Server]The statement has been terminated. SQLSTATE IS: 01000", odbc_query => <<"INSERT INTO discovery_nodes (cluster_name, node_name, node_num, address, updated_timestamp) VALUES (?, ?, ?, ?, ?)">>, odbc_params => [{{sql_wlongvarchar, 50}, [<<98,0, 105,0, 103,0, 95,0, 116,0, 101,0, 115,0, 116,0, 95,0, 114,0, 100,0, 98,0, 109,0, 115,0, 95,0,98, 0,97,0, 99,0, 107,0, 101,0, 110,0, 100,0, 95,0, 100,0, 98,0,95, 0,113,0, 117,0, 101,0, 114,0, 105,0, 101,0, 115,0, 95,0,98, 0,54,0, 101,0, 97,0,52, 0,53,0, 50,0, 102,0, 52,0,56, 0,97,0, 53,0, 100,0, 57,0,56, 0,57,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 49,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1710157358">>]}]}}
*** User 2024-03-11 11:42:38.287 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>, <<"test1">>, 2, <<>>, 1710157358) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__59D9EC25972B8FF1'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (big_test_rdbms_backend_db_queries_b6ea452f48a5d989, test1).[FreeTDS][SQL Server]The statement has been terminated. SQLSTATE IS: 01000", odbc_query => <<"INSERT INTO discovery_nodes (cluster_name, node_name, node_num, address, updated_timestamp) VALUES (?, ?, ?, ?, ?)">>, odbc_params => [{{sql_wlongvarchar, 50}, [<<98,0, 105,0, 103,0, 95,0, 116,0, 101,0, 115,0, 116,0, 95,0, 114,0, 100,0, 98,0, 109,0, 115,0, 95,0,98, 0,97,0, 99,0, 107,0, 101,0, 110,0, 100,0, 95,0, 100,0, 98,0,95, 0,113,0, 117,0, 101,0, 114,0, 105,0, 101,0, 115,0, 95,0,98, 0,54,0, 101,0, 97,0,52, 0,53,0, 50,0, 102,0, 52,0,56, 0,97,0, 53,0, 100,0, 57,0,56, 0,57,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 49,0>>]}, {sql_integer, [2]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1710157358">>]}]}}
*** User 2024-03-11 11:42:38.288 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>, <<"test2">>, 1, <<>>, 1710157358) = {error, #{reason => "[FreeTDS][SQL Server]Cannot insert duplicate key row in object 'dbo.discovery_nodes' with unique index 'i_discovery_nodes_node_num'. The duplicate key value is (big_test_rdbms_backend_db_queries_b6ea452f48a5d989, 1).[FreeTDS][SQL Server]The statement has been terminated. SQLSTATE IS: 01000", odbc_query => <<"INSERT INTO discovery_nodes (cluster_name, node_name, node_num, address, updated_timestamp) VALUES (?, ?, ?, ?, ?)">>, odbc_params => [{{sql_wlongvarchar, 50}, [<<98,0, 105,0, 103,0, 95,0, 116,0, 101,0, 115,0, 116,0, 95,0, 114,0, 100,0, 98,0, 109,0, 115,0, 95,0,98, 0,97,0, 99,0, 107,0, 101,0, 110,0, 100,0, 95,0, 100,0, 98,0,95, 0,113,0, 117,0, 101,0, 114,0, 105,0, 101,0, 115,0, 95,0,98, 0,54,0, 101,0, 97,0,52, 0,53,0, 50,0, 102,0, 52,0,56, 0,97,0, 53,0, 100,0, 57,0,56, 0,57,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 50,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1710157358">>]}]}}
*** User 2024-03-11 11:42:38.291 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>, <<"test2">>, 2, <<>>, 1710157358) = {updated, 1}
*** User 2024-03-11 11:42:38.292 ***🔗 select(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>) = {selected, [{<<"test1">>, 1,<<>>, 1710157358}, {<<"test2">>, 2,<<>>, 1710157358}]}
*** User 2024-03-11 11:42:38.294 ***🔗 select(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>, <<"test1">>, <<>>, 1710157458) = {updated, 1}
*** User 2024-03-11 11:42:38.295 ***🔗 select(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>) = {selected, [{<<"test1">>, 1,<<>>, 1710157458}, {<<"test2">>, 2,<<>>, 1710157358}]}
*** User 2024-03-11 11:42:38.297 ***🔗 delete_node_from_db(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>, <<"test1">>) = {updated, 1}
*** User 2024-03-11 11:42:38.298 ***🔗 select(<<"big_test_rdbms_backend_db_queries_b6ea452f48a5d989">>) = {selected, [{<<"test2">>, 2,<<>>, 1710157358}]}
=== Ended at 2024-03-11 11:42:38 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result