I found in syslog: May 16 01:00:11 verticanode1 kernel: [7745522.508054] INFO: task jbd2/xvda1-8:259 blocked for more than 120 seconds. May 16 01:00:11 verticanode1 kernel: [7745522.511461] Not tainted 3.13.0-48-generic #80-Ubuntu May 16 01:00:11 verticanode1 kernel: [7745522.514210] "echo 0 > /proc...

The spread.conf seems to be OK. Also, I don't think it is an installation problem. The cluster works 95% of the time very well. OS: Ubuntu 14.04.2 LTS (GNU/Linux 3.13.0-48-generic x86_64) I restarted the node. After that, when I wanted to retrieve data from my tables, connecting to the node just res...

Hi, I have a similar issue with a cluster, 3 nodes,installed 1 year ago. For 3 times a node shutdown. 2016-05-16 01:23:26.005 Init Session:0x7ff3b8023460 [Session] <INFO> [Query] TX:0(verticanode1-22017:0x2fc749) select 1 /*jdbc Connection.isValid() check*/ 2016-05-16 01:23:26.057 Init Session:0x7ff...

Hi, Thank you for your response. The version is Vertica Analytic Database v7.1.1-0 . MERGE only with UPDATE , 971 columns, works. MERGE only with INSERT, 971 columns, doesn't work. MERGE only with INSERT, 26 columns, works. INSERT (971 columns) SELECT 971 columns FROM, works. Probably is a limitatio...

Hi,
I have 2 tables with 971 columns.
The first one has 12,700,000 records, the second one is empty.
I need to run a MERGE in order to fill/update the second table.
The error is : ERROR 4913: Target lists can have at most 1664 entries
Where can I find information about this error ?
Thank you,
Veronica

Thank you, Jim!
In fact, there was an other error behind this, related to the insufficient space.

Hi Brett, I have the same problem. 2015-11-05 18:50:11.014 nameless:0x87cedd0 <WARNING> @v_officedw_node0001: 01000/2971: Data collector, unable to open /D/vertica/databases/catalog/officedw/v_officedw_node0001_catalog/DataCollector/BlockMemoryManagerStatistics_500064347001406.log: Too many open fil...