关于WorkBench6.1-lError Code: 1175.错误

本文介绍了解决Workbench中因安全更新模式导致的错误问题。通过取消勾选特定选项,可以避免在不使用键列进行WHERE限定时出现更新错误。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

报错问题:

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect.

原因:

因为在workbench下的安全模式所引起的错误

解决:

参考:http://www.shootsoft.net/110

但是可能版本不一样所以操作有所不同

在版本6.1中操作如下:

在Edit->Preferences->SQL Queries中

”Safe Updates“,Forbid UPDATEs andDELETEs with no key in WHERE dause or no LIMT dause.Requires a reconnection选项去掉前面的勾

记得要重启才能使用!



[File Watcher (node.js)] Request to start watching: /home/SENSETIME/leisiquan.vendor/.config/Code/User (excludes: <none>, includes: <all>, filter: <none>, correlationId: <none>),/home/SENSETIME/leisiquan.vendor/.config/Code/User/settings.json (excludes: <none>, includes: <all>, filter: <none>, correlationId: <none>) [main 2025-08-01T12:47:02.252Z] [File Watcher (node.js)] ignoring a path for watching who's stat info failed to resolve: /home/SENSETIME/leisiquan.vendor/.config/Code/User/settings.json (error: Error: ENOENT: no such file or directory, stat '/home/SENSETIME/leisiquan.vendor/.config/Code/User/settings.json') [main 2025-08-01T12:47:02.253Z] [File Watcher (node.js)] starting fs.watchFile() on /home/SENSETIME/leisiquan.vendor/.config/Code/User/settings.json (correlationId: undefined) [main 2025-08-01T12:47:02.256Z] Starting VS Code [main 2025-08-01T12:47:02.256Z] from: /usr/share/code/resources/app [main 2025-08-01T12:47:02.256Z] args: { _: [], diff: false, merge: false, add: false, remove: false, goto: false, 'new-window': false, 'reuse-window': false, wait: false, help: false, 'list-extensions': false, 'show-versions': false, 'pre-release': false, 'update-extensions': false, version: false, verbose: true, status: false, 'prof-startup': false, 'no-cached-data': false, 'prof-v8-extensions': false, 'disable-extensions': false, 'disable-lcd-text': false, 'disable-gpu': true, 'disable-chromium-sandbox': false, sandbox: false, telemetry: false, debugRenderer: false, 'enable-smoke-test-driver': false, logExtensionHostCommunication: false, 'skip-release-notes': false, 'skip-welcome': false, 'disable-telemetry': false, 'disable-updates': false, 'use-inmemory-secretstorage': false, 'disable-workspace-trust': false, 'disable-crash-reporter': false, 'crash-reporter-id': '9bc59030-b82d-49d9-9051-898bbb437304', 'skip-add-to-recently-opened': false, 'open-url': false, 'file-write': false, 'file-chmod': false, force: false, 'do-not-sync': false, 'do-not-include-pack-dependencies': false, trace: false, 'trace-memory-infra': false, 'preserve-env': false, 'force-user-env': false, 'force-disable-user-env': false, 'open-devtools': false, 'disable-gpu-sandbox': false, '__enable-file-policy': false, 'enable-coi': false, 'enable-rdp-display-tracking': false, 'disable-layout-restore': false, 'no-proxy-server': false, 'no-sandbox': false, nolazy: false, 'force-renderer-accessibility': false, 'ignore-certificate-errors': false, 'allow-insecure-localhost': false, 'disable-dev-shm-usage': false, 'profile-temp': false, logsPath: '/home/SENSETIME/leisiquan.vendor/.config/Code/logs/20250801T204702' } [main 2025-08-01T12:47:02.258Z] Resolving machine identifier... [main 2025-08-01T12:47:02.262Z] [File Watcher (node.js)] Started watching: '/home/SENSETIME/leisiquan.vendor/.config/Code/User' [49295:0801/204702.266343:WARNING:vaapi_wrapper.cc(1534)] Skipping nVidia device named: nvidia-drm [49295:0801/204702.268231:WARNING:sandbox_linux.cc(420)] InitializeSandbox() called with multiple threads in process gpu-process. [49295:0801/204702.269007:WARNING:viz_main_impl.cc(85)] VizNullHypothesis is disabled (not a warning) [main 2025-08-01T12:47:02.298Z] Resolved machine identifier: 3777bd569b947d43ea914eabe3a61f5de17708a4d53a88839111bf818a20a675 [main 2025-08-01T12:47:02.298Z] Main->SharedProcess#connect [main 2025-08-01T12:47:02.302Z] StorageMainService: creating application storage [main 2025-08-01T12:47:02.306Z] ElectronURLListener: waiting for window to be ready to handle URLs... [main 2025-08-01T12:47:02.306Z] lifecycle (main): phase changed (value: 2) [main 2025-08-01T12:47:02.306Z] windowsManager#open [main 2025-08-01T12:47:02.307Z] windowsManager#open pathsToOpen [ [Object: null prototype] {} ] [main 2025-08-01T12:47:02.307Z] windowsManager#doOpenEmpty { restore: false, remoteAuthority: undefined, filesToOpen: undefined, forceNewWindow: false } [main 2025-08-01T12:47:02.309Z] IPC Object URL: Registered new channel vscode:dc0454f3-919f-4e9a-999c-dc2a526cc059. [main 2025-08-01T12:47:02.309Z] window#validateWindowState: validating window state on 1 display(s) { width: 1200, height: 800, mode: 1, x: 360, y: 140, hasDefaultState: true } [main 2025-08-01T12:47:02.309Z] window#validateWindowState: single monitor working area { x: 72, y: 27, width: 1848, height: 1053 } [main 2025-08-01T12:47:02.309Z] window#ctor: using window state { width: 1200, height: 800, mode: 1, x: 360, y: 140, hasDefaultState: true } [main 2025-08-01T12:47:02.356Z] window#load: attempt to load window (id: 1) [main 2025-08-01T12:47:02.364Z] windowsManager#open used window count 1 (workspacesToOpen: 0, foldersToOpen: 0, emptyToRestore: 0, maybeOpenEmptyWindow: true) [main 2025-08-01T12:47:02.364Z] lifecycle (main): phase changed (value: 3) [main 2025-08-01T12:47:02.364Z] resolveShellEnv(): skipped (VSCODE_CLI is set) [main 2025-08-01T12:47:02.365Z] update#setState idle [main 2025-08-01T12:47:02.407Z] resolveShellEnv(): skipped (VSCODE_CLI is set) [49253:0801/204702.419375:INFO:CONSOLE(3)] "[uncaught exception]: TypeError: Failed to fetch dynamically imported module: vscode-file://vscode-app/usr/share/code/resources/app/out/vs/workbench/workbench.desktop.main.js", source: vscode-file://vscode-app/usr/share/code/resources/app/out/vs/code/electron-browser/workbench/workbench.js (3) [49253:0801/204702.419453:INFO:CONSOLE(3)] "TypeError: Failed to fetch dynamically imported module: vscode-file://vscode-app/usr/share/code/resources/app/out/vs/workbench/workbench.desktop.main.js", source: vscode-file://vscode-app/usr/share/code/resources/app/out/vs/code/electron-browser/workbench/workbench.js (3) [49253:0801/204702.419556:INFO:CONSOLE(4)] "Uncaught (in promise) TypeError: Failed to fetch dynamically imported module: vscode-file://vscode-app/usr/share/code/resources/app/out/vs/workbench/workbench.desktop.main.js", source: vscode-file://vscode-app/usr/share/code/resources/app/out/vs/code/electron-browser/workbench/workbench.js (4) [49253:0801/204702.445759:ERROR:nss_util.cc(227)] Error initializing NSS with a persistent database (sql:/home/SENSETIME/leisiquan.vendor/.pki/nssdb): libsoftokn3.so: 无法打开共享对象文件: 没有那个文件或目录 [49253:0801/204702.445798:ERROR:nss_util.cc(112)] Error initializing NSS without a persistent database: NSS error code: -5925 [49253:0801/204702.445805:FATAL:nss_util.cc(114)] nss_error=-5925, os_error=0 [0801/204702.482445:ERROR:directory_reader_posix.cc(43)] opendir /home/SENSETIME/leisiquan.vendor/.config/Code/Crashpad/attachments/63a4640e-035f-4f73-ac78-2ede9b09a5b9: No such file or directory (2) [49299:0801/204708.716049:ERROR:ssl_client_socket_impl.cc(877)] handshake failed; returned -1, SSL error code 1, net_error -3
最新发布
08-02
<think>我们正在处理VS Code启动时出现的两个主要错误1. "Failed to fetch dynamically imported module"(动态导入模块加载失败) 2. "NSS error -5925"(NSS初始化错误) 根据之前的上下文,我们知道NSS(Network Security Services)错误-5925可能与系统库的损坏或缺失有关,特别是与网络安全服务相关的库。而动态导入模块加载失败可能与网络问题、缓存损坏或模块路径问题有关。 解决方案步骤: 步骤1:修复NSS错误-5925 这个错误通常是由于系统中NSS库的问题引起的。我们可以尝试重新安装NSS相关的库。 在终端中执行: ```bash sudo apt update sudo apt install --reinstall libnss3 libnss3-dev ``` 步骤2:解决动态导入模块加载失败 这个错误可能是由于VS Code在加载某些模块时出现问题,可能是缓存损坏或网络问题(如果是远程模块)。我们可以尝试清除VS Code的缓存。 清除VS Code的缓存目录: ```bash rm -rf ~/.config/Code/Cache rm -rf ~/.config/Code/CachedData ``` 步骤3:检查依赖项 确保系统依赖项完整,特别是与图形和网络相关的库。 ```bash sudo apt install -f sudo apt install libasound2 libatk1.0-0 libcairo2 libcups2 libexpat1 libfontconfig1 libfreetype6 libgtk-3-0 libpango-1.0-0 libx11-xcb1 libxcomposite1 libxcursor1 libxdamage1 libxext6 libxfixes3 libxi6 libxrandr2 libxrender1 libxss1 libxtst6 ``` 步骤4:重置VS Code配置(如果上述步骤无效) 注意:这将删除你的设置和扩展,请先备份重要数据(如设置文件settings.json和扩展列表)。 备份扩展列表: ```bash code --list-extensions > extensions.txt ``` 然后删除配置文件夹: ```bash rm -rf ~/.config/Code ``` 然后重新启动VS Code,它会重新生成配置。之后可以重新安装扩展(使用`cat extensions.txt | xargs -L 1 code --install-extension`)。 步骤5:重新安装VS Code 如果以上步骤都不行,尝试完全卸载VS Code并重新安装。 卸载: ```bash sudo apt purge code rm -rf ~/.config/Code rm -rf ~/.vscode ``` 然后重新安装,可以从微软官网下载最新的.deb包: ```bash wget -O vscode.deb 'https://code.visualstudio.com/sha/download?build=stable&os=linux-deb-x64' sudo dpkg -i vscode.deb ``` 步骤6:检查系统日志 如果问题仍然存在,检查系统日志以获取更多信息: ```bash dmesg | grep -i error journalctl -xe ``` 同时,运行VS Code时添加`--verbose`标志,将日志输出到文件: ```bash code --verbose > vscode_log.txt 2>&1 ``` 然后分析日志文件,查找错误原因。 生成相关问题: §§相关问题§§ 1. 如何备份和恢复VS Code的扩展和设置? 2. 在Linux上,VS Code启动时出现NSS错误还有哪些其他解决方法? 3. 动态导入模块加载失败是否与特定的VS Code扩展有关? 4. 如何通过日志诊断VS Code的启动问题?</think>### VS Code 启动错误解决方案:动态模块加载失败 & NSS 错误 -5925 您遇到的错误主要涉及两个关键问题: 1. **动态导入模块加载失败**(Failed to fetch dynamically imported module) 2. **NSS 初始化错误**(NSS error -5925) 以下是系统性的解决方案: --- ### 一、解决 NSS 错误 -5925(网络安全服务错误) 此错误通常由 **NSS 库损坏/缺失**或**证书配置问题**引起[^1]。 #### 步骤 1:修复 NSS 库 ```bash # 重新安装核心安全库 sudo apt update sudo apt install --reinstall libnss3 libnss3-dev libnss3-tools ``` #### 步骤 2:重建证书数据库 ```bash # 删除损坏的证书数据库 rm -r ~/.pki/nssdb # 重建新数据库 mkdir -p ~/.pki/nssdb certutil -N -d sql:~/.pki/nssdb --empty-password ``` #### 步骤 3:更新根证书 ```bash # 安装根证书更新工具 sudo apt install ca-certificates # 强制更新证书 sudo update-ca-certificates --fresh ``` --- ### 二、解决动态模块加载失败 此错误通常由 **VS Code 核心文件损坏**或**扩展冲突**导致[^2]。 #### 步骤 1:修复 VS Code 核心文件 ```bash # 清除缓存目录 rm -rf ~/.config/Code/Cache/* rm -rf ~/.config/Code/CachedData/* # 重新安装 VS Code 核心模块 sudo apt reinstall --fix-broken code ``` #### 步骤 2:禁用问题扩展 ```bash # 安全模式启动(禁用所有扩展) code --disable-extensions # 若正常启动,逐个启用扩展排查 code --disable-extension=扩展ID ``` #### 步骤 3:重置加载器配置 ```bash # 编辑加载器配置 sudo nano /usr/share/code/resources/app/out/vs/loader.js # 在文件开头添加(修复动态导入) process.env.ELECTRON_DISABLE_SECURITY_WARNINGS = true; ``` --- ### 三、综合验证 1. **生成诊断日志**: ```bash code --verbose --disable-gpu > vscode_debug.log 2>&1 ``` 检查日志中的: - `ERR Failed to fetch dynamically imported module` 相关堆栈 - `NSS error -5925` 出现位置 2. **测试网络连接**: ```bash # 检查 VS Code 服务可达性 curl -v https://update.code.visualstudio.com # 测试证书验证 openssl s_client -connect update.code.visualstudio.com:443 ``` --- ### 四、终极解决方案 若上述步骤无效,执行彻底重置: ```bash # 完全卸载 sudo apt purge code rm -rf ~/.config/Code ~/.vscode # 全新安装(指定稳定版本) wget https://update.code.visualstudio.com/latest/linux-deb-x64/stable -O vscode.deb sudo dpkg -i vscode.deb # 修复依赖 sudo apt install -f ``` ---
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值