# Create a SQLite database on TACC

**URL:** <https://ask.cyberinfrastructure.org/t/create-a-sqlite-database-on-tacc/2905>\
**Category:** Q&A\
**Tags:** data, programming-for-hpc, python\
**Created:** [August 15, 2023, 8:23pm UTC](https://ask.cyberinfrastructure.org/t/create-a-sqlite-database-on-tacc/2905 "2023-08-15T20:23:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sohil.shrestha](https://ask.cyberinfrastructure.org/letter_avatar_proxy/v4/letter/s/b77776/32.png) [@sohil.shrestha](https://ask.cyberinfrastructure.org/u/sohil.shrestha)\
**Post date:** [August 15, 2023, 8:23pm UTC](https://ask.cyberinfrastructure.org/t/create-a-sqlite-database-on-tacc/2905/1 "2023-08-15T20:23:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sohil.shrestha](https://ask.cyberinfrastructure.org/letter_avatar_proxy/v4/letter/s/b77776/32.png) [@sohil.shrestha](https://ask.cyberinfrastructure.org/u/sohil.shrestha)\
**Post date:** [August 16, 2023, 4:28pm UTC](https://ask.cyberinfrastructure.org/t/create-a-sqlite-database-on-tacc/2905/2 "2023-08-16T16:28:56Z")

</div>

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.
