Alter table Failed: DDLPackageProcessor::tokenizeData

5 posts / 0 new
Last post
MrLee
MrLee's picture
Offline
Last seen: 4 days 15 hours ago
Joined: Jul 23 2012
Junior Boarder

Posts: 4

qichen li
Alter table Failed: DDLPackageProcessor::tokenizeData

Hi,

  I create a task which is renamed table by cron.But it has error in err.log.
 
  Apr 25 23:17:32 localhost ddlpackageproc[1548]: 32.062174 |0|0|0| E 23 CAL0001:  
  Alter table Failed:  DDLPackageProcessor::tokenizeData basic_string::_S_construct NULL not valid
  
  I checked the source code.I knew that it would call the tokenizeData function when the column.colType.colWidth  is  greater than 8.Which confused me is that the column.colType.colWidth of my table cosists of many formats,such as int,smallint,bigint,timestamp。
  Can you help me?
radams
radams's picture
Offline
Last seen: 23 hours 56 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Alter table Failed: DDLPackageProcessor::tokenizeData

 

 

Hi,

 

Please post the show create table and the alter table statement for this test.

 

Thanks,

 

Robert

 

 

MrLee
MrLee's picture
Offline
Last seen: 4 days 15 hours ago
Joined: Jul 23 2012
Junior Boarder

Posts: 4

qichen li
Hi,

Hi,

   I rename this table, it has the same error. I drop this table and recreate it, it is ok!

 

show create table t_tbl_2014051600;
+----------------------------------------------+---------------------------------------------------------------+
| Table                                        | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+----------------------------------------------+---------------------------------------------------------------+
| t_tbl_2014051600 | CREATE TABLE `t_tbl_2014051600` (
  `timestamp` datetime DEFAULT NULL,
  `id` smallint(6) DEFAULT NULL,
  `users` int(11) DEFAULT NULL,
  `ing_num` bigint(20) DEFAULT NULL,
  `eng_num` bigint(20) DEFAULT NULL
) ENGINE=InfiniDB DEFAULT CHARSET=utf8 |
+----------------------------------------------+---------------------------------------------------------------+
1 row in set (0.00 sec)
 
rename table t_tbl_2014051600 to t_tbl_2014051700;
 
Alter table Failed:  DDLPackageProcessor::tokenizeData basic_string::_S_construct NULL not valid
 
Thanks!
qichen
radams
radams's picture
Offline
Last seen: 23 hours 56 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
 We do not see any issues

 

We do not see any issues when testing this here.

 

#idbmysql

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12383
Server version: 5.1.73 InfiniDB 4.5.0-1
 
Copyright (c) 2014, InfiniDB, Inc. and/or its affiliates. All rights reserved.
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
 
InfiniDB is a registered trademark of InfiniDB, Inc. and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> create database temp;
Query OK, 1 row affected (0.00 sec)
 
mysql> use temp
Database changed
mysql> CREATE TABLE `t_tbl_2014051600` (
    ->   `timestamp` datetime DEFAULT NULL,
    ->   `id` smallint(6) DEFAULT NULL,
    ->   `users` int(11) DEFAULT NULL,
    ->   `ing_num` bigint(20) DEFAULT NULL,
    ->   `eng_num` bigint(20) DEFAULT NULL
    -> ) ENGINE=InfiniDB DEFAULT CHARSET=utf8;                                                                                                    
Query OK, 0 rows affected (0.33 sec)
 
mysql> rename table t_tbl_2014051600 to t_tbl_2014051700;
Query OK, 0 rows affected (0.18 sec)
 
mysql> show tables;
+------------------+
| Tables_in_temp   |
+------------------+
| t_tbl_2014051700 |
+------------------+
1 row in set (0.00 sec)
 
mysql> 
MrLee
MrLee's picture
Offline
Last seen: 4 days 15 hours ago
Joined: Jul 23 2012
Junior Boarder

Posts: 4

qichen li
Hi,

Hi,

    It happened error after some days。And I can not repair it until dropping and recreating the table。

 

Thanks!

qichen