About the OmniSci Core category


#1

This topic is for questions and comments on the OmniSci Core database. Please post questions about install, SQL support, supported hardware, etc. here.


#2

Help me. My ask.

My computer has been K40c & GTX970M.

K40c can using Kepler.

and I have writed mapd.conf like this

gpu = true
num-gpus = 0
start-qpu = 0

But all the time I can’t see result.

select count(*) from flights_2008_7M;

./startmapd &
[4] 16967
[1] Terminated ./startmapd
[3] Terminated ./startmapd
[root@localhost MapD-GPU]# Backend TCP: localhost:9091
Backend HTTP: localhost:9090
Frontend Web: localhost:9092
Calcite TCP: localhost:9093

  • sleeping for 5s while server starts
    F0717 10:42:24.680974 17012 NvidiaKernel.cpp:93] Check failed: cuModuleLoadDataEx(&module_, image, num_options, options, option_vals) == CUDA_SUCCESS (300 vs. 0)
    *** Check failure stack trace: ***
    @ 0x19c2bba google::LogMessage::Fail()
    @ 0x19c2b11 google::LogMessage::SendToLog()
    @ 0x19c24dc google::LogMessage::Flush()
    @ 0x19c5475 google::LogMessageFatal::~LogMessageFatal()
    @ 0xfac2d8 GpuCompilationContext::GpuCompilationContext()
    @ 0xfa6048 Executor::optimizeAndCodegenGPU()
    @ 0xfa8656 Executor::compileWorkUnit()
    @ 0xf5dd16 Executor::ExecutionDispatch::compile()
    @ 0xf4e965 Executor::executeWorkUnit()
    @ 0xfefad8 RelAlgExecutor::executeWorkUnit()
    @ 0xff075d RelAlgExecutor::executeCompound()
    @ 0xff30cd RelAlgExecutor::executeRelAlgStep()
    @ 0xff38bf RelAlgExecutor::executeRelAlgSeq()
    @ 0xff486d RelAlgExecutor::executeRelAlgQuery()
    @ 0xe5f135 MapDHandler::execute_rel_alg()
    @ 0xe659a5 MapDHandler::sql_execute_impl()
    @ 0xe689e1 MapDHandler::sql_execute()
    @ 0xdb7b0e MapDProcessor::process_sql_execute()
    @ 0xda9697 MapDProcessor::dispatchCall()
    @ 0xda354c apache::thrift::TDispatchProcessor::process()
    @ 0x2f7026f apache::thrift::server::TConnectedClient::run()
    @ 0x2f4b6b5 apache::thrift::concurrency::ThreadManager::Task::run()
    @ 0x2f4bbf5 apache::thrift::concurrency::ThreadManager::Worker::run()
    @ 0x2f6a59b apache::thrift::concurrency::PthreadThread::threadMain()

nvidia-smi -q

==============NVSMI LOG==============

Timestamp : Mon Jul 17 10:49:24 2017
Driver Version : 375.66

Attached GPUs : 2
GPU 0000:02:00.0
Product Name : Tesla K40c
Product Brand : Tesla
Display Mode : Disabled
Display Active : Disabled
Persistence Mode : Disabled
Accounting Mode : Disabled
Accounting Mode Buffer Size : 1920
Driver Model
Current : N/A
Pending : N/A
Serial Number : 0320415010475
GPU UUID : GPU-f139bc7b-144c-aac3-fd45-90bffd66d463
Minor Number : 0
VBIOS Version : 80.80.3E.00.02
MultiGPU Board : No
Board ID : 0x200
GPU Part Number : 900-22081-2250-000
Inforom Version
Image Version : 2081.0206.01.04
OEM Object : 1.1
ECC Object : 3.0
Power Management Object : N/A
GPU Operation Mode
Current : N/A
Pending : N/A
GPU Virtualization Mode
Virtualization mode : None
PCI
Bus : 0x02
Device : 0x00
Domain : 0x0000
Device Id : 0x102410DE
Bus Id : 0000:02:00.0
Sub System Id : 0x098310DE
GPU Link Info
PCIe Generation
Max : 3
Current : 1
Link Width
Max : 16x
Current : 8x
Bridge Chip
Type : N/A
Firmware : N/A
Replays since reset : 0
Tx Throughput : N/A
Rx Throughput : N/A
Fan Speed : 25 %
Performance State : P8
Clocks Throttle Reasons
Idle : Active
Applications Clocks Setting : Not Active
SW Power Cap : Not Active
HW Slowdown : Not Active
Sync Boost : Not Active
Unknown : Not Active
FB Memory Usage
Total : 11439 MiB
Used : 0 MiB
Free : 11439 MiB
BAR1 Memory Usage
Total : 256 MiB
Used : 2 MiB
Free : 254 MiB
Compute Mode : Default
Utilization
Gpu : 0 %
Memory : 0 %
Encoder : 0 %
Decoder : 0 %
Encoder Stats
Active Sessions : 0
Average FPS : 0
Average Latency : 0 ms
Ecc Mode
Current : Enabled
Pending : Enabled
ECC Errors
Volatile
Single Bit
Device Memory : 0
Register File : 0
L1 Cache : 0
L2 Cache : 0
Texture Memory : 0
Texture Shared : N/A
Total : 0
Double Bit
Device Memory : 0
Register File : 0
L1 Cache : 0
L2 Cache : 0
Texture Memory : 0
Texture Shared : N/A
Total : 0
Aggregate
Single Bit
Device Memory : 0
Register File : 0
L1 Cache : 0
L2 Cache : 0
Texture Memory : 0
Texture Shared : N/A
Total : 0
Double Bit
Device Memory : 0
Register File : 0
L1 Cache : 0
L2 Cache : 0
Texture Memory : 0
Texture Shared : N/A
Total : 0
Retired Pages
Single Bit ECC : 0
Double Bit ECC : 0
Pending : No
Temperature
GPU Current Temp : 47 C
GPU Shutdown Temp : 95 C
GPU Slowdown Temp : 90 C
Power Readings
Power Management : Supported
Power Draw : 21.18 W
Power Limit : 235.00 W
Default Power Limit : 235.00 W
Enforced Power Limit : 235.00 W
Min Power Limit : 180.00 W
Max Power Limit : 235.00 W
Clocks
Graphics : 324 MHz
SM : 324 MHz
Memory : 324 MHz
Video : 405 MHz
Applications Clocks
Graphics : 745 MHz
Memory : 3004 MHz
Default Applications Clocks
Graphics : 745 MHz
Memory : 3004 MHz
Max Clocks
Graphics : 875 MHz
SM : 875 MHz
Memory : 3004 MHz
Video : 540 MHz
Clock Policy
Auto Boost : N/A
Auto Boost Default : N/A
Processes : None

GPU 0000:04:00.0
Product Name : GeForce GTX 970
Product Brand : GeForce
Display Mode : Enabled
Display Active : Enabled
Persistence Mode : Disabled
Accounting Mode : Disabled
Accounting Mode Buffer Size : 1920
Driver Model
Current : N/A
Pending : N/A
Serial Number : N/A
GPU UUID : GPU-be407530-c665-e731-b9a0-f9183c6f8f07
Minor Number : 1
VBIOS Version : 84.04.84.00.51
MultiGPU Board : No
Board ID : 0x400
GPU Part Number : N/A
Inforom Version
Image Version : N/A
OEM Object : N/A
ECC Object : N/A
Power Management Object : N/A
GPU Operation Mode
Current : N/A
Pending : N/A
GPU Virtualization Mode
Virtualization mode : None
PCI
Bus : 0x04
Device : 0x00
Domain : 0x0000
Device Id : 0x13C210DE
Bus Id : 0000:04:00.0
Sub System Id : 0x113110DE
GPU Link Info
PCIe Generation
Max : 3
Current : 1
Link Width
Max : 16x
Current : 16x
Bridge Chip
Type : N/A
Firmware : N/A
Replays since reset : 0
Tx Throughput : 0 KB/s
Rx Throughput : 4000 KB/s
Fan Speed : 44 %
Performance State : P8
Clocks Throttle Reasons
Idle : Active
Applications Clocks Setting : Not Active
SW Power Cap : Not Active
HW Slowdown : Not Active
Sync Boost : Not Active
Unknown : Not Active
FB Memory Usage
Total : 4037 MiB
Used : 159 MiB
Free : 3878 MiB
BAR1 Memory Usage
Total : 256 MiB
Used : 4 MiB
Free : 252 MiB
Compute Mode : Default
Utilization
Gpu : 0 %
Memory : 4 %
Encoder : 0 %
Decoder : 0 %
Encoder Stats
Active Sessions : 0
Average FPS : 0
Average Latency : 0 ms
Ecc Mode
Current : N/A
Pending : N/A
ECC Errors
Volatile
Single Bit
Device Memory : N/A
Register File : N/A
L1 Cache : N/A
L2 Cache : N/A
Texture Memory : N/A
Texture Shared : N/A
Total : N/A
Double Bit
Device Memory : N/A
Register File : N/A
L1 Cache : N/A
L2 Cache : N/A
Texture Memory : N/A
Texture Shared : N/A
Total : N/A
Aggregate
Single Bit
Device Memory : N/A
Register File : N/A
L1 Cache : N/A
L2 Cache : N/A
Texture Memory : N/A
Texture Shared : N/A
Total : N/A
Double Bit
Device Memory : N/A
Register File : N/A
L1 Cache : N/A
L2 Cache : N/A
Texture Memory : N/A
Texture Shared : N/A
Total : N/A
Retired Pages
Single Bit ECC : N/A
Double Bit ECC : N/A
Pending : N/A
Temperature
GPU Current Temp : 40 C
GPU Shutdown Temp : 96 C
GPU Slowdown Temp : 91 C
Power Readings
Power Management : Supported
Power Draw : 24.65 W
Power Limit : 200.00 W
Default Power Limit : 200.00 W
Enforced Power Limit : 200.00 W
Min Power Limit : 100.00 W
Max Power Limit : 250.00 W
Clocks
Graphics : 135 MHz
SM : 135 MHz
Memory : 324 MHz
Video : 405 MHz
Applications Clocks
Graphics : 1178 MHz
Memory : 3505 MHz
Default Applications Clocks
Graphics : 1178 MHz
Memory : 3505 MHz
Max Clocks
Graphics : 1519 MHz
SM : 1519 MHz
Memory : 3505 MHz
Video : 1397 MHz
Clock Policy
Auto Boost : N/A
Auto Boost Default : N/A
Processes
Process ID : 15018
Type : G
Name : /usr/bin/X
Used GPU Memory : 82 MiB
Process ID : 15380
Type : G
Name : /usr/bin/gnome-shell
Used GPU Memory : 75 MiB