Create a SQLite database on TACC

Q&A
, ,
1

I am trying to train a deep learning model in TACC. My project involves creating a sqlite3 database . I get the following error when i try to create a database: (sqlite3.OperationalError) disk I/O error [SQL: PRAGMA table_info("entries")]

To test if there is an issue with my code, I built the project on CentOS (same as TACC) locally and it is running fine. Anyone has insight on why this is the case? I am creating the file in $WORK directory

2

Most likely this is due to the SQLite library requiring certain POSIX features that aren’t available on the Lustre /work file system. I tested to confirm this by trying to create the database file in /tmp/ instead, and it works there. It is likely due to requirements of the SQLite database creation process and not sure if there is a way to disable them.