Omnisci_server running problem

Hello,

I’m following instructions from the link:

It seems successfully installed up to activation step.
But, I got the following error when performing the checkpoint part.

Thrift: Fri Dec 3 18:43:36 2021 TSocket::open() connect() <Host: localhost Port: 6274>: Connection refused
Failed to open transport. Is omnisci_server running?

However, the omnisci_server seems running well…

Additionally, I try to access omnisci through web server (http://ip_address:port), but it fails.
The command “journalctl -xn -u omnisci_web_server | tail -n 10” shows the following error.

18:45:40 digits omnisci_web_server[32846]: ⇨ http server started on [::]:6273
18:45:50 digits omnisci_web_server[32846]: {“time”:“2021-12-03T18:45:50.441194983+09:00”,“level”:“ERROR”,“prefix”:“echo”,“file”:“proxy_1_11.go”,“line”:“20”,“message”:“remote http://localhost:6278 unreachable, could not forward: dial tcp 127.0.0.1:6278: connect: connection refused”}

What’s the problem? Can I get some help?

Hi @tslee,

Thanks for joining our community, and we hope you will enjoy using our tools.

It looks that you installed everything in the right way, but for whatever reason, the database itself is crashing, or it’s not starting correctly.
This can happen for several reasons, but if you installed Vulkan, you could try to disable it, setting the parameter renderer-use-Vulkan-driver to false, then restart the server.
To set up this parameter you would change the file called omnisci.conf that’s typically located into /var/lib/omnisci and add renderer-use-Vulkan-driver=flase into the main section.

If with this parameter everything is running as expected, it would be better check the troubleshooting section of the Vulkan renderer and fix the installation installation.

To check if something is going wrong in a deeper way, you can run the server running this command and sharing the output with us

sudo /opt/omnisci/bin/omnisci_server --data /var/lib/omnisci/data --log-severity-clog=DEBUG4

This should output a vary detailed log on the screen, helping us to find out the root cause of the problem

Regards,
Candido

Hi, @candido.dessanti

Thanks for your guide.

First of all, i tried setting “renderer-use-vulkan-driver” to false, but it also failed.

I ran the server using the command “sudo /opt/omnisci/bin/omnisci_server --data …” and got the following error message (I removed a line due to character limit):

2021-12-07T06:15:46.739070 I 50245 0 0 CommandLineOptions.cpp:1777 Max import threads 32
2021-12-07T06:15:46.739307 I 50245 0 0 CommandLineOptions.cpp:1780 cuda block size 0
2021-12-07T06:15:46.739328 I 50245 0 0 CommandLineOptions.cpp:1781 cuda grid size 0
2021-12-07T06:15:46.739339 I 50245 0 0 CommandLineOptions.cpp:1782 Min CPU buffer pool slab size 268435456
2021-12-07T06:15:46.739351 I 50245 0 0 CommandLineOptions.cpp:1783 Max CPU buffer pool slab size 4294967296
2021-12-07T06:15:46.739361 I 50245 0 0 CommandLineOptions.cpp:1784 Min GPU buffer pool slab size 268435456
2021-12-07T06:15:46.739372 I 50245 0 0 CommandLineOptions.cpp:1785 Max GPU buffer pool slab size 4294967296
2021-12-07T06:15:46.739383 I 50245 0 0 CommandLineOptions.cpp:1786 calcite JVM max memory 1024
2021-12-07T06:15:46.739393 I 50245 0 0 CommandLineOptions.cpp:1787 OmniSci Server Port 6274
2021-12-07T06:15:46.739404 I 50245 0 0 CommandLineOptions.cpp:1788 OmniSci Calcite Port 6279
2021-12-07T06:15:46.739415 I 50245 0 0 CommandLineOptions.cpp:1789 Enable Calcite view optimize true
2021-12-07T06:15:46.739426 I 50245 0 0 CommandLineOptions.cpp:1791 Allow Local Auth Fallback: disabled
2021-12-07T06:15:46.739436 I 50245 0 0 CommandLineOptions.cpp:1793 ParallelTop min threshold: 100000
2021-12-07T06:15:46.739447 I 50245 0 0 CommandLineOptions.cpp:1794 ParallelTop watchdog max: 20000000
2021-12-07T06:15:46.739458 I 50245 0 0 CommandLineOptions.cpp:1796 Enable Data Recycler: enabled
2021-12-07T06:15:46.739468 I 50245 0 0 CommandLineOptions.cpp:1799 Use hashtable cache: enabled
2021-12-07T06:15:46.739479 I 50245 0 0 CommandLineOptions.cpp:1802 Total amount of bytes that hashtable cache keeps: 4096 MB.
2021-12-07T06:15:46.739490 I 50245 0 0 CommandLineOptions.cpp:1804 Per-hashtable size limit: 2048 MB.
2021-12-07T06:15:46.739587 I 50245 0 0 CommandLineOptions.cpp:1345 License file not found: /var/lib/omnisci/data/omnisci.license
2021-12-07T06:15:46.739601 I 50245 0 0 CommandLineOptions.cpp:1350 OmniSci started with data directory at ‘/var/lib/omnisci/data’
2021-12-07T06:15:46.739614 I 50245 0 0 CommandLineOptions.cpp:1360 Server read-only mode is false
2021-12-07T06:15:46.739626 I 50245 0 0 CommandLineOptions.cpp:1364 Threading layer: TBB
2021-12-07T06:15:46.739636 I 50245 0 0 CommandLineOptions.cpp:1368 Watchdog is set to true
2021-12-07T06:15:46.739647 I 50245 0 0 CommandLineOptions.cpp:1369 Dynamic Watchdog is set to false
2021-12-07T06:15:46.739657 I 50245 0 0 CommandLineOptions.cpp:1373 Runtime query interrupt is set to true
2021-12-07T06:15:46.739668 I 50245 0 0 CommandLineOptions.cpp:1375 A frequency of checking pending query interrupt request is set to 1000 (in ms.)
2021-12-07T06:15:46.739679 I 50245 0 0 CommandLineOptions.cpp:1377 A frequency of checking running query interrupt request is set to 0.1 (0.0 ~ 1.0)
2021-12-07T06:15:46.739694 I 50245 0 0 CommandLineOptions.cpp:1380 Non-kernel time query interrupt is set to true
2021-12-07T06:15:46.739705 I 50245 0 0 CommandLineOptions.cpp:1383 Debug Timer is set to false
2021-12-07T06:15:46.739716 I 50245 0 0 CommandLineOptions.cpp:1384 LogUserId is set to false
2021-12-07T06:15:46.739726 I 50245 0 0 CommandLineOptions.cpp:1385 Maximum idle session duration 60
2021-12-07T06:15:46.739737 I 50245 0 0 CommandLineOptions.cpp:1386 Maximum active session duration 43200
2021-12-07T06:15:46.739748 I 50245 0 0 CommandLineOptions.cpp:1387 Maximum number of sessions -1
2021-12-07T06:15:46.739759 I 50245 0 0 CommandLineOptions.cpp:1389 Allowed import paths is set to
2021-12-07T06:15:46.739769 I 50245 0 0 CommandLineOptions.cpp:1390 Allowed export paths is set to
2021-12-07T06:15:46.739804 I 50245 0 0 CommandLineOptions.cpp:1438 Cannot enable disk cache for fsi when fsi is disabled. Defaulted to disk cache disabled
2021-12-07T06:15:46.739828 I 50245 0 0 CommandLineOptions.cpp:1490 Vacuum Min Selectivity: 0.1
2021-12-07T06:15:46.739841 I 50245 0 0 CommandLineOptions.cpp:1492 Enable system tables is set to false
2021-12-07T06:15:46.739853 I 50245 0 0 MapDServer.cpp:426 OmniSciDB starting up
2021-12-07T06:15:46.742991 1 50245 0 1 MapDServer.cpp:358 heartbeat thread starting
2021-12-07T06:15:46.743027 I 50245 0 0 DBHandler.cpp:314 OmniSci Server 5.9.0-20211118-75d225cb93
2021-12-07T06:15:47.008593 I 50245 0 0 CudaMgr.cpp:368 Using 2 Gpus.
2021-12-07T06:15:47.008649 1 50245 0 0 CudaMgr.cpp:370 Device: 0
2021-12-07T06:15:47.008655 1 50245 0 0 CudaMgr.cpp:371 UUID: ff44abf6-5a0a-90f2-9f23-f3f11938d9bf
2021-12-07T06:15:47.008669 1 50245 0 0 CudaMgr.cpp:372 Clock (khz): 1695000
2021-12-07T06:15:47.008674 1 50245 0 0 CudaMgr.cpp:373 Compute Major: 8
2021-12-07T06:15:47.008679 1 50245 0 0 CudaMgr.cpp:374 Compute Minor: 6
2021-12-07T06:15:47.008683 1 50245 0 0 CudaMgr.cpp:375 PCI bus id: 27
2021-12-07T06:15:47.008688 1 50245 0 0 CudaMgr.cpp:376 PCI deviceId id: 0
2021-12-07T06:15:47.008692 1 50245 0 0 CudaMgr.cpp:377 Per device global memory: 23.6995 GB
2021-12-07T06:15:47.008707 1 50245 0 0 CudaMgr.cpp:379 Memory clock (khz): 9751000
2021-12-07T06:15:47.008712 1 50245 0 0 CudaMgr.cpp:380 Memory bandwidth: 468.048 GB/sec
2021-12-07T06:15:47.008717 1 50245 0 0 CudaMgr.cpp:383 Constant Memory: 65536
2021-12-07T06:15:47.008722 1 50245 0 0 CudaMgr.cpp:384 Shared memory per multiprocessor: 102400
2021-12-07T06:15:47.008727 1 50245 0 0 CudaMgr.cpp:386 Shared memory per block: 49152
2021-12-07T06:15:47.008731 1 50245 0 0 CudaMgr.cpp:387 Number of MPs: 82
2021-12-07T06:15:47.008736 1 50245 0 0 CudaMgr.cpp:388 Warp Size: 32
2021-12-07T06:15:47.008740 1 50245 0 0 CudaMgr.cpp:389 Max threads per block: 1024
2021-12-07T06:15:47.008745 1 50245 0 0 CudaMgr.cpp:390 Max registers per block: 65536
2021-12-07T06:15:47.008749 1 50245 0 0 CudaMgr.cpp:391 Max register per MP: 65536
2021-12-07T06:15:47.008754 1 50245 0 0 CudaMgr.cpp:392 Memory bus width in bits: 384
2021-12-07T06:15:47.008758 1 50245 0 0 CudaMgr.cpp:370 Device: 1
2021-12-07T06:15:47.008762 1 50245 0 0 CudaMgr.cpp:371 UUID: 50d1a19d-577f-8b3f-4447-fa29d0fb58b7
2021-12-07T06:15:47.008767 1 50245 0 0 CudaMgr.cpp:372 Clock (khz): 1695000
2021-12-07T06:15:47.008772 1 50245 0 0 CudaMgr.cpp:373 Compute Major: 8
2021-12-07T06:15:47.008776 1 50245 0 0 CudaMgr.cpp:374 Compute Minor: 6
2021-12-07T06:15:47.008780 1 50245 0 0 CudaMgr.cpp:375 PCI bus id: 64
2021-12-07T06:15:47.008785 1 50245 0 0 CudaMgr.cpp:376 PCI deviceId id: 0
2021-12-07T06:15:47.008789 1 50245 0 0 CudaMgr.cpp:377 Per device global memory: 23.6995 GB
2021-12-07T06:15:47.008794 1 50245 0 0 CudaMgr.cpp:379 Memory clock (khz): 9751000
2021-12-07T06:15:47.008798 1 50245 0 0 CudaMgr.cpp:380 Memory bandwidth: 468.048 GB/sec
2021-12-07T06:15:47.008803 1 50245 0 0 CudaMgr.cpp:383 Constant Memory: 65536
2021-12-07T06:15:47.008807 1 50245 0 0 CudaMgr.cpp:384 Shared memory per multiprocessor: 102400
2021-12-07T06:15:47.008812 1 50245 0 0 CudaMgr.cpp:386 Shared memory per block: 49152
2021-12-07T06:15:47.008816 1 50245 0 0 CudaMgr.cpp:387 Number of MPs: 82
2021-12-07T06:15:47.008820 1 50245 0 0 CudaMgr.cpp:388 Warp Size: 32
2021-12-07T06:15:47.008824 1 50245 0 0 CudaMgr.cpp:389 Max threads per block: 1024
2021-12-07T06:15:47.008829 1 50245 0 0 CudaMgr.cpp:390 Max registers per block: 65536
2021-12-07T06:15:47.008833 1 50245 0 0 CudaMgr.cpp:391 Max register per MP: 65536
2021-12-07T06:15:47.008837 1 50245 0 0 CudaMgr.cpp:392 Memory bus width in bits: 384
2021-12-07T06:15:47.008841 I 50245 0 0 CudaMgr.cpp:67 Warming up the GPU JIT Compiler… (this may take several seconds)
2021-12-07T06:15:47.009590 1 50245 0 0 NvidiaKernel.cpp:77 CUDA JIT time to create link: 0.718357
2021-12-07T06:15:47.108846 1 50245 0 0 NvidiaKernel.cpp:84 CUDA JIT time to add RT fatbinary: 23.6491
2021-12-07T06:15:47.112515 I 50245 0 0 CudaMgr.cpp:70 GPU JIT Compiler initialized.
2021-12-07T06:15:47.112558 I 50245 0 0 ArrowForeignStorage.cpp:859 CSV backed temporary tables has been activated. Create table with (storage_type='CSV:path/to/file.csv');
2021-12-07T06:15:47.112568 I 50245 0 0 ArrowForeignStorage.cpp:1037 CSV backed temporary tables has been activated. Create table with (storage_type='CSV:path/to/file.csv');
2021-12-07T06:15:47.112596 1 50245 0 0 DataMgr.cpp:229 Detected 515649M of total system memory.
2021-12-07T06:15:47.112615 I 50245 0 0 DataMgr.cpp:238 Min CPU Slab Size is 256MB
2021-12-07T06:15:47.112623 I 50245 0 0 DataMgr.cpp:239 Max CPU Slab Size is 4096MB
2021-12-07T06:15:47.112630 I 50245 0 0 DataMgr.cpp:240 Max memory pool size for CPU is 412519MB
2021-12-07T06:15:47.112638 I 50245 0 0 DataMgr.cpp:262 Reserved GPU memory is 1337.67MB includes render buffer allocation
2021-12-07T06:15:47.112647 I 50245 0 0 DataMgr.cpp:281 Min GPU Slab size for GPU 0 is 256MB
2021-12-07T06:15:47.112655 I 50245 0 0 DataMgr.cpp:283 Max GPU Slab size for GPU 0 is 4096MB
2021-12-07T06:15:47.112662 I 50245 0 0 DataMgr.cpp:285 Max memory pool size for GPU 0 is 22930.6MB
2021-12-07T06:15:47.112670 I 50245 0 0 DataMgr.cpp:281 Min GPU Slab size for GPU 1 is 256MB
2021-12-07T06:15:47.112677 I 50245 0 0 DataMgr.cpp:283 Max GPU Slab size for GPU 1 is 4096MB
2021-12-07T06:15:47.112685 I 50245 0 0 DataMgr.cpp:285 Max memory pool size for GPU 1 is 22930.6MB
2021-12-07T06:15:47.112810 I 50245 0 0 FileMgr.cpp:230 Completed Reading table’s file metadata, Elapsed time : 0ms Epoch: 0 files read: 0 table location: ‘/var/lib/omnisci/data/mapd_data/table_0_0’
2021-12-07T06:15:47.112821 3 50245 0 0 FileMgr.cpp:277 Number of Headers in Vector: 0
2021-12-07T06:15:47.112839 I 50245 0 0 Calcite.cpp:371 Creating Calcite Handler, Calcite Port is 6279 base data dir is /var/lib/omnisci/data
2021-12-07T06:15:47.112852 I 50245 0 0 Calcite.cpp:279 Running Calcite server as a daemon
2021-12-07T06:15:47.636858 I 50245 0 0 Calcite.cpp:319 Calcite server start took 500 ms
2021-12-07T06:15:47.636962 I 50245 0 0 Calcite.cpp:320 ping took 18 ms
2021-12-07T06:15:47.645229 1 50245 0 0 Calcite.cpp:614 (too long… i will post this line separately in another reply)
2021-12-07T06:15:47.664932 I 50245 0 0 DBHandler.cpp:497 Started in GPU mode
2021-12-07T06:15:47.667587 I 50245 0 0 DriverInstance.cpp:41 Using GfxDriver: Vulkan
2021-12-07T06:15:47.668918 I 50245 0 0 VulkanPlatform.cpp:134 Vulkan Instance API version: 1.2.131
2021-12-07T06:15:47.743272 1 50245 0 1 MapDServer.cpp:363 heartbeat thread exiting
2021-12-07T06:15:47.743354 I 50245 0 1 MapDServer.cpp:368 Interrupt signal (11) received.
Segmentation fault

What’s wrong?

Thanks

I post the part of error message here due to character limit. I cannot upload a file because i’m a new user…
2021-12-07T06:15:47.645229 1 50245 0 0 Calcite.cpp:614 [{“name”:“Truncate__”,“ret”:“float”,“args”:[“float”,“i32”]},{“name”:“area_triangle”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”]},{“name”:“box_contains_point”,“ret”:“i1”,“args”:[“double*”,“i64”,“double”,“double”]},{“name”:“Round__”,“ret”:“float”,“args”:[“float”,“i32”]},{“name”:“ST_YMax”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”]},{“name”:“ST_Intersects_Point_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“distance_point_point_squared”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”]},{“name”:“centroid_add_polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“double*”,“double*”,“double*”,“double*”,“i64*”,“double*”]},{“name”:“h3ToGeoPacked”,“ret”:“i64”,“args”:[“i64”]},{“name”:“perimeter_multipolygon”,“ret”:“double”,“args”:[“i8*”,“i32”,“i8*”,“i32”,“i8*”,“i32”,“i32”,“i32”,“i32”,“i1”]},{“name”:“ST_Distance_Polygon_MultiPolygon”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“downAp7",“ret”:“i1”,“args”:[“i32*”]},{“name”:“ST_Centroid_MultiPolygon”,“ret”:“void”,“args”:[“i8*”,“i32”,“i32*”,“i32”,“i32*”,“i32”,“i32”,“i32”,“i32”,“double*”]},{“name”:"isNan_”,“ret”:“i1”,“args”:[“float”]},{“name”:“convert_meters_to_pixel_height”,“ret”:“double”,“args”:[“double”,“i8*”,“i64”,“i32”,“i32”,“i32”,“double”,“double”,“i32”,“double”]},{“name”:"_hex2dToGeo",“ret”:“i1”,“args”:[“double*”,“i32”,“i32”,“i32”,“double*”]},{“name”:“tol_eq”,“ret”:“i1”,“args”:[“double”,“double”,“double”]},{“name”:“ST_YMin_Bounds”,“ret”:“double”,“args”:[“double*”,“i64”,“i32”,“i32”]},{“name”:“ST_Centroid_Polygon”,“ret”:“void”,“args”:[“i8*”,“i32”,“i32*”,“i32”,“i32”,“i32”,“i32”,“double*”]},{“name”:“square",“ret”:“double”,“args”:[“double”]},{“name”:“Log10”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_YMax_Bounds”,“ret”:“double”,“args”:[“double*”,“i64”,“i32”,“i32”]},{“name”:"ct_device_selection_udf_gpu__gpu”,“ret”:“i32”,“args”:[“i32”]},{“name”:“ST_DWithin_Point_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“round_to_digit”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:"_ijkScale",“ret”:“i1”,“args”:[“i32*”,“i32”]},{“name”:“rotate60cw",“ret”:“i32”,“args”:[“i32”]},{“name”:“array_append__3”,“ret”:"{double*, i64, i8}",“args”:["{double, i64, i8}",“double”]},{“name”:“array_append__2”,“ret”:"{i8, i64, i8}",“args”:["{i8, i64, i8}",“i8”]},{“name”:“array_append__1”,“ret”:"{i16, i64, i8}",“args”:["{i16, i64, i8}",“i16”]},{“name”:"_geoToFaceIjk",“ret”:“i1”,“args”:["double",“i32”,“i32*”]},{“name”:“array_append__4”,“ret”:"{float*, i64, i8}",“args”:["{float, i64, i8}",“float”]},{“name”:“ST_XMin_Bounds”,“ret”:“double”,“args”:["double",“i64”,“i32”,“i32”]},{“name”:“MapD_GeoPolyRenderGroup”,“ret”:“i32”,“args”:[“i32”]},{“name”:“ST_X_Point”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”]},{“name”:“ST_Distance_LineString_Polygon”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“array_append”,“ret”:"{i64*, i64, i8}",“args”:["{i64, i64, i8}",“i64”]},{“name”:“ST_Length_LineString_Geodesic”,“ret”:“double”,“args”:["i8",“i64”,“i32”,“i32”,“i32”]},{“name”:“point_in_polygon_winding_number”,“ret”:“i1”,“args”:[“i8*”,“i32”,“double”,“double”,“i32”,“i32”,“i32”]},{“name”:“ST_cContains_MultiPolygon_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:"v2dMag",“ret”:“double”,“args”:[“double*”]},{“name”:“neighbor",“ret”:“i1”,“args”:[“i32*”,“i32”]},{“name”:“reg_hex_horiz_pixel_bin_y”,“ret”:“float”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“i32”,“i32”]},{“name”:“reg_hex_horiz_pixel_bin_x”,“ret”:“float”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“i32”,“i32”]},{“name”:“compressed_coord”,“ret”:“i32”,“args”:[“i8*”,“i32”]},{“name”:“ST_Distance_Point_LineString”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“area_polygon”,“ret”:“double”,“args”:[“i8*”,“i32”,“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:"ct_device_selection_udf_both__gpu”,“ret”:“i32”,“args”:[“i32”]},{“name”:"Log”,“ret”:“double”,“args”:[“float”]},{“name”:“ST_XMax”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”]},{“name”:“ST_DWithin_MultiPolygon_MultiPolygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ijkToHex2d",“ret”:“i1”,“args”:[“i32*”,“double*”]},{“name”:“isNan”,“ret”:“i1”,“args”:[“double”]},{“name”:“ST_Perimeter_MultiPolygon_Geodesic”,“ret”:“double”,“args”:[“i8*”,“i32”,“i8*”,“i32”,“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_Contains_Point_LineString”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“centroid_add_triangle”,“ret”:“i1”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double*”,“double*”]},{“name”:“distance_point_linestring”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“i1”,“double”]},{“name”:“ST_Contains_Point_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“h3ToLat”,“ret”:“double”,“args”:[“i64”]},{“name”:“ST_Distance_Point_MultiPolygon”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Distance_LineString_LineString”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“OmniSci_Geo_PolyRenderGroup”,“ret”:“i32”,“args”:[“i32”]},{“name”:“h3ToGeo",“ret”:“i1”,“args”:[“i64”,“double*”]},{“name”:"upAp7r",“ret”:“i1”,“args”:[“i32*”]},{“name”:“Point_Overlaps_Box”,“ret”:“i1”,“args”:[“double*”,“i64”,“double”,“double”]},{“name”:“point_dwithin_box”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32”,“i32”,“double*”,“i64”,“i32”,“i32”,“double”]},{“name”:“Floor__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“ST_Distance_Point_ClosedLineString”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“Floor__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“ST_Intersects_Point_MultiPolygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“transform_coord_y”,“ret”:“double”,“args”:[“double”,“i32”,“i32”]},{“name”:“Floor__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“transform_coord_x”,“ret”:“double”,“args”:[“double”,“i32”,“i32”]},{“name”:“ST_Intersects_Point_LineString”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:"array_append”,“ret”:"{i32*, i64, i8}",“args”:["{i32, i64, i8}",“i32”]},{“name”:"_upAp7",“ret”:“i1”,“args”:["i32"]},{“name”:"faceIjkToH3",“ret”:“i64”,“args”:[“i32*”,“i32”]},{“name”:“Sinh”,“ret”:“double”,“args”:[“double”]},{“name”:“barray_append”,“ret”:"{i1*, i64, i8}",“args”:["{i1, i64, i8}",“i1”]},{“name”:“ST_XMin”,“ret”:“double”,“args”:["i8",“i64”,“i32”,“i32”,“i32”]},{“name”:“ST_DWithin_Polygon_MultiPolygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Distance_MultiPolygon_Polygon”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Intersects_LineString_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_Perimeter_Polygon”,“ret”:“double”,“args”:[“i8*”,“i32”,“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_DWithin_Point_MultiPolygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“geoToH3”,“ret”:“i64”,“args”:[“double”,“double”,“i32”]},{“name”:“ST_Distance_Polygon_LineString”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Intersects_MultiPolygon_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“max_distance_point_line”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”]},{“name”:“pointSquareDist",“ret”:“double”,“args”:[“double*”,“double*”]},{“name”:“ST_DWithin_LineString_LineString”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“unitIjkToDigit",“ret”:“i32”,“args”:[“i32*”]},{“name”:“ST_Contains_Polygon_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“Sin”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_Distance_Polygon_Point”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Distance_LineString_Point_Geodesic”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“distance_point_point”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”]},{“name”:"downAp7r",“ret”:“i1”,“args”:[“i32*”]},{“name”:“ST_Contains_Polygon_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“tol_ge”,“ret”:“i1”,“args”:[“double”,“double”,“double”]},{“name”:“ST_Contains_LineString_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_XMax_Bounds”,“ret”:“double”,“args”:[“double*”,“i64”,“i32”,“i32”]},{“name”:“ST_Intersects_MultiPolygon_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:"ln”,“ret”:“double”,“args”:[“float”]},{“name”:“ST_Contains_MultiPolygon_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“convert_meters_to_merc_pixel_width”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”,“double”,“i32”,“double”]},{“name”:“ST_Intersects_Polygon_MultiPolygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_Length_LineString”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”]},{“name”:“ST_Perimeter_Polygon_Geodesic”,“ret”:“double”,“args”:[“i8*”,“i32”,“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_Contains_Point_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_Area_Polygon”,“ret”:“double”,“args”:[“i8*”,“i32”,“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:"ct_device_selection_udf_both__cpu”,“ret”:“i32”,“args”:[“i32”]},{“name”:“box_dwithin_box”,“ret”:“i1”,“args”:[“double*”,“i64”,“i32”,“double*”,“i64”,“i32”,“i32”,“double”]},{“name”:“centroid_add_linestring”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”,“i1”,“double*”,“double*”,“i64*”,“double*”]},{“name”:"Log10”,“ret”:“double”,“args”:[“float”]},{“name”:“ST_Intersects_MultiPolygon_MultiPolygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“Asin”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_Distance_MultiPolygon_LineString”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“rect_pixel_bin_x”,“ret”:“float”,“args”:[“double”,“double”,“double”,“double”,“double”,“i32”]},{“name”:“rect_pixel_bin_y”,“ret”:“float”,“args”:[“double”,“double”,“double”,“double”,“double”,“i32”]},{“name”:“ST_Intersects_LineString_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“is_point_in_view”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32”,“double”,“double”,“double”,“double”]},{“name”:“is_point_size_in_merc_view”,“ret”:“i1”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”]},{“name”:"_ijkRotate60ccw",“ret”:“i1”,“args”:[“i32*”]},{“name”:“ST_Distance_LineString_MultiPolygon”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Intersects_LineString_Linestring”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_Distance_Polygon_Polygon”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Distance_Point_Point_Geodesic”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“Contains_MultiPolygon_Point_Impl”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:"_geoToHex2d",“ret”:“i1”,“args”:[“double*”,“i32”,“i32*”,“double*”]},{“name”:"_adjustOverageClassII",“ret”:“i32”,“args”:[“i32*”,“i32”,“i32”,“i32”]},{“name”:“degrees”,“ret”:“double”,“args”:[“double”]},{“name”:“approx_distance_in_meters”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:“constrainLng”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_Intersects_LineString_MultiPolygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_DWithin_LineString_MultiPolygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:"_posAngleRads",“ret”:“double”,“args”:[“double”]},{“name”:“Tanh”,“ret”:“double”,“args”:[“double”]},{“name”:“isBaseCellPentagon",“ret”:“i32”,“args”:[“i32”]},{“name”:“ST_MaxDistance_Point_LineString”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:"h3ToFaceIjk",“ret”:“i1”,“args”:[“i64”,“i32*”]},{“name”:“Log”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_Perimeter_MultiPolygon”,“ret”:“double”,“args”:[“i8*”,“i32”,“i8*”,“i32”,“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:“tol_zero_template”,“ret”:“i1”,“args”:[“i64”,“i64”]},{“name”:“centroid_add_ring”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”,“double”,“double*”,“double*”,“double*”,“double*”,“i64*”,“double*”]},{“name”:“ijkSub",“ret”:“i1”,“args”:[“i32*”,“i32*”,“i32*”]},{“name”:“ST_YMin”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”]},{“name”:"h3ToFaceIjkWithInitializedFijk",“ret”:“i32”,“args”:[“i64”,“i32*”]},{“name”:“Ceil”,“ret”:“double”,“args”:[“double”]},{“name”:“polygon_contains_point”,“ret”:“i1”,“args”:[“i8*”,“i32”,“double”,“double”,“i32”,“i32”,“i32”]},{“name”:“ST_Distance_LineString_Point”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Centroid_LineString”,“ret”:“void”,“args”:[“i8*”,“i32”,“i32”,“i32”,“i32”,“double*”]},{“name”:“ST_Distance_Point_LineString_Geodesic”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:"distance_in_meters”,“ret”:“double”,“args”:[“float”,“float”,“float”,“float”]},{“name”:"Floor”,“ret”:“float”,“args”:[“float”]},{“name”:“box_overlaps_box”,“ret”:“i1”,“args”:[“double*”,“i64”,“double*”,“i64”]},{“name”:“decompress_coord”,“ret”:“double”,“args”:[“i8*”,“i32”,“i32”,“i1”]},{“name”:“isResClassIII”,“ret”:“i32”,“args”:[“i32”]},{“name”:“array_append_impl”,“ret”:"{float*, i64, i8}",“args”:["{float, i64, i8}",“float”]},{“name”:“max_distance_point_linestring”,“ret”:“double”,“args”:["i8",“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“i1”]},{“name”:“ST_Distance_MultiPolygon_MultiPolygon”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“tol_zero”,“ret”:“i1”,“args”:[“double”,“double”]},{“name”:“rect_pixel_bin_packed”,“ret”:“i32”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“i32”,“i32”]},{“name”:“barray_append_impl”,“ret”:"{i1*, i64, i8}",“args”:["{i1, i64, i8}",“i8”]},{“name”:"_rotate60ccw",“ret”:“i32”,“args”:[“i32”]},{“name”:“tol”,“ret”:“double”,“args”:[“i32”,“i32”]},{“name”:"_geoAzDistanceRads",“ret”:“i1”,“args”:["double",“double”,“double”,“double*”]},{“name”:"_ijkAdd",“ret”:“i1”,“args”:[“i32*”,“i32*”,“i32*”]},{“name”:“ST_DWithin_Point_LineString”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“convert_meters_to_pixel_width”,“ret”:“double”,“args”:[“double”,“i8*”,“i64”,“i32”,“i32”,“i32”,“double”,“double”,“i32”,“double”]},{“name”:“reg_hex_vert_pixel_bin_y”,“ret”:“float”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“i32”,“i32”]},{“name”:“reg_hex_vert_pixel_bin_x”,“ret”:“float”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“i32”,“i32”]},{“name”:“ST_Contains_LineString_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:"_faceIjkToBaseCellCCWrot60",“ret”:“i32”,“args”:[“i32*”]},{“name”:“power”,“ret”:“double”,“args”:[“double”,“double”]},{“name”:“area_ring”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”]},{“name”:“MapD_GeoPolyBoundsPtr”,“ret”:“i64”,“args”:[“double*”,“i64”]},{“name”:“reg_hex_vert_pixel_bin_packed”,“ret”:“i32”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“i32”,“i32”]},{“name”:“Atanh”,“ret”:“double”,“args”:[“double”]},{“name”:“length_linestring”,“ret”:“double”,“args”:[“i8*”,“i32”,“i32”,“i32”,“i32”,“i1”,“i1”]},{“name”:“Cos”,“ret”:“double”,“args”:[“double”]},{“name”:“Sqrt”,“ret”:“double”,“args”:[“double”]},{“name”:“tol_le”,“ret”:“i1”,“args”:[“double”,“double”,“double”]},{“name”:“Cot”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_DWithin_Point_Point_Geodesic”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:"_h3LeadingNonZeroDigit",“ret”:“i32”,“args”:[“i64”]},{“name”:“coord_x”,“ret”:“double”,“args”:[“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:“coord_y”,“ret”:“double”,“args”:[“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:“box_contains_box”,“ret”:“i1”,“args”:[“double*”,“i64”,“double*”,“i64”]},{“name”:“ST_DWithin_LineString_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“line_intersects_line”,“ret”:“i1”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”]},{“name”:"_faceIjkToBaseCell",“ret”:“i32”,“args”:[“i32*”]},{“name”:“compression_unit_size”,“ret”:“i32”,“args”:[“i32”]},{“name”:“ST_Area_MultiPolygon”,“ret”:“double”,“args”:[“i8*”,“i32”,“i8*”,“i32”,“i8*”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_Intersects_Polygon_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“centroid_add_segment”,“ret”:“i1”,“args”:[“double”,“double”,“double”,“double”,“double*”,“double*”]},{“name”:“radsToDegs”,“ret”:“double”,“args”:[“double”]},{“name”:“Tan”,“ret”:“double”,“args”:[“double”]},{“name”:"_h3RotatePent60cw",“ret”:“i64”,“args”:[“i64”]},{“name”:"_faceIjkToGeo",“ret”:“i1”,“args”:[“i32*”,“i32”,“double*”]},{“name”:“ln”,“ret”:“double”,“args”:[“double”]},{“name”:“transform_coord”,“ret”:“double”,“args”:[“double”,“i32”,“i32”,“i1”]},{“name”:"_h3RotatePent60ccw",“ret”:“i64”,“args”:[“i64”]},{“name”:“ST_Contains_MultiPolygon_LineString”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“rect_pixel_bin”,“ret”:“float”,“args”:[“double”,“double”,“double”,“i32”,“i32”]},{“name”:“ST_Distance_Point_Polygon”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Intersects_MultiPolygon_LineString”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ct_device_selection_udf_any”,“ret”:“i32”,“args”:[“i32”]},{“name”:"_geoToVec3d",“ret”:“i1”,“args”:[“double*”,“double*”]},{“name”:“Ceil__2”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Ceil__1”,“ret”:“i16”,“args”:[“i16”]},{“name”:“Ceil__3”,“ret”:“i64”,“args”:[“i64”]},{“name”:“distance_point_line”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”]},{“name”:“ST_Centroid_Point”,“ret”:“void”,“args”:[“i8*”,“i32”,“i32”,“i32”,“i32”,“double*”]},{“name”:“OmniSci_Geo_PolyBoundsPtr”,“ret”:“i64”,“args”:[“double*”,“i64”]},{“name”:"_hex2dToCoordIJK",“ret”:“i1”,“args”:[“double*”,“i32*”]},{“name”:“ST_Distance_MultiPolygon_Point”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“i32*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“Round2_to_digit”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“ST_DWithin_Point_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“ST_Intersects_Polygon_LineString”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“on_segment”,“ret”:“i1”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”]},{“name”:“h3ToLon”,“ret”:“double”,“args”:[“i64”]},{“name”:“distance_in_meters”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”]},{“name”:"_baseCellIsCwOffset",“ret”:“i1”,“args”:[“i32”,“i32”]},{“name”:“ST_DWithin_Polygon_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”,“double”]},{“name”:“setIJK",“ret”:“i1”,“args”:[“i32*”,“i32”,“i32”,“i32”]},{“name”:“Atan2”,“ret”:“double”,“args”:[“double”,“double”]},{“name”:“Acos”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_Y_Point”,“ret”:“double”,“args”:[“i8*”,“i64”,“i32”,“i32”,“i32”]},{“name”:"ijkMatches",“ret”:“i32”,“args”:[“i32*”,“i32*”]},{“name”:“Cosh”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_Contains_Polygon_LineString”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“ST_Intersects_Point_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“Truncate”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“ST_cContains_Polygon_Point”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“radians”,“ret”:“double”,“args”:[“double”]},{“name”:“ST_MaxDistance_LineString_Point”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“h3ToParent”,“ret”:“i64”,“args”:[“i64”,“i32”]},{“name”:“h3Rotate60ccw",“ret”:“i64”,“args”:[“i64”]},{“name”:"ijkNormalize",“ret”:“i1”,“args”:[“i32*”]},{“name”:"Ceil”,“ret”:“float”,“args”:[“float”]},{“name”:“reg_hex_horiz_pixel_bin_packed”,“ret”:“i32”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“double”,“i32”,“i32”]},{“name”:“ijkRotate60cw",“ret”:“i1”,“args”:[“i32*”]},{“name”:“convert_meters_to_merc_pixel_height”,“ret”:“double”,“args”:[“double”,“double”,“double”,“double”,“double”,“i32”,“double”]},{“name”:“Round”,“ret”:“double”,“args”:[“double”,“i32”]},{“name”:“ST_Intersects_Polygon_Polygon”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“is_point_size_in_view”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32”,“double”,“double”,“double”,“double”,“double”]},{“name”:“conv_4326_900913_x”,“ret”:“double”,“args”:[“double”]},{“name”:“Contains_Polygon_Point_Impl”,“ret”:“i1”,“args”:[“i8*”,“i64”,“i32*”,“i64”,“double*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“conv_4326_900913_y”,“ret”:“double”,“args”:[“double”]},{“name”:“Atan”,“ret”:“double”,“args”:[“double”]},{“name”:"ct_device_selection_udf_cpu__cpu”,“ret”:“i32”,“args”:[“i32”]},{“name”:“Floor”,“ret”:“double”,“args”:[“double”]},{“name”:“orientation”,“ret”:“i16”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”]},{“name”:“Truncate__1”,“ret”:“i16”,“args”:[“i16”,“i32”]},{“name”:“ST_Distance_Point_Point”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“Truncate__2”,“ret”:“i32”,“args”:[“i32”,“i32”]},{“name”:“is_left”,“ret”:“i64”,“args”:[“i64”,“i64”,“i64”,“i64”,“i64”,“i64”]},{“name”:“Truncate__3”,“ret”:“i64”,“args”:[“i64”,“i32”]},{“name”:“is_point_in_merc_view”,“ret”:“i1”,“args”:[“double”,“double”,“double”,“double”,“double”,“double”]},{“name”:“degsToRads”,“ret”:“double”,“args”:[“double”]},{“name”:"Tan”,“ret”:“double”,“args”:[“float”]},{“name”:“polygon_contains_linestring”,“ret”:“i1”,“args”:[“i8*”,“i32”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:"_geoAzimuthRads",“ret”:“double”,“args”:[“double*”,“double*”]},{“name”:“pi”,“ret”:“double”,“args”:},{“name”:“Round__1”,“ret”:“i16”,“args”:[“i16”,“i32”]},{“name”:“ST_Distance_Point_Point_Squared”,“ret”:“double”,“args”:[“i8*”,“i64”,“i8*”,“i64”,“i32”,“i32”,“i32”,“i32”,“i32”]},{“name”:“Exp”,“ret”:“double”,“args”:[“double”]},{“name”:“Round__2”,“ret”:“i32”,“args”:[“i32”,“i32”]},{“name”:“Round__3”,“ret”:“i64”,“args”:[“i64”,“i32”]},{“name”:“Round__4”,“ret”:“i64”,“args”:[“i64”,“i32”,“i32”]},{“name”:"_h3Rotate60cw",“ret”:“i64”,“args”:[“i64”]}]

Hi @tslee ,

To me looks that the problem is the Vulkan renderer that’s crashing the server; another user got the same problem

so try to run the server from command line adding

sudo /opt/omnisci/bin/omnisci_server --data /var/lib/omnisci/data --renderer-use-vulkan-driver=false

or to run with

export VK_ICD_FILENAMES=$(ls /usr/share/vulkan/icd.d/nvidia*)
sudo /opt/omnisci/bin/omnisci_server --data /var/lib/omnisci/data --renderer-use-vulkan-driver=false

I am almost sure it will work on both cases (I have the same configuration of your in my notebook and I experience the same crashes)

To fix this you can follow the instructions I posted in the previous message.

Best Regards,
Candido

Hi, @candido.dessanti

I followed the instructions you posted in the previous message.
I removed mesa-vulkan-drivers (by using sudo apt remove mesa-vulkan-drivers) and ran omnisci_server again.

When I put this “–renderer-use-vulkan-driver=false” option in the configuration file it failed again.
I removed that line, it showed the following error messages… but the server worked correctly!

2021-12-08T06:10:09.395744 E 72275 0 0 RenderError.h:69 Error creating Vulkan instance: Vulkan Error: VK_ERROR_EXTENSION_NOT_PRESENT - /home/jenkins-slave/workspace/mapd2-multi/compiler/gcc/host/centos7-cuda-x86_64/render/render/GfxDriver/Drivers/Vulkan/VulkanPlatform.cpp:250 (VulkanResult.cpp:20)
2021-12-08T06:10:09.396587 E 72275 0 0 DBHandler.cpp:533 Backend rendering disabled: Error creating Vulkan instance: Vulkan Error: VK_ERROR_EXTENSION_NOT_PRESENT - /home/jenkins-slave/workspace/mapd2-multi/compiler/gcc/host/centos7-cuda-x86_64/render/render/GfxDriver/Drivers/Vulkan/VulkanPlatform.cpp:250

The problem seems to be resolved, I can use the OmniSci server.
Thanks!

Hi,

Can you try this? with mesa-vulkan-drivers installed?

export VK_ICD_FILENAMES=$(ls /usr/share/vulkan/icd.d/nvidia*)
sudo /opt/omnisci/bin/omnisci_server --data /var/lib/omnisci/data

Asking this because the server started but the backend rendering is disabled, so you aren’t able to user the maps in Immerse.

in the configuration file you should use renderer-use-vulkan-driver=false without --

Candido