Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-1416

exception 'PDOException' with message 'SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'siblings' already exists'

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • translate5 - 2.8.5
    • None
    • None

    Description

      problem

      For filling the materialized view of a table the temporary table siblings for that fill request is created.

      Temporary tables are isolated into the calling request, and the table is deleted after the request, so basically there is no problem with that approach.

      But in some cases (cron job request for example, all batch operations on tasks) multiple segment views for multiple tasks have to be created. Then the the error "exception 'PDOException' with message 'SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'siblings' already exists'" happens.

      solution

      Drop siblings table before creation.

      Attachments

        Activity

          People

            tlauria Thomas Lauria
            tlauria Thomas Lauria
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: