From dev-return-2309-archive-asf-public=cust-asf.ponee.io@tephra.incubator.apache.org Tue Dec 11 16:05:33 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id E6F6D180671 for ; Tue, 11 Dec 2018 16:05:32 +0100 (CET) Received: (qmail 79272 invoked by uid 500); 11 Dec 2018 15:05:32 -0000 Mailing-List: contact dev-help@tephra.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tephra.incubator.apache.org Delivered-To: mailing list dev@tephra.incubator.apache.org Received: (qmail 79260 invoked by uid 99); 11 Dec 2018 15:05:31 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2018 15:05:31 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 0142AC0188 for ; Tue, 11 Dec 2018 15:05:31 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.047 X-Spam-Level: ** X-Spam-Status: No, score=2.047 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-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 (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id flm-IR1sn-Tp for ; Tue, 11 Dec 2018 15:05:26 +0000 (UTC) Received: from mail-ed1-f41.google.com (mail-ed1-f41.google.com [209.85.208.41]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 40E745FB54 for ; Tue, 11 Dec 2018 15:05:26 +0000 (UTC) Received: by mail-ed1-f41.google.com with SMTP id d3so12779251edx.7 for ; Tue, 11 Dec 2018 07:05:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=t7kttBoOzNKW1QlEn0cmrVwyKsZb5rnNdntM104TCuQ=; b=ecFMe87EXDwGsPccqyfdHBnOZVAdGvzdy0XTBULAJdR/MlzS9oAuwY7rS8W71JcK9B e0wu1PeZSPyLOgyy+a7WxeQdXJTRhAAm5MbWD3JjWQPxPq2qc4j7fynLeeXkXN2ML+kb 8IcjbykZdbSWzcu/opJwLT4x6uf4klqVZJyCympN0wt7jrUzZinwCYTGe0bTqcIOex2L 5QdbyjeyZ1LQZIDO5VVfTVXm1mpECuc7K/7tfJaPfLrUqHBs9+QR45uSoodaLJT0P8x6 Dc2EM5+pD+eRO4MP+EMMy+/jzz+b3+OFydieiMnzx+5iF4mzMtQ2v4i7+Iw5OgJpiZJI jlwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=t7kttBoOzNKW1QlEn0cmrVwyKsZb5rnNdntM104TCuQ=; b=iOD4xJHYimVJ1i5mo3+htDhbYTIFDnd/uSzviAOCXmjbWOuqXeclm8F7qnNDZ1yZsJ xvQaIY6Tw2kt1yzADEJJfTvsq8dcnvuZ7dr7GI59rAD0/EI8bLhJSOFXBHiN9S3Va2NO 9dOwE+BJ3J6klLfO/ukvA/qe77adUw1uShDqfdKe2hFOA/muPgLXfzC5nyGAXUrvOeD3 EALjHAhy21oI7KLIa5/ijNBMpILXlAHInCuKGph5xweUd+W+JyOH+NLGhNek1QAqatSX 5gPOQ2rwuhResAxqdWFdnCuvGW9r6uxrCqKnPZqERvlkXp7lpp5tJZRsmmgJMdyn1Z/y 85gQ== X-Gm-Message-State: AA+aEWZ1+zVQK0uBMyfrrZNaiUxhzV5SYE2xaXLHIMz4NMlpjIIPdrUQ Q8JugaHLc2cMgYRUKKlRIQVoWlKE8FygMGd6yCv+buKz X-Google-Smtp-Source: AFSGD/VubXFALcBNJam4xwNXEn5uCbPpKhg2IVdZHJVuDfnQhDQcvxsguDEZ/JUthpZfx522dgns6uVuuLo/UILSuK8= X-Received: by 2002:a50:8163:: with SMTP id 90mr15506771edc.174.1544540724952; Tue, 11 Dec 2018 07:05:24 -0800 (PST) MIME-Version: 1.0 From: Varun Rao Date: Tue, 11 Dec 2018 10:05:14 -0500 Message-ID: Subject: SELECT after INSERT shows missing data To: dev@tephra.incubator.apache.org Content-Type: multipart/alternative; boundary="00000000000040808e057cc069ed" --00000000000040808e057cc069ed Content-Type: text/plain; charset="UTF-8" Hello, We have an application that issues two sequential inserts within the same Phoenix/Tephra transaction. Before the second insert, a check is performed to ensure data from the first insert is available (select ...). This check failed once in production (an intermittent problem which has not been reproduced). Phoenix/Tephra is being accessed through Spring (which uses Java Transaction API) with 'read committed' and 'propagation.required' options. The code is similar to the following: @transactional void insertOuter(Object obj1, Object obj2) throws SomeException { // Spring call to insert obj1 into Phoenix transactional table1 insertInner(obj2) } @Transactional void insertInner(Object obj) throws SomeException { checkToEnsureObj1WasInserted() // ** THIS FAILS ... // code to insert object 2 } We expect to see that subsequent write operations within the same Phoenix transactions are guaranteed to see the results of prior operations (the second write will have access to the first write) 1) Should Java Spring be compatible with Phoenix/Tephra? 2) Is there a particular Phoenix/Tephra logging configuration that can be enabled to capture additional transaction-specific information, such as when commits or rollbacks occur? Thanks very much --00000000000040808e057cc069ed--