Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Loading…

crashed or error occurred when creating or modifying table-table relationship or dealing with foreign keys #24

Closed
mingshun opened this Issue · 14 comments

2 participants

@mingshun

Under ubuntu 32bits, I came into crash several times when creating or modifying table-table relationship. Sometimes it prompted error message. But it is in Portuguese, and I didn't know what happened. Sometimes it crashed. And I couldn't reopen the project file which I edited the last time.

I create foreign keys by adding a constraint of a column. But
it didn't shown in the graph. By creating table-table relationship, the column name could not be modified. I didn't like the name generated by pgmodeler. Most of the time when I was dealing with foreign keys or relationships, it crashed.

@rkhaotix
Owner

Can you please post the Portuguese message!? The name suffix of generated columns can be changed on relationship editing form. About user added fks they aren't shown on model, this because pgModeler handles fks via relationships. If possible, you cat attach the model file you've editing?

@mingshun

I am busy working with a data model of a new app by another modeler these days. I tried several times, and couldn't reproduce the same message. I will retry after my current work done. By the way, I do dislike the prefix of generated column name of the relationship. I think the whole name being changeable should be better. Others may need this function.

@rkhaotix
Owner

Ok! I understand and thank you by the opinion. I'll study a way to override the generated column names. Thanks.

@mingshun

When dealing with relationships, pgmodeler sometimes crashes. Sometimes it stops responding. I must kill it with task manager. Sometimes it crashes when closing model. I think you can add a log to determine where the bugs are. So I can debug myself and help to fix it.
I hope modeler will be better and better. There are few database modeler for postgres. And I think pgmodeler will the popular one and I don't want to use the modelers for other database to create models for postgres.
Thanks for your work! :)

@rkhaotix
Owner

@mingshun Thanks for the incentive. I want people think that pgModeler is useful for their work as it is to my work!

The project is in an initial stage this explains the crashes but I'm correcting as many as possible bugs that is reported! I have the clear idea that much code maturation has to be applied. At the moment I count only with myself to fix the code but in a near future (I hope!) the code will be completely refactored to english so people may help with code fixes!

It is comment like yours that can improve more and more a software! Thank you again.

@rkhaotix
Owner

I've reproduced the crash! It seems to occurs when editing relationships or deleting it! Now I know where to work on! ^^)

@rkhaotix
Owner

@mingshun, apparently I made a resolution to the several segmentation fault when dealing with relationships. I've tested for hours and the software did'nt crashed! If you have a spare time, please make your tests to see if the patch respond well on your pgModeler copy. Thanks!

@mingshun

When creating relationship, it appears the below error message:

Unknown attribute 'constraint' in file /home/mingshun/dev/pgmodeler/build/schemas/sql/common/relationship.sch, line 14, column 15!

Is it my misoperation?
Sometimes the [New Object] menu from the left down button or the right-click menu is not visible when the button pushed down or the right button of mouse pressed. I can misclick the item of the menu to create something.

@rkhaotix
Owner
@mingshun

right click -> [New object] -> [Table-Table Relationship] -> [Relationship 1-n] -> click one table -> click another table -> [Apply], then the above error occurred.

If I drop pgmodeler for a while to do other things, then I come back to it. The right menu or the left-down button menu cannot be seen when right clicked or the left-down button pressed.

By the way, there is another message shown when startup modeler: Unable to load one or more configuration files! Please check if files exists in the configuration folder and if they are not corrupted to preventing this error to occur again on the next startup!

@rkhaotix
Owner

Hello @mingshun!

right click -> [New object] -> [Table-Table Relationship] -> [Relationship 1-n] -> click one table -> click another table -> [Apply], then the above error occurred.

I've tested for several times and no error raised! Are you changed by accident any of the .sch files in the folder "schemas"?

If I drop pgmodeler for a while to do other things, then I come back to it. The right menu or the left-down button menu cannot be seen when right clicked or the left-down button pressed.

I've detected one little bug at the menu with actions related to the model. The action "New object" now triggers the menu popup correctly when is pressed.

By the way, there is another message shown when startup modeler: Unable to load one or more configuration files! Please check if files exists in the configuration folder and if they are not corrupted to preventing this error to occur again on the next startup!

Not detected! Have you changed the default search paths on pgModeler startup script? Or even on you system environment variables?

By the way, thanks for the great help on testing pgModeler! ;)

@rkhaotix rkhaotix closed this
@mingshun

right click -> [New object] -> [Table-Table Relationship] -> [Relationship 1-n] -> click one table -> click another table -> [Apply], then the above error occurred.

I've tested for several times and no error raised! Are you changed by accident any of the .sch files in the folder "schemas"?

I'v compared the file with the your repository, and couldn't find difference. But I realize that 'pgmodeler / schemas / sql / common / relationship.sch' is different from 'pgmodeler / build / schemas / sql / common / relationship.sch'. I copy the former one to the latter location, and there is no error.

By the way, there is another message shown when startup modeler: Unable to load one or more configuration files! Please check if files exists in the configuration folder and if they are not corrupted to preventing this error to occur again on the next startup!

Not detected! Have you changed the default search paths on pgModeler startup script? Or even on you system environment variables?

After doing the last operation, I didn't come across this when startup. If I replace the file with the older one, the same error occurs.

Maybe the different version files of 'pgmodeler' and 'pgmodeler/build' caused the above problems.

@rkhaotix
Owner

Checking the repo again I've commited by mistake the files of build/ folder! Thanks for the advice. Tomorrow I'll cleanup the build directory to prevent situations like that again!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.