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

[Shepherd, Matthew]

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