Re: [Postgres-xc-general] failed to find proc in ProcArray

[Rishi R. <the...@gm...>]

I just tried with REL1_1_STABLE. Here are my logs from the coordinator:

LOG:  database system was shut down at 2014-02-13 10:14:16 EST
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
ERROR:  syntax error at or near "asdf" at character 1
STATEMENT:  asdf;
LOG:  failed to find proc 0x7f7d4a79ea60 in ProcArray
STATEMENT:  create database test;
LOG:  failed to find proc 0x7f7d4a79bc60 in ProcArray
ERROR:  cannot drop the currently open database
STATEMENT:  drop database test;
LOG:  failed to find proc 0x7f7d4a79ea60 in ProcArray
STATEMENT:  drop database test;
ERROR:  syntax error at or near "blah" at character 1
STATEMENT:  blah blah blah;
LOG:  failed to find proc 0x7f7d4a79bc60 in ProcArray
LOG:  failed to find proc 0x7f7d4a79bc60 in ProcArray
LOG:  failed to find proc 0x7f7d4a79bc60 in ProcArray

The logs from the datanode:

LOG:  database system was shut down at 2014-02-13 10:19:33 EST
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
LOG:  failed to find proc 0x7f06bee5ea60 in ProcArray
STATEMENT:  COMMIT PREPARED 'T10014'
LOG:  failed to find proc 0x7f06bee5bc60 in ProcArray
LOG:  failed to find proc 0x7f06bee5ea60 in ProcArray
STATEMENT:  COMMIT PREPARED 'T10023'
LOG:  failed to find proc 0x7f06bee5bc60 in ProcArray
LOG:  failed to find proc 0x7f06bee5bc60 in ProcArray
LOG:  failed to find proc 0x7f06bee5bc60 in ProcArray
LOG:  failed to find proc 0x7f06bee5bc60 in ProcArray
LOG:  failed to find proc 0x7f06bee5bc60 in ProcArray
LOG:  failed to find proc 0x7f06bee5bc60 in ProcArray

The datanode seems to continuously produce logs but the coordinator does
not. I issued CREATE NODE commands to both services but they don't seem to
show up in the log.


On Thu, Feb 13, 2014 at 9:49 AM, Rishi Ramraj
<the...@gm...>wrote:

> I haven't been issuing commits or aborts every 30 seconds. So far, I've
> only issued five commands to the cluster using psql, but I have over 100
> logs. I will try 1.1 today and let you know.
>
> Do you use a specific branching methodology, like gitflow<http://nvie.com/posts/a-successful-git-branching-model/>?
> Do you have a bug tracking system? If you need any help with release
> engineering, let me know; I don't mind volunteering some time.
>
>
> On Thu, Feb 13, 2014 at 1:41 AM, 鈴木 幸市 <ko...@in...> wrote:
>
>> GTM message is just a report.   When GTM starts, it tries to read if
>> there is any slave connected in previous run and it didn’t find one.
>>
>> The first message looks not harmful but could be some potential issues.
>> Please let me look into it.   The chance to have this message is at the
>> initialization of each datanode/coordinator, COMMIT, ABORT, COMMIT PREPARED
>> or ABORT PREPARED.
>>
>> Do you have a chance to issue them every 30 seconds?
>>
>> If possible, could you try release 1.1 and see if you have the same issue
>> (first message)?  I think release 1.1 is better because master is anyway
>> development branch.
>>
>> Best;
>> ---
>> Koichi Suzuki
>>
>> 2014/02/13 14:51、Rishi Ramraj <the...@gm...> のメール：
>>
>> > Hello All,
>> >
>> > I just installed postgres-xc from the git master branch on a test
>> machine. All processes are running on the same box. On both the coordinator
>> and data processes, I'm getting the following logs about every 30 seconds:
>> >
>> > LOG:  failed to find proc 0x7fd9ee703f80 in ProcArray
>> >
>> > On the GTM process, I'm getting the following logs at about the same
>> frequency:
>> >
>> > LOG:  Any GTM standby node not found in registered node(s).
>> > LOCATION:  gtm_standby_connect_to_standby_int, gtm_standby.c:381
>> >
>> > The cluster seems to be working properly. I was able to create a new
>> database and a table within that database without any problem. I restarted
>> all services and the data was persisted, but the logs persist. Any idea
>> what's causing these logs?
>> >
>> > Thanks,
>> > - Rishi
>> >
>> ------------------------------------------------------------------------------
>> > Android apps run on BlackBerry 10
>> > Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>> > Now with support for Jelly Bean, Bluetooth, Mapview and more.
>> > Get your Android app in front of a whole new audience.  Start now.
>> >
>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk_______________________________________________
>> > Postgres-xc-general mailing list
>> > Pos...@li...
>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>
>>
>
>
> --
> Cheers,
> - Rishi
>



-- 
Cheers,
- Rishi