[GRASS-user] Error while executing: 'CREATE TEMPORARY TABLE...

[Markus Metz]

On Thu, Mar 14, 2019 at 3:44 AM Jamille Haarloo <j.r.haarloo at gmail.com>
wrote:
>
> Just tested:
>
> (Wed Mar 13 23:42:59 2019)

> v.db.dropcolumn map=nvTrainingset_new2019 at LUP1
columns=Uitleg2,SegUitleg,x22kcluster,x12kcluster,x17kcluster,x8kcluster,xkcluster
> ERROR: Error while executing: 'CREATE TEMPORARY TABLE
nvTrainingset_new2019_backup(cat INTEGER, compact_circle DOUBLE PRECISION,
DV2_mean DOUBLE PRECISION, DV2_stddev DOUBLE PRECISION, DV2_variance DOUBLE
PRECISION, DV2_coeff_var DOUBLE PRECISION, DV2_first_quart DOUBLE
PRECISION, DV2_median DOUBLE PRECISION, DV2_third_quart DOUBLE PRECISION,
DV2_perc_90 DOUBLE PRECISION, DV4_mean DOUBLE PRECISION, DV4_stddev DOUBLE
PRECISION, DV4_variance DOUBLE PRECISION, DV4_coeff_var DOUBLE PRECISION,
DV4_first_quart DOUBLE PRECISION, DV4_median DOUBLE PRECISION,
DV4_third_quart DOUBLE PRECISION, DV4_perc_90 DOUBLE PRECISION, IDM2_mean
DOUBLE PRECISION, IDM2_stddev DOUBLE PRECISION, IDM2_variance DOUBLE
PRECISION, IDM2_coeff_var DOUBLE PRECISION, IDM2_first_quart DOUBLE
PRECISION, IDM2_median DOUBLE PRECISION, IDM2_third_quart DOUBLE PRECISION,
IDM2_perc_90 DOUBLE PRECISION, IDM4_mean DOUBLE PRECISION, IDM4_stddev
DOUBLE PRECISION, IDM4_variance DOUBLE PRECISION, IDM4_coeff_var DOUBLE
PRECISION, IDM4_first_quart DOUBLE PRECISION, IDM4_median DOUBLE PRECISION,
IDM4_third_quart DOUBLE PRECISION, IDM4_perc_90 DOUBLE PRECISION, W2_mean
DOUBLE PRECISION, W2_stddev DOUBLE PRECISION, W2_variance DOUBLE PRECISION,
W2_coeff_var DOUBLE PRECISION, W2_first_quart DOUBLE PRECISION, W2_median
DOUBLE PRECISION, W2_third_quart DOUBLE PRECISION, W2_perc_90 DOUBLE
PRECISION, W4_mean DOUBLE PRECISION, W4_stddev DOUBLE PRECISION,
W4_variance DOUBLE PRECISION, W4_coeff_var DOUBLE PRECISION, W4_first_quart
DOUBLE PRECISION, W4_median DOUBLE PRECISION, W4_third_quart DOUBLE
PRECISION, W4_perc_90 DOUBLE PRECISION, neighbors_count DOUBLE PRECISION,
compact_circle_nbrmean DOUBLE PRECISION, compact_circle_nbrstddev DOUBLE
PRECISION, DV2_mean_nbrmean DOUBLE PRECISION, DV2_mean_nbrstddev DOUBLE
PRECISION, DV2_stddev_nbrmean DOUBLE PRECISION, DV2_stddev_nbrstddev DOUBLE
PRECISION, DV2_variance_nbrmean DOUBLE PRECISION, DV2_variance_nbrstddev
DOUBLE PRECISION, DV2_coeff_var_nbrmean DOUBLE PRECISION,
DV2_coeff_var_nbrstddev DOUBLE PRECISION, DV2_first_quart_nbrmean DOUBLE
PRECISION, DV2_first_quart_nbrstddev DOUBLE PRECISION, DV2_median_nbrmean
DOUBLE PRECISION, DV2_median_nbrstddev DOUBLE PRECISION,
DV2_third_quart_nbrmean DOUBLE PRECISION, DV2_third_quart_nbrstddev DOUBLE
PRECISION, DV2_perc_90_nbrmean DOUBLE PRECISION, DV2_perc_90_nbrstddev
DOUBLE PRECISION, DV4_mean_nbrmean DOUBLE PRECISION, DV4_mean_nbrstddev
DOUBLE PRECISION, DV4_stddev_nbrmean DOUBLE PRECISION, DV4_stddev_nbrstddev
DOUBLE PRECISION, DV4_variance_nbrmean DOUBLE PRECISION,
DV4_variance_nbrstddev DOUBLE PRECISION, DV4_coeff_var_nbrmean DOUBLE
PRECISION, DV4_coeff_var_nbrstddev DOUBLE PRECISION,
DV4_first_quart_nbrmean DOUBLE PRECISION, DV4_first_quart_nbrstddev DOUBLE
PRECISION, DV4_median_nbrmean DOUBLE PRECISION, DV4_median_nbrstddev DOUBLE
PRECISION, DV4_third_quart_nbrmean DOUBLE PRECISION,
DV4_third_quart_nbrstddev DOUBLE PRECISION, DV4_perc_90_nbrmean DOUBLE
PRECISION, DV4_perc_90_nbrstddev DOUBLE PRECISION, IDM2_mean_nbrmean DOUBLE
PRECISION, IDM2_mean_nbrstddev DOUBLE PRECISION, IDM2_stddev_nbrmean DOUBLE
PRECISION, IDM2_stddev_nbrstddev DOUBLE PRECISION, IDM2_variance_nbrmean
DOUBLE PRECISION, IDM2_variance_nbrstddev DOUBLE PRECISION,
IDM2_coeff_var_nbrmean DOUBLE PRECISION, IDM2_coeff_var_nbrstddev DOUBLE
PRECISION, IDM2_first_quart_nbrmean DOUBLE PRECISION,
IDM2_first_quart_nbrstddev DOUBLE PRECISION, IDM2_median_nbrmean DOUBLE
PRECISION, IDM2_median_nbrstddev DOUBLE PRECISION, IDM2_third_quart_nbrmean
DOUBLE PRECISION, IDM2_third_quart_nbrstddev DOUBLE PRECISION,
IDM2_perc_90_nbrmean DOUBLE PRECISION, IDM2_perc_90_nbrstddev DOUBLE
PRECISION, IDM4_mean_nbrmean DOUBLE PRECISION, IDM4_mean_nbrstddev DOUBLE
PRECISION, IDM4_stddev_nbrmean DOUBLE PRECISION, IDM4_stddev_nbrstddev
DOUBLE PRECISION, IDM4_variance_nbrmean DOUBLE PRECISION,
IDM4_variance_nbrstddev DOUBLE PRECISION, IDM4_coeff_var_nbrmean DOUBLE
PRECISION, IDM4_coeff_var_nbrstddev DOUBLE PRECISION,
IDM4_first_quart_nbrmean DOUBLE PRECISION, IDM4_first_quart_nbrstddev
DOUBLE PRECISION, IDM4_median_nbrmean
> DOUBLE PRECISION, IDM4_median_nbrstddev DOUBLE PRECIS'
> ERROR: Deleting column failed

The sql command is still truncated to 4096 characters. Are you sure you are
using latest GRASS 7.6 or 7.7 from svn? For me it works in trunk with more
than 4096 characters.

Markus M

>
> On Fri, Mar 8, 2019 at 4:25 PM Markus Metz <markus.metz.giswork at gmail.com>
wrote:
>>
>>
>>
>> On Thu, Mar 7, 2019 at 6:35 PM Markus Neteler <neteler at osgeo.org> wrote:
>> >
>> > Hi,
>> >
>> > On Sat, Feb 16, 2019 at 12:28 AM Jamille Haarloo <j.r.haarloo at gmail.com>
wrote:
>> > >
>> > > Dear Grass community,
>> > >
>> > > I don't have any success with removal of columns from a vector file
I am working with, while adding columns has not been a problem.
>> > >
>> > > output:
>> > > v.db.dropcolumn map=nvTrainingset_test2019_clean at LUP1 columns=code
>> > > ERROR: Error while executing: 'CREATE TEMPORARY TABLE
nvTrainingset_test2019_clean_backup(cat INTEGER, compact_circle DOUBLE
PRECISION, DV2_mean DOUBLE PRECISION, DV2_stddev DOUBLE PRECISION,
DV2_variance DOUBLE PRECISION, DV2_coeff_var DOUBLE PRECISION,
DV2_first_quart DOUBLE PRECISION, DV2_median DOUBLE PRECISION,
DV2_third_quart DOUBLE PRECISION, DV2_perc_90 DOUBLE PRECISION, DV4_mean
DOUBLE PRECISION, DV4_stddev DOUBLE PRECISION, DV4_variance DOUBLE
PRECISION, DV4_coeff_var DOUBLE PRECISION, DV4_first_quart DOUBLE
PRECISION, DV4_median DOUBLE PRECISION, DV4_third_quart DOUBLE PRECISION,
DV4_perc_90 DOUBLE PRECISION, IDM2_mean DOUBLE PRECISION, IDM2_stddev
DOUBLE PRECISION, IDM2_variance DOUBLE PRECISION, IDM2_coeff_var DOUBLE
PRECISION, IDM2_first_quart DOUBLE PRECISION, IDM2_median DOUBLE PRECISION,
IDM2_third_quart DOUBLE PRECISION, IDM2_perc_90 DOUBLE PRECISION, IDM4_mean
DOUBLE PRECISION, IDM4_stddev DOUBLE PRECISION, IDM4_variance DOUBLE
PRECISION, IDM4_coeff_var DOUBLE PRECISION, IDM4_first_quart DOUBLE
PRECISION, IDM4_median DOUBLE PRECISION, IDM4_third_quart DOUBLE PRECISION,
IDM4_perc_90 DOUBLE PRECISION, W2_mean DOUBLE PRECISION, W2_stddev DOUBLE
PRECISION, W2_variance DOUBLE PRECISION, W2_coeff_var DOUBLE PRECISION,
W2_first_quart DOUBLE PRECISION, W2_median DOUBLE PRECISION, W2_third_quart
DOUBLE PRECISION, W2_perc_90 DOUBLE PRECISION, W4_mean DOUBLE PRECISION,
W4_stddev DOUBLE PRECISION, W4_variance DOUBLE PRECISION, W4_coeff_var
DOUBLE PRECISION, W4_first_quart DOUBLE PRECISION, W4_median DOUBLE
PRECISION, W4_third_quart DOUBLE PRECISION, W4_perc_90 DOUBLE PRECISION,
neighbors_count DOUBLE PRECISION, compact_circle_nbrmean DOUBLE PRECISION,
compact_circle_nbrstddev DOUBLE PRECISION, DV2_mean_nbrmean DOUBLE
PRECISION, DV2_mean_nbrstddev DOUBLE PRECISION, DV2_stddev_nbrmean DOUBLE
PRECISION, DV2_stddev_nbrstddev DOUBLE PRECISION, DV2_variance_nbrmean
DOUBLE PRECISION, DV2_variance_nbrstddev DOUBLE PRECISION,
DV2_coeff_var_nbrmean DOUBLE PRECISION, DV2_coeff_var_nbrstddev DOUBLE
PRECISION, DV2_first_quart_nbrmean DOUBLE PRECISION,
DV2_first_quart_nbrstddev DOUBLE PRECISION, DV2_median_nbrmean DOUBLE
PRECISION, DV2_median_nbrstddev DOUBLE PRECISION, DV2_third_quart_nbrmean
DOUBLE PRECISION, DV2_third_quart_nbrstddev DOUBLE PRECISION,
DV2_perc_90_nbrmean DOUBLE PRECISION, DV2_perc_90_nbrstddev DOUBLE
PRECISION, DV4_mean_nbrmean DOUBLE PRECISION, DV4_mean_nbrstddev DOUBLE
PRECISION, DV4_stddev_nbrmean DOUBLE PRECISION, DV4_stddev_nbrstddev DOUBLE
PRECISION, DV4_variance_nbrmean DOUBLE PRECISION, DV4_variance_nbrstddev
DOUBLE PRECISION, DV4_coeff_var_nbrmean DOUBLE PRECISION,
DV4_coeff_var_nbrstddev DOUBLE PRECISION, DV4_first_quart_nbrmean DOUBLE
PRECISION, DV4_first_quart_nbrstddev DOUBLE PRECISION, DV4_median_nbrmean
DOUBLE PRECISION, DV4_median_nbrstddev DOUBLE PRECISION,
DV4_third_quart_nbrmean DOUBLE PRECISION, DV4_third_quart_nbrstddev DOUBLE
PRECISION, DV4_perc_90_nbrmean DOUBLE PRECISION, DV4_perc_90_nbrstddev
DOUBLE PRECISION, IDM2_mean_nbrmean DOUBLE PRECISION, IDM2_mean_nbrstddev
DOUBLE PRECISION, IDM2_stddev_nbrmean DOUBLE PRECISION,
IDM2_stddev_nbrstddev DOUBLE PRECISION, IDM2_variance_nbrmean DOUBLE
PRECISION, IDM2_variance_nbrstddev DOUBLE PRECISION, IDM2_coeff_var_nbrmean
DOUBLE PRECISION, IDM2_coeff_var_nbrstddev DOUBLE PRECISION,
IDM2_first_quart_nbrmean DOUBLE PRECISION, IDM2_first_quart_nbrstddev
DOUBLE PRECISION, IDM2_median_nbrmean DOUBLE PRECISION,
IDM2_median_nbrstddev DOUBLE PRECISION, IDM2_third_quart_nbrmean DOUBLE
PRECISION, IDM2_third_quart_nbrstddev DOUBLE PRECISION,
IDM2_perc_90_nbrmean DOUBLE PRECISION, IDM2_perc_90_nbrstddev DOUBLE
PRECISION, IDM4_mean_nbrmean DOUBLE PRECISION, IDM4_mean_nbrstddev DOUBLE
PRECISION, IDM4_stddev_nbrmean DOUBLE PRECISION, IDM4_stddev_nbrstddev
DOUBLE PRECISION, IDM4_variance_nbrmean DOUBLE PRECISION,
IDM4_variance_nbrstddev DOUBLE PRECISION, IDM4_coeff_var_nbrmean DOUBLE
PRECISION, IDM4_coeff_var_nbrstddev DOUBLE PRECISION,
IDM4_first_quart_nbrmean DOUBLE PRECISION, IDM4_first_quart_nbrstddev
DOUBLE PRECISION, IDM4_median_n
>> > > brmean DOUBLE PRECISION, IDM4_median_nbrstddev DOUBLE'
>> > > ERROR: Deleting column failed
>> > >
>> > > Any suggestions?
>> >
>> > I used "wc -c" to count the length of the string: it is 4096
characters.
>> >
>> > Which DB driver do you use? It seems to be a limitation in the driver
>> > communication, i.e. the buffer is limited.
>>
>> The db SQL buffer has been enlarged in trunk r74189 and relbr76 r74190.
>>
>> Please test!
>>
>> Markus M
>> >
>> > Markus
>> > _______________________________________________
>> > grass-user mailing list
>> > grass-user at lists.osgeo.org
>> > https://lists.osgeo.org/mailman/listinfo/grass-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20190314/231161f9/attachment.html>