Why is MySQL throwing a stack overflow exception in its C API?

Question

0.00/5 (No votes)

See more:

I can't seem to figure this out. I copied this code almost line for line (I made a few adjustments) to store an image as a BLOB data type in a MySQL data table.

C++

void Mainframe::User::setImage(std::string ID, std::string dbProperty, std::string imagePath)
	{
		MYSQL *conn; 

		int len, size;
		char data[1000*1024];
		char chunk[2*1000*1024+1];
		char query[1024*5000];

		FILE *fp;

		conn = mysql_init(NULL);
		mysql_real_connect(conn, "localhost", "root", "password", "testdb", 0, NULL, 0);

		fp = fopen(imagePath.c_str(), "rb");
		size = fread(data, 1, 1024*1000, fp);

		mysql_real_escape_string(conn, chunk, data, size);

		std::string updateStr = ("update users set " + dbProperty + "='%s' where id=" + ID + ";"); 
		len = _snprintf(query, sizeof(updateStr.c_str()) + sizeof(chunk),updateStr.c_str(), chunk);
		
		mysql_real_query(conn, query, len);

		fclose(fp);
		mysql_close(conn);
	}

Yet, every time it runs, I the app immediately crashes and I get:

Unhandled exception at 0x00ee2867 in MSQLClientTest.exe: 0xC00000FD: Stack overflow.

Any ideas what might be going wrong? I tried changing my "char"s to "char*"s after I saw someone suggest it online, but it only lead to more problems involving cast exceptions and whatnot. So any help would be greatly appreciated. Thanks in advance.

Posted 28-Mar-13 15:36pm

RadXPictures

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

H.Brydon · Answer 1 · 2013-03-28T17:04:00

Yeah, those char arrays are enormous. You either need to allocate the arrays on the heap, as static objects or increase the size of the stack. On most machines, the stack is not usually more than 1 or 2 megabytes by default.

You can make them static simply by declaration:

C#

static char data[1000*1024];
static char chunk[2*1000*1024+1];
static char query[1024*5000];

To allocate them on the heap, you will need to rewrite the code a little. Hopefully you know how to do that.

To increase the stack size, you do this for the main executable project. Details are straightforward but slightly different for each version of Visual Studio.

Why is MySQL throwing a stack overflow exception in its C API?

1 solution

Solution 1

Add your solution here

Preview 0

Why is MySQL throwing a stack overflow exception in its C API?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us