ERROR 1105 (HY000): unknown error: no memory available

[ajnavarro]

Setting MAX_MEMORY to 1024 and executing the following query:

SELECT 
	COUNT(blob_hash),        
	commit_hash 
FROM ref_commits 
NATURAL JOIN commits 
NATURAL JOIN commit_blobs 
WHERE ref_name = 'HEAD' 
GROUP BY commit_hash;

I get the following error:

ERROR 1105 (HY000): unknown error: no memory available

This is OK, but if I execute the query again, it can be executed as usual.

If it can be executed, it should be executed the first time too.

It took 36362 rows in set (11 min 27.23 sec)

[erizocosmico]

What is the dataset?

[ajnavarro]

sorry, I forgot to mention it: bblfsh + src-d organizations.

[erizocosmico]

I've downloaded the dataset and tried to reproduce with 1024 and other different amounts and whenever it errors the first time, it errors all other times for me.

Did you try with the siva files collected by gitcollector or manually download? Perhaps if they were not siva, the memory footprint will change.

[ajnavarro]

They are siva files downloaded using gitcollector.

[erizocosmico]

I used those too and could not reproduce

[ajnavarro]

I'm not able to reproduce it again, closing the issue.