Truncate table - command is too large

[debraj-manna]

As discussed in forum

I was trying to truncate a table TRUNCATE TABLE config_blob;

I got this message -

root@:26257/van> truncate table config_blob;
pq: command is too large: 143792138 bytes (max: 67108864)

The table has a structure like below:-

CREATE TABLE config_blob (
    cid integer NOT NULL,
    otype integer NOT NULL,
    oid bigint NOT NULL,
    pname text NOT NULL,
    timeinstant bigint NOT NULL,
    updatetimestamp timestamp with time zone DEFAULT now(),
    value text,
    PRIMARY KEY (cid, otype, oid, pname, timeinstant)
);

Sample Data:-

COPY config_blob (cid, otype, oid, pname, timeinstant, updatetimestamp, value) FROM stdin;
10000	28	1325506347	_runtime	1507942986529	2017-10-14 01:03:06.931555+00	{\n  "@class" : "com.van.model.core.L3NR",\n  "objectGuid" : "de-l3-i-dom",\n  "vendorId" : null,\n  "assetIdentifier" : null,\n  "name" : null,\n  "otherNames" : null,\n  "manager" : null,\n  "modelKey" : {\n    "key" : "10000:28:1325506347"\n  },\n  "groups" : [ "java.util.HashSet", [ ] ],\n  "subTypes" : [ "java.util.HashSet", [ ] ],\n  "description" : null,\n  "propertyBag" : {\n    "@class" : "com.van.model.core.PropertyBag",\n    "propertyValues" : [ "java.util.HashSet", [ ] ]\n  },\n  "associationEntities" : {\n    "@class" : "java.util.HashMap"\n  },\n  "graph" : {\n    "@class" : "com.van.model.graph.Graph",\n    "nodes" : [ "java.util.LinkedList", [ ] ],\n    "edges" : [ "java.util.ArrayList", [ ] ],\n    "propertyBag" : null,\n    "ids" : [ "java.util.ArrayList", [ ] ]\n  },\n  "basePayload" : ""\n}

Trucnate Output:-

root@:26257/> SELECT count(*) FROM van.config_blob;
+----------+
| count(*) |
+----------+
|  2000000 |
+----------+
(1 row)
root@:26257/> truncate table config_blob;
pq: no database specified: "config_blob"
root@:26257/> TRUNCATE TABLE van.config_blob;
pq: command is too large: 129091303 bytes (max: 67108864)
root@:26257/>  

Environment:-

• Mac OS X - 10.12.6
• Cockroach - 1.1

[jordanlewis]

Possibly #19267?

[vivekmenezes]

@debraj-manna I'm unable to see how this can happen on the 1.1 release. Are you sure you tried this with the 1.1 release? Thanks

[debraj-manna]

Yes I am using version 1.1.

…

On Mon, Oct 23, 2017 at 4:20 PM, vivekmenezes ***@***.***> wrote: @debraj-manna <https://github.com/debraj-manna> I'm unable to see how this can happen on the 1.1 release. Are you sure you tried this with the 1.1 release? Thanks — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#19304 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AHw8JKky9DtzR02cDi9jOfEDc1UAbiPFks5svG9hgaJpZM4P7tPe> .

-- Debraj Manna

[vivekmenezes]

@debraj-manna sorry about that. Can you please share the program that is generating the data. I'm unable to reproduce this problem. Thanks!

[debraj-manna]

I will try to give you the program on this weekend as it is a part of bigger code.

…

On Mon, Oct 23, 2017 at 7:22 PM, vivekmenezes ***@***.***> wrote: @debraj-manna <https://github.com/debraj-manna> sorry about that. Can you please share the program that is generating the data. I'm unable to reproduce this problem. Thanks! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#19304 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AHw8JNoIxJmuwojsebdvz6svDc4u-t-dks5svJo0gaJpZM4P7tPe> .

-- Debraj Manna

[debraj-manna]

Sorry my mistake. I was checking the version 1.0.3/