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

Data truncated for column 'SESSION_USER_AGENT'

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.0, 2.3.1, 2.4.0, 2.4.1, 2.5.0, 2.5.2, 2.5.3
    • Fix Version/s: 2.5.6, 2.6.0
    • Labels:
      None
    • Environment:
      MySQL 4.1.16

      Description

      java.lang.RuntimeException: SqlService.dbWrite failure
      at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:850)
      caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'SESSION_USER_AGENT' at row 1

      (bug report below)
      We have 3 consecutive bug reports like this - I suppose the user didnt' login...

      [From Stephen Marquard]
      This is due to an exceptionally long user-agent:

      Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; SIMBAR Enabled; SIMBAR=

      {7652EBAF-788B-4212-B9A7-099DD3982FF8}

      ; Mozilla/4.0(Compatible Mozilla/4.0(Compatible-EmbeddedWB 14.57 http://bsalsa.com/ EmbeddedWB- 14.57 from: http://bsalsa.com/ ; .NET CLR 1.1.4322)

      265 characters in total.

      Really the session code should either truncate it or SESSION_USER_AGENT should be something larger than varchar(255).

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  nfernandes Nuno Fernandes (Inactive)
                  Reporter:
                  nfernandes Nuno Fernandes (Inactive)
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration