[root@localhost ~]# service IBSng start
Starting IBSng Core: importing required files ...
forking ...
IBSng started with pid=0
Calling Initializer routins
IBSng started with pid=6412
Shutting down on error
IBSng Failed to start!
Traceback (most recent call last):
File "/usr/local/IBSng/ibs.py", line 65, in start
mainThreadInitialize()
File "/usr/local/IBSng/ibs.py", line 40, in mainThreadInitialize
core.main.init()
File "/usr/local/IBSng/core/main.py", line 32, in init
db_main.init()
File "/usr/local/IBSng/core/db/db_main.py", line 48, in init
dbpool.initPool()
File "/usr/local/IBSng/core/db/dbpool.py", line 130, in initPool
main_pool=DBPool()
File "/usr/local/IBSng/core/db/dbpool.py", line 16, in __init__
self.__initializeHandles()
File "/usr/local/IBSng/core/db/dbpool.py", line 23, in __initializeHandles
self.__addNewHandleToPool()
File "/usr/local/IBSng/core/db/dbpool.py", line 34, in __addNewHandleToPool
handle=self.__createNewHandle()
File "/usr/local/IBSng/core/db/dbpool.py", line 39, in __createNewHandle
return db_handle.getDBHandle()
File "/usr/local/IBSng/core/db_handle.py", line 4, in getDBHandle
return db_pg.db_pg("IBSng",DB_HOST,DB_PORT,DB_USERNAME,DB_PASSWORD)
File "/usr/local/IBSng/core/db/ibs_db.py", line 9, in __init__
self.connect(dbname,host,port,user,password)
File "/usr/local/IBSng/core/db/db_pg.py", line 17, in connect
raise ibs_exceptions.DBException(str(e))
DBException: FATAL: database is not accepting commands to avoid wraparound data loss in database "template1"
HINT: Stop the postmaster and use a standalone backend to vacuum database "template1".
[FAILED]
[root@localhost ~]# Traceback (most recent call last):
File "/usr/local/IBSng/ibs.py", line 89, in ?
start()
File "/usr/local/IBSng/ibs.py", line 75, in start
core.main.mainThreadShutdown()
File "/usr/local/IBSng/core/main.py", line 144, in mainThreadShutdown
server.shutdown()
File "/usr/local/IBSng/core/server/server.py", line 25, in shutdown
if not server_started:
NameError: global name 'server_started' is not defined
q
این مشکل vacuum دیتابیس هست که باید هر دیتابیسی که مشکل دارد ... دستورات زیر را برایش اجرا کنید:
service postgresql stop
su postgres
touch /tmp/fix.sql
echo "VACUUM FULL;" > /tmp/fix.sql
postgres -D /var/lib/pgsql/data YOUR_DATABASE_NAME < /tmp/fix.sql
بهجای YOUR_DATABASE_NAME اسمدیتابیسیکهمشکلدارهرومینویسیداینجاباتوجهبهاروریکهداده
DBException: FATAL: database is not accepting commands to avoid wraparound data loss in database "
postgres
"
دیتابیس postgres مشکلدارهپسدستوراینمیشه
postgres -D /var/lib/pgsql/data postgres < /tmp/fix.sql
exit
service postgresql restart
