=== Test case: cets_disco_SUITE:rdbms_backend_db_queries/1 (click for source code)
=== Config value:
[{watchdog,<0.105687.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@6b612e74bd51.2024-04-16_10.12.39/big_tests.tests.cets_disco_SUITE.logs/run.2024-04-16_10.31.01/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@6b612e74bd51.2024-04-16_10.12.39/big_tests.tests.cets_disco_SUITE.logs/run.2024-04-16_10.31.01/log_private/"}]
=== Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@6b612e74bd51.2024-04-16_10.12.39"
=== Started at 2024-04-16 10:31:02
*** User 2024-04-16 10:31:02.043 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_c96099aa45aa9400">>, <<"testA">>, 1, <<>>, 1713263462) = {updated, 1}
*** User 2024-04-16 10:31:02.044 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_c96099aa45aa9400">>, <<"testA">>, 1, <<>>, 1713263462) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__86404B15504E9A25'. 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,99, 0,57,0, 54,0,48, 0,57,0, 57,0,97, 0,97,0, 52,0,53, 0,97,0, 97,0,57, 0,52,0, 48,0,48, 0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 65,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1713263462">>]}]}}
*** User 2024-04-16 10:31:02.044 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_c96099aa45aa9400">>, <<"testA">>, 2, <<>>, 1713263462) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__86404B15504E9A25'. 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,99, 0,57,0, 54,0,48, 0,57,0, 57,0,97, 0,97,0, 52,0,53, 0,97,0, 97,0,57, 0,52,0, 48,0,48, 0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 65,0>>]}, {sql_integer, [2]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1713263462">>]}]}}
*** User 2024-04-16 10:31:02.046 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_c96099aa45aa9400">>, <<"testB">>, 1, <<>>, 1713263462) = {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_c96099aa45aa9400, 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,99, 0,57,0, 54,0,48, 0,57,0, 57,0,97, 0,97,0, 52,0,53, 0,97,0, 97,0,57, 0,52,0, 48,0,48, 0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 66,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1713263462">>]}]}}
*** User 2024-04-16 10:31:02.047 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_c96099aa45aa9400">>, <<"testB">>, 2, <<>>, 1713263462) = {updated, 1}
*** User 2024-04-16 10:31:02.048 ***🔗 insert_new(<<"my-cluster">>, <<"testA">>, 1, <<>>, 1713263462) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__86404B15504E9A25'. 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}, [<<"1713263462">>]}]}}
*** User 2024-04-16 10:31:02.048 ***🔗 select(<<"big_test_rdbms_backend_db_queries_c96099aa45aa9400">>) = {selected, [{<<"testA">>, 1,<<>>, 1713263462}, {<<"testB">>, 2,<<>>, 1713263462}]}
*** User 2024-04-16 10:31:02.049 ***🔗 select(<<"testA">>, <<>>, 1713263562) = {updated,1}
*** User 2024-04-16 10:31:02.050 ***🔗 select(<<"big_test_rdbms_backend_db_queries_c96099aa45aa9400">>) = {selected, [{<<"testA">>, 1,<<>>, 1713263562}, {<<"testB">>, 2,<<>>, 1713263462}]}
*** User 2024-04-16 10:31:02.051 ***🔗 delete_node_from_db(<<"testA">>) = {updated,1}
*** User 2024-04-16 10:31:02.051 ***🔗 select(<<"big_test_rdbms_backend_db_queries_c96099aa45aa9400">>) = {selected, [{<<"testB">>, 2,<<>>, 1713263462}]}
=== Ended at 2024-04-16 10:31:02 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result