The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
0answers
18 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
1answer
29 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 ...
1
vote
1answer
51 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
281 views

What's the approach to figure out reason for mysql crash?

The database I'm using crashes a lot recently. And I can't find a decent way to dig into the issue. I looked into mysql error log, but don't know how to start. I know there was a "load data infile" ...
1
vote
0answers
25 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
25 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-...
0
votes
0answers
86 views

Mysql failed to start, InnoDB Error: page log sequence number is in the future

I had issue in starting mysql after machine crash. Looking in mysqld.log, I found below errors: 160511 09:50:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160511 9:50:40 [...
0
votes
1answer
25 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 ...
2
votes
2answers
108 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
0answers
66 views

Cannot open InnoDB table though the .frm file for the table exists

tonight, my local Server has crashed because the power went out. I do not have backups because this was only experimental. And for the sake of learning, I'd like to know what to do in this case. Here'...
0
votes
0answers
50 views

mongodb server crashed on login with admin users

On OpenSuse, I encountered the following problem Here is the output of the user creation, which i created before. For confirmation i again create the same user, mongod confirmed that user exist with ...
0
votes
2answers
135 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 != '...
9
votes
1answer
9k views

MySQL INNODB corruption after server crash during concurrent truncate command

My server crashed today I think due to a concurrent truncate table command on one of our INNODB tables. The server could be restarted, but after it starts up, everytime I try to issue an SQL command, ...
0
votes
0answers
22 views

MySQL 5.6.18 got signal 11

My MySQL Server 5.6.18 got signal 11 today very randomly. Has not happened before. This is the stack trace : stack_bottom = 7fdb9bcb1e0f thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)...
1
vote
1answer
78 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" ...
4
votes
1answer
491 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 ...
0
votes
0answers
132 views

MySQL Crashes on a freshly installed XAMPP

I've been working with MySQL for a couple of years, but something really changed happened today. While I was working on a project, my MySQL server suddenly crashed. mysql_error.log didn't make me any ...
1
vote
1answer
88 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 ...
34
votes
1answer
46k views

intermittent MySQL crashes with error “Fatal error: cannot allocate memory for the buffer pool”

Added on edit, 2013-05-29: Because this is a long question and discussion, here's a short summary of the question and the solution. I had problems running MySQL and Apache on a small Linux server (1 ...
3
votes
1answer
280 views

Configuring MySQL for Power Failure

I have an embedded device running a MySQL database with a web based application. The problem is when I shutdown my embedded device it just cuts off the power, and I can not have a controlled shutdown....
8
votes
1answer
7k views

How to trace SQL queries which are crashing SQL Server

We have a SQL Server 2008 database server (it happens to be running under MS Failover Clustering, but I don't think that is relevant here). Our application runs Hibernate for DB access, and since we ...
19
votes
4answers
11k views

MySQL InnoDB crash post-mortem

MySQL crashed on me this morning. With the exception of the standard MySQL included databases everything I use is InnoDB. I attempted to restart the MySQL daemon but it failed twice. I then ...
2
votes
1answer
3k views

MySql replication from 5.1 master to 5.6 slave keep crashing

I recently updated one of the replication slaves to mysql 5.6. After importing a recent dump from the master, I run mysql_upgrade with no errors. the database deamon started correctly with no error....
0
votes
1answer
4k views

mysqld got signal 11 - it's my fault but how do I fix it?

I was copying the database tables from our production server to my dev machine, and in the middle of the transfer I found out users were being locked out of the system because the select had locked a ...
1
vote
1answer
52 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:...
1
vote
1answer
196 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 ...
0
votes
0answers
494 views

slave mysql server crash : mysqld got signal 6

Hi I am trying import a mysql logical backup file on server A.Server A and B are in master slave configuration and both running on same unix server.slave is running while import is in progress.Due to ...
2
votes
2answers
586 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 ...
1
vote
1answer
400 views

MYSQL crashes on XAMPP while working with drupal

Good day, just today morning i was using drupal to add some content, it crashed and mysql shutdown unexpectedly at xampp!! last thing i was doing was inserting a data into a field with "auto complete ...
1
vote
1answer
93 views

MySQL Crashing every few days

Our website hasn't launched yet so we're gaining little to no traffic at the moment. For some strange reason MySQL seems to crash every 2-3 days unexpectedly. Here's the SQL log of the crash 2015-06-...
1
vote
1answer
173 views

MySQL Database Keeps Crashing

Our mysql instance is keep crashing after every 5-10 minutes very frequently. We have around 600 databases on that instance. I think 600 is not a big number of databases given the size of databases ...
0
votes
1answer
104 views

MySQL sudden restart

I have a strange issue with my MySQL server. It suddenly restarts. It's a rare but very big problem for me. This server is running as Master in Master-Slave replication. I'm using MySQL 5.6.16-1+sury....
0
votes
0answers
171 views

SQL Server service crashes when i run a linked server query

I'm using SQL Server 2012 on a Windows 7 Professional, 32 bit system. With the SQL Server service running, I run a linked server query and the service crashes. The OS is already updated and I change ...
0
votes
1answer
152 views

MySQL Crash After Starting Binary Logs

Recently I have added binary logs to mysql to start replication but after that setting, mysql process failed to start and keep crashing constantly. In mysql error logs some messages are there but not ...
2
votes
1answer
1k views

Mongodb 2.6 Server crash and not restarting

We are using mongodb 2.6 with one Primary and 2 secondaries. One of the secondary has gone bad and not restarting. 2014-04-18T21:13:34.765+0000 [rsSync] replSet still syncing, not yet to minValid ...
1
vote
1answer
6k views

Cannot enter psql command “FATAL: the database system is starting up” [closed]

I cannot login into postgresql server using psql command (to create / update / delete table) because some sort of error like below. the command : [root@Server-Database pg_log]# su postgres bash-4.1$...
0
votes
0answers
532 views

MySQL Inno DB Crash

This is the log of the crash. Basically every time I run a query it looses connection an crash. 2014-11-03 19:46:42 58021 [Note] Event Scheduler: Loaded 0 events 2014-11-03 19:46:42 58021 [Note] /...
1
vote
1answer
96 views

How to investegate MySQL crash on windows?

I have MySQL 5.6.19 running on Windows Server 2008 R2. I have 3 servers A, B, C Server A is a stand alone server. This server had data that can't be placed on SERVER B (ie. users information.) ...
4
votes
1answer
13k views

MySQL crashes randomly with “Database was not shut down normally” message in log

I am having an issue where, for no apparent reason, my MySQL server crashes and has to restart. Essentially, the error log has entries like this: 131128 12:16:35 mysqld_safe Number of processes ...
1
vote
1answer
4k views

Shut Down MySQL during InnoDB rollback after crash

I am puzzled once again. We had a server crash last night during some huge queries. Upon restart in the morning MySQL went into recovery mode. I needed to shut down the MySQL service and it is ...
9
votes
2answers
10k views

mysql.proc keeps crashing, cannot do a mysqldump?

Due to some problems with InnoDB, I'm going to dump all databases to a new server: mysqldump -E -R --all-databases | pv -b | mysql -u root -p -h new.server The dump process stopped with ...
0
votes
0answers
4 views

(libmysql): (filename not available): mysql_query [duplicate]

Hi everybody im running a game server connected to mysql and it crashes only because of mysql connection when i dont use mysql and save data as files on harddrive it dont crash at all but i cant ...
0
votes
2answers
300 views

Seg faults in Percona Server 5.6.19

Trying to figure out what went wrong here. Any advice would be appreciated. This server is running a new installation of Percona Server 5.6.19 on CentOS 6.5 16:05:46 UTC - mysqld got signal 11 ; This ...
0
votes
1answer
84 views

MySQL warm up time after restart because of lost connection

MySQL 5.6.10 on Windows 7. I'm cleaning up and paring down a large INNODB table. Its .ibd file is originally 22 gigs. While I was in the middle of an ALTER, dropping some columns, the mysqld.exe ...
0
votes
1answer
1k views

My database keeps crashing on startup how can i repair it without it running?

I've got some problems with my database. I hope somebody can help me out. Problem: The database keeps crashing on startup. In my log i see a couple off these errors: [ERROR] /usr/libexec/mysqld: ...
18
votes
1answer
414 views

Weird SQL Server instance crash on casting to numeric

While working with C# Entity Framework I noticed a crash of my SQL Server instance. I was able to track it down to this statement: SELECT * FROM dbo.[TestTable] where mpnr in (1099059904, 1038139906,...
2
votes
0answers
1k views

Analyzing MySQL crash due to corrupt InnoDB page. Failed page checksum

Lately we have been pestered by infrequent sporadic database crashes on one of our MySQL instances. Each time it is due to a failed page checksum. It happens on a specific database but spans multiple ...
0
votes
0answers
122 views

MySQL server crashed. [closed]

Help! I managed to crash MySQL last night. I am on a Mac using the native version that came with Mountain Lion. I was upgrading from 5.5 to 5.6. I have followed instructions in this forum to delete ...
8
votes
1answer
584 views

SQL Server 2008 R2 corrupted after changing MAXDOP [closed]

My SQL Server 2008 R2 doesn't work after changing the MAXDOP parameter on instances. I have 6 instances located on the same physical server and I changed MAXDOP from 1 to 2 on 5 instances. After ...