Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-1910

Need warning when max upload file size exceeded in mysql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.1.0
    • Labels:
      None
    • Environment:
      WINXP IE
    • Previous Issue Keys:
      SAM-504

      Description

      Sakai - 2.0.0 - Sakai 2.0.0[506121], mysql only

      The 'max_allowed_packet' variable in mysql controls the maximum size of files you can upload in delivery. If you try to upload a file larger than that you get an out of memory exception and the following in logs:

      WARN: forward: javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [Packet for query is too large (1360344 > 1047552). You can change this value on the server by setting the max_allowed_packet' variable.]; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1360344 > 1047552). You can change this value on the server by setting the max_allowed_packet' variable.

      Instead of getting an exception, users should just see a warning message when they exceed the file size limit. How about something like:

      Error: File larger than the (#MB) limit

      if it's possible to list the current limit? Marc, what do you think?

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  marith Margaret Petit (Inactive)
                  Reporter:
                  marith Margaret Petit (Inactive)
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration