Questions tagged [crash]
The crash tag has no usage guidance.
103
questions
0
votes
0
answers
10
views
Help debugging Mariadb randomly crashing
These are the logs journalctl -u mariadb -f from the past days at the moment of the crash:
Mar 17 07:40:58 new-server.novalocal mariadbd[6664]: 2023-03-17 7:40:58 138278 [Warning] Access denied for ...
0
votes
0
answers
23
views
mysqld --initialize not starting MySQL5.7 on Ubuntu 20.04
Recent crash (RAID controller cache failure) made me re-create the MySQL system databases and tables for some were missing. I run MySQL 5.7 on Ubuntu 20.04.
2023-03-10T19:06:19.363955Z 0 [ERROR] --...
- 11
2
votes
2
answers
222
views
Database keeps crashing every few hours
The MariaDB server will crash every few hours(it's been a week so yeah, dozens of crashes), and restart automatically. In 2 previous crashes it went as far as the server not starting up again, and I ...
- 155
0
votes
1
answer
63
views
Recovering MySQL database from crashed drive - innodb tables
I have a machine that crashed that contained a VERY important MySQL crash. My automated daily backups were in one of the locations where the data was fragged. So all I have is my physical /var/lib/...
- 101
0
votes
0
answers
313
views
Copying a record using Trigger in the same table
I have a table issues with following fields.
Whenever a new record is inserted in the issues table, I want that inserted record to be copied (as a backup) in the same table(issues). I have created a ...
2
votes
1
answer
1k
views
PostgreSQL crash due to lack of device space
We run PostgreSQL 11 under a CentOS 7 server.
Recently, we had several warnings in the log that caused the PostgreSQL server to crash:
2022-05-09 23:26:29 EDT pg_restore db123 132.132.132.32 ...
- 1,713
0
votes
0
answers
226
views
Why mysql 8.0.17 is clean after crash
I was working with my website and after I started a very huge process in the server (CentOS 8.5.2111), the server can not allocate more tasks because memory full, and MySQL (8.0.17) started with ...
EsopMx
0
votes
1
answer
563
views
Crash of MSSQL CHECKDB with EXCEPTION_ACCESS_VIOLATION
I have a db with some consistency errors. Below the messages I get when issuing a CHECKDB on it with repair_rebuild option.
CHECKDB found 0 allocation errors and 16 consistency errors in database '...
clebig
0
votes
0
answers
70
views
Can an Oracle Database request a system crash (One Instance Crash)?
I am Junior Database Administrator at a Bank and there was an issue that caused the Oracle Database Instance one to crash (We have two instances). So the system rebooted itself and everything is ...
- 1
0
votes
0
answers
79
views
SQL Server 2019 Express for Linux on Ubuntu 20.04 - Bug - CU 13 - c0000005 EXCEPTION_ACCESS_VIOLATION when specifying @wkt in Table-valued function
Pretty sure I've found a bug in SQL Server 2019 (Express) for Linux (CU 13, version 15.0.4178.1 running on Ubuntu 20.04 LTS). After the following table-valued function dbo.bTest is created:
use devdb
...
- 121
-2
votes
1
answer
101
views
How to recover from setting maximum server memory too low? [closed]
On SQL Server 2019, it is possible to configure the server for a smaller than minimum amount of memory (in my case, 100mb). After doing this, the server crashes on startup. Some other forums pointed ...
1
vote
1
answer
1k
views
Azure Database for MySQL - Memory keeps increasing then crashes
I know there are some similar posts as mine but none of them helped me out.
I have an Azure Database for MySQL. The average memory usage is above 90% and sometimes the server crashes and restarts.
...
- 13
0
votes
0
answers
400
views
Need a hand recovering a MySQL InnoDB database
I recently had my file server OS hard disk die completely. Of course I have the file storage on a ZFS array so that's fine, but not the OS drive. I was able to use Clonezilla to partially recover data ...
- 101
1
vote
1
answer
610
views
MySQL InnoDB now has error after Windows 10 update [closed]
These two things are seemingly unrelated, but I have just done a Windows update, and all of a sudden, MariaDB won't start up. I get the following errors:
InnoDB: using atomic writes.
2021-08-11 14:10:...
- 135
0
votes
1
answer
452
views
When a thread/process crashes on acquired DB locks, how does DB detects that and releases the lock?
Take MySQL as an example, say a thread run SELECT ... FOR UPDATE crashes before committing the update, how does MySQL detect the crash and release the lock?
I assume most RMDBS will have some keep-...
- 101
1
vote
2
answers
2k
views
MySQL 8.0.24 Windows 10 crashes [not] resolved by reboot, [requires mySQL optimizer tweak]
MySQL 8.0.24 on Windows 10 (10.0.18363.0) crashes near the same point when running a final results query, but only after data input queries with many more records have been run.
A restart of the MySQL ...
- 119
1
vote
1
answer
556
views
MySQL8 crash recovery
My dev MySQL-8 server crashed last night and would not restart. The error is:
[ERROR] [MY-012646] [InnoDB] File ./ibdata1: 'open' returned OS error 71. Cannot continue operation
I tried the classic &...
- 111
0
votes
1
answer
591
views
Mysql on Ubuntu crashing periodically [duplicate]
I have a problem with Mysql on my ubuntu server. it is restarting periodically about 4-5 times a day .
Here is the logs that I found in /var/log/mysql/error.log:
2021-02-23T08:35:08.249856Z 18 [Note] ...
1
vote
1
answer
62
views
MySQL crashed suddenly
MySQL seems to crash suddenly but recovered in around 2minutes. I am running on Ubuntu 18.04 (16vcpu, 32GB RAM). I dont know what caused it.
Here is my.ini
[mysql]
default-character-set=utf8mb4
[...
- 79
1
vote
1
answer
143
views
postgresql crash in master node with streaming replication
We have a master/slave postgresql cluster with streaming replication and pgpool.
Versions in both postgresql servers are.
postgres: 9.4
OS: Debian GNU/Linux 8 (jessie)
PGPOOL server:
version pgpool: ...
- 11
0
votes
1
answer
287
views
postgres cluster: Crash of master crashes the replicas too
Environment:
Postgres version: 9.6
Cluster of 3 servers, with Patroni and etcd
Scenario:
When index of tables were started with 16 parallel requests (on a 16CPU machine), postgres on the master ...
- 147
1
vote
2
answers
490
views
CPU High usage crashing our server
The server where my database is running is suffering from CPU spikes. We're having trouble identifying what is causing these CPU spikes, and consequently how to mitigate them.
I've tried adding some ...
0
votes
1
answer
1k
views
mysql (mariadb) won't start after power outage (MacOS)
/var/log/system.log says (over and over)
Oct 13 19:34:01 Data-Server com.apple.xpc.launchd[1] (com.mariadb.server[2128]): Service exited with abnormal code: 1
Oct 13 19:34:01 Data-Server com.apple.xpc....
- 191
1
vote
0
answers
146
views
MySQL router on server with tomcat memory leak
Memory is slowly used by mysql router. I am running mysql router version 8.0.20 (I found there was a memory leak on mysql router 2.1.2 but mysql router 8.x is newer)
I have a 3 node single-primary ...
- 11
0
votes
0
answers
459
views
MySQL says "check that your my.cnf matches the ibdata files". How?
After trying to copy some columns of big tables (500k records) into another one, my MySQL dockers (5.7) images stoped. Trying to start it again I get the following error:
[ERROR] InnoDB: Trying to ...
- 261
3
votes
1
answer
328
views
In PostgreSQL, if crashes during VACUUM, will it recover from a checkpoint that is before the frozen transaction ID of VACUUM?
When VACUUM starts, it will calculate a frozen transaction ID and freeze all tuples older than it. Will this frozen TXID be younger than the latest checkpoint?
If this is the case, then when the ...
- 31
1
vote
4
answers
130
views
Investigating an Oracle 12c outage after the fact, while limited to SQL*Plus
Warning up front: unfortunately I'm limited to using SQL*Plus on remote site, with no other tools available. This is Oracle 12c (12.2.0.1.0) Standard Edition running on Windows Server 2012R2.
Over ...
- 134
0
votes
1
answer
63
views
mongodb 2.4.1 instance shutdown without log
I am running mongodb in a replica set of 3 nodes (no sharding). But since 5 days the secondary instance shuts down intermittently, once in 2 days.
Log does not indicate any event related to shutdown, ...
5
votes
1
answer
6k
views
AWS Aurora running out of freeable memory and crashing
We have an issue with our AWS Aurora MySQL instance running out of freeable memory and crashing as a result. AWS's response was to upgrade to a bigger instance, but I don't feel that will necessarily ...
0
votes
0
answers
293
views
MariaDB Cluster node crashes after upgrade
I have a 3 node MariaDB galera cluster running. It was running fine until I updated one node from MariaDB 10.3.14 to 10.3.16 (the other nodes are still on 10.3.14). Since then, this one node regularly ...
- 111
0
votes
0
answers
583
views
Mysql 5.7.25 crash on first query to corrupted innodb table
Setup:
Ubuntu 18.04.1 LTS
4.15.0-34-generic #37-Ubuntu
Docker: 18.06.1-ce build e68fc7a
mysql:5@sha256:e47e309f72c831cf880cc0e1990b9c5ac427016acdc71346a36c83806ca79bb4
mysql --version = Ver 14.14 ...
- 101
0
votes
1
answer
735
views
MySQL 8.0.15 starts normally but any connection hangs
I dropped a large table (80G) Friday morning and got a crash:
InnoDB: ###### Diagnostic info printed to the standard error stream
2019-04-19T18:48:55.445507Z 0 [ERROR] [MY-012872] [InnoDB] Semaphore ...
- 1
0
votes
1
answer
81
views
Mariadb times out on startup after system reboot
This is continued from:
https://stackoverflow.com/q/55071021/8644833
Mariadb shuts down after running for a minute or two. If I remove Mariadb and reinstall (keeping my databases), everything works ...
0
votes
1
answer
500
views
Mysql 5.7.20 crashes after jemalloc installation
Recently i faced memory leak issue in one my mysql instance (5.7.20) where eventhough allocated buffer pool size was 50% of the RAM, but mysqld memory utilization was constantly pegging at 90%.
I ...
0
votes
4
answers
634
views
Group Replication plugin crashes MySQL 8.0
Problem description:
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
results in
ERROR 2013 (HY000): Lost connection to MySQL server during query
Specs:
MySQL version: 8.0.13 ...
- 13
0
votes
2
answers
486
views
MySQL 5.7 intermittent max connections errors
I’m having a problem with MySQL 5.7 with « too many connections » causing services crashes. The max_connections system variable is set at 1000 and on average there are +/- 250 sessions/thread, so it’s ...
- 9
3
votes
1
answer
4k
views
SSMS crashes when attempting to create a database diagram
I'm currently using the latest version of SSMS (17.8.1) on windows 10 and everytime I try to create a database diagram it crashes without giving me any error message. I've already tried to re-install ...
- 602
1
vote
2
answers
554
views
Why do uncommitted transactions rollback instead of redo after a crash in ARIES?
Since all actions within a transaction are idempotent in crash recovery algorithms like ARIES that use write-ahead logging why do we rollback after a crash during an uncommitted transaction to get ...
- 419
23
votes
5
answers
4k
views
Can SQL Server's crash resilience be improved?
We have PCs running SQL Server (2008 SP4 and 2016 SP1) which regularly lose power. Obviously, this sometimes leads to (index) corruption of the SQL Server database, which we need to restore afterwards....
- 3,145
1
vote
0
answers
186
views
MSSQL Linux Crashes with data files on EXT4 formated ZVOL Reason: 0x00000003
Reason: 0x00000003
Message: 0 == (m_PhysicalSectorSize % m_LogicalSectorSize)
Stacktrace: 0000558d9d8c90c1 0000558d9d91ff08 0000558d9d8cd02c
0000558d9d8d0965 0000558d9d8cdc3b ...
0
votes
1
answer
754
views
mysqli::query(): (HY000/1194)
I have a server on Azure with a MySQL database, we have two apps there and sometimes we get this error on the code:
Warning: mysqli::query(): (HY000/1194):
Table 'noticia' is marked as crashed and ...
3
votes
1
answer
5k
views
MongoDB crashes with out-of-memory or is being killed by oom-killer
A two shards MongoDB database regularly crashes with out-of-memory error or is being killed by the oom-killer. The system runs on GCE Debian 9.4 with MongoDB v3.6.5, WiredTiger storage engine and ...
- 221
7
votes
3
answers
51k
views
Won't start: InnoDB: Corrupted page ... Tablespace was not found
After a server crash (Ubuntu 16.04), when I try to start Mysql (Mysql 5.7) using innodb_force_recovery=0 it doesn't start and error.log shows:
InnoDB: Checksum mismatch in datafile: ./...
- 173
9
votes
3
answers
36k
views
Mysql Workbench crashing when connecting
I have created an user i intend to give access to one db only.
But when i try connecting with him, the program crashes. When i connect with the root user, it works.
create user 'test'@'localhost';
...
- 93
2
votes
1
answer
569
views
Effect of over allocating shared_buffers
I have a 9.6 PostgreSQL RDS instance that I am tending to, but did not initially configure, and have been struggling with two different symptoms:
the system (a db.r3.2xlarge w/ 61GB memory) would ...
- 121
1
vote
2
answers
1k
views
How to decrese MySQL Innodb crash recovery time (force MySQL to do it faster)
I'm running MySQL 5.7 with 1GB of innodb_log_file_size on CentOS 7 x64 and I can't change the value of that parameter right now.
In the case of crashes, it takes about 20 minutes to recover, but ...
- 139
1
vote
1
answer
3k
views
MySQL memory usage slowly increasing then crash - what's causing this? [duplicate]
So I have a Server that's constantly receiving 30k clicks/day. However, in the meantime does certain insert/update/select cronjobs as well.
My server has 4CPUs, 8GM RAM. Using MySQL 5.7.18 + PHP.
I ...
- 167
3
votes
2
answers
1k
views
Running MySQL in virtualbox with data dir on shared folder sometimes results in data corruption
I'm trying to move our development environment onto a vagrant box (virtual machine using Oracle virtualbox). Currently I'm stuck on one problem:
The environment needs a MySQL server and some ...
- 704
2
votes
1
answer
19k
views
MySQL Crashed - InnoDB
Im using mysql 5.5
All of my Tables are in innoDB.
Today my app went down and the mysql was unable to start.
Here are my findings.
The manual page at http://dev.mysql.com/doc/mysql/en/crashing....
- 1,840
1
vote
0
answers
234
views
mariadb won't restart after storage space induced crash
I have a large mariadb instance running (400 gb or so).
Due to running out of storage space it crashed.
I went ahead and resized my volume (I am using AWS), and went to restart the service service ...
- 121