Skip to Content
1
Jul 31, 2018 at 03:57 PM

Hybris 6.6 carts43sn table is too big. What is it used for

324 Views

We've found that table carts43sn is very big. It contains 16x more rows than cart table.

Where is it used and how can I clear it?

 enter code heremysql> desc carts43sn;
 +------------------+--------------+------+-----+---------+----------------+
 | Field            | Type         | Null | Key | Default | Extra          |
 +------------------+--------------+------+-----+---------+----------------+
 | ID               | bigint(20)   | NO   | PRI | NULL    | auto_increment |
 | ITEMPK           | bigint(20)   | YES  | MUL | NULL    |                |
 | ITEMTYPEPK       | bigint(20)   | YES  |     | NULL    |                |
 | timestamp        | datetime(6)  | YES  |     | NULL    |                |
 | currenttimestamp | datetime(6)  | YES  |     | NULL    |                |
 | changinguser     | varchar(255) | YES  |     | NULL    |                |
 | context          | longtext     | YES  |     | NULL    |                |
 | payloadbefore    | longtext     | YES  |     | NULL    |                |
 | payloadafter     | longtext     | YES  |     | NULL    |                |
 | operationtype    | bigint(20)   | YES  |     | NULL    |                |
 +------------------+--------------+------+-----+---------+----------------+
 
 mysql> select * from carts43sn limit 1\G
 *************************** 1. row ***************************
               ID: 1
           ITEMPK: 8806939263019
       ITEMTYPEPK: 8796094038098
        timestamp: 2018-03-21 13:47:03.711000
 currenttimestamp: 2018-03-21 13:47:03.770000
     changinguser: testkuser+_20171222131724@gmail.com
          context: {}
    payloadbefore: {"mapBasedAttributes":{},"attributes":{},"locAttributes":{}}
     payloadafter: {"mapBasedAttributes":{},"attributes":{"date":{"type":{"type":"java.util.Date","collection":""},"value":["1521636423546"]},"code":{"type":{"type":"java.lang.String","collection":""},"value":["200449000"]},"paymentcost":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"totalprice":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"totaltaxvaluesinternal":{"type":{"type":"java.lang.String","collection":""},"value":["[]"]},"discountsincludepaymentcost":{"type":{"type":"java.lang.Boolean","collection":""},"value":["false"]},"deliverycost":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"discountsincludedeliverycost":{"type":{"type":"java.lang.Boolean","collection":""},"value":["false"]},"totaltax":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"modifiedtime":{"type":{"type":"java.util.Date","collection":""},"value":["1521636423711"]},"itemtype":{"type":{"type":"de.hybris.platform.core.PK","collection":""},"value":["8796094038098"]},"subtotal":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"guid":{"type":{"type":"java.lang.String","collection":""},"value":["83f8e42b-d7e9-420d-bde0-e5b223ac7c88"]},"totaldiscounts":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"currency":{"type":{"type":"de.hybris.platform.core.PK","collection":""},"value":["8800746242081"]},"creationtime":{"type":{"type":"java.util.Date","collection":""},"value":["1521636423546"]},"pk":{"type":{"type":"de.hybris.platform.core.PK","collection":""},"value":["8806939263019"]},"net":{"type":{"type":"java.lang.Boolean","collection":""},"value":["false"]},"calculated":{"type":{"type":"java.lang.Boolean","collection":""},"value":["false"]},"user":{"type":{"type":"de.hybris.platform.core.PK","collection":""},"value":["8797043884036"]}},"locAttributes":{}}
    operationtype: 1
 1 row in set (0.00 sec)