API tools faq
paste
Advertisement
brianh6854

Monetdb Issue

brianh6854
Jan 27th, 2013
141
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.94 KB | None | 0 0
raw download clone embed print report
  1. [root@biosphere ]# uname -a
  2. Linux biosphere 3.6.9-2.fc17.x86_64 #1 SMP Tue DEC 4 13:26:04 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
  3. [root@biosphere ]# cat /etc/issue
  4. Fedora release 17 (Beefy Miracle)
  5. Kernel \r ON an \m (\l)
  6. [root@biosphere ]# rpm -qa | grep -i monetdb
  7. MonetDB5-server-11.13.9-20130127.fc17.x86_64
  8. MonetDB-stream-devel-11.13.9-20130127.fc17.x86_64
  9. MonetDB-stream-11.13.9-20130127.fc17.x86_64
  10. MonetDB-11.13.9-20130127.fc17.x86_64
  11. MonetDB-SQL-server5-11.13.9-20130127.fc17.x86_64
  12. MonetDB-geom-MonetDB5-11.13.9-20130127.fc17.x86_64
  13. MonetDB-testing-11.13.9-20130127.fc17.x86_64
  14. MonetDB-client-11.13.9-20130127.fc17.x86_64
  15. MonetDB-jaql-11.13.9-20130127.fc17.x86_64
  16. [brian@biosphere ]$ mclient -u monetdb -d myschema
  17. password:
  18. Welcome TO mclient, the MonetDB/SQL interactive terminal (Oct2012-SP3)
  19. DATABASE: MonetDB v11.13.9 (Oct2012-SP3), 'mapi:monetdb://biosphere:50000/myschema'
  20. TYPE \q TO quit, \? FOR a list OF available commands
  21. auto commit mode: ON
  22. sql>SELECT COUNT(*) AS num FROM "myschema".tablea;
  23. +----------+
  24. | num      |
  25. +==========+
  26. | 10153768 |
  27. +----------+
  28. 1 tuple (4.106ms)
  29. sql>SELECT COUNT(*) AS num FROM "myschema".tableb;
  30. +---------+
  31. | num     |
  32. +=========+
  33. | 8726980 |
  34. +---------+
  35. 1 tuple (4.509ms)
  36. sql>SELECT COUNT(*) AS num FROM "myschema".tablec;
  37. +--------+
  38. | num    |
  39. +========+
  40. | 931376 |
  41. +--------+
  42. 1 tuple (3.579ms)
  43.  
  44. sql>SELECT a.ip_dst AS ip_dst, b.tcp_dport AS tcp_dport, COUNT(*) AS num FROM "myschema".tablea a LEFT JOIN "myschema".tableb b ON (a.guid = b.guid) WHERE b.tcp_dport IS NOT NULL GROUP BY a.ip_dst, b.tcp_dport ORDER BY num DESC LIMIT 20;
  45. +-----------------+-----------+---------+
  46. | ip_dst          | tcp_dport | num     |
  47. +=================+===========+=========+
  48. Results ommited.
  49. +-----------------+-----------+---------+
  50. 20 tuples (5.4s)
  51. sql>SELECT a.ip_dst AS ip_dst, b.udp_dport AS udp_dport, COUNT(*) AS num FROM "myschema".tablea a LEFT JOIN "myschema".tablec b ON (a.guid = b.guid) WHERE b.udp_dport IS NOT NULL GROUP BY a.ip_dst, b.udp_dport ORDER BY num DESC LIMIT 20
  52. more>;
  53. Connection TERMINATED
  54.  
  55. # It crashes interesting tablec has alot less DATA than tableb but tablea joining TO tableb works fine.
  56. [root@biosphere ThreatmonitorDashboard]# du -h /var/monetdb5/dbfarm/ | tail -1
  57. 2,4G    /var/monetdb5/dbfarm/
  58.  
  59. # The Box has 6GB OF Memory
  60.  
  61. [brian@biosphere ]$ su
  62. Passwort:
  63. [root@biosphere ]# monetdb STATUS
  64.      name        state     uptime       health
  65. myschema   crashed                12%,  7m  crash 2013-01-27 18:06:02
  66. [root@biosphere ]# tail -50 /var/log/monetdb/merovingian.log
  67. 2013-01-27 18:01:58 MSG control[1138]: (LOCAL): served STATUS list
  68. 2013-01-27 18:02:07 MSG merovingian[1138]: proxying client localhost:33976 FOR DATABASE 'myschema' TO mapi:monetdb:///var/monetdb5/dbfarm/myschema/.mapi.sock?DATABASE=myschema
  69. 2013-01-27 18:02:07 MSG merovingian[1138]: target connection IS ON LOCAL UNIX DOMAIN socket, passing ON filedescriptor instead OF proxying
  70. 2013-01-27 18:02:18 MSG discovery[1138]: NEW DATABASE mapi:monetdb://biosphere:50000/myschema (ttl=660s)
  71. 2013-01-27 18:02:19 MSG control[1138]: (LOCAL): served STATUS list
  72. 2013-01-27 18:02:21 MSG control[1138]: (LOCAL): served STATUS list
  73. 2013-01-27 18:02:57 MSG control[1138]: (LOCAL): served STATUS list
  74. 2013-01-27 18:02:57 MSG merovingian[1138]: sending process 3212 (DATABASE 'myschema') the TERM signal
  75. 2013-01-27 18:03:57 ERR merovingian[1138]: timeout OF 60 seconds expired, sending process 3212 (DATABASE 'myschema') the KILL signal
  76. 2013-01-27 18:03:57 MSG control[1138]: (LOCAL): stopped DATABASE 'myschema'
  77. 2013-01-27 18:03:57 MSG merovingian[1138]: DATABASE 'myschema' (3212) was killed BY signal SIGKILL
  78. 2013-01-27 18:04:05 MSG control[1138]: (LOCAL): served STATUS list
  79. 2013-01-27 18:04:05 MSG merovingian[1138]: DATABASE 'myschema' has crashed after START ON 2013-01-27 17:58:56, attempting restart, up MIN/avg/MAX: 4s/7m/18m, crash average: 1.00 0.90 0.70 (24-3=21)
  80. 2013-01-27 18:04:05 MSG control[1138]: (LOCAL): started 'myschema'
  81. 2013-01-27 18:04:05 MSG myschema[3612]: arguments: /usr/bin/mserver5 --set gdk_dbfarm=/var/monetdb5/dbfarm --dbname=myschema --set merovingian_uri=mapi:monetdb://biosphere:50000/myschema --set mapi_open=false --set mapi_port=0 --set mapi_usock=/var/monetdb5/dbfarm/myschema/.mapi.sock --set monet_vault_key=/var/monetdb5/dbfarm/myschema/.vaultkey --set gdk_nr_threads=2 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes
  82. 2013-01-27 18:04:05 MSG myschema[3612]: # MonetDB 5 server v11.13.9 "Oct2012-SP3"
  83. 2013-01-27 18:04:05 MSG myschema[3612]: # Serving DATABASE 'myschema', USING 2 threads
  84. 2013-01-27 18:04:05 MSG myschema[3612]: # Compiled FOR x86_64-unknown-linux-gnu/64bit WITH 64bit OIDs dynamically linked
  85. 2013-01-27 18:04:05 MSG myschema[3612]: # Found 5.800 GiB available main-memory.
  86. 2013-01-27 18:04:05 MSG myschema[3612]: # Copyright (c) 1993-July 2008 CWI.
  87. 2013-01-27 18:04:05 MSG myschema[3612]: # Copyright (c) August 2008-2013 MonetDB B.V., ALL rights reserved
  88. 2013-01-27 18:04:05 MSG myschema[3612]: # Visit http://www.monetdb.org/ FOR further information
  89. 2013-01-27 18:04:05 MSG myschema[3612]: # Listening FOR UNIX DOMAIN connection requests ON mapi:monetdb:///var/monetdb5/dbfarm/myschema/.mapi.sock
  90. 2013-01-27 18:04:05 MSG myschema[3612]: # MonetDB/GIS module loaded
  91. 2013-01-27 18:04:05 MSG myschema[3612]: # MonetDB/JAQL module loaded
  92. 2013-01-27 18:04:05 MSG myschema[3612]: # MonetDB/SQL module loaded
  93. 2013-01-27 18:04:36 MSG merovingian[1138]: proxying client localhost:33977 FOR DATABASE 'myschema' TO mapi:monetdb:///var/monetdb5/dbfarm/myschema/.mapi.sock?DATABASE=myschema
  94. 2013-01-27 18:04:36 MSG merovingian[1138]: target connection IS ON LOCAL UNIX DOMAIN socket, passing ON filedescriptor instead OF proxying
  95. 2013-01-27 18:04:42 MSG merovingian[1138]: DATABASE 'myschema' (3612) was killed BY signal SIGSEGV
  96. 2013-01-27 18:06:02 MSG control[1138]: (LOCAL): served STATUS list
  97. 2013-01-27 18:06:02 MSG merovingian[1138]: DATABASE 'myschema' has crashed after START ON 2013-01-27 18:04:05, attempting restart, up MIN/avg/MAX: 4s/7m/18m, crash average: 1.00 0.90 0.73 (25-3=22)
  98. 2013-01-27 18:06:03 MSG control[1138]: (LOCAL): started 'myschema'
  99. 2013-01-27 18:06:03 MSG myschema[3753]: arguments: /usr/bin/mserver5 --set gdk_dbfarm=/var/monetdb5/dbfarm --dbname=myschema --set merovingian_uri=mapi:monetdb://biosphere:50000/myschema --set mapi_open=false --set mapi_port=0 --set mapi_usock=/var/monetdb5/dbfarm/myschema/.mapi.sock --set monet_vault_key=/var/monetdb5/dbfarm/myschema/.vaultkey --set gdk_nr_threads=2 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes
  100. 2013-01-27 18:06:03 MSG myschema[3753]: # MonetDB 5 server v11.13.9 "Oct2012-SP3"
  101. 2013-01-27 18:06:03 MSG myschema[3753]: # Serving DATABASE 'myschema', USING 2 threads
  102. 2013-01-27 18:06:03 MSG myschema[3753]: # Compiled FOR x86_64-unknown-linux-gnu/64bit WITH 64bit OIDs dynamically linked
  103. 2013-01-27 18:06:03 MSG myschema[3753]: # Found 5.800 GiB available main-memory.
  104. 2013-01-27 18:06:03 MSG myschema[3753]: # Copyright (c) 1993-July 2008 CWI.
  105. 2013-01-27 18:06:03 MSG myschema[3753]: # Copyright (c) August 2008-2013 MonetDB B.V., ALL rights reserved
  106. 2013-01-27 18:06:03 MSG myschema[3753]: # Visit http://www.monetdb.org/ FOR further information
  107. 2013-01-27 18:06:03 MSG myschema[3753]: # Listening FOR UNIX DOMAIN connection requests ON mapi:monetdb:///var/monetdb5/dbfarm/myschema/.mapi.sock
  108. 2013-01-27 18:06:03 MSG myschema[3753]: # MonetDB/GIS module loaded
  109. 2013-01-27 18:06:03 MSG myschema[3753]: # MonetDB/JAQL module loaded
  110. 2013-01-27 18:06:03 MSG myschema[3753]: # MonetDB/SQL module loaded
  111. 2013-01-27 18:06:13 MSG merovingian[1138]: proxying client (LOCAL) FOR DATABASE 'myschema' TO mapi:monetdb:///var/monetdb5/dbfarm/myschema/.mapi.sock?DATABASE=myschema
  112. 2013-01-27 18:06:13 MSG merovingian[1138]: target connection IS ON LOCAL UNIX DOMAIN socket, passing ON filedescriptor instead OF proxying
  113. 2013-01-27 18:06:13 MSG merovingian[1138]: proxying client (LOCAL) FOR DATABASE 'myschema' TO mapi:monetdb:///var/monetdb5/dbfarm/myschema/.mapi.sock?DATABASE=myschema
  114. 2013-01-27 18:06:13 MSG merovingian[1138]: target connection IS ON LOCAL UNIX DOMAIN socket, passing ON filedescriptor instead OF proxying
  115. 2013-01-27 18:07:05 MSG merovingian[1138]: DATABASE 'myschema' (3753) was killed BY signal SIGSEGV
  116. 2013-01-27 18:07:23 MSG control[1138]: (LOCAL): served STATUS list
  117. [root@biosphere ]# dmesg | tail -20
  118. [4083107.484892] device p6p1 LEFT promiscuous mode
  119. [4083426.553995] mserver5[27459]: segfault at 0 ip 00007f12b1276fc0 sp 00007f1257b5d830 error 4 IN libbat.so.8.0.1[7f12b125d000+2a3000]
  120. [4084889.430916] mserver5[16741]: segfault at 7fa33941fff8 ip 00007fa39be6177c sp 00007fa341c1e780 error 4 IN libbat.so.8.0.3[7fa39bd6a000+349000]
  121. [4085893.283501] mserver5[16803]: segfault at 7f6d24d7dff8 ip 00007f6d819d277c sp 00007f6d27b5d780 error 4 IN libbat.so.8.0.3[7f6d818db000+349000]
  122. [4085999.862580] mserver5[16857]: segfault at 7f9e0cefeff8 ip 00007f9e85aa777c sp 00007f9e774b4780 error 4 IN libbat.so.8.0.3[7f9e859b0000+349000]
  123. [4087710.447023] mserver5[17150]: segfault at 7fac9919eff8 ip 00007fad4c1f177c sp 00007fad3ddff780 error 4 IN libbat.so.8.0.3[7fad4c0fa000+349000]
  124. [4098766.959341] mserver5[22047]: segfault at 7f5a302bfff8 ip 00007f5a77a4977c sp 00007f5a17bfc780 error 4 IN libbat.so.8.0.3[7f5a77952000+349000]
  125. [4137069.542054] device p6p1 entered promiscuous mode
  126. [4138409.252642] mserver5[1130]: segfault at 7fae01d1dff8 ip 00007fae8eb0a77c sp 00007fae805177e0 error 4 IN libbat.so.8.0.3[7fae8ea13000+349000]
  127. [4138409.390857] device p6p1 LEFT promiscuous mode
  128. [4139227.439936] mserver5[2362]: segfault at 7f235e3b3ff8 ip 00007f23c07667cc sp 00007f235b311790 error 4 IN libbat.so.8.0.3[7f23c04ab000+349000]
  129. [4139244.212386] mserver5[2391]: segfault at 7fa8e141fff8 ip 00007fa94f58d7cc sp 00007fa8eaade790 error 4 IN libbat.so.8.0.3[7fa94f2d2000+349000]
  130. [4139469.413760] mserver5[2687]: segfault at 7fc18d41fff8 ip 00007fc1f8c697cc sp 00007fc194bdd790 error 4 IN libbat.so.8.0.3[7fc1f89ae000+349000]
  131. [4139487.063208] mserver5[2720]: segfault at 7f1db141fff8 ip 00007f1e12bd977c sp 00007f1db989e780 error 4 IN libbat.so.8.0.3[7f1e12ae2000+349000]
  132. [4139636.146238] mserver5[2887]: segfault at 7fa89cbbdff8 ip 00007fa8f9cc477c sp 00007fa89fb9e780 error 4 IN libbat.so.8.0.3[7fa8f9bcd000+349000]
  133. [4139649.070083] mserver5[2912]: segfault at 7fc96d41fff8 ip 00007fc9d056577c sp 00007fc9c2173780 error 4 IN libbat.so.8.0.3[7fc9d046e000+349000]
  134. [4139747.088153] mserver5[3076]: segfault at 7f3138cdfff8 ip 00007f319caea77c sp 00007f3143b9e780 error 4 IN libbat.so.8.0.3[7f319c9f3000+349000]
  135. [4139836.092259] mserver5[3197]: segfault at 7f1d60bbdff8 ip 00007f1dbdbac77c sp 00007f1d63b9e780 error 4 IN libbat.so.8.0.3[7f1dbdab5000+349000]
  136. [4140194.902851] mserver5[3667]: segfault at 7f07a4bbdff8 ip 00007f0800bf377c sp 00007f07a7b9e780 error 4 IN libbat.so.8.0.3[7f0800afc000+349000]
  137. [4140337.563514] mserver5[3834]: segfault at 7fb43e6beff8 ip 00007fb4b72d077c sp 00007fb4a8cdd780 error 4 IN libbat.so.8.0.3[7fb4b71d9000+349000]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!