Database admin
Budget: $25 – $50 USD
I am looking for a skilled database administrator who can help me with complete administration of a SQL database.
Skills and Experience Needed:
- Strong expertise in SQL database administration
- Experience with managing and maintaining SQL databases
- Knowledge of performance tuning and optimization techniques
- Familiarity with backup and recovery processes
- Ability to troubleshoot and resolve issues related to database tables
The ideal candidate should have a deep understanding of SQL databases and be able to handle all aspects of database administration, including performance tuning and backup. They should also have experience in resolving issues related to database tables.
Current issue
Hi
Db version - 8.0.0
Two errors
1. From db logs hosted in kubernetes env
WARNING: oldest multixact is far in the past
HINT: Close open transactions with multixacts soon to avoid wraparound problems.
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
You might also need to commit or roll back old prepared transactions, or drop stale replication slots.
2 when querying one table or vacuuming this table called features in the db, can query other tables
ERROR: [data-timescale-data-2]: multixact "members" limit exceeded
SQL state: 54000
Detail: This command would create a multixact with 15 members, but the remaining space is only enough for 0 members.
Hint: Execute a database-wide VACUUM in database with OID 16384 with reduced vacuum_multixact_freeze_min_age and vacuum_multixact_freeze_table_age settings.
Skills and Experience Needed:
- Strong expertise in SQL database administration
- Experience with managing and maintaining SQL databases
- Knowledge of performance tuning and optimization techniques
- Familiarity with backup and recovery processes
- Ability to troubleshoot and resolve issues related to database tables
The ideal candidate should have a deep understanding of SQL databases and be able to handle all aspects of database administration, including performance tuning and backup. They should also have experience in resolving issues related to database tables.
Current issue
Hi
Db version - 8.0.0
Two errors
1. From db logs hosted in kubernetes env
WARNING: oldest multixact is far in the past
HINT: Close open transactions with multixacts soon to avoid wraparound problems.
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
You might also need to commit or roll back old prepared transactions, or drop stale replication slots.
2 when querying one table or vacuuming this table called features in the db, can query other tables
ERROR: [data-timescale-data-2]: multixact "members" limit exceeded
SQL state: 54000
Detail: This command would create a multixact with 15 members, but the remaining space is only enough for 0 members.
Hint: Execute a database-wide VACUUM in database with OID 16384 with reduced vacuum_multixact_freeze_min_age and vacuum_multixact_freeze_table_age settings.