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