Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32528

ERROR 1048 (23000) at line 138: Column 'message' cannot be null

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Not a Bug
    • 10.11.4
    • N/A
    • None
    • Debian GNU/Linux Bookworm

    Description

      Hi,

      We are facing an unclear error message regarding to the following:

      $ head update.sql
      UPDATE tempfeatures SET feadeb=1, feafin=18113, location='1..18113' WHERE numacc='IMGT000171' AND feanum=1;
      UPDATE tempfeatures SET feadeb=18114, feafin=27543, location='18114..27543' WHERE numacc='IMGT000171' AND feanum=9;
      UPDATE tempfeatures SET feadeb=27544, feafin=34020, location='27544..34020' WHERE numacc='IMGT000171' AND feanum=16;
      UPDATE tempfeatures SET feadeb=34021, feafin=40209, location='34021..40209' WHERE numacc='IMGT000171' AND feanum=26;
      UPDATE tempfeatures SET feadeb=40210, feafin=42557, location='40210..42557' WHERE numacc='IMGT000171' AND feanum=33;
      UPDATE tempfeatures SET feadeb=42558, feafin=49034, location='42558..49034' WHERE numacc='IMGT000171' AND feanum=37;
      UPDATE tempfeatures SET feadeb=49035, feafin=55774, location='49035..55774' WHERE numacc='IMGT000171' AND feanum=64;
      UPDATE tempfeatures SET feadeb=55775, feafin=58605, location='55775..58605' WHERE numacc='IMGT000171' AND feanum=71;
      UPDATE tempfeatures SET feadeb=58606, feafin=61350, location='58606..61350' WHERE numacc='IMGT000171' AND feanum=79;
      UPDATE tempfeatures SET feadeb=61351, feafin=66917, location='61351..66917' WHERE numacc='IMGT000171' AND feanum=83;
       
      $ mariadb-show  -t ligmdb_v12 tempfeatures
      Database: ligmdb_v12  Table: tempfeatures
      +------------+----------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
      | Field      | Type                 | Collation          | Null | Key | Default | Extra | Privileges                      | Comment |
      +------------+----------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
      | numacc     | varchar(20)          | utf8mb3_bin        | NO   | PRI |         |       | select,insert,update,references |         |
      | feanum     | smallint(5) unsigned |                    | NO   | PRI |         |       | select,insert,update,references |         |
      | labcode    | int(10) unsigned     |                    | NO   | MUL |         |       | select,insert,update,references |         |
      | feadeb     | int(11) unsigned     |                    | NO   |     |         |       | select,insert,update,references |         |
      | feafin     | int(11) unsigned     |                    | NO   |     |         |       | select,insert,update,references |         |
      | partial    | tinyint(3) unsigned  |                    | NO   |     |         |       | select,insert,update,references |         |
      | phase      | tinyint(3) unsigned  |                    | YES  |     |         |       | select,insert,update,references |         |
      | complement | tinyint(4)           |                    | YES  |     |         |       | select,insert,update,references |         |
      | location   | varchar(80)          | utf8mb4_general_ci | NO   |     |         |       | select,insert,update,references |         |
      +------------+----------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
       
      $ mariadb-show  -i ligmdb_v12 tempfeatures
      Database: ligmdb_v12  Wildcard: tempfeatures
      +--------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
      | Name         | Engine | Version | Row_format | Rows  | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation          | Checksum | Create_options | Comment | Max_index_length | Temporary |
      +--------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
      | tempfeatures | InnoDB | 10      | Dynamic    | 94169 | 82             | 7798784     | 0               | 4276224      | 4194304   |                | 2023-08-11 08:35:25 | 2023-10-20 09:36:34 |            | utf8mb4_general_ci |          |                |         | 0                | N         |
      +--------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
       
      $ mariadb-repair  -a ligmdb_v12 tempfeatures
      ligmdb_v12.tempfeatures                            OK
       
      $ cat update.sql | mariadb ligmdb_v12
      ERROR 1048 (23000) at line 138: Column 'message' cannot be null
       
      $ sed -n 138p update.sql
      UPDATE tempfeatures SET feadeb=1116194, feafin=1115690, location='1116194..-1115690' WHERE numacc='IMGT000171' AND feanum=1542;
      

      Could this be related to the number of the UPDATE statements in the file?

      Regards,
      Patrice

      Attachments

        Activity

          People

            Unassigned Unassigned
            Patrice Patrice Duroux
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.