Print

---

We've got this error and we aren't sure what to do to fix it on the 
in2p3 cluster. It looks like the qservCssData database does not exist.

==> /qserv/run/var/log/qserv-czar-console.log <==
terminate called after throwing an instance of 'lsst::qserv::css::CssError'
   what():  Error from mysql: (-999) Error connecting to mysql with 
config:[host=, port=0, usr=qsmaster, pass=, dbName=qservCssData, 
socket=/qserv/run/var/lib/mysql/mysql.sock

On 11/10/15 09:41, Fabrice Jammes wrote:
> Hello,
>
> CSS metadata is still stored in zookeeper on cc-in2p3 cluster, so any 
> SQL query on a partitioned table crashes Qserv.
> Does somebody knows how to upgrade css metadata to new format?
>
> If it is proven that the crash is due to wrong metadata format, I'll 
> open a bug, this shouldn't crash Qserv but print explicit log message 
> instead, isn't i?
>
> Error report is available below.
>
> Thanks,
>
>
> -------- Forwarded Message --------
> Subject: 	About docker install
> Date: 	Mon, 09 Nov 2015 16:58:23 -0800
> From: 	Fabrice Jammes <[log in to unmask]>
> To: 	John Gates <[log in to unmask]>
>
>
>
> Hi John,
>
> It seems our docker configuration is working a bit:
> fjammes@ccosvms0070:~$ time mysql --host ccqserv125 --port 4040 --user
> qsmaster LSST -e "show tables;";
> +------------------------------------+
> | Tables_in_LSST                     |
> +------------------------------------+
> | ForcedSource                       |
> | ForcedSourceFullOverlap_1234567890 |
> | ForcedSource_1234567890            |
> | Object                             |
> | ObjectFullOverlap_1234567890       |
> | Object_1234567890                  |
> | Source                             |
> | SourceFullOverlap_1234567890       |
> | Source_1234567890                  |
> +------------------------------------+
>
> real    0m0.027s
> user    0m0.010s
> sys     0m0.013s
>
> Nevertheless next query fails and crash qserv czar:
> fjammes@ccosvms0070:~$ time mysql --host ccqserv125 --port 4040 --user
> qsmaster LSST -e "select count(*) from Object;";
> ERROR 4005 (Proxy) at line 1: Unable to run lua xmlrpc client, message:
> ...inux64/lua/5.1.4.lsst1/share/lua/5.1/xmlrpc/http.lua:41: closed
>
>
>
> real    0m0.105s
> user    0m0.004s
> sys     0m0.009s
>
> qserv-czar.log doesn't print any error message:
> qserv@ccqserv125:/qserv$ tail /qserv/run/var/log/qserv-czar.log
> user = qsmaster
> port = 0
>
>
> 2015-11-10T00:53:52.413Z [0x7f98d86af700] DEBUG root
> (appInterface.py:70) - _idCounter 27996832412
> 2015-11-10T00:53:52.413Z [0x7f98d86af700] INFO  root (server.py:137) -
> endpoints: [<bound method AppInterface.cancelEverything of
> <lsst.qserv.czar.appInterface.AppInterface instance at 0x7f98cba83878>>,
> <bound method AppInterface.check of
> <lsst.qserv.czar.appInterface.AppInterface instance at 0x7f98cba83878>>,
> <bound method AppInterface.joinQuery of
> <lsst.qserv.czar.appInterface.AppInterface instance at 0x7f98cba83878>>,
> <bound method AppInterface.killQuery of
> <lsst.qserv.czar.appInterface.AppInterface instance at 0x7f98cba83878>>,
> <bound method AppInterface.killQueryUgly of
> <lsst.qserv.czar.appInterface.AppInterface instance at 0x7f98cba83878>>,
> <bound method AppInterface.resultTableString of
> <lsst.qserv.czar.appInterface.AppInterface instance at 0x7f98cba83878>>,
> <bound method AppInterface.results of
> <lsst.qserv.czar.appInterface.AppInterface instance at 0x7f98cba83878>>,
> <bound method AppInterface.submitQuery of
> <lsst.qserv.czar.appInterface.AppInterface instance at 0x7f98cba83878>>,
> <bound method Czar.echo of <lsst.qserv.czar.server.Czar instance at
> 0x7f98cba83830>>, <bound method Czar.stop of
> <lsst.qserv.czar.server.Czar instance at 0x7f98cba83830>>, <bound method
> Czar.reset of <lsst.qserv.czar.server.Czar instance at 0x7f98cba83830>>]
> 2015-11-10T00:53:52.420Z [0x7f98d86af700] INFO  root (server.py:128) -
> Starting Qserv interface on port: 7080
> 2015-11-10T00:56:40.602Z [0x7f98d86af700] DEBUG root
> (appInterface.py:119) - taskId 27996832412
> 2015-11-10T00:56:40.613Z [0x7f98d86af700] DEBUG css.CssAccess
> (core/modules/css/CssAccess.cc:95) - Create CSS instance from config map
> 2015-11-10T00:56:40.613Z [0x7f98d86af700] DEBUG css.CssAccess
> (core/modules/css/CssAccess.cc:148) - Create CSS instance with mysql store
>
>
>
>
> ------------------------------------------------------------------------
>
> 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