Hello,
We are trying to have a running mono-node installation of Qserv with all data
from PT11 loaded. We have managed to run a bunch of queries correctly but some
give errors like this one:
SELECT o1.objectId, o2.objectId
FROM LSST.Object o1, LSST.Object o2
WHERE qserv_areaspec_box(0.5, 0.5, 1.5, 1.5) AND
scisql_angSep(o1.ra_PS, o1.decl_PS,
o2.ra_PS, o2.decl_Ps) < 0.2;
ERROR 4120 (Proxy): Error executing query using qserv.
After many debugging and repeating SQL commands from xrootd.log by hand we found
that creating a temporary result table Qserv was not possible :
mysql> CREATE TABLE IF NOT EXISTS Subchunks_LSST_100.Object_100_0 ENGINE = MEMORY
-> AS SELECT * FROM LSST.Object_100 WHERE subChunkId = 0;
ERROR 1114 (HY000): The table 'Object_100_0' is full
One solution we just found is to increase the memory limit to avoid this problem:
[mysqld]
tmp_table_size=4G
max_heap_table_size=4G
- Could you add this options as default in the my.cnf template ?
- Would it be possible to check these table creations and in case of a problem
to report an error message in log files ?
Talk to you soon,
--
########################################################################
Use REPLY-ALL to reply to list
To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1
|