stratosphereips / StratosphereLinuxIPS

Slips, a free software behavioral Python intrusion prevention system (IDS/IPS) that uses machine learning to detect malicious behaviors in the network traffic. Stratosphere Laboratory, AIC, FEL, CVUT in Prague.
Other
668 stars 165 forks source link

Error in sqlite: database is locked #756

Open AlyaGomaa opened 2 days ago

AlyaGomaa commented 2 days ago

Slips version: 1.0.6 File:CTU-SME-11/CTU-SME-11/Experiment-VM-Linux-Ubuntu2204-1/2023-02-23/raw/2023-02-23-00-01-51-192.168.1.109.pcap Branch: develop Commit: f36318c0d3f27f3b25f3b7d30f81b2d686ff730a


res = self.cursor.fetchall()

sqlite3.InterfaceError: Cursor needed to be reset because of commit/rollback and can no longer be fetched from.

2023/09/01 09:55:06.201900 [SQLiteDB] Error executing query: SELECT * FROM altflows WHERE uid = "CaMwok16y6lsnyEaD8" - database is locked. Query discarded

2023/09/01 09:55:06.235602 [Timeline] Problem on process_flow() line 258

2023/09/01 09:55:06.235814 [Timeline] None

2023/09/01 09:55:40.350600 [SQLiteDB] Error executing query: INSERT OR REPLACE INTO flows (profileid, twid, uid, flow, label, aid) VALUES (?, ?, ?, ?, ?, ?); - database disk image is malformed. Query discarded

2023/09/01 09:56:29.336460 [SQLiteDB] Error executing query: INSERT OR REPLACE INTO flows (profileid, twid, uid, flow, label, aid) VALUES (?, ?, ?, ?, ?, ?); - database is locked. Query discarded

2023/09/01 09:57:05.443009 [SQLiteDB] Error executing query: INSERT OR REPLACE INTO flows (profileid, twid, uid, flow, label, aid) VALUES (?, ?, ?, ?, ?, ?); - database is locked. Query discarded

Created by Alya Gomaa via monday.com integration. 🎉