Can you run a server built from source with debugging enabled? When I was having problems with MERGE tables, that was the only way to figure out what was going wrong. It sounds like you have a reproducible test case.
From: users-list [mailto:users-list-bounces+david.b.anderson=citi.com@monetdb.org] On Behalf Of Ariel Abadi
Sent: Sunday, July 17, 2016 11:22 PM
To: Communication channel for MonetDB users
Subject: Re: MERGE TABLE ERROR
We are having a serious problem. Every time the DB starts doing crazy things with the MERGE tables (as described in the email attached). The DB crashes for ever.
2016-07-17 23:51:29 MSG merovingian[10151]: database 'trafico' (10165) was killed by signal SIGSEGV
2016-07-17 23:51:29 ERR control[10151]: (local): failed to fork mserver: database 'trafico' appears to shut itself down after starting, check monetdbd's logfile for possible hints
2016-07-17 23:52:16 MSG merovingian[10151]: caught SIGTERM, starting shutdown sequence
2016-07-17 23:52:19 MSG merovingian[10151]: Merovingian 1.7 stopped
2016-07-17 23:52:19 MSG control[10151]: control channel closed
The only way to recover is creating a newly fresh DBFARM.
If anyone knows something please help me!. We are creating the DB every week :(
Ariel Abadi
Direct: +54 11 5279.2054
Mobile:+54 9 11 6050.0101
Email: aabadi@starconnecting.commailto:aabadi@starconnecting.com
Web: www.starconnecting.comhttps://urldefense.proofpoint.com/v2/url?u=http-3A__www.starconnecting.com&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=F97qUo-qi7nXgmnzI_zs_JPUY1_Gdbuxk73xGr75Kik&e=
On Sun, Jul 17, 2016 at 8:09 PM, Ariel Abadi mailto:aabadi@starconnecting.com> wrote:
Hi!
We are facing a problem with MERGE Tables.
We have a process in php which connects to the DB using the mapi (https://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/MAPIhttps://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_url-3Fq-3Dhttps-253A-252F-252Fwww.monetdb.org-252FDocumentation-252FManuals-252FSQLreference-252FProgramming-252FMAPI-26sa-3DD-26sntz-3D1-26usg-3DAFQjCNGpR9jSaQKxbmqRuVF8krphUQBn1g&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=TCBRhMVJpBqohBAbnbUVvgYKPiKFqjtu1E5YpbJopNU&e=)
The process creates a new table everyday as follows:
CREATE TABLE cub8_20160717 AS (SELECT * FROM cub8) WITH NO DATA;
Then, attaches that new table to the MERGE table called cub8_cubo as follows:
ALTER TABLE cub8_cubo ADD TABLE cub8_20160717 ;
Once all this is created, it start inserting data.
Everything works fine, with NO errors. BUT if I run a query against cub8_cubo I dont see cub8_20160717 data.
So I run this query in order to check if the new table was attached to the merge:
SELECT a.namehttps://urldefense.proofpoint.com/v2/url?u=http-3A__a.name&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=ZnIDaE5j_yUr6kSrOOE4Cq3warOfS07K_mIaeOwegkM&e=, b.namehttps://urldefense.proofpoint.com/v2/url?u=http-3A__b.name&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=_JclMJpcqhsINlwHeS8ktjB0_9RuNyYUbZ-cWZjugP0&e=, s.namehttps://urldefense.proofpoint.com/v2/url?u=http-3A__s.name&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=8ilEeDdElFocGAbnSPq-W29d3JFq16BYH0toUBKbg7E&e= FROM sys.tables as a JOIN sys.dependencies d ON a.idhttps://urldefense.proofpoint.com/v2/url?u=http-3A__a.id&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=1_-oTcb5B--YfIwGbvdu9ZiQDpG7hiPmu0AT4pTkvCA&e= = d.depend_id JOIN sys.tables as b ON b.idhttps://urldefense.proofpoint.com/v2/url?u=http-3A__b.id&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=ys7CybxwWMK332gjlTpc32DRDwp5s0jYgVCOHCCqKJU&e== d.idhttps://urldefense.proofpoint.com/v2/url?u=http-3A__d.id&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=N4PPkvTlKUfkg02qExjB4obAPJlr8-MBAEY0eFDAD10&e= JOIN sys.schemas as s ON a.schema_id = s.idhttps://urldefense.proofpoint.com/v2/url?u=http-3A__s.id&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=6dEMFdZ5wFejqBuipNcFWMuLaLfKkE5ifGCPSlIcC9o&e= WHERE a.type= 3 AND a.namehttps://urldefense.proofpoint.com/v2/url?u=http-3A__a.name&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KRZtgsAHenCyBgFZm9GAQBp03krybbhwPad-dLGK_cQ&s=ZnIDaE5j_yUr6kSrOOE4Cq3warOfS07K_mIaeOwegkM&e= ILIKE '%cub8%' ORDER BY 1,2;
+-----------+---------------+
| name | name |
+===========+===============+
| cub8_cubo | cub8_20160710 |
| cub8_cubo | cub8_20160711 |
| cub8_cubo | cub8_20160712 |
| cub8_cubo | cub8_20160713 |
| cub8_cubo | cub8_20160714 |
| cub8_cubo | cub8_20160715 |
| cub8_cubo | cub8_20160716 |
| cub8_cubo | cub8_20160717 |
So I try to detached from cub8_cubo, with the command:
ALTER TABLE cub8_cubo DROP TABLE cub8_20160717;
ALTER TABLE: table 'sb_traf.cub8_20160717' isn't part of the MERGE TABLE 'sb_traf.cub8_cubo'
So I ADD it again:
ALTER TABLE cub8_cubo ADD TABLE cub8_20160717;
and now yes... I can see the data. If I need to detach that table, I need to run ALTER ... DROP twice or three times to get it done.
It seems to be a bug?, are we doing something wrong ??
Thks in advance!
PS.:We are using
MonetDB Database Server v1.7 (Jun2016)
Welcome to mclient, the MonetDB/SQL interactive terminal (Jun2016)
