Questions tagged [crash]
The crash tag has no usage guidance.
80
questions
1
vote
1answer
81 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
0answers
36 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 ...
0
votes
0answers
49 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 ...
0
votes
1answer
53 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 ...
0
votes
1answer
25 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
1answer
107 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
0answers
9 views
MyISAM Mysqldump failing with a 1.5GB database on a VPS
It's basically because of a memory issue. I just downgraded to 2GB ram on this openvz vps. And the swap can't be changed from 512mb.
Another database at 350MB has no issue finishing. But the 1.5GB db ...
1
vote
1answer
847 views
MySQL Crashed, innodb trying to access page number which is outside the tablespace bounds
I am running MySQL (5.7) on a Windows 2012 server. One of the table (> 1 million records) seems to be corrupted. The mysql error log shows
2019-01-16T09:41:09.256990Z 0 [Note] InnoDB: Buffer pool(s) ...
0
votes
4answers
197 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 ...
1
vote
2answers
104 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 ...
0
votes
1answer
866 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 ...
1
vote
2answers
102 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 ...
20
votes
5answers
3k 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....
1
vote
0answers
67 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
1answer
104 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
1answer
603 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 ...
5
votes
2answers
9k 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: ./...
1
vote
1answer
7k 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';
...
2
votes
1answer
295 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 ...
1
vote
2answers
493 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 ...
0
votes
1answer
1k views
How can I determine why MySQL is crashing/exiting on startup?
I have a MySQL instance acting as a replication slave and something recently caused it to crash. I suspected InnoDB page corruption and wanted to switch from one-shared-tablespace (for InnoDB) to file-...
0
votes
1answer
835 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 ...
1
vote
2answers
716 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 ...
1
vote
1answer
2k 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
vote
0answers
77 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 ...
-1
votes
1answer
18 views
Mysql crashes on fresh installation
I try to run mysqld and here's the dump I get:
https://pastebin.com/TCk2YWQN
I tried re-installing mysql, but the same thing happens. Just running mysql returns ERROR 2002 (HY000): Can't connect to ...
-2
votes
2answers
2k views
Rootcause Oracle database crash due to open connections
We have a Windows 2003 server with a Oracle 11g DB installed and running a Java backend application that mines and inserts data onto the DB. The data is then distributed with PHP via a web server
...
1
vote
2answers
175 views
Mysql configuration and power failure
I'd like to know if there are certain configurations of Mysql that should be considered to keep the effect of the power failure as low as possible. Which configuration points should be noted and what ...
2
votes
0answers
439 views
MySQL 5.7 Crashing Every Few Days from Assertion failure
There's seems to be a lot of these sort of questions, all with varying error messages, but I seem to have found a relatively new one. There is a bug report here, https://bugs.launchpad.net/percona-...
4
votes
2answers
623 views
MySql: Frequent crashes on server with substantial resources
My MySQL server running the latest version of MySql on Ubuntu 16.x keeps crashing once or twice a day. Sometimes it repairs itself fairly quickly (10 minutes). Sometimes I have to reboot and do an ...
5
votes
1answer
669 views
Worker threads issue: How to read this crash dump, and what to do about it?
Our production SQL Server froze up yesterday. Had to kill the windows process to get it to restart.
Microsoft SQL Server 2016 (SP1-CU1) (KB3208177) - 13.0.4411.0 (X64)
Jan 6 2017 14:24:37
...
0
votes
1answer
74 views
Constant MysQL crashes. How to fix?
MysQL is frequently going down. Error logs contain:
[ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it | 149 occurrences
[ERROR] Native table 'performance_schema'....
0
votes
1answer
1k views
Mysql Crash SIGSEGV signal 11, recovered after killing apport
My mysql instance (ver 5.6.33) on AWS ( r3.4xlarge CPU Cores : 16 , RAM : 120 GB
, filesystem : XFS ) is crashing with signal 11 .
The instance is EBS optimised with EBS for storage.
At around 9:04 ...
1
vote
2answers
2k views
MySQL crash/restart during mysqldump
General: Standalone MySQL-5.5.43 in OpenVZ on ProxMox-3.4-6/102d4547 (Debian, 2.6.32-39-pve). Container uses 18Gb of RAM and 100Gb of disk. This container runs this service more than a year.
There's ...
0
votes
1answer
343 views
Safe method to rename a crashed myisam table
I have a large MyISAM table which has crashed. Repairing the table will take some time. The table only INSERTed to and SELECTed from, never updated. To allow the application to continue working, ...
0
votes
1answer
522 views
Mysql MyIsam tables get corrupted
I am facing the myisam tables get Corrupted frequently but I don't know exact root-cause for this problem. However I will do Repair/MyIsamchk --auto-repair whenever the table gets corrupted. Please ...
1
vote
0answers
2k views
MySQL keeps crashing
MySQL keeps crashing randomly - recent errors in error logs says this
160626 21:50:42 [Warning] IP address '113.108.21.*' could not be resolved: Name or service not known
160626 22:42:57 [Warning] IP ...
1
vote
2answers
2k views
mysqld is terminated because the system is low on memory; what to do?
I did recently a site migration; during that I had to erase all plugins and the reinstalling only the minimum as the site was causing the server to crash (A Vps with 1gb of ram), the most problematic ...
1
vote
1answer
1k views
ERROR 1091 (42000): Can't DROP 'PRIMARY'; on “mysql_upgrade”
I updated MySQL from 5.5.50 to 5.6.31 on a Centos 6.8 box with Plesk 12.5.30.
Using those steps.
The upgrade was successful but I ran into trouble with mysql_upgrade. I had to rebuild the permission ...
2
votes
0answers
1k views
Mongos process memory usage and crashes
So our MongoS instances use up A LOT of memory. More than even the shards and sometimes crash because of it.
Cluster structure
3x mongos
3x mongod Shards
3x mongod Replicas (one for each shard)
3x ...
1
vote
0answers
644 views
1 Node crashed of 3 node mariadb galera cluster
Heading
I have three nodes Galera cluster MariaDB, a node in June 4, 2016 suddenly crash, the following is log error
Red Hat Enterprise Linux Server release 6.5
Server version: 5.5.39-MariaDB-wsrep-...
3
votes
2answers
2k views
Oracle: Why is DBW terminating my Instance?
I was performing routine administrative tasks on an Oracle instance and I was not able to connect to it.
I proceeded to do as follows to reach a diagnosis:
I checked for Oracle processes in memory ...
0
votes
2answers
1k views
MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash
We have tables with MyISAM. The are out of sync, the number of records is different on each cluster node
> select table_schema, table_name from tables where ENGINE = 'MyISAM' and table_schema != '...
1
vote
1answer
385 views
MySQL: Reducing amount of open files
So, I currently have a problem with my mySQL server opening far too many file handles.
This requires me to restart to server each day, as otherwise, I get the infamous "errno 24, too many open files" ...
3
votes
1answer
2k views
Oracle crashing on CentOS
Here is alert_XE.log:
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_cjq0_23146.trc:
Process J000 died, see its trace file
kkjcre1p: unable to ...
1
vote
1answer
311 views
Postgres reindex on crash folklore
I'm struggling with a problem of folk memory re Postgres.
The folklore
I am told that a long time ago in a galaxy far, far away (PostgreSQL 8.4 under Ubuntu 12.04), PostgreSQL frequently suffered ...
0
votes
1answer
99 views
Procedure to replace a BDR server
I have set up a 2-node PG 9.4 system with BDR. Replication works great.
Now, let's suppose that one of the two nodes needs to be replaced. In fact, let's be more specific. Let's say that the node on ...
1
vote
1answer
176 views
Restore Postgresql data after hdd crash
My HDD crashed, so, I can't make a Postgresql backup. It seems that my data tables are OK (I can view the data via pgAdmin). However, when I run pg_dump I get this:
pg_dump: Error message from server:...
2
votes
1answer
1k views
Mysql shutting down during a mysqldump of a specific database
I have a server which is running Centos 6.6 with Cpanel. I have been attempting to do mysqldump backups on individual databases. All of the databases are under 5MB except for one.
The database that ...
2
votes
2answers
5k views
Would increasing innodb buffer pool size prevent a mysql crash?
My server keeps running out of memory for mysql. I keep getting. 150708 3:39:09 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 258064 bytes)
When I looked in my.cnf I saw that ...
