Hello People,

I have a serious problem.
The Slony began to make the error below, I tried to restart it to see if
returned but continued to give the same thing.
I tried in several places, but found nothing. Even talking to my Network
Administrator forming in Linux to see if it would be a problem in the
machine, but he told me what could be a problem in the DB.

I tried the following:
* Database restart in the slave
* Recreated table sl_node in the master
* Vacuumed and reindexed tables sl_node and sl_confirm (Master / Slave)
* Reset the Postgres service in the slave

SQL that the Slony does and has given the problem is (I get it in the src):

        /*
         * Read configuration table sl_node
         */
        dstring_init(&query);
        slon_mkquery(&query,
                                 "select no_id, no_active, no_comment, "
                                 "    (select coalesce(max(con_seqno),0)
from %s.sl_confirm "
                                 "        where con_origin =3D no_id and
con_received =3D %d) "
                                 "        as last_event "
                                 "from %s.sl_node "
                                 "order by no_id; ",
                                 rtcfg_namespace, rtcfg_nodeid,
rtcfg_namespace);
        res =3D PQexec(startup_conn, dstring_data(&query));
        if (PQresultStatus(res) !=3D PGRES_TUPLES_OK)
        {
                slon_log(SLON_FATAL, "main: Cannot get node list - %s\n",
                                 PQresultErrorMessage(res));
                PQclear(res);
                dstring_free(&query);
                slon_retry();
        }

2008-05-26 14:45:43 BRT DEBUG2 slon_retry() from pid=3D23678
2008-05-26 14:45:43 BRT DEBUG1 slon: retry requested
2008-05-26 14:45:43 BRT DEBUG2 slon: notify worker process to shutdown
2008-05-26 14:45:43 BRT DEBUG2 slon: child terminated status: 0; pid: 23678,
current worker pid: 23678
2008-05-26 14:45:43 BRT DEBUG1 slon: restart of worker
2008-05-26 14:45:43 BRT CONFIG main: slon version 1.2.8 starting up
2008-05-26 14:45:43 BRT DEBUG2 slon: watchdog process started
2008-05-26 14:45:43 BRT DEBUG2 slon: watchdog ready - pid =3D 23464
2008-05-26 14:45:43 BRT DEBUG2 slon: worker process created - pid =3D 23681
2008-05-26 14:45:44 BRT CONFIG main: local node id =3D 2
2008-05-26 14:45:44 BRT DEBUG2 main: main process started
2008-05-26 14:45:44 BRT CONFIG main: launching sched_start_mainloop
2008-05-26 14:45:44 BRT CONFIG main: loading current cluster configuration

2008-05-26 14:45:44 BRT FATAL  main: Cannot get node list - ERROR: cannot
open segment 1 from relation 1663/242628616/279475826 (target block
250120132): File or directory not found

2008-05-26 14:45:44 BRT DEBUG2 slon_retry() from pid=3D23681
2008-05-26 14:45:44 BRT DEBUG1 slon: retry requested
2008-05-26 14:45:44 BRT DEBUG2 slon: notify worker process to shutdown
2008-05-26 14:45:44 BRT DEBUG2 slon: child terminated status: 0; pid: 23681,
current worker pid: 23681
2008-05-26 14:45:44 BRT DEBUG1 slon: restart of worker
2008-05-26 14:45:44 BRT CONFIG main: slon version 1.2.8 starting up
2008-05-26 14:45:44 BRT DEBUG2 slon: watchdog process started
2008-05-26 14:45:44 BRT DEBUG2 slon: watchdog ready - pid =3D 23464
2008-05-26 14:45:44 BRT DEBUG2 slon: worker process created - pid =3D 23685

If anyone has any ideas, I thank

Tnks
Rafael Domiciano
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080526/=
0ecfb80c/attachment.htm