 |
 |
Daniel L. Wang a écrit : > 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. > Done. As the default value is rather low, I made the change in the my.cnf to avoid future similar problems. > -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 > ######################################################################## 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