Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-2396

Checksum checker and bitstream.user_format_description on version 5.0rc2

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 5.0
    • Fix Version/s: 5.0
    • Component/s: DSpace API
    • Labels:
      None
    • Environment:
      Linux CentOS 6.5 distribution, java 1.7
    • Attachments:
      0
    • Comments:
      5
    • Documentation Status:
      Not Required

      Description

      We found a problem after upgrading from dspace 3.2 to dspace 5.0 rc2 (for testing purposes).

      We've tested running:
      /dspace/bin/dspace checker -lp

      the following error occurs when we tested with migrated itens or with new itens:

      dspace log
      --------------------------------------------------

      Bitstream metadata could not be retrieved. ERROR: column bitstream.user_format_description does not exist

      Position: 141

      org.postgresql.util.PSQLException: ERROR: column bitstream.user_format_description does not exist

      Position: 141

      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)

      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)

      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)

      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)

      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

      at org.dspace.checker.BitstreamInfoDAO.findByBitstreamId(BitstreamInfoDAO.java:244)

      at org.dspace.checker.CheckerCommand.checkBitstream(CheckerCommand.java:142)

      at org.dspace.checker.CheckerCommand.process(CheckerCommand.java:119)

      at org.dspace.app.checker.ChecksumChecker.main(ChecksumChecker.java:233)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:606)

      at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:225)

      at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:77)

      checksum checker log
      -------------------------------------------------
      WET - STATEMENT: select bitstream.deleted, bitstream.store_number, bitstream.size_bytes, bitstreamformatregistry.short_description, bitstream.bitstream_id, bitstream.user_format_description, bitstream.internal_id, bitstream.source, bitstream.checksum_algorithm, bitstream.checksum, bitstream.name, most_recent_checksum.last_process_end_date,most_recent_checksum.to_be_processed from bitstream left outer join bitstreamformatregistry on bitstream.bitstream_format_id = bitstreamformatregistry.bitstream_format_id, most_recent_checksum where bitstream.bitstream_id = $1 and bitstream.bitstream_id = most_recent_checksum.bitstream_id

      2015-01-08 00:00:00.299 WET - ERROR: column bitstream.user_format_description does not exist at character 141

      ----------------------------------------------------------------

      We know that some of the columns (one of them is the user_format_description) in the bitstream table are droped in this version of DSpace. We confirmed that after upgrading from 3.2 to 5.0 rc2, in the BD, the column bitstream.user_format_description no longer exists. We think the problem might be with the checker himself.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kevin van de velde Kevin Van de Velde (Atmire)
                Reporter:
                paulo_graca Paulo Graça
                Reviewer:
                Tim Donohue
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: