From users-return-49198-archive-asf-public=cust-asf.ponee.io@activemq.apache.org Fri Jan 26 10:07:51 2018 Return-Path: X-Original-To: archive-asf-public@eu.ponee.io Delivered-To: archive-asf-public@eu.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by mx-eu-01.ponee.io (Postfix) with ESMTP id C50E4180657 for ; Fri, 26 Jan 2018 10:07:51 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id B5297160C3E; Fri, 26 Jan 2018 09:07:51 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 05A6B160C20 for ; Fri, 26 Jan 2018 10:07:50 +0100 (CET) Received: (qmail 33676 invoked by uid 500); 26 Jan 2018 09:07:49 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 33651 invoked by uid 99); 26 Jan 2018 09:07:48 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Jan 2018 09:07:48 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 62D151A066C for ; Fri, 26 Jan 2018 09:07:48 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 5.21 X-Spam-Level: ***** X-Spam-Status: No, score=5.21 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, URI_HEX=1.313, URI_TRY_3LD=1.999] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id Bt5ZchDMCH8K for ; Fri, 26 Jan 2018 09:07:47 +0000 (UTC) Received: from mail-pf0-f171.google.com (mail-pf0-f171.google.com [209.85.192.171]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id D5CB95F20C for ; Fri, 26 Jan 2018 09:07:46 +0000 (UTC) Received: by mail-pf0-f171.google.com with SMTP id e76so7908821pfk.1 for ; Fri, 26 Jan 2018 01:07:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=R3a5Nnv0iVpF4YSJZmUwsz44ehwWDoIF73phrOrETus=; b=gSNsKlV1OhFK1aeA9Qh5IL+j/lnqxO12NZHbEBoK/2vrAEMq00rujPrHxrCEV+cD4s mnLX332W9OTBiISwKamRlKVRUodQNB2QnR8P+XMpGfGocRhwMf0vnZtQ0+cmGSB5kbKX zegdHNTGyfAFa3CUQ7TqFfNTAdgkuyxD3LeVgmt4Iulo50qKTTroo/8ByxCxwVoGPTbD fI1HV09/qgVWtajA/Ub0xusRx5vLVAHNeGnCZ6dcUoNgPTMFptg25E7ErUZP/uuA4NQE 4hr3ZF+Mu0eeC5JktBVoZXwNKWudwzY1X/C6zrCsc8Hzcccqs2vFq/pVsTcbN8f953nr 994w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=R3a5Nnv0iVpF4YSJZmUwsz44ehwWDoIF73phrOrETus=; b=sduvDHggxbrKHo1qKeXq4b0rU1lvMbi0SkcDbgS9dKdNEa888YmllKq8Hd8+vvf0GY UKi0Q8ryVxd57OOTzBKmfZFo0OwBr+tj18pmTc5dvyjQQBiVChoHcfS/0tauWXTCpEdM 5IPbmjN424+972yhNuYmPB23+T7DIMmXCzyLHNH3XQ12FmYaDUhQDnbcFgCwXzw6IVXo WymOIT6ff3MkQDLoaXe6RYmk21vhE1Ylbo2xDf9r9OdOpE6YkYp4N0z+UL7RnfL1KHau +w3p1GfnQU7WdINjMOawmb0MgJs13uipQSz83Yx72Z4lSiNWus79c1zCbETRXiIWHi8y SLsw== X-Gm-Message-State: AKwxytdAKYveV/lF5CZpTLC7udL2D1zjsSarCzhKlycGrLqY+yiYigSp NdKcIC+ea3ukUiEAxNXOixHmiNcjnmnVY2ek2fo= X-Google-Smtp-Source: AH8x226pDVfZukzHt8+QMAtiTsolqkDYQNk3ot8LNYrz66HT0CG0ROXO4XHpX9KE7TrNDue2TMa9ljB1A7wW2kYM5LQ= X-Received: by 10.99.37.7 with SMTP id l7mr4503017pgl.311.1516957660217; Fri, 26 Jan 2018 01:07:40 -0800 (PST) MIME-Version: 1.0 References: <1516956771979-0.post@n4.nabble.com> In-Reply-To: <1516956771979-0.post@n4.nabble.com> From: Francesco Nigro Date: Fri, 26 Jan 2018 09:07:29 +0000 Message-ID: Subject: Re: [ARTEMIS] Server doesn't start if JDBC store is used and table NODE_MANAGER_STORE is empty To: users@activemq.apache.org Content-Type: multipart/alternative; boundary="94eb2c03151c7a06550563aa3a1a" --94eb2c03151c7a06550563aa3a1a Content-Type: text/plain; charset="UTF-8" Hi! AFAIK that table is part of the effort to provide HA Shared Store feature when a JDBC Journal is configured, hence I suppose that the same issue would be likely to happen for the other JDBC Journal tables as well. The solutions I see are: 1 - have the user granted to create/modify schema in order to have the whole JDBC features working properly 2 - manually create the missing table(s) (it is not the best EVER solution but it solves the issue) IMO having proper granted users would be the best one. I hope this could help :) Cheers, Franz Il giorno ven 26 gen 2018 alle ore 09:52 Archibald ha scritto: > Hi all, > > 2.4.0 introduced a new table NODE_MANAGER_STORE. This table is being > created > on startup if it doesn't exist. > But if it does exist but is empty server fails to start (seen on a oracle > database) with > > 08:43:20,510 INFO [org.apache.activemq.artemis.integration.bootstrap] > AMQ101000: Starting ActiveMQ Artemis Server > activemq_1 | can't write NODE_ID on the JDBC Node Manager Store! > > The issue is that the database user it is not always allowed (has the > proper > grants) to create/modify a schema. > > Can this be fixed? > > Thanks, > Archibald > > > > -- > Sent from: > http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html > --94eb2c03151c7a06550563aa3a1a--