=== Test case: cets_disco_SUITE:rdbms_backend_db_queries/1 (click for source code)
=== Config value:
[{watchdog,<0.106035.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@1ed7c4837c10.2024-04-24_13.09.52/big_tests.tests.cets_disco_SUITE.logs/run.2024-04-24_14.03.29/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@1ed7c4837c10.2024-04-24_13.09.52/big_tests.tests.cets_disco_SUITE.logs/run.2024-04-24_14.03.29/log_private/"}]
=== Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@1ed7c4837c10.2024-04-24_13.09.52"
=== Started at 2024-04-24 14:03:30
*** User 2024-04-24 14:03:30.077 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_bc802ac5d79a89f3">>, <<"testA">>, 1, <<>>, 1713967410) = {updated, 1}
*** User 2024-04-24 14:03:30.086 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_bc802ac5d79a89f3">>, <<"testA">>, 1, <<>>, 1713967410) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__86404B15A25A172B'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (testA).[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,99,0, 56,0,48, 0,50,0, 97,0,99, 0,53,0, 100,0, 55,0,57, 0,97,0, 56,0,57, 0,102,0, 51,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 65,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1713967410">>]}]}}
*** User 2024-04-24 14:03:30.087 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_bc802ac5d79a89f3">>, <<"testA">>, 2, <<>>, 1713967410) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__86404B15A25A172B'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (testA).[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,99,0, 56,0,48, 0,50,0, 97,0,99, 0,53,0, 100,0, 55,0,57, 0,97,0, 56,0,57, 0,102,0, 51,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 65,0>>]}, {sql_integer, [2]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1713967410">>]}]}}
*** User 2024-04-24 14:03:30.087 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_bc802ac5d79a89f3">>, <<"testB">>, 1, <<>>, 1713967410) = {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_bc802ac5d79a89f3, 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,99,0, 56,0,48, 0,50,0, 97,0,99, 0,53,0, 100,0, 55,0,57, 0,97,0, 56,0,57, 0,102,0, 51,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 66,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1713967410">>]}]}}
*** User 2024-04-24 14:03:30.089 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_bc802ac5d79a89f3">>, <<"testB">>, 2, <<>>, 1713967410) = {updated, 1}
*** User 2024-04-24 14:03:30.090 ***🔗 insert_new(<<"my-cluster">>, <<"testA">>, 1, <<>>, 1713967410) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__86404B15A25A172B'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (testA).[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, 10}, [<<109,0, 121,0, 45,0,99, 0,108,0, 117,0, 115,0, 116,0, 101,0, 114,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 65,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1713967410">>]}]}}
*** User 2024-04-24 14:03:30.090 ***🔗 select(<<"big_test_rdbms_backend_db_queries_bc802ac5d79a89f3">>) = {selected, [{<<"testA">>, 1,<<>>, 1713967410}, {<<"testB">>, 2,<<>>, 1713967410}]}
*** User 2024-04-24 14:03:30.091 ***🔗 select(<<"testA">>, <<>>, 1713967510) = {updated,1}
*** User 2024-04-24 14:03:30.092 ***🔗 select(<<"big_test_rdbms_backend_db_queries_bc802ac5d79a89f3">>) = {selected, [{<<"testA">>, 1,<<>>, 1713967510}, {<<"testB">>, 2,<<>>, 1713967410}]}
*** User 2024-04-24 14:03:30.093 ***🔗 delete_node_from_db(<<"testA">>) = {updated,1}
*** User 2024-04-24 14:03:30.093 ***🔗 select(<<"big_test_rdbms_backend_db_queries_bc802ac5d79a89f3">>) = {selected, [{<<"testB">>, 2,<<>>, 1713967410}]}
=== Ended at 2024-04-24 14:03:30 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result