13.0.15 Cel module update locks up mysql

21

Aren’t they?

mysql> SHOW INDEX FROM cel;
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name       | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| cel   |          0 | PRIMARY        |            1 | id          | A         |      127670 |     NULL | NULL   |      | BTREE      |         |
| cel   |          1 | uniqueid_index |            1 | uniqueid    | A         |       63835 |     NULL | NULL   |      | BTREE      |         |
| cel   |          1 | linkedid_index |            1 | linkedid    | A         |       25534 |     NULL | NULL   |      | BTREE      |         |
| cel   |          1 | cid_num_index  |            1 | cid_num     | A         |         227 |     NULL | NULL   |      | BTREE      |         |
| cel   |          1 | exten_index    |            1 | exten       | A         |           4 |     NULL | NULL   |      | BTREE      |         |
| cel   |          1 | context_index  |            1 | context     | A         |           4 |     NULL | NULL   |      | BTREE      |         |
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
6 rows in set (0.24 sec)
22

Didn’t even notice that. I think drop table is the quickest solution! Again does that matter?

23

If you don’t need the records it’s fine. Might be better to go with a truncate. Doesn’t matter though as the module will add the table back after it’s been dropped.

24

not drop, truncate

truncate table cel;

drop destroys the table, truncate resets it.

25

Yeah but the module creates the table if it doesn’t exist. But good advice I’ll probably truncate.

26

Dont know f i have the same issue but the installation of CEL ver 13.0.22 totally stops

CEL Error.JPG1280×800 78.5 KB

27

This is normal if your cel database is huge as it’s adding new columns. You can run it through the cli. It’ll take just as long but at least you can monitor it.

28

Andrew, thanks read some of the others posts and left it doing its thing, came back to it 2hrs later and it was installed.