Unknown SQLite 3.x database swift files
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Fuel for OpenStack |
In Progress
|
Critical
|
Oleksiy Molchanov |
Bug Description
Detailed bug description:
/var/lib/glance is being filled due to frequent temp file(file type - SQLite 3.x database) generation in /var/lib/
root@cic-2:~# du -h --max-depth 1 /var/lib/
236G /var/lib/
232M /var/lib/
224M /var/lib/
39G /var/lib/
0 /var/lib/
82M /var/lib/
275G /var/lib/
root@cic-2:~# du -h --max-depth 1 /var/lib/
289G /var/lib/
234M /var/lib/
207M /var/lib/
40G /var/lib/
0 /var/lib/
1.1G /var/lib/
330G /var/lib/
root@cic-2:~/temp# file /var/lib/
/var/lib/
root@cic-2:~/temp#
root@cic-2:~/temp# sqlite3 /var/lib/
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq name file
--- --------------- -------
0 main /var/lib/
sqlite> .tables
container_info incoming_sync outgoing_sync
container_stat object policy_stat
sqlite>
sqlite>
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE outgoing_sync (
remote_id TEXT UNIQUE,
sync_point INTEGER,
updated_at TEXT DEFAULT 0
);
CREATE TABLE incoming_sync (
remote_id TEXT UNIQUE,
sync_point INTEGER,
updated_at TEXT DEFAULT 0
);
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
INSERT INTO "incoming_sync" VALUES(
Steps to reproduce:
unknown
Expected results:
These files should clear by itself.
Actual result:
Files keeps creating until disk is completely full.
Reproducibility:
unknown
Workaround:
Delete tmp files (without certainty that it is safe).
Impact:
No space left on device
Description of the environment:
Operation system: Ubuntu 14.04
Versions of components: MOS 9+ (code snapshot of August 2018), Mitaka
Network model: Neutron + OVS
Changed in fuel: | |
milestone: | none → 9.x-updates |
assignee: | nobody → MOS Maintenance (mos-maintenance) |
importance: | Undecided → Critical |
status: | New → Confirmed |
tags: | added: customer-found sla2 |
Changed in fuel: | |
assignee: | MOS Maintenance (mos-maintenance) → Oleksiy Molchanov (omolchanov) |
status: | Confirmed → In Progress |
Might be connected with this one: https:/ /bugs.launchpad .net/swift/ +bug/1691566