SQLite Forum

no such table error
Login
HI,

I am using RHEL7 with Apache httpd, MariaDB and SQLLite with following versions:

# rpm -qa | grep httpd
httpd-2.4.6-93.el7.x86_64
httpd-tools-2.4.6-93.el7.x86_64

# rpm -qa | grep mariadb
mariadb-5.5.65-1.el7.x86_64
mariadb-server-5.5.65-1.el7.x86_64
mariadb-libs-5.5.65-1.el7.x86_64

# rpm -qa | grep sqlite
sqlite-3.7.17-8.el7.x86_64

These are used as part of my open source cloud platform namely OpenStack (stein). One of my openstack processes namely keystone runs inside httpd. the Keystone processes in turn use python sqlalchemy library to connect to the database.

It is found in 5% of the cases where httpd service is restarted, the new process throws "no such table error". But if the service is restarted, the problem disappears. Is it possible that the root cause here is that when httpd service is restarted, the keystone process inside it is still holding on to the DB connection and before it is released the new process attempts to get the connection, and the new process does not successfully get it due to which it auto creates a DB, which finally leads to this error ?

Some context to this problem can be found at https://bugs.launchpad.net/keystone/+bug/1891019