Postgresql, FATAL: valor fora do intervalo: ocorreu underflow ao executar o initdb

0

Eu tenho um problema ao instalar o postgres na placa incorporada com base no arm7l. Eu compilei o postgres 9.5.10 e fiz a portabilidade no quadro. mas quando executo o initdb para inicializar o postgres, ele gera um erro FATAL no ponto de criação do banco de dados de modelos. Anexei a mensagem de erro como abaixo.

> VERSION=9.5.10 PGDATA=/data/psql/data share_path=/conf/postgres/share
> PGPATH=/conf/postgres/bin POSTGRES_SUPERUSERNAME=postgres
> POSTGRES_BKI=/conf/postgres/share/postgres.bki
> POSTGRES_DESCR=/conf/postgres/share/postgres.description
> POSTGRES_SHDESCR=/conf/postgres/share/postgres.shdescription
> POSTGRESQL_CONF_SAMPLE=/conf/postgres/share/postgresql.conf.sample
> PG_HBA_SAMPLE=/conf/postgres/share/pg_hba.conf.sample
> PG_IDENT_SAMPLE=/conf/postgres/share/pg_ident.conf.sample 
> DEBUG:  invoking IpcMemoryCreate(size=146210816)
> DEBUG:  mmap(146800640) with MAP_HUGETLB failed, huge pages disabled: Invalid argument
> DEBUG:  SlruScanDirectory invoking callback on pg_notify/0000
> DEBUG:  removing file "pg_notify/0000"
> DEBUG:  dynamic shared memory system will support 288 segments
> DEBUG:  created dynamic shared memory control segment 1804289383 (2316 bytes)
> DEBUG:  transaction ID wrap limit is 2147483650, limited by database with OID 1
> DEBUG:  MultiXactId wrap limit is 2147483648, limited by database with OID 1
> DEBUG:  creating and filling new WAL file
> DEBUG:  done creating and filling new WAL file
> DEBUG:  InitPostgres
> DEBUG:  my backend ID is 1
> NOTICE:  database system was shut down at 2017-11-02 12:46:13 UTC
> DEBUG:  checkpoint record is at 0/1000028
> DEBUG:  redo record is at 0/1000028; shutdown TRUE
> DEBUG:  next transaction ID: 0/3; next OID: 10000
> DEBUG:  next MultiXactId: 1; next MultiXactOffset: 0
> DEBUG:  oldest unfrozen transaction ID: 3, in database 1
> DEBUG:  oldest MultiXactId: 1, in database 1
> DEBUG:  commit timestamp Xid oldest/newest: 0/0
> DEBUG:  transaction ID wrap limit is 2147483650, limited by database with OID 1
> DEBUG:  MultiXactId wrap limit is 2147483648, limited by database with OID 1
> DEBUG:  starting up replication slots
> DEBUG:  MultiXactId wrap limit is 2147483648, limited by database with OID 1
> DEBUG:  MultiXact member stop limit is now 4294914944 based on MultiXact 1
> DEBUG:  StartTransaction
> DEBUG:  name: unnamed;  blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
> DEBUG:  start transaction
> DEBUG:  creating bootstrap relation pg_proc 1255
> DEBUG:  column proname name
> DEBUG:  column pronamespace oid
> DEBUG:  column proowner oid
> DEBUG:  column prolang oid
> DEBUG:  column procost float4
> DEBUG:  column prorows float4
> DEBUG:  column provariadic oid
> DEBUG:  column protransform regproc
> DEBUG:  column proisagg bool
> DEBUG:  column proiswindow bool
> DEBUG:  column prosecdef bool
> DEBUG:  column proleakproof bool
> DEBUG:  column proisstrict bool
> DEBUG:  column proretset bool
> DEBUG:  column provolatile char
> DEBUG:  column pronargs int2
> DEBUG:  column pronargdefaults int2
> DEBUG:  column prorettype oid
> DEBUG:  column proargtypes oidvector
> DEBUG:  column proallargtypes _oid
> DEBUG:  column proargmodes _char
> DEBUG:  column proargnames _text
> DEBUG:  column proargdefaults pg_node_tree
> DEBUG:  column protrftypes _oid
> DEBUG:  column prosrc text
> DEBUG:  column probin text
> DEBUG:  column proconfig _text
> DEBUG:  column proacl _aclitem
> DEBUG:  CommitTransaction
> DEBUG:  name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
> DEBUG:  commit transaction
> DEBUG:  StartTransaction
> DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
> DEBUG:  start transaction
> DEBUG:  bootstrap relation created
> DEBUG:  CommitTransaction
> DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
> DEBUG:  commit transaction
> DEBUG:  StartTransaction
> DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
> DEBUG:  start transaction
> DEBUG:  inserting row with oid 1242
> DEBUG:  inserting column 0 value "boolin"
> DEBUG:  inserted -> boolin
> DEBUG:  inserting column 1 value "11"
> DEBUG:  inserted -> 11
> DEBUG:  inserting column 2 value "10"
> DEBUG:  inserted -> 10
> DEBUG:  inserting column 3 value "12"
> DEBUG:  inserted -> 12
> DEBUG:  inserting column 4 value "1"
> DEBUG:  inserted -> nan
> DEBUG:  inserting column 5 value "0"
> **FATAL:  value out of range: underflow**
> DEBUG:  shmem_exit(1): 1 before_shmem_exit callbacks to make
> DEBUG:  shmem_exit(1): 11 on_shmem_exit callbacks to make
> NOTICE:  shutting down
> DEBUG:  performing replication slot checkpoint
> DEBUG:  attempting to remove WAL segments older than log file 000000000000000000000000
> DEBUG:  SlruScanDirectory invoking callback on pg_subtrans/0000
> NOTICE:  database system is shut down
> DEBUG:  cleaning up dynamic shared memory control segment with ID 1804289383
> DEBUG:  proc_exit(1): 3 callbacks to make DEBUG:  exit(1)
> DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
> DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
> DEBUG:  proc_exit(-1): 0 callbacks to make child process exited with exit code 1 initdb: removing contents of data directory "/data/psql/data"

O binário compilado postgres-9.5.10 está funcionando bem em outra placa que é diferente da anterior. As diferenças são a versão do kernel, a contagem do núcleo, o tamanho do memeory e mais coisas. Por favor, deixe-me saber se você tem uma solução para isso. obrigado.

    
por yjlee 28.11.2017 / 01:05

0 respostas