我上一次使用dbt是在几个月前。回到它,我不得不从0.21.1版本更新到1.1.0版本,以匹配我团队的项目。我已经运行了dbt-clean,然后dbt-deps总是返回以下错误:该进程无法访问该文件,因为它正被另一个进程使用:"dbt_packages\dbt-expectations-0.5.1\integration_tests">
在它出错之后,我看到了两个包:dbt_expects&dbt-expectations-0.5.1-我不确定后一个包是关于什么的,因为它不存在于我队友的机器上。
这些都是我的包,匹配我的队友:
- 包:calogica/dbt_date版本:0.5.1
- 包:dbt-labs/dbt_utils版本:0.8.0
- 软件包:dbt-labs/codegen版本:0.5.0
- 包:calogica/dbt_expects版本:0.5.1
在执行dbt-deps&我已经重新启动以确保没有任何问题。我在日志中看不到任何有用的东西:
14:28:05.0062468[debug][MainThread]:发送事件:{'类别:"dbt"、"action":"package"、"label":'5cc0ad0f-792a-49a6-8a6-f59ff8c3e642','property_':'install','context':[<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x000002CDFB6D1EB0>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x000002CDFB6D14C0>]}14:28:05.063465[info][MainThread]:安装calogica/dbt_expects 14:28:06.961306[debug][MainThread]:正在发送事件:{"类别":"dbt","操作":"调用","标签":"end","context":[<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x000002CDFB689550>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x000002CDFB6D14C0>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x000002CDFB702EE0>]}
========================2022-05-23 14:28:10.424049|2a7e240e-1707-451-8966-58797e038d3a==============================14:28:10.424049[info][MainThread]:使用dbt=1.1.0运行14:28:10.425046[debug][MainThread]:使用参数运行dbt{'write_json':True,'use_colors':True,'printer_width':80,"version_check":True,"partial_parse":False,"static_parser":True,"profiles_dir":"C:\Users\jasonmckenzie\.dbt","send_anonymous_usage_stats":True,"event_buffer_size":100000,"quiet":False,"no_print":False、"resource_types":[]、"output":'选择器','间接选择':'渴望','哪个':'列表'}14:28:10.425046[debug][MainThread]:跟踪:跟踪14:28:10.435018〔debug〕〔MainThread〕:发送事件:{'类别:"dbt"、"action":"invocation"、"label":"start"、"context":[<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000254727F3D90>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000254727F32E0>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000254727F37C0>]}14:28:10.462945〔debug〕〔MainThread〕:发送事件:{"类别":"dbt","操作":"调用","标签":"结束",'context':[<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000254727D1820>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000254727D1490>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000254727D19D0>]}
==========================2022-05-23 14:28:10.825973|8d0ab879-6b59-4473-845a-cde9dd23352b==============================14:28:10.825973[info][MainThread]:使用dbt=1.1.0运行14:28:10.826970[debug][MainThread]:使用参数运行dbt{'write_json':True,'use_colors':True,'printer_width':80,"version_check":True,"partial_parse":False,"static_parser":True,"profiles_dir":"C:\Users\jasonmckenzie\.dbt","send_anonymous_usage_stats":True,"event_buffer_size":100000,"quiet":False,"no_print":False、"resource_types":[]、"output":'选择器','间接选择':'渴望','哪个':'列表'}14:28:10.826970[debug][MainThread]:跟踪:跟踪14:28:10.835946〔debug〕〔MainThread〕:发送事件:{"类别":"dbt"、"action":"invocation"、"label":"start"、"context":[<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000170D052F100>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000170D052FEB0>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000170D052FC40>]}14:28:10.892797[debug][MainThread]:发送事件:{"类别":"dbt","操作":"调用","标签":"结束",'context':[<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000170D04EC640>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000170D04ECD90>,<snowprover_tracker.self-descripting_json.self-DescriptingJson对象位于0x00000170D04EC4F0>]}
我在尝试安装tsql_utils时遇到了这个错误。我通过在版本周围添加引号来"修复"它。
packages:
- package: dbt-labs/dbt_utils
version: "0.9.2"
- package: dbt-msft/tsql_utils
version: "0.8.1"
起初,我没有引用它们。