You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/03/09 04:20:40 UTC
[jira] [Commented] (HAWQ-504) Crash when WALSendServer and standby
connection timeout
[ https://issues.apache.org/jira/browse/HAWQ-504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15186416#comment-15186416 ]
ASF GitHub Bot commented on HAWQ-504:
-------------------------------------
Github user wengyanqing commented on the pull request:
https://github.com/apache/incubator-hawq/pull/421#issuecomment-194095421
+1
> Crash when WALSendServer and standby connection timeout
> -------------------------------------------------------
>
> Key: HAWQ-504
> URL: https://issues.apache.org/jira/browse/HAWQ-504
> Project: Apache HAWQ
> Issue Type: Bug
> Reporter: Ming LI
> Assignee: Lei Chang
>
> <SQL>
> BEGIN;
> BEGIN
> INSERT INTO foo_table VALUES (1);
> INSERT 0 1
> SAVEPOINT one;
> SAVEPOINT
> INSERT into bar_table VALUES (1);
> ERROR: relation "bar_table" does not exist
> ROLLBACK TO one;
> ROLLBACK
> RELEASE SAVEPOINT one;
> RELEASE
> SAVEPOINT two;
> SAVEPOINT
> INSERT into barbaz_table VALUES (1);
> INSERT 0 1
> RELEASE two;
> RELEASE
> SAVEPOINT three;
> SAVEPOINT
> SAVEPOINT four;
> SAVEPOINT
> INSERT INTO foo_table VALUES (2);
> INSERT 0 1
> RELEASE SAVEPOINT four;
> RELEASE
> ROLLBACK TO SAVEPOINT three;
> ROLLBACK
> RELEASE SAVEPOINT three;
> RELEASE
> INSERT INTO foo_table VALUES (3);
> INSERT 0 1
> COMMIT;
> COMMIT
> SELECT * FROM foo_table;
> PANIC: Read from 'WAL Send Server' timed out after 30.000 seconds
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> connection to server was lost
> <SQL>
> <quote>
> Core was generated by `postgres: port 31000, gpadmin gptest 192.168.2.100(45663) con116 cmd50 SELECT 1'.
> Program terminated with signal 6, Aborted.
> (gdb) bt
> #0 0x00000033f5232925 in raise () from /lib64/libc.so.6
> #1 0x00000033f5234105 in abort () from /lib64/libc.so.6
> #2 0x000000000087123e in errfinish (dummy=<value optimized out>) at elog.c:682
> #3 0x000000000074edea in ServiceClientRead (serviceClient=0xe41980, response=<value optimized out>, responseLen=<value optimized out>, timeout=<value optimized out>) at service.c:566
> #4 0x00000000004f0c35 in XLogQDMirrorWaitForResponse (WriteRqst=..., flexible=<value optimized out>, xlog_switch=<value optimized out>) at xlog.c:1920
> #5 XLogQDMirrorWrite (WriteRqst=..., flexible=<value optimized out>, xlog_switch=<value optimized out>) at xlog.c:2005
> #6 XLogWrite (WriteRqst=..., flexible=<value optimized out>, xlog_switch=<value optimized out>) at xlog.c:2354
> #7 0x00000000004f178a in XLogFlush (record=<value optimized out>) at xlog.c:2572
> #8 0x00000000004e0ef0 in RecordTransactionCommit () at xact.c:1124
> #9 0x00000000004e3271 in CommitTransaction () at xact.c:2348
> #10 0x00000000004e3fbd in CommitTransactionCommand () at xact.c:3168
> #11 0x00000000007ae170 in finish_xact_command (query_string=<value optimized out>, seqServerHost=<value optimized out>, seqServerPort=<value optimized out>) at postgres.c:3123
> #12 exec_simple_query (query_string=<value optimized out>, seqServerHost=<value optimized out>, seqServerPort=<value optimized out>) at postgres.c:1780
> #13 0x00000000007afedc in PostgresMain (argc=<value optimized out>, argv=0x3284be8, username=<value optimized out>) at postgres.c:4738
> #14 0x0000000000763913 in BackendRun (port=0x3245750) at postmaster.c:5891
> #15 BackendStartup (port=0x3245750) at postmaster.c:5484
> #16 0x000000000076407d in ServerLoop () at postmaster.c:2163
> #17 0x0000000000765eae in PostmasterMain (argc=9, argv=0x325b5b0) at postmaster.c:1454
> #18 0x00000000006c029a in main (argc=9, argv=0x325b570) at main.c:226
> </quote>
> After that, all process on master node will be restarted, and standby will be out of sync.
> <quote>
> postgres=# select * from gp_master_mirroring ;
> summary_state | detail_state | log_time | error_message
> ------------------+-----------------------+------------------------+-------------------------------------
> -----------------------
> Not Synchronized | WAL Send server error | 2016-03-07 00:26:14-08 | Read from 'WAL Send Server' timed ou
> t after 30.000 seconds
> (1 row)
> </quote>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)