yes you are right. On Sun, Jan 25, 2015 at 11:13 AM, Maxim Solodovnik <solomax...@gmail.com> wrote:
> 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 <mkraju...@gmail.com> 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 <zurca...@gmail.com> 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" <mkraju...@gmail.com> wrote: >>> > trying to backup on version only 3.0.4 >>> > >>> > >>> > >>> > On Sat, Jan 24, 2015 at 6:34 PM, Maxim Solodovnik >>> > <solomax...@gmail.com> 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" >>> > <mkraju...@gmail.com> 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 <solomax...@gmail.com> 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" >>> > <mkraju...@gmail.com> wrote: >>> > i created new db in mysql and >>> > running OM >>> > >>> > >>> > On Sat, Jan 24, 2015 at 5:29 >>> > PM, Maxim Solodovnik >>> > <solomax...@gmail.com> 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" >>> > <mkraju...@gmail.com> >>> > 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 > -- Regards, M K Raju.