=== Test case: cets_disco_SUITE:rdbms_backend_db_queries/1 (click for source code) === Config value: [{watchdog,<0.87027.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@c558b6ad2bd8.2024-02-26_15.40.27/big_tests.tests.cets_disco_SUITE.logs/run.2024-02-26_15.57.38/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@c558b6ad2bd8.2024-02-26_15.40.27/big_tests.tests.cets_disco_SUITE.logs/run.2024-02-26_15.57.38/log_private/"}] === Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@c558b6ad2bd8.2024-02-26_15.40.27" === Started at 2024-02-26 15:57:38
*** User 2024-02-26 15:57:38.573 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>, <<"test1">>, 1, <<>>, 1708963058) = {updated, 1}
*** User 2024-02-26 15:57:38.575 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>, <<"test1">>, 1, <<>>, 1708963058) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__59D9EC25C2D84832'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (big_test_rdbms_backend_db_queries_521f96fd182e9b2f, 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,53, 0,50,0, 49,0, 102,0, 57,0,54, 0,102,0, 100,0, 49,0,56, 0,50,0, 101,0, 57,0,98, 0,50,0, 102,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 49,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1708963058">>]}]}}
*** User 2024-02-26 15:57:38.576 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>, <<"test1">>, 2, <<>>, 1708963058) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__59D9EC25C2D84832'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (big_test_rdbms_backend_db_queries_521f96fd182e9b2f, 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,53, 0,50,0, 49,0, 102,0, 57,0,54, 0,102,0, 100,0, 49,0,56, 0,50,0, 101,0, 57,0,98, 0,50,0, 102,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 49,0>>]}, {sql_integer, [2]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1708963058">>]}]}}
*** User 2024-02-26 15:57:38.577 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>, <<"test2">>, 1, <<>>, 1708963058) = {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_521f96fd182e9b2f, 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,53, 0,50,0, 49,0, 102,0, 57,0,54, 0,102,0, 100,0, 49,0,56, 0,50,0, 101,0, 57,0,98, 0,50,0, 102,0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 50,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1708963058">>]}]}}
*** User 2024-02-26 15:57:38.578 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>, <<"test2">>, 2, <<>>, 1708963058) = {updated, 1}
*** User 2024-02-26 15:57:38.578 ***🔗 select(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>) = {selected, [{<<"test1">>, 1,<<>>, 1708963058}, {<<"test2">>, 2,<<>>, 1708963058}]}
*** User 2024-02-26 15:57:38.579 ***🔗 select(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>, <<"test1">>, <<>>, 1708963158) = {updated, 1}
*** User 2024-02-26 15:57:38.580 ***🔗 select(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>) = {selected, [{<<"test1">>, 1,<<>>, 1708963158}, {<<"test2">>, 2,<<>>, 1708963058}]}
*** User 2024-02-26 15:57:38.582 ***🔗 delete_node_from_db(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>, <<"test1">>) = {updated, 1}
*** User 2024-02-26 15:57:38.582 ***🔗 select(<<"big_test_rdbms_backend_db_queries_521f96fd182e9b2f">>) = {selected, [{<<"test2">>, 2,<<>>, 1708963058}]}
=== Ended at 2024-02-26 15:57:38 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result