OK, let's try to figure out what is happening: 1) you have created new DB 2) start 3.0.4 (*what build? what revision? *try top menu-> About) 3) install OM 4) work in it 5) open Admin->Backup 6) try to backup Result: error
is this correct? On Sun, Jan 25, 2015 at 10:55 AM, Raju M K <[email protected]> wrote: > Dear Alvaro, > i left old db aside and created new db. > But i replaced in persistence.xml with new db name and password. > still will it be any relation with old db?? > > > On Sun, Jan 25, 2015 at 12:03 AM, Alvaro <[email protected]> wrote: > >> ..."left old db not deleted"...maybe Raju build a new database on the >> old database? >> >> >> .............. >> >> >> El sáb, 24-01-2015 a las 21:43 +0700, Maxim Solodovnik escribió: >> > Still not clear :( >> > >> > You are trying to backup? restore? On the 3.0.4 what revision? If >> > restore from what revision? >> > >> > WBR, Maxim >> > (from mobile, sorry for the typos) >> > >> > On Jan 24, 2015 7:34 PM, "Raju M K" <[email protected]> wrote: >> > trying to backup on version only 3.0.4 >> > >> > >> > >> > On Sat, Jan 24, 2015 at 6:34 PM, Maxim Solodovnik >> > <[email protected]> wrote: >> > System backup of old version? Or the new one? >> > What are exact versions/revisions? >> > >> > WBR, Maxim >> > (from mobile, sorry for the typos) >> > >> > On Jan 24, 2015 6:51 PM, "Raju M K" >> > <[email protected]> wrote: >> > as you advice earlier, i created new db and >> > installed OM 3.0.4 snapshot. >> > >> > left old db not deleted >> > >> > Now iam trying to do system backup from gui >> > then i got this error >> > >> > >> > On Sat, Jan 24, 2015 at 5:34 PM, Maxim >> > Solodovnik <[email protected]> wrote: >> > Could you please provide detailed >> > steps of what are you doing? >> > >> > WBR, Maxim >> > (from mobile, sorry for the typos) >> > >> > On Jan 24, 2015 6:03 PM, "Raju M K" >> > <[email protected]> wrote: >> > i created new db in mysql and >> > running OM >> > >> > >> > On Sat, Jan 24, 2015 at 5:29 >> > PM, Maxim Solodovnik >> > <[email protected]> wrote: >> > Which of your db are >> > you trying to backup? >> > >> > WBR, Maxim >> > (from mobile, sorry >> > for the typos) >> > >> > On Jan 24, 2015 5:58 >> > PM, "Raju M K" >> > <[email protected]> >> > wrote: >> > got error >> > while system >> > backup(Using >> > OM >> > Version >> > 3.0.4-SNAPSHOT >> > >> > * >> <openjpa-2.3.0-r422266:1540826 fatal general error> >> org.apache.openjpa.persistence.PersistenceException: Got error 28 from >> storage engine {prepstmnt 838366117 SELECT t0.id, t1.id, t1.deleted, >> t2.id, t2.deleted, t2.insertedby, t2.name, t2.starttime, t2.updatedby, >> t2.updatetime, t3.id, t3.allow_font_styles, t3.allow_recording, >> t3.allow_user_questions, t3.appointment, t3.auto_video_select, >> t3.chat_moderated, t3.chat_opened, t3.comment_field, t3.confno, t3.deleted, >> t3.demo_time, t3.externalRoomId, t3.externalRoomType, t3.files_opened, >> t3.hide_actions_menu, t3.hide_activities_and_actions, t3.hide_chat, >> t3.hide_files_explorer, t3.hide_screen_sharing, t3.hide_top_bar, >> t3.hide_whiteboard, t3.is_audio_only, t3.is_closed, t3.isdemoroom, >> t3.ismoderatedroom, t3.ispublic, t3.name, t3.numberOfPartizipants, >> t3.owner_id, t3.pin, t3.redirect_url, t3.roomtypes_id, >> t3.show_microphone_status, t3.sip_enabled, t3.starttime, t3.updatetime, >> t3.wait_for_recording, t1.starttime, t1.updatetime FROM room t0 INNER JOIN >> rooms_organisation t1 ON t0.id = t1.rooms_id LEFT OUTER JOIN >> organisation t2 ON t1.organisation_id = t2.id LEFT OUTER JOIN room t3 ON >> t1.rooms_id = t3.id ORDER BY t0.id ASC} [code=1030, state=HY000] >> FailedObject: SELECT r FROM Room r ORDER BY r.rooms_id [java.lang.String] >> > >> > >> > -- >> > Regards, >> > M K Raju. >> > >> > >> > >> > >> > >> > -- >> > Regards, >> > M K Raju. >> > >> > >> > >> > >> > >> > -- >> > Regards, >> > M K Raju. >> > >> > >> > >> > >> > >> > -- >> > Regards, >> > M K Raju. >> > >> > >> >> >> > > > -- > Regards, > M K Raju. > > -- WBR Maxim aka solomax
