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

Wed Mar 13 19:44:36 PDT 2019

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

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/20190313/be8e325c/attachment.html>