db upgrade 1.1.4

[lindeamon]

you are right.i have changed the service config and i got the messages i wrote in my last post

i hope you have the answer to the problem.

[victor]

I have replicated this issue on my system. Looks like a bug in MySQL driver. I'll post a patch when I fix it.

Best regards,
Victor

[lindeamon]

so what you are saying is that will not be able to use this new vesrion ?
bummer
ok, i will wait for the patch.
b.t.w - i have restored everything to version 1.1.3 and everything is working fine again.

[victor]

Yes, unfortunately there is a bug in MySQL driver in 1.1.4. I'll try to made a patch tomorrow. Other DB engines should work fine. I do most of the development using Oracle and PostgreSQL, and at some point forgot to make necessary tests at MySQL.

Best regards,
Victor

[Jmp_3f8h]

Hi Victor,

I'm getting this error upgrading to version 1.1.4 (from 1.1.3):

C:\Program Files\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 1.1.4

Upgrading database...
Upgrading from version 236 to 237
SQL query failed ([Microsoft][SQL Native Client][SQL Server]The object 'DF__business___paren__09746778' is dependent on column 'parent_id'.):
ALTER TABLE business_services DROP COLUMN parent_id
Rolling back last stage due to upgrade errors...
Database upgrade failed

Now I rolled back to version 1.1.3, any hints?

Another question: where can I find the mobile client for Android?

Thank you very much for your support.

Marco.

[victor]

Hi!

Same problem as here: https://www.netxms.org/forum/installation/1-1-4-database-upgrade-error/. In short, try to run manually

ALTER TABLE business_services DROP CONSTRAINT DF__business___paren__09746778;

Best regards,
Victor

[victor]

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

Best regards,
Victor

---

mysql.ddr

[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]

Could you please try this driver?

Best regards,
Victor

---

mysql.ddr

[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]

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

---

netxms_db_export_v1.1.4_no_data.sql

[victor]

@lindeamon said in db upgrade 1.1.4:

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

Yes.

Best regards,
Victor