[Halld-offline] how to make ccdb.sqlite?

[Sean Dobbs]

Matt,

This is weird - I can create the file just fine on the scratch disk, but I
seem similar errors to you when running it on the volatile disk.  I'm not
sure why that would be the case.

BTW, the file I created is at
  /lustre/expphy/volatile/halld/home/sdobbs/ccdb_test/ccdb.sqlite
if you want to try it out.


Cheers,
Sean

On Mon, Dec 8, 2014 at 2:02 PM, Shepherd, Matthew <mashephe at indiana.edu>
wrote:

>
> Sean,
>
> I still can't get it to work:
>
> shepherd at ifarm1101> pwd
> /lustre/expphy/volatile/halld/home/shepherd/testing
>
> shepherd at ifarm1101> $CCDB_HOME/scripts/mysql2sqlite/mysql2sqlite.sh -
> hhalldweb1.jlab.org -uccdb_user | sqlite3 ccdb.sqlite
> Error: near line 1: disk I/O error
> memory
>
> shepherd at ifarm1101> ls -lh
> total 226M
> -rw-r--r-- 1 shepherd halld-1    0 Dec  8 15:01 ccdb.sqlite
> -rw-r--r-- 1 shepherd halld-1 226M Dec  8 13:08 fcal_test.root
>
> -Matt
>
> ---------------------------------------------------------------------
> Matthew Shepherd, Associate Professor
> Department of Physics, Indiana University, Swain West 265
> 727 East Third Street, Bloomington, IN 47405
>
> Office Phone:  +1 812 856 5808
>
> > On Dec 8, 2014, at 2:57 PM, Sean Dobbs <s-dobbs at northwestern.edu> wrote:
> >
> > Hi Matt,
> >
> > That command works fine for me - you do need to keep the user as
> "ccdb_user".
> >
> > I'd suggest running the command when your current directory is in
> somewhere besides your home directory - maybe the volatile or scratch
> disks?  the CCDB keeps on getting larger, and you might be running out of
> disk space wherever you were running that command.
> >
> > Cheers,
> > Sean
> >
> > On Mon, Dec 8, 2014 at 1:50 PM, Shepherd, Matthew <mashephe at indiana.edu>
> wrote:
> >
> > Hi all,
> >
> > I'd like to make a ccdb.sqlite file.  This page:
> >
> >
> https://halldweb1.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database
> >
> > Says that I need to run this command:
> >
> > $CCDB_HOME/scripts/mysql2sqlite/mysql2sqlite.sh -hhalldweb1.jlab.org
> -uccdb_user ccdb | sqlite3 ccdb.sqlite
> >
> > I tried this replacing ccdb_user with anonymous:
> >
> > shepherd at ifarm1101> $CCDB_HOME/scripts/mysql2sqlite/mysql2sqlite.sh -
> hhalldweb1.jlab.org -uanonymous | sqlite3 ccdb.sqlite
> > Error: near line 1: disk I/O error
> > memory
> >
> > Is this the correct command?  Does anyone know
> > what the problem is?
> >
> > Thanks in advance,
> >
> > Matt
> >
> > ---------------------------------------------------------------------
> > Matthew Shepherd, Associate Professor
> > Department of Physics, Indiana University, Swain West 265
> > 727 East Third Street, Bloomington, IN 47405
> >
> > Office Phone:  +1 812 856 5808
> >
> >
> > _______________________________________________
> > Halld-offline mailing list
> > Halld-offline at jlab.org
> > https://mailman.jlab.org/mailman/listinfo/halld-offline
> >
> >
> >
> > --
> > Sean Dobbs
> > Department of Physics & Astronomy
> > Northwestern University
> > phone: 847-467-2826
>
>


-- 
Sean Dobbs
Department of Physics & Astronomy
Northwestern University
phone: 847-467-2826
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mailman.jlab.org/pipermail/halld-offline/attachments/20141208/44bebfaf/attachment-0001.html