Thread: londiste re-create leaf node
Hi, I had a londiste3 slave server that no longer works and I want to re-create. I dropped all the pgq and londiste schemas in the leaf node manually...now I want to create the node again, but I'm getting this error: londiste3 /home/londiste/replicacion/db_esclavo.ini create-leaf node_esclavo "dbname=database host=192.65.214.199" --provider="dbname=database host=192.65.214.204" ProgrammingError: schema "pgq_node" does not exist This is obvious, the question is how can I re-create that schema. I tried generating the leaf node again, from the master database, but I get this: 2016-09-09 10:58:41,925 9680 INFO plpgsql is installed 2016-09-09 10:58:41,926 9680 INFO Installing pgq 2016-09-09 10:58:41,957 9680 INFO Reading from /usr/local/share/skytools3/pgq.sql 2016-09-09 10:58:45,130 9680 ERROR Job job_repli_ris_master got error on connection 'db': could not access file "$libdir/pgq_lowlevel": No such file or directory. This is weird, because master is working without issues. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877
El 09/09/16 a las 10:53, Leonardo M. Ramé escribió: > Hi, I had a londiste3 slave server that no longer works and I want to > re-create. > > I dropped all the pgq and londiste schemas in the leaf node > manually...now I want to create the node again, but I'm getting this > error: > > londiste3 /home/londiste/replicacion/db_esclavo.ini create-leaf > node_esclavo "dbname=database host=192.65.214.199" > --provider="dbname=database host=192.65.214.204" > > ProgrammingError: schema "pgq_node" does not exist > > This is obvious, the question is how can I re-create that schema. > > I tried generating the leaf node again, from the master database, but > I get this: > > 2016-09-09 10:58:41,925 9680 INFO plpgsql is installed > 2016-09-09 10:58:41,926 9680 INFO Installing pgq > 2016-09-09 10:58:41,957 9680 INFO Reading from > /usr/local/share/skytools3/pgq.sql > 2016-09-09 10:58:45,130 9680 ERROR Job job_repli_ris_master got error > on connection 'db': could not access file "$libdir/pgq_lowlevel": No > such file or directory. > > This is weird, because master is working without issues. > > Regards, Mmm, built and reinstalled skytools-3.2, but now I'm getting this: InternalError: could not load library "/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so": /usr/lib/postgresql/9.5/lib/pgq_lowlevel.so: undefined symbol: oid_hash -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877
On 09/09/2016 07:15 AM, Leonardo M. Ramé wrote: > El 09/09/16 a las 10:53, Leonardo M. Ramé escribió: >> Hi, I had a londiste3 slave server that no longer works and I want to >> re-create. >> >> I dropped all the pgq and londiste schemas in the leaf node >> manually...now I want to create the node again, but I'm getting this >> error: >> >> londiste3 /home/londiste/replicacion/db_esclavo.ini create-leaf >> node_esclavo "dbname=database host=192.65.214.199" >> --provider="dbname=database host=192.65.214.204" >> >> ProgrammingError: schema "pgq_node" does not exist >> >> This is obvious, the question is how can I re-create that schema. >> >> I tried generating the leaf node again, from the master database, but >> I get this: >> >> 2016-09-09 10:58:41,925 9680 INFO plpgsql is installed >> 2016-09-09 10:58:41,926 9680 INFO Installing pgq >> 2016-09-09 10:58:41,957 9680 INFO Reading from >> /usr/local/share/skytools3/pgq.sql >> 2016-09-09 10:58:45,130 9680 ERROR Job job_repli_ris_master got error >> on connection 'db': could not access file "$libdir/pgq_lowlevel": No >> such file or directory. >> >> This is weird, because master is working without issues. >> >> Regards, > > Mmm, built and reinstalled skytools-3.2, but now I'm getting this: > > InternalError: could not load library > "/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so": > /usr/lib/postgresql/9.5/lib/pgq_lowlevel.so: undefined symbol: oid_hash Well if I read correctly: http://pgfoundry.org/forum/forum.php?forum_id=1951 support only goes up to 9.4 > > -- Adrian Klaver adrian.klaver@aklaver.com
"=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" <l.rame@griensu.com> writes:
> Mmm, built and reinstalled skytools-3.2, but now I'm getting this:
> InternalError: could not load library
> "/usr/lib/postgresql/9.5/lib/pgq_lowlevel.so":
> /usr/lib/postgresql/9.5/lib/pgq_lowlevel.so: undefined symbol: oid_hash
Looks like you built against a set of backend headers that is older than
the server you're trying to run in.
regards, tom lane