Aggregate error: Problem persisting data or accessing data

We are facing a difficulty.We can't recover the data from one of our vdi drives. Can you provide us with technical assistance? In asseratyiaWe can't recover the data from one of our vdi drives. Can you provide us with technical assistance?

Below is the error message that the Odk Aggregate vm server sends us.

Error: Problem persisting data or accessing data (org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [SELECT "_URI", "_CREATOR_URI_USER", "_CREATION_DATE", "_LAST_UPDATE_URI_USER", "_LAST_UPDATE_DATE", "_MODEL_VERSION", "_UI_VERSION", "_IS_COMPLETE", "_SUBMISSION_DATE", "_MARKED_AS_COMPLETE_DATE", "AUTREQUARTIER", "Q910", "NBNOMCHEF", "Q59A", "Q912", "Q911", "NOTE1", "PRENOM2CHEF", "Q11B", "Q11A", "NOM2CHEF", "NOM2ENQUETEUR", "Q103", "Q58A", "Q12", "HHID", "PR_TOIT", "PR_TRAVAIL_RECOLTE", "NBPRIVATIONSPOND", "PR_EAU", "DISTRICT", "Q21", "PR_ENFANT_TRAV", "RESIDENCE", "PR_TRAVAIL_AGRICOLE", "PROXIES_SCORES", "PRENOM2ENQUETEUR", "Q143", "Q61IC", "Q61ID", "Q61IB", "Q33", "Q35", "Q34", "Q37", "Q36", "Q710", "PR_SOL", "PRENOM1CHEF", "CGPS_ACC", "PROXY6", "PROXY7", "PROXY8", "PROXY9", "SCORE1", "PROXY2", "TAILLEDEUX", "PROXY3", "PR_ANALPHABETE", "PROXY4", "PROXY5", "PROXY11", "PROXY12", "Q39B", "DEPARTEMENT", "Q39A", "PROXY1", "PROXY10", "PROXY15", "PR_ANIMAUX", "PROXY16", "PROXY13", "PROXY14", "PRIVATIONS", "PROXY17", "PROXY18", "Q144", "Q51", "EN_HEURE_ECOLE", "NOM3CHEF", "END", "Q610", "EN_MINUTE_CSI", "SCORE", "Q62", "Q64", "Q63", "META_INSTANCE_ID", "TEL_RECENSEUR", "Q61A", "Q66", "Q65", "Q61C", "Q68", "Q61B", "Q67", "Q69", "RUE_AVENUE_REPERE", "Q61H", "Q61K", "Q61J", "Q61E", "Q61D", "Q61G", "PR_MUR", "Q61F", "PR_DIFFICULTE_NOURRIR", "PERSON_DETAILS_COUNT", "PR_TOILETTE", "Q71", "Q73", "Q72", "Q75", "Q74", "NOM3ENQUETEUR", "Q77", "QUARTIER", "Q76", "Q78", "PR_PRIMAIRE", "START", "NBRECHEF", "PR_CUISINE", "Q510", "Q142B", "SCORE43", "PROXY51", "SCORE42", "PROXY52", "Q82", "SCORE45", "Q81", "SCORE44", "SCORE47", "PROXY55", "Q83", "SCORE46", "SCORE49", "PROXY53", "Q142A", "SCORE48", "PROXY54", "Q511A", "Q99B", "BG_LOGO_LOGO", "Q99A", "SCORE41", "SCORE40", "TOKEN", "BG_NBMEMBRES_Q310", "SCORE39", "ESCORE", "Q61L", "CGPS_LNG", "Q91", "Q143C", "SCORE32", "PROXY40", "SCORE31", "PROXY41", "Q93", "SCORE34", "Q92", "SCORE33", "Q95", "SCORE36", "PROXY44", "SCORE35", "PROXY45", "SCORE38", "PROXY42", "Q96", "Q143B", "SCORE37", "PROXY43", "PR_CSI", "NBPRENOMENQUETEUR", "PROXY48", "PR_TRAVAIL_BETAIL", "Q98", "PROXY49", "Q512A", "PROXY46", "DEVICEID", "PROXY47", "PRENOM1ENQUETEUR", "DUREE_MINUTE_CSI", "SCORE29", "SCORE28", "SCORE21", "SCORE20", "SCORE23", "SCORE22", "SCORE25", "PROXY33", "SCORE24", "PROXY34", "SCORE27", "PROXY31", "SCORE26", "PROXY32", "PROXY37", "SIMSERIAL", "PROXY38", "PROXY35", "PROXY36", "PROXY39", "Q53A", "PR_BIENS", "SCORE18", "SCORE17", "SCORE10", "SCORE12", "SCORE11", "SCORE14", "PROXY22", "SCORE13", "PROXY23", "SCORE16", "PROXY20", "SCORE15", "PROXY21", "SCORE9", "PROXY26", "SCORE8", "PROXY27", "SCORE7", "PROXY24", "SCORE6", "PROXY25", "PIN", "SCORE5", "SCORE4", "Q52A", "SCORE3", "PROXY28", "SCORE2", "PROXY29", "BLOC", "Q82_RAW", "ZONE", "NOM1CHEF", "Q55A", "Q72_RAW", "END_RAW", "EN_MINUTE_ECOLE", "PR_TRAVAIL_SINISTRE", "CHOIXAUTREQUARTIER", "NBNOMENQUETEUR", "CONCLUSION", "SCORE_IPM", "CIBLAGE_IPM", "CGPS_LAT", "PR_ECLAIRAGE", "NBPRENOMCHEF", "Q54A", "NOTE_HHID", "EN_HEURE_CSI", "CIBLAGE_PMT", "PRENOM3CHEF", "CGPS_ALT", "NOM1ENQUETEUR", "PHONENUMBER", "START_RAW", "Q57A", "CONSTANTE", "BG_NBMEMBRES_REPEATMEMBRE", "DUREE_MINUTE_ECOLE", "TODAY", "Q141A", "SCORE54", "Q141B", "SCORE53", "Q56A", "SCORE55", "PRENOM3ENQUETEUR", "SCORE52", "SCORE51", "PR_ENFANTS614_DESCOLARISES", "TODAY_RAW", "PR_MALADIEC" FROM "aggregate"."PROJET46FINALE_CORE" WHERE "_MARKED_AS_COMPLETE_DATE" > ? AND "_IS_COMPLETE" = ? ORDER BY "_MARKED_AS_COMPLETE_DATE" ASC , "_URI" ASC ;]; ERROR: could not write block 3021 of temporary file: No space left on device; nested exception is org.postgresql.util.PSQLException: ERROR: could not write block 3021 of temporary file: No space left on device)

Thank's for your help.

It seems that the hard drive or partition where is located the database is full :

So you should try to free some space on the device.

1 Like

Thank you very much for your answer. You're going to try this. Thank you again.

Dear Mathieu. Thank you for your advice. The data have been recovered after the machine doping.

2 Likes