db upgrade 1.1.4

Started by lindeamon, September 11, 2011, 07:31:03 PM

Previous topic - Next topic

Victor Kirhenshtein

MySQL driver patch for 1.1.4. Just replace existing mysql.ddr with attached one.

Best regards,
Victor

lindeamon

thank you victor.

there is something not clear to me yet.how can i do a replace if the installation is a new one ?
do i have to do an installation without configuring the server,replace the driver and then do the server configuration part ?

10x,
lindeamon

lindeamon

sorry victor,

i have remmebered why we needed the patch.to replace the old one after the db upgrade.
just ignore my former post.

thank you,
lindeamon

lindeamon

hi victor,

i have installed version 1.1.3 and let it work for a day or two and it worked ok.i have uninstalled it and installed version 1.1.4.
i have gone through all the steps of the setup and when the server configuration wizard came up i have replaced the mysql.ddr file with the one you gave me in this post and finished the wizard and nothing works.
i have tried to upgrade the db through command line and it says the db version is the latest.
i invoked the netxmsd in command line with debug 9 and it said it had connected to the database but failed with this message "error initializing component locks table"

best regards,
lindeamon

lindeamon

i forgot to say that i did not initialized the databse.

Victor Kirhenshtein

Could you please try this driver?

Best regards,
Victor

lindeamon

ok

i will give it a try and tell you if it worked.

lindeamon

hi victor,

to cut the story short i did everything as i mentioned in the last time and everything went fine but service did not came up.running the service from command line told that my db has a version of 232 and the server is compiled for version 240.
i did an upgrade and it failed and the error message said :" sql query failed (table 'business_services' already exists): " and then it writes the sql command: "create table business_services........" and all of it's data.

Best Regards,
Lindeamon

lindeamon

hi victor,

i have tried to delete the table mentioned in the former post and failed with other tables like node_links.
fyi

lindeamon

Victor Kirhenshtein

Hi!

Looks like database was messed up during all these upgrades. Can you please run

nxdbmgr upgrade -X

(it will ignore errors), and then try to run server. Also, if possible, export and send to me database schema - I'll check it for correctness.

Best regards,
Victor

lindeamon

ok victor,

it worked.
what version of the sql.ddr patches do i have to save for now ? the latest one ?

Best Regards,
Lindeamon

lindeamon

regarding the schema,is there any quick way to export it without any records ? if it is not possible then i will not be able to send it to you.
but there is something the makes me wonder,after each installation i tried with the different patches you gave me i have restored the databse to the one that worked with v1.1.3 so why would it give me errors ?
maybe i will try to make a clean install and check it.

10x,
lindeamon

lindeamon

hi victor,

i found a way to export with no data.here is the v1.1.4 schema

Victor Kirhenshtein

Quote from: lindeamon on September 14, 2011, 04:41:43 PM
what version of the sql.ddr patches do i have to save for now ? the latest one ?

Yes.

Best regards,
Victor