以下为报错
option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-07-28 20:21:16 7056 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-28 20:21:16 7056 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-28 20:21:16 7056 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-07-28 20:21:16 7056 [Note] InnoDB: Memory barrier is not used
2015-07-28 20:21:16 7056 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-28 20:21:16 7056 [Note] InnoDB: Not using CPU crc32 instructions
2015-07-28 20:21:16 7056 [Note] InnoDB: Initializing buffer pool, size = 755.0M
2015-07-28 20:21:16 7056 [Note] InnoDB: Completed initialization of buffer pool
2015-07-28 20:21:16 7056 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-28 20:21:16 7056 [Note] InnoDB: Log scan progressed past the checkpoint lsn 19904353340
2015-07-28 20:21:16 7056 [Note] InnoDB: Database was not shutdown normally!
2015-07-28 20:21:16 7056 [Note] InnoDB: Starting crash recovery.
2015-07-28 20:21:16 7056 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-07-28 20:21:37 7056 [ERROR] InnoDB: Attempted to open a previously opened tablespace.
急求助 数据库服务无法打开 ~~
答案:2 悬赏:80 手机版
解决时间 2021-02-20 19:08
- 提问者网友:美人性情
- 2021-02-20 13:31
最佳答案
- 五星知识达人网友:蕴藏春秋
- 2021-02-20 15:01
找到"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\"文件夹,点击属性,在常规选项卡中点击高级, 在弹出的窗口中的压缩或加密属性中去掉压缩内容或者节省磁盘空间,点击确定,点击应用,勾选应用于该文件夹所有文件。
或者只需对数据库系统必须的几个数据库:master,model,msdb,tempdb等操作即可。
或者只需对数据库系统必须的几个数据库:master,model,msdb,tempdb等操作即可。
全部回答
- 1楼网友:孤独的牧羊人
- 2021-02-20 16:18
说一下是什么情况哦,插入不了数据有很多情况
数据库本身而言:无法连接,约束,错误等
后台程序:语法错误 ,语句错误,数据错误等情况
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯