设备环境：物理机，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.<anonymous> (/wiz/app/wizserver/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/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 (<anonymous>)
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.<anonymous> (/wiz/app/wizserver/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/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 (<anonymous>)
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-5-29 19:19:13
