=== Test case: cets_disco_SUITE:rdbms_backend_db_queries/1 (click for source code) === Config value: [{watchdog,<0.86865.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@647ed17fbff4.2024-02-20_07.34.51/big_tests.tests.cets_disco_SUITE.logs/run.2024-02-20_07.53.23/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@647ed17fbff4.2024-02-20_07.34.51/big_tests.tests.cets_disco_SUITE.logs/run.2024-02-20_07.53.23/log_private/"}] === Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@647ed17fbff4.2024-02-20_07.34.51" === Started at 2024-02-20 07:53:23
*** User 2024-02-20 07:53:23.618 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>, <<"test1">>, 1, <<>>, 1708415603) = {updated, 1}
*** User 2024-02-20 07:53:23.620 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>, <<"test1">>, 1, <<>>, 1708415603) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__59D9EC2553B5913D'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (big_test_rdbms_backend_db_queries_b229120e1d493d52, 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,50,0, 50,0,57, 0,49,0, 50,0,48, 0,101,0, 49,0, 100,0, 52,0,57, 0,51,0, 100,0, 53,0,50, 0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 49,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1708415603">>]}]}}
*** User 2024-02-20 07:53:23.621 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>, <<"test1">>, 2, <<>>, 1708415603) = {error, #{reason => "[FreeTDS][SQL Server]Violation of PRIMARY KEY constraint 'PK__discover__59D9EC2553B5913D'. Cannot insert duplicate key in object 'dbo.discovery_nodes'. The duplicate key value is (big_test_rdbms_backend_db_queries_b229120e1d493d52, 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,50,0, 50,0,57, 0,49,0, 50,0,48, 0,101,0, 49,0, 100,0, 52,0,57, 0,51,0, 100,0, 53,0,50, 0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 49,0>>]}, {sql_integer, [2]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1708415603">>]}]}}
*** User 2024-02-20 07:53:23.622 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>, <<"test2">>, 1, <<>>, 1708415603) = {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_b229120e1d493d52, 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,50,0, 50,0,57, 0,49,0, 50,0,48, 0,101,0, 49,0, 100,0, 52,0,57, 0,51,0, 100,0, 53,0,50, 0>>]}, {{sql_wlongvarchar, 5}, [<<116,0, 101,0, 115,0, 116,0, 50,0>>]}, {sql_integer, [1]}, {{sql_wlongvarchar, 0}, [<<>>]}, {{sql_varchar, 10}, [<<"1708415603">>]}]}}
*** User 2024-02-20 07:53:23.625 ***🔗 insert_new(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>, <<"test2">>, 2, <<>>, 1708415603) = {updated, 1}
*** User 2024-02-20 07:53:23.625 ***🔗 select(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>) = {selected, [{<<"test1">>, 1,<<>>, 1708415603}, {<<"test2">>, 2,<<>>, 1708415603}]}
*** User 2024-02-20 07:53:23.629 ***🔗 select(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>, <<"test1">>, <<>>, 1708415703) = {updated, 1}
*** User 2024-02-20 07:53:23.630 ***🔗 select(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>) = {selected, [{<<"test1">>, 1,<<>>, 1708415703}, {<<"test2">>, 2,<<>>, 1708415603}]}
*** User 2024-02-20 07:53:23.633 ***🔗 delete_node_from_db(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>, <<"test1">>) = {updated, 1}
*** User 2024-02-20 07:53:23.634 ***🔗 select(<<"big_test_rdbms_backend_db_queries_b229120e1d493d52">>) = {selected, [{<<"test2">>, 2,<<>>, 1708415603}]}
=== Ended at 2024-02-20 07:53:23 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result