anywhere else i need to give new db name other than persistence.xml?? On Sun, Jan 25, 2015 at 12:59 PM, Maxim Solodovnik <[email protected]> wrote:
> it is extremely weird > please provide bigger stack trace > > On Sun, Jan 25, 2015 at 1:22 PM, Raju M K <[email protected]> wrote: > >> For me Everything is working fine. >> I got error while backup only. >> anywhere else i need to give new db name other than persistence.xml?? >> >> Regards. >> >> On Sun, Jan 25, 2015 at 12:04 PM, Maxim Solodovnik <[email protected]> >> wrote: >> >>> Just have tested using local installation >>> version: >>> Version3.0.4-SNAPSHOTRevision1654180 >>> everything works as expected >>> >>> On Sun, Jan 25, 2015 at 12:16 PM, Raju M K <[email protected]> wrote: >>> >>>> yes you are right. >>>> >>>> On Sun, Jan 25, 2015 at 11:13 AM, Maxim Solodovnik < >>>> [email protected]> 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 <[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 >>>>> >>>> >>>> >>>> >>>> -- >>>> Regards, >>>> M K Raju. >>>> >>>> >>> >>> >>> -- >>> WBR >>> Maxim aka solomax >>> >> >> >> >> -- >> Regards, >> M K Raju. >> >> > > > -- > WBR > Maxim aka solomax > -- Regards, M K Raju.
