Solved

MySQL error 4000 - MEMORY ALLOCATION ERROR

Posted on 2012-04-09
1
959 Views
Last Modified: 2012-08-14
Hi all! I've setup a MySQL cluster with 3 servers (1 arbitrator, 2 nodes, the mysqld process is on the same machine as arbitrator), I keep getting error 4000 - MEMORY ALLOCATION ERROR when reading the "vw_users" view. It is a join with a table and a "postal codes" table which has 500k records.

Part of my config:
[ndbd default]
NoOfReplicas = 2
DataDir = /var/lib/mysql-ndb-data
DataMemory = 1G
IndexMemory = 256M
TransactionBufferMemory = 8M
TransactionInactiveTimeout = 2000
MaxNoOfOrderedIndexes = 1024
MaxNoOfAttributes = 10000
MaxNoOfTables = 2500
MaxNoOfConcurrentOperations = 100000
MaxNoOfConcurrentIndexOperations = 100000

Sometimes it works, sometimes it fails. The machines all have 2GB Ram. Am I doing something wrong?

Today, my PHP scripts gave my this error if it is releavant, but I fixed it, it's OK:
Host '10.1.0.1' is blocked because of many connection errors
0
Comment
Question by:alex3948
1 Comment
 

Accepted Solution

by:
alex3948 earned 0 total points
ID: 37848879
Issue has been resolved. This was a very tricky bug in MySQL cluster with pushdown joints. Solution was to call "set ndb_join_pushdown = off" right after the connection and the problem goes away.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question