 |
 |
I think those settings are good to add to the mysqld configuration, but as we said on the phone, we hope not to have chunks (and subchunks) that large. If you'd like to make the change in the my.cnf template, feel free to commit that on the master and let us all know when you've done so. -Daniel On 03/14/2013 08:09 AM, Emmanuel Medernach wrote: > 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 ######################################################################## 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