我有一个应用程序在 PostgreSQL-12 中存储了测量数据。几个进程通过如下查询写入数据:
INSERT INTO "<measurement>" (<columns>) VALUES (<values>);
但由于某种原因,该"<measurement>"
表没有创建,我得到了如下错误:
ERROR: relation "<measurement>" does not exist at character 13
问题是:大量错误计数会影响数据库性能吗?
我有一个应用程序在 PostgreSQL-12 中存储了测量数据。几个进程通过如下查询写入数据:
INSERT INTO "<measurement>" (<columns>) VALUES (<values>);
但由于某种原因,该"<measurement>"
表没有创建,我得到了如下错误:
ERROR: relation "<measurement>" does not exist at character 13
问题是:大量错误计数会影响数据库性能吗?
当服务器仍在访问从数据库时,我正在进行迁移。我有一个主/从设置。重新启动服务器后,我意识到我无法再连接到 SLAVE。我进入 SLAVE 并尝试重新启动 Postgres,这是它返回的内容:
$ sudo /etc/init.d/postgresql start
* Starting PostgreSQL 9.3 database server
* The PostgreSQL server failed to start. Please check the log output:
2014-12-16 22:14:20 UTC LOG: database system was interrupted while in recovery at log time 2014-12-16 20:57:20 UTC
2014-12-16 22:14:20 UTC HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
2014-12-16 22:14:20 UTC LOG: entering standby mode
2014-12-16 22:14:20 UTC LOG: redo starts at 0/38620168
2014-12-16 22:14:20 UTC LOG: consistent recovery state reached at 0/38680BF0
2014-12-16 22:14:20 UTC LOG: database system is ready to accept read only connections
2014-12-16 22:14:20 UTC PANIC: heap2_redo: unknown op code 32
2014-12-16 22:14:20 UTC CONTEXT: xlog redo UNKNOWN
2014-12-16 22:14:21 UTC LOG: startup process (PID 18357) was terminated by signal 6: Aborted
2014-12-16 22:14:21 UTC LOG: terminating any other active server processes
关于可能导致此问题的原因以及我可以做些什么来解决这个问题的任何想法?我要陷入恐慌之中。
我知道我可以通过运行 sp_cycle_errorlog 轻松循环当前的错误日志,但我想知道 SQL Server 是否会删除旧的/存档的错误日志文件。似乎无法在任何地方找到答案...
SQL Server 错误日志中的日期看起来很奇怪。Sep/29/2014 上午 8:00 和 Sep/29/5:40pm 之间的消息子集显示日期为 Feb/16/2014。你以前见过这个吗?知道为什么日期看起来不同吗?