设备环境：物理机，fnOS 0.9.8
BUG现象：安装应用中心的为知笔记无法正常使用，会报错，日志如下
出现频率：必现
-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_bb` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_bc` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_bd` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_be` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_bf` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c0` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c1` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c2` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c3` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c4` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c5` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c6` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c7` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c8` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_c9` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_ca` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_cb` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_cc` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_cd` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_ce` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_cf` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d0` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d1` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d2` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d3` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d4` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d5` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d6` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d7` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d8` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_d9` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-----------------CREATE TABLE IF NOT EXISTS `wiz_kv_da` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`section` varchar(255) NOT NULL DEFAULT '',`name` varchar(255) NOT NULL DEFAULT '',`value` mediumtext NOT NULL,`ts` bigint(20) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `KEY_INDEX` (`section`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;Error: ER_NO_SUCH_TABLE: Table 'wizkv.wiz_kv_da' doesn't exist at Query._packetToError (/wiz/app/wizserver/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14) at Query.ErrorPacket (/wiz/app/wizserver/node_modules/mysql/lib/protocol/sequences/Query.js:79:18) at Protocol._parsePacket (/wiz/app/wizserver/node_modules/mysql/lib/protocol/Protocol.js:291:23) at Parser._parsePacket (/wiz/app/wizserver/node_modules/mysql/lib/protocol/Parser.js:433:10) at Parser.write (/wiz/app/wizserver/node_modules/mysql/lib/protocol/Parser.js:43:10) at Protocol.write (/wiz/app/wizserver/node_modules/mysql/lib/protocol/Protocol.js:38:16) at Socket. (/wiz/app/wizserver/node_modules/mysql/lib/Connection.js:88:28) at Socket. (/wiz/app/wizserver/node_modules/mysql/lib/Connection.js:526:10) at Socket.emit (events.js:375:28) at addChunk (internal/streams/readable.js:290:12) -------------------- at Pool.query (/wiz/app/wizserver/node_modules/mysql/lib/Pool.js:199:23) at /wiz/app/wizserver/upgrade_db.js:28:10 at new Promise () at executeSql (/wiz/app/wizserver/upgrade_db.js:27:10) at executeCommand (/wiz/app/wizserver/upgrade_db.js:44:11) at processSqlFile (/wiz/app/wizserver/upgrade_db.js:109:13) at processTicksAndRejections (internal/process/task_queues.js:95:5) at async doUpgrade (/wiz/app/wizserver/upgrade_db.js:270:5) { code: 'ER_NO_SUCH_TABLE', errno: 1146, sqlMessage: "Table 'wizkv.wiz_kv_da' doesn't exist", sqlState: '42S02', index: 0, sql: '\n' + '\n' + '\n' + 'CREATE TABLE IF NOT EXISTS `wiz_kv_da` (\n' + '`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n' + "`section` varchar(255) NOT NULL DEFAULT '',\n" + "`name` varchar(255) NOT NULL DEFAULT '',\n" + '`value` mediumtext NOT NULL,\n' + '`ts` bigint(20) NOT NULL,\n' + 'PRIMARY KEY (`id`),\n' + 'UNIQUE KEY `KEY_INDEX` (`section`,`name`)\n' + ') ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;\n'}(node:98) UnhandledPromiseRejectionWarning: Error: ER_NO_SUCH_TABLE: Table 'wizkv.wiz_kv_da' doesn't exist at Query._packetToError (/wiz/app/wizserver/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14) at Query.ErrorPacket (/wiz/app/wizserver/node_modules/mysql/lib/protocol/sequences/Query.js:79:18) at Protocol._parsePacket (/wiz/app/wizserver/node_modules/mysql/lib/protocol/Protocol.js:291:23) at Parser._parsePacket (/wiz/app/wizserver/node_modules/mysql/lib/protocol/Parser.js:433:10) at Parser.write (/wiz/app/wizserver/node_modules/mysql/lib/protocol/Parser.js:43:10) at Protocol.write (/wiz/app/wizserver/node_modules/mysql/lib/protocol/Protocol.js:38:16) at Socket. (/wiz/app/wizserver/node_modules/mysql/lib/Connection.js:88:28) at Socket. (/wiz/app/wizserver/node_modules/mysql/lib/Connection.js:526:10) at Socket.emit (events.js:375:28) at addChunk (internal/streams/readable.js:290:12) -------------------- at Pool.query (/wiz/app/wizserver/node_modules/mysql/lib/Pool.js:199:23) at /wiz/app/wizserver/upgrade_db.js:28:10 at new Promise () at executeSql (/wiz/app/wizserver/upgrade_db.js:27:10) at executeCommand (/wiz/app/wizserver/upgrade_db.js:44:11) at processSqlFile (/wiz/app/wizserver/upgrade_db.js:109:13) at processTicksAndRejections (internal/process/task_queues.js:95:5) at async doUpgrade (/wiz/app/wizserver/upgrade_db.js:270:5)(Use `node --trace-warnings ...` to show where the warning was created)(node:98) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 1)(node:98) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
发表于 2025-10-15 01:49:23
