Skip to main content

Questions tagged [crash]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
3 answers
314 views

MariaDB Crashes Every Time Restarted

OSX Sonoma, OSX Monterey Latest MariaDB from Homebrew (11.4.2-MariaDB, client 15.2 for osx10.17 (x86_64)) MariaDB won't start every time I restart the brew service or restart the computer. I ...
Penyo's user avatar
  • 11
0 votes
0 answers
19 views

Galera Cluster: All Nodes Slowed Down After Update Query and Too Many Connections Error

I met a disability while using galeracluser and I have a question. It is an active-active 3-node structure and maintains replication through log_slave_updates=ON. I'm using MariaDB 10.5.13 version ...
samsamsamsmasma's user avatar
0 votes
0 answers
46 views

MariaDB Crash Rolled back recovered transaction

For months my MariaDB is running fine but for the last 2 - 3 weeks it crashes randomly 2 - 3 times in the week. i have observed the log files but i'm stuck for now. this is our main production server. ...
Stefx's user avatar
  • 9
1 vote
2 answers
120 views

Queries causing MariaDB to get signal 7

I have a Redhat box running MariaDB 10.3.39-MariaDB-log. There are some queries that are running that seem to cause MariaDB to get a signal 7, MariaDB will crash mark a bunch of tables as crashed and ...
Anthony Benavidez's user avatar
1 vote
1 answer
33 views

Mariadb semi-freezing while writing gigabytes per second according to iotop

Recently, I've had a crash of mariadb that started a nightmare. When I restored dumps I had sometimes the daemon hang during bulk inserts. This happened only on the few "big" innodb tables (...
meh's user avatar
  • 23
0 votes
1 answer
323 views

What will happen when SQL Server log drive is full?

One of my production database log file drive filled up and I noticed below messages in SQL Server error log. 2022-02-13 03:16:24.500 spid72 Error: 9002, Severity: 17, State: 4. 2022-02-13 03:16:24....
Fajela Tajkiya's user avatar
0 votes
0 answers
121 views

mariadb 11.0.2 crashed without error message

I am using MariaDB 11.0.2, upgraded from 10.5.x. some of the servers is good and working fast. the other one, is not. It start crashing after upgrade, but without an error message. when running as a ...
Moshe L's user avatar
  • 126
-1 votes
1 answer
88 views

AlwaysOn proc doesn't stop, but it can't be telnet。SqlDumpExceptionHandler: Process {0} g fatal exception c0000094 EXCEPTION_INT_DIVIDE_BY_ZERO

I'm a DBA, I'm still learning, and I've recently encountered an Alwayson cluster that can't be used. Storage failure 1796932693059087230, type 5 Event name: SQLException64 Response: Not applicable Cab ...
Wayne Chen's user avatar
1 vote
0 answers
314 views

Trying to use the "Object Explorer" in pgAdmin crashes server when pg-strom is installed

I'm trying to get to the bottom of some unusual behavior with pgAdmin4 when the GPU acceleration extension pg-strom is installed in PostgreSQL 14 and 15. Simple queries seem to work fine, but when ...
Sam's user avatar
  • 111
1 vote
1 answer
480 views

Is a Postgresql UNLOGGED table completely lost on process crash?

I use UNLOGGED tables for a few very large tables in a data warehouse style application. Until recently, I understood UNLOGGED to mean “won’t write to the WAL” - which in turn means that recent ...
adam's user avatar
  • 155
2 votes
2 answers
2k 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 ...
lyeaf's user avatar
  • 177
0 votes
1 answer
442 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/...
R. Smith's user avatar
  • 101
2 votes
1 answer
2k 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 ...
Sébastien Clément's user avatar
0 votes
0 answers
271 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 ...
user avatar
0 votes
1 answer
952 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 '...
user avatar
0 votes
0 answers
135 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 ...
lulmail's user avatar
1 vote
2 answers
294 views

After server is restarted, the database and the backups are destroyed by the system crash. What ACID properties are broken in this situation?

Let's assume that two transactions execute on a database, both reading, and writing. At some time, the system crashes. After the server is restarted, the database and the backups were destroyed by the ...
ujoeja's user avatar
  • 11
0 votes
0 answers
110 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 ...
Rayner's user avatar
  • 121
-2 votes
1 answer
208 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 ...
Seth Ficke's user avatar
2 votes
1 answer
2k 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. ...
Robert's user avatar
  • 23
0 votes
0 answers
790 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 ...
risingfish's user avatar
1 vote
1 answer
1k 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:...
Kobus Myburgh's user avatar
1 vote
1 answer
803 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-...
Qiulang 邱朗's user avatar
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 ...
wistlo's user avatar
  • 119
1 vote
1 answer
938 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 &...
Christian68's user avatar
0 votes
1 answer
1k 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] ...
MohammadAli Zeraatkar's user avatar
1 vote
1 answer
145 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 [...
JRA's user avatar
  • 149
1 vote
1 answer
235 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: ...
ybs_antel's user avatar
0 votes
1 answer
421 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 ...
rsmoorthy's user avatar
  • 157
2 votes
2 answers
707 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 ...
Kacper Kleszczyński's user avatar
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....
Jan Steinman's user avatar
1 vote
0 answers
179 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 ...
TheFox's user avatar
  • 11
0 votes
0 answers
684 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 ...
Real Dreams's user avatar
3 votes
1 answer
591 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 ...
DizzyZeratul's user avatar
1 vote
4 answers
146 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 ...
TrojanName's user avatar
0 votes
1 answer
114 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, ...
Sachin DG's user avatar
5 votes
1 answer
8k 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 ...
Nigel McLaughlin's user avatar
0 votes
0 answers
376 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 ...
homedom's user avatar
  • 111
0 votes
0 answers
631 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 ...
Bor691's user avatar
  • 101
0 votes
1 answer
978 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 ...
Bill's user avatar
  • 1
0 votes
1 answer
113 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 ...
Phillip Brantley's user avatar
0 votes
1 answer
723 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 ...
udhayan dharmalingam's user avatar
0 votes
4 answers
786 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 ...
insideClaw's user avatar
0 votes
2 answers
593 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 ...
Shawn_M's user avatar
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 ...
Mattia Nocerino's user avatar
1 vote
2 answers
692 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 ...
Adam Thompson's user avatar
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....
Heinzi's user avatar
  • 3,155
1 vote
0 answers
236 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 ...
Jarrod Farrell's user avatar
0 votes
1 answer
954 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 ...
leandro2219's user avatar
4 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 ...
ssasa's user avatar
  • 241