[MSNoise] Problem with database conection.
Oscar Alberto Castro Artola
oscar.cas.art at gmail.com
Thu Jun 15 19:25:36 UTC 2017
Dear Thomas,
I tried *pip uninstall msnoise*, and I get this:
Uninstalling msnoise-0+unknown:
/usr/local/anaconda/bin/msnoise
/usr/local/anaconda/lib/python2.7/site-packages/msnoise-0+unknown-py2.7.egg-info
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/MWCS.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/MWCS.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/__init__.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/__init__.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/_version.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/_version.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/api.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/api.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/bugreport.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/bugreport.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/data_structures.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/data_structures.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/default.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/default.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/msnoise_admin.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/msnoise_admin.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/msnoise_table_def.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/msnoise_table_def.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/myCorr.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/myCorr.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/__init__.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/__init__.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/ccftime.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/ccftime.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/data_availability.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/data_availability.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/distance.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/distance.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/dtt.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/dtt.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/dvv.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/dvv.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/interferogram.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/interferogram.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/mwcs.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/mwcs.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/station_map.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/station_map.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/timing.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/plots/timing.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s000installer.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s000installer.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s001configurator.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s001configurator.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s002populate_station_table.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s002populate_station_table.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s01scan_archive.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s01scan_archive.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s02new_jobs.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s02new_jobs.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s03compute_cc.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s03compute_cc.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s04stack.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s04stack.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s05compute_mwcs.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s05compute_mwcs.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s06compute_dtt.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/s06compute_dtt.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/scripts/__init__.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/scripts/__init__.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/scripts/msnoise.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/scripts/msnoise.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/static/admin/msnoise.css
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/static/admin/msnoise.png
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/static/admin/style.css
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/stretch.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/stretch.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/admin/about.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/admin/bugreport.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/admin/data_availability.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/admin/index.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/admin/interferogram.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/admin/master.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/admin/model/edit-config.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/admin/results.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/templates/index.html
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/__init__.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/__init__.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/data/2010/UV05/HHZ.D/YA.UV05.00.HHZ.D.2010.244
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/data/2010/UV06/HHZ.D/YA.UV06.00.HHZ.D.2010.244
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/data/2010/UV10/HHZ.D/YA.UV10.00.HHZ.D.2010.244
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/extra/stations.csv
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/run_tests.sh
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/tests.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/test/tests.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/whiten.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/whiten.pyc
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/whitenAM.py
/usr/local/anaconda/lib/python2.7/site-packages/msnoise/whitenAM.pyc
Proceed (y/n)? y
Exception:
Traceback (most recent call last):
File
"/usr/local/anaconda/lib/python2.7/site-packages/pip/basecommand.py", line
215, in main
status = self.run(options, args)
File
"/usr/local/anaconda/lib/python2.7/site-packages/pip/commands/uninstall.py",
line 76, in run
requirement_set.uninstall(auto_confirm=options.yes)
File
"/usr/local/anaconda/lib/python2.7/site-packages/pip/req/req_set.py", line
346, in uninstall
req.uninstall(auto_confirm=auto_confirm)
File
"/usr/local/anaconda/lib/python2.7/site-packages/pip/req/req_install.py",
line 754, in uninstall
paths_to_remove.remove(auto_confirm)
File
"/usr/local/anaconda/lib/python2.7/site-packages/pip/req/req_uninstall.py",
line 115, in remove
renames(path, new_path)
File
"/usr/local/anaconda/lib/python2.7/site-packages/pip/utils/__init__.py",
line 267, in renames
shutil.move(old, new)
File "/usr/local/anaconda/lib/python2.7/shutil.py", line 303, in move
os.unlink(src)
OSError: [Errno 13] Permission denied: '/usr/local/anaconda/bin/msnoise'
Again, thanks for your help!
Cheers,
Oscar
On Thu, Jun 15, 2017 at 11:43 AM, Thomas Lecocq <Thomas.Lecocq at seismology.be
> wrote:
> Oscar,
>
> just try:
>
> pip uninstall msnoise
>
> and then
>
> pip install msnoise
>
>
> Cheers,
>
> Tom
>
>
> On 15/06/2017 18:10, Oscar Alberto Castro Artola wrote:
>
>> Dear Lukas,
>>
>> I have tried: *pip install msnoise -U,* but I get this error. Do you know
>> what the problem is?
>>
>> *Collecting msnoise*
>> *Collecting setuptools (from msnoise)*
>> * Using cached setuptools-36.0.1-py2.py3-none-any.whl*
>> *Collecting pymysql (from msnoise)*
>> * Using cached PyMySQL-0.7.11-py2.py3-none-any.whl*
>> *Collecting numpy>=1.0 (from msnoise)*
>> * Downloading numpy-1.13.0-cp27-cp27mu-manylinux1_x86_64.whl (16.6MB)*
>> * 100% |████████████████████████████████| 16.6MB 10kB/s *
>> *Collecting matplotlib (from msnoise)*
>> * Using cached matplotlib-2.0.2-cp27-cp27mu-manylinux1_x86_64.whl*
>> *Requirement already up-to-date: scipy in
>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>> *Collecting jinja2 (from msnoise)*
>> * Using cached Jinja2-2.9.6-py2.py3-none-any.whl*
>> *Requirement already up-to-date: wtforms in
>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>> *Collecting pandas (from msnoise)*
>> * Using cached pandas-0.20.2-cp27-cp27mu-manylinux1_x86_64.whl*
>> *Collecting flask (from msnoise)*
>> * Using cached Flask-0.12.2-py2.py3-none-any.whl*
>> *Collecting sqlalchemy (from msnoise)*
>> *Collecting folium (from msnoise)*
>> * Using cached folium-0.3.0-py2-none-any.whl*
>> *Collecting click (from msnoise)*
>> * Using cached click-6.7-py2.py3-none-any.whl*
>> *Collecting flask-admin (from msnoise)*
>> *Collecting obspy (from msnoise)*
>> *Collecting flask-wtf (from msnoise)*
>> * Using cached Flask_WTF-0.14.2-py2.py3-none-any.whl*
>> *Collecting markdown (from msnoise)*
>> *Requirement already up-to-date: python-dateutil in
>> /usr/local/anaconda/lib/python2.7/site-packages (from
>> matplotlib->msnoise)*
>> *Requirement already up-to-date: subprocess32 in
>> /usr/local/anaconda/lib/python2.7/site-packages (from
>> matplotlib->msnoise)*
>> *Requirement already up-to-date: cycler>=0.10 in
>> /usr/local/anaconda/lib/python2.7/site-packages/cycler-0.10.0-py2.7.egg
>> (from matplotlib->msnoise)*
>> *Requirement already up-to-date: six>=1.10 in
>> /usr/local/anaconda/lib/python2.7/site-packages (from
>> matplotlib->msnoise)*
>> *Requirement already up-to-date: pytz in
>> /usr/local/anaconda/lib/python2.7/site-packages (from
>> matplotlib->msnoise)*
>> *Requirement already up-to-date: functools32 in
>> /usr/local/anaconda/lib/python2.7/site-packages (from
>> matplotlib->msnoise)*
>> *Requirement already up-to-date: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=1.5.6
>> in /usr/local/anaconda/lib/python2.7/site-packages (from
>> matplotlib->msnoise)*
>> *Collecting MarkupSafe>=0.23 (from jinja2->msnoise)*
>> *Collecting Werkzeug>=0.7 (from flask->msnoise)*
>> * Using cached Werkzeug-0.12.2-py2.py3-none-any.whl*
>> *Requirement already up-to-date: itsdangerous>=0.21 in
>> /usr/local/anaconda/lib/python2.7/site-packages (from flask->msnoise)*
>> *Collecting branca (from folium->msnoise)*
>> * Using cached branca-0.2.0-py2-none-any.whl*
>> *Requirement already up-to-date: future>=0.12.4 in
>> /usr/local/anaconda/lib/python2.7/site-packages (from obspy->msnoise)*
>> *Collecting requests (from obspy->msnoise)*
>> * Downloading requests-2.18.1-py2.py3-none-any.whl (88kB)*
>> * 100% |████████████████████████████████| 92kB 4.0MB/s *
>> *Requirement already up-to-date: decorator in
>> /usr/local/anaconda/lib/python2.7/site-packages (from obspy->msnoise)*
>> *Collecting lxml (from obspy->msnoise)*
>> * Using cached lxml-3.8.0-cp27-cp27mu-manylinux1_x86_64.whl*
>> *Collecting chardet<3.1.0,>=3.0.2 (from requests->obspy->msnoise)*
>> * Downloading chardet-3.0.4-py2.py3-none-any.whl (133kB)*
>> * 100% |████████████████████████████████| 143kB 2.5MB/s *
>> *Requirement already up-to-date: certifi>=2017.4.17 in
>> /usr/local/anaconda/lib/python2.7/site-packages (from
>> requests->obspy->msnoise)*
>> *Collecting idna<2.6,>=2.5 (from requests->obspy->msnoise)*
>> * Using cached idna-2.5-py2.py3-none-any.whl*
>> *Collecting urllib3<1.22,>=1.21.1 (from requests->obspy->msnoise)*
>> * Using cached urllib3-1.21.1-py2.py3-none-any.whl*
>> *Installing collected packages: setuptools, pymysql, numpy, matplotlib,
>> MarkupSafe, jinja2, pandas, click, Werkzeug, flask, sqlalchemy, branca,
>> folium, flask-admin, chardet, idna, urllib3, requests, lxml, obspy,
>> flask-wtf, markdown, msnoise*
>> * Found existing installation: setuptools 33.1.1.post20170320*
>> * Uninstalling setuptools-33.1.1.post20170320:*
>> *Exception:*
>> *Traceback (most recent call last):*
>> * File
>> "/usr/local/anaconda/lib/python2.7/site-packages/pip/basecommand.py",
>> line
>> 215, in main*
>> * status = self.run(options, args)*
>> * File
>> "/usr/local/anaconda/lib/python2.7/site-packages/pip/command
>> s/install.py",
>> line 342, in run*
>> * prefix=options.prefix_path,*
>> * File
>> "/usr/local/anaconda/lib/python2.7/site-packages/pip/req/req_set.py",
>> line
>> 778, in install*
>> * requirement.uninstall(auto_confirm=True)*
>> * File
>> "/usr/local/anaconda/lib/python2.7/site-packages/pip/req/req_install.py",
>> line 754, in uninstall*
>> * paths_to_remove.remove(auto_confirm)*
>> * File
>> "/usr/local/anaconda/lib/python2.7/site-packages/pip/req/
>> req_uninstall.py",
>> line 115, in remove*
>> * renames(path, new_path)*
>> * File
>> "/usr/local/anaconda/lib/python2.7/site-packages/pip/utils/__init__.py",
>> line 267, in renames*
>> * shutil.move(old, new)*
>> * File "/usr/local/anaconda/lib/python2.7/shutil.py", line 303, in move*
>> * os.unlink(src)*
>> *OSError: [Errno 13] Permission denied:
>> '/usr/local/anaconda/bin/easy_install'*
>>
>>
>> Thank you very much for your time!
>>
>> Greetings,
>>
>> Oscar
>>
>> On Tue, Jun 6, 2017 at 1:42 AM, Lukas Preiswerk <
>> preiswerk at vaw.baug.ethz.ch>
>> wrote:
>>
>> Oscar,
>>>
>>> I think “pip install msnoise -U” should do the trick (-U is for
>>> —upgrade).
>>>
>>> Lukas
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> 2017-06-02 18:55 GMT+02:00 Oscar Alberto Castro Artola
>>> <oscar.cas.art at gmail.com>:
>>>
>>>> Dear Christos and Lukas,
>>>>
>>>> first of all thanks for you help! I really apreciate it!
>>>>
>>>> Christos: I have a server with 40 cores, so I think the *-t 20* flag is
>>>> working fine!
>>>>
>>>> Lukas: I tried to do a *pip install msnoise*, but I don't think it is
>>>> actually upgrading MSNoise, the output is:
>>>>
>>>> *Requirement already satisfied: msnoise in
>>>> /usr/local/anaconda/lib/python2.7/site-packages*
>>>> *Requirement already satisfied: setuptools in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: numpy>=1.0 in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: scipy in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: pandas in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: matplotlib in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: statsmodels in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: sqlalchemy in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: obspy in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: click in
>>>> /usr/local/anaconda/lib/python2.7/site-packages/click-4.0-py2.7.egg
>>>>
>>> (from
>>>
>>>> msnoise)*
>>>> *Requirement already satisfied: pymysql in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: flask in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: flask-admin in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: multiprocessing_logging in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: markdown in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: folium in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from msnoise)*
>>>> *Requirement already satisfied: six>=1.10 in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from
>>>>
>>> matplotlib->msnoise)*
>>>
>>>> *Requirement already satisfied: python-dateutil in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from
>>>>
>>> matplotlib->msnoise)*
>>>
>>>> *Requirement already satisfied: functools32 in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from
>>>>
>>> matplotlib->msnoise)*
>>>
>>>> *Requirement already satisfied: subprocess32 in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from
>>>>
>>> matplotlib->msnoise)*
>>>
>>>> *Requirement already satisfied: pytz in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from
>>>>
>>> matplotlib->msnoise)*
>>>
>>>> *Requirement already satisfied: cycler>=0.10 in
>>>> /usr/local/anaconda/lib/python2.7/site-packages/cycler-0.10.0-py2.7.egg
>>>> (from matplotlib->msnoise)*
>>>> *Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1
>>>> .6,>=1.5.6
>>>>
>>> in
>>>
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from
>>>>
>>> matplotlib->msnoise)*
>>>
>>>> *Requirement already satisfied: future>=0.12.4 in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from obspy->msnoise)*
>>>> *Requirement already satisfied: lxml in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from obspy->msnoise)*
>>>> *Requirement already satisfied: decorator in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from obspy->msnoise)*
>>>> *Requirement already satisfied: requests in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from obspy->msnoise)*
>>>> *Requirement already satisfied: wtforms in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from
>>>>
>>> flask-admin->msnoise)*
>>>
>>>> *Requirement already satisfied: Jinja2 in
>>>> /usr/local/anaconda/lib/python2.7/site-packages (from folium->msnoise)*
>>>>
>>>> This is the second time I do *msnoise -t 20 compute_mwcs*, last time it
>>>> worked fine but I needed to change *dtt_lag* to "dynamic". So when I
>>>>
>>> tried
>>>
>>>> to rerun* msnoise -t 20 compute_mwcs* with the new parameter this error
>>>> message appears. What I've done is run the process in the morning, all
>>>>
>>> day
>>>
>>>> it works fine, but the next morning I always find that error message.
>>>>
>>>> Thanks again!
>>>>
>>>> Oscar
>>>>
>>>> On Fri, Jun 2, 2017 at 8:39 AM, Lukas Preiswerk <
>>>>
>>> preiswerk at vaw.baug.ethz.ch>
>>>
>>>> wrote:
>>>>
>>>> Hi Oscar
>>>>>
>>>>> The problem is that “MySQL server has gone away”, so it can’t update
>>>>> the database after finishing the MWCS job. We fixed this in the newest
>>>>> version, so you should indeed update.
>>>>>
>>>>> I think that updating is done by “pip install msnoise”, and then for
>>>>> each project “msnoise upgrade_db” (see the release notes
>>>>> http://msnoise.org/doc/releasenotes/msnoise-1.5.html ). Tom can
>>>>> clarify if this method I just described is actually the way to go…
>>>>>
>>>>> Best, Lukas
>>>>>
>>>>>
>>>>>
>>>>> 2017-06-02 15:20 GMT+02:00 Christos Evangelidis <cevan at noa.gr>:
>>>>>
>>>>>> Dear Oscar,
>>>>>>
>>>>>> Can you really run 20 instances of the code (-t 20) ? I find the -t 20
>>>>>> rather high, but your machine might support it..
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Christos
>>>>>>
>>>>>> Στις 1 Ιουν 2017 6:01 μμ, ο χρήστης "Oscar Alberto Castro Artola" <
>>>>>> oscar.cas.art at gmail.com> έγραψε:
>>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I have 10 years of data for 13 stations, I have computed the CCF and
>>>>>>
>>>>> now
>>>
>>>> it
>>>>>
>>>>>> is turn to compute the MWCS. When I do *msnoise -t 20 compute_mwcs
>>>>>>
>>>>> *this
>>>
>>>> error appears:
>>>>>>
>>>>>> *Process Process-4:*
>>>>>> *Traceback (most recent call last):*
>>>>>> * File "/usr/local/anaconda/lib/python2.7/multiprocessing/
>>>>>>
>>>>> process.py",
>>>
>>>> line 258, in _bootstrap*
>>>>>> * self.run()*
>>>>>> * File "/usr/local/anaconda/lib/python2.7/multiprocessing/
>>>>>>
>>>>> process.py",
>>>
>>>> line 114, in run*
>>>>>> * self._target(*self._args, **self._kwargs)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/msnoise/
>>>>>> s05compute_mwcs.py",
>>>>>> line 150, in main*
>>>>>> * update_job(db, day, pair, jobtype='DTT', flag='D')*
>>>>>> * File "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> msnoise/api.py",
>>>>>
>>>>>> line 615, in update_job*
>>>>>> * job = session.query(Job).filter(Job.day == day).filter(Job.pair
>>>>>>
>>>>> ==
>>>
>>>> pair).filter(Job.jobtype == jobtype).first()*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/orm/query.py",
>>>>>
>>>>>> line 2755, in first*
>>>>>> * ret = list(self[0:1])*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/orm/query.py",
>>>>>
>>>>>> line 2547, in __getitem__*
>>>>>> * return list(res)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/orm/query.py",
>>>>>
>>>>>> line 2855, in __iter__*
>>>>>> * return self._execute_and_instances(context)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/orm/query.py",
>>>>>
>>>>>> line 2878, in _execute_and_instances*
>>>>>> * result = conn.execute(querycontext.statement, self._params)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/engine/base.py",
>>>>>
>>>>>> line 945, in execute*
>>>>>> * return meth(self, multiparams, params)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/
>>>>>> sql/elements.py",
>>>>>> line 263, in _execute_on_connection*
>>>>>> * return connection._execute_clauseelement(self, multiparams,
>>>>>>
>>>>> params)*
>>>>>
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/engine/base.py",
>>>>>
>>>>>> line 1053, in _execute_clauseelement*
>>>>>> * compiled_sql, distilled_params*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/engine/base.py",
>>>>>
>>>>>> line 1189, in _execute_context*
>>>>>> * context)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/engine/base.py",
>>>>>
>>>>>> line 1402, in _handle_dbapi_exception*
>>>>>> * exc_info*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/util/compat.py",
>>>>>
>>>>>> line 203, in raise_from_cause*
>>>>>> * reraise(type(exception), exception, tb=exc_tb, cause=cause)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> sqlalchemy/engine/base.py",
>>>>>
>>>>>> line 1182, in _execute_context*
>>>>>> * context)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/sqlalchemy/
>>>>>> engine/default.py",
>>>>>> line 470, in do_execute*
>>>>>> * cursor.execute(statement, parameters)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/pymysql/cursors.py",
>>>>>>
>>>>> line
>>>>>
>>>>>> 158, in execute*
>>>>>> * result = self._query(query)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/pymysql/cursors.py",
>>>>>>
>>>>> line
>>>>>
>>>>>> 308, in _query*
>>>>>> * conn.query(q)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> pymysql/connections.py",
>>>>>
>>>>>> line 819, in query*
>>>>>> * self._execute_command(COMMAND.COM_QUERY, sql)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> pymysql/connections.py",
>>>>>
>>>>>> line 1037, in _execute_command*
>>>>>> * self._write_bytes(packet)*
>>>>>> * File
>>>>>> "/usr/local/anaconda/lib/python2.7/site-packages/
>>>>>>
>>>>> pymysql/connections.py",
>>>>>
>>>>>> line 989, in _write_bytes*
>>>>>> * raise err.OperationalError(2006, "MySQL server has gone away
>>>>>>
>>>>> (%r)" %
>>>
>>>> (e,))*
>>>>>> *OperationalError: (pymysql.err.OperationalError) (2006, "MySQL server
>>>>>>
>>>>> has
>>>>>
>>>>>> gone away (error(32, 'Broken pipe'))") [SQL: u'SELECT jobs.ref AS
>>>>>>
>>>>> jobs_ref,
>>>>>
>>>>>> jobs.day AS jobs_day, jobs.pair AS jobs_pair, jobs.jobtype AS
>>>>>>
>>>>> jobs_jobtype,
>>>>>
>>>>>> jobs.flag AS jobs_flag, jobs.lastmod AS jobs_lastmod \nFROM jobs
>>>>>>
>>>>> \nWHERE
>>>
>>>> jobs.day = %(day_1)s AND jobs.pair = %(pair_1)s AND jobs.jobtype =
>>>>>> %(jobtype_1)s \n LIMIT %(param_1)s'] [parameters: {u'param_1': 1,
>>>>>>
>>>>> u'day_1':
>>>>>
>>>>>> '2009-02-16', u'jobtype_1': 'DTT', u'pair_1': 'IG.ARIG:IG.MOIG'}]*
>>>>>>
>>>>>> At the beginning everything works fine, but because it takes a long
>>>>>>
>>>>> time
>>>
>>>> to
>>>>>
>>>>>> make the computation (around 5 days), every time that I come back to
>>>>>>
>>>>> see
>>>
>>>> the results this happens. I am working with MSNoise 1.4 and I don't
>>>>>>
>>>>> know
>>>
>>>> how to upgrade to MSNoise 1.5.
>>>>>>
>>>>>> Does anyone know how to fix this?
>>>>>>
>>>>>> Thanks in advance!
>>>>>>
>>>>>> Oscar
>>>>>> _______________________________________________
>>>>>> MSNoise mailing list
>>>>>> MSNoise at mailman-as.oma.be
>>>>>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>>>>> _______________________________________________
>>>>>> MSNoise mailing list
>>>>>> MSNoise at mailman-as.oma.be
>>>>>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>>>>>
>>>>> _______________________________________________
>>>>> MSNoise mailing list
>>>>> MSNoise at mailman-as.oma.be
>>>>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>>>>
>>>>> _______________________________________________
>>>> MSNoise mailing list
>>>> MSNoise at mailman-as.oma.be
>>>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>>>
>>> _______________________________________________
>>> MSNoise mailing list
>>> MSNoise at mailman-as.oma.be
>>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>>
>>> _______________________________________________
>> MSNoise mailing list
>> MSNoise at mailman-as.oma.be
>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
> _______________________________________________
> MSNoise mailing list
> MSNoise at mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise
>
More information about the MSNoise
mailing list