You are viewing a plain text version of this content. The canonical link for it is here.
Posted to infrastructure-issues@apache.org by "Jeff Turner (JIRA)" <ji...@apache.org> on 2010/12/16 09:21:00 UTC

[jira] Created: (INFRA-3291) Lost attachments on ActiveMQ and ServiceMix JIRA issues after JIRA import

Lost attachments on ActiveMQ and ServiceMix JIRA issues after JIRA import
-------------------------------------------------------------------------

                 Key: INFRA-3291
                 URL: https://issues.apache.org/jira/browse/INFRA-3291
             Project: Infrastructure
          Issue Type: Sub-task
      Security Level: public (Regular issues)
          Components: JIRA
            Reporter: Jeff Turner


When we merged the activemq JIRA contents into the main JIRA, it seems that 42 of the 4288 attachments were silently dropped. The files still exist on the filesystem but no longer appear on the JIRA issues. These are the missing attachments:

jira_3135=# select * from (select ji.pkey, f.id ,newid('fileattachment', f.id, false) nid, f.* from subjira.fileattachment f, subjira.jiraissue ji where f.issueid=ji.id ) x where x.nid is null ;
||  pkey   ||  id   || nid ||  id   || issueid ||           mimetype           ||                        filename                        ||          created           || filesize ||       author        ||
|  AMQ-133 | 13403 |     | 13403 |   19310 | application/octet-stream     | jar-versions.diff                                      | 2004-11-20 06:09:06+11     |    44520 | memelet |
|  AMQ-180 | 13891 |     | 13891 |   20477 | application/zip              | amq180-retestinfo.zip                                  | 2005-01-29 17:14:41+11     |    28909 | dennis@bevocal.com |
|  AMQ-88  | 13015 |     | 13015 |   17797 | text/plain                   | StackTrace.txt                                         | 2004-09-16 16:43:15+10     |     1432 | onkar |
|  AMQ-240 | 14262 |     | 14262 |   22199 | application/zip              | activemq-test-log.zip                                  | 2005-04-14 17:39:25+10     |   288175 | johnrsisson |
|  AMQ-161 | 13632 |     | 13632 |   19951 | application/x-zip-compressed | broker-test.zip                                        | 2004-12-18 11:18:10+11     |     8627 | mgaffney |
|  AMQ-129 | 13331 |     | 13331 |   18997 | text/plain                   | trace.log                                              | 2004-11-09 15:18:56+11     |   156557 | mgaffney |
|  AMQ-176 | 13840 |     | 13840 |   20439 | text/plain                   | TEST-org.codehaus.activemq.usecases.DeadLetterTest.txt | 2005-01-21 13:45:39+11     |      723 | chirino |
|  AMQ-242 | 14270 |     | 14270 |   22215 | text/plain                   | activemq.log                                           | 2005-04-15 04:10:09+10     |     7289 | yowmhong |
|  AMQ-240 | 14261 |     | 14261 |   22199 | text/plain                   | ActiveMQMavenOutput.txt                                | 2005-04-14 17:36:41+10     |    18694 | johnrsisson |
|  AMQ-180 | 13906 |     | 13906 |   20477 | application/zip              | clients-scripts-configs.zip                            | 2005-02-02 09:09:45+11     |   131791 | dennis@bevocal.com |
|  AMQ-228 | 14220 |     | 14220 |   22026 | text/plain                   | AMQ-228.patch                                          | 2005-04-08 03:23:49+10     |      465 | skleinei |
|  AMQ-194 | 13982 |     | 13982 |   20827 | application/octet-stream     | JMSSessionStatsImpl.java.dif                           | 2005-02-15 16:53:04+11     |     1676 | dennis@bevocal.com |
|  AMQ-194 | 13980 |     | 13980 |   20827 | application/octet-stream     | StatsImpl.java.dif                                     | 2005-02-15 16:51:48+11     |      862 | dennis@bevocal.com |
|  AMQ-194 | 13983 |     | 13983 |   20827 | application/octet-stream     | JMSConnectionStatsImpl.java.dif                        | 2005-02-15 16:54:03+11     |     1236 | dennis@bevocal.com |
|  AMQ-135 | 13413 |     | 13413 |   19354 | text/plain                   | JmsQueueSendBrowseReceiveTest.txt                      | 2004-11-21 12:47:04+11     |     1654 | aarrgard |
|  AMQ-139 | 13451 |     | 13451 |   19429 | application/x-gzip           | ClusterTest.tar.gz                                     | 2004-11-25 05:36:27+11     |  1933260 | lazerdye |
|  AMQ-242 | 14271 |     | 14271 |   22215 | text/xml                     | activemq.xml                                           | 2005-04-15 04:17:08+10     |     3806 | yowmhong |
|  AMQ-135 | 13412 |     | 13412 |   19354 | text/plain                   | JmsSendReceiveTestSupport.txt                          | 2004-11-21 12:46:51+11     |      801 | aarrgard |
|  AMQ-43  | 12440 |     | 12440 |   16223 | text/plain                   | ClockAndThreadPoolPatch.txt                            | 2004-07-08 17:55:57+10     |     4912 | gianny |
|  AMQ-95  | 13106 |     | 13106 |   18115 | text/plain                   | patch.txt                                              | 2004-09-30 00:22:41+10     |     2252 | daggerrz |
|  AMQ-157 | 13626 |     | 13626 |   19891 | application/x-zip-compressed | activemq-npe.zip                                       | 2004-12-16 13:03:59+11     |  2950525 | mgaffney |
|  AMQ-124 | 13307 |     | 13307 |   18895 | text/plain                   | patch.txt                                              | 2004-11-03 12:55:17+11     |    13833 | mgaffney |
|  AMQ-209 | 14066 |     | 14066 |   21331 | application/x-zip-compressed | test.zip                                               | 2005-03-09 07:05:45+11     |     7910 | franos |
|  AMQ-194 | 13981 |     | 13981 |   20827 | application/octet-stream     | JMSEndpointStatsImpl.java.dif                          | 2005-02-15 16:52:33+11     |     1764 | dennis@bevocal.com |
|  AMQ-183 | 13914 |     | 13914 |   20562 | text/plain                   | patchfile.txt                                          | 2005-02-03 18:45:48+11     |     1588 | johnrsisson |
|  AMQ-242 | 14285 |     | 14285 |   22215 | application/octet-stream     | mysql-ab_jdbc_driver                                   | 2005-04-17 01:17:36+10     |       50 | fritz |
|  AMQ-91  | 13071 |     | 13071 |   18003 | application/x-zip-compressed | cluster-testcase.zip                                   | 2004-09-24 21:58:01+10     |    10495 | aarrgard |
|  AMQ-173 | 13838 |     | 13838 |   20420 | application/zip              | amq173info.zip                                         | 2005-01-20 15:31:21+11     |    12330 | dennis@bevocal.com |
|  AMQ-135 | 13411 |     | 13411 |   19354 | text/plain                   | JmsTopicSendReceiveTest.txt                            | 2004-11-21 12:46:34+11     |     1037 | aarrgard |
|  AMQ-230 | 14224 |     | 14224 |   22056 | text/plain                   | ReliableTcpTest.java                                   | 2005-04-08 17:44:40+10     |     5065 | psmith@apache.org |
|  AMQ-173 | 13854 |     | 13854 |   20420 | application/zip              | amq173info-3.zip                                       | 2005-01-22 08:52:38+11     |     1495 | dennis@bevocal.com |
|  AMQ-183 | 13915 |     | 13915 |   20562 | text/plain                   | patchfile2ndAttempt.txt                                | 2005-02-03 19:21:59+11     |     1586 | johnrsisson |
|  AMQ-129 | 13330 |     | 13330 |   18997 | application/x-zip-compressed | mdb-test.zip                                           | 2004-11-09 15:16:13+11     |     8002 | mgaffney |
|  AMQ-183 | 13928 |     | 13928 |   20562 | text/plain                   | patchfile3rdAttempt.txt                                | 2005-02-07 22:09:23+11     |     1651 | johnrsisson |
|  AMQ-197 | 14251 |     | 14251 |   21027 | text/plain                   | activemq_jtds.txt                                      | 2005-04-13 14:44:44+10     |     4068 | fritz |
|  AMQ-173 | 13839 |     | 13839 |   20420 | application/zip              | amq173info-2.zip                                       | 2005-01-20 16:33:01+11     |    14330 | dennis@bevocal.com |
|  AMQ-121 | 13284 |     | 13284 |   18847 | text/plain                   | patch.txt                                              | 2004-10-30 13:40:21+10     |    21674 | mgaffney |
|  SM-1974 | 19627 |     | 19627 |   33280 | text/plain                   | SM-1974-patch.txt                                      | 2010-09-10 00:09:18.441+10 |     3951 | iocanel |
|  SM-2014 | 19879 |     | 19879 |   33863 | text/plain                   | SM-2014-patch.txt                                      | 2010-11-23 23:09:17.256+11 |     9842 | iocanel |
|  AMQ-137 | 13447 |     | 13447 |   19425 | text/plain                   | ActiveMQTestClientEmbedded.java                        | 2004-11-25 03:06:28+11     |     3901 | hdockter |
|  AMQ-137 | 13446 |     | 13446 |   19425 | text/plain                   | ActiveMQTestServerEmbedded.java                        | 2004-11-25 03:06:07+11     |     3587 | hdockter |
|  AMQ-218 | 14120 |     | 14120 |   21588 | application/x-zip-compressed | testcase.zip                                           | 2005-03-17 23:51:03+11     |     1633 | hdockter |
| (42 rows) |


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Assigned: (INFRA-3291) Lost attachments on ActiveMQ and ServiceMix JIRA issues after JIRA import

Posted by "Jeff Turner (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/INFRA-3291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Turner reassigned INFRA-3291:
----------------------------------

    Assignee: Jeff Turner

> Lost attachments on ActiveMQ and ServiceMix JIRA issues after JIRA import
> -------------------------------------------------------------------------
>
>                 Key: INFRA-3291
>                 URL: https://issues.apache.org/jira/browse/INFRA-3291
>             Project: Infrastructure
>          Issue Type: Sub-task
>      Security Level: public(Regular issues) 
>          Components: JIRA
>            Reporter: Jeff Turner
>            Assignee: Jeff Turner
>
> When we merged the activemq JIRA contents into the main JIRA, it seems that 42 of the 4288 attachments were silently dropped. The files still exist on the filesystem but no longer appear on the JIRA issues. These are the missing attachments:
> jira_3135=# select * from (select ji.pkey, f.id ,newid('fileattachment', f.id, false) nid, f.* from subjira.fileattachment f, subjira.jiraissue ji where f.issueid=ji.id ) x where x.nid is null ;
> ||  pkey   ||  id   || nid ||  id   || issueid ||           mimetype           ||                        filename                        ||          created           || filesize ||       author        ||
> |  AMQ-133 | 13403 |     | 13403 |   19310 | application/octet-stream     | jar-versions.diff                                      | 2004-11-20 06:09:06+11     |    44520 | memelet |
> |  AMQ-180 | 13891 |     | 13891 |   20477 | application/zip              | amq180-retestinfo.zip                                  | 2005-01-29 17:14:41+11     |    28909 | dennis@bevocal.com |
> |  AMQ-88  | 13015 |     | 13015 |   17797 | text/plain                   | StackTrace.txt                                         | 2004-09-16 16:43:15+10     |     1432 | onkar |
> |  AMQ-240 | 14262 |     | 14262 |   22199 | application/zip              | activemq-test-log.zip                                  | 2005-04-14 17:39:25+10     |   288175 | johnrsisson |
> |  AMQ-161 | 13632 |     | 13632 |   19951 | application/x-zip-compressed | broker-test.zip                                        | 2004-12-18 11:18:10+11     |     8627 | mgaffney |
> |  AMQ-129 | 13331 |     | 13331 |   18997 | text/plain                   | trace.log                                              | 2004-11-09 15:18:56+11     |   156557 | mgaffney |
> |  AMQ-176 | 13840 |     | 13840 |   20439 | text/plain                   | TEST-org.codehaus.activemq.usecases.DeadLetterTest.txt | 2005-01-21 13:45:39+11     |      723 | chirino |
> |  AMQ-242 | 14270 |     | 14270 |   22215 | text/plain                   | activemq.log                                           | 2005-04-15 04:10:09+10     |     7289 | yowmhong |
> |  AMQ-240 | 14261 |     | 14261 |   22199 | text/plain                   | ActiveMQMavenOutput.txt                                | 2005-04-14 17:36:41+10     |    18694 | johnrsisson |
> |  AMQ-180 | 13906 |     | 13906 |   20477 | application/zip              | clients-scripts-configs.zip                            | 2005-02-02 09:09:45+11     |   131791 | dennis@bevocal.com |
> |  AMQ-228 | 14220 |     | 14220 |   22026 | text/plain                   | AMQ-228.patch                                          | 2005-04-08 03:23:49+10     |      465 | skleinei |
> |  AMQ-194 | 13982 |     | 13982 |   20827 | application/octet-stream     | JMSSessionStatsImpl.java.dif                           | 2005-02-15 16:53:04+11     |     1676 | dennis@bevocal.com |
> |  AMQ-194 | 13980 |     | 13980 |   20827 | application/octet-stream     | StatsImpl.java.dif                                     | 2005-02-15 16:51:48+11     |      862 | dennis@bevocal.com |
> |  AMQ-194 | 13983 |     | 13983 |   20827 | application/octet-stream     | JMSConnectionStatsImpl.java.dif                        | 2005-02-15 16:54:03+11     |     1236 | dennis@bevocal.com |
> |  AMQ-135 | 13413 |     | 13413 |   19354 | text/plain                   | JmsQueueSendBrowseReceiveTest.txt                      | 2004-11-21 12:47:04+11     |     1654 | aarrgard |
> |  AMQ-139 | 13451 |     | 13451 |   19429 | application/x-gzip           | ClusterTest.tar.gz                                     | 2004-11-25 05:36:27+11     |  1933260 | lazerdye |
> |  AMQ-242 | 14271 |     | 14271 |   22215 | text/xml                     | activemq.xml                                           | 2005-04-15 04:17:08+10     |     3806 | yowmhong |
> |  AMQ-135 | 13412 |     | 13412 |   19354 | text/plain                   | JmsSendReceiveTestSupport.txt                          | 2004-11-21 12:46:51+11     |      801 | aarrgard |
> |  AMQ-43  | 12440 |     | 12440 |   16223 | text/plain                   | ClockAndThreadPoolPatch.txt                            | 2004-07-08 17:55:57+10     |     4912 | gianny |
> |  AMQ-95  | 13106 |     | 13106 |   18115 | text/plain                   | patch.txt                                              | 2004-09-30 00:22:41+10     |     2252 | daggerrz |
> |  AMQ-157 | 13626 |     | 13626 |   19891 | application/x-zip-compressed | activemq-npe.zip                                       | 2004-12-16 13:03:59+11     |  2950525 | mgaffney |
> |  AMQ-124 | 13307 |     | 13307 |   18895 | text/plain                   | patch.txt                                              | 2004-11-03 12:55:17+11     |    13833 | mgaffney |
> |  AMQ-209 | 14066 |     | 14066 |   21331 | application/x-zip-compressed | test.zip                                               | 2005-03-09 07:05:45+11     |     7910 | franos |
> |  AMQ-194 | 13981 |     | 13981 |   20827 | application/octet-stream     | JMSEndpointStatsImpl.java.dif                          | 2005-02-15 16:52:33+11     |     1764 | dennis@bevocal.com |
> |  AMQ-183 | 13914 |     | 13914 |   20562 | text/plain                   | patchfile.txt                                          | 2005-02-03 18:45:48+11     |     1588 | johnrsisson |
> |  AMQ-242 | 14285 |     | 14285 |   22215 | application/octet-stream     | mysql-ab_jdbc_driver                                   | 2005-04-17 01:17:36+10     |       50 | fritz |
> |  AMQ-91  | 13071 |     | 13071 |   18003 | application/x-zip-compressed | cluster-testcase.zip                                   | 2004-09-24 21:58:01+10     |    10495 | aarrgard |
> |  AMQ-173 | 13838 |     | 13838 |   20420 | application/zip              | amq173info.zip                                         | 2005-01-20 15:31:21+11     |    12330 | dennis@bevocal.com |
> |  AMQ-135 | 13411 |     | 13411 |   19354 | text/plain                   | JmsTopicSendReceiveTest.txt                            | 2004-11-21 12:46:34+11     |     1037 | aarrgard |
> |  AMQ-230 | 14224 |     | 14224 |   22056 | text/plain                   | ReliableTcpTest.java                                   | 2005-04-08 17:44:40+10     |     5065 | psmith@apache.org |
> |  AMQ-173 | 13854 |     | 13854 |   20420 | application/zip              | amq173info-3.zip                                       | 2005-01-22 08:52:38+11     |     1495 | dennis@bevocal.com |
> |  AMQ-183 | 13915 |     | 13915 |   20562 | text/plain                   | patchfile2ndAttempt.txt                                | 2005-02-03 19:21:59+11     |     1586 | johnrsisson |
> |  AMQ-129 | 13330 |     | 13330 |   18997 | application/x-zip-compressed | mdb-test.zip                                           | 2004-11-09 15:16:13+11     |     8002 | mgaffney |
> |  AMQ-183 | 13928 |     | 13928 |   20562 | text/plain                   | patchfile3rdAttempt.txt                                | 2005-02-07 22:09:23+11     |     1651 | johnrsisson |
> |  AMQ-197 | 14251 |     | 14251 |   21027 | text/plain                   | activemq_jtds.txt                                      | 2005-04-13 14:44:44+10     |     4068 | fritz |
> |  AMQ-173 | 13839 |     | 13839 |   20420 | application/zip              | amq173info-2.zip                                       | 2005-01-20 16:33:01+11     |    14330 | dennis@bevocal.com |
> |  AMQ-121 | 13284 |     | 13284 |   18847 | text/plain                   | patch.txt                                              | 2004-10-30 13:40:21+10     |    21674 | mgaffney |
> |  SM-1974 | 19627 |     | 19627 |   33280 | text/plain                   | SM-1974-patch.txt                                      | 2010-09-10 00:09:18.441+10 |     3951 | iocanel |
> |  SM-2014 | 19879 |     | 19879 |   33863 | text/plain                   | SM-2014-patch.txt                                      | 2010-11-23 23:09:17.256+11 |     9842 | iocanel |
> |  AMQ-137 | 13447 |     | 13447 |   19425 | text/plain                   | ActiveMQTestClientEmbedded.java                        | 2004-11-25 03:06:28+11     |     3901 | hdockter |
> |  AMQ-137 | 13446 |     | 13446 |   19425 | text/plain                   | ActiveMQTestServerEmbedded.java                        | 2004-11-25 03:06:07+11     |     3587 | hdockter |
> |  AMQ-218 | 14120 |     | 14120 |   21588 | application/x-zip-compressed | testcase.zip                                           | 2005-03-17 23:51:03+11     |     1633 | hdockter |
> | (42 rows) |

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (INFRA-3291) Lost attachments on ActiveMQ and ServiceMix JIRA issues after JIRA import

Posted by "Jeff Turner (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/INFRA-3291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Turner resolved INFRA-3291.
--------------------------------

    Resolution: Won't Fix

On further inspection, the files on disk associated with these database records are missing, which would explain why the JIRA project importer didn't preserve them. They're not in our oldest backups so however they were lost, I'm afraid they're probably gone for good.

> Lost attachments on ActiveMQ and ServiceMix JIRA issues after JIRA import
> -------------------------------------------------------------------------
>
>                 Key: INFRA-3291
>                 URL: https://issues.apache.org/jira/browse/INFRA-3291
>             Project: Infrastructure
>          Issue Type: Sub-task
>      Security Level: public(Regular issues) 
>          Components: JIRA
>            Reporter: Jeff Turner
>            Assignee: Jeff Turner
>
> When we merged the activemq JIRA contents into the main JIRA, it seems that 42 of the 4288 attachments were silently dropped. The files still exist on the filesystem but no longer appear on the JIRA issues. These are the missing attachments:
> jira_3135=# select * from (select ji.pkey, f.id ,newid('fileattachment', f.id, false) nid, f.* from subjira.fileattachment f, subjira.jiraissue ji where f.issueid=ji.id ) x where x.nid is null ;
> ||  pkey   ||  id   || nid ||  id   || issueid ||           mimetype           ||                        filename                        ||          created           || filesize ||       author        ||
> |  AMQ-133 | 13403 |     | 13403 |   19310 | application/octet-stream     | jar-versions.diff                                      | 2004-11-20 06:09:06+11     |    44520 | memelet |
> |  AMQ-180 | 13891 |     | 13891 |   20477 | application/zip              | amq180-retestinfo.zip                                  | 2005-01-29 17:14:41+11     |    28909 | dennis@bevocal.com |
> |  AMQ-88  | 13015 |     | 13015 |   17797 | text/plain                   | StackTrace.txt                                         | 2004-09-16 16:43:15+10     |     1432 | onkar |
> |  AMQ-240 | 14262 |     | 14262 |   22199 | application/zip              | activemq-test-log.zip                                  | 2005-04-14 17:39:25+10     |   288175 | johnrsisson |
> |  AMQ-161 | 13632 |     | 13632 |   19951 | application/x-zip-compressed | broker-test.zip                                        | 2004-12-18 11:18:10+11     |     8627 | mgaffney |
> |  AMQ-129 | 13331 |     | 13331 |   18997 | text/plain                   | trace.log                                              | 2004-11-09 15:18:56+11     |   156557 | mgaffney |
> |  AMQ-176 | 13840 |     | 13840 |   20439 | text/plain                   | TEST-org.codehaus.activemq.usecases.DeadLetterTest.txt | 2005-01-21 13:45:39+11     |      723 | chirino |
> |  AMQ-242 | 14270 |     | 14270 |   22215 | text/plain                   | activemq.log                                           | 2005-04-15 04:10:09+10     |     7289 | yowmhong |
> |  AMQ-240 | 14261 |     | 14261 |   22199 | text/plain                   | ActiveMQMavenOutput.txt                                | 2005-04-14 17:36:41+10     |    18694 | johnrsisson |
> |  AMQ-180 | 13906 |     | 13906 |   20477 | application/zip              | clients-scripts-configs.zip                            | 2005-02-02 09:09:45+11     |   131791 | dennis@bevocal.com |
> |  AMQ-228 | 14220 |     | 14220 |   22026 | text/plain                   | AMQ-228.patch                                          | 2005-04-08 03:23:49+10     |      465 | skleinei |
> |  AMQ-194 | 13982 |     | 13982 |   20827 | application/octet-stream     | JMSSessionStatsImpl.java.dif                           | 2005-02-15 16:53:04+11     |     1676 | dennis@bevocal.com |
> |  AMQ-194 | 13980 |     | 13980 |   20827 | application/octet-stream     | StatsImpl.java.dif                                     | 2005-02-15 16:51:48+11     |      862 | dennis@bevocal.com |
> |  AMQ-194 | 13983 |     | 13983 |   20827 | application/octet-stream     | JMSConnectionStatsImpl.java.dif                        | 2005-02-15 16:54:03+11     |     1236 | dennis@bevocal.com |
> |  AMQ-135 | 13413 |     | 13413 |   19354 | text/plain                   | JmsQueueSendBrowseReceiveTest.txt                      | 2004-11-21 12:47:04+11     |     1654 | aarrgard |
> |  AMQ-139 | 13451 |     | 13451 |   19429 | application/x-gzip           | ClusterTest.tar.gz                                     | 2004-11-25 05:36:27+11     |  1933260 | lazerdye |
> |  AMQ-242 | 14271 |     | 14271 |   22215 | text/xml                     | activemq.xml                                           | 2005-04-15 04:17:08+10     |     3806 | yowmhong |
> |  AMQ-135 | 13412 |     | 13412 |   19354 | text/plain                   | JmsSendReceiveTestSupport.txt                          | 2004-11-21 12:46:51+11     |      801 | aarrgard |
> |  AMQ-43  | 12440 |     | 12440 |   16223 | text/plain                   | ClockAndThreadPoolPatch.txt                            | 2004-07-08 17:55:57+10     |     4912 | gianny |
> |  AMQ-95  | 13106 |     | 13106 |   18115 | text/plain                   | patch.txt                                              | 2004-09-30 00:22:41+10     |     2252 | daggerrz |
> |  AMQ-157 | 13626 |     | 13626 |   19891 | application/x-zip-compressed | activemq-npe.zip                                       | 2004-12-16 13:03:59+11     |  2950525 | mgaffney |
> |  AMQ-124 | 13307 |     | 13307 |   18895 | text/plain                   | patch.txt                                              | 2004-11-03 12:55:17+11     |    13833 | mgaffney |
> |  AMQ-209 | 14066 |     | 14066 |   21331 | application/x-zip-compressed | test.zip                                               | 2005-03-09 07:05:45+11     |     7910 | franos |
> |  AMQ-194 | 13981 |     | 13981 |   20827 | application/octet-stream     | JMSEndpointStatsImpl.java.dif                          | 2005-02-15 16:52:33+11     |     1764 | dennis@bevocal.com |
> |  AMQ-183 | 13914 |     | 13914 |   20562 | text/plain                   | patchfile.txt                                          | 2005-02-03 18:45:48+11     |     1588 | johnrsisson |
> |  AMQ-242 | 14285 |     | 14285 |   22215 | application/octet-stream     | mysql-ab_jdbc_driver                                   | 2005-04-17 01:17:36+10     |       50 | fritz |
> |  AMQ-91  | 13071 |     | 13071 |   18003 | application/x-zip-compressed | cluster-testcase.zip                                   | 2004-09-24 21:58:01+10     |    10495 | aarrgard |
> |  AMQ-173 | 13838 |     | 13838 |   20420 | application/zip              | amq173info.zip                                         | 2005-01-20 15:31:21+11     |    12330 | dennis@bevocal.com |
> |  AMQ-135 | 13411 |     | 13411 |   19354 | text/plain                   | JmsTopicSendReceiveTest.txt                            | 2004-11-21 12:46:34+11     |     1037 | aarrgard |
> |  AMQ-230 | 14224 |     | 14224 |   22056 | text/plain                   | ReliableTcpTest.java                                   | 2005-04-08 17:44:40+10     |     5065 | psmith@apache.org |
> |  AMQ-173 | 13854 |     | 13854 |   20420 | application/zip              | amq173info-3.zip                                       | 2005-01-22 08:52:38+11     |     1495 | dennis@bevocal.com |
> |  AMQ-183 | 13915 |     | 13915 |   20562 | text/plain                   | patchfile2ndAttempt.txt                                | 2005-02-03 19:21:59+11     |     1586 | johnrsisson |
> |  AMQ-129 | 13330 |     | 13330 |   18997 | application/x-zip-compressed | mdb-test.zip                                           | 2004-11-09 15:16:13+11     |     8002 | mgaffney |
> |  AMQ-183 | 13928 |     | 13928 |   20562 | text/plain                   | patchfile3rdAttempt.txt                                | 2005-02-07 22:09:23+11     |     1651 | johnrsisson |
> |  AMQ-197 | 14251 |     | 14251 |   21027 | text/plain                   | activemq_jtds.txt                                      | 2005-04-13 14:44:44+10     |     4068 | fritz |
> |  AMQ-173 | 13839 |     | 13839 |   20420 | application/zip              | amq173info-2.zip                                       | 2005-01-20 16:33:01+11     |    14330 | dennis@bevocal.com |
> |  AMQ-121 | 13284 |     | 13284 |   18847 | text/plain                   | patch.txt                                              | 2004-10-30 13:40:21+10     |    21674 | mgaffney |
> |  SM-1974 | 19627 |     | 19627 |   33280 | text/plain                   | SM-1974-patch.txt                                      | 2010-09-10 00:09:18.441+10 |     3951 | iocanel |
> |  SM-2014 | 19879 |     | 19879 |   33863 | text/plain                   | SM-2014-patch.txt                                      | 2010-11-23 23:09:17.256+11 |     9842 | iocanel |
> |  AMQ-137 | 13447 |     | 13447 |   19425 | text/plain                   | ActiveMQTestClientEmbedded.java                        | 2004-11-25 03:06:28+11     |     3901 | hdockter |
> |  AMQ-137 | 13446 |     | 13446 |   19425 | text/plain                   | ActiveMQTestServerEmbedded.java                        | 2004-11-25 03:06:07+11     |     3587 | hdockter |
> |  AMQ-218 | 14120 |     | 14120 |   21588 | application/x-zip-compressed | testcase.zip                                           | 2005-03-17 23:51:03+11     |     1633 | hdockter |
> | (42 rows) |

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] [Closed] (INFRA-3291) Lost attachments on ActiveMQ and ServiceMix JIRA issues after JIRA import

Posted by "#asfinfra IRC Bot (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/INFRA-3291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

#asfinfra IRC Bot closed INFRA-3291.
------------------------------------

    
> Lost attachments on ActiveMQ and ServiceMix JIRA issues after JIRA import
> -------------------------------------------------------------------------
>
>                 Key: INFRA-3291
>                 URL: https://issues.apache.org/jira/browse/INFRA-3291
>             Project: Infrastructure
>          Issue Type: Sub-task
>      Security Level: public(Regular issues) 
>          Components: JIRA
>            Reporter: Jeff Turner
>            Assignee: Jeff Turner
>
> When we merged the activemq JIRA contents into the main JIRA, it seems that 42 of the 4288 attachments were silently dropped. The files still exist on the filesystem but no longer appear on the JIRA issues. These are the missing attachments:
> jira_3135=# select * from (select ji.pkey, f.id ,newid('fileattachment', f.id, false) nid, f.* from subjira.fileattachment f, subjira.jiraissue ji where f.issueid=ji.id ) x where x.nid is null ;
> ||  pkey   ||  id   || nid ||  id   || issueid ||           mimetype           ||                        filename                        ||          created           || filesize ||       author        ||
> |  AMQ-133 | 13403 |     | 13403 |   19310 | application/octet-stream     | jar-versions.diff                                      | 2004-11-20 06:09:06+11     |    44520 | memelet |
> |  AMQ-180 | 13891 |     | 13891 |   20477 | application/zip              | amq180-retestinfo.zip                                  | 2005-01-29 17:14:41+11     |    28909 | dennis@bevocal.com |
> |  AMQ-88  | 13015 |     | 13015 |   17797 | text/plain                   | StackTrace.txt                                         | 2004-09-16 16:43:15+10     |     1432 | onkar |
> |  AMQ-240 | 14262 |     | 14262 |   22199 | application/zip              | activemq-test-log.zip                                  | 2005-04-14 17:39:25+10     |   288175 | johnrsisson |
> |  AMQ-161 | 13632 |     | 13632 |   19951 | application/x-zip-compressed | broker-test.zip                                        | 2004-12-18 11:18:10+11     |     8627 | mgaffney |
> |  AMQ-129 | 13331 |     | 13331 |   18997 | text/plain                   | trace.log                                              | 2004-11-09 15:18:56+11     |   156557 | mgaffney |
> |  AMQ-176 | 13840 |     | 13840 |   20439 | text/plain                   | TEST-org.codehaus.activemq.usecases.DeadLetterTest.txt | 2005-01-21 13:45:39+11     |      723 | chirino |
> |  AMQ-242 | 14270 |     | 14270 |   22215 | text/plain                   | activemq.log                                           | 2005-04-15 04:10:09+10     |     7289 | yowmhong |
> |  AMQ-240 | 14261 |     | 14261 |   22199 | text/plain                   | ActiveMQMavenOutput.txt                                | 2005-04-14 17:36:41+10     |    18694 | johnrsisson |
> |  AMQ-180 | 13906 |     | 13906 |   20477 | application/zip              | clients-scripts-configs.zip                            | 2005-02-02 09:09:45+11     |   131791 | dennis@bevocal.com |
> |  AMQ-228 | 14220 |     | 14220 |   22026 | text/plain                   | AMQ-228.patch                                          | 2005-04-08 03:23:49+10     |      465 | skleinei |
> |  AMQ-194 | 13982 |     | 13982 |   20827 | application/octet-stream     | JMSSessionStatsImpl.java.dif                           | 2005-02-15 16:53:04+11     |     1676 | dennis@bevocal.com |
> |  AMQ-194 | 13980 |     | 13980 |   20827 | application/octet-stream     | StatsImpl.java.dif                                     | 2005-02-15 16:51:48+11     |      862 | dennis@bevocal.com |
> |  AMQ-194 | 13983 |     | 13983 |   20827 | application/octet-stream     | JMSConnectionStatsImpl.java.dif                        | 2005-02-15 16:54:03+11     |     1236 | dennis@bevocal.com |
> |  AMQ-135 | 13413 |     | 13413 |   19354 | text/plain                   | JmsQueueSendBrowseReceiveTest.txt                      | 2004-11-21 12:47:04+11     |     1654 | aarrgard |
> |  AMQ-139 | 13451 |     | 13451 |   19429 | application/x-gzip           | ClusterTest.tar.gz                                     | 2004-11-25 05:36:27+11     |  1933260 | lazerdye |
> |  AMQ-242 | 14271 |     | 14271 |   22215 | text/xml                     | activemq.xml                                           | 2005-04-15 04:17:08+10     |     3806 | yowmhong |
> |  AMQ-135 | 13412 |     | 13412 |   19354 | text/plain                   | JmsSendReceiveTestSupport.txt                          | 2004-11-21 12:46:51+11     |      801 | aarrgard |
> |  AMQ-43  | 12440 |     | 12440 |   16223 | text/plain                   | ClockAndThreadPoolPatch.txt                            | 2004-07-08 17:55:57+10     |     4912 | gianny |
> |  AMQ-95  | 13106 |     | 13106 |   18115 | text/plain                   | patch.txt                                              | 2004-09-30 00:22:41+10     |     2252 | daggerrz |
> |  AMQ-157 | 13626 |     | 13626 |   19891 | application/x-zip-compressed | activemq-npe.zip                                       | 2004-12-16 13:03:59+11     |  2950525 | mgaffney |
> |  AMQ-124 | 13307 |     | 13307 |   18895 | text/plain                   | patch.txt                                              | 2004-11-03 12:55:17+11     |    13833 | mgaffney |
> |  AMQ-209 | 14066 |     | 14066 |   21331 | application/x-zip-compressed | test.zip                                               | 2005-03-09 07:05:45+11     |     7910 | franos |
> |  AMQ-194 | 13981 |     | 13981 |   20827 | application/octet-stream     | JMSEndpointStatsImpl.java.dif                          | 2005-02-15 16:52:33+11     |     1764 | dennis@bevocal.com |
> |  AMQ-183 | 13914 |     | 13914 |   20562 | text/plain                   | patchfile.txt                                          | 2005-02-03 18:45:48+11     |     1588 | johnrsisson |
> |  AMQ-242 | 14285 |     | 14285 |   22215 | application/octet-stream     | mysql-ab_jdbc_driver                                   | 2005-04-17 01:17:36+10     |       50 | fritz |
> |  AMQ-91  | 13071 |     | 13071 |   18003 | application/x-zip-compressed | cluster-testcase.zip                                   | 2004-09-24 21:58:01+10     |    10495 | aarrgard |
> |  AMQ-173 | 13838 |     | 13838 |   20420 | application/zip              | amq173info.zip                                         | 2005-01-20 15:31:21+11     |    12330 | dennis@bevocal.com |
> |  AMQ-135 | 13411 |     | 13411 |   19354 | text/plain                   | JmsTopicSendReceiveTest.txt                            | 2004-11-21 12:46:34+11     |     1037 | aarrgard |
> |  AMQ-230 | 14224 |     | 14224 |   22056 | text/plain                   | ReliableTcpTest.java                                   | 2005-04-08 17:44:40+10     |     5065 | psmith@apache.org |
> |  AMQ-173 | 13854 |     | 13854 |   20420 | application/zip              | amq173info-3.zip                                       | 2005-01-22 08:52:38+11     |     1495 | dennis@bevocal.com |
> |  AMQ-183 | 13915 |     | 13915 |   20562 | text/plain                   | patchfile2ndAttempt.txt                                | 2005-02-03 19:21:59+11     |     1586 | johnrsisson |
> |  AMQ-129 | 13330 |     | 13330 |   18997 | application/x-zip-compressed | mdb-test.zip                                           | 2004-11-09 15:16:13+11     |     8002 | mgaffney |
> |  AMQ-183 | 13928 |     | 13928 |   20562 | text/plain                   | patchfile3rdAttempt.txt                                | 2005-02-07 22:09:23+11     |     1651 | johnrsisson |
> |  AMQ-197 | 14251 |     | 14251 |   21027 | text/plain                   | activemq_jtds.txt                                      | 2005-04-13 14:44:44+10     |     4068 | fritz |
> |  AMQ-173 | 13839 |     | 13839 |   20420 | application/zip              | amq173info-2.zip                                       | 2005-01-20 16:33:01+11     |    14330 | dennis@bevocal.com |
> |  AMQ-121 | 13284 |     | 13284 |   18847 | text/plain                   | patch.txt                                              | 2004-10-30 13:40:21+10     |    21674 | mgaffney |
> |  SM-1974 | 19627 |     | 19627 |   33280 | text/plain                   | SM-1974-patch.txt                                      | 2010-09-10 00:09:18.441+10 |     3951 | iocanel |
> |  SM-2014 | 19879 |     | 19879 |   33863 | text/plain                   | SM-2014-patch.txt                                      | 2010-11-23 23:09:17.256+11 |     9842 | iocanel |
> |  AMQ-137 | 13447 |     | 13447 |   19425 | text/plain                   | ActiveMQTestClientEmbedded.java                        | 2004-11-25 03:06:28+11     |     3901 | hdockter |
> |  AMQ-137 | 13446 |     | 13446 |   19425 | text/plain                   | ActiveMQTestServerEmbedded.java                        | 2004-11-25 03:06:07+11     |     3587 | hdockter |
> |  AMQ-218 | 14120 |     | 14120 |   21588 | application/x-zip-compressed | testcase.zip                                           | 2005-03-17 23:51:03+11     |     1633 | hdockter |
> | (42 rows) |

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira