Project

General

Profile

Actions

Defect #22176

closed

Orphaned attachments

Added by Simone Fratini about 8 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Low
Assignee:
-
Category:
Attachments
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

When you create a new issue and attach one o more files.

If you don't save the issue (for some reason), these attachments are stored in the database and on the filesystem.

mysql> select * from attachments where container_id is null;
+----+--------------+----------------+---------------------+----------------------------------+----------+--------------+----------------------------------+-----------+-----------+---------------------+-------------+----------------+
| id | container_id | container_type | filename            | disk_filename                    | filesize | content_type | digest                           | downloads | author_id | created_on          | description | disk_directory |
+----+--------------+----------------+---------------------+----------------------------------+----------+--------------+----------------------------------+-----------+-----------+---------------------+-------------+----------------+
|  1 |         NULL | NULL           | WP_20160305_001.jpg | 160310184012_WP_20160305_001.jpg |  1335237 |              | 1bd2cb25ae7bf4dc78cdfab19768eac7 |         0 |         1 | 2016-03-10 18:40:13 | NULL        | 2016/03        |
|  2 |         NULL | NULL           | 100_0007-0.JPG      | 160310184902_100_0007-0.JPG      |   170212 |              | 2584dac5daa37440924942d07b169f12 |         0 |         1 | 2016-03-10 18:49:02 | NULL        | 2016/03        |
|  3 |         NULL | NULL           | 100_0007-1.JPG      | 160310184905_100_0007-1.JPG      |   164227 |              | f01fc8e99279e913973484e1dd6d8af1 |         0 |         1 | 2016-03-10 18:49:05 | NULL        | 2016/03        |
+----+--------------+----------------+---------------------+----------------------------------+----------+--------------+----------------------------------+-----------+-----------+---------------------+-------------+----------------+
root@ubuntu:/var/lib/redmine/default/files/2016/03# ll
total 1644
drwxr-xr-x 2 www-data www-data    4096 Mar 10 18:49 ./
drwxr-xr-x 3 www-data www-data    4096 Mar 10 18:40 ../
-rw-r--r-- 1 www-data www-data 1335237 Mar 10 18:40 160310184012_WP_20160305_001.jpg
-rw-r--r-- 1 www-data www-data  170212 Mar 10 18:49 160310184902_100_0007-0.JPG
-rw-r--r-- 1 www-data www-data  164227 Mar 10 18:49 160310184905_100_0007-1.JPG

Related issues

Related to Redmine - Feature #10253: Better handling of attachments when validation failsClosedJean-Philippe Lang

Actions
Actions #1

Updated by Toshi MARUYAMA about 8 years ago

  • Status changed from New to Closed
  • Resolution set to Invalid

This is expected behavior.
You can use "rake redmine:attachments:prune".

Actions #2

Updated by Go MAEDA almost 2 years ago

  • Related to Defect #18572: some problems with file uploader added
Actions #3

Updated by Go MAEDA almost 2 years ago

  • Related to deleted (Defect #18572: some problems with file uploader)
Actions #4

Updated by Go MAEDA almost 2 years ago

  • Related to Feature #10253: Better handling of attachments when validation fails added
Actions

Also available in: Atom PDF